Skip to content

database not updating #77

@markkiddy

Description

@markkiddy

Hi
I tried many times import my library to mysql bot without luck. Strange thing, slimpd have write access to database cause can save create users in dedicated table. After running ./slimpd hard reset I see bunch of filenames from my mpd library an at the end see this :

root@piplayer:/var/www/slimpd# sudo -u www-data php slimpd hard-reset --force
deleting .lock file
All data of database:slimpddb will be lost! Continue? [y/n]
y
Dropping database
Recreating database
Will migrate: Sun, 17 Jul 2016 09:53:46 +0000 (slimpd_v1) ---> Fri, 07 Feb 2020 17:59:35 +0000

APPLY: Fri, 06 Jan 2017 06:44:30 +0000
NOW AT: Fri, 06 Jan 2017 06:44:30 +0000
Deleting files and directories inside localdata/cache/
Deleting files and directories inside localdata/embedded/
Deleting files and directories inside localdata/peakfiles/
STARTING import phase 0 triggerImport()
STARTING import phase 1 waitForMpd()
mpd seems to be ready. continuing...
FINISHED import phase 1 waitForMpd()
STARTING import phase 2 processMpdDatabasefile()
#1 mp3_to_unpack/him2010.ZIP/HIM - Screamworks Love in Theory and Practice (2010)/01. In Venere Veritas.mp3
mpd-file does not exist in rawtagdata: mp3_to_unpack/him2010.ZIP/HIM - Screamworks Love in Theory and Practice (2010)/01. In Venere Veritas.mp3
...
#7000 Ministry/Ministry - 2008 - Cover Up/49 - [blank].flac
mpd-file does not exist in rawtagdata: Ministry/Ministry - 2008 - Cover Up/49 - [blank].flac
batch-insert rawtagdatas (1000 records)
......
#12516 Руины Вечности - Шепот Забытых Холмов (2017)/08 – Наследие.mp3
mpd-file does not exist in rawtagdata: Руины Вечности - Шепот Забытых Холмов (2017)/08 – Наследие.mp3
batch-insert rawtagdatas (516 records)
dircount: 2226
songs: 12516
dead songs: 0
FINISHED import phase 2 processMpdDatabasefile()
STARTING import phase 3 run()
FINISHED import phase 3 run()
STARTING import phase 4 run()
FINISHED import phase 4 run()
STARTING import phase 5 destroyExtractedImageDupes()
Deleted 0 images with a total size of 0 bytes
FINISHED import phase 5 destroyExtractedImageDupes()
STARTING import phase 6 searchImagesInFilesystem()
FINISHED import phase 6 searchImagesInFilesystem()
STARTING import phase 7 updateCounterCache()
clearing stats in databasetables
collecting track data
collecting album data
start processing collected data
updating table:Artist with trackCount and albumCount
updating table:Genre with trackCount and albumCount
updating table:Label with trackCount and albumCount
deleting artists with trackCount=0 AND albumCount=0
deleting labels with trackCount=0 AND albumCount=0
deleting genres with trackCount=0 AND albumCount=0
FINISHED import phase 7 updateCounterCache()
STARTING import phase 8 extractAllMp3FingerPrints()
FINISHED import phase 8 extractAllMp3FingerPrints()
FINISHED import phase 0 finishBatch()
deleting .lock file

rawtagdata is still empty.
What can I do ?
It's fresh raspbian installation with all needed components.
Earlier, on ubuntu (the same machine) everything worked without issues.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions