0021550: MM5 Timeout due to complex query

ID	Project	Category	View Status	Date Submitted	Last Update

0021550	MMA	Synchronization	public	2025-03-25 14:11	2025-03-29 20:33

Reporter	martin	Assigned To
Priority	urgent	Severity	minor	Reproducibility	sometimes
Status	closed	Resolution	reopened
Platform	Android	OS	-	OS Version	all
Product Version	2.0.4
Target Version	2.0.5	Fixed in Version	2.0.5

Summary	0021550: MM5 Timeout due to complex query
Description	It occurs when a user removes too many items from the sync list and "Delete other files and playlists" is set to "All other media files" or "Unselected library files", MMW sends all unselected media to MMA to confirm deletion. It can be many items like tens of thousands of tracks, and sometimes MMA is waiting more than 19s and wifi sync fails due to Timeout exception. @lowlander can replicate it with 65k track to delete. I tested it with his database on MMA side, but MMW processing tooks only around 6 seconds. Currently, the timeout limit is reasonably set to 19s when Wifi-Sync starts and is common with all queries during wifi sync. However, it makes sense to offer users Wi-Fi sync retry with double the Timeout limit.
Tags	No tags attached.

Fixed in build	1243

martin 2025-03-25 14:13 developer ~0078536	Screenshot_20250324-192803.png (75,375 bytes) Screenshot_20250324-192803.png (75,375 bytes)

martin 2025-03-25 14:13 developer ~0078537	Fixed in build 2.0.5.1242

lowlander 2025-03-27 16:28 developer ~0078552	Sorry, it still fails after Retry (tried twice): Log ID: XHV6HXA8UR Description: server not responding retry twice It does start with x of 500, then x of 1000, etc. but does fail eventually anyway.

martin 2025-03-28 15:41 developer ~0078562	increased timeout limit 3x Fixed in build 2.0.5.1243

lowlander 2025-03-29 20:33 developer ~0078569	Verified on 1243, still wonder if a keep-alive from MMA to MMW is better than arbitrary timeout.