• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Mariadb : Incorrect definition of table mysql.column_stats

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    1
    3
    136
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      marcolefo
      last edited by

      Hi

      Since 3 days I have this error in /var/log/mysql/error.log 3 times by second :

      2025-04-03 12:11:38 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
      2025-04-03 12:11:38 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
      

      I have done what I have written here :
      https://forums.fogproject.org/topic/17849/fogtaskscheduler-100-cpu

      Do you think there is a link ?

      Other symptom, after clone a system to the server, the image stays in /images/dev/<@mac> and doesnโ€™t go to /images/.

      Thanks ๐Ÿ™‚

      FOG : 1.5.10.1655
      OS : Debian GNU/Linux 12

      1 Reply Last reply Reply Quote 0
      • M
        marcolefo @marcolefo
        last edited by

        @marcolefo

        Okay nothing to do with FOG ๐Ÿ˜‰

        ALTER TABLE mysql.column_stats MODIFY histogram longblob;
        ALTER TABLE mysql.column_stats MODIFY hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB');
        

        Sorry for the noise

        FOG : 1.5.10.1655
        OS : Debian GNU/Linux 12

        1 Reply Last reply Reply Quote 0
        • M
          marcolefo
          last edited by

          @marcolefo said in Mariadb : Incorrect definition of table mysql.column_stats:

          Incorrect definition of table mysql.column_stats

          Oh ! There was an update of Mariadb

          2025-04-03 12:28:20 status installed mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1
          2025-04-03 12:28:20 remove mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1 <none>
          2025-04-03 12:28:20 status half-configured mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1
          2025-04-03 12:28:20 status half-installed mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1
          2025-04-03 12:28:20 status config-files mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1
          

          I will check that

          FOG : 1.5.10.1655
          OS : Debian GNU/Linux 12

          M 1 Reply Last reply Reply Quote 0
          • M
            marcolefo @marcolefo
            last edited by

            @marcolefo

            Okay nothing to do with FOG ๐Ÿ˜‰

            ALTER TABLE mysql.column_stats MODIFY histogram longblob;
            ALTER TABLE mysql.column_stats MODIFY hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB');
            

            Sorry for the noise

            FOG : 1.5.10.1655
            OS : Debian GNU/Linux 12

            1 Reply Last reply Reply Quote 0
            • [[undefined-on, M marcolefo, ]]
            • [[undefined-on, M marcolefo, ]]
            • 1 / 1
            • First post
              Last post

            188

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright ยฉ 2012-2024 FOG Project