I have been running OE for many years, on several different generations of hardware (AMD E45, RPi1, Matrix TBS2910 amd RPi2).
Most recently, my main installation has been running OE v6.0.3 on the RPi2.
I have just attempted to update that system to LE7.0.2 by placing the LibreELEC-RPi2.arm-7.0.2.tar file in the updates folder.
Following the archive extraction, md5 checks and image file copying, the system rebooted itself, as expected. First it displayed the rainbow screen, then a LibreELEC welcome splash.
Unfortunately, there was a powercut during this process.
Now, when the system boots up it gets into a loop, displaying the Kodi v16.1 Jarvis splash briefly (less than a second) approximately every ten to 15 seconds.
The system is not rebooting - an ssh session stays permanently connected.
The Kodi crash log ends as follows:
19:49:43 2233.640869 T:1962852352 NOTICE: Register - new cec device registered on cec->RPI: CEC Adapter (2708:1001)
19:49:44 2233.853760 T:1962852352 NOTICE: Running database version Addons20
19:49:44 2233.856689 T:1962852352 NOTICE: Running database version ViewModes6
19:49:44 2233.860596 T:1962852352 NOTICE: Running database version Textures13
19:49:44 2233.872559 T:1962852352 ERROR: SQL: [MyMusic56] The table does not exist
Query: SELECT idVersion FROM version
############### END LOG FILE ################
############ END kodi CRASH LOG #############
Display More
So, it would seem that my database has become corrupted.
The Database folder has the following content:
OERPi2:~ # ls -al .kodi/userdata/Database
total 6422
drwxr-xr-x 3 root root 1024 Jul 5 18:02 .
drwxr-xr-x 9 root root 1024 Jul 5 19:55 ..
-rw-r--r-- 1 root root 843776 Jul 5 06:03 Addons19.db
-rw-r--r-- 1 root root 843776 Jul 5 18:02 Addons20.db
-rw-r--r-- 1 root root 0 Jul 5 18:02 Addons20.db.OE2LE_Backup
drwxr-xr-x 2 root root 1024 Jan 1 1970 CDDB
-rw-r--r-- 1 root root 28672 Oct 25 2015 Epg10.db
-rw-r--r-- 1 root root 2711552 Oct 26 2015 MyMusic52.db
-rw-r--r-- 1 root root 352256 Oct 25 2015 MyVideos93.db
-rw-r--r-- 1 root root 32768 Oct 25 2015 TV29.db
-rw-r--r-- 1 root root 1712128 Jul 5 06:03 Textures13.db
-rw-r--r-- 1 root root 45056 Jun 12 11:06 ViewModes6.db
OERPi2:~ #
Display More
However, there is the complication that my 'real' database is held on a file server running MariaDB. The server is protected by UPS - unfortunately, the media systems are not!
Can I simply delete the remnants of the Addons20 database and the db update will restart?
Will a similar problem exist on my database server and, if so, how can I clean that up?
Other systems, still running OE6.0.3, still seem to be working correctly, with a complete database.