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
Vertica Node crashed - help :(
Moderator: NorbertKrupa
-
- Newbie
- Posts: 4
- Joined: Tue Oct 27, 2015 6:14 pm
Return to “Vertica Database Administration”
Jump to
- General
- ↳ Welcome to vertica-forums.com!
- ↳ Board Announcements
- ↳ Request for New Forums Categories
- ↳ Announcements, Events and Activities
- ↳ Vertica Links
- ↳ General
- ↳ Employment
- ↳ Vertica Certification
- Newbie
- ↳ New to Vertica
- ↳ New to Vertica Database Administration
- ↳ New to Vertica Database Development
- ↳ New to Vertica SQL
- Using Vertica
- ↳ Vertica Database Administration
- ↳ Vertica Database Development
- ↳ Vertica SQL
- ↳ Vertica SQL Functions
- ↳ Vertica Database Designer (DBD)
- ↳ Vertica User Defined Functions (UDFs)
- ↳ Vertica External Procedures
- ↳ Vertica Analytics
- ↳ Vertica Management Console
- ↳ Vertica Error Codes
- ↳ Vertica Backup & Recovery
- ↳ Vertica Installation
- ↳ Vertica Security
- ↳ Vertica Performance Tuning
- ↳ Vertica Administration Tools
- ↳ Vertica Upgrade
- ↳ Vertica Migration
- ↳ Vertica and the Operating System
- ↳ Vertica Data Load
- ↳ Vertica Tips, Lessons and Examples
- ↳ Vertica "How to..."
- Connecting to Vertica
- ↳ ADO.NET
- ↳ Cognos
- ↳ DBeaver
- ↳ dbVisualizer
- ↳ HDFS Connector
- ↳ Hadoop Connector
- ↳ HCatalog Connector
- ↳ Informatica PowerCenter
- ↳ JDBC
- ↳ Microsoft SQL Server Analysis Services (SSAS)
- ↳ MicroStrategy
- ↳ Microsoft SQL Server Integration Services (SSIS)
- ↳ ODBC
- ↳ Perl
- ↳ PHP
- ↳ Python
- ↳ R Language Integration
- ↳ Rhapsody Interface Engine
- ↳ SQL Workbench/J
- ↳ SQuirreL SQL Client
- ↳ Talend
- ↳ Tableau
- ↳ Toad for Data Analysts
- ↳ Vertica SDK API
- ↳ VoltDB
- ↳ vSQL
- Vertica Portfolio
- ↳ Vertica Premium Edition
- ↳ Vertica Express Edition
- ↳ Vertica Community Edition
- ↳ Vertica SQL on Hadoop
- ↳ Vertica in the AWS Cloud
- ↳ Vertica on Microsoft Azure
- All times are UTC+01:00
- Top
- Delete all board cookies
Powered by phpBB ® | phpBB3 theme by KomiDesign