Kodi Community Forum

Full Version: EPG database excessive writing
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
System: Kodi 14.2, Openelec 5.0.8 (latest stable), VDR, 3.5" HDD 7200 rpm, ext4, USB DVB-T adapter
After Kodi startup it writes for another 2-3 minutes in /storage/.kodi/userdata/Database/Epg8.db-journal.
Write rate is low, around 300kB/s, but it seems to have a lot of transactions and probably syncs often.
This behaviour started recently, don't know why. Resetting the epg database from menu didn't help. Tried deleting Epg8.db file and starting Kodi, it was back to normal but after a couple of days started again.
There are around 40-50 channels in nthe list, not all of them have Epg.
Earlier the whole process was not even noticeable, onscreen progress bar for channels and epg update takes only a couple of seconds.
Am i looking at some kind of recurring database corruption?

Write pattern:
Code:
19:47:20.943519 kodi.bin(10526): WO /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:20.944136 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.176001 kodi.bin(10526): CW /storage/.kodi/userdata/Database/Epg8.db-journal (deleted)
19:47:21.176001 kodi.bin(10526): WO /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.382429 kodi.bin(10526): CW /storage/.kodi/userdata/Database/Epg8.db-journal (deleted)
19:47:21.383167 kodi.bin(10526): O /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.383365 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.383533 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.739345 kodi.bin(10526): CW /storage/.kodi/userdata/Database/Epg8.db-journal (deleted)
19:47:21.740226 kodi.bin(10526): O /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740339 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740380 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740416 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740454 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740506 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740548 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740548 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740613 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740737 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740779 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740814 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740880 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740919 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740958 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.740958 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.963217 kodi.bin(10526): CW /storage/.kodi/userdata/Database/Epg8.db-journal (deleted)
19:47:21.964193 kodi.bin(10526): O /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.964352 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.964402 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.964446 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.964490 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.964716 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.964716 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:21.964923 kodi.bin(10526): W /storage/.kodi/userdata/Database/Epg8.db-journal
19:47:22.328561 kodi.bin(10526): CW /storage/.kodi/userdata/Database/Epg8.db-journal (deleted)

Excerpt from Kodi startup log (2 minutes after EPG thread start it is still writing to Epg8.db journal):
http://paste.ubuntu.com/12556927/
I would not use Kodi's database for epg at all.