[MXS-970] A fatal problem with maxscale automatically shut down Created: 2016-11-16  Updated: 2016-11-18  Resolved: 2016-11-18

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.0.1
Fix Version/s: 2.0.2

Type: Bug Priority: Blocker
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MXS-976 Crash in libqc_sqlite Closed
Sprint: 2016-22

 Description   

Dear，all：
I have a problem，while I use the client tools to connect Maxscale. the Maxscale Will automatically shut down，and error.

Client Tools：sequel pro
Maxscale version:2.0.1
ssl：yes

The maxscale error is as follows：

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~·
 
2016-11-15 14:07:56   error  : Fatal: MaxScale 2.0.1 received fatal signal 11. Attempting backtrace.
 
2016-11-15 14:07:56   error  : Commit ID: fa2a66719554d13a00db5c81c5c9ffd5b3a2ce14 System name: Linux Release string: Red Hat Enterprise Linux Server release 6.4 (Santiago)
 
2016-11-15 14:07:56   error  :   /usr/bin/maxscale() [0x403b9c] 
2016-11-15 14:07:56   error  :   /lib64/libpthread.so.0() [0x352960f710] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x54a94) [0x7f40e1b2aa94] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x532b4) [0x7f40e1b292b4] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x5339f) [0x7f40e1b2939f] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x5611c) [0x7f40e1b2c11c] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x56207) [0x7f40e1b2c207] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x55c88) [0x7f40e1b2bc88] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x5363a) [0x7f40e1b2963a] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x5628b) [0x7f40e1b2c28b] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x81efb) [0x7f40e1b57efb] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x826c2) [0x7f40e1b586c2] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x99690) [0x7f40e1b6f690] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0xaa25) [0x7f40e1ae0a25] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x9ad38) [0x7f40e1b70d38] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0xa022e) [0x7f40e1b7622e] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0xa143f) [0x7f40e1b7743f] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x78a91) [0x7f40e1b4ea91] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x78dda) [0x7f40e1b4edda] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x78f60) [0x7f40e1b4ef60] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x8aef) [0x7f40e1adeaef] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x8e92) [0x7f40e1adee92] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x8827) [0x7f40e1ade827] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0x889b) [0x7f40e1ade89b] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libqc_sqlite.so(+0xc894) [0x7f40e1ae2894] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(qc_get_type+0x20) [0x34e3045387] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libreadwritesplit.so(+0x4d39) [0x7f40e1faed39] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libreadwritesplit.so(+0x4b65) [0x7f40e1faeb65] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libMySQLClient.so(+0x35ff) [0x7f40e0ed15ff] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libMySQLClient.so(+0x2b79) [0x7f40e0ed0b79] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libMySQLClient.so(+0x2ae1) [0x7f40e0ed0ae1] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libMySQLClient.so(+0x246d) [0x7f40e0ed046d] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0() [0x34e3047887] 
2016-11-15 14:07:56   error  :   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(poll_waitevents+0x5fc) [0x34e304712c] 
2016-11-15 14:07:56   error  :   /usr/bin/maxscale(main+0x17e9) [0x40697e] 
2016-11-15 14:07:56   error  :   /lib64/libc.so.6(__libc_start_main+0xfd) [0x30efe1ed5d] 
2016-11-15 14:07:56   error  :   /usr/bin/maxscale() [0x4035a9]


this maxscale config as :
 
 
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
[maxscale]
 
threads=4
 
syslog=0
 
 
 
[MySQL Monitor]
 
type=monitor
 
module=mysqlmon
 
servers=sql-178
 
user=maxscale
 
passwd=xxxx
 
monitor_interval=10000
 
 
 
#[DatabaseFirewall]
 
#type=filter
 
#module=dbfwfilter
 
#rules=/home/maxscale/rules.txt
 
 
 
[RW Split Router]
 
type=service
 
router=readwritesplit
 
servers=sql-178
 
user=maxscale
 
passwd=xxxx
 
#filters=DatabaseFirewall
 
 
 
[RW Split Listener]
 
type=listener
 
service=RW Split Router
 
protocol=MySQLClient
 
address=x.x.x.x
 
port=4006
 
 
 
# Enable SSL, Use Server Certs
 
ssl=required
 
ssl_ca_cert = /usr/local/mysql/ssl/ca.pem
 
ssl_cert = /usr/local/mysql/ssl/server-cert.pem
 
ssl_key = /usr/local/mysql/ssl/server-key.pem
 
ssl_version=TLSv10
 
 
 
[Binlog_Service]
 
type=service
 
router=binlogrouter
 
 
 
# Privileges: Show databases,select,Replication client,Replication slave
 
user=repl_maxscale
 
passwd=xxxx
 
version_string=5.6.27-76.0-log
 
# server_id：binlog proxy name
 
router_options=server_id=73,user=repl_maxscale,password=xxxx,filestem=binlog,binlogdir=/var/lib/maxscale/binlogs
 
 
 
[Binlog Listener]
 
type=listener
 
service=Binlog_Service
 
protocol=MySQLClient
 
port=5306
 
 
 
# Enable SSL, Use Server Certs
 
ssl=required
 
ssl_ca_cert = /usr/local/mysql/ssl/ca.pem
 
ssl_cert = /usr/local/mysql/ssl/server-cert.pem
 
ssl_key = /usr/local/mysql/ssl/server-key.pem
 
 
 
[Debug Interface]
 
type=service
 
router=debugcli
 
 
 
[Debug Listener]
 
type=listener
 
service=Debug Interface
 
protocol=telnetd
 
address=127.0.0.1
 
port=4442
 
 
 
[CLI]
 
type=service
 
router=cli
 
 
 
[CLI Listener]
 
type=listener
 
service=CLI
 
protocol=maxscaled
 
port=6603
 
 
 
[sql-178]
 
type=server
 
address=x.x.x.x
 
port=3306
 
protocol=MySQLBackend
 
persistpoolmax=100
 
persistmaxtime=3600
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



 Comments   
Comment by Johan Wikman [ 2016-11-16 ] 

/usr/bin/maxscale() [0x403b9c]
 
/lib64/libpthread.so.0() [0x352960f710]
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:85772
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:85016
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:85030
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:86542
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:86566
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:86346
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:85118
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:86598
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:115112
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:115354
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:128253
 
/home/ec2-user/workspace/query_classifier/qc_sqlite/qc_sqlite.c:1376
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:131795
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:133764
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:134961
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:110232
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:110320
 
/home/ec2-user/workspace/_build/sqlite-bld-3110100/sqlite3.c:110384
 
/home/ec2-user/workspace/query_classifier/qc_sqlite/qc_sqlite.c:394
 
/home/ec2-user/workspace/query_classifier/qc_sqlite/qc_sqlite.c:506
 
/home/ec2-user/workspace/query_classifier/qc_sqlite/qc_sqlite.c:296
 
/home/ec2-user/workspace/query_classifier/qc_sqlite/qc_sqlite.c:322
 
/home/ec2-user/workspace/query_classifier/qc_sqlite/qc_sqlite.c:2574
 
/usr/lib64/maxscale/libmaxscale-common.so.1.0.0(qc_get_type+0x20) [0x34e3045387]
 
/home/ec2-user/workspace/server/modules/routing/readwritesplit/readwritesplit.c:1918
 
/home/ec2-user/workspace/server/modules/routing/readwritesplit/readwritesplit.c:1840
 
/home/ec2-user/workspace/server/modules/protocol/mysql_client.c:1388
 
/home/ec2-user/workspace/server/modules/protocol/mysql_client.c:898
 
/home/ec2-user/workspace/server/modules/protocol/mysql_client.c:849
 
/home/ec2-user/workspace/server/modules/protocol/mysql_client.c:532
 
/usr/lib64/maxscale/libmaxscale-common.so.1.0.0() [0x34e3047887]
 
/usr/lib64/maxscale/libmaxscale-common.so.1.0.0(poll_waitevents+0x5fc) [0x34e304712c]
 
/usr/bin/maxscale(main+0x17e9) [0x40697e]
 
/lib64/libc.so.6(__libc_start_main+0xfd) [0x30efe1ed5d]
 
/usr/bin/maxscale() [0x4035a9]

Generated at Thu Feb 08 04:03:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.