[SOLVED] - Kodi in reboot loop using Mysql Database

Help and Support Raspberry Pi
1

Hi,
i made a fresh install on my new Pi2,
i put my config files advancedsettings.xml, sources.xml … i had on my old Pi working with Kodi too

But Kodi keep restarting after crashing every minutes
here is full kodi.log : Debian paste error
there is no error at the end
i can navigate in the menus before it crashes

if you have any idea.
or need more infos

thanks

2

Pi 2 consumes more power than the original Pi. Are you sure your power supply is good? Please see Wiki - OSMC for some more information on this.

Lastly, I would try not copying over your settings and starting fresh to see if this is causing the issue

Sam

3

Thanks for your reply

my power supply provide 2A as required.
Note, it’s not the whole PI2 who keeps rebooting but only the Kodi process

i try to test with different settings and it appears if i remove the sql database the process doesn’t reboot anymore

but as i have several kodi running i need the SQL feature

4

What version of xbmc/kodi are running on the other installs? The Pi may be trying to update database versions which is very power hungry. If possible the database update would be better run on a more powerful system

5

It’s the same version of Kodi using _videos90 as datavbase version

6

Try starting with a clean .kodi folder by renaming /home/osmc/.kodi to .kodi.bak or whatever then restart kodi
Next copy advancedsettings over to /home/osmc/.kodi/userdata/advancedsettings.xml and restart Kodi, does it start?

7
  • renaming /home/osmc/.kodi to .kodi.bak
    => Kodi start
  • copy advancedsettings over to /home/osmc/.kodi/userdata/advancedsettings.xml
    => Kodi keeps rebooting
8

The other installs work? That’s strange. Grab a debu log from the clean install with just advancedsettings copied over

9

Yes the other ones with kodi on Pi1 works fine.

here it is : Debian paste error

10

OK, I’m at a loss you can see it querying the movie database right at the end. Not sure of your skill level but assuming MySql still has the earlier database versions you could try dropping the video90 database then open osmc to have it upgrade your database to the newest version. Hopefullu I make sense :smile:

Only other thought is to check /usr/share/kodi/system/advancedsettings.xml for corruption or a setting causing problemsbut I see nothing in my version. I see some image manipulation going on in your version. Mine contains:

<advancedsettings>
   <video>
     <defaultplayer>dvdplayer</defaultplayer>
     <defaultdvdplayer>dvdplayer</defaultdvdplayer>
   </video>
 </advancedsettings>
11

Hi again,
i made a fresh install again starting from the windows installer
here is 5 new kodi.log, you can see each time they don’t stop at the same point:
http://paste.osmc.io/mihozefuro
http://paste.osmc.io/nodejetami
http://paste.osmc.io/apozokarap
http://paste.osmc.io/ibarerapup
http://paste.osmc.io/oreqewubal

12

more info :
I stoped mediacenter then tried to launch kodi using the command line :

osmc@osmc:~/.kodi/userdata$ /usr/lib/kodi/kodi.bin --standalone -fs --lircdev /var/run/lirc/lircd
Segmentation fault
osmc@osmc:~/.kodi/userdata$ echo $?
139

13

Have you enabled a PVR? My Pi2 goes into a loop when I enable Mythtv.

I assume it is in the PVR addon as I also tried with Openelec and it also started to loop as soon as I enabled Live TV mode in settings.

14

Hi,
nope pvr is not enabled

15

What happens if you remove /userdata/advancedsettings.xml then set up a local video library? I’ve been assuming it’s a database problem and the logs indicate it seems to happen when accessing the video database.
Is it the database or some data processing/handling task which is crashing, maybe an image causing problems when it is being resized by the /system/advancedsettings.xml There are 2 advancedsettings files if you weren’t aware one in userdata/ and one in /usr/share/kodi/system/ your system one has some image size restrictions which aren’t in my copy, not sure why but I’ using a Pi B+ while you have a Pi2

16

Hi again,

here some news, i managed to make it works :smile:

I went on phpmyadmin and run a check on my database, it appears a view was marked as crashed

While it didn’t bothered the others Kodi on my network running on windows and Pi B+
It seems the kodi with osmc alpha4 on Pi2 can’t handle this kind of error

So i executed a “repair table” on each table of the database and now everything is fine

Thanks again for your support.
Let’s hope this thread could help others :smile:

17

For those that don’t want to install phpmyadmin, repairing tables can be done via the command line quite easily as well

Sam

18

I am having the same exact problem with my RPi2 (but not my RPi), could someone explain on how to repair the tables?

19

Had the same error, random crashes of kodi under windows with connection to the MySQL Database. I could not repair, so i removed the tables and let Kodi create new ones