Exit status of sysbench

[Raghavendra D Prabhu]

When there is an error in the test(ie. lua script), and sysbench fails, it exits with exit code of 0 than a non-zero status.

[Alexey Kopytov (akopytov)]

Could not reproduce this. This is what I tried:

1. Adding a syntax error to a Lua script. sysbench failed with 1 as the exit status.
2. Adding a syntax error to an SQL query executed by sysbench. Again, it failed with 1 as the exit status.
3. Starting a server with read-only=1, so that SQL queries have valid syntax, but would return an error. Again, sysbench failed with a non-zero exit status.

Can you provide a test case for this bug?

[Raghavendra D Prabhu (raghavendra-prabhu)]

 http://jenkins.percona.com/job/PXC-5.6-msysbench/170/BTYPE=release,Host=centos6-64/console is the sysbench bug

The exit code for

"03:16:17 ALERT: failed to execute MySQL query: `INSERT INTO sbtest45 (id, k, c, pad) VALUES (4993, 4996, '37247164271-88079818172-84134305488-61961809718-50477640378-24587008020-63963244677-62752244319-56030806318-97428684634', '34874118501-93522659892-01931374238-89720983735-86067146107')`:
03:16:17 ALERT: Error 1062 Duplicate entry '4993' for key 'PRIMARY'
03:16:17 FATAL: failed to execute function `event': (null)"

 is zero

 Another instance:

04:30:13 ALERT: failed to execute MySQL query: `DROP TABLE testdb.sbtest81210`:
04:30:13 ALERT: Error 1051 Unknown table 'testdb.sbtest81210'
04:30:13 FATAL: failed to execute function `event': (null)

[Alexey Kopytov (akopytov)]

Still cannot repeat:

 ./sysbench --test=tests/db/oltp.lua cleanup
sysbench 0.5: multi-threaded system evaluation benchmark

Dropping table 'sbtest1'...

$ ./sysbench --test=tests/db/oltp.lua cleanup
sysbench 0.5: multi-threaded system evaluation benchmark

Dropping table 'sbtest1'...
ALERT: mysql_drv_query() for query 'DROP TABLE sbtest1' failed: 1051 Unknown table 'sbtest.sbtest1'
FATAL: failed to execute function `cleanup': 3

$ echo $?
1