0

Lost local DB 3 times in 2 days

Luyckx Bart

July 11, 2020 18:45

None

Follow

It occured already 3 times in 2 days that I lost the connection to the local database on /data/library/music/local. I had to reinstall Hifiberry OS each time. Luckily the music is still on the SD card and I don't need to copy it again (Which will take me more then 1 day) # df -h Filesystem Size Used Avail Use% Mounted on /dev/root 1.4G 634M 716M 47% / devtmpfs 829M 0 829M 0% /dev tmpfs 958M 0 958M 0% /dev/shm tmpfs 958M 6.7M 952M 1% /run tmpfs 958M 0 958M 0% /sys/fs/cgroup tmpfs 958M 24K 958M 1% /tmp /dev/mmcblk0p1 32M 8.8M 24M 28% /boot /dev/mmcblk0p4 181G 105G 77G 58% /data # When the DB is not available I notice that /dev/mmcblk)p4 is not mounted. This is a a very annoying problem. Why does it happen? Are there issues when powering off? Has it to do with the automatic DB update-check? ...? I run on version 20200708 but it happend also with version 202020701

• Facebook
• Twitter
• LinkedIn

38 comments

• 0
  
  HiFiBerry team July 30, 2020 09:50

  The database will be scanned on updates on every reboot as the system doesn't know if something has been changed. Most people let the system run. As you seem to have lots of problems after reboots, I would recommend to leave it running.

  I can't say anything on "how long" as the size of a library doesn't say anything about this. You can simply have one large song with 120GB size, than scanning will be very slow. It depends on a lot of factors and you need to try by yourself.

  Our office system here is rebooted once every day without any problems - but we store the music on a NAS.

• 0
  
  Luyckx Bart July 30, 2020 10:01

  Quote :"The database will be scanned on updates on every reboot as the system doesn't know if something has been changed."

  Is this not strange?  I would expect it does know.  Just keeping track of last scan and last changes,  when something change it need to be logged somewhere (transactionllog) .  Update should only update the changes and not the whole DB I would expect.

  Update looks like hanging when you run it.  Can not see any progress-bar....i have about 150 albums and 250 or more artists I guess

   

   

• 0
  
  HiFiBerry team July 30, 2020 10:03

  There is no "transaction log" on a NAS or an USB stick. Updates WILL only update the changes. However, to know if there are changes, the whole music storage has to be scanned.

• 0
  
  Luyckx Bart July 30, 2020 10:44

  Thanks for the support and clarifying things

  For my understanding moving things to a USB thumbdrive will not solve my problem?  Am I correct?

  If updating database takes so long why not start it only manually from the menu and not everytime at startup?  User should know when he made changes and update is needed.   Some progress-bar would help also i feel.

• 0
  
  HiFiBerry team July 30, 2020 11:45

  As I don't know what's causing your problem, I can't tell you what will fix it. I can only tell you, that we're working here with USB sticks and NAS devices without issues.

• 0
  
  Luyckx Bart July 30, 2020 12:00

  For me it's also not clear what is causing the problem.  Since the latest release the mounting of the drive /data is correct every time only the DB is not always available as it should be.

  If I would install a USB Thumbdrive,how would it be formatted?  ex FAT?

• 0
  
  Luyckx Bart July 30, 2020 14:40

  Is there a way to rebuild the database from scratch?   

  I was playing Wet Wet Wet.  Left de Pi on powered on as suggested.  When I came back after a few hours, the list in artists and album was empty again, but still showing the last played track.

  I updated the DB with /opt/hifiberry/bin/update-mpd-db

  The process just stopped as shown in one of the ssh sessions.

  But strangely al the albums are visible again (artist list stay empty) .

  Im able to play music from there (as shown in the other ssh session)  update seems not to continue but window with the update still active and ongoing.   

  Now playing Depeche Mode, but under in the screen still shows Wet Wet Wet.... 

   

   

   

• 0
  
  Luyckx Bart July 31, 2020 10:22

  Any idea what is wrong and why the system behaves in this way?   How to fix it?