Comment 10 for bug 379264

Revision history for this message
MadMatt (yonkovim) wrote :

Here is the bug:
Memcached get: Block: 51f0:7:48d8 : Thread : 1095784784 time:226
Memcached get: Block: 51f0:1:6e8a : Thread : 1096051024 time:542
Memcached get: Block: 51f0:1:5c41 : Thread : 1095203152 time:463
Memcached get: Block: 51f0:7:2aff : Thread : 1095469392 time:614
Memcached get: Block: 51f0:1:8fb5 : Thread : 1094334800 time:473
Memcached get: Block: 51f0:4:2a8 : Thread : 1150839120 time:153
Memcached get: Block: 51f0:7:4e7 : Thread : 1150306640 time:921
InnoDB: error in sec index entry update in
InnoDB: index `myidx1` of table `dbt2`.`new_order`
InnoDB: tuple DATA TUPLE: 3 fields;
 0: len 4; hex 8000000f; asc ;; 1: len 4; hex 80000cec; asc ;; 2: len 4; hex 80000003; asc ;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 8000000f; asc ;; 1: len 4; hex 80000cec; asc ;; 2: len 4; hex 80000002; asc ;;

TRANSACTION 0 1387899, ACTIVE 0 sec, process no 20975, OS thread id 1150572880 updating or deleting
mysql tables in use 1, locked 1
15 lock struct(s), heap size 3024, 24 row lock(s), undo log entries 22
MySQL thread id 28, query id 20822257 localhost root updating
DELETE FROM new_order
WHERE no_o_id = 3308
  AND no_w_id = 15
  AND no_d_id = 3

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
Memcached get: Block: 51f0:7:6186 : Thread : 1096583504 time:536
Memcached get: Block: 51f0:7:2709 : Thread : 1094334800 time:773
Memcached get: Block: 51f0:7:270a : Thread : 1094334800 time:551
Memcached get: Block: 51f0:1:b37e : Thread : 1150040400 time:523

Memcached get: Block: 51f0:7:44d4 : Thread : 1094334800 time:270
Memcached get: Block: 51f0:1:d9e : Thread : 1095203152 time:216
Memcached get: Block: 51f0:7:46b5 : Thread : 1150306640 time:1036
Memcached get: Block: 51f0:1:2a65 : Thread : 1094867280 time:358
Memcached get: Block: 51f0:7:3495 : Thread : 1095469392 time:417
Memcached get: Block: 51f0:1:959c : Thread : 1097738576 time:323
Memcached get: Block: 51f0:3:a1c7 : Thread : 1094601040 time:450
Memcached get: Block: 51f0:1:9b18 : Thread : 1097738576 time:471
Memcached get: Block: 51f0:7:276 : Thread : 1150572880 time:270
Memcached get: Block: 51f0:7:4596 : Thread : 1094334800 time:277
Memcached get: Block: 51f0:7:f20 : Thread : 1150040400 time:273
Memcached get: Block: 51f0:7:28d1 : Thread : 1094334800 time:301
Memcached get: Block: 51f0:7:4b9c : Thread : 1094601040 time:655
Memcached get: Block: 51f0:1:6de2 : Thread : 1096317264 time:194
Memcached get: Block: 51f0:1:29ec : Thread : 1150839120 time:141
Memcached get: Block: 51f0:7:298 : Thread : 1150572880 time:521
Memcached get: Block: 51f0:1:3d0 : Thread : 1095203152 time:107
Memcached get: Block: 51f0:7:1e71 : Thread : 1094867280 time:2160
Memcached get: Block: 51f0:1:54c7 : Thread : 1094334800 time:317
Memcached get: Block: 51f0:1:a799 : Thread : 1094068560 time:450
InnoDB: error in sec index entry update in
InnoDB: index `myidx1` of table `dbt2`.`new_order`
InnoDB: tuple DATA TUPLE: 3 fields;
 0: len 4; hex 8000000f; asc ;; 1: len 4; hex 80000ced; asc ;; 2: len 4; hex 80000003; asc ;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 32
 0: len 4; hex 8000000f; asc ;; 1: len 4; hex 80000ced; asc ;; 2: len 4; hex 80000002; asc ;;

TRANSACTION 0 1388669, ACTIVE 0 sec, process no 20975, OS thread id 1094601040 updating or deleting
mysql tables in use 1, locked 1
15 lock struct(s), heap size 3024, 35 row lock(s), undo log entries 32
MySQL thread id 23, query id 20834926 localhost root updating
DELETE FROM new_order
WHERE no_o_id = 3309
  AND no_w_id = 15
  AND no_d_id = 3

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
Memcached get: Block: 51f0:1:980e : Thread : 1097738576 time:302
Memcached get: Block: 51f0:7:cf4 : Thread : 1094867280 time:367
Memcached get: Block: 51f0:7:33f1 : Thread : 1096051024 time:273
Memcached get: Block: 51f0:1:987a : Thread : 1097738576 time:314
Memcached get: Block: 51f0:7:2318 : Thread : 1151105360 time:318
Memcached get: Block: 51f0:1:a756 : Thread : 1094068560 time:107
Memcached get: Block: 51f0:7:47e2 : Thread : 1150306640 time:352