• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sync problems (again..., sorry...)
#1
I have created a folder to sync to on GDrive and for the last several weeks I synced my tablet to this folder every couple of days, updating folder. Each time I could see changes that I made on the tablet being propagated to the GDrive. All other devices sync to this folder, updating device only.

Then all of a sudden the sync started to ask to update songs that weren't changed. Investigating the files and databases on the GDrive and on the tablet revealed some strange discrepancies.

For example, the database on the GDrive contains a few songs with full path names instead of drive handles. There songs were the last songs that I added, approx a week ago. They have file sizes (in the database) that do not make sense (e.g. 1136 instead of 167270) and type 3 (text) instead of 0 (image). Moreover, the files are also in the database with correct info. This is from the database on the GDrive:

Quote:select * from files where path like '%proud%';
16411|427|1R6P4KkH4tnVQ579GRiy3ssvZhauTO54j/Proud_Mary.cho|1-2|1106|1450706302000|1|3|
16846|5|1L1ZzzERfjr1GQX3fiPDn6iTWYPALwAf3/Proud_Mary.cho|1-2|1071|1534420026000|1|3|
16992|2617|1P3G1yENqNIN2T4pVOHNdy84oR9-QnArw/Proud_Mary-ptg.png|1-1|167270|1537878218000|1|0|
16996|627|/storage/C443-17EE/Android/data/com.zubersoft.mobilesheetspro/files/Partituren/RtV/Proud_Mary-ptg.png|1-2|1136|1479243238000|1|3|

The first two entries are older files. The 3rd entry is a new file with correct information, and the 4th entry is the same file with incorrect information.

This is from the database on the tablet:

Quote:15572|427|Partituren/SingAlong/Proud_Mary.cho|1-2|1106|1450706302000|1|3|
16441|5|Partituren/Afasiekoor/Proud_Mary.cho|1-2|1071|1534420026000|1|3|
16527|2617|Partituren/RtV/Proud_Mary-ptg.png|1-1|167270|1537878218000|1|0|

Another strangeness is a dialog asking whether to add or delete a file. Mine = add, Theirs = delete. This seems to indicate that the file is on the device but not on the GDrive. However, it is on the GDrive, it is in the database on the GDrive, and it is in the mobilesheets_hashcodes.txt on the GDrive.

Device database:
Quote:select * from files where path like '%commander%';
15688|626|Partituren/Leonard_Cohen/Field_Commander_Cohen.cho|1-2|1383|1479243230000|1|3|

Device actual file:
Quote:-rwxrwx--x 1 u0_a149 sdcard_rw 1383 2016-11-15 18:53 Partituren/Leonard_Cohen/Field_Commander_Cohen.cho

I have no clue why this leads to an add/delete situation.
GDrive database:
Quote:16995|626|1Hrc12m2Ky0cZnuoiG-ZE6lSLAURWXuv3/Field_Commander_Cohen.cho|1-2|1383|1479243230000|1|3|

GDrive hashcodes:
Quote:1Hrc12m2Ky0cZnuoiG-ZE6lSLAURWXuv3/Field_Commander_Cohen.cho
1886876993
1538411426947
1383

GDrive actual file:
Quote:-rw------- 1 jv jv 1383 Aug 16 14:22 /home/jv/Cloud/Drive/MobileSheetsPro/Synch3/Partituren/Leonard_Cohen/Field_Commander_Cohen.cho

I have no clue why this would lead to an add/delete situation.
Johan
johanvromans.nl — hetgeluidvanseptember.nl — mojore.nl -- howsagoin.nl
Samsung Galaxy Note S7FE (T733) 12.4", Android 13.0, AirTurn Duo & Digit (Gigs).
Samsung Galaxy Note S4 (T830) 10.5", Android 10.0 (maintenance and backup).
Samsung A3 (A320FL), Android 8.0.0 (emergency).
Reply


Messages In This Thread
Sync problems (again..., sorry...) - by sciurius - 10-05-2018, 01:06 AM
RE: Sync problems (again..., sorry...) - by itsme - 10-05-2018, 07:48 AM
RE: Sync problems (again..., sorry...) - by itsme - 10-05-2018, 05:49 PM



Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.