PBXT

  1. Bug #315564
  2. Comment #4

Comment 4 for bug 315564

Revision history for this message
Vladimir Kolesnikov (vkolesnikov) wrote :

Ok, now I can repro it with 5.1.30:

...
# 01:40:49 Bad average for table: table10_pbxt_int_autoinc; average1: 200.0000; average2: 198.9455; count: 569; affected_rows: 0E0; query: ROLLBACK
# 01:40:49 Bad average for table: table10_pbxt_int_autoinc; average1: 200.0000; average2: 198.9455; count: 569; affected_rows: 0E0; query: COMMIT
# 01:40:49 Bad average for table: table10_pbxt_int_autoinc; average1: 200.0000; average2: 198.9455; count: 569; affected_rows: 0E0; query: ROLLBACK
# 01:40:49 Bad average for table: table10_pbxt_int_autoinc; average1: 200.0000; average2: 198.9455; count: 569; affected_rows: 0E0; query: ROLLBACK
# 01:40:49 Bad average for table: table10_pbxt_int_autoinc; average1: 200.0000; average2: 198.9455; count: 569; affected_rows: 0E0; query: COMMIT
#
...

and

mysql> select * from table10_pbxt_int_autoinc where `int` is null;
+---------+------+------+
| int_key | pk | int |
 +---------+------+------+
| NULL | 1283 | NULL |
| NULL | 1284 | NULL |
| NULL | 1285 | NULL |
 +---------+------+------+
3 rows in set (0.00 sec)

I assume this is what you meant.