Re: "stuck spinlock"
От | Christophe Pettus |
---|---|
Тема | Re: "stuck spinlock" |
Дата | |
Msg-id | B0D8F32B-3564-4519-9882-0BAB0ACD28B9@thebuild.com обсуждение исходный текст |
Ответ на | Re: "stuck spinlock" (Andres Freund <andres@2ndquadrant.com>) |
Список | pgsql-hackers |
On Dec 12, 2013, at 4:23 PM, Andres Freund <andres@2ndquadrant.com> wrote: > Could you install the -dbg package and regenerate? Of course! #0 0x00007f699a4fa425 in raise () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x00007f699a4fdb8b in abort () from /lib/x86_64-linux-gnu/libc.so.6 #2 0x00007f699c81991b in errfinish (dummy=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/utils/error/elog.c:542 #3 0x00007f699c81a477 in elog_finish (elevel=<optimized out>, fmt=0x7f699c937a48 "stuck spinlock (%p) detected at %s:%d") at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/utils/error/elog.c:1297 #4 0x00007f699c735db3 in s_lock_stuck (line=1099, file=0x7f699c934a78 "/tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/buffer/bufmgr.c",lock=0x7f6585e2cbb4 "\001") at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/lmgr/s_lock.c:40 #5 s_lock (lock=0x7f6585e2cbb4 "\001", file=0x7f699c934a78 "/tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/buffer/bufmgr.c",line=1099) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/lmgr/s_lock.c:109 #6 0x00007f699c71e1f0 in PinBuffer (buf=0x7f6585e2cb94, strategy=0x0) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/buffer/bufmgr.c:1099 #7 0x00007f699c71eaf9 in BufferAlloc (foundPtr=0x7fff60ec563e "", strategy=0x0, blockNum=1730, forkNum=MAIN_FORKNUM,relpersistence=112 'p', smgr=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/buffer/bufmgr.c:776 #8 ReadBuffer_common (smgr=<optimized out>, relpersistence=112 'p', forkNum=MAIN_FORKNUM, blockNum=1730, mode=RBM_NORMAL,strategy=0x0, hit=0x7fff60ec56af "") at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/buffer/bufmgr.c:333 #9 0x00007f699c71f53e in ReadBufferExtended (reln=0x7f6577d80560, forkNum=MAIN_FORKNUM, blockNum=1730, mode=<optimizedout>, strategy=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/storage/buffer/bufmgr.c:252 #10 0x00007f699c56d03a in index_fetch_heap (scan=0x7f699f94c7a0) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/access/index/indexam.c:515 #11 0x00007f699c67a0b7 in IndexOnlyNext (node=0x7f699f94b690) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/nodeIndexonlyscan.c:109 #12 0x00007f699c66e98e in ExecScanFetch ( recheckMtd=0x7f699c679fb0 <IndexOnlyRecheck>, accessMtd=0x7f699c679fe0 <IndexOnlyNext>,node=0x7f699f94b690) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/execScan.c---Type<return> to continue, or q <return> to quit--- :82 #13 ExecScan (node=0x7f699f94b690, accessMtd=0x7f699c679fe0 <IndexOnlyNext>, recheckMtd=0x7f699c679fb0 <IndexOnlyRecheck>) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/execScan.c:167 #14 0x00007f699c6679a8 in ExecProcNode (node=0x7f699f94b690) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/execProcnode.c:408 #15 0x00007f699c67407f in agg_retrieve_direct (aggstate=0x7f699f94af90) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/nodeAgg.c:1121 #16 ExecAgg (node=0x7f699f94af90) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/nodeAgg.c:1013 #17 0x00007f699c6678b8 in ExecProcNode (node=0x7f699f94af90) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/execProcnode.c:476 #18 0x00007f699c664dd2 in ExecutePlan (dest=0x7f699f98c308, direction=<optimized out>, numberTuples=0, sendTuples=1 '\001', operation=CMD_SELECT, planstate=0x7f699f94af90, estate=0x7f699f94ae80) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/execMain.c:1472 #19 standard_ExecutorRun (queryDesc=0x7f699f940dc0, direction=<optimized out>, count=0) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/executor/execMain.c:307 #20 0x00007f6996ad928d in explain_ExecutorRun (queryDesc=0x7f699f940dc0, direction=ForwardScanDirection, count=0) at/tmp/buildd/postgresql-9.3-9.3.2/build/../contrib/auto_explain/auto_explain.c:233 #21 0x00007f69968d3525 in pgss_ExecutorRun (queryDesc=0x7f699f940dc0, direction=ForwardScanDirection, count=0) at /tmp/buildd/postgresql-9.3-9.3.2/build/../contrib/pg_stat_statements/pg_stat_statements.c:717 #22 0x00007f699c745207 in PortalRunSelect (portal=0x7f699de596a0, forward=<optimized out>, count=0, dest=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/tcop/pquery.c:946 #23 0x00007f699c746651 in PortalRun (portal=0x7f699de596a0, count=9223372036854775807, isTopLevel=1 '\001', dest=0x7f699f98c308, altdest=0x7f699f98c308, completionTag=0x7fff60ec5f30 "") at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/tcop/pquery.c:790 #24 0x00007f699c742960 in exec_simple_query ( query_string=0x7f699dd564a0 "SELECT COUNT(*) FROM \"signups\" WHERE (signups.is_supporter= true)") at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/tcop/postgres.c:1048 #25 PostgresMain (argc=<optimized out>, argv=<optimized out>, ---Type <return> to continue, or q <return> to quit--- dbname=0x7f699dd3e138 "nbuild", username=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/tcop/postgres.c:4005 #26 0x00007f699c6ff765 in BackendRun (port=0x7f699dd82050) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/postmaster/postmaster.c:3999 #27 BackendStartup (port=0x7f699dd82050) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/postmaster/postmaster.c:3688 #28 ServerLoop () at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/postmaster/postmaster.c:1589 #29 PostmasterMain (argc=<optimized out>, argv=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/postmaster/postmaster.c:1258 #30 0x00007f699c53bea2 in main (argc=5, argv=0x7f699dd3c1a0) at /tmp/buildd/postgresql-9.3-9.3.2/build/../src/backend/main/main.c:196 -- -- Christophe Pettus xof@thebuild.com
В списке pgsql-hackers по дате отправления: