MariaDB addon not starting

SilkBC · February 8, 2025 at 5:42 PM

The MariaDB service on my LibreElec 12.02 is suddenly not starting, so none of my media is showing up currently. I have uninstalled and re-installed the MariaDB serice add-on, but still no jot. I have enabled debugging and rebooted, but I see no errors in the kodi.log about the MariaDB service; in fact, it seems to show that it started up OK:

Code

2025-02-08 09:20:58.400 T:1354     info <general>: CAddonMgr::FindAddons: service.mariadb v12.0.0.4 installed
2025-02-08 09:20:58.400 T:1354     info <general>: CAddonMgr::FindAddons: service.mariadb v12.0.0.4 installed
2025-02-08 09:20:59.011 T:1354    debug <general>: LocalizeStrings: loaded 4 strings from file /storage/.kodi/addons/service.mariadb/resources/language/English/strings.po
2025-02-08 09:20:59.317 T:1354    debug <general>: CServiceAddonManager: starting service.mariadb
2025-02-08 09:20:59.320 T:1392    debug <general>: CPythonInvoker(13, /storage/.kodi/addons/service.mariadb/default.py): start processing
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13, /storage/.kodi/addons/service.mariadb/default.py): the source file to load is "/storage/.kodi/addons/service.mariadb/default.py"
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13): full python path:
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):   custom python path:
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):     /storage/.kodi/addons/service.mariadb
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):   default python path:
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):     /usr/lib/python311.zip
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):     /usr/lib/python3.11
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):     /usr/lib/python3.11/lib-dynload
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):     /usr/lib/python3.11/site-packages
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13): adding args:
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13):
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13, /storage/.kodi/addons/service.mariadb/default.py): entering source directory /storage/.kodi/addons/service.mariadb
2025-02-08 09:20:59.492 T:1392    debug <general>: CPythonInvoker(13, /storage/.kodi/addons/service.mariadb/default.py): instantiating addon using automatically obtained id of "service.
2025-02-08 09:20:59.503 T:1381    debug <general>: -->Python Interpreter Initialized<--
2025-02-08 09:20:59.503 T:1381    debug <general>:

Display More

That is all there is in the log about MariaDB. Trying to start it automatically shows no error either; it just returns back to the command line like it started without issue.

Your insight is greatly appreciated!

SilkBC · February 8, 2025 at 5:54 PM

UPDATE: Here is what the mysqld.log says:

Code

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

Display More

I have tried changing the "thread_stack" value in my.cnf but that does not resolve the error. Not sure what else the issue could be? Could it have to with the size of the database?

**mglae** · February 8, 2025 at 6:25 PM

Addon 12.80.1.0 with MariaDB 11.4.3 is the last one working.

I'm not using MariaDB but had the addon installed at one of my test installs and saw it restarting.

SilkBC · February 8, 2025 at 6:55 PM

Quote from mglae

Addon 12.80.1.0 with MariaDB 11.4.3 is the last one working.
I'm not using MariaDB but had the addon installed at one of my test installs and saw it restarting.

Hrm, OK, there is something weird with my system then. My Addon is reporting version 12.0.0.4 with MariaDB 11.4.5.

System info shows I am running Libreelec 12.0.2 (sorry, I missed a decimal in my original post) with Kodi 21.2

The addon was installed from the Libreelec repository. Is there somewhere else I can get the latest from (i.e., 12.80.1.0)?

SilkBC · February 8, 2025 at 6:59 PM

Hrm, OK, so I see MariaDB was updated to 11.4.5 two days ago, but you mention that 11,4,3 is the last one working. Is there a way to revert back to using MariaDB 11.4.3?

denix · February 8, 2025 at 8:36 PM

Same here

Anyway, to go back to a working version, simply select the add-on in the interface, go to versions, and select 12.0.0.3 . This is working fine for me.

**heitbaum** · February 9, 2025 at 1:10 AM

Revert queue for le12. https://github.com/LibreELEC/LibreELEC.tv/pull/9776

Le13 will need further work - due to depends for a revert (libfmt/c23) - so will look in to the fix / upstream issue

**heitbaum** · February 9, 2025 at 1:33 AM

Raised upstream https://jira.mariadb.org/browse/MDEV-36051

**chewitt** · February 9, 2025 at 8:26 AM

Revert is merged.

olm · February 9, 2025 at 8:48 AM

Hmm - have the same problem, fiddled with it on my own for a while and might have ruined something, anyway downgraded first mariadb pluging, but still have the same errors in both kodi.log and mysqld.log, then downgraded to libreelec 12.0.0.1 and still have same errors. I suspect it is something else eg permissions in the filesystem.

mysqld.log

Code

2025-02-09  8:41:43 0 [Note] Starting MariaDB 11.4.2-MariaDB source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 2509
2025-02-09  8:41:43 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2025-02-09  8:41:43 0 [Note] InnoDB: Number of transaction pools: 1
2025-02-09  8:41:43 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-02-09  8:41:43 0 [Note] InnoDB: Using Linux native AIO
2025-02-09  8:41:43 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
2025-02-09  8:41:43 0 [Note] InnoDB: Completed initialization of buffer pool
2025-02-09  8:41:43 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2025-02-09  8:41:43 0 [Note] InnoDB: End of log at LSN=37776
2025-02-09  8:41:44 0 [Note] InnoDB: Opened 3 undo tablespaces
2025-02-09  8:41:44 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2025-02-09  8:41:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-02-09  8:41:44 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2025-02-09  8:41:44 0 [Note] InnoDB: log sequence number 37776; transaction id 4
2025-02-09  8:41:44 0 [Note] InnoDB: Loading buffer pool(s) from /storage/.kodi/userdata/addon_data/service.mariadb/data/ib_buffer_pool
2025-02-09  8:41:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-02-09  8:41:44 0 [Note] Plugin 'wsrep-provider' is disabled.
2025-02-09  8:41:44 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
2025-02-09  8:41:44 0 [Note] InnoDB: Buffer pool(s) load completed at 250209  8:41:44
2025-02-09  8:41:44 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2025-02-09  8:41:44 0 [Note] Server socket created on IP: '0.0.0.0'.
2025-02-09  8:41:44 0 [Note] Server socket created on IP: '::'.
2025-02-09  8:41:44 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
2025-02-09  8:41:44 0 [ERROR] Aborting

Display More

olm · February 9, 2025 at 8:54 AM

Ahh - service.mariadb/data/mysql was empty except for db.opt replaced it with an old filesystem copy and mysql started - so now my best guess is that something went missing on the upgrade (eg a new system table required)

**heitbaum** · February 9, 2025 at 10:12 AM

12.0.0.5 is available now