sysbench needs to reconnect in case of errors
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
sysbench |
Fix Committed
|
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-
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-
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:/
One more thing, in addition, it would be better to specify which errors to ignore (for reconnect )and which ones are fatal.
Fixed by http:// bazaar. launchpad. net/~sysbench- developers/ sysbench/ 0.5/revision/ 126.