Bug 141252

Did you put DynamicCollection=false into the amarokrc on ALL computers which share the database?

Yes DynamicCollection=false is/was on all ends.

Some additional info, I've now found that it "works" if I perform the collection scan from one of any of the clients.  In this case the Amarok app on the server also can connect.  This behavior is different than 1.4.4 and recent SVNs.

If I perform the collection scan on the server its self, the clients cannot use the sharded DB, no errors, just shows zero files in collection.

Perhaps this is acceptable?  In many cases the server is not likely to have Amarok installed?

There shouldn't be any difference between Amarok on the server itself and Amarok on the clients. Please run the following sql query once after scanning from the client, and once after scanning from the server and post the results:

SELECT DISTINCT deviceid FROM tags;

Interesting.

Currently with the DB built from the client the deviceid from tags is "-1", which happens to match:

[Collection Folders]
-1=./main/backup/MP3

On the server:

[Collection Folders]
2=./main/backup/MP3

If i rescanned on the server would deviceid likely = 2?

You didn't add DynamicCollection=false to the amarokrc on your server, or the line is in the wrong group.

Here it is:

[Collection]
DatabaseEngine=1
DynamicCollection=false
Monitor Changes=false

OK, how about this?

On server I started v1.4.5 with a clean install, which means I had no amarokrc file, couldn't add the DynamicCollection switch.  So I fired Amarok for the firt time, added the music directory with the GUI, shut down Amarok, then added the switch.  

Adding the music directory without the switch probably made the deviceid 2.  Doing it in this order probably confuses Amarok?

ok, you do have the correct line in the amarokrc. I really need the results of those sql queries then please.

Ok, its a big DB, takes 4-5 hours, I'll start it when I get home.

Scanning the collection on the server results in a deviceid of 2 in tags.  Scanning from any of the clients results in -1.

Max,

I manually set -1 on the server, see below:

[Collection Folders]
-1=./main/backup/MP3 

Did a rescan and the deviceid in tags was again 2.  And the clients cannot connect.

I updated deviceid to -1 and all is good, on both server/client.

Max, more info, didn't notice till now.

Even though on the server (I had to manually edit amarokrc and change 2 to -1):

[Collection Folders]
-1=./main/backup/MP3

SELECT * FROM `amarok`.`directories` shows:

./backup/MP3 for ALL directories

Shouldn't it be ./main/backup/MP3?

Amarok is unable to play cause it cannot find the files.

Max, any updated info?

He's probably waiting on info from you, since you never posted the results of the SQL queries.

I did, comment #10.

In that case: either you are using an old Amarok version on the server, or you did not add DynamicCollection=false to the server's armarokrc.

Well, it was the most recent when this bug was posted, 1.4.5 and I posted my amarokrc entry which did include DynamicCollection=false.

If there have been changes since 1.4.5 I'm willing to test, if not I'd prefer not to again lose my collection stats.

I've worked around this bug by never scanning/updating from the server box.

I don't remember when that switch in amarokrc was introduced (I think it was earlier than 1.4.5. But there is no way to get a deviceid of 2 when rescanning the collection if the Amarok version is recent enough and it has been correctly switched off in the amarokrc file that the Amarok instance is using.