PBXT

  1. Bug #664418
  2. Comment #1

Comment 1 for bug 664418

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

The workload causes the following error:

 UPDATE `E` AS X SET `col_int_key` = 124 , `col_int_key` = 179 , `col_int_key` = 18 WHERE `col_int_key` <= 11 failed: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again.

The MySQL manual says "If a transaction is larger than this many bytes, it fails and rolls back". However, it seems that this is not the case of PBXT, and an explicit ROLLBACK is required after such an error in order to bring things back into shape. So this bug is a manifestation of LP bug#662714