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

2

tests

0

failures

0

ignored

0.743s

duration

100%

successful

Tests

Test Duration Result
testFilenameCapitalizationWindows 0.322s passed
testFilenameNonASCII 0.421s passed

Standard error

18-11-18 14:33:49.974 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:49.974 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
18-11-18 14:33:49.983 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:49.983 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-22513-client-A' ...
18-11-18 14:33:49.983 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:49.983 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:49.983 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:49.983 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:49.984 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-22513-client-A' ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : - With feature PathAware
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : - With feature TransactionAware
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:49.984 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
18-11-18 14:33:49.984 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
18-11-18 14:33:49.993 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
18-11-18 14:33:49.993 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
18-11-18 14:33:49.998 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
18-11-18 14:33:50.001 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
18-11-18 14:33:50.001 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
18-11-18 14:33:50.007 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
18-11-18 14:33:50.007 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
18-11-18 14:33:50.007 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
18-11-18 14:33:50.007 | 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) ); 
18-11-18 14:33:50.009 | 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 ); 
18-11-18 14:33:50.012 | 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 ); 
18-11-18 14:33:50.014 | 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 ); 
18-11-18 14:33:50.017 | 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 ); 
18-11-18 14:33:50.019 | 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 ); 
18-11-18 14:33:50.021 | 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 ); 
18-11-18 14:33:50.024 | 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 ); 
18-11-18 14:33:50.026 | 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 ); 
18-11-18 14:33:50.028 | 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) ); 
18-11-18 14:33:50.031 | 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) ); 
18-11-18 14:33:50.033 | 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) ); 
18-11-18 14:33:50.035 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
18-11-18 14:33:50.035 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
18-11-18 14:33:50.036 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
18-11-18 14:33:50.038 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
18-11-18 14:33:50.043 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
18-11-18 14:33:50.045 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
18-11-18 14:33:50.046 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
18-11-18 14:33:50.048 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
18-11-18 14:33:50.049 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
18-11-18 14:33:50.049 | 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'; 
18-11-18 14:33:50.052 | 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'; 
18-11-18 14:33:50.054 | 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; 
18-11-18 14:33:50.056 | 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'; 
18-11-18 14:33:50.061 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
18-11-18 14:33:50.061 | 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; 
18-11-18 14:33:50.063 | 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; 
18-11-18 14:33:50.065 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
18-11-18 14:33:50.065 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
18-11-18 14:33:50.065 | 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; 
18-11-18 14:33:50.067 | UpOperation     | Test worker    | INFO : 
18-11-18 14:33:50.067 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
18-11-18 14:33:50.067 | UpOperation     | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.067 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@57ba0eeb) ...
18-11-18 14:33:50.068 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.068 | StatusOperation | Test worker    | INFO : 
18-11-18 14:33:50.068 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
18-11-18 14:33:50.068 | StatusOperation | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.068 | StatusOperation | Test worker    | INFO : Force checksum ENABLED.
18-11-18 14:33:50.068 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
18-11-18 14:33:50.068 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@943fe52) ...
18-11-18 14:33:50.069 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-181118143132272-22513-client-A ...
18-11-18 14:33:50.069 | StatusOperation | Test worker    | FINE : - New file: FILENAME-FOR-WINDOWS
18-11-18 14:33:50.069 | StatusOperation | Test worker    | FINE : - New file: filename-for-windows
18-11-18 14:33:50.069 | StatusOperation | Test worker    | FINE : - New file: Filename-For-Windows
18-11-18 14:33:50.069 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
18-11-18 14:33:50.069 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@4857a68f) ...
18-11-18 14:33:50.069 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
18-11-18 14:33:50.070 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.070 | LsRemoteOperati | Test worker    | INFO : 
18-11-18 14:33:50.070 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
18-11-18 14:33:50.070 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.070 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@7223dfba) ...
18-11-18 14:33:50.070 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
18-11-18 14:33:50.070 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@1bcd1bc0) ...
18-11-18 14:33:50.070 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
18-11-18 14:33:50.070 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1542551629984] ...
18-11-18 14:33:50.070 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1542551629984]
18-11-18 14:33:50.071 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1542551629984] ...
18-11-18 14:33:50.071 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.072 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
18-11-18 14:33:50.072 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
18-11-18 14:33:50.072 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@726c3681) ...
18-11-18 14:33:50.072 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
18-11-18 14:33:50.072 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-181118143132272-22513-client-A/FILENAME-FOR-WINDOWS
18-11-18 14:33:50.072 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-181118143132272-22513-client-A/FILENAME-FOR-WINDOWS
18-11-18 14:33:50.078 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 49c32a96f7d5967c9bbd80438f1ae061d4fc6052
18-11-18 14:33:50.078 | Indexer         | AsyncI/syncany | FINE : - +MultiChunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0
18-11-18 14:33:50.081 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 49c32a96f7d5967c9bbd80438f1ae061d4fc6052 > 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0
18-11-18 14:33:50.082 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 49c32a96f7d5967c9bbd80438f1ae061d4fc6052 > /tmp/syncanytest/syncany-181118143132272-22513-client-A/FILENAME-FOR-WINDOWS
18-11-18 14:33:50.082 | Indexer         | AsyncI/syncany | FINE : - /File: FILENAME-FOR-WINDOWS (checksum 49c32a96f7d5967c9bbd80438f1ae061d4fc6052)
18-11-18 14:33:50.083 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: FILENAME-FOR-WINDOWS, checksum: 49c32a96f7d5967c9bbd80438f1ae061d4fc6052)
18-11-18 14:33:50.083 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file FILENAME-FOR-WINDOWS
18-11-18 14:33:50.083 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=49c32a96f7d5967c9bbd80438f1ae061d4fc6052, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.083 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
18-11-18 14:33:50.083 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@644bfbd7) ...
18-11-18 14:33:50.085 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-181118143132272-22513-client-A/Filename-For-Windows
18-11-18 14:33:50.085 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-181118143132272-22513-client-A/Filename-For-Windows
18-11-18 14:33:50.086 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 54c5143fb6ac3926879e3fccb50c113d8254121e
18-11-18 14:33:50.086 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 54c5143fb6ac3926879e3fccb50c113d8254121e > 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0
18-11-18 14:33:50.086 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 54c5143fb6ac3926879e3fccb50c113d8254121e > /tmp/syncanytest/syncany-181118143132272-22513-client-A/Filename-For-Windows
18-11-18 14:33:50.086 | Indexer         | AsyncI/syncany | FINE : - /File: Filename-For-Windows (checksum 54c5143fb6ac3926879e3fccb50c113d8254121e)
18-11-18 14:33:50.087 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: Filename-For-Windows, checksum: 54c5143fb6ac3926879e3fccb50c113d8254121e)
18-11-18 14:33:50.087 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file Filename-For-Windows
18-11-18 14:33:50.087 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=54c5143fb6ac3926879e3fccb50c113d8254121e, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.087 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
18-11-18 14:33:50.087 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-181118143132272-22513-client-A/filename-for-windows
18-11-18 14:33:50.087 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-181118143132272-22513-client-A/filename-for-windows
18-11-18 14:33:50.088 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 52b1212146d7805e1117a388015e004caa905cbe
18-11-18 14:33:50.089 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 52b1212146d7805e1117a388015e004caa905cbe > 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0
18-11-18 14:33:50.089 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 52b1212146d7805e1117a388015e004caa905cbe > /tmp/syncanytest/syncany-181118143132272-22513-client-A/filename-for-windows
18-11-18 14:33:50.089 | Indexer         | AsyncI/syncany | FINE : - /File: filename-for-windows (checksum 52b1212146d7805e1117a388015e004caa905cbe)
18-11-18 14:33:50.089 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: filename-for-windows, checksum: 52b1212146d7805e1117a388015e004caa905cbe)
18-11-18 14:33:50.089 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file filename-for-windows
18-11-18 14:33:50.089 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=52b1212146d7805e1117a388015e004caa905cbe, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.089 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
18-11-18 14:33:50.090 | Indexer         | AsyncI/syncany | FINE : - /MultiChunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0
18-11-18 14:33:50.090 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@aa6ddb0) ...
18-11-18 14:33:50.090 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1542551630072, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.090 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@7b591eda) ...
18-11-18 14:33:50.091 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
18-11-18 14:33:50.091 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
18-11-18 14:33:50.091 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
18-11-18 14:33:50.091 | UpOperation     | Test worker    | INFO : - Uploading multichunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 from /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 to RemoteFile[name=multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0] ...
18-11-18 14:33:50.092 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 -> Temp. remote file: RemoteFile[name=temp-yoCVP-multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0], final location: RemoteFile[name=multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0]
18-11-18 14:33:50.092 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1542551630091, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.092 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1542551630091 to file /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/database-A-0000000001 ... 
18-11-18 14:33:50.092 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/database-A-0000000001 ...
18-11-18 14:33:50.092 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
18-11-18 14:33:50.092 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
18-11-18 14:33:50.092 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-stYGK-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
18-11-18 14:33:50.093 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
18-11-18 14:33:50.093 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
18-11-18 14:33:50.093 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/temp-transaction-1668183362098910146.tmp
18-11-18 14:33:50.093 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@465f7a20) ...
18-11-18 14:33:50.094 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-11688c62] ...
18-11-18 14:33:50.094 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
18-11-18 14:33:50.094 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@7f29e2d5) ...
18-11-18 14:33:50.094 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 to temp. file RemoteFile[name=temp-yoCVP-multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0] ...
18-11-18 14:33:50.094 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@3a49f324) ...
18-11-18 14:33:50.094 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-181118143132272-22513-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-stYGK-database-A-0000000001] ...
18-11-18 14:33:50.095 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-yoCVP-multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0] to final location RemoteFile[name=multichunk-19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0] ...
18-11-18 14:33:50.095 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-stYGK-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
18-11-18 14:33:50.095 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-11688c62] ...
18-11-18 14:33:50.095 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
18-11-18 14:33:50.095 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
18-11-18 14:33:50.095 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1542551630091) ...
18-11-18 14:33:50.100 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
18-11-18 14:33:50.103 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
18-11-18 14:33:50.106 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1542551630091, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.106 | UpOperation     | Test worker    | INFO : Committing local database.
18-11-18 14:33:50.106 | UpOperation     | Test worker    | FINE : Waiting for new database version.
18-11-18 14:33:50.106 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1542551630103, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
18-11-18 14:33:50.106 | UpOperation     | Test worker    | INFO : Sync up done.
18-11-18 14:33:50.108 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1542551629984] ...
18-11-18 14:33:50.109 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1542551629984]
18-11-18 14:33:50.109 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
18-11-18 14:33:50.109 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
18-11-18 14:33:50.109 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@5c3700b3) ...
18-11-18 14:33:50.110 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-22513-client-B' ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:50.111 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-22513-client-B' ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - With feature PathAware
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - With feature TransactionAware
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:50.111 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
18-11-18 14:33:50.111 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
18-11-18 14:33:50.124 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
18-11-18 14:33:50.125 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
18-11-18 14:33:50.134 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
18-11-18 14:33:50.138 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
18-11-18 14:33:50.138 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
18-11-18 14:33:50.142 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
18-11-18 14:33:50.142 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
18-11-18 14:33:50.143 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
18-11-18 14:33:50.143 | 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) ); 
18-11-18 14:33:50.145 | 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 ); 
18-11-18 14:33:50.147 | 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 ); 
18-11-18 14:33:50.149 | 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 ); 
18-11-18 14:33:50.151 | 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 ); 
18-11-18 14:33:50.152 | 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 ); 
18-11-18 14:33:50.154 | 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 ); 
18-11-18 14:33:50.156 | 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 ); 
18-11-18 14:33:50.157 | 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 ); 
18-11-18 14:33:50.159 | 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) ); 
18-11-18 14:33:50.161 | 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) ); 
18-11-18 14:33:50.162 | 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) ); 
18-11-18 14:33:50.164 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
18-11-18 14:33:50.164 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
18-11-18 14:33:50.165 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
18-11-18 14:33:50.167 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
18-11-18 14:33:50.168 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
18-11-18 14:33:50.170 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
18-11-18 14:33:50.172 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
18-11-18 14:33:50.174 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
18-11-18 14:33:50.176 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
18-11-18 14:33:50.176 | 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'; 
18-11-18 14:33:50.178 | 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'; 
18-11-18 14:33:50.181 | 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; 
18-11-18 14:33:50.183 | 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'; 
18-11-18 14:33:50.185 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
18-11-18 14:33:50.186 | 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; 
18-11-18 14:33:50.188 | 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; 
18-11-18 14:33:50.190 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
18-11-18 14:33:50.190 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
18-11-18 14:33:50.190 | 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; 
18-11-18 14:33:50.192 | DownOperation   | Test worker    | INFO : 
18-11-18 14:33:50.192 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
18-11-18 14:33:50.192 | DownOperation   | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.192 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@66237f31) ...
18-11-18 14:33:50.192 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
18-11-18 14:33:50.193 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.193 | LsRemoteOperati | Test worker    | INFO : 
18-11-18 14:33:50.193 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
18-11-18 14:33:50.193 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.193 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@5b9bc2de) ...
18-11-18 14:33:50.193 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
18-11-18 14:33:50.193 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
18-11-18 14:33:50.193 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@66fb7c21) ...
18-11-18 14:33:50.193 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@14c5f017) ...
18-11-18 14:33:50.193 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1542551630111] ...
18-11-18 14:33:50.193 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1542551630111]
18-11-18 14:33:50.194 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1542551630111] ...
18-11-18 14:33:50.194 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
18-11-18 14:33:50.194 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-181118143132272-22513-client-B/.syncany/cache/database-A-0000000001
18-11-18 14:33:50.194 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@55db563e) ...
18-11-18 14:33:50.194 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
18-11-18 14:33:50.195 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-181118143132272-22513-client-B/.syncany/cache/database-A-0000000001 ...
18-11-18 14:33:50.200 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1542551630091
18-11-18 14:33:50.201 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-181118143132272-22513-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
18-11-18 14:33:50.201 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
18-11-18 14:33:50.201 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1542551630091], B=[]}
18-11-18 14:33:50.201 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
18-11-18 14:33:50.201 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1542551630091
18-11-18 14:33:50.201 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
18-11-18 14:33:50.201 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1542551630091
18-11-18 14:33:50.201 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
18-11-18 14:33:50.201 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
18-11-18 14:33:50.201 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
18-11-18 14:33:50.201 | DatabaseReconci | Test worker    | INFO : Losers Branch: []
18-11-18 14:33:50.201 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1542551630091]
18-11-18 14:33:50.201 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
18-11-18 14:33:50.201 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1542551630091]
18-11-18 14:33:50.201 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
18-11-18 14:33:50.202 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-181118143132272-22513-client-B/.syncany/cache/database-A-0000000001 ...
18-11-18 14:33:50.203 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1542551630091
18-11-18 14:33:50.203 | DownOperation   | Test worker    | INFO : Determine file system actions ...
18-11-18 14:33:50.203 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.204 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
18-11-18 14:33:50.204 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
18-11-18 14:33:50.204 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
18-11-18 14:33:50.204 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=52b1212146d7805e1117a388015e004caa905cbe, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.207 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file filename-for-windows
18-11-18 14:33:50.207 | 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=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=52b1212146d7805e1117a388015e004caa905cbe, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-181118143132272-22513-client-B/filename-for-windows
18-11-18 14:33:50.207 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=52b1212146d7805e1117a388015e004caa905cbe, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.207 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
18-11-18 14:33:50.207 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=54c5143fb6ac3926879e3fccb50c113d8254121e, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.207 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file Filename-For-Windows
18-11-18 14:33:50.207 | 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=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=54c5143fb6ac3926879e3fccb50c113d8254121e, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-181118143132272-22513-client-B/Filename-For-Windows
18-11-18 14:33:50.207 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=54c5143fb6ac3926879e3fccb50c113d8254121e, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.207 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
18-11-18 14:33:50.208 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=49c32a96f7d5967c9bbd80438f1ae061d4fc6052, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.208 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file FILENAME-FOR-WINDOWS
18-11-18 14:33:50.208 | 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=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=49c32a96f7d5967c9bbd80438f1ae061d4fc6052, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-181118143132272-22513-client-B/FILENAME-FOR-WINDOWS
18-11-18 14:33:50.208 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=49c32a96f7d5967c9bbd80438f1ae061d4fc6052, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.208 | DownOperation   | Test worker    | INFO :   + Adding multichunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 to download list ...
18-11-18 14:33:50.209 | DownOperation   | Test worker    | INFO :   + Adding multichunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 to download list ...
18-11-18 14:33:50.209 | DownOperation   | Test worker    | INFO :   + Adding multichunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 to download list ...
18-11-18 14:33:50.210 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
18-11-18 14:33:50.210 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@5be672f1) ...
18-11-18 14:33:50.210 | Downloader      | Test worker    | INFO :   + Downloading multichunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 ...
18-11-18 14:33:50.210 | Downloader      | Test worker    | INFO :   + Decrypting multichunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 ...
18-11-18 14:33:50.210 | Downloader      | Test worker    | FINE :   + Locally deleting multichunk 19e2ea7a306a3c662f0e8a9e06fcf57bc0323ee0 ...
18-11-18 14:33:50.211 | FileSystemActio | Test worker    | INFO :    Sorted actions:
18-11-18 14:33:50.211 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=49c32a96f7d5967c9bbd80438f1ae061d4fc6052, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.211 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=54c5143fb6ac3926879e3fccb50c113d8254121e, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.212 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=52b1212146d7805e1117a388015e004caa905cbe, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.212 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
18-11-18 14:33:50.212 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=FILENAME-FOR-WINDOWS, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=49c32a96f7d5967c9bbd80438f1ae061d4fc6052, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.212 | Assembler       | Test worker    | INFO :      - Creating file FILENAME-FOR-WINDOWS to /tmp/syncanytest/syncany-181118143132272-22513-client-B/.syncany/cache/temp-reconstructedFileVersion-4640568904656597979.tmp ...
18-11-18 14:33:50.213 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
18-11-18 14:33:50.214 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Filename-For-Windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=54c5143fb6ac3926879e3fccb50c113d8254121e, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.214 | Assembler       | Test worker    | INFO :      - Creating file Filename-For-Windows to /tmp/syncanytest/syncany-181118143132272-22513-client-B/.syncany/cache/temp-reconstructedFileVersion-6680424602905770049.tmp ...
18-11-18 14:33:50.215 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
18-11-18 14:33:50.216 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=filename-for-windows, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:49 UTC 2018, linkTarget=null, checksum=52b1212146d7805e1117a388015e004caa905cbe, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.216 | Assembler       | Test worker    | INFO :      - Creating file filename-for-windows to /tmp/syncanytest/syncany-181118143132272-22513-client-B/.syncany/cache/temp-reconstructedFileVersion-839059796334463552.tmp ...
18-11-18 14:33:50.218 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
18-11-18 14:33:50.218 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
18-11-18 14:33:50.218 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
18-11-18 14:33:50.218 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1542551630091, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.225 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1542551630111] ...
18-11-18 14:33:50.228 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1542551630111]
18-11-18 14:33:50.228 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
18-11-18 14:33:50.229 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
18-11-18 14:33:50.229 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@45bde740) ...
18-11-18 14:33:50.229 | DownOperation   | Test worker    | INFO : Sync down done.
18-11-18 14:33:50.241 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-181118143132272-22513-client-A/filename-for-windows, but actual PATH = tmp/syncanytest/syncany-181118143132272-22513-client-B/filename-for-windows, for file tmp/syncanytest/syncany-181118143132272-22513-client-B/filename-for-windows
18-11-18 14:33:50.243 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-181118143132272-22513-client-A/Filename-For-Windows, but actual PATH = tmp/syncanytest/syncany-181118143132272-22513-client-B/Filename-For-Windows, for file tmp/syncanytest/syncany-181118143132272-22513-client-B/Filename-For-Windows
18-11-18 14:33:50.246 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-181118143132272-22513-client-A/FILENAME-FOR-WINDOWS, but actual PATH = tmp/syncanytest/syncany-181118143132272-22513-client-B/FILENAME-FOR-WINDOWS, for file tmp/syncanytest/syncany-181118143132272-22513-client-B/FILENAME-FOR-WINDOWS
18-11-18 14:33:50.247 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.248 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.278 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from chunk order by CHECKSUM asc
18-11-18 14:33:50.279 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select STATUS, LOCALTIME, CLIENT, VECTORCLOCK_SERIALIZED from databaseversion order by ID asc
18-11-18 14:33:50.280 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CLIENT, LOGICALTIME from databaseversion_vectorclock order by DATABASEVERSION_ID asc, CLIENT asc
18-11-18 14:33:50.281 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from filecontent order by CHECKSUM asc
18-11-18 14:33:50.281 | 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
18-11-18 14:33:50.281 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID from filehistory order by ID asc, DATABASEVERSION_ID asc
18-11-18 14:33:50.287 | 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
18-11-18 14:33:50.289 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID, SIZE from multichunk order by ID asc
18-11-18 14:33:50.291 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select MULTICHUNK_ID, CHUNK_CHECKSUM from multichunk_chunk order by MULTICHUNK_ID asc, CHUNK_CHECKSUM asc
18-11-18 14:33:50.295 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:50.295 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
18-11-18 14:33:50.312 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:50.312 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-18468-client-A' ...
18-11-18 14:33:50.312 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:50.312 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:50.312 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:50.312 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:50.312 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:50.312 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:50.313 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:50.313 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-18468-client-A' ...
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : - With feature PathAware
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : - With feature TransactionAware
18-11-18 14:33:50.313 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:50.313 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:50.313 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:50.313 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:50.313 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:50.313 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
18-11-18 14:33:50.313 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
18-11-18 14:33:50.321 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
18-11-18 14:33:50.322 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
18-11-18 14:33:50.330 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
18-11-18 14:33:50.333 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
18-11-18 14:33:50.333 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
18-11-18 14:33:50.340 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
18-11-18 14:33:50.340 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
18-11-18 14:33:50.340 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
18-11-18 14:33:50.340 | 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) ); 
18-11-18 14:33:50.343 | 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 ); 
18-11-18 14:33:50.346 | 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 ); 
18-11-18 14:33:50.348 | 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 ); 
18-11-18 14:33:50.350 | 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 ); 
18-11-18 14:33:50.351 | 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 ); 
18-11-18 14:33:50.353 | 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 ); 
18-11-18 14:33:50.355 | 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 ); 
18-11-18 14:33:50.357 | 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 ); 
18-11-18 14:33:50.359 | 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) ); 
18-11-18 14:33:50.361 | 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) ); 
18-11-18 14:33:50.363 | 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) ); 
18-11-18 14:33:50.365 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
18-11-18 14:33:50.365 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
18-11-18 14:33:50.365 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
18-11-18 14:33:50.368 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
18-11-18 14:33:50.370 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
18-11-18 14:33:50.371 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
18-11-18 14:33:50.374 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
18-11-18 14:33:50.375 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
18-11-18 14:33:50.377 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
18-11-18 14:33:50.377 | 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'; 
18-11-18 14:33:50.379 | 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'; 
18-11-18 14:33:50.380 | 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; 
18-11-18 14:33:50.382 | 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'; 
18-11-18 14:33:50.384 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
18-11-18 14:33:50.384 | 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; 
18-11-18 14:33:50.386 | 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; 
18-11-18 14:33:50.388 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
18-11-18 14:33:50.388 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
18-11-18 14:33:50.388 | 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; 
18-11-18 14:33:50.390 | UpOperation     | Test worker    | INFO : 
18-11-18 14:33:50.390 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
18-11-18 14:33:50.390 | UpOperation     | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.390 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@1c7553fe) ...
18-11-18 14:33:50.391 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.391 | StatusOperation | Test worker    | INFO : 
18-11-18 14:33:50.391 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
18-11-18 14:33:50.391 | StatusOperation | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.391 | StatusOperation | Test worker    | INFO : Force checksum ENABLED.
18-11-18 14:33:50.391 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
18-11-18 14:33:50.391 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@58d2b2f3) ...
18-11-18 14:33:50.392 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-181118143132272-18468-client-A ...
18-11-18 14:33:50.392 | StatusOperation | Test worker    | FINE : - New file: Exposé
18-11-18 14:33:50.393 | StatusOperation | Test worker    | FINE : - New file: One&Two
18-11-18 14:33:50.398 | StatusOperation | Test worker    | FINE : - New file: 這是一個測試
18-11-18 14:33:50.399 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
18-11-18 14:33:50.399 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@70a2684d) ...
18-11-18 14:33:50.399 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
18-11-18 14:33:50.400 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.401 | LsRemoteOperati | Test worker    | INFO : 
18-11-18 14:33:50.401 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
18-11-18 14:33:50.401 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.401 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@4b4aa2a7) ...
18-11-18 14:33:50.404 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
18-11-18 14:33:50.404 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@1ce28e90) ...
18-11-18 14:33:50.404 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
18-11-18 14:33:50.404 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1542551630313] ...
18-11-18 14:33:50.405 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1542551630313]
18-11-18 14:33:50.405 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1542551630313] ...
18-11-18 14:33:50.406 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.411 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
18-11-18 14:33:50.411 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
18-11-18 14:33:50.420 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@769dfa14) ...
18-11-18 14:33:50.420 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
18-11-18 14:33:50.420 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-181118143132272-18468-client-A/Exposé
18-11-18 14:33:50.421 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-181118143132272-18468-client-A/Exposé
18-11-18 14:33:50.423 | Indexer         | AsyncI/syncany | FINE : - Chunk new: c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f
18-11-18 14:33:50.423 | Indexer         | AsyncI/syncany | FINE : - +MultiChunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b
18-11-18 14:33:50.424 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f > 54142a432c6ec49a9c5fa0a96497c9f14b0c831b
18-11-18 14:33:50.426 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f > /tmp/syncanytest/syncany-181118143132272-18468-client-A/Exposé
18-11-18 14:33:50.426 | Indexer         | AsyncI/syncany | FINE : - /File: Exposé (checksum c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f)
18-11-18 14:33:50.428 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: Exposé, checksum: c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f)
18-11-18 14:33:50.428 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file Exposé
18-11-18 14:33:50.428 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.428 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
18-11-18 14:33:50.428 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@60792e08) ...
18-11-18 14:33:50.428 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-181118143132272-18468-client-A/One&Two
18-11-18 14:33:50.429 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-181118143132272-18468-client-A/One&Two
18-11-18 14:33:50.430 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 7a7336e08e4f938e90f74f097abd39029b7a2ac9
18-11-18 14:33:50.430 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 7a7336e08e4f938e90f74f097abd39029b7a2ac9 > 54142a432c6ec49a9c5fa0a96497c9f14b0c831b
18-11-18 14:33:50.435 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 7a7336e08e4f938e90f74f097abd39029b7a2ac9 > /tmp/syncanytest/syncany-181118143132272-18468-client-A/One&Two
18-11-18 14:33:50.435 | Indexer         | AsyncI/syncany | FINE : - /File: One&Two (checksum 7a7336e08e4f938e90f74f097abd39029b7a2ac9)
18-11-18 14:33:50.436 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: One&Two, checksum: 7a7336e08e4f938e90f74f097abd39029b7a2ac9)
18-11-18 14:33:50.436 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file One&Two
18-11-18 14:33:50.437 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=7a7336e08e4f938e90f74f097abd39029b7a2ac9, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.437 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
18-11-18 14:33:50.437 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-181118143132272-18468-client-A/這是一個測試
18-11-18 14:33:50.437 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-181118143132272-18468-client-A/這是一個測試
18-11-18 14:33:50.438 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803
18-11-18 14:33:50.439 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803 > 54142a432c6ec49a9c5fa0a96497c9f14b0c831b
18-11-18 14:33:50.439 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803 > /tmp/syncanytest/syncany-181118143132272-18468-client-A/這是一個測試
18-11-18 14:33:50.439 | Indexer         | AsyncI/syncany | FINE : - /File: 這是一個測試 (checksum 80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803)
18-11-18 14:33:50.440 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: 這是一個測試, checksum: 80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803)
18-11-18 14:33:50.447 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file 這是一個測試
18-11-18 14:33:50.447 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.447 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
18-11-18 14:33:50.448 | Indexer         | AsyncI/syncany | FINE : - /MultiChunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b
18-11-18 14:33:50.448 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@26787c38) ...
18-11-18 14:33:50.448 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1542551630420, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.448 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
18-11-18 14:33:50.448 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
18-11-18 14:33:50.449 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
18-11-18 14:33:50.449 | UpOperation     | Test worker    | INFO : - Uploading multichunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b from /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b to RemoteFile[name=multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b] ...
18-11-18 14:33:50.449 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b -> Temp. remote file: RemoteFile[name=temp-gKhPP-multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b], final location: RemoteFile[name=multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b]
18-11-18 14:33:50.449 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1542551630449, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.449 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1542551630449 to file /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/database-A-0000000001 ... 
18-11-18 14:33:50.449 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/database-A-0000000001 ...
18-11-18 14:33:50.451 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
18-11-18 14:33:50.451 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
18-11-18 14:33:50.451 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-sNZXr-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
18-11-18 14:33:50.451 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
18-11-18 14:33:50.451 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
18-11-18 14:33:50.452 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/temp-transaction-4492003480113525388.tmp
18-11-18 14:33:50.452 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@1914b190) ...
18-11-18 14:33:50.453 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-5598ee3f] ...
18-11-18 14:33:50.453 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
18-11-18 14:33:50.453 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@279eed54) ...
18-11-18 14:33:50.453 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b to temp. file RemoteFile[name=temp-gKhPP-multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b] ...
18-11-18 14:33:50.454 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@62934370) ...
18-11-18 14:33:50.454 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-181118143132272-18468-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-sNZXr-database-A-0000000001] ...
18-11-18 14:33:50.455 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-gKhPP-multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b] to final location RemoteFile[name=multichunk-54142a432c6ec49a9c5fa0a96497c9f14b0c831b] ...
18-11-18 14:33:50.455 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-sNZXr-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
18-11-18 14:33:50.455 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-5598ee3f] ...
18-11-18 14:33:50.456 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
18-11-18 14:33:50.456 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
18-11-18 14:33:50.456 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1542551630449) ...
18-11-18 14:33:50.455 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@16675f3c) ...
18-11-18 14:33:50.461 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
18-11-18 14:33:50.463 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
18-11-18 14:33:50.483 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1542551630449, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.483 | UpOperation     | Test worker    | INFO : Committing local database.
18-11-18 14:33:50.483 | UpOperation     | Test worker    | FINE : Waiting for new database version.
18-11-18 14:33:50.483 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1542551630463, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
18-11-18 14:33:50.483 | UpOperation     | Test worker    | INFO : Sync up done.
18-11-18 14:33:50.494 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1542551630313] ...
18-11-18 14:33:50.500 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1542551630313]
18-11-18 14:33:50.500 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
18-11-18 14:33:50.500 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
18-11-18 14:33:50.500 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@62304de7) ...
18-11-18 14:33:50.502 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:50.502 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-18468-client-B' ...
18-11-18 14:33:50.502 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:50.502 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:50.503 | org.syncany.plu | Test worker    | FINE : Validating required fields
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-181118143132272-18468-client-B' ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : - With feature Retriable
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : - With feature PathAware
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : - With feature TransactionAware
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
18-11-18 14:33:50.503 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
18-11-18 14:33:50.503 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
18-11-18 14:33:50.525 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
18-11-18 14:33:50.532 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
18-11-18 14:33:50.539 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
18-11-18 14:33:50.542 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
18-11-18 14:33:50.542 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
18-11-18 14:33:50.547 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
18-11-18 14:33:50.547 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
18-11-18 14:33:50.547 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
18-11-18 14:33:50.547 | 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) ); 
18-11-18 14:33:50.550 | 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 ); 
18-11-18 14:33:50.552 | 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 ); 
18-11-18 14:33:50.554 | 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 ); 
18-11-18 14:33:50.556 | 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 ); 
18-11-18 14:33:50.557 | 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 ); 
18-11-18 14:33:50.559 | 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 ); 
18-11-18 14:33:50.561 | 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 ); 
18-11-18 14:33:50.563 | 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 ); 
18-11-18 14:33:50.565 | 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) ); 
18-11-18 14:33:50.566 | 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) ); 
18-11-18 14:33:50.568 | 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) ); 
18-11-18 14:33:50.570 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
18-11-18 14:33:50.570 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
18-11-18 14:33:50.570 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
18-11-18 14:33:50.572 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
18-11-18 14:33:50.575 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
18-11-18 14:33:50.576 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
18-11-18 14:33:50.578 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
18-11-18 14:33:50.580 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
18-11-18 14:33:50.581 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
18-11-18 14:33:50.581 | 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'; 
18-11-18 14:33:50.583 | 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'; 
18-11-18 14:33:50.585 | 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; 
18-11-18 14:33:50.587 | 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'; 
18-11-18 14:33:50.590 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
18-11-18 14:33:50.590 | 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; 
18-11-18 14:33:50.592 | 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; 
18-11-18 14:33:50.594 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
18-11-18 14:33:50.594 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
18-11-18 14:33:50.594 | 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; 
18-11-18 14:33:50.596 | DownOperation   | Test worker    | INFO : 
18-11-18 14:33:50.596 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
18-11-18 14:33:50.596 | DownOperation   | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.596 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@464f4845) ...
18-11-18 14:33:50.596 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
18-11-18 14:33:50.597 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.597 | LsRemoteOperati | Test worker    | INFO : 
18-11-18 14:33:50.597 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
18-11-18 14:33:50.597 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
18-11-18 14:33:50.597 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@3be0866c) ...
18-11-18 14:33:50.597 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
18-11-18 14:33:50.597 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
18-11-18 14:33:50.598 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@37f2029b) ...
18-11-18 14:33:50.598 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@a802f4f) ...
18-11-18 14:33:50.598 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1542551630503] ...
18-11-18 14:33:50.598 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1542551630503]
18-11-18 14:33:50.598 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1542551630503] ...
18-11-18 14:33:50.598 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
18-11-18 14:33:50.599 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-181118143132272-18468-client-B/.syncany/cache/database-A-0000000001
18-11-18 14:33:50.599 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@288de58) ...
18-11-18 14:33:50.599 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
18-11-18 14:33:50.599 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-181118143132272-18468-client-B/.syncany/cache/database-A-0000000001 ...
18-11-18 14:33:50.601 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1542551630449
18-11-18 14:33:50.601 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-181118143132272-18468-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
18-11-18 14:33:50.601 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
18-11-18 14:33:50.601 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1542551630449], B=[]}
18-11-18 14:33:50.602 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
18-11-18 14:33:50.602 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1542551630449
18-11-18 14:33:50.602 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
18-11-18 14:33:50.602 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1542551630449
18-11-18 14:33:50.602 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
18-11-18 14:33:50.602 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
18-11-18 14:33:50.602 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
18-11-18 14:33:50.602 | DatabaseReconci | Test worker    | INFO : Losers Branch: []
18-11-18 14:33:50.602 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1542551630449]
18-11-18 14:33:50.602 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
18-11-18 14:33:50.602 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1542551630449]
18-11-18 14:33:50.602 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
18-11-18 14:33:50.602 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-181118143132272-18468-client-B/.syncany/cache/database-A-0000000001 ...
18-11-18 14:33:50.603 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1542551630449
18-11-18 14:33:50.603 | DownOperation   | Test worker    | INFO : Determine file system actions ...
18-11-18 14:33:50.613 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.614 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
18-11-18 14:33:50.614 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
18-11-18 14:33:50.614 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
18-11-18 14:33:50.614 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.614 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file Exposé
18-11-18 14:33:50.614 | 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=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-181118143132272-18468-client-B/Exposé
18-11-18 14:33:50.614 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.615 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
18-11-18 14:33:50.615 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=7a7336e08e4f938e90f74f097abd39029b7a2ac9, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.615 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file One&Two
18-11-18 14:33:50.615 | 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=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=7a7336e08e4f938e90f74f097abd39029b7a2ac9, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-181118143132272-18468-client-B/One&Two
18-11-18 14:33:50.615 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=7a7336e08e4f938e90f74f097abd39029b7a2ac9, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.615 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
18-11-18 14:33:50.615 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]
18-11-18 14:33:50.615 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file 這是一個測試
18-11-18 14:33:50.615 | 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=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-181118143132272-18468-client-B/這是一個測試
18-11-18 14:33:50.616 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.619 | DownOperation   | Test worker    | INFO :   + Adding multichunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b to download list ...
18-11-18 14:33:50.624 | DownOperation   | Test worker    | INFO :   + Adding multichunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b to download list ...
18-11-18 14:33:50.625 | DownOperation   | Test worker    | INFO :   + Adding multichunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b to download list ...
18-11-18 14:33:50.625 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
18-11-18 14:33:50.625 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@3834ae77) ...
18-11-18 14:33:50.625 | Downloader      | Test worker    | INFO :   + Downloading multichunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b ...
18-11-18 14:33:50.626 | Downloader      | Test worker    | INFO :   + Decrypting multichunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b ...
18-11-18 14:33:50.626 | Downloader      | Test worker    | FINE :   + Locally deleting multichunk 54142a432c6ec49a9c5fa0a96497c9f14b0c831b ...
18-11-18 14:33:50.628 | FileSystemActio | Test worker    | INFO :    Sorted actions:
18-11-18 14:33:50.628 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.628 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=7a7336e08e4f938e90f74f097abd39029b7a2ac9, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.628 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.628 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
18-11-18 14:33:50.628 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=Exposé, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=c2b8e91f30ee22837830afe3a0c12c59ecbf2c6f, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.629 | Assembler       | Test worker    | INFO :      - Creating file Exposé to /tmp/syncanytest/syncany-181118143132272-18468-client-B/.syncany/cache/temp-reconstructedFileVersion-4445272540002274335.tmp ...
18-11-18 14:33:50.630 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
18-11-18 14:33:50.636 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=One&Two, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=7a7336e08e4f938e90f74f097abd39029b7a2ac9, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.637 | Assembler       | Test worker    | INFO :      - Creating file One&Two to /tmp/syncanytest/syncany-181118143132272-18468-client-B/.syncany/cache/temp-reconstructedFileVersion-2000549623470445608.tmp ...
18-11-18 14:33:50.638 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
18-11-18 14:33:50.639 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=這是一個測試, type=FILE, status=NEW, size=51200, lastModified=Sun Nov 18 14:33:50 UTC 2018, linkTarget=null, checksum=80ba1db9c5ee1e3a2e026ccb7775c8192b7d5803, updated=Sun Nov 18 14:33:50 UTC 2018, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
18-11-18 14:33:50.639 | Assembler       | Test worker    | INFO :      - Creating file 這是一個測試 to /tmp/syncanytest/syncany-181118143132272-18468-client-B/.syncany/cache/temp-reconstructedFileVersion-7890013068261412386.tmp ...
18-11-18 14:33:50.641 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
18-11-18 14:33:50.644 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
18-11-18 14:33:50.648 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
18-11-18 14:33:50.648 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1542551630449, chunks=3, multiChunks=1, fileContents=3, fileHistories=3]
18-11-18 14:33:50.655 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1542551630503] ...
18-11-18 14:33:50.660 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1542551630503]
18-11-18 14:33:50.660 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
18-11-18 14:33:50.660 | Cache           | Test worker    | INFO : Cache size okay (153 KB), no need to clean (keep size is 500 MB)
18-11-18 14:33:50.660 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@277fa7d9) ...
18-11-18 14:33:50.661 | DownOperation   | Test worker    | INFO : Sync down done.
18-11-18 14:33:50.666 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-181118143132272-18468-client-A/Exposé, but actual PATH = tmp/syncanytest/syncany-181118143132272-18468-client-B/Exposé, for file tmp/syncanytest/syncany-181118143132272-18468-client-B/Exposé
18-11-18 14:33:50.670 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-181118143132272-18468-client-A/這是一個測試, but actual PATH = tmp/syncanytest/syncany-181118143132272-18468-client-B/這是一個測試, for file tmp/syncanytest/syncany-181118143132272-18468-client-B/這是一個測試
18-11-18 14:33:50.676 | FileVersionComp | Test worker    | INFO :      - [CHANGED_PATH]: Local file DIFFERS from file version, expected PATH = tmp/syncanytest/syncany-181118143132272-18468-client-A/One&Two, but actual PATH = tmp/syncanytest/syncany-181118143132272-18468-client-B/One&Two, for file tmp/syncanytest/syncany-181118143132272-18468-client-B/One&Two
18-11-18 14:33:50.676 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.677 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
18-11-18 14:33:50.706 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from chunk order by CHECKSUM asc
18-11-18 14:33:50.707 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select STATUS, LOCALTIME, CLIENT, VECTORCLOCK_SERIALIZED from databaseversion order by ID asc
18-11-18 14:33:50.707 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CLIENT, LOGICALTIME from databaseversion_vectorclock order by DATABASEVERSION_ID asc, CLIENT asc
18-11-18 14:33:50.708 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, SIZE from filecontent order by CHECKSUM asc
18-11-18 14:33:50.710 | 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
18-11-18 14:33:50.710 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID from filehistory order by ID asc, DATABASEVERSION_ID asc
18-11-18 14:33:50.712 | 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
18-11-18 14:33:50.713 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select ID, SIZE from multichunk order by ID asc
18-11-18 14:33:50.713 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select MULTICHUNK_ID, CHUNK_CHECKSUM from multichunk_chunk order by MULTICHUNK_ID asc, CHUNK_CHECKSUM asc