Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T7VqN-0000fi-QR for pgsql-admin@postgresql.org; Fri, 31 Aug 2012 18:21:23 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T7VqM-0007DX-9k for pgsql-admin@postgresql.org; Fri, 31 Aug 2012 18:21:23 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1T7VqL-00082a-Ql for pgsql-admin@postgresql.org; Fri, 31 Aug 2012 11:21:21 -0700 Date: Fri, 31 Aug 2012 11:21:21 -0700 (PDT) From: amacvar To: pgsql-admin@postgresql.org Message-ID: <1346437281821-5722162.post@n5.nabble.com> In-Reply-To: <1346354162985-5721983.post@n5.nabble.com> References: <1346354162985-5721983.post@n5.nabble.com> Subject: Re: What else could I've done? COPY to unlogged tbl "hung"/locked the table MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.9 (/) X-Archive-Number: 201208/119 X-Sequence-Number: 39940 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-the-table-tp5721983p5722162.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.