Dear Maintainer,
we are running debian 12 with mariadb-server version 1:10.11.11-0+deb12u1.
munin-plugins-core is at 2.0.76-1~bpo12+1
Output of SHOW ENGINE INNODB STATUS; contains this section, which is lacking newline
- ------------------------
LATEST FOREIGN KEY ERROR
- ------------------------
2025-05-15 03:30:03 0x7fb440c0d6c0 Error in foreign key constraint of table `db`.`user_acl`:
Alter table `db`.`user_acl` with foreign key `user` constraint failed. Referenced table `db`.`user` not found in the data dictionary.------------
TRANSACTIONS
- ------------
Trx id counter 12112974616
Purge done for trx's n:o < 12112974486 undo n:o < 0 state: running
History list length 7
Thus breaking parsing of mysql_ plugin.
I have created this patch, which fixed it for us
diff -ur a/mysql_ b/mysql_
- --- a/mysql_ 2024-05-28 17:37:27.000000000 +0200
+++ b/mysql_ 2025-05-15 15:22:54.401920864 +0200
@@ -1351,6 +1351,9 @@
# remove non-standard (and useless) "---OLDEST VIEW---" section, as it breaks the plugin
s{^---OLDEST VIEW---\v.*?^-----------------\v}{}ms;
+ s{\.------------}{.\n------------}mg;
+
+
# Add a dummy section to the end in case the innodb status output
# has been truncated (Happens for status > 64K characters)
$_ .= "\n----------\nDUMMY\n";
Should this be reported upstream?
Thanks,
Libor
*** Reporter, please consider answering these questions, where appropriate ***
* What led up to the situation?
* What exactly did you do (or not do) that was effective (or
ineffective)?
* What was the outcome of this action?
* What outcome did you expect instead?
*** End of the template - remove these template lines ***
- -- System Information:
Debian Release: trixie/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 6.12.25-amd64 (SMP w/12 CPU threads; PREEMPT)
Kernel taint flags: TAINT_USER, TAINT_OOT_MODULE
Locale: LANG=cs_CZ.UTF-8, LC_CTYPE=cs_CZ.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages munin-plugins-core depends on:
pn munin-common <none>
ii perl 5.40.1-3
Versions of packages munin-plugins-core recommends:
pn libnet-snmp-perl <none>
Versions of packages munin-plugins-core suggests:
ii acpi 1.8-1
pn conntrack <none>
pn default-mysql-client <none>
ii ethtool 1:6.14-2
ii hdparm 9.65+ds-1.1
pn libcache-cache-perl <none>
ii libdbd-mysql-perl 4.053-1
pn libdbd-pg-perl <none>
ii libhttp-date-perl 6.06-1
pn liblwp-useragent-determined-perl <none>
ii libnet-dns-perl 1.50-1
ii libnet-ip-perl 1.26-4
pn libnet-irc-perl <none>
pn libnet-ldap-perl <none>
ii libnet-netmask-perl 2.0002-2
pn libnet-telnet-perl <none>
ii libwww-perl 6.78-1
ii libxml-parser-perl 2.47-1+b3
pn libxml-simple-perl <none>
ii lm-sensors 1:3.6.2-2
pn logtail <none>
ii net-tools 2.10-1.1
ii python3 3.13.3-1
ii ruby 1:3.3+b1
ii smartmontools 7.4-3
-----BEGIN PGP SIGNATURE-----
iQJJBAEBCAAzFiEEPGZVVU37tFmB0TQv8O+MbsKfR44FAmgl7GQVHGxpYm9yLmts
ZXBhY0BiY29tLmN6AAoJEPDvjG7Cn0eOJ2YP/RzrrZJ3oXdMOognrxp6ywV4ege7
vr+F41JV4oH2jvgGM5sr7XjvTsJRTaRG60EaXmc9gUVsqlC9uLg8UslIEQWSdQ1e
z7VMaBQRwbVFsgCOiGcaYWbFBj2GDglpisvP/Y0/D91K0JcHL2OOm2W3Li08xSM/
pbb1+fdCRPTw+vbuVw2wWe/N6V3rDqgVh2dt4piklXSHXpQQPLcZgNOLnZ4XHu/A
pMN7hy4sgC3CATwmjDiQf35+Jb19VE4dVL4sKGXKZMlglFFscnacbk7KJclq2dhb
N20Kw24Ym2ctEHrb2AJsqssWrSQo/UkHgL67qEJNTxG4yrKIgLtexdJbK1dEwq87
kmrN9rhJ7OrlR15sK0C4JSP2zH0ZLyFXUm6WfA010q5I7zHjKMuGcnZwAZ66ERDm
mCciznQHZ1dzd4qc9j7S/r3B8ChO3QnvFefNFPGywZzW0VxMJ3kO0s8yJUSlRoiE
Sh7I7FDgndqSV5QkinZNbiIq9xzoyhoApD5wBEZ1vNYcsRVrTpTwfuyyn0CBMs9g
zvSw/JYala/8zwMq6uWg5DVzs6PzAgTqmVOtu1s+qR0m9Cu+9W1v9lQm0YvHyPE0
SJVUutyg0gDStJWTjmRSS0h2Ji+NPAIyqhWHt/EZbo+t2JL6wiEGt0NevwA3q34u
03ErL9W99cUmwQ01
=Jczx
-----END PGP SIGNATURE-----