Thank you Tom for the suggestion and the workaround.
I think we will be able to hold off on the temporary workaround.
Would the 2nd processes in the deadlock show up in pg_locks? (It didn't)
An insert from another table that i created to test the datafile did show up
as blocked.
I got
In addition here is a backtrace of the process while it hung again today:
(thanks to our SA Eric)
#0 0x00396c8d4627 in semop () from /lib64/libc.so.6
#1 0x005dc313 in PGSemaphoreLock ()
#2 0x00616586 in LWLockAcquire ()
#3 0x004a718c in
Hi,
I'm relatively new to Pg.
Question:
What could have happened to cause the COPY to unlogged table to hang?
And what would the recreate of the unlogged table have released that a
reboot of the cluster did not.
Any other place that I could've looked or done something else other than
recreating