Forum: Managing VoltDB

Post: Constraint violations/ incorrect number of parameters supplied to procedure during transaction replay

Constraint violations/ incorrect number of parameters supplied to procedure during transaction replay
mathewbutler
Aug 19, 2014
The following log is from a database that was manually killed via the kill command (it was hung).

The database is under development and the below may just reflect the evolution of the schema and stored procedures during development.

However, I'd like to understand the following:


"Constraint Type UNIQUE, Table CatalogId N_QUEUE"

Under what circumstances can the database contain data that violates a constraint?

"WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: PROCEDURE S_STORE.insert EXPECTS 17 PARAMS, BUT RECEIVED 6"

Under what circumstances can the command log contain inserts that expect an incorrect number of parameters?


[SNIP...]

2014-08-19 15:54:49,069 INFO [Iv2ExecutionSite: 0:1] CONSOLE: Finished restore of /opt/voltdb/dev/83886144/command_log_snapshot with nonce: 1406628464673 in 0.31 seconds
2014-08-19 15:54:49,123 INFO [task-message-generator] LOGGING: Start replaying command log with 2 segments
2014-08-19 15:54:49,157 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: CONSTRAINT VIOLATION
Attempted violation of constraint
Constraint Type UNIQUE, Table CatalogId N_QUEUE
header size: 30
status code: -128 column count: 2
cols (M_ID:STRING), (MESSAGE:VARBINARY),
rows -
11-22-33-44-55-66-77-88:79-33-44-55-66-77-88-00:40,bin[crc:2082744911,value:0xACED000573...]

2014-08-19 15:54:49,164 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: CONSTRAINT VIOLATION
Attempted violation of constraint
Constraint Type UNIQUE, Table CatalogId N_QUEUE
header size: 30
status code: -128 column count: 2
cols (M_ID:STRING), (MESSAGE:VARBINARY),
rows -
11-22-33-44-55-66-77-88:79-33-44-55-66-77-88-00:40,bin[crc:3366435068,value:0xACED000573...]

2014-08-19 15:54:49,170 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: CONSTRAINT VIOLATION
Attempted violation of constraint
Constraint Type UNIQUE, Table CatalogId N_QUEUE
header size: 30
status code: -128 column count: 2
cols (M_ID:STRING), (MESSAGE:VARBINARY),
rows -
11-22-33-44-55-66-77-88:79-33-44-55-66-77-88-00:40,bin[crc:1851005786,value:0xACED000573...]

2014-08-19 15:54:49,189 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: CONSTRAINT VIOLATION
Attempted violation of constraint
Constraint Type UNIQUE, Table CatalogId N_QUEUE
header size: 30
status code: -128 column count: 2
cols (M_ID:STRING), (MESSAGE:VARBINARY),
rows -
11-22-33-44-55-66-77-88:27-33-44-55-66-77-88-00:5,bin[crc:1357677049,value:0xACED000573...]

2014-08-19 15:54:49,195 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: PROCEDURE S_STORE.insert EXPECTS 17 PARAMS, BUT RECEIVED 6
2014-08-19 15:54:49,196 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: PROCEDURE S_STORE.insert EXPECTS 17 PARAMS, BUT RECEIVED 6
2014-08-19 15:55:15,535 INFO [MpInitiator send] LOGGING: 100000 transactions replayed, 0 rolled back, 6 failed
2014-08-19 15:55:37,672 INFO [MpInitiator send] LOGGING: 200000 transactions replayed, 0 rolled back, 6 failed
2014-08-19 15:55:59,715 INFO [MpInitiator send] LOGGING: 300000 transactions replayed, 0 rolled back, 6 failed
2014-08-19 15:56:07,396 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: PROCEDURE S_STORE.insert EXPECTS 17 PARAMS, BUT RECEIVED 6
2014-08-19 15:56:21,624 INFO [MpInitiator send] LOGGING: 400000 transactions replayed, 0 rolled back, 7 failed
2014-08-19 15:56:43,726 INFO [MpInitiator send] LOGGING: 500000 transactions replayed, 0 rolled back, 7 failed
2014-08-19 15:57:06,761 INFO [MpInitiator send] LOGGING: 600000 transactions replayed, 0 rolled back, 7 failed
2014-08-19 15:57:28,928 INFO [MpInitiator send] LOGGING: 700000 transactions replayed, 0 rolled back, 7 failed
2014-08-19 15:57:51,113 INFO [MpInitiator send] LOGGING: 800000 transactions replayed, 0 rolled back, 7 failed
2014-08-19 15:58:13,174 INFO [MpInitiator send] LOGGING: 900000 transactions replayed, 0 rolled back, 7 failed
2014-08-19 15:58:34,357 WARN [Iv2ExecutionSite: 0:0] LOGGING: VOLTDB ERROR: PROCEDURE S_STORE.insert EXPECTS 17 PARAMS, BUT RECEIVED 6
2014-08-19 15:58:35,819 INFO [MpInitiator send] LOGGING: 1000000 transactions replayed, 0 rolled back, 8 failed
2014-08-19 15:58:57,912 INFO [MpInitiator send] LOGGING: 1100000 transactions replayed, 0 rolled back, 8 failed
2014-08-19 15:59:19,861 INFO [MpInitiator send] LOGGING: 1200000 transactions replayed, 0 rolled back, 8 failed

[...SNIP
John T Crawford
Aug 19, 2014
Hi Mat,

As I said in another thread, would you mind emailing this question to support@voltdb.com? Then one of our engineers will get back to you quickly. Thanks!
- John Crawford, VoltDB QA Automation & Support Engineer
mathewbutler
Aug 20, 2014
Thanks John. Now raised with Support.