[sciurius]

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:

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:

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:

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:

-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:

16995|626|1Hrc12m2Ky0cZnuoiG-ZE6lSLAURWXuv3/Field_Commander_Cohen.cho|1-2|1383|1479243230000|1|3|

GDrive hashcodes:

1Hrc12m2Ky0cZnuoiG-ZE6lSLAURWXuv3/Field_Commander_Cohen.cho
1886876993
1538411426947
1383

GDrive actual file:

-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.