This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
We Azure postgresql database build. on that we have a ADF process that is doing truncate and load from source schema to prod schema every morning. Teams are querying to prod schema continuously to pull data which causes deadlock on table. then adf load from source to prod fails. How can we refresh table in prod without getting rid of deadlock?
I am looking to take care of deadlocks in the back end when they happen and also remove them if exists before adf pipeline runs to load data.
Hi Grover, Jyoti,
Just checking if below answers help. If yes, please consider hitting Accept Answer button. Accepted answers help community as well. Please let me know if any further queries. Thank you.
truncate and load from source schema to prod schema
If you do a full load to an empty table, then the complete table gets locked; that's quite normal.
In PostgreSQL you can set the transaction isolation to "READ UNCOMMITED" to read the "new" data anyway, see https://www.postgresql.org/docs/8.4/transaction-iso.html
Hi Grover, Jyoti, Just checking if above answer helps. If yes, please consider hitting Accept Answer. Accepted answers help community as well. Please let me know if any further queries. Thank you.
that makes sense. but deadlock. isnt deadlock self removed if happens?
After read completes from teams deadlocks usually get self removed.
Hope this helps.
Please consider hitting Accept Answer button. Accepted answers help community as well.
Grover, Jyoti,
Just checking if above answer helps. If yes, please consider hitting Accept Answer button. Accepted answers help community as well. Please let me know if any further queries. Thank you.
Hello...I need help to figure out why my one table fails to load data after I run a query that runs for a while but outputs a .csv file. but systems show an idle process hanging out there. when we remove that idle process, we are able to load data. Why system does not automatically disconnect with all processes at the time of load.
to add to above information: ADF error: Azure Data Factory Error - Failure happened on 'Sink' side. 'Type=Npgsql.NpgsqlException,Message=Exception while reading from stream,Source=Npgsql,''Type=System.IO.IOException,Message=Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.,Source=System,''Type=System.Net.Sockets.SocketException,Message=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond,Source=System,'
How we solved it? we deleted following processes. then load was able to run.
on database:
Is this table in different schema or database? Are we have proper network settings and firewall settings enabled for this table. Because from the error message, it seems failed to establish the connection.
What you mean when you same removed ideal process? Kindly elaborate more. thank you.
Hi Grover, Jyoti, Just checking if above answer helps. If yes, please consider hitting Accept Answer. Accepted answers help community as well. Please let me know if any further queries. Thank you.