sysbench needs to reconnect in case of errors

Bug #1355071 reported by Raghavendra D Prabhu on 2014-08-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
sysbench
Undecided
Alexey Kopytov

Bug Description

Currently it exits.

ALERT: [ 0s] Event generation thread is too slow
ALERT: [ 1s] Event generation thread is too slow
ALERT: [ 1s] Event generation thread is too slow
ALERT: [ 1s] Event generation thread is too slow
ALERT: [ 2s] Event generation thread is too slow
ALERT: [ 3s] Event generation thread is too slow
ALERT: [ 3s] Event generation thread is too slow
ALERT: [ 4s] Event generation thread is too slow
ALERT: [ 5s] Event generation thread is too slow
ALERT: [ 5s] Event generation thread is too slow
ALERT: [ 8s] Event generation thread is too slow
ALERT: [ 8s] Event generation thread is too slow
ALERT: [ 9s] Event generation thread is too slow
ALERT: [ 9s] Event generation thread is too slow
ALERT: [ 9s] Event generation thread is too slow
[ 10s] threads: 20, tps: 1.30, reads/s: 92.40, writes/s: 115.70, response time: 2372.32ms (95%)
[ 10s] queue length: 1147, concurrency: 20
ALERT: [ 12s] Event generation thread is too slow
ALERT: [ 13s] Event generation thread is too slow
ALERT: [ 14s] Event generation thread is too slow
ALERT: [ 15s] Event generation thread is too slow
ALERT: [ 15s] Event generation thread is too slow
ALERT: [ 15s] Event generation thread is too slow
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: [ 19s] Event generation thread is too slow
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `UPDATE sbtest14 SET c='83232520494-77785347888-04383168242-28199971817-16141249625-43727091732-66357277398-21324253482-59478745107-30747754572' WHERE id=5011`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `BEGIN`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `COMMIT`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)
ALERT: failed to execute MySQL query: `UPDATE sbtest19 SET c='80409850888-25761355169-67356684823-95337515164-32241478141-29196103246-24982538677-79109412783-76643333994-65083363366' WHERE id=5029`:
ALERT: Error 1047 Unknown command
FATAL: failed to execute function `event': (null)

==============================

This would be helpful with netem testing.

There also seems to be a branch for it https://bazaar.launchpad.net/~percona-dev/perconatools/sysbench-reconnect/revision/108

One more thing, in addition, it would be better to specify which errors to ignore (for reconnect )and which ones are fatal.

Alexey Kopytov (akopytov) wrote :
Changed in sysbench:
assignee: nobody → Alexey Kopytov (akopytov)
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers