SQLite WAL in 7.6.1 - please test

[andyg]

Well, after I deleted the squeezebox-persistent.* files, it doesn't rebuild the database at all... 0 tracks 0 albums 0 artists. The scanner detects all files and then quits...

Shut down the server and delete all the database files, that should cause it to rescan.

[verypsb]

It looks like it's rescanning, but doesn't show any progress... It just shows 'abort scan'. I think we can confirm that the Windows version is badly broken now. (7.6.1 - r33022) (Since all persons using Windows have the same error)

[slate]

a continuation on my previous report on 33022.

So only half the music there... I settled for that as I was at work; annoying I know.... but I found that eg Abraxas only had 3 tracks and when I tried to play it only the first seconds played before it skipped to the next track etc....
Had a meeting and in the lunchbreak I cleaned the cache and went for a rescan.... and it went downhill from there "bad database" "no music source defined"... or something to that effect.
Went back to 33011

Now at home... should I have a go at my music server.....?!

[JJZolx]

I tried running 7.6.1 with MySQL and get similar results, although the numbers aren't identical. A full scan comes back with approximately half the library. When I run with SQLite the track count is always identical (three tries so far). With both database systems, running new & changed scans afterward gradually picks up the missed files.

Running 7.5.6, a full scan stills returns all files.

[JJZolx]

It looks like it's rescanning, but doesn't show any progress... It just shows 'abort scan'. I think we can confirm that the Windows version is badly broken now. (7.6.1 - r33022) (Since all persons using Windows have the same error)

That's what I see as well if the cache is cleared. And my SQLite editor reports a malformed database file.

A full scan only works when there is already an existing set of databases.

[verypsb]

Went back to 7.6.1 - r33011.

[Mnyb]

That's what I see as well if the cache is cleared. And my SQLite editor reports a malformed database file.

A full scan only works when there is already an existing set of databases.

Ok I installed build 30022 chosed a "clear and rescan everything" did not remove old dB Thanks for the warning .

Before WAL

Total Tracks: 31,650
Total Albums: 2,647
Total Artists: 1,203
Total Genres: 225
Total Playing Time: 2440:50:01

Cu all in an hour or 2 , having a slow via C7 server, will report the result

[Mnyb]

Ok I installed build 30022 chosed a "clear and rescan everything" did not remove old dB Thanks for the warning .

Before WAL

Total Tracks: 31,650
Total Albums: 2,647
Total Artists: 1,203
Total Genres: 225
Total Playing Time: 2440:50:01

Cu all in an hour or 2 , having a slow via C7 server, will report the result

This did not work out very well :-/

Total Tracks: 18,535
Total Albums: 1,845
Total Artists: 912
Total Genres: 179
Total Playing Time: 1410:43:25

Discovering files: /media/music (34422 of 34422) Complete 00:04:37
Scanning new files: /media/music (31275 of 31275) Complete 00:30:07
Discovering playlists: /media/music/Playlists (17 of 17) Complete 00:00:00
Scanning new playlists: /media/music/Playlists (16 of 16) Complete 00:04:13
Pre-caching Artwork (1710 of 1710) Complete 00:09:28
The server has finished scanning your music collection.
Total Time: 00:48:25 (2011/08/09 Tuesday / 20:45)

It misses 900 albums and artworks ?

[Mnyb]

Server and scanner log tells nothing of interest ?

[Mnyb]

This did not work out very well :-/

Total Tracks: 18,535
Total Albums: 1,845
Total Artists: 912
Total Genres: 179
Total Playing Time: 1410:43:25

Discovering files: /media/music (34422 of 34422) Complete 00:04:37
Scanning new files: /media/music (31275 of 31275) Complete 00:30:07
Discovering playlists: /media/music/Playlists (17 of 17) Complete 00:00:00
Scanning new playlists: /media/music/Playlists (16 of 16) Complete 00:04:13
Pre-caching Artwork (1710 of 1710) Complete 00:09:28
The server has finished scanning your music collection.
Total Time: 00:48:25 (2011/08/09 Tuesday / 20:45)

It misses 900 albums and artworks ?

A scan for new and changed brings the track count up

Total Tracks: 25,127
Total Albums: 2,341
Total Artists: 1,103
Total Genres: 215
Total Playing Time: 1953:16:35

Discovering files: /media/music (34421 of 34421) Complete 00:05:24
Removing deleted files: /media/music (27 of 27) Complete 00:00:08
Scanning new files: /media/music (12894 of 12894) Complete 00:19:15
Pre-caching Artwork (786 of 786) Complete 00:04:23
The server has finished scanning your music collection.
Total Time: 00:29:10 (2011/08/09 Tuesday / 21:27)

But we are still not there yet

Fyi i kept copies of the dB files between each pass now i shall run the new and changed scan again to see if it picks up the rest of my music .

Logs are not much ? should i use some particalur setting ? it's strange that missing >12000 files does not show a simple error of any kind ?