Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
2.0.1
-
None
-
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
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-