After upgrading to mariadb 10.1.33-r1, the mysql health check scripts segfaults: # /usr/lib/nagios/plugins/check_mysql_health --socket /var/run/mysqld/mysqld.sock --mode bufferpool-hitrate OK - innodb buffer pool hitrate at 99.80% | bufferpool_hitrate=99.80%;98:;95:;0;100 bufferpool_hitrate_now=100.00% Segmentation fault # dmesg [517917.051223] check_mysql_hea[25427]: segfault at 981b3e9ea8 ip 00007f48855922c9 sp 00007ffe6a100c90 error 4 in libmysqlclient.so.18.4.0[7f4885554000+34a000] [517918.755398] check_mysql_sel[25442]: segfault at 1e37fd6288 ip 00007fdbdb4542c9 sp 00007fff843bf9a0 error 4 in libmysqlclient.so.18.4.0[7fdbdb416000+34a000] [517919.276654] check_mysql_hea[25447]: segfault at 80f269d778 ip 00007fec607612c9 sp 00007ffcfb659840 error 4 in libmysqlclient.so.18.4.0[7fec60723000+34a000] [517923.032301] check_mysql_sel[25503]: segfault at f566543218 ip 00007efe87b262c9 sp 00007fff84b25270 error 4 in libmysqlclient.so.18.4.0[7efe87ae8000+34a000] [517923.087334] check_mysql_con[25537]: segfault at 6888a6c828 ip 00007f1e9211b2c9 sp 00007ffd60f464b0 error 4 in libmysqlclient.so.18.4.0[7f1e920dd000+34a000] [517923.126697] check_mysql_hea[25492]: segfault at 60b432ca88 ip 00007fabe22b32c9 sp 00007ffec796e790 error 4 in libmysqlclient.so.18.4.0[7fabe2275000+34a000] [517923.564266] check_mysql_hea[25547]: segfault at 45babd8a88 ip 00007ff8f023e2c9 sp 00007fff9e3b5a30 error 4 in libmysqlclient.so.18.4.0[7ff8f0200000+34a000] [517923.652945] check_mysql_com[25669]: segfault at d5325c10e8 ip 00007f826c9862c9 sp 00007ffeb0219080 error 4 in libmysqlclient.so.18.4.0[7f826c948000+34a000] [517923.708860] check_mysql_hea[25687]: segfault at c1819e1438 ip 00007f25783ae2c9 sp 00007ffefd318250 error 4 in libmysqlclient.so.18.4.0[7f2578370000+34a000]
mariadb 10.1.33-r1 does not provided client libraries. Instead this is shifted to mysql-connector-c. Did you run revdep-rebuild on libmysqlclient? The libs are not 100% ABI compatible.
(In reply to Brian Evans from comment #1) > mariadb 10.1.33-r1 does not provided client libraries. Instead this is > shifted to mysql-connector-c. > > Did you run revdep-rebuild on libmysqlclient? The libs are not 100% ABI > compatible. Rebuilding net-analyzer/nagios-check_mysql_health didn't help, but after checking the deps and rebuilding dev-perl/DBD-mysql it works properly now. Maybe we should add a note about this change?
(In reply to Tomáš Mózes from comment #2) > (In reply to Brian Evans from comment #1) > > mariadb 10.1.33-r1 does not provided client libraries. Instead this is > > shifted to mysql-connector-c. > > > > Did you run revdep-rebuild on libmysqlclient? The libs are not 100% ABI > > compatible. > > Rebuilding net-analyzer/nagios-check_mysql_health didn't help, but after > checking the deps and rebuilding dev-perl/DBD-mysql it works properly now. > > Maybe we should add a note about this change? There is a note, however the dependency order was not correct and mysql-connector-c has to be scheduled first. Once I get everything set in ~arch, I'll write up a news article. MariaDB 10.1.34 has the order corrected for others who install.
Thank you very much!
*** Bug 659020 has been marked as a duplicate of this bug. ***
Worked for me with MySQL-5.7.22 -- wish I had known of this earlier -- wasted lots of time with this one.
