Exit status of sysbench

Bug #1382807 reported by Raghavendra D Prabhu on 2014-10-18
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
sysbench
Undecided
Unassigned

Bug Description

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.

Tags: pxc Edit Tag help
Alexey Kopytov (akopytov) wrote :

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?

Changed in sysbench:
status: New → Incomplete

 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)

Changed in sysbench:
status: Incomplete → New
tags: added: pxc
Alexey Kopytov (akopytov) wrote :

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

Changed in sysbench:
status: New → Incomplete
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers