SegFault while starting Oracle database bench
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
sysbench |
New
|
Undecided
|
Unassigned |
Bug Description
Hi,
I'm working on a redhat system. I need to bench some Oracle database so I get to compile a Sysbench 0.4.12 for this.
$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Some env variables :
LD_LIBRARY_
ORACLE_
OSTYPE=linux-gnu
PATH=/opt/
In order to compile this I execute folowing steps :
$ cd sysbench-0.4.12
$ export CC=cc
$ export CXX=c++export CFLAGS="-m64 -I /oracle/
$ export CXXFLAGS="$CFLAGS"
$ export LD_LIBRARY_
$ export SHLIB_PATH=
$ export CPPFLAGS=
$ export LDFLAGS=
$ ./configure --prefix=
$ make
$ make install
and it produce the wanted folder structure and files.
For Mysql database, all bench process ("prepare", "run" and " cleanup") run fine.
For Oracle database, "prepare" and "cleanup" steps run fine without any error message.
But "run" step will fail with a 'Segmentation fault' fatal message
$ /opt/sysbench/
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 16
Debug mode enabled.
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
DEBUG: Runner thread started (0)!
DEBUG: Runner thread started (1)!
DEBUG: Runner thread started (2)!
DEBUG: Runner thread started (3)!
DEBUG: Runner thread started (4)!
DEBUG: Runner thread started (5)!
DEBUG: Runner thread started (6)!
Threads started!
Segmentation fault
Hi,
I'm not fluent with debugging tools for C code but I found the strace utility:
strace -f -F -v -o /home/dba/ sysbenchtrace ./sysbench --test=oltp --db-driver=oracle --oracle-user=bench --oracle- password= benchbench01 --oracle-db=jde9dv --oltp- table-size= 10000 --num-threads=3 --max-requests=1000 --debug=on --verbosity=5 run
25154 execve( "./sysbench" , ["./sysbench", "--test=oltp", "--db-driver= oracle" , "--oracle- user=bench" , "--oracle- password= benchbench01" , "--oracle- db=jde9dv" , "--oltp- table-size= 10000", "--num-threads=3", "--max- requests= 1000", "--debug=on", "--verbosity=5", "run"], ["HOSTNAME= dev-web01" , "M2=/opt/ maven/bin" , "TERM=xterm", "SHELL=/bin/bash", "HISTSIZE=1000", "KDE_NO_IPV6=1", "SSH_CLIENT= 172.17. 6.212 51781 22", "OLDPWD=/home/dba", "SSH_TTY= /dev/pts/ 1", "ANT_HOME= /opt/ant" , "CC_HOME= /opt/cruisecont rol", "http_proxy=http:// 172.16. 32.252:", "USER=dba", "LD_LIBRARY_ PATH=/opt/ mysql/lib: /", "LS_COLORS= no=00:fi= 00:di=00; 34:l", "KDEDIR=/usr", "MAVEN_ OPTS=-Xms256m -Xmx512m", "MAIL=/ var/spool/ mail/dba" , "PATH=/ opt/libreoffice 3.6/program" , "INPUTRC= /etc/inputrc" , "PWD=/opt/ sysbench/ bin", "JAVA_HOME= /usr/java/ jdk1.6. 0_43", "LANG=C", "KDE_IS_ PRELINKED= 1", "SSH_ASKPASS= /usr/libexec/ openssh" , "M2_HOME= /opt/maven" , "SHLVL=1", "HOME=/home/dba", "no_proxy= localhost, .vetoquinol, .", "LOGNAME=dba", "CVS_RSH=ssh", "SSH_CONNECTION =172.17. 6.212 5178", "LESSOPEN= |/usr/bin/ lesspipe. sh %", "ORACLE_ HOME=/oracle/ ora11g" , "G_BROKEN_ FILENAMES= 1", "_=/usr/ bin/strace" ]) = 0 PROT_WRITE, MAP_PRIVATE| MAP_ANONYMOUS, -1, 0) = 0x2abdadc9d000 sysname= "Linux" , nodename= "dev-web01" , release= "2.6.18- 164.el5" , version="#1 SMP Tue Aug 18 15:51:48 EDT 2009", machine="x86_64"}) = 0 "/etc/ld. so.preload" , R_OK) = -1 ENOENT (No such file or directory) opt/mysql/ lib/tls/ x86_64/ libmysqlclient. so.18", O_RDONLY) = -1 ENOENT (No such file or directory) opt/mysql/ lib/tls/ x86_64" , 0x7fff4fc52990) = -1 ENOENT (No such file or directory) opt/mysql/ lib/tls/ libmysqlclient. so.18", O_RDONLY) = -1 ENOENT (No such file or directory) opt/mysql/ lib/tls" , 0x7fff4fc52990) = -1 ENOENT (No such file or directory) opt/mysql/ lib/x86_ 64/libmysqlclie nt.so.18" , O_RDONLY) = -1 ENOENT (No such file or directory) opt/mysql/ lib/x86_ 64", 0x7fff4fc52990) = -1 ENOENT (No such file or directory) opt/mysql/ lib/libmysqlcli ent.so. 18", O_RDONLY) = 3 2\1\1\0\ 0\0\0\0\ 0\0\0\0\ 3\0>\0\ 1\0\0\0` \350\2\ 0\0\0\0\ 0"..., 832) = 832 S_IFREG| 0770, st_nlink=1, st_uid=611, st_gid=611, st_blksize=4096, st_blocks=7248, st_size=3705453, st_atime= 2013/09/ 30-15:06: 49, st_mtime= 2013/04/ 16-14:23: 14, st_ctime= 2013/09/ 30-00:28: 11}) = 0 PROT_WRITE, MAP_PRIVATE| MAP_ANONYMOUS, -1, 0) = 0x2abdadc9e000 PROT_EXEC, MAP_PRIVATE| MAP_DENYWRITE, 3, 0) = 0x2abdadc9f000 0x2abdadf73000, 2097152, PROT_NONE) = 0 3000, 540672, PROT_READ| PROT_WRITE, MAP_PRIVATE|MAP_...
25154 brk(0) = 0xc0f8000
25154 mmap(NULL, 4096, PROT_READ|
25154 uname({
25154 access(
25154 open("/
25154 stat("/
25154 open("/
25154 stat("/
25154 open("/
25154 stat("/
25154 open("/
25154 read(3, "\177ELF\
25154 fstat(3, {st_dev=makedev(8, 2), st_ino=4496983, st_mode=
25154 mmap(NULL, 4096, PROT_READ|
25154 mmap(NULL, 5622128, PROT_READ|
25154 mprotect(
25154 mmap(0x2abdae17