[MXS-813] binlogrouter, mariadb10.0, signal 11, crash Created: 2016-07-28  Updated: 2016-07-29  Resolved: 2016-07-29

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: 1.4.3
Fix Version/s: 2.0.0

Type: Bug Priority: Major
Reporter: sava Assignee: Massimiliano Pinto (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

master:
amazon RDS mariadb10.0.24

maxscale:
CentOS7 maxscale-1.4.3-1.x86_64


 Description   

My /etc/maxscale.cnf is below

[maxscale]
threads=1
log_info=1

[MaxAdmin Service]
type=service
router=cli

[Replication]
type=service
router=binlogrouter
user=maxscale
passwd=xxxxxxxxxxxxxxxx
version_string=10.0.24-MariaDB
router_options=binlogdir=/var/cache/maxscale,server_id=1,user=repl,password=xxxxxxxxxxxx,mariadb10-compatibility=1

[MaxAdmin Listener]
type=listener
service=MaxAdmin Service
protocol=maxscaled
port=6603

[Replication Listener]
type=listener
service=Replication
protocol=MySQLClient
port=5308

My operation is below:

sudo systemctl start maxscale.service

mysql -h 127.0.0.1 -u maxscale -P 5308 --protocol=tcp -p
Enter password:

MariaDB [(none)]> CHANGE MASTER TO MASTER_HOST='xxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='xxxxxxxxxxx', MASTER_LOG_FILE='mysql-bin-changelog.001521', MASTER_LOG_POS=4;
MariaDB [(none)]> start slave;
MariaDB [(none)]> show slave status;

My logfile is below:

2016-07-28 09:46:30 [3] info : Execute statement from the slave 'show slave status'
2016-07-28 09:46:30 error : Fatal: MaxScale 1.4.3 received fatal signal 11. Attempting backtrace.
2016-07-28 09:46:30 error : Commit ID: c2706bab69d1f3b5f1f3ec70f78b1a4803788fec System name: Linux Release string: CentOS Linux release 7.2.1511 (Core) Embedded library version: (null)
2016-07-28 09:46:30 error : /usr/bin/maxscale() [0x403b80]
2016-07-28 09:46:30 error : /lib64/libpthread.so.0(+0xf100) [0x7fbc3a1ef100]
2016-07-28 09:46:30 error : /usr/lib64/maxscale/libbinlogrouter.so(+0x2a6c9) [0x7fbc347e36c9]
2016-07-28 09:46:30 error : /usr/lib64/maxscale/libbinlogrouter.so(+0x2778e) [0x7fbc347e078e]
2016-07-28 09:46:30 error : /usr/lib64/maxscale/libbinlogrouter.so(blr_slave_request+0x107) [0x7fbc347df683]
2016-07-28 09:46:30 error : /usr/lib64/maxscale/libbinlogrouter.so(+0x1d875) [0x7fbc347d6875]
2016-07-28 09:46:30 error : /usr/lib64/maxscale/libMySQLClient.so(+0x3566) [0x7fbc30501566]
2016-07-28 09:46:30 error : /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x43f90) [0x7fbc3ab16f90]
2016-07-28 09:46:30 error : /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(poll_waitevents+0x5de) [0x7fbc3ab1686e]
2016-07-28 09:46:30 error : /usr/bin/maxscale(main+0x16e0) [0x406779]
2016-07-28 09:46:30 error : /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fbc38bf4b15]
2016-07-28 09:46:30 error : /usr/bin/maxscale() [0x4035a9]
2016-07-28 09:46:30 [3] info : Starting log flushing to disk.

 Comments   
Comment by sava [ 2016-07-28 ]

RDS MySQL 5.6.29 is also bad.
mariadb-5.5.47-1.el7_2.x86_64 works fine.
Binlogrouter does not support Amazon RDS as master?

Comment by Massimiliano Pinto (Inactive) [ 2016-07-28 ]

There is a bug in the routine that reports the hostname in SHOW SLAVE STATUS

Max size is 41 bytes for all columns: this is being fixed with forthcoming maxScale release.

Would you mind testing again MySQL 5.6 and MariaDB 10.0 using shorter names or IP if possible?

Comment by sava [ 2016-07-29 ]

Hello Massimiliano Pinto,

I've tested IP address instead of long FQDN like xxxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com.
Every things seems good.
MySQL 5.6 on RDS works fine as master. MariaDB 10.0 also works fine. Thank you.

Comment by Massimiliano Pinto (Inactive) [ 2016-07-29 ]

Hi,
the fix has been tested and it can show up to 250 bytes in the SHOW SLAVE STATUS.

It will be available in the next release.

For now, as you successfully tested, the only way to get rid of the issue is to use a 41 bytes long hostname.

Massimiliano

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