WiFi sync fails due to SQL error in MMW 1815

Beta Testing for Windows Products and plugins

Moderator: Gurus

WiFi sync fails due to SQL error in MMW 1815

Postby 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.
rivorson
 
Posts: 526
Joined: Thu Jul 25, 2013 4:17 am

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

Postby 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 viewtopic.php?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.
Best regards,
Pavle
MM Core Developer and Admin of free MediaMonkey extensions Hosting
Image
Image
Peke
 
Posts: 10436
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia

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

Postby 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.
rivorson
 
Posts: 526
Joined: Thu Jul 25, 2013 4:17 am

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

Postby 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.
Ludek
 
Posts: 2236
Joined: Fri Mar 09, 2007 9:00 am

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

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

Confirmed fixed in 1816. Thank you.
rivorson
 
Posts: 526
Joined: Thu Jul 25, 2013 4:17 am


Return to MediaMonkey for Windows 4 Beta Testing

Who is online

Users browsing this forum: No registered users and 12 guests