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

Thread stack overrun: 8366744 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.". Some plugins may be not loaded

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 11.4.4, 11.4.5, 10.5, 10.6, 10.11
    • 10.11, 11.4, 11.8
    • Server
    • None
    • Linux LibreELEC

    Description

      With 11.4.3 the server starts correctly with a 256K thread_stack but with 11.4.4 and 11.4.5 the error of 8M is occurring. This was reported by one of our users when we updated the package from 11.4.3 to 11.4.5. We have subsequently tested the builds and if was introduced in 11.4.4, rolling back to 11.4.3 (with no other changes to the development and runtime environment allows this to be reproduced.)

      https://github.com/LibreELEC/LibreELEC.tv/pull/9776
      https://forum.libreelec.tv/thread/29487-mariadb-addon-not-starting/

      2025-02-09 12:24:24 0 [Note] Starting MariaDB 11.4.5-MariaDB source revision 0771110266ff5c04216af4bf1243c65f8c67ccf4 server_uid InfkWh78H903mx/MLA8UkYYTjsY= as process 3504997
      2025-02-09 12:24:24 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
      2025-02-09 12:24:24 0 [Note] InnoDB: Number of transaction pools: 1
      2025-02-09 12:24:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2025-02-09 12:24:24 0 [Note] InnoDB: Using Linux native AIO
      2025-02-09 12:24:24 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
      2025-02-09 12:24:24 0 [Note] InnoDB: Completed initialization of buffer pool
      2025-02-09 12:24:24 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
      2025-02-09 12:24:24 0 [Note] InnoDB: End of log at LSN=481118
      2025-02-09 12:24:24 0 [Note] InnoDB: Opened 3 undo tablespaces
      2025-02-09 12:24:24 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2025-02-09 12:24:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2025-02-09 12:24:24 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2025-02-09 12:24:24 0 [Note] InnoDB: log sequence number 481118; transaction id 941
      2025-02-09 12:24:24 0 [Note] Plugin 'FEEDBACK' is disabled.
      2025-02-09 12:24:24 0 [Note] Plugin 'wsrep-provider' is disabled.
      2025-02-09 12:24:24 0 [Note] InnoDB: Loading buffer pool(s) from /storage/.kodi/userdata/addon_data/service.mariadb/data/ib_buffer_pool
      2025-02-09 12:24:24 0 [ERROR] Could not open mysql.plugin table: "Thread stack overrun:  8366744 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.". Some plugins may be not loaded
      2025-02-09 12:24:24 0 [Note] InnoDB: Buffer pool(s) load completed at 250209 12:24:24
      2025-02-09 12:24:24 0 [ERROR] Can't open and lock privilege tables: Thread stack overrun:  8368904 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.
      2025-02-09 12:24:24 0 [Note] Server socket created on IP: '0.0.0.0'.
      2025-02-09 12:24:24 0 [Note] Server socket created on IP: '::'.
      2025-02-09 12:24:24 0 [ERROR] Fatal error: Can't open and lock privilege tables: Thread stack overrun:  8348984 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.
      2025-02-09 12:24:24 0 [ERROR] Aborting

      Attachments

        Activity

          heitbaum Rudi Heitbaum created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Fix Version/s 11.4 [ 29301 ]
          Assignee Sergei Golubchik [ serg ]
          Priority Major [ 3 ] Critical [ 2 ]
          elenst Elena Stepanova made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          elenst Elena Stepanova made changes -
          Environment Linux Linux LibreELEC
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Michael Widenius [ monty ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.11 [ 27614 ]
          Fix Version/s 11.8 [ 29921 ]
          serg Sergei Golubchik made changes -
          Affects Version/s 10.5 [ 23123 ]
          Affects Version/s 10.6 [ 24028 ]
          Affects Version/s 10.11 [ 27614 ]
          serg Sergei Golubchik made changes -
          Description With 11.4.3 the server starts correctly with a 256K thread_stack but with 11.4.4 and 11.4.5 the error of 8M is occurring. This was reported by one of our users when we updated the package from 11.4.3 to 11.4.5. We have subsequently tested the builds and if was introduced in 11.4.4, rolling back to 11.4.3 (with no other changes to the development and runtime environment allows this to be reproduced.)

          https://github.com/LibreELEC/LibreELEC.tv/pull/9776
          https://forum.libreelec.tv/thread/29487-mariadb-addon-not-starting/

          2025-02-09 12:24:24 0 [Note] Starting MariaDB 11.4.5-MariaDB source revision 0771110266ff5c04216af4bf1243c65f8c67ccf4 server_uid InfkWh78H903mx/MLA8UkYYTjsY= as process 3504997
          2025-02-09 12:24:24 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
          2025-02-09 12:24:24 0 [Note] InnoDB: Number of transaction pools: 1
          2025-02-09 12:24:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
          2025-02-09 12:24:24 0 [Note] InnoDB: Using Linux native AIO
          2025-02-09 12:24:24 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
          2025-02-09 12:24:24 0 [Note] InnoDB: Completed initialization of buffer pool
          2025-02-09 12:24:24 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
          2025-02-09 12:24:24 0 [Note] InnoDB: End of log at LSN=481118
          2025-02-09 12:24:24 0 [Note] InnoDB: Opened 3 undo tablespaces
          2025-02-09 12:24:24 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
          2025-02-09 12:24:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
          2025-02-09 12:24:24 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
          2025-02-09 12:24:24 0 [Note] InnoDB: log sequence number 481118; transaction id 941
          2025-02-09 12:24:24 0 [Note] Plugin 'FEEDBACK' is disabled.
          2025-02-09 12:24:24 0 [Note] Plugin 'wsrep-provider' is disabled.
          2025-02-09 12:24:24 0 [Note] InnoDB: Loading buffer pool(s) from /storage/.kodi/userdata/addon_data/service.mariadb/data/ib_buffer_pool
          2025-02-09 12:24:24 0 [ERROR] Could not open mysql.plugin table: "Thread stack overrun: 8366744 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.". Some plugins may be not loaded
          2025-02-09 12:24:24 0 [Note] InnoDB: Buffer pool(s) load completed at 250209 12:24:24
          2025-02-09 12:24:24 0 [ERROR] Can't open and lock privilege tables: Thread stack overrun: 8368904 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.
          2025-02-09 12:24:24 0 [Note] Server socket created on IP: '0.0.0.0'.
          2025-02-09 12:24:24 0 [Note] Server socket created on IP: '::'.
          2025-02-09 12:24:24 0 [ERROR] Fatal error: Can't open and lock privilege tables: Thread stack overrun: 8348984 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.
          2025-02-09 12:24:24 0 [ERROR] Aborting
          With 11.4.3 the server starts correctly with a 256K thread_stack but with 11.4.4 and 11.4.5 the error of 8M is occurring. This was reported by one of our users when we updated the package from 11.4.3 to 11.4.5. We have subsequently tested the builds and if was introduced in 11.4.4, rolling back to 11.4.3 (with no other changes to the development and runtime environment allows this to be reproduced.)

          https://github.com/LibreELEC/LibreELEC.tv/pull/9776
          https://forum.libreelec.tv/thread/29487-mariadb-addon-not-starting/
          {noformat}
          2025-02-09 12:24:24 0 [Note] Starting MariaDB 11.4.5-MariaDB source revision 0771110266ff5c04216af4bf1243c65f8c67ccf4 server_uid InfkWh78H903mx/MLA8UkYYTjsY= as process 3504997
          2025-02-09 12:24:24 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
          2025-02-09 12:24:24 0 [Note] InnoDB: Number of transaction pools: 1
          2025-02-09 12:24:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
          2025-02-09 12:24:24 0 [Note] InnoDB: Using Linux native AIO
          2025-02-09 12:24:24 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
          2025-02-09 12:24:24 0 [Note] InnoDB: Completed initialization of buffer pool
          2025-02-09 12:24:24 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
          2025-02-09 12:24:24 0 [Note] InnoDB: End of log at LSN=481118
          2025-02-09 12:24:24 0 [Note] InnoDB: Opened 3 undo tablespaces
          2025-02-09 12:24:24 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
          2025-02-09 12:24:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
          2025-02-09 12:24:24 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
          2025-02-09 12:24:24 0 [Note] InnoDB: log sequence number 481118; transaction id 941
          2025-02-09 12:24:24 0 [Note] Plugin 'FEEDBACK' is disabled.
          2025-02-09 12:24:24 0 [Note] Plugin 'wsrep-provider' is disabled.
          2025-02-09 12:24:24 0 [Note] InnoDB: Loading buffer pool(s) from /storage/.kodi/userdata/addon_data/service.mariadb/data/ib_buffer_pool
          2025-02-09 12:24:24 0 [ERROR] Could not open mysql.plugin table: "Thread stack overrun: 8366744 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.". Some plugins may be not loaded
          2025-02-09 12:24:24 0 [Note] InnoDB: Buffer pool(s) load completed at 250209 12:24:24
          2025-02-09 12:24:24 0 [ERROR] Can't open and lock privilege tables: Thread stack overrun: 8368904 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.
          2025-02-09 12:24:24 0 [Note] Server socket created on IP: '0.0.0.0'.
          2025-02-09 12:24:24 0 [Note] Server socket created on IP: '::'.
          2025-02-09 12:24:24 0 [ERROR] Fatal error: Can't open and lock privilege tables: Thread stack overrun: 8348984 bytes used of a 299008 byte stack, and 81920 bytes needed. Consider increasing the thread_stack system variable.
          2025-02-09 12:24:24 0 [ERROR] Aborting{noformat}
          serg Sergei Golubchik made changes -
          Status Confirmed [ 10101 ] Open [ 1 ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] Needs Feedback [ 10501 ]

          People

            monty Michael Widenius
            heitbaum Rudi Heitbaum
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.