View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011766 | MMW v4 | Synchronization | public | 2014-01-20 13:26 | 2014-01-21 22:18 |
| Reporter | Ludek | Assigned To | |||
| Priority | immediate | Severity | minor | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.1 | ||||
| Target Version | 4.1 | Fixed in Version | 4.1 | ||
| Summary | 0011766: Sync MMW->MMA USB sync can fail to transfer advanced metadata on occassion | ||||
| Description | Based on some logs from the past and it also appeared to me once that USB sync from MMW to MMA did not transfer advanced metadata (like rating). I found that it was because the database file for MMA (mmstore.dd.synced) was not closed properly, namely -WAL (write ahead log) file was not incorporated to the database file on closing, this caused that MMA did not see the changes made by MMW (e.g. sync_operations table was missing) and thus MMA did not accepted such a db. Here: http://www.sqlite.org/draft/wal.html#how_to_checkpoint is written that the auto-checkpoint (to commit WAL) occurs when the last database connection on a database file closes. But as we can see this is not always true, so we should solve it by calling "PRAGMA wal_checkpoint" before commit and close of the db. Or alternativelly disable WAL by "PRAGMA journal_mode=DELETE" | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1689 | ||||
|
|
Further studing shown that the WAL is not the real cause, but that the DB sometimes isn't closed properly on MMW side for some reason, might be a regression related to 0011587, studing more... |
|
|
Further testing shown that this occasionally happened, but only when using 'Send-to' -> <device> The real cause was that it erroneously triggered device re-scan on the same MMA's DB local copy and this caused the conflict and potential close failure (if the device was still being re-scanned on sync end). So it is regression caused by this 0008342:0038602 in build 1677. |
|
|
Fixed in build 1689. |
|
|
Verified 1689 and MMA 220 pro |
