Tag Archives: sql
As mentioned here, I noticed some odd behaviour from minidlna, where it was hogging the CPU. Now minidlna have filled up the filesystem /var two times for me, so what’s up?
A closer inspection of /var showed that it was the logfile /var/log/minidlna.log that was growing out of control, with a size of several hundreds of MB. The logfile was filled with errors like these:
INSERT into OBJECTS (OBJECT_ID, PARENT_ID, REF_ID, DETAIL_ID, CLASS, NAME) VALUES ('64$0$1D', '64$0', NULL, 0, 'container.storageFolder', 'stuff...')
Some googling suggested that there might be a problem with the ownership of the database file, specifically if it was owned by root… Everything in /var/lib/minidlna on my system was owned by root, so I changed ownership to the user/group minidlna: