Still no one to has a hint for me? No one else has this problem with migrating the mysql/mariadb form LE10 to LE11????
Thanks! Thats approximatly the same problem I have - except I do not use docker. But the rest sounds exactly what I've tried....
I jsut couldn't imagine that I'm the only one who'd has this problem....
I was able to solve the error by running the mentioned "mysql_upgrade" on my MariaDB docker instance. Will have to keep that command in my back pocket, as this was the first Kodi upgrade that failed. All previous Kodi/database upgrades didn't require any direct/user touching of the (same) database (eg. when I went from LE9 -> LE10 it was seamless)
Sounds good .. and you've your solution.
Unfortunatly this isn't working on my databaseinstallation on my RPi4. Libreelec migration from 10->11 seems not possible, as there is no mysql_upgrade script available on the Libreelec installation, as I understood chewitt's hint (an I didn't find this script just to fit it for my installation). I've migrated now several Libreelecversions with the "onboard" mysql-databse without any problems until now, just like you did.
Or am I wrong at all?
Thanks a lot - but - uhh -that's the problem! I run a mariadbserver und my central RPi 4 with and since LE 9 - not a "client" as I'd like to say!
Upgrading the DB server was never a problem: from Kodi 17->18, 18->19, but 19-20: from LE 10 to LE 11 is failing - as I described it in my threads.
I tried this on my Raspi 4 with libreelec 11 - but I got: "-sh: mysql_updgrade: not found" (same with "mariadb-upgrade). Is there no "mysql_upgrade" possible?
Thanks a lot!
I have same problem on my RPi4. Tried a lot:
- migrating from a client with different OS
- checking/editing relevant mariadb users rights in every thinkable way
- etc. etc.
- MyMusic 82 seems to be untouched and is working well
- I've mariadb 10.11.2 that seems to be the latest stable version for me
Seems that at leqst views and triggers are not to be migrated.
Found this in the kodi.log:Code
mysql_upgrade/mariadb-upgrade is not workig:
"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax..."
After trying several things (altering rights etc.) of the mysql(mariadb users etc. I didn't succeed.
Thanks to chewitt, I know now why.
But still the migration problem left.... ("error <general>: SQL: Can't determine list of routines to drop." like to see above)
EDIT: I've tried almost everything what I could find in the net (excep mysql_upgrade script, that is obviously not content of libreelec (11) and I'didn't find any sources for the content of the script..). But nothing fixed the problem.
Is there no one who can give me a clue how to fix this problem un a RPi4 with Librerelec 11 (an nothing else on it?) Or how to "fore mysql_upgrade" the actual mariadb 10.11.2 without the "mysql_upgrade" script an/or the modules not installed with Libreelec 11?
Upgraded my Pi 4 that uses MariaDB from LE10 to LE11 using the built-in settings app, but after the reboot I can now only see my Music library
Do we need to do anything special to trigger a database update?Code
2023-03-10 12:40:18.075 T:839 info <general>: MYSQL: Connected to version 10.6.12-MariaDB-log 2023-03-10 12:40:18.145 T:839 info <general>: Running database version MyMusic82 2023-03-10 12:40:18.178 T:839 error <general>: Unable to open database: MyVideos121 (Unknown database 'MyVideos121') 2023-03-10 12:40:18.211 T:839 error <general>: Unable to open database: MyVideos120 (Unknown database 'MyVideos120') 2023-03-10 12:40:18.270 T:839 info <general>: Old database found - updating from version 119 to 121 2023-03-10 12:40:54.831 T:839 info <general>: Attempting to update the database MyVideos121 from version 119 to 121 2023-03-10 12:40:56.459 T:839 error <general>: SQL: Can't determine list of routines to drop. 2023-03-10 12:40:56.460 T:839 error <general>: Exception droping old analytics from MyVideos121 2023-03-10 12:40:56.492 T:839 error <general>: Unable to open database: MyVideos118 (Unknown database 'MyVideos118') 2023-03-10 12:40:56.525 T:839 error <general>: Unable to open database: MyVideos117 (Unknown database 'MyVideos117') 2023-03-10 12:40:56.588 T:839 info <general>: Old database found - updating from version 116 to 121 2023-03-10 12:40:56.638 T:839 error <general>: SQL: Can't create database for copy: 'MyVideos116' (1007) 2023-03-10 12:40:56.638 T:839 error <general>: Unable to copy old database MyVideos116 to new version MyVideos121
"interestingly, i also see some failed queries indicate missing views..."
I've upgraded today from Kodi 19.5. to 20. But mariadb migration is obviously failing. The migration from video119 to 121 caught all tables, but none of the views and none of the triggers - so nothing is shown in the kodi libraries. The Music82 tables seem untouched and are working well.
I found sveral similar entries here an elsewhere, but I couldn't get my mariadb running correctly.
I (re-)tried the migration several times (librelec or kodi-windows clients), but all the same result.
The kodi Log shows the following error:
info <general>: Attempting to update the database MyVideos121 from version 119 to 121
2023-03-10 17:51:20.204 T:998
error <general>: SQL: Can't determine list of routines to drop.
The often mentioned solution "mysql_upgrade" gives me:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql_upgrade' at line 1
But here I couldn't find a hint that helped me....
MariaDB Version is 10.11.2 - I think it's uptodate. The root and the kodi user got all neccesary rights granted as I read in several forums - but who knows? Any help is apriciated!
If needed, I'll try to provide a full debug error.
I'm migrating kodi now the third time and I had no problem with the databasemigration before.
Thanks for support!
Hope I'm right here....
I have an RPi 4 4GB RAM und the same behaviour/issue opening several smb-directories (not files!) on a NASCode
and starting filmclips (mp4/m4v), crashing my LE10.0.2 (I changed to finally from LE9.X.X ) afterwards, when I stop them and start to watch a new one (unusually also having this caching circles for a long time - I'd tried several mem/cache/buffer settings in the advancedsettings.xml - no significant changes). Interesting fact I observed today the first time: Leaving Kodi untouched for serveral minutes (what I didn't before examening this problem), the log shows up with "Samba is idle. Closing the remaining connections" -> Et voilá, no more problems (at least I started serveral clips without any problems). Could this behaviour be associated with this (smb-?)problem - or is this something totally different and shows up only the same error-message?
Thanks a lot!
True. I had to change the folder from "vdr" to "tvh" in "Picon path" setting.
Great, when it fitted to you! But that was not quite my problem. Everthing within TVH was correct - but there was a change in the naming within the share - therefore the path for the channelicons in KODI (!) did not work further (and it seemed, it blocked everything else witihn the PVR settings... ?!? I don't know.....).., I changed the path to the share from ".../Picons/... " to ".../picons/...." that caused the errors in the logfile....
After that everythings worked smoothly... but, I downgrades to LE 9.2.6 for usability reasons ... for the moment at least ....
Finally I soluted the screensaver "german mutated vowel" problem within the screensaver Addon (it was a mixture of countrycodes/locales behaviour and differences between IPTC and XMP Data mechanisms within the Addoncode)
Obviously there was a change in the code within the pointed data fields from python2 to python3 , that caused my troubles.
Changing the IPTC "title" value from "headline" to "object name" solved this in the end.
Thanks for any support given here!
FYI (fixed before returning to LE 9.2.6.): Problem fixed. Wrong path within the Settings ->Menu/OSD->symbols->folder for Channelsymbols.
Ok. Then we go the same way
And: I'll would certainly publish any solutions I find, that's for sure.
But I hope, that you can understand my point of you, having a system, that fits your purposes.... at least for a while.
As I mentioned several times: I appreciate all of your/the community support in the LE support!
If you think that bugs are going to magically disappear by themselves... That's not gonna happen. But enjoy LE 9.x.
Yes, thats right. That's not the point. But, why are you insulting/critizing me? The only thing I say is, that I've spent a lot of time in soluting a lot of problems after the upgrade from LE 10 - without any success. And now, I've no more time for that ... for the moment. That's all. Probably I'll have another try in the future - that was my statement! Sorry, when You felt different to that.
Why should I use a system, that is not working for my purposes, while LE 9.2.6 ist doing it?
And believe me: If I'd seen a chance to solve all of this by posting the debug-log, I'd already done it.
And the last thing I mentioned (scrapers stuff) was only a systembehaviour I observed.. nothing else.
Last Farewell to LE 10... (at least for a while)
As I prepared to save some data form my LE 10, I became aware of another "bug", that I could reproduce several times. As you know, all my problems startet after changing to LE 10 vrom LE 9.2.6. Last probs were, that Kodi restartet with problems crashing by fast forward and backward videofiles and now by scraping videofiles with german titels with muted vowels and "ß" (as I guess, because the log ends every time with that). Finally I tried to change the scraper from "The Movie Database Python" to "Universal Movie Scraper" - and "Bang" -> TV Headendserver ends with the message, that it doenst work correkt anymore (same with "The Movie Database" (without Python)). The only solution was to reinstall the TVH Server to make it work again.
Finally: I really don't know, if the german vowels and the "ß" are really responsible for that behaviour at last, but it ist the only thing I saw everytime as last row in the (Debug)Logs.
Ok. Thanks a lot for your support and help.
I wanted to check your suggestions out.
EDIT: By the way, some of the mentioned MP4 Files were created by myself, so I think I know what they contain...
But: In the meantime the situation is going worse and several things are going wrong for what reason ever: Now the scrapers (video, muscvideos) going "crazy" since the last addon updates. Kodi crashes now by scraping Files and folders with titles that contain German mutes vowels like ä, ü, ö and "ß". I tried every possible setting - no way succeeded.
All in all the usability for me is now going to zero (together with my former posted screensaverproblems). I'll downgrade back to 9.2.6 - where all the "with LE 10 lost functions" worked brilliant and wait, until I've again more "patience" to try an upgrade again....
MP4/all Video clips seem now to crash/freeze with fast forward/backwards or using jump marks in Librelec 10.0.1 (Kodi 19.3). It happens only on my RPi with LE, on my 3 other windowsclients with Kodi 19.3. all works as specified - with the same MP4 files/Video clips from the same source. There's no crash log written by the system, but: The last row in kodi.old.log says "WARNING <general>: OutputPicture - timeout waiting for buffer". Seems to be a memory problem?
I didn't find a fitting hint in my (short, I've to admit ) search in the web to my problem. Again, I can't remember this behaviour on LE 9.2.6. Do I have to change something within the configuration with LE 10?
Thanks a lot!
Obviously ... I searched this file with wrong parameters, so I just find "/storage/.config/samba.conf".
My fault. Anyway, thank you for this information....
Still guessing, where this error-messages in the log come from....