Percona Server moved to https://jira.percona.com/projects/PS

  1. Series 5.6
  2. Bug #1168265
  3. Comment #22

Comment 22 for bug 1168265

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

Seen this issue in PS-5.5. Most of the SERVER CRASH errors are with 'UPDATE IGNORE' query. As per #16, removing "IGNORE" clause from PS 5.5 yy grammar.

Some of the update queries that caused server crash..

Query (7fb54c4472d0): UPDATE IGNORE `view_table500_innodb_compressed_int_autoinc` t1, `table500_innodb_default_int` t2 SET t1.`c6` = -1 WHERE t1.`c10` < '2003-05-09 13:09:40.001516'

Query (7f1774004dd0): UPDATE IGNORE `table500_innodb_compressed_key_pk_parts_2_int` t1, `table500_innodb_compressed_key_pk_parts_2_int_autoinc` t2 SET t1.`c11` = NULL WHERE t1.`c10` < '20041117104500.024739'

Query (7ff3e8004dd0): UPDATE IGNORE `table500_innodb_compressed_key_pk_parts_2_int` t1, `table500_innodb_default_key_pk_parts_2_int` t2 SET t1.`c1` = '20061122143506.002479' WHERE t1.`c18` = 'f'

Query (7ffc6c004dd0): UPDATE IGNORE `table500_innodb_compressed_key_pk_parts_2_int` t1, `table500_innodb_default` t2 SET t1.`c4` = -1 WHERE t1.`c4` != 0