Class org.syncany.tests.integration.scenarios.FilenameCapitalizationWindowsScenarioTest

2

tests

0

failures

0

ignored

0.907s

duration

100%

successful

Tests

Test Duration Result
testFilenameCapitalizationWindows 0.392s passed
testFilenameNonASCII 0.515s passed

Standard error

27-4-17 11:01:42.289 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.290 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
27-4-17 11:01:42.300 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-23957-client-A' ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.300 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-23957-client-A' ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - With feature PathAware
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - With feature TransactionAware
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.300 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.300 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
27-4-17 11:01:42.301 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
27-4-17 11:01:42.326 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
27-4-17 11:01:42.326 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
27-4-17 11:01:42.338 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
27-4-17 11:01:42.341 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
27-4-17 11:01:42.341 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
27-4-17 11:01:42.347 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
27-4-17 11:01:42.347 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
27-4-17 11:01:42.348 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
27-4-17 11:01:42.348 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS databaseversion ( id int NOT NULL IDENTITY, status varchar(45) NOT NULL, localtime datetime NOT NULL, client varchar(45) NOT NULL, vectorclock_serialized varchar(1024) NOT NULL, UNIQUE (vectorclock_serialized) ); 
27-4-17 11:01:42.350 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  chunk ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.352 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  databaseversion_vectorclock ( databaseversion_id int NOT NULL, client varchar(45) NOT NULL, logicaltime int NOT NULL, PRIMARY KEY (databaseversion_id, client), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.355 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.357 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent_chunk ( filecontent_checksum varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, num int NOT NULL, PRIMARY KEY (filecontent_checksum, chunk_checksum, num), FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.360 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filehistory ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, PRIMARY KEY (id, databaseversion_id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.362 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  fileversion ( filehistory_id varchar(40) NOT NULL, version int NOT NULL, databaseversion_id int NOT NULL, path varchar(1024) NOT NULL, type varchar(45) NOT NULL, status varchar(45) NOT NULL, size bigint NOT NULL, lastmodified datetime NOT NULL, linktarget varchar(1024), filecontent_checksum varchar(40) DEFAULT NULL, updated datetime NOT NULL, posixperms varchar(45) DEFAULT NULL, dosattrs varchar(45) DEFAULT NULL, PRIMARY KEY (filehistory_id, version, databaseversion_id), FOREIGN KEY (filehistory_id, databaseversion_id) REFERENCES filehistory (id, databaseversion_id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.365 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.367 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_chunk ( multichunk_id varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, PRIMARY KEY (multichunk_id, chunk_checksum), FOREIGN KEY (multichunk_id) REFERENCES multichunk (id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.369 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_muddy ( id varchar(40) NOT NULL, machine_name varchar(255) NOT NULL, machine_version int NOT NULL, PRIMARY KEY (id) ); 
27-4-17 11:01:42.371 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  known_databases ( id int NOT NULL IDENTITY, client varchar(45) NOT NULL, filenumber int NOT NULL, UNIQUE (client, filenumber) ); 
27-4-17 11:01:42.374 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  general_settings ( key varchar(255) NOT NULL, value varchar(255) NOT NULL, PRIMARY KEY (key) ); 
27-4-17 11:01:42.376 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
27-4-17 11:01:42.376 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
27-4-17 11:01:42.377 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
27-4-17 11:01:42.379 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
27-4-17 11:01:42.381 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
27-4-17 11:01:42.383 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
27-4-17 11:01:42.386 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
27-4-17 11:01:42.388 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
27-4-17 11:01:42.390 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
27-4-17 11:01:42.390 | SqlRunner       | Test worker    | INFO : SQL:    CREATE VIEW databaseversion_master AS SELECT dbv.*, vc.logicaltime as client_version FROM databaseversion dbv JOIN databaseversion_vectorclock vc on dbv.id=vc.databaseversion_id and dbv.client=vc.client WHERE dbv.status='MASTER'; 
27-4-17 11:01:42.393 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master AS SELECT fv0.* FROM fileversion fv0 JOIN databaseversion dbv ON fv0.databaseversion_id=dbv.id AND dbv.status='MASTER'; 
27-4-17 11:01:42.395 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_maxversion AS SELECT DISTINCT filehistory_id, MAX(version) version FROM fileversion_master GROUP BY filehistory_id; 
27-4-17 11:01:42.398 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_last AS SELECT fv.* FROM fileversion_master_maxversion fvmax JOIN fileversion_master fv ON fvmax.filehistory_id=fv.filehistory_id AND fvmax.version=fv.version WHERE fv.status<>'DELETED'; 
27-4-17 11:01:42.401 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
27-4-17 11:01:42.401 | SqlRunner       | Test worker    | INFO : SQL:    create view filehistory_full as select dbv.status as databaseversion_status, dbv.localtime as databaseversion_localtime, dbv.client as databaseversion_client, dbv.vectorclock_serialized as databaseversion_vectorclock_serialized, fh.* from databaseversion dbv join filehistory fh on dbv.id=fh.databaseversion_id; 
27-4-17 11:01:42.403 | SqlRunner       | Test worker    | INFO : SQL:  create view fileversion_full as select fhf.databaseversion_status, fhf.databaseversion_localtime, fhf.databaseversion_client, fhf.databaseversion_vectorclock_serialized, fv.* from filehistory_full fhf join fileversion fv on fhf.id=fv.filehistory_id and fhf.databaseversion_id=fv.databaseversion_id; 
27-4-17 11:01:42.406 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
27-4-17 11:01:42.406 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
27-4-17 11:01:42.406 | SqlRunner       | Test worker    | INFO : SQL:     create function substr_count(haystack varchar(255), needle varchar(255)) returns integer begin atomic declare strCount integer; declare lastIndex integer;  set strCount = 0; set lastIndex = 1;  while lastIndex <> 0 do set lastIndex = locate(needle, haystack, lastIndex);  if lastIndex <> 0 then set strCount = strCount + 1; set lastIndex = lastIndex + length(needle); end if; end while;  return strCount; end; 
27-4-17 11:01:42.409 | UpOperation     | Test worker    | INFO : 
27-4-17 11:01:42.409 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
27-4-17 11:01:42.409 | UpOperation     | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.409 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@2683635c) ...
27-4-17 11:01:42.410 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.410 | StatusOperation | Test worker    | INFO : 
27-4-17 11:01:42.410 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
27-4-17 11:01:42.410 | StatusOperation | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.410 | StatusOperation | Test worker    | INFO : Force checksum ENABLED.
27-4-17 11:01:42.410 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
27-4-17 11:01:42.410 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@181e1621) ...
27-4-17 11:01:42.411 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-170427110008054-23957-client-A ...
27-4-17 11:01:42.411 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
27-4-17 11:01:42.411 | StatusOperation | Test worker    | FINE : - New file: filename-for-windows
27-4-17 11:01:42.411 | StatusOperation | Test worker    | FINE : - New file: FILENAME-FOR-WINDOWS
27-4-17 11:01:42.412 | StatusOperation | Test worker    | FINE : - New file: Filename-For-Windows
27-4-17 11:01:42.412 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@4d059ad8) ...
27-4-17 11:01:42.412 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
27-4-17 11:01:42.412 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.412 | LsRemoteOperati | Test worker    | INFO : 
27-4-17 11:01:42.412 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
27-4-17 11:01:42.412 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.412 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@19755a7) ...
27-4-17 11:01:42.412 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
27-4-17 11:01:42.413 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@16a2d5b6) ...
27-4-17 11:01:42.413 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
27-4-17 11:01:42.413 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1493290902301] ...
27-4-17 11:01:42.413 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1493290902301]
27-4-17 11:01:42.413 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1493290902301] ...
27-4-17 11:01:42.414 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.417 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
27-4-17 11:01:42.418 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
27-4-17 11:01:42.418 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@44f99057) ...
27-4-17 11:01:42.418 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
27-4-17 11:01:42.418 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-170427110008054-23957-client-A/FILENAME-FOR-WINDOWS
27-4-17 11:01:42.418 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-170427110008054-23957-client-A/FILENAME-FOR-WINDOWS
27-4-17 11:01:42.423 | Indexer         | AsyncI/syncany | FINE : - Chunk new: beb853c3f8103be1ad5b804724643bc9c8f17a2e
27-4-17 11:01:42.423 | Indexer         | AsyncI/syncany | FINE : - +MultiChunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87
27-4-17 11:01:42.424 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: beb853c3f8103be1ad5b804724643bc9c8f17a2e > 525fc9928fa574057eb1e122d2e8f51fcb24ba87
27-4-17 11:01:42.425 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: beb853c3f8103be1ad5b804724643bc9c8f17a2e > /tmp/syncanytest/syncany-170427110008054-23957-client-A/FILENAME-FOR-WINDOWS
27-4-17 11:01:42.426 | Indexer         | AsyncI/syncany | FINE : - /File: FILENAME-FOR-WINDOWS (checksum beb853c3f8103be1ad5b804724643bc9c8f17a2e)
27-4-17 11:01:42.426 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: FILENAME-FOR-WINDOWS, checksum: beb853c3f8103be1ad5b804724643bc9c8f17a2e)
27-4-17 11:01:42.426 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file FILENAME-FOR-WINDOWS
27-4-17 11:01:42.427 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=beb853c3f8103be1ad5b804724643bc9c8f17a2e, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.427 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
27-4-17 11:01:42.427 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@5c3f066e) ...
27-4-17 11:01:42.428 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-170427110008054-23957-client-A/Filename-For-Windows
27-4-17 11:01:42.429 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-170427110008054-23957-client-A/Filename-For-Windows
27-4-17 11:01:42.430 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 0654560fc8e36544ff4146ad663cc413d1027c5b
27-4-17 11:01:42.430 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 0654560fc8e36544ff4146ad663cc413d1027c5b > 525fc9928fa574057eb1e122d2e8f51fcb24ba87
27-4-17 11:01:42.433 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 0654560fc8e36544ff4146ad663cc413d1027c5b > /tmp/syncanytest/syncany-170427110008054-23957-client-A/Filename-For-Windows
27-4-17 11:01:42.433 | Indexer         | AsyncI/syncany | FINE : - /File: Filename-For-Windows (checksum 0654560fc8e36544ff4146ad663cc413d1027c5b)
27-4-17 11:01:42.434 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: Filename-For-Windows, checksum: 0654560fc8e36544ff4146ad663cc413d1027c5b)
27-4-17 11:01:42.434 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file Filename-For-Windows
27-4-17 11:01:42.434 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=0654560fc8e36544ff4146ad663cc413d1027c5b, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.434 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
27-4-17 11:01:42.434 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-170427110008054-23957-client-A/filename-for-windows
27-4-17 11:01:42.435 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-170427110008054-23957-client-A/filename-for-windows
27-4-17 11:01:42.435 | Indexer         | AsyncI/syncany | FINE : - Chunk new: bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f
27-4-17 11:01:42.438 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f > 525fc9928fa574057eb1e122d2e8f51fcb24ba87
27-4-17 11:01:42.438 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f > /tmp/syncanytest/syncany-170427110008054-23957-client-A/filename-for-windows
27-4-17 11:01:42.438 | Indexer         | AsyncI/syncany | FINE : - /File: filename-for-windows (checksum bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f)
27-4-17 11:01:42.439 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: filename-for-windows, checksum: bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f)
27-4-17 11:01:42.439 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file filename-for-windows
27-4-17 11:01:42.441 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.441 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
27-4-17 11:01:42.442 | Indexer         | AsyncI/syncany | FINE : - /MultiChunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87
27-4-17 11:01:42.442 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@7886ee13) ...
27-4-17 11:01:42.442 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1493290902418, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:42.443 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
27-4-17 11:01:42.443 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
27-4-17 11:01:42.443 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
27-4-17 11:01:42.443 | UpOperation     | Test worker    | INFO : - Uploading multichunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87 from /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87 to RemoteFile[name=multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87] ...
27-4-17 11:01:42.443 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87 -> Temp. remote file: RemoteFile[name=temp-RyFSA-multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87], final location: RemoteFile[name=multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87]
27-4-17 11:01:42.443 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1493290902443, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:42.444 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1493290902443 to file /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/database-A-0000000001 ... 
27-4-17 11:01:42.444 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/database-A-0000000001 ...
27-4-17 11:01:42.444 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
27-4-17 11:01:42.444 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
27-4-17 11:01:42.444 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-KtSpI-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
27-4-17 11:01:42.445 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
27-4-17 11:01:42.445 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
27-4-17 11:01:42.446 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/temp-transaction-3225345804599327685.tmp
27-4-17 11:01:42.446 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@703af998) ...
27-4-17 11:01:42.446 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-61595420] ...
27-4-17 11:01:42.447 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
27-4-17 11:01:42.447 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@54848e11) ...
27-4-17 11:01:42.447 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87 to temp. file RemoteFile[name=temp-RyFSA-multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87] ...
27-4-17 11:01:42.448 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@1c286c09) ...
27-4-17 11:01:42.448 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-170427110008054-23957-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-KtSpI-database-A-0000000001] ...
27-4-17 11:01:42.448 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-RyFSA-multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87] to final location RemoteFile[name=multichunk-525fc9928fa574057eb1e122d2e8f51fcb24ba87] ...
27-4-17 11:01:42.448 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-KtSpI-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
27-4-17 11:01:42.448 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-61595420] ...
27-4-17 11:01:42.449 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
27-4-17 11:01:42.449 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
27-4-17 11:01:42.449 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1493290902443) ...
27-4-17 11:01:42.452 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
27-4-17 11:01:42.452 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@52e402a0) ...
27-4-17 11:01:42.462 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1493290902443, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:42.463 | UpOperation     | Test worker    | INFO : Committing local database.
27-4-17 11:01:42.463 | UpOperation     | Test worker    | FINE : Waiting for new database version.
27-4-17 11:01:42.465 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
27-4-17 11:01:42.465 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1493290902465, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
27-4-17 11:01:42.465 | UpOperation     | Test worker    | INFO : Sync up done.
27-4-17 11:01:42.467 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1493290902301] ...
27-4-17 11:01:42.474 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1493290902301]
27-4-17 11:01:42.474 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
27-4-17 11:01:42.475 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
27-4-17 11:01:42.475 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@7b4cfca3) ...
27-4-17 11:01:42.476 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.476 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-23957-client-B' ...
27-4-17 11:01:42.476 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.476 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.476 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.476 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.476 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.476 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.476 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.477 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.477 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.477 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-23957-client-B' ...
27-4-17 11:01:42.477 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.477 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.477 | TransferManager | Test worker    | INFO : - With feature PathAware
27-4-17 11:01:42.477 | TransferManager | Test worker    | INFO : - With feature TransactionAware
27-4-17 11:01:42.477 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.477 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.477 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.477 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.477 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.477 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.477 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
27-4-17 11:01:42.477 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
27-4-17 11:01:42.498 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
27-4-17 11:01:42.498 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
27-4-17 11:01:42.507 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
27-4-17 11:01:42.511 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
27-4-17 11:01:42.512 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
27-4-17 11:01:42.518 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
27-4-17 11:01:42.518 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
27-4-17 11:01:42.519 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
27-4-17 11:01:42.519 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS databaseversion ( id int NOT NULL IDENTITY, status varchar(45) NOT NULL, localtime datetime NOT NULL, client varchar(45) NOT NULL, vectorclock_serialized varchar(1024) NOT NULL, UNIQUE (vectorclock_serialized) ); 
27-4-17 11:01:42.521 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  chunk ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.524 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  databaseversion_vectorclock ( databaseversion_id int NOT NULL, client varchar(45) NOT NULL, logicaltime int NOT NULL, PRIMARY KEY (databaseversion_id, client), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.527 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.529 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent_chunk ( filecontent_checksum varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, num int NOT NULL, PRIMARY KEY (filecontent_checksum, chunk_checksum, num), FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.532 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filehistory ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, PRIMARY KEY (id, databaseversion_id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.534 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  fileversion ( filehistory_id varchar(40) NOT NULL, version int NOT NULL, databaseversion_id int NOT NULL, path varchar(1024) NOT NULL, type varchar(45) NOT NULL, status varchar(45) NOT NULL, size bigint NOT NULL, lastmodified datetime NOT NULL, linktarget varchar(1024), filecontent_checksum varchar(40) DEFAULT NULL, updated datetime NOT NULL, posixperms varchar(45) DEFAULT NULL, dosattrs varchar(45) DEFAULT NULL, PRIMARY KEY (filehistory_id, version, databaseversion_id), FOREIGN KEY (filehistory_id, databaseversion_id) REFERENCES filehistory (id, databaseversion_id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.537 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.539 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_chunk ( multichunk_id varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, PRIMARY KEY (multichunk_id, chunk_checksum), FOREIGN KEY (multichunk_id) REFERENCES multichunk (id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.542 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_muddy ( id varchar(40) NOT NULL, machine_name varchar(255) NOT NULL, machine_version int NOT NULL, PRIMARY KEY (id) ); 
27-4-17 11:01:42.544 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  known_databases ( id int NOT NULL IDENTITY, client varchar(45) NOT NULL, filenumber int NOT NULL, UNIQUE (client, filenumber) ); 
27-4-17 11:01:42.546 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  general_settings ( key varchar(255) NOT NULL, value varchar(255) NOT NULL, PRIMARY KEY (key) ); 
27-4-17 11:01:42.548 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
27-4-17 11:01:42.548 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
27-4-17 11:01:42.549 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
27-4-17 11:01:42.552 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
27-4-17 11:01:42.554 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
27-4-17 11:01:42.556 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
27-4-17 11:01:42.558 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
27-4-17 11:01:42.560 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
27-4-17 11:01:42.562 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
27-4-17 11:01:42.563 | SqlRunner       | Test worker    | INFO : SQL:    CREATE VIEW databaseversion_master AS SELECT dbv.*, vc.logicaltime as client_version FROM databaseversion dbv JOIN databaseversion_vectorclock vc on dbv.id=vc.databaseversion_id and dbv.client=vc.client WHERE dbv.status='MASTER'; 
27-4-17 11:01:42.565 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master AS SELECT fv0.* FROM fileversion fv0 JOIN databaseversion dbv ON fv0.databaseversion_id=dbv.id AND dbv.status='MASTER'; 
27-4-17 11:01:42.567 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_maxversion AS SELECT DISTINCT filehistory_id, MAX(version) version FROM fileversion_master GROUP BY filehistory_id; 
27-4-17 11:01:42.570 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_last AS SELECT fv.* FROM fileversion_master_maxversion fvmax JOIN fileversion_master fv ON fvmax.filehistory_id=fv.filehistory_id AND fvmax.version=fv.version WHERE fv.status<>'DELETED'; 
27-4-17 11:01:42.573 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
27-4-17 11:01:42.573 | SqlRunner       | Test worker    | INFO : SQL:    create view filehistory_full as select dbv.status as databaseversion_status, dbv.localtime as databaseversion_localtime, dbv.client as databaseversion_client, dbv.vectorclock_serialized as databaseversion_vectorclock_serialized, fh.* from databaseversion dbv join filehistory fh on dbv.id=fh.databaseversion_id; 
27-4-17 11:01:42.576 | SqlRunner       | Test worker    | INFO : SQL:  create view fileversion_full as select fhf.databaseversion_status, fhf.databaseversion_localtime, fhf.databaseversion_client, fhf.databaseversion_vectorclock_serialized, fv.* from filehistory_full fhf join fileversion fv on fhf.id=fv.filehistory_id and fhf.databaseversion_id=fv.databaseversion_id; 
27-4-17 11:01:42.578 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
27-4-17 11:01:42.578 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
27-4-17 11:01:42.578 | SqlRunner       | Test worker    | INFO : SQL:     create function substr_count(haystack varchar(255), needle varchar(255)) returns integer begin atomic declare strCount integer; declare lastIndex integer;  set strCount = 0; set lastIndex = 1;  while lastIndex <> 0 do set lastIndex = locate(needle, haystack, lastIndex);  if lastIndex <> 0 then set strCount = strCount + 1; set lastIndex = lastIndex + length(needle); end if; end while;  return strCount; end; 
27-4-17 11:01:42.581 | DownOperation   | Test worker    | INFO : 
27-4-17 11:01:42.581 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
27-4-17 11:01:42.581 | DownOperation   | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.581 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@4f8982c5) ...
27-4-17 11:01:42.581 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
27-4-17 11:01:42.582 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.582 | LsRemoteOperati | Test worker    | INFO : 
27-4-17 11:01:42.582 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
27-4-17 11:01:42.582 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.582 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@1bc8dc3a) ...
27-4-17 11:01:42.582 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
27-4-17 11:01:42.582 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
27-4-17 11:01:42.582 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@7177a027) ...
27-4-17 11:01:42.582 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@11033dd0) ...
27-4-17 11:01:42.582 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1493290902477] ...
27-4-17 11:01:42.582 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1493290902477]
27-4-17 11:01:42.582 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1493290902477] ...
27-4-17 11:01:42.583 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
27-4-17 11:01:42.583 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-170427110008054-23957-client-B/.syncany/cache/database-A-0000000001
27-4-17 11:01:42.583 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@2e50f19c) ...
27-4-17 11:01:42.583 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
27-4-17 11:01:42.583 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-170427110008054-23957-client-B/.syncany/cache/database-A-0000000001 ...
27-4-17 11:01:42.585 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1493290902443
27-4-17 11:01:42.585 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-170427110008054-23957-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
27-4-17 11:01:42.585 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
27-4-17 11:01:42.585 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1493290902443], B=[]}
27-4-17 11:01:42.585 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
27-4-17 11:01:42.585 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1493290902443
27-4-17 11:01:42.585 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
27-4-17 11:01:42.585 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1493290902443
27-4-17 11:01:42.585 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
27-4-17 11:01:42.585 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
27-4-17 11:01:42.585 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
27-4-17 11:01:42.585 | DatabaseReconci | Test worker    | INFO : Losers Branch: []
27-4-17 11:01:42.585 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1493290902443]
27-4-17 11:01:42.585 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
27-4-17 11:01:42.585 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1493290902443]
27-4-17 11:01:42.585 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
27-4-17 11:01:42.585 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-170427110008054-23957-client-B/.syncany/cache/database-A-0000000001 ...
27-4-17 11:01:42.587 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1493290902443
27-4-17 11:01:42.587 | DownOperation   | Test worker    | INFO : Determine file system actions ...
27-4-17 11:01:42.590 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.590 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
27-4-17 11:01:42.590 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
27-4-17 11:01:42.590 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
27-4-17 11:01:42.591 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=0654560fc8e36544ff4146ad663cc413d1027c5b, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.591 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file Filename-For-Windows
27-4-17 11:01:42.594 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=0654560fc8e36544ff4146ad663cc413d1027c5b, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-170427110008054-23957-client-B/Filename-For-Windows
27-4-17 11:01:42.598 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=0654560fc8e36544ff4146ad663cc413d1027c5b, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.598 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
27-4-17 11:01:42.598 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=beb853c3f8103be1ad5b804724643bc9c8f17a2e, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.598 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file FILENAME-FOR-WINDOWS
27-4-17 11:01:42.598 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=beb853c3f8103be1ad5b804724643bc9c8f17a2e, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-170427110008054-23957-client-B/FILENAME-FOR-WINDOWS
27-4-17 11:01:42.598 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=beb853c3f8103be1ad5b804724643bc9c8f17a2e, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.599 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
27-4-17 11:01:42.599 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.599 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file filename-for-windows
27-4-17 11:01:42.599 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-170427110008054-23957-client-B/filename-for-windows
27-4-17 11:01:42.599 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.600 | DownOperation   | Test worker    | INFO :   + Adding multichunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87 to download list ...
27-4-17 11:01:42.600 | DownOperation   | Test worker    | INFO :   + Adding multichunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87 to download list ...
27-4-17 11:01:42.601 | DownOperation   | Test worker    | INFO :   + Adding multichunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87 to download list ...
27-4-17 11:01:42.601 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
27-4-17 11:01:42.601 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@2b6df53e) ...
27-4-17 11:01:42.601 | Downloader      | Test worker    | INFO :   + Downloading multichunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87 ...
27-4-17 11:01:42.602 | Downloader      | Test worker    | INFO :   + Decrypting multichunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87 ...
27-4-17 11:01:42.602 | Downloader      | Test worker    | FINE :   + Locally deleting multichunk 525fc9928fa574057eb1e122d2e8f51fcb24ba87 ...
27-4-17 11:01:42.604 | FileSystemActio | Test worker    | INFO :    Sorted actions:
27-4-17 11:01:42.604 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=beb853c3f8103be1ad5b804724643bc9c8f17a2e, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.604 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=0654560fc8e36544ff4146ad663cc413d1027c5b, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.604 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.604 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
27-4-17 11:01:42.604 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=beb853c3f8103be1ad5b804724643bc9c8f17a2e, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.605 | Assembler       | Test worker    | INFO :      - Creating file FILENAME-FOR-WINDOWS to /tmp/syncanytest/syncany-170427110008054-23957-client-B/.syncany/cache/temp-reconstructedFileVersion-3085802146955855515.tmp ...
27-4-17 11:01:42.606 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
27-4-17 11:01:42.606 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=0654560fc8e36544ff4146ad663cc413d1027c5b, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.606 | Assembler       | Test worker    | INFO :      - Creating file Filename-For-Windows to /tmp/syncanytest/syncany-170427110008054-23957-client-B/.syncany/cache/temp-reconstructedFileVersion-3339450677472866844.tmp ...
27-4-17 11:01:42.613 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
27-4-17 11:01:42.614 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=bf9a7554a8a737674f74d7b7dac6fbc1cf584d8f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:42.614 | Assembler       | Test worker    | INFO :      - Creating file filename-for-windows to /tmp/syncanytest/syncany-170427110008054-23957-client-B/.syncany/cache/temp-reconstructedFileVersion-457420267926469062.tmp ...
27-4-17 11:01:42.615 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
27-4-17 11:01:42.616 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
27-4-17 11:01:42.616 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
27-4-17 11:01:42.616 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1493290902443, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:42.629 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1493290902477] ...
27-4-17 11:01:42.630 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1493290902477]
27-4-17 11:01:42.630 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
27-4-17 11:01:42.630 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
27-4-17 11:01:42.630 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@27270672) ...
27-4-17 11:01:42.630 | DownOperation   | Test worker    | INFO : Sync down done.
27-4-17 11:01:42.635 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-170427110008054-23957-client-A/filename-for-windows, but actual PATH = tmp/syncanytest/syncany-170427110008054-23957-client-B/filename-for-windows, for file tmp/syncanytest/syncany-170427110008054-23957-client-B/filename-for-windows
27-4-17 11:01:42.637 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-170427110008054-23957-client-A/Filename-For-Windows, but actual PATH = tmp/syncanytest/syncany-170427110008054-23957-client-B/Filename-For-Windows, for file tmp/syncanytest/syncany-170427110008054-23957-client-B/Filename-For-Windows
27-4-17 11:01:42.639 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-170427110008054-23957-client-A/FILENAME-FOR-WINDOWS, but actual PATH = tmp/syncanytest/syncany-170427110008054-23957-client-B/FILENAME-FOR-WINDOWS, for file tmp/syncanytest/syncany-170427110008054-23957-client-B/FILENAME-FOR-WINDOWS
27-4-17 11:01:42.640 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.641 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.659 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from chunk order by CHECKSUM asc
27-4-17 11:01:42.660 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select STATUS, LOCALTIME, CLIENT, VECTORCLOCK_SERIALIZED from databaseversion order by ID asc
27-4-17 11:01:42.661 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CLIENT, LOGICALTIME from databaseversion_vectorclock order by DATABASEVERSION_ID asc, CLIENT asc
27-4-17 11:01:42.661 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from filecontent order by CHECKSUM asc
27-4-17 11:01:42.662 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select FILECONTENT_CHECKSUM, CHUNK_CHECKSUM, NUM from filecontent_chunk order by FILECONTENT_CHECKSUM asc, CHUNK_CHECKSUM asc, NUM asc
27-4-17 11:01:42.662 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID from filehistory order by ID asc, DATABASEVERSION_ID asc
27-4-17 11:01:42.674 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select FILEHISTORY_ID, VERSION, PATH, TYPE, STATUS, SIZE, LASTMODIFIED, LINKTARGET, FILECONTENT_CHECKSUM, UPDATED, POSIXPERMS, DOSATTRS from fileversion order by FILEHISTORY_ID asc, VERSION asc, DATABASEVERSION_ID asc
27-4-17 11:01:42.675 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID, SIZE from multichunk order by ID asc
27-4-17 11:01:42.675 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select MULTICHUNK_ID, CHUNK_CHECKSUM from multichunk_chunk order by MULTICHUNK_ID asc, CHUNK_CHECKSUM asc
27-4-17 11:01:42.683 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.683 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
27-4-17 11:01:42.696 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.696 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-88199-client-A' ...
27-4-17 11:01:42.697 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.697 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.697 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.697 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.697 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.697 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.697 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.697 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.697 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.697 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-88199-client-A' ...
27-4-17 11:01:42.698 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.698 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.698 | TransferManager | Test worker    | INFO : - With feature PathAware
27-4-17 11:01:42.698 | TransferManager | Test worker    | INFO : - With feature TransactionAware
27-4-17 11:01:42.698 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.698 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.698 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.698 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.698 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.698 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.698 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
27-4-17 11:01:42.698 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
27-4-17 11:01:42.717 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
27-4-17 11:01:42.717 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
27-4-17 11:01:42.726 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
27-4-17 11:01:42.729 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
27-4-17 11:01:42.729 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
27-4-17 11:01:42.735 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
27-4-17 11:01:42.735 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
27-4-17 11:01:42.735 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
27-4-17 11:01:42.735 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS databaseversion ( id int NOT NULL IDENTITY, status varchar(45) NOT NULL, localtime datetime NOT NULL, client varchar(45) NOT NULL, vectorclock_serialized varchar(1024) NOT NULL, UNIQUE (vectorclock_serialized) ); 
27-4-17 11:01:42.739 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  chunk ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.742 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  databaseversion_vectorclock ( databaseversion_id int NOT NULL, client varchar(45) NOT NULL, logicaltime int NOT NULL, PRIMARY KEY (databaseversion_id, client), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.745 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.748 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent_chunk ( filecontent_checksum varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, num int NOT NULL, PRIMARY KEY (filecontent_checksum, chunk_checksum, num), FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.750 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filehistory ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, PRIMARY KEY (id, databaseversion_id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.753 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  fileversion ( filehistory_id varchar(40) NOT NULL, version int NOT NULL, databaseversion_id int NOT NULL, path varchar(1024) NOT NULL, type varchar(45) NOT NULL, status varchar(45) NOT NULL, size bigint NOT NULL, lastmodified datetime NOT NULL, linktarget varchar(1024), filecontent_checksum varchar(40) DEFAULT NULL, updated datetime NOT NULL, posixperms varchar(45) DEFAULT NULL, dosattrs varchar(45) DEFAULT NULL, PRIMARY KEY (filehistory_id, version, databaseversion_id), FOREIGN KEY (filehistory_id, databaseversion_id) REFERENCES filehistory (id, databaseversion_id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.756 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.758 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_chunk ( multichunk_id varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, PRIMARY KEY (multichunk_id, chunk_checksum), FOREIGN KEY (multichunk_id) REFERENCES multichunk (id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.760 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_muddy ( id varchar(40) NOT NULL, machine_name varchar(255) NOT NULL, machine_version int NOT NULL, PRIMARY KEY (id) ); 
27-4-17 11:01:42.763 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  known_databases ( id int NOT NULL IDENTITY, client varchar(45) NOT NULL, filenumber int NOT NULL, UNIQUE (client, filenumber) ); 
27-4-17 11:01:42.765 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  general_settings ( key varchar(255) NOT NULL, value varchar(255) NOT NULL, PRIMARY KEY (key) ); 
27-4-17 11:01:42.767 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
27-4-17 11:01:42.767 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
27-4-17 11:01:42.768 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
27-4-17 11:01:42.771 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
27-4-17 11:01:42.773 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
27-4-17 11:01:42.775 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
27-4-17 11:01:42.777 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
27-4-17 11:01:42.780 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
27-4-17 11:01:42.782 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
27-4-17 11:01:42.782 | SqlRunner       | Test worker    | INFO : SQL:    CREATE VIEW databaseversion_master AS SELECT dbv.*, vc.logicaltime as client_version FROM databaseversion dbv JOIN databaseversion_vectorclock vc on dbv.id=vc.databaseversion_id and dbv.client=vc.client WHERE dbv.status='MASTER'; 
27-4-17 11:01:42.784 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master AS SELECT fv0.* FROM fileversion fv0 JOIN databaseversion dbv ON fv0.databaseversion_id=dbv.id AND dbv.status='MASTER'; 
27-4-17 11:01:42.787 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_maxversion AS SELECT DISTINCT filehistory_id, MAX(version) version FROM fileversion_master GROUP BY filehistory_id; 
27-4-17 11:01:42.790 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_last AS SELECT fv.* FROM fileversion_master_maxversion fvmax JOIN fileversion_master fv ON fvmax.filehistory_id=fv.filehistory_id AND fvmax.version=fv.version WHERE fv.status<>'DELETED'; 
27-4-17 11:01:42.792 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
27-4-17 11:01:42.793 | SqlRunner       | Test worker    | INFO : SQL:    create view filehistory_full as select dbv.status as databaseversion_status, dbv.localtime as databaseversion_localtime, dbv.client as databaseversion_client, dbv.vectorclock_serialized as databaseversion_vectorclock_serialized, fh.* from databaseversion dbv join filehistory fh on dbv.id=fh.databaseversion_id; 
27-4-17 11:01:42.795 | SqlRunner       | Test worker    | INFO : SQL:  create view fileversion_full as select fhf.databaseversion_status, fhf.databaseversion_localtime, fhf.databaseversion_client, fhf.databaseversion_vectorclock_serialized, fv.* from filehistory_full fhf join fileversion fv on fhf.id=fv.filehistory_id and fhf.databaseversion_id=fv.databaseversion_id; 
27-4-17 11:01:42.798 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
27-4-17 11:01:42.798 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
27-4-17 11:01:42.798 | SqlRunner       | Test worker    | INFO : SQL:     create function substr_count(haystack varchar(255), needle varchar(255)) returns integer begin atomic declare strCount integer; declare lastIndex integer;  set strCount = 0; set lastIndex = 1;  while lastIndex <> 0 do set lastIndex = locate(needle, haystack, lastIndex);  if lastIndex <> 0 then set strCount = strCount + 1; set lastIndex = lastIndex + length(needle); end if; end while;  return strCount; end; 
27-4-17 11:01:42.801 | UpOperation     | Test worker    | INFO : 
27-4-17 11:01:42.801 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
27-4-17 11:01:42.801 | UpOperation     | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.801 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@2f7923a8) ...
27-4-17 11:01:42.802 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.802 | StatusOperation | Test worker    | INFO : 
27-4-17 11:01:42.802 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
27-4-17 11:01:42.802 | StatusOperation | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.802 | StatusOperation | Test worker    | INFO : Force checksum ENABLED.
27-4-17 11:01:42.802 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
27-4-17 11:01:42.802 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@260905e9) ...
27-4-17 11:01:42.803 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-170427110008054-88199-client-A ...
27-4-17 11:01:42.803 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
27-4-17 11:01:42.807 | StatusOperation | Test worker    | FINE : - New file: 這是一個測試
27-4-17 11:01:42.808 | StatusOperation | Test worker    | FINE : - New file: Exposé
27-4-17 11:01:42.809 | StatusOperation | Test worker    | FINE : - New file: One&Two
27-4-17 11:01:42.809 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@71a079b7) ...
27-4-17 11:01:42.809 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
27-4-17 11:01:42.818 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.818 | LsRemoteOperati | Test worker    | INFO : 
27-4-17 11:01:42.818 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
27-4-17 11:01:42.818 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:42.819 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@5d4edcd9) ...
27-4-17 11:01:42.819 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
27-4-17 11:01:42.819 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@5d5059f0) ...
27-4-17 11:01:42.819 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
27-4-17 11:01:42.820 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1493290902700] ...
27-4-17 11:01:42.820 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1493290902700]
27-4-17 11:01:42.820 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1493290902700] ...
27-4-17 11:01:42.822 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:42.829 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
27-4-17 11:01:42.830 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
27-4-17 11:01:42.830 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@21024d27) ...
27-4-17 11:01:42.830 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
27-4-17 11:01:42.830 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-170427110008054-88199-client-A/Exposé
27-4-17 11:01:42.831 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-170427110008054-88199-client-A/Exposé
27-4-17 11:01:42.838 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 150657286f28c801c6c39688d5d76905d8e40f39
27-4-17 11:01:42.842 | Indexer         | AsyncI/syncany | FINE : - +MultiChunk c2b417a4ed08eac0780cb29b21910a0007c334d0
27-4-17 11:01:42.843 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 150657286f28c801c6c39688d5d76905d8e40f39 > c2b417a4ed08eac0780cb29b21910a0007c334d0
27-4-17 11:01:42.843 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 150657286f28c801c6c39688d5d76905d8e40f39 > /tmp/syncanytest/syncany-170427110008054-88199-client-A/Exposé
27-4-17 11:01:42.843 | Indexer         | AsyncI/syncany | FINE : - /File: Exposé (checksum 150657286f28c801c6c39688d5d76905d8e40f39)
27-4-17 11:01:42.844 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: Exposé, checksum: 150657286f28c801c6c39688d5d76905d8e40f39)
27-4-17 11:01:42.845 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file Exposé
27-4-17 11:01:42.845 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=150657286f28c801c6c39688d5d76905d8e40f39, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.846 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
27-4-17 11:01:42.846 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@199c27f6) ...
27-4-17 11:01:42.846 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-170427110008054-88199-client-A/One&Two
27-4-17 11:01:42.850 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-170427110008054-88199-client-A/One&Two
27-4-17 11:01:42.851 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 99889542260064122a7c46a71fd7721066528d5d
27-4-17 11:01:42.851 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 99889542260064122a7c46a71fd7721066528d5d > c2b417a4ed08eac0780cb29b21910a0007c334d0
27-4-17 11:01:42.852 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 99889542260064122a7c46a71fd7721066528d5d > /tmp/syncanytest/syncany-170427110008054-88199-client-A/One&Two
27-4-17 11:01:42.852 | Indexer         | AsyncI/syncany | FINE : - /File: One&Two (checksum 99889542260064122a7c46a71fd7721066528d5d)
27-4-17 11:01:42.853 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: One&Two, checksum: 99889542260064122a7c46a71fd7721066528d5d)
27-4-17 11:01:42.857 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file One&Two
27-4-17 11:01:42.858 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=99889542260064122a7c46a71fd7721066528d5d, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.858 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
27-4-17 11:01:42.858 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-170427110008054-88199-client-A/這是一個測試
27-4-17 11:01:42.859 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-170427110008054-88199-client-A/這是一個測試
27-4-17 11:01:42.860 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 10b9f206a1c3d171fcf0405aef4e0e914131c30f
27-4-17 11:01:42.860 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 10b9f206a1c3d171fcf0405aef4e0e914131c30f > c2b417a4ed08eac0780cb29b21910a0007c334d0
27-4-17 11:01:42.861 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 10b9f206a1c3d171fcf0405aef4e0e914131c30f > /tmp/syncanytest/syncany-170427110008054-88199-client-A/這是一個測試
27-4-17 11:01:42.861 | Indexer         | AsyncI/syncany | FINE : - /File: 這是一個測試 (checksum 10b9f206a1c3d171fcf0405aef4e0e914131c30f)
27-4-17 11:01:42.862 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: 這是一個測試, checksum: 10b9f206a1c3d171fcf0405aef4e0e914131c30f)
27-4-17 11:01:42.862 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file 這是一個測試
27-4-17 11:01:42.862 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=10b9f206a1c3d171fcf0405aef4e0e914131c30f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:42.864 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
27-4-17 11:01:42.864 | Indexer         | AsyncI/syncany | FINE : - /MultiChunk c2b417a4ed08eac0780cb29b21910a0007c334d0
27-4-17 11:01:42.864 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@8fb4b9d) ...
27-4-17 11:01:42.865 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1493290902830, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:42.865 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
27-4-17 11:01:42.865 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
27-4-17 11:01:42.866 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
27-4-17 11:01:42.866 | UpOperation     | Test worker    | INFO : - Uploading multichunk c2b417a4ed08eac0780cb29b21910a0007c334d0 from /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0 to RemoteFile[name=multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0] ...
27-4-17 11:01:42.866 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0 -> Temp. remote file: RemoteFile[name=temp-dQADj-multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0], final location: RemoteFile[name=multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0]
27-4-17 11:01:42.866 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1493290902866, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:42.866 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1493290902866 to file /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/database-A-0000000001 ... 
27-4-17 11:01:42.866 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/database-A-0000000001 ...
27-4-17 11:01:42.868 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
27-4-17 11:01:42.868 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
27-4-17 11:01:42.868 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-vYEJu-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
27-4-17 11:01:42.869 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
27-4-17 11:01:42.869 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
27-4-17 11:01:42.870 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/temp-transaction-8667943888031612354.tmp
27-4-17 11:01:42.871 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@ad4837) ...
27-4-17 11:01:42.871 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-14969ead] ...
27-4-17 11:01:42.871 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
27-4-17 11:01:42.871 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@6350f4ea) ...
27-4-17 11:01:42.872 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0 to temp. file RemoteFile[name=temp-dQADj-multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0] ...
27-4-17 11:01:42.872 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@e352455) ...
27-4-17 11:01:42.872 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-170427110008054-88199-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-vYEJu-database-A-0000000001] ...
27-4-17 11:01:42.873 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-dQADj-multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0] to final location RemoteFile[name=multichunk-c2b417a4ed08eac0780cb29b21910a0007c334d0] ...
27-4-17 11:01:42.873 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-vYEJu-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
27-4-17 11:01:42.877 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-14969ead] ...
27-4-17 11:01:42.877 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
27-4-17 11:01:42.878 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
27-4-17 11:01:42.878 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1493290902866) ...
27-4-17 11:01:42.872 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@32ded864) ...
27-4-17 11:01:42.897 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
27-4-17 11:01:42.902 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
27-4-17 11:01:42.910 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1493290902866, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:42.910 | UpOperation     | Test worker    | INFO : Committing local database.
27-4-17 11:01:42.911 | UpOperation     | Test worker    | FINE : Waiting for new database version.
27-4-17 11:01:42.911 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1493290902897, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
27-4-17 11:01:42.911 | UpOperation     | Test worker    | INFO : Sync up done.
27-4-17 11:01:42.920 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1493290902700] ...
27-4-17 11:01:42.929 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1493290902700]
27-4-17 11:01:42.929 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
27-4-17 11:01:42.930 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
27-4-17 11:01:42.930 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@1744c1ae) ...
27-4-17 11:01:42.932 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.933 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-88199-client-B' ...
27-4-17 11:01:42.933 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.933 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.933 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.933 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.933 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.933 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.933 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.933 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.933 | org.syncany.plu | Test worker    | FINE : Validating required fields
27-4-17 11:01:42.934 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-170427110008054-88199-client-B' ...
27-4-17 11:01:42.934 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
27-4-17 11:01:42.934 | TransferManager | Test worker    | INFO : - With feature Retriable
27-4-17 11:01:42.934 | TransferManager | Test worker    | INFO : - With feature PathAware
27-4-17 11:01:42.934 | TransferManager | Test worker    | INFO : - With feature TransactionAware
27-4-17 11:01:42.934 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
27-4-17 11:01:42.934 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
27-4-17 11:01:42.935 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
27-4-17 11:01:42.935 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
27-4-17 11:01:42.935 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
27-4-17 11:01:42.935 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
27-4-17 11:01:42.935 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
27-4-17 11:01:42.935 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
27-4-17 11:01:42.955 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
27-4-17 11:01:42.958 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
27-4-17 11:01:42.966 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
27-4-17 11:01:42.970 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
27-4-17 11:01:42.970 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
27-4-17 11:01:42.976 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
27-4-17 11:01:42.976 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
27-4-17 11:01:42.976 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
27-4-17 11:01:42.976 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS databaseversion ( id int NOT NULL IDENTITY, status varchar(45) NOT NULL, localtime datetime NOT NULL, client varchar(45) NOT NULL, vectorclock_serialized varchar(1024) NOT NULL, UNIQUE (vectorclock_serialized) ); 
27-4-17 11:01:42.979 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  chunk ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.981 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  databaseversion_vectorclock ( databaseversion_id int NOT NULL, client varchar(45) NOT NULL, logicaltime int NOT NULL, PRIMARY KEY (databaseversion_id, client), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.984 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent ( checksum varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (checksum), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.986 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filecontent_chunk ( filecontent_checksum varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, num int NOT NULL, PRIMARY KEY (filecontent_checksum, chunk_checksum, num), FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.988 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  filehistory ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, PRIMARY KEY (id, databaseversion_id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.990 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  fileversion ( filehistory_id varchar(40) NOT NULL, version int NOT NULL, databaseversion_id int NOT NULL, path varchar(1024) NOT NULL, type varchar(45) NOT NULL, status varchar(45) NOT NULL, size bigint NOT NULL, lastmodified datetime NOT NULL, linktarget varchar(1024), filecontent_checksum varchar(40) DEFAULT NULL, updated datetime NOT NULL, posixperms varchar(45) DEFAULT NULL, dosattrs varchar(45) DEFAULT NULL, PRIMARY KEY (filehistory_id, version, databaseversion_id), FOREIGN KEY (filehistory_id, databaseversion_id) REFERENCES filehistory (id, databaseversion_id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (filecontent_checksum) REFERENCES filecontent (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.993 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk ( id varchar(40) NOT NULL, databaseversion_id int NOT NULL, size bigint NOT NULL, PRIMARY KEY (id), FOREIGN KEY (databaseversion_id) REFERENCES databaseversion (id) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.995 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_chunk ( multichunk_id varchar(40) NOT NULL, chunk_checksum varchar(40) NOT NULL, PRIMARY KEY (multichunk_id, chunk_checksum), FOREIGN KEY (multichunk_id) REFERENCES multichunk (id) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (chunk_checksum) REFERENCES chunk (checksum) ON DELETE NO ACTION ON UPDATE NO ACTION ); 
27-4-17 11:01:42.998 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  multichunk_muddy ( id varchar(40) NOT NULL, machine_name varchar(255) NOT NULL, machine_version int NOT NULL, PRIMARY KEY (id) ); 
27-4-17 11:01:43.000 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  known_databases ( id int NOT NULL IDENTITY, client varchar(45) NOT NULL, filenumber int NOT NULL, UNIQUE (client, filenumber) ); 
27-4-17 11:01:43.003 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  general_settings ( key varchar(255) NOT NULL, value varchar(255) NOT NULL, PRIMARY KEY (key) ); 
27-4-17 11:01:43.005 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
27-4-17 11:01:43.005 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
27-4-17 11:01:43.005 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
27-4-17 11:01:43.008 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
27-4-17 11:01:43.010 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
27-4-17 11:01:43.012 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
27-4-17 11:01:43.015 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
27-4-17 11:01:43.027 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
27-4-17 11:01:43.029 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
27-4-17 11:01:43.029 | SqlRunner       | Test worker    | INFO : SQL:    CREATE VIEW databaseversion_master AS SELECT dbv.*, vc.logicaltime as client_version FROM databaseversion dbv JOIN databaseversion_vectorclock vc on dbv.id=vc.databaseversion_id and dbv.client=vc.client WHERE dbv.status='MASTER'; 
27-4-17 11:01:43.032 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master AS SELECT fv0.* FROM fileversion fv0 JOIN databaseversion dbv ON fv0.databaseversion_id=dbv.id AND dbv.status='MASTER'; 
27-4-17 11:01:43.035 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_maxversion AS SELECT DISTINCT filehistory_id, MAX(version) version FROM fileversion_master GROUP BY filehistory_id; 
27-4-17 11:01:43.037 | SqlRunner       | Test worker    | INFO : SQL:  CREATE VIEW fileversion_master_last AS SELECT fv.* FROM fileversion_master_maxversion fvmax JOIN fileversion_master fv ON fvmax.filehistory_id=fv.filehistory_id AND fvmax.version=fv.version WHERE fv.status<>'DELETED'; 
27-4-17 11:01:43.040 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
27-4-17 11:01:43.040 | SqlRunner       | Test worker    | INFO : SQL:    create view filehistory_full as select dbv.status as databaseversion_status, dbv.localtime as databaseversion_localtime, dbv.client as databaseversion_client, dbv.vectorclock_serialized as databaseversion_vectorclock_serialized, fh.* from databaseversion dbv join filehistory fh on dbv.id=fh.databaseversion_id; 
27-4-17 11:01:43.043 | SqlRunner       | Test worker    | INFO : SQL:  create view fileversion_full as select fhf.databaseversion_status, fhf.databaseversion_localtime, fhf.databaseversion_client, fhf.databaseversion_vectorclock_serialized, fv.* from filehistory_full fhf join fileversion fv on fhf.id=fv.filehistory_id and fhf.databaseversion_id=fv.databaseversion_id; 
27-4-17 11:01:43.046 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
27-4-17 11:01:43.046 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
27-4-17 11:01:43.046 | SqlRunner       | Test worker    | INFO : SQL:     create function substr_count(haystack varchar(255), needle varchar(255)) returns integer begin atomic declare strCount integer; declare lastIndex integer;  set strCount = 0; set lastIndex = 1;  while lastIndex <> 0 do set lastIndex = locate(needle, haystack, lastIndex);  if lastIndex <> 0 then set strCount = strCount + 1; set lastIndex = lastIndex + length(needle); end if; end while;  return strCount; end; 
27-4-17 11:01:43.049 | DownOperation   | Test worker    | INFO : 
27-4-17 11:01:43.049 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
27-4-17 11:01:43.049 | DownOperation   | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:43.049 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@25cefe8d) ...
27-4-17 11:01:43.049 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
27-4-17 11:01:43.050 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:43.050 | LsRemoteOperati | Test worker    | INFO : 
27-4-17 11:01:43.050 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
27-4-17 11:01:43.051 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
27-4-17 11:01:43.051 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@6947e239) ...
27-4-17 11:01:43.051 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
27-4-17 11:01:43.051 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
27-4-17 11:01:43.051 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@5c462ad2) ...
27-4-17 11:01:43.051 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@6199c979) ...
27-4-17 11:01:43.053 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1493290902935] ...
27-4-17 11:01:43.054 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1493290902935]
27-4-17 11:01:43.054 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1493290902935] ...
27-4-17 11:01:43.055 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
27-4-17 11:01:43.055 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-170427110008054-88199-client-B/.syncany/cache/database-A-0000000001
27-4-17 11:01:43.055 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@2088ed97) ...
27-4-17 11:01:43.056 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
27-4-17 11:01:43.056 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-170427110008054-88199-client-B/.syncany/cache/database-A-0000000001 ...
27-4-17 11:01:43.062 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1493290902866
27-4-17 11:01:43.062 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-170427110008054-88199-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
27-4-17 11:01:43.063 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
27-4-17 11:01:43.063 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1493290902866], B=[]}
27-4-17 11:01:43.063 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
27-4-17 11:01:43.063 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1493290902866
27-4-17 11:01:43.064 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
27-4-17 11:01:43.064 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1493290902866
27-4-17 11:01:43.064 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
27-4-17 11:01:43.064 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
27-4-17 11:01:43.064 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
27-4-17 11:01:43.064 | DatabaseReconci | Test worker    | INFO : Losers Branch: []
27-4-17 11:01:43.065 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1493290902866]
27-4-17 11:01:43.065 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
27-4-17 11:01:43.065 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1493290902866]
27-4-17 11:01:43.065 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
27-4-17 11:01:43.066 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-170427110008054-88199-client-B/.syncany/cache/database-A-0000000001 ...
27-4-17 11:01:43.073 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1493290902866
27-4-17 11:01:43.073 | DownOperation   | Test worker    | INFO : Determine file system actions ...
27-4-17 11:01:43.074 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:43.075 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
27-4-17 11:01:43.075 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
27-4-17 11:01:43.075 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
27-4-17 11:01:43.075 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=150657286f28c801c6c39688d5d76905d8e40f39, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:43.075 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file Exposé
27-4-17 11:01:43.075 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=150657286f28c801c6c39688d5d76905d8e40f39, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-170427110008054-88199-client-B/Exposé
27-4-17 11:01:43.076 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=150657286f28c801c6c39688d5d76905d8e40f39, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.076 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
27-4-17 11:01:43.076 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=10b9f206a1c3d171fcf0405aef4e0e914131c30f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:43.076 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file 這是一個測試
27-4-17 11:01:43.076 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=10b9f206a1c3d171fcf0405aef4e0e914131c30f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-170427110008054-88199-client-B/這是一個測試
27-4-17 11:01:43.077 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=10b9f206a1c3d171fcf0405aef4e0e914131c30f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.077 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
27-4-17 11:01:43.077 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=99889542260064122a7c46a71fd7721066528d5d, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]
27-4-17 11:01:43.078 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file One&Two
27-4-17 11:01:43.078 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=99889542260064122a7c46a71fd7721066528d5d, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-170427110008054-88199-client-B/One&Two
27-4-17 11:01:43.078 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=99889542260064122a7c46a71fd7721066528d5d, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.081 | DownOperation   | Test worker    | INFO :   + Adding multichunk c2b417a4ed08eac0780cb29b21910a0007c334d0 to download list ...
27-4-17 11:01:43.081 | DownOperation   | Test worker    | INFO :   + Adding multichunk c2b417a4ed08eac0780cb29b21910a0007c334d0 to download list ...
27-4-17 11:01:43.082 | DownOperation   | Test worker    | INFO :   + Adding multichunk c2b417a4ed08eac0780cb29b21910a0007c334d0 to download list ...
27-4-17 11:01:43.082 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
27-4-17 11:01:43.089 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@1bbf6d7d) ...
27-4-17 11:01:43.089 | Downloader      | Test worker    | INFO :   + Downloading multichunk c2b417a4ed08eac0780cb29b21910a0007c334d0 ...
27-4-17 11:01:43.090 | Downloader      | Test worker    | INFO :   + Decrypting multichunk c2b417a4ed08eac0780cb29b21910a0007c334d0 ...
27-4-17 11:01:43.090 | Downloader      | Test worker    | FINE :   + Locally deleting multichunk c2b417a4ed08eac0780cb29b21910a0007c334d0 ...
27-4-17 11:01:43.093 | FileSystemActio | Test worker    | INFO :    Sorted actions:
27-4-17 11:01:43.093 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=150657286f28c801c6c39688d5d76905d8e40f39, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.093 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=99889542260064122a7c46a71fd7721066528d5d, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.093 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=10b9f206a1c3d171fcf0405aef4e0e914131c30f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.093 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
27-4-17 11:01:43.093 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=150657286f28c801c6c39688d5d76905d8e40f39, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.093 | Assembler       | Test worker    | INFO :      - Creating file Exposé to /tmp/syncanytest/syncany-170427110008054-88199-client-B/.syncany/cache/temp-reconstructedFileVersion-7520820884386030141.tmp ...
27-4-17 11:01:43.095 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
27-4-17 11:01:43.095 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=99889542260064122a7c46a71fd7721066528d5d, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.095 | Assembler       | Test worker    | INFO :      - Creating file One&Two to /tmp/syncanytest/syncany-170427110008054-88199-client-B/.syncany/cache/temp-reconstructedFileVersion-3600186663929163958.tmp ...
27-4-17 11:01:43.096 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
27-4-17 11:01:43.097 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Thu Apr 27 11:01:42 UTC 2017, linkTarget=null, checksum=10b9f206a1c3d171fcf0405aef4e0e914131c30f, updated=Thu Apr 27 11:01:42 UTC 2017, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
27-4-17 11:01:43.097 | Assembler       | Test worker    | INFO :      - Creating file 這是一個測試 to /tmp/syncanytest/syncany-170427110008054-88199-client-B/.syncany/cache/temp-reconstructedFileVersion-7710749266795285422.tmp ...
27-4-17 11:01:43.098 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
27-4-17 11:01:43.098 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
27-4-17 11:01:43.099 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
27-4-17 11:01:43.099 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1493290902866, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
27-4-17 11:01:43.113 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1493290902935] ...
27-4-17 11:01:43.121 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1493290902935]
27-4-17 11:01:43.121 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
27-4-17 11:01:43.122 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
27-4-17 11:01:43.122 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@5f0423d1) ...
27-4-17 11:01:43.122 | DownOperation   | Test worker    | INFO : Sync down done.
27-4-17 11:01:43.130 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-170427110008054-88199-client-A/Exposé, but actual PATH = tmp/syncanytest/syncany-170427110008054-88199-client-B/Exposé, for file tmp/syncanytest/syncany-170427110008054-88199-client-B/Exposé
27-4-17 11:01:43.136 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-170427110008054-88199-client-A/這是一個測試, but actual PATH = tmp/syncanytest/syncany-170427110008054-88199-client-B/這是一個測試, for file tmp/syncanytest/syncany-170427110008054-88199-client-B/這是一個測試
27-4-17 11:01:43.139 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-170427110008054-88199-client-A/One&Two, but actual PATH = tmp/syncanytest/syncany-170427110008054-88199-client-B/One&Two, for file tmp/syncanytest/syncany-170427110008054-88199-client-B/One&Two
27-4-17 11:01:43.142 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:43.143 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
27-4-17 11:01:43.172 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from chunk order by CHECKSUM asc
27-4-17 11:01:43.178 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select STATUS, LOCALTIME, CLIENT, VECTORCLOCK_SERIALIZED from databaseversion order by ID asc
27-4-17 11:01:43.179 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CLIENT, LOGICALTIME from databaseversion_vectorclock order by DATABASEVERSION_ID asc, CLIENT asc
27-4-17 11:01:43.179 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from filecontent order by CHECKSUM asc
27-4-17 11:01:43.185 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select FILECONTENT_CHECKSUM, CHUNK_CHECKSUM, NUM from filecontent_chunk order by FILECONTENT_CHECKSUM asc, CHUNK_CHECKSUM asc, NUM asc
27-4-17 11:01:43.186 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID from filehistory order by ID asc, DATABASEVERSION_ID asc
27-4-17 11:01:43.186 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select FILEHISTORY_ID, VERSION, PATH, TYPE, STATUS, SIZE, LASTMODIFIED, LINKTARGET, FILECONTENT_CHECKSUM, UPDATED, POSIXPERMS, DOSATTRS from fileversion order by FILEHISTORY_ID asc, VERSION asc, DATABASEVERSION_ID asc
27-4-17 11:01:43.187 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID, SIZE from multichunk order by ID asc
27-4-17 11:01:43.187 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select MULTICHUNK_ID, CHUNK_CHECKSUM from multichunk_chunk order by MULTICHUNK_ID asc, CHUNK_CHECKSUM asc