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?
Posts by SilkBC
-
-
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)?
-
UPDATE: Here is what the mysqld.log says:
Code
Display More2025-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
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?
-
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
Display More2025-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>:
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!
-
My LE version is 'LibreELEC (official): 9.2.6 (Generic.x86_64)'. Here is my output from 'ir-keytable':
CodeFound /sys/class/rc/rc0/ (/dev/input/event9) with: Name: Media Center Ed. eHome Infrared Remote Transceiver (1784:0008) Driver: mceusb, table: rc-rc6-mce lirc device: /dev/lirc0 Supported protocols: lirc rc-5 rc-5-sz jvc sony nec sanyo mce_kbd rc-6 sharp xmp imon rc-mm Enabled protocols: lirc nec rc-6 bus: 3, vendor/product: 1784:0008, version: 0x0101 Repeat delay = 500 ms, repeat period = 125 ms
I ran 'ir-keytable -t -s rc0' still nothing comes up when I press the "Exit" or "Menu" buttons on my Harmony remote.
I have nothing in my /storage/.config/rc_keymaps folder; what *should* be in there? My actual MCEUSB remote "just works" without any files needing to be in there.
-
Hello,
I have a MCE remote (HA-IR01SV) that works perfectly with LibreElec, however when I use my Harmony Hub remote, most buttons work except the "Exit" and "Menu" buttons (which I am wantingto have mapped to "Back" and "Context Menu", respectively)
In my Harmony software, I have the "Microsoft MCE Keyboard" and "Microsoft Windows Media Center SE" added as devices. When I try to map *anything* to the "Exit" or "Menu" keys, nothing registers (I run 'ir-keytable -t' and see nothing; same when I run 'irw'). Oddly, if I try to map, say "C" (for "Context Menu") from the "Microsoft MCE Keyboard" to any other key which already works with something else, nothing registers when I press it.
I should note that the actual MCE remote I have works without issue, and when I was running Kodi on Ubuntu up to about 3-4 months ago, the Harmony Remote was working perfectly as well (i.e., "Menu" was working as the Context menu)
I have edited my 'keyboard.xml' file in /http://storage.kodi/userdata/keymaps/keyboard.xml to add '<menu>C</menu>' to the '<keybaord></keyboard>' section under "Global", and even restarted the whole machine, but still nothing registers.
Any insight or advise greatly appreciated!
Thanks, in advance.