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)
Posts by olm
-
-
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
Display More2025-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