WiFi sync fails due to SQL error in MMW 1815

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: WiFi sync fails due to SQL error in MMW 1815

Re: WiFi sync fails due to SQL error in MMW 1815

by rivorson » Tue Nov 01, 2016 3:20 pm

Confirmed fixed in 1816. Thank you.

Re: WiFi sync fails due to SQL error in MMW 1815

by Ludek » Mon Oct 24, 2016 4:54 am

Thank you for reporting, I re-opened http://www.ventismedia.com/mantis/view.php?id=13070
It will be fixed in the next build.

Re: WiFi sync fails due to SQL error in MMW 1815

by rivorson » Sun Oct 23, 2016 7:19 pm

Support ticket submitted.

It isn't necessary to have multiple devices synchronising simultaneously but if one device causes the error then all other concurrent syncs will be terminated. They key to causing the error is syncing a full collection with the Playlist Is criteria.

I installed build 1813 and the problem did not occur so it is new to 1815.

Re: WiFi sync fails due to SQL error in MMW 1815

by Peke » Sun Oct 23, 2016 2:46 pm

Hi,
I tried to replicate with 4 device simultaneously sync with MMW over WiFi and all 4 devices finished sync with no issues.

Can you please open support ticket and Create log file as described in http://www.mediamonkey.com/forum/viewto ... ?f=20&t=69 and in addition to that log send log file from each device on fail while writing IDs in support ticket.

That will give us enough info on whet is going on.

WiFi sync fails due to SQL error in MMW 1815

by rivorson » Fri Oct 21, 2016 4:09 pm

When I attempt a WiFi sync between MMA 618 on my Nexus 6 and MMW 1815 I get an error in MMW stating:
There was a problem querying the database:
Error executing SQL statement "DROP TABLE IF EXISTS _TempPlaylistContent_382": database table is locked (6, 6)
The error seems to be caused by including in the sync list any Collection with criteria Playlist Is. Syncing the playlist without the Collection succeeds, as does syncing a Collection which does not contain a playlist criteria.

If multiple WiFi sync tasks are running concurrently then this error occurring for one device will cause all devices to fail.

Top