From: amacvar <kahitarich-postgresForum@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: What else could I've done? COPY to unlogged tbl "hung"/locked the table
Date: Fri, 31 Aug 2012 11:21:21 -0700 (PDT)
Message-ID: <1346437281821-5722162.post@n5.nabble.com> (raw)
In-Reply-To: <1346354162985-5721983.post@n5.nabble.com>
References: <1346354162985-5721983.post@n5.nabble.com>
In addition here is a backtrace of the process while it hung again today:
(thanks to our SA Eric)
#0 0x000000396c8d4627 in semop () from /lib64/libc.so.6
#1 0x00000000005dc313 in PGSemaphoreLock ()
#2 0x0000000000616586 in LWLockAcquire ()
#3 0x00000000004a718c in ginHeapTupleFastInsert ()
#4 0x000000000049c808 in gininsert ()
#5 0x00000000006dd968 in FunctionCall6Coll ()
#6 0x0000000000474b07 in index_insert ()
#7 0x00000000005664c8 in ExecInsertIndexTuples ()
#8 0x0000000000511fa2 in DoCopy ()
#9 0x0000000000626f71 in standard_ProcessUtility ()
#10 0x0000000000624299 in PostgresMain ()
#11 0x0000000000625309 in CreateQueryDesc ()
#12 0x0000000000625d35 in PortalRun ()
#13 0x0000000000623262 in PostgresMain ()
#14 0x00000000005e7ae4 in ClosePostmasterPorts ()
#15 0x00000000005e8861 in PostmasterMain ()
#16 0x000000000058c5be in main ()
--
View this message in context: http://postgresql.1045698.n5.nabble.com/What-else-could-I-ve-done-COPY-to-unlogged-tbl-hung-locked-t...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kahitarich-postgresForum@yahoo.com
Subject: Re: What else could I've done? COPY to unlogged tbl "hung"/locked the table
In-Reply-To: <1346437281821-5722162.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox