Vertica Node crashed - help :(

Moderator: NorbertKrupa

Chicago_vertica
Newbie
Newbie
Posts: 4
Joined: Tue Oct 27, 2015 6:14 pm

Re: Vertica Node crashed - help :(

Post by Chicago_vertica » Wed Oct 28, 2015 7:55 pm

Do you have a load balancer for the cluster?
Is the crash on different node in random?

By my experience, the immediate query in the log above "Panic" may not be the culprit. A few more queries up.

I put our log below for your reference. My key words here are "fatal" and "rollback". Hope you find your pattern in the log.

Doesn't hurt to pick out one or two and ask around. Someone may recognize it. I feel it is a bug and hopefully you can point your test app to a specific node in test.

Good luck.

Yongzhi

--log below

2015-10-15 08:06:32.547 Init Session:0x7fa2a0015440-140000000194c29 [Txn] <INFO> Begin Txn: 140000000194c29 'SELECT "MedRecNum", "DatabaseId", "RecordId"
, "MedicareId" FROM CDP.tblAbstract'
2015-10-15 08:06:32.548 Init Session:0x7fa2a0015440-140000000194c29 [Session] <INFO> [BQuery] TX:140000000194c29(DB-Vertica11-22737:0x9236) SELECT "MedRe
cNum", "DatabaseId", "RecordId", "MedicareId" FROM CDP.tblAbstract
2015-10-15 08:06:32.549 Init Session:0x7fa2a0015440-140000000194c29 <LOG> @v_hulkdb_node0011: 00000/3316: Executing statement: 'SELECT "MedRecNum", "Data
baseId", "RecordId", "MedicareId" FROM CDP.tblAbstract'
2015-10-15 08:06:32.599 Init Session:0x7fa2a0014ee0 <LOG> @v_hulkdb_node0011: 00000/2705: Connection received: host=192.168.2.203 port=20648 (connCnt 15)
2015-10-15 08:06:32.599 Init Session:0x7fa2a0014ee0 <FATAL> @v_hulkdb_node0011: {SessionRun} 57014/2605: Client canceled session DB-Vertica11-22737:0x923
6
2015-10-15 08:06:32.600 Spread Client:0x7859d50 [VMPI] <INFO> Hurry: processing for session DB-Vertica11-22737:0x9236, call 29 of type 1
2015-10-15 08:06:32.600 Spread Client:0x7859d50 [Dist] <INFO> Dist::cancelPlan: canceling state EXECUTING(3): 140000000194c2a
2015-10-15 08:06:32.601 Spread Client:0x7859d50 [Dist] <INFO> Dist::cancelPlan: canceled state EXECUTING(3): 140000000194c2a
2015-10-15 08:06:32.601 Spread Client:0x7859d50 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): 140000000194c2a
2015-10-15 08:06:32.601 Spread Client:0x7859d50 [Dist] <INFO> Dist::cancelPlan: already canceled 140000000194c2a
2015-10-15 08:06:32.601 Spread Client:0x7859d50 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): 140000000194c2a
2015-10-15 08:06:32.608 Init Session:0x7fa2a0015440-140000000194c29 <ERROR> @v_hulkdb_node0011: 57014/3322: Execution canceled by operator

Post Reply

Return to “Vertica Database Administration”