Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26297

[ERROR] mysqld: Incorrect information in file: './sys/sys_config.frm' after SELECT query and using small tmp-disk-table-size

    XMLWordPrintable

    Details

      Description

      CLI Based execution seems required. Also, using SET GLOBAL does not produce the same issue (i.e. direct mysqld option is required)

      # mysqld options required for replay:  --tmp-disk-table-size=1024
      SELECT * FROM information_schema.TRIGGERS ORDER BY trigger_name;
      

      Leads to:

      10.6.4 42b9daaea7ece6155558f7c3bf638e8e175a7ff7 (Optimized)

      2021-08-03 17:42:47 0 [Note] /test/MD260721-mariadb-10.6.4-linux-x86_64-opt/bin/mysqld: ready for connections.
      Version: '10.6.4-MariaDB'  socket: '/test/MD260721-mariadb-10.6.4-linux-x86_64-opt/socket.sock'  port: 34790  MariaDB Server
      2021-08-03 17:42:47 0 [Note] InnoDB: Buffer pool(s) load completed at 210803 17:42:47
      2021-08-03 17:43:29 4 [ERROR] mysqld: The table '(temporary)' is full
      2021-08-03 17:43:29 4 [ERROR] mysqld: Incorrect information in file: './sys/sys_config.frm'
      2021-08-03 17:43:29 0 [Note] /test/MD260721-mariadb-10.6.4-linux-x86_64-opt/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown
      

      Bug confirmed present in:
      MariaDB: 10.6.4 (dbg), 10.6.4 (opt), 10.7.0 (dbg), 10.7.0 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.39 (dbg), 10.2.39 (opt), 10.3.30 (dbg), 10.3.30 (opt), 10.4.20 (dbg), 10.4.20 (opt), 10.5.11 (dbg), 10.5.11 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.34 (dbg), 5.7.34 (opt), 8.0.24 (dbg), 8.0.24 (opt)

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration