• Bug#1105823: munin-plugins-core: mysql_ plugin parsing broken on innodb

    From =?utf-8?b?TGlib3IgS2xlcMOhxI0=?=@21:1/5 to All on Thu May 15 15:40:01 2025
    Package: munin-plugins-core
    Version: 2.0.76-1~bpo12+1
    Severity: important

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA256

    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-----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)