[Postgres-xl-developers] error logs related to hung query metacommads on 9.2 pgxl

Durgamahesh Manne maheshpostgres9 at gmail.com
Tue Mar 15 11:28:39 PDT 2016


hi
this is regarding errors related to  hung metacommand & query

 Coordinator log error info

DEBUG:  00000: Autovacuum worker: connection established to GTM with string
host=node2 port=20001 node_name=coord2
LOCATION:  InitGTM, gtm.c:94
DEBUG:  00000: Assigned new transaction ID from GTM = 9822
LOCATION:  GetNewTransactionId, varsup.c:179
DEBUG:  00000: Getting snapshot for autovacuum. Current XID = 9822
LOCATION:  GetSnapshotDataDataNode, procarray.c:2824
DEBUG:  00000: for autovacuum from GTM: xmin = 9822, xmax = 9822, xcnt = 0,
RecGlobXmin = 9822
LOCATION:  GetSnapshotDataDataNode, procarray.c:2855
DEBUG:  00000: Record transaction commit 9822
LOCATION:  TransactionIdSetTreeStatus, clog.c:166
DEBUG:  00000: Autovacuum worker: connection to GTM closed
LOCATION:  CloseGTM, gtm.c:131
DEBUG:  00000: [re]setting xid = 0, old_value = 0
LOCATION:  SetNextTransactionId, varsup.c:55
DEBUG:  00000: autovacuum: processing database "postgres"
LOCATION:  AutoVacWorkerMain, autovacuum.c:1647
DEBUG:  00000: Done pgxc_nodes scan: 2 coordinators and 2 datanodes
LOCATION:  PgxcNodeListAndCount, nodemgr.c:359
DEBUG:  00000: Get OIDs from table: 2 coordinators and 2 datanodes
LOCATION:  PgxcNodeGetOids, nodemgr.c:387
DEBUG:  00000: [re]setting xid = 0, old_value = 0
LOCATION:  SetNextTransactionId, varsup.c:55
DEBUG:  00000: Pool maintenance, done in 0.000000 seconds, removed 0 pools
LOCATION:  pools_maintenance, poolmgr.c:3142
DEBUG:  00000: Pool maintenance, done in 0.000000 seconds, removed 0 pools
LOCATION:  pools_maintenance, poolmgr.c:3142
DEBUG:  00000: Autovacuum launcher: connection established to GTM with
string host=node2 port=20001 node_name=coord2
LOCATION:  InitGTM, gtm.c:96
DEBUG:  00000: Assigned new transaction ID from GTM = 9829
LOCATION:  GetNewTransactionId, varsup.c:179
DEBUG:  00000: Getting snapshot for autovacuum. Current XID = 9829
LOCATION:  GetSnapshotDataDataNode, procarray.c:2824
DEBUG:  00000: for autovacuum from GTM: xmin = 9829, xmax = 9829, xcnt = 0,
RecGlobXmin = 9829
LOCATION:  GetSnapshotDataDataNode, procarray.c:2855
DEBUG:  00000: Record transaction commit 9829
LOCATION:  TransactionIdSetTreeStatus, clog.c:166
DEBUG:  00000: Autovacuum launcher: connection to GTM closed
LOCATION:  CloseGTM, gtm.c:133
DEBUG:  00000: [re]setting xid = 0, old_value = 0
LOCATION:  SetNextTransactionId, varsup.c:55
DEBUG:  00000: Autovacuum worker: connection established to GTM with string
host=node2 port=20001 node_name=coord2
LOCATION:  InitGTM, gtm.c:94
DEBUG:  00000: Assigned new transaction ID from GTM = 9830
LOCATION:  GetNewTransactionId, varsup.c:179
DEBUG:  00000: Getting snapshot for autovacuum. Current XID = 9830
LOCATION:  GetSnapshotDataDataNode, procarray.c:2824
DEBUG:  00000: for autovacuum from GTM: xmin = 9830, xmax = 9830, xcnt = 0,
RecGlobXmin = 9830
LOCATION:  GetSnapshotDataDataNode, procarray.c:2855
DEBUG:  00000: Record transaction commit 9830
LOCATION:  TransactionIdSetTreeStatus, clog.c:166
DEBUG:  00000: Autovacuum worker: connection to GTM closed
LOCATION:  CloseGTM, gtm.c:131
DEBUG:  00000: [re]setting xid = 0, old_value = 0
LOCATION:  SetNextTransactionId, varsup.c:55
DEBUG:  00000: autovacuum: processing database "postgres"
LOCATION:  AutoVacWorkerMain, autovacuum.c:1647
DEBUG:  00000: Done pgxc_nodes scan: 2 coordinators and 2 datanodes
LOCATION:  PgxcNodeListAndCount, nodemgr.c:359
DEBUG:  00000: Get OIDs from table: 2 coordinators and 2 datanodes
LOCATION:  PgxcNodeGetOids, nodemgr.c:387
DEBUG:  00000: [re]setting xid = 0, old_value = 0
LOCATION:  SetNextTransactionId, varsup.c:55
DEBUG:  00000: Pool maintenance, done in 0.000000 seconds, removed 0 pools
LOCATION:  pools_maintenance, poolmgr.c:3142
DEBUG:  00000: Pool maintenance, done in 0.000000 seconds, removed 0 pools
LOCATION:  pools_maintenance, poolmgr.c:3142
pg3-tf pg_log #
pg3-tf pg_log #



datanode log info:


LOG:  00000: database system was shut down at 2016-03-15 21:14:14 IST
LOCATION:  StartupXLOG, xlog.c:6327
LOG:  00000: database system is ready to accept connections
LOCATION:  reaper, postmaster.c:2619
LOG:  00000: autovacuum launcher started
LOCATION:  AutoVacLauncherMain, autovacuum.c:416



regards
mahesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20160315/d7079a02/attachment.htm>


More information about the Postgres-xl-developers mailing list