Class org.syncany.tests.integration.scenarios.SymlinkSyncScenarioTest

3

tests

0

failures

0

ignored

1.889s

duration

100%

successful

Tests

Test Duration Result
testSymlinkMultipleUpsAndDowns 0.605s passed
testSymlinkOneUpOneDown 0.524s passed
testSymlinkSyncToNonExistingFolder 0.760s passed

Standard error

29-5-19 15:06:47.100 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.101 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
29-5-19 15:06:47.115 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.117 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-65962-client-A' ...
29-5-19 15:06:47.117 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.117 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.117 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.117 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.117 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.117 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.117 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.117 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.117 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.118 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-65962-client-A' ...
29-5-19 15:06:47.118 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.118 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.118 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:47.118 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:47.119 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.120 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.120 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.120 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.120 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.120 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.120 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:47.120 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:47.140 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:06:47.142 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:06:47.160 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:06:47.166 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:06:47.168 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:06:47.175 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:06:47.175 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:06:47.175 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:06:47.175 | 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) ); 
29-5-19 15:06:47.178 | 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 ); 
29-5-19 15:06:47.180 | 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 ); 
29-5-19 15:06:47.184 | 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 ); 
29-5-19 15:06:47.186 | 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 ); 
29-5-19 15:06:47.190 | 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 ); 
29-5-19 15:06:47.193 | 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 ); 
29-5-19 15:06:47.196 | 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 ); 
29-5-19 15:06:47.214 | 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 ); 
29-5-19 15:06:47.222 | 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) ); 
29-5-19 15:06:47.227 | 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) ); 
29-5-19 15:06:47.230 | 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) ); 
29-5-19 15:06:47.233 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:06:47.233 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:06:47.234 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:06:47.238 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:06:47.240 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:06:47.243 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:06:47.246 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:06:47.249 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:06:47.253 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:06:47.253 | 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'; 
29-5-19 15:06:47.256 | 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'; 
29-5-19 15:06:47.262 | 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; 
29-5-19 15:06:47.266 | 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'; 
29-5-19 15:06:47.274 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:06:47.274 | 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; 
29-5-19 15:06:47.292 | 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; 
29-5-19 15:06:47.295 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:06:47.295 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:06:47.295 | 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; 
29-5-19 15:06:47.298 | UpOperation     | Test worker    | INFO : 
29-5-19 15:06:47.299 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
29-5-19 15:06:47.299 | UpOperation     | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.299 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@6f6dfac4) ...
29-5-19 15:06:47.300 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.300 | StatusOperation | Test worker    | INFO : 
29-5-19 15:06:47.300 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
29-5-19 15:06:47.300 | StatusOperation | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.300 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
29-5-19 15:06:47.300 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@6098857) ...
29-5-19 15:06:47.305 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-190529150340085-65962-client-A ...
29-5-19 15:06:47.306 | StatusOperation | Test worker    | FINE : - New file: symlink-name
29-5-19 15:06:47.306 | StatusOperation | Test worker    | FINE : - New file: symlink-target
29-5-19 15:06:47.306 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
29-5-19 15:06:47.306 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@16ffcf65) ...
29-5-19 15:06:47.306 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:47.309 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.309 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:47.309 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
29-5-19 15:06:47.310 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.310 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@525e3eb3) ...
29-5-19 15:06:47.310 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:47.310 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@10cd7d65) ...
29-5-19 15:06:47.314 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
29-5-19 15:06:47.314 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1559142407120] ...
29-5-19 15:06:47.314 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1559142407120]
29-5-19 15:06:47.314 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1559142407120] ...
29-5-19 15:06:47.317 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.327 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
29-5-19 15:06:47.328 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
29-5-19 15:06:47.328 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@189a8962) ...
29-5-19 15:06:47.330 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
29-5-19 15:06:47.330 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-190529150340085-65962-client-A/symlink-name
29-5-19 15:06:47.331 | Indexer         | AsyncI/syncany | FINE : - /File: symlink-name (directory/symlink/0-byte-file)
29-5-19 15:06:47.332 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: symlink-name, SYMLINK)
29-5-19 15:06:47.333 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file symlink-name
29-5-19 15:06:47.333 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=14, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=symlink-target, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]
29-5-19 15:06:47.333 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
29-5-19 15:06:47.333 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@780ea8de) ...
29-5-19 15:06:47.333 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-190529150340085-65962-client-A/symlink-target
29-5-19 15:06:47.333 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-190529150340085-65962-client-A/symlink-target
29-5-19 15:06:47.367 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 37b63ffdf24f9997c5a836a7e3ff1c601c5d228d
29-5-19 15:06:47.367 | Indexer         | AsyncI/syncany | FINE : - +MultiChunk e348d78907989e4697528f9bf8b5286faf35551a
29-5-19 15:06:47.368 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 37b63ffdf24f9997c5a836a7e3ff1c601c5d228d > e348d78907989e4697528f9bf8b5286faf35551a
29-5-19 15:06:47.370 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 37b63ffdf24f9997c5a836a7e3ff1c601c5d228d > /tmp/syncanytest/syncany-190529150340085-65962-client-A/symlink-target
29-5-19 15:06:47.370 | Indexer         | AsyncI/syncany | FINE : - /File: symlink-target (checksum 37b63ffdf24f9997c5a836a7e3ff1c601c5d228d)
29-5-19 15:06:47.379 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: symlink-target, checksum: 37b63ffdf24f9997c5a836a7e3ff1c601c5d228d)
29-5-19 15:06:47.379 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file symlink-target
29-5-19 15:06:47.380 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=symlink-target, type=FILE, status=NEW, size=51200, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=37b63ffdf24f9997c5a836a7e3ff1c601c5d228d, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]
29-5-19 15:06:47.380 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
29-5-19 15:06:47.380 | Indexer         | AsyncI/syncany | FINE : - /MultiChunk e348d78907989e4697528f9bf8b5286faf35551a
29-5-19 15:06:47.380 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@5288d1c8) ...
29-5-19 15:06:47.381 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142407328, chunks=1, multiChunks=1, fileContents=1, fileHistories=2]
29-5-19 15:06:47.381 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
29-5-19 15:06:47.381 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
29-5-19 15:06:47.381 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@6f647a76) ...
29-5-19 15:06:47.383 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
29-5-19 15:06:47.383 | UpOperation     | Test worker    | INFO : - Uploading multichunk e348d78907989e4697528f9bf8b5286faf35551a from /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/multichunk-e348d78907989e4697528f9bf8b5286faf35551a to RemoteFile[name=multichunk-e348d78907989e4697528f9bf8b5286faf35551a] ...
29-5-19 15:06:47.383 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/multichunk-e348d78907989e4697528f9bf8b5286faf35551a -> Temp. remote file: RemoteFile[name=temp-ycsFX-multichunk-e348d78907989e4697528f9bf8b5286faf35551a], final location: RemoteFile[name=multichunk-e348d78907989e4697528f9bf8b5286faf35551a]
29-5-19 15:06:47.383 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1559142407383, chunks=1, multiChunks=1, fileContents=1, fileHistories=2]
29-5-19 15:06:47.383 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1559142407383 to file /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/database-A-0000000001 ... 
29-5-19 15:06:47.383 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:47.385 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
29-5-19 15:06:47.385 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
29-5-19 15:06:47.385 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-ZHzhB-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
29-5-19 15:06:47.386 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
29-5-19 15:06:47.386 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
29-5-19 15:06:47.387 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
29-5-19 15:06:47.388 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/temp-transaction-8166229384225706674.tmp
29-5-19 15:06:47.388 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@6aeb72a7) ...
29-5-19 15:06:47.388 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-249b644e] ...
29-5-19 15:06:47.388 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
29-5-19 15:06:47.389 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@324ea7eb) ...
29-5-19 15:06:47.389 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/multichunk-e348d78907989e4697528f9bf8b5286faf35551a to temp. file RemoteFile[name=temp-ycsFX-multichunk-e348d78907989e4697528f9bf8b5286faf35551a] ...
29-5-19 15:06:47.389 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@651f5e5e) ...
29-5-19 15:06:47.389 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-65962-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-ZHzhB-database-A-0000000001] ...
29-5-19 15:06:47.391 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-ycsFX-multichunk-e348d78907989e4697528f9bf8b5286faf35551a] to final location RemoteFile[name=multichunk-e348d78907989e4697528f9bf8b5286faf35551a] ...
29-5-19 15:06:47.391 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-ZHzhB-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
29-5-19 15:06:47.391 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-249b644e] ...
29-5-19 15:06:47.392 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
29-5-19 15:06:47.392 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
29-5-19 15:06:47.392 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1559142407383) ...
29-5-19 15:06:47.398 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
29-5-19 15:06:47.414 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1559142407383, chunks=1, multiChunks=1, fileContents=1, fileHistories=2]
29-5-19 15:06:47.414 | UpOperation     | Test worker    | INFO : Committing local database.
29-5-19 15:06:47.414 | UpOperation     | Test worker    | FINE : Waiting for new database version.
29-5-19 15:06:47.414 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142407387, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
29-5-19 15:06:47.414 | UpOperation     | Test worker    | INFO : Sync up done.
29-5-19 15:06:47.418 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1559142407120] ...
29-5-19 15:06:47.426 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1559142407120]
29-5-19 15:06:47.427 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:47.427 | Cache           | Test worker    | INFO : Cache size okay (51 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:47.427 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@723ddb10) ...
29-5-19 15:06:47.427 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.427 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-65962-client-B' ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.429 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-65962-client-B' ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.429 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:47.429 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:47.461 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:06:47.462 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:06:47.477 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:06:47.485 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:06:47.485 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:06:47.501 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:06:47.501 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:06:47.501 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:06:47.501 | 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) ); 
29-5-19 15:06:47.506 | 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 ); 
29-5-19 15:06:47.510 | 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 ); 
29-5-19 15:06:47.515 | 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 ); 
29-5-19 15:06:47.518 | 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 ); 
29-5-19 15:06:47.522 | 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 ); 
29-5-19 15:06:47.527 | 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 ); 
29-5-19 15:06:47.532 | 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 ); 
29-5-19 15:06:47.535 | 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 ); 
29-5-19 15:06:47.540 | 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) ); 
29-5-19 15:06:47.544 | SqlRunner       | Test worker    | INFO : SQL:  CREATE CACHED TABLE IF NOT EXISTS  known_databases ( id int NOT NULL IDENTITY, client varchar(45) NOT NULL, filenumber int NOT NULL, UNIQUE (client, filenumber) ); 
29-5-19 15:06:47.548 | 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) ); 
29-5-19 15:06:47.554 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:06:47.554 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:06:47.555 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:06:47.560 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:06:47.563 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:06:47.566 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:06:47.568 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:06:47.571 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:06:47.573 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:06:47.573 | 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'; 
29-5-19 15:06:47.576 | 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'; 
29-5-19 15:06:47.579 | 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; 
29-5-19 15:06:47.583 | 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'; 
29-5-19 15:06:47.587 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:06:47.587 | 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; 
29-5-19 15:06:47.590 | 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; 
29-5-19 15:06:47.593 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:06:47.593 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:06:47.593 | 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; 
29-5-19 15:06:47.596 | DownOperation   | Test worker    | INFO : 
29-5-19 15:06:47.596 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
29-5-19 15:06:47.596 | DownOperation   | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.596 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@493981e1) ...
29-5-19 15:06:47.596 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:47.597 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.597 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:47.597 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
29-5-19 15:06:47.597 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.597 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@2f9e4a5d) ...
29-5-19 15:06:47.597 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:47.597 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
29-5-19 15:06:47.597 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@488c780f) ...
29-5-19 15:06:47.597 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@140015d5) ...
29-5-19 15:06:47.597 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1559142407429] ...
29-5-19 15:06:47.597 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1559142407429]
29-5-19 15:06:47.598 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1559142407429] ...
29-5-19 15:06:47.598 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
29-5-19 15:06:47.599 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-190529150340085-65962-client-B/.syncany/cache/database-A-0000000001
29-5-19 15:06:47.599 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@510ca4d4) ...
29-5-19 15:06:47.599 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
29-5-19 15:06:47.599 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-190529150340085-65962-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:47.601 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142407383
29-5-19 15:06:47.602 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-190529150340085-65962-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
29-5-19 15:06:47.605 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
29-5-19 15:06:47.606 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1559142407383], B=[]}
29-5-19 15:06:47.606 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
29-5-19 15:06:47.606 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1559142407383
29-5-19 15:06:47.606 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
29-5-19 15:06:47.606 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1559142407383
29-5-19 15:06:47.606 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
29-5-19 15:06:47.607 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
29-5-19 15:06:47.607 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
29-5-19 15:06:47.607 | DatabaseReconci | Test worker    | INFO : Losers Branch: []
29-5-19 15:06:47.607 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1559142407383]
29-5-19 15:06:47.607 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
29-5-19 15:06:47.607 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1559142407383]
29-5-19 15:06:47.607 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
29-5-19 15:06:47.608 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-190529150340085-65962-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:47.617 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142407383
29-5-19 15:06:47.622 | DownOperation   | Test worker    | INFO : Determine file system actions ...
29-5-19 15:06:47.624 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.627 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
29-5-19 15:06:47.631 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
29-5-19 15:06:47.632 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
29-5-19 15:06:47.633 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=14, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=symlink-target, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]
29-5-19 15:06:47.633 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file symlink-name
29-5-19 15:06:47.634 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=14, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=symlink-target, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-] AND /tmp/syncanytest/syncany-190529150340085-65962-client-B/symlink-name
29-5-19 15:06:47.634 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=14, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=symlink-target, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:47.635 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
29-5-19 15:06:47.635 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=symlink-target, type=FILE, status=NEW, size=51200, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=37b63ffdf24f9997c5a836a7e3ff1c601c5d228d, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]
29-5-19 15:06:47.635 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file symlink-target
29-5-19 15:06:47.636 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=symlink-target, type=FILE, status=NEW, size=51200, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=37b63ffdf24f9997c5a836a7e3ff1c601c5d228d, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-190529150340085-65962-client-B/symlink-target
29-5-19 15:06:47.638 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-target, type=FILE, status=NEW, size=51200, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=37b63ffdf24f9997c5a836a7e3ff1c601c5d228d, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
29-5-19 15:06:47.639 | DownOperation   | Test worker    | INFO :   + Adding multichunk e348d78907989e4697528f9bf8b5286faf35551a to download list ...
29-5-19 15:06:47.645 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
29-5-19 15:06:47.645 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@7a8a3ee1) ...
29-5-19 15:06:47.646 | Downloader      | Test worker    | INFO :   + Downloading multichunk e348d78907989e4697528f9bf8b5286faf35551a ...
29-5-19 15:06:47.647 | Downloader      | Test worker    | INFO :   + Decrypting multichunk e348d78907989e4697528f9bf8b5286faf35551a ...
29-5-19 15:06:47.650 | Downloader      | Test worker    | FINE :   + Locally deleting multichunk e348d78907989e4697528f9bf8b5286faf35551a ...
29-5-19 15:06:47.650 | FileSystemActio | Test worker    | INFO :    Sorted actions:
29-5-19 15:06:47.651 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-target, type=FILE, status=NEW, size=51200, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=37b63ffdf24f9997c5a836a7e3ff1c601c5d228d, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
29-5-19 15:06:47.651 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=14, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=symlink-target, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:47.651 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
29-5-19 15:06:47.652 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-target, type=FILE, status=NEW, size=51200, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=37b63ffdf24f9997c5a836a7e3ff1c601c5d228d, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]]
29-5-19 15:06:47.652 | Assembler       | Test worker    | INFO :      - Creating file symlink-target to /tmp/syncanytest/syncany-190529150340085-65962-client-B/.syncany/cache/temp-reconstructedFileVersion-8144314477783880715.tmp ...
29-5-19 15:06:47.656 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rw-rw-r-- ...
29-5-19 15:06:47.666 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=14, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=symlink-target, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:47.667 | FileSystemActio | Test worker    | INFO :      - Creating symlink at /tmp/syncanytest/syncany-190529150340085-65962-client-B/symlink-name (target: symlink-target) ...
29-5-19 15:06:47.668 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
29-5-19 15:06:47.668 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
29-5-19 15:06:47.668 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1559142407383, chunks=1, multiChunks=1, fileContents=1, fileHistories=2]
29-5-19 15:06:47.692 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1559142407429] ...
29-5-19 15:06:47.694 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1559142407429]
29-5-19 15:06:47.695 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:47.696 | Cache           | Test worker    | INFO : Cache size okay (51 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:47.696 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@25804011) ...
29-5-19 15:06:47.696 | DownOperation   | Test worker    | INFO : Sync down done.
29-5-19 15:06:47.708 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.708 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
29-5-19 15:06:47.732 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.732 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-A' ...
29-5-19 15:06:47.732 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.732 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.732 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.732 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.732 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.732 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.732 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.733 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.733 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.733 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-A' ...
29-5-19 15:06:47.733 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.733 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.733 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:47.733 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:47.733 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.733 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.733 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.733 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.733 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.733 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.733 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:47.733 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:47.794 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:06:47.794 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:06:47.806 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:06:47.811 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:06:47.811 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:06:47.817 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:06:47.817 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:06:47.817 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:06:47.818 | 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) ); 
29-5-19 15:06:47.821 | 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 ); 
29-5-19 15:06:47.824 | 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 ); 
29-5-19 15:06:47.831 | 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 ); 
29-5-19 15:06:47.835 | 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 ); 
29-5-19 15:06:47.840 | 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 ); 
29-5-19 15:06:47.844 | 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 ); 
29-5-19 15:06:47.848 | 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 ); 
29-5-19 15:06:47.852 | 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 ); 
29-5-19 15:06:47.856 | 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) ); 
29-5-19 15:06:47.860 | 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) ); 
29-5-19 15:06:47.863 | 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) ); 
29-5-19 15:06:47.867 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:06:47.867 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:06:47.868 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:06:47.872 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:06:47.876 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:06:47.879 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:06:47.882 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:06:47.885 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:06:47.887 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:06:47.887 | 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'; 
29-5-19 15:06:47.899 | 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'; 
29-5-19 15:06:47.903 | 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; 
29-5-19 15:06:47.907 | 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'; 
29-5-19 15:06:47.911 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:06:47.911 | 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; 
29-5-19 15:06:47.915 | 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; 
29-5-19 15:06:47.920 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:06:47.920 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:06:47.920 | 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; 
29-5-19 15:06:47.925 | UpOperation     | Test worker    | INFO : 
29-5-19 15:06:47.925 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
29-5-19 15:06:47.925 | UpOperation     | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.925 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@16af5fb8) ...
29-5-19 15:06:47.926 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.927 | StatusOperation | Test worker    | INFO : 
29-5-19 15:06:47.927 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
29-5-19 15:06:47.927 | StatusOperation | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.927 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
29-5-19 15:06:47.927 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@1f6ed51e) ...
29-5-19 15:06:47.927 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-190529150340085-71557-client-A ...
29-5-19 15:06:47.928 | StatusOperation | Test worker    | FINE : - New file: folder1
29-5-19 15:06:47.929 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
29-5-19 15:06:47.929 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@5de72f6f) ...
29-5-19 15:06:47.929 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:47.930 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.930 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:47.930 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
29-5-19 15:06:47.930 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:47.930 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@27e1765b) ...
29-5-19 15:06:47.930 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:47.930 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@9b0941c) ...
29-5-19 15:06:47.930 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
29-5-19 15:06:47.930 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1559142407733] ...
29-5-19 15:06:47.930 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1559142407733]
29-5-19 15:06:47.931 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1559142407733] ...
29-5-19 15:06:47.931 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:47.938 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
29-5-19 15:06:47.938 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
29-5-19 15:06:47.939 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@31d44e74) ...
29-5-19 15:06:47.939 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
29-5-19 15:06:47.939 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-190529150340085-71557-client-A/folder1
29-5-19 15:06:47.939 | Indexer         | AsyncI/syncany | FINE : - /File: folder1 (directory/symlink/0-byte-file)
29-5-19 15:06:47.943 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: folder1, FOLDER)
29-5-19 15:06:47.943 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file folder1
29-5-19 15:06:47.943 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=folder1, type=FOLDER, status=NEW, size=4096, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxr-x, dosAttributes=--a-]
29-5-19 15:06:47.943 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
29-5-19 15:06:47.943 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@e402063) ...
29-5-19 15:06:47.943 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@1a4f39f2) ...
29-5-19 15:06:47.943 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142407938, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:47.943 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
29-5-19 15:06:47.943 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
29-5-19 15:06:47.944 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
29-5-19 15:06:47.944 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1559142407944, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:47.944 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1559142407944 to file /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000001 ... 
29-5-19 15:06:47.944 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:47.945 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
29-5-19 15:06:47.945 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
29-5-19 15:06:47.945 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-qJEXI-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
29-5-19 15:06:47.946 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
29-5-19 15:06:47.946 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
29-5-19 15:06:47.947 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/temp-transaction-8353765341800143271.tmp
29-5-19 15:06:47.947 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@7dbb656) ...
29-5-19 15:06:47.947 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-3fb3b238] ...
29-5-19 15:06:47.947 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
29-5-19 15:06:47.947 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@65b638c1) ...
29-5-19 15:06:47.947 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-qJEXI-database-A-0000000001] ...
29-5-19 15:06:47.948 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-qJEXI-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
29-5-19 15:06:47.948 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-3fb3b238] ...
29-5-19 15:06:47.950 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
29-5-19 15:06:47.950 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
29-5-19 15:06:47.950 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1559142407944) ...
29-5-19 15:06:47.951 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
29-5-19 15:06:47.952 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@27162c33) ...
29-5-19 15:06:47.963 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
29-5-19 15:06:47.974 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1559142407944, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:47.974 | UpOperation     | Test worker    | INFO : Committing local database.
29-5-19 15:06:47.974 | UpOperation     | Test worker    | FINE : Waiting for new database version.
29-5-19 15:06:47.974 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142407963, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
29-5-19 15:06:47.974 | UpOperation     | Test worker    | INFO : Sync up done.
29-5-19 15:06:47.977 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1559142407733] ...
29-5-19 15:06:47.990 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1559142407733]
29-5-19 15:06:47.990 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:47.990 | Cache           | Test worker    | INFO : Cache size okay (0 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:47.990 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@c94c871) ...
29-5-19 15:06:47.991 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-B' ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.991 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-B' ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:47.991 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:47.991 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:48.039 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:06:48.039 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:06:48.058 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:06:48.061 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:06:48.062 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:06:48.067 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:06:48.068 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:06:48.068 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:06:48.068 | 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) ); 
29-5-19 15:06:48.072 | 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 ); 
29-5-19 15:06:48.076 | 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 ); 
29-5-19 15:06:48.078 | 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 ); 
29-5-19 15:06:48.080 | 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 ); 
29-5-19 15:06:48.083 | 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 ); 
29-5-19 15:06:48.086 | 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 ); 
29-5-19 15:06:48.089 | 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 ); 
29-5-19 15:06:48.092 | 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 ); 
29-5-19 15:06:48.096 | 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) ); 
29-5-19 15:06:48.098 | 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) ); 
29-5-19 15:06:48.101 | 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) ); 
29-5-19 15:06:48.103 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:06:48.103 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:06:48.104 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:06:48.108 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:06:48.111 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:06:48.112 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:06:48.115 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:06:48.117 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:06:48.120 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:06:48.120 | 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'; 
29-5-19 15:06:48.122 | 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'; 
29-5-19 15:06:48.126 | 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; 
29-5-19 15:06:48.128 | 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'; 
29-5-19 15:06:48.132 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:06:48.132 | 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; 
29-5-19 15:06:48.135 | 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; 
29-5-19 15:06:48.138 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:06:48.138 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:06:48.138 | 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; 
29-5-19 15:06:48.141 | DownOperation   | Test worker    | INFO : 
29-5-19 15:06:48.141 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
29-5-19 15:06:48.141 | DownOperation   | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.141 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@28d0bb4b) ...
29-5-19 15:06:48.142 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:48.143 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.143 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:48.143 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
29-5-19 15:06:48.143 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.143 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@47db4d19) ...
29-5-19 15:06:48.143 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:48.143 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
29-5-19 15:06:48.143 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@31160ac8) ...
29-5-19 15:06:48.143 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@655d9444) ...
29-5-19 15:06:48.143 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1559142407991] ...
29-5-19 15:06:48.143 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1559142407991]
29-5-19 15:06:48.144 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1559142407991] ...
29-5-19 15:06:48.146 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
29-5-19 15:06:48.146 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-190529150340085-71557-client-B/.syncany/cache/database-A-0000000001
29-5-19 15:06:48.146 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@6a97c023) ...
29-5-19 15:06:48.147 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
29-5-19 15:06:48.147 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-190529150340085-71557-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:48.151 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142407944
29-5-19 15:06:48.152 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-190529150340085-71557-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
29-5-19 15:06:48.152 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
29-5-19 15:06:48.152 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1559142407944], B=[]}
29-5-19 15:06:48.155 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
29-5-19 15:06:48.155 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1559142407944
29-5-19 15:06:48.155 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
29-5-19 15:06:48.155 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1559142407944
29-5-19 15:06:48.155 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
29-5-19 15:06:48.155 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
29-5-19 15:06:48.155 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
29-5-19 15:06:48.155 | DatabaseReconci | Test worker    | INFO : Losers Branch: []
29-5-19 15:06:48.155 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1559142407944]
29-5-19 15:06:48.156 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
29-5-19 15:06:48.156 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1559142407944]
29-5-19 15:06:48.156 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
29-5-19 15:06:48.157 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-190529150340085-71557-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:48.165 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142407944
29-5-19 15:06:48.173 | DownOperation   | Test worker    | INFO : Determine file system actions ...
29-5-19 15:06:48.178 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.181 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
29-5-19 15:06:48.186 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
29-5-19 15:06:48.186 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
29-5-19 15:06:48.186 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=folder1, type=FOLDER, status=NEW, size=4096, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxr-x, dosAttributes=--a-]
29-5-19 15:06:48.187 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file folder1
29-5-19 15:06:48.188 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=folder1, type=FOLDER, status=NEW, size=4096, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxr-x, dosAttributes=--a-] AND /tmp/syncanytest/syncany-190529150340085-71557-client-B/folder1
29-5-19 15:06:48.188 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=folder1, type=FOLDER, status=NEW, size=4096, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxr-x, dosAttributes=--a-]]
29-5-19 15:06:48.188 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
29-5-19 15:06:48.188 | FileSystemActio | Test worker    | INFO :    Sorted actions:
29-5-19 15:06:48.188 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=folder1, type=FOLDER, status=NEW, size=4096, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxr-x, dosAttributes=--a-]]
29-5-19 15:06:48.188 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
29-5-19 15:06:48.188 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=folder1, type=FOLDER, status=NEW, size=4096, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxr-x, dosAttributes=--a-]]
29-5-19 15:06:48.189 | FileSystemActio | Test worker    | INFO :      - Creating folder at FileVersion [version=1, path=folder1, type=FOLDER, status=NEW, size=4096, lastModified=Wed May 29 15:06:47 UTC 2019, linkTarget=null, checksum=null, updated=Wed May 29 15:06:47 UTC 2019, posixPermissions=rwxrwxr-x, dosAttributes=--a-] ...
29-5-19 15:06:48.190 | FileSystemActio | Test worker    | INFO :      - Creating folder at /tmp/syncanytest/syncany-190529150340085-71557-client-B/folder1 ...
29-5-19 15:06:48.191 | FileSystemActio | Test worker    | INFO :      - Setting POSIX permissions: rwxrwxr-x ...
29-5-19 15:06:48.192 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
29-5-19 15:06:48.192 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
29-5-19 15:06:48.192 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1559142407944, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.203 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1559142407991] ...
29-5-19 15:06:48.210 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1559142407991]
29-5-19 15:06:48.211 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:48.212 | Cache           | Test worker    | INFO : Cache size okay (0 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:48.212 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@727b68dc) ...
29-5-19 15:06:48.212 | DownOperation   | Test worker    | INFO : Sync down done.
29-5-19 15:06:48.214 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.217 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-A' ...
29-5-19 15:06:48.218 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.218 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.218 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.218 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.218 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.218 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.218 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.218 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.218 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.222 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-A' ...
29-5-19 15:06:48.222 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.222 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.222 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:48.222 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:48.222 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.222 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.222 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.223 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.223 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.223 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.223 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:48.223 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:48.231 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.231 | UpOperation     | Test worker    | INFO : 
29-5-19 15:06:48.231 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
29-5-19 15:06:48.232 | UpOperation     | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.232 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@4c326113) ...
29-5-19 15:06:48.233 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.233 | StatusOperation | Test worker    | INFO : 
29-5-19 15:06:48.233 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
29-5-19 15:06:48.233 | StatusOperation | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.233 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
29-5-19 15:06:48.233 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@31ab230b) ...
29-5-19 15:06:48.234 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-190529150340085-71557-client-A ...
29-5-19 15:06:48.235 | StatusOperation | Test worker    | FINE : - New file: folder1/symlink-name
29-5-19 15:06:48.235 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
29-5-19 15:06:48.235 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@7c37d18f) ...
29-5-19 15:06:48.235 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:48.236 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.238 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:48.238 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
29-5-19 15:06:48.238 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.238 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@4ac12745) ...
29-5-19 15:06:48.238 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:48.238 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is already known (in local database). Ignoring.
29-5-19 15:06:48.238 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@1b315513) ...
29-5-19 15:06:48.239 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
29-5-19 15:06:48.239 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1559142408223] ...
29-5-19 15:06:48.239 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1559142408223]
29-5-19 15:06:48.239 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1559142408223] ...
29-5-19 15:06:48.247 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.264 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
29-5-19 15:06:48.266 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
29-5-19 15:06:48.266 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@20b74735) ...
29-5-19 15:06:48.266 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
29-5-19 15:06:48.266 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-190529150340085-71557-client-A/folder1/symlink-name
29-5-19 15:06:48.267 | Indexer         | AsyncI/syncany | FINE : - /File: folder1/symlink-name (directory/symlink/0-byte-file)
29-5-19 15:06:48.278 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: folder1/symlink-name, SYMLINK)
29-5-19 15:06:48.278 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file folder1/symlink-name
29-5-19 15:06:48.278 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=folder1/symlink-name, type=SYMLINK, status=NEW, size=15, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/does/not/exist, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]
29-5-19 15:06:48.279 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
29-5-19 15:06:48.279 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@f624827) ...
29-5-19 15:06:48.279 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@34da5983) ...
29-5-19 15:06:48.279 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142408266, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.279 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@29fb39d4) ...
29-5-19 15:06:48.279 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
29-5-19 15:06:48.279 | UpOperation     | Test worker    | INFO : Last vector clock was: (A1)
29-5-19 15:06:48.279 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
29-5-19 15:06:48.279 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A2)/T=1559142408279, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.280 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A2)/T=1559142408279 to file /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000002 ... 
29-5-19 15:06:48.280 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000002 ...
29-5-19 15:06:48.282 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
29-5-19 15:06:48.282 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000002 to RemoteFile[name=database-A-0000000002] ...
29-5-19 15:06:48.282 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000002 -> Temp. remote file: RemoteFile[name=temp-ikxNd-database-A-0000000002], final location: RemoteFile[name=database-A-0000000002]
29-5-19 15:06:48.283 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
29-5-19 15:06:48.283 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
29-5-19 15:06:48.283 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
29-5-19 15:06:48.284 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/temp-transaction-18092596349681280130.tmp
29-5-19 15:06:48.284 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@1a11ac97) ...
29-5-19 15:06:48.285 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-66e0a3ea] ...
29-5-19 15:06:48.285 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
29-5-19 15:06:48.285 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@2f94012a) ...
29-5-19 15:06:48.285 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-71557-client-A/.syncany/cache/database-A-0000000002 to temp. file RemoteFile[name=temp-ikxNd-database-A-0000000002] ...
29-5-19 15:06:48.286 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-ikxNd-database-A-0000000002] to final location RemoteFile[name=database-A-0000000002] ...
29-5-19 15:06:48.286 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-66e0a3ea] ...
29-5-19 15:06:48.286 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
29-5-19 15:06:48.286 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
29-5-19 15:06:48.286 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A2)/T=1559142408279) ...
29-5-19 15:06:48.287 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
29-5-19 15:06:48.294 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A2)/T=1559142408279, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.295 | UpOperation     | Test worker    | INFO : Committing local database.
29-5-19 15:06:48.295 | UpOperation     | Test worker    | FINE : Waiting for new database version.
29-5-19 15:06:48.295 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142408283, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
29-5-19 15:06:48.295 | UpOperation     | Test worker    | INFO : Sync up done.
29-5-19 15:06:48.298 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1559142408223] ...
29-5-19 15:06:48.307 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1559142408223]
29-5-19 15:06:48.307 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:48.309 | Cache           | Test worker    | INFO : Cache size okay (1 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:48.309 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@3ad12b71) ...
29-5-19 15:06:48.309 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-B' ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.310 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-71557-client-B' ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.310 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:48.310 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:48.317 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.317 | DownOperation   | Test worker    | INFO : 
29-5-19 15:06:48.317 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
29-5-19 15:06:48.317 | DownOperation   | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.317 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@38488364) ...
29-5-19 15:06:48.317 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:48.319 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.319 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:48.319 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
29-5-19 15:06:48.319 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.319 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@42680f57) ...
29-5-19 15:06:48.319 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:48.319 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000002 is new.
29-5-19 15:06:48.319 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is already known (in local database). Ignoring.
29-5-19 15:06:48.320 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@1aa03895) ...
29-5-19 15:06:48.320 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@62ccffbe) ...
29-5-19 15:06:48.320 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1559142408310] ...
29-5-19 15:06:48.320 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1559142408310]
29-5-19 15:06:48.320 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1559142408310] ...
29-5-19 15:06:48.321 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
29-5-19 15:06:48.321 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000002 to local cache at /tmp/syncanytest/syncany-190529150340085-71557-client-B/.syncany/cache/database-A-0000000002
29-5-19 15:06:48.321 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@6390c6cb) ...
29-5-19 15:06:48.322 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
29-5-19 15:06:48.322 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-190529150340085-71557-client-B/.syncany/cache/database-A-0000000002 ...
29-5-19 15:06:48.324 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A2)/T=1559142408279
29-5-19 15:06:48.325 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-190529150340085-71557-repo/databases/database-A-0000000002; maybe invalid file name pattern. Ignoring file.
29-5-19 15:06:48.325 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-190529150340085-71557-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
29-5-19 15:06:48.325 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
29-5-19 15:06:48.325 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A2)/T=1559142408279], B=[A/(A1)/T=1559142407944]}
29-5-19 15:06:48.326 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
29-5-19 15:06:48.326 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1559142407944
29-5-19 15:06:48.326 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A2)/T=1559142408279
29-5-19 15:06:48.326 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
29-5-19 15:06:48.327 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1559142407944
29-5-19 15:06:48.327 | DatabaseReconci | Test worker    | INFO :   + A/(A2)/T=1559142408279
29-5-19 15:06:48.327 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
29-5-19 15:06:48.327 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
29-5-19 15:06:48.327 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
29-5-19 15:06:48.327 | DatabaseReconci | Test worker    | INFO : Losers Branch: [A/(A1)/T=1559142407944]
29-5-19 15:06:48.327 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1559142407944, A/(A2)/T=1559142408279]
29-5-19 15:06:48.328 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
29-5-19 15:06:48.328 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A2)/T=1559142408279]
29-5-19 15:06:48.328 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
29-5-19 15:06:48.328 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-190529150340085-71557-client-B/.syncany/cache/database-A-0000000002 ...
29-5-19 15:06:48.334 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A2)/T=1559142408279
29-5-19 15:06:48.335 | DownOperation   | Test worker    | INFO : Determine file system actions ...
29-5-19 15:06:48.338 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.340 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
29-5-19 15:06:48.343 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
29-5-19 15:06:48.343 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
29-5-19 15:06:48.343 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=folder1/symlink-name, type=SYMLINK, status=NEW, size=15, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/does/not/exist, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]
29-5-19 15:06:48.343 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file folder1/symlink-name
29-5-19 15:06:48.344 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=folder1/symlink-name, type=SYMLINK, status=NEW, size=15, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/does/not/exist, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-] AND /tmp/syncanytest/syncany-190529150340085-71557-client-B/folder1/symlink-name
29-5-19 15:06:48.344 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=folder1/symlink-name, type=SYMLINK, status=NEW, size=15, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/does/not/exist, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:48.344 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
29-5-19 15:06:48.347 | FileSystemActio | Test worker    | INFO :    Sorted actions:
29-5-19 15:06:48.348 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=folder1/symlink-name, type=SYMLINK, status=NEW, size=15, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/does/not/exist, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:48.349 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
29-5-19 15:06:48.349 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=folder1/symlink-name, type=SYMLINK, status=NEW, size=15, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/does/not/exist, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:48.349 | FileSystemActio | Test worker    | INFO :      - Parent folder does not exist, creating /tmp/syncanytest/syncany-190529150340085-71557-client-B/folder1 ...
29-5-19 15:06:48.351 | FileSystemActio | Test worker    | INFO :      - Creating symlink at /tmp/syncanytest/syncany-190529150340085-71557-client-B/folder1/symlink-name (target: /does/not/exist) ...
29-5-19 15:06:48.351 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
29-5-19 15:06:48.351 | DownOperation   | Test worker    | INFO :   + Applying database version (A2)
29-5-19 15:06:48.351 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A2)/T=1559142408279, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.362 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1559142408310] ...
29-5-19 15:06:48.462 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1559142408310]
29-5-19 15:06:48.462 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:48.462 | Cache           | Test worker    | INFO : Cache size okay (1 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:48.462 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@1584e782) ...
29-5-19 15:06:48.462 | DownOperation   | Test worker    | INFO : Sync down done.
29-5-19 15:06:48.467 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.467 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
29-5-19 15:06:48.482 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.484 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-50780-client-A' ...
29-5-19 15:06:48.484 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.484 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.485 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.485 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.485 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.485 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.487 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.487 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.487 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.488 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-50780-client-A' ...
29-5-19 15:06:48.488 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.488 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.488 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:48.489 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:48.489 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.489 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.489 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.489 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.489 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.489 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.490 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:48.490 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:48.550 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:06:48.558 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:06:48.570 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:06:48.577 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:06:48.577 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:06:48.588 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:06:48.588 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:06:48.589 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:06:48.589 | 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) ); 
29-5-19 15:06:48.594 | 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 ); 
29-5-19 15:06:48.598 | 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 ); 
29-5-19 15:06:48.604 | 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 ); 
29-5-19 15:06:48.608 | 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 ); 
29-5-19 15:06:48.611 | 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 ); 
29-5-19 15:06:48.614 | 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 ); 
29-5-19 15:06:48.618 | 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 ); 
29-5-19 15:06:48.621 | 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 ); 
29-5-19 15:06:48.624 | 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) ); 
29-5-19 15:06:48.627 | 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) ); 
29-5-19 15:06:48.630 | 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) ); 
29-5-19 15:06:48.635 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:06:48.635 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:06:48.636 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:06:48.641 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:06:48.645 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:06:48.648 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:06:48.650 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:06:48.653 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:06:48.658 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:06:48.658 | 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'; 
29-5-19 15:06:48.662 | 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'; 
29-5-19 15:06:48.665 | 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; 
29-5-19 15:06:48.669 | 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'; 
29-5-19 15:06:48.673 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:06:48.673 | 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; 
29-5-19 15:06:48.676 | 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; 
29-5-19 15:06:48.679 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:06:48.679 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:06:48.679 | 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; 
29-5-19 15:06:48.683 | UpOperation     | Test worker    | INFO : 
29-5-19 15:06:48.683 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
29-5-19 15:06:48.683 | UpOperation     | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.683 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@4b766d15) ...
29-5-19 15:06:48.684 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.684 | StatusOperation | Test worker    | INFO : 
29-5-19 15:06:48.684 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
29-5-19 15:06:48.684 | StatusOperation | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.684 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
29-5-19 15:06:48.684 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@448dc5c7) ...
29-5-19 15:06:48.685 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-190529150340085-50780-client-A ...
29-5-19 15:06:48.685 | StatusOperation | Test worker    | FINE : - New file: symlink-name
29-5-19 15:06:48.698 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
29-5-19 15:06:48.698 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@b1f71d6) ...
29-5-19 15:06:48.699 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:48.699 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.700 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:48.700 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client A ...
29-5-19 15:06:48.700 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.700 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@1d950bf6) ...
29-5-19 15:06:48.700 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:48.700 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@17ac2c1f) ...
29-5-19 15:06:48.700 | UpOperation     | Test worker    | INFO : No remote changes, ready to upload.
29-5-19 15:06:48.700 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1559142408490] ...
29-5-19 15:06:48.700 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1559142408490]
29-5-19 15:06:48.701 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1559142408490] ...
29-5-19 15:06:48.702 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.711 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
29-5-19 15:06:48.719 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
29-5-19 15:06:48.721 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@44ba404d) ...
29-5-19 15:06:48.724 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
29-5-19 15:06:48.725 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-190529150340085-50780-client-A/symlink-name
29-5-19 15:06:48.725 | Indexer         | AsyncI/syncany | FINE : - /File: symlink-name (directory/symlink/0-byte-file)
29-5-19 15:06:48.730 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: symlink-name, SYMLINK)
29-5-19 15:06:48.732 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file symlink-name
29-5-19 15:06:48.733 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=10, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/etc/hosts, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]
29-5-19 15:06:48.733 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
29-5-19 15:06:48.733 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@7e4181a5) ...
29-5-19 15:06:48.733 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@6f21cc10) ...
29-5-19 15:06:48.733 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142408720, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.733 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
29-5-19 15:06:48.733 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
29-5-19 15:06:48.734 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
29-5-19 15:06:48.734 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1559142408734, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.734 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1559142408734 to file /tmp/syncanytest/syncany-190529150340085-50780-client-A/.syncany/cache/database-A-0000000001 ... 
29-5-19 15:06:48.734 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-190529150340085-50780-client-A/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:48.735 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
29-5-19 15:06:48.735 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-50780-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
29-5-19 15:06:48.735 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150340085-50780-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-xPpOX-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
29-5-19 15:06:48.735 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
29-5-19 15:06:48.735 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
29-5-19 15:06:48.736 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-190529150340085-50780-client-A/.syncany/cache/temp-transaction-3264340984281512094.tmp
29-5-19 15:06:48.736 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@7d72710c) ...
29-5-19 15:06:48.736 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-6b762830] ...
29-5-19 15:06:48.737 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
29-5-19 15:06:48.737 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@550ac7c1) ...
29-5-19 15:06:48.737 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150340085-50780-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-xPpOX-database-A-0000000001] ...
29-5-19 15:06:48.737 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-xPpOX-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
29-5-19 15:06:48.737 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-6b762830] ...
29-5-19 15:06:48.738 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@64244e07) ...
29-5-19 15:06:48.738 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
29-5-19 15:06:48.738 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
29-5-19 15:06:48.738 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1559142408734) ...
29-5-19 15:06:48.739 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
29-5-19 15:06:48.748 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
29-5-19 15:06:48.753 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1559142408734, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.753 | UpOperation     | Test worker    | INFO : Committing local database.
29-5-19 15:06:48.753 | UpOperation     | Test worker    | FINE : Waiting for new database version.
29-5-19 15:06:48.753 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142408748, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
29-5-19 15:06:48.753 | UpOperation     | Test worker    | INFO : Sync up done.
29-5-19 15:06:48.766 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1559142408490] ...
29-5-19 15:06:48.774 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1559142408490]
29-5-19 15:06:48.775 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:48.775 | Cache           | Test worker    | INFO : Cache size okay (0 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:48.775 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@53d091) ...
29-5-19 15:06:48.776 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.777 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.777 | FileVersionSqlD | Test worker    | INFO :  getFileTree(path = symlink-name, history = %, minSlash = 0, maxSlash = 0, date <= Sat Jan 01 01:01:01 UTC 2101, types = FILE, FOLDER, SYMLINK
29-5-19 15:06:48.784 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.786 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-50780-client-B' ...
29-5-19 15:06:48.786 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.787 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.787 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.787 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.787 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.787 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.787 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.787 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.787 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:06:48.787 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150340085-50780-client-B' ...
29-5-19 15:06:48.787 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:06:48.787 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:06:48.787 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:06:48.787 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:06:48.788 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:06:48.788 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:06:48.788 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:06:48.788 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:06:48.788 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:06:48.788 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:06:48.788 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:06:48.788 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:06:48.845 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:06:48.846 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:06:48.856 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:06:48.860 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:06:48.862 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:06:48.872 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:06:48.872 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:06:48.874 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:06:48.874 | 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) ); 
29-5-19 15:06:48.879 | 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 ); 
29-5-19 15:06:48.881 | 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 ); 
29-5-19 15:06:48.883 | 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 ); 
29-5-19 15:06:48.885 | 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 ); 
29-5-19 15:06:48.888 | 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 ); 
29-5-19 15:06:48.890 | 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 ); 
29-5-19 15:06:48.893 | 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 ); 
29-5-19 15:06:48.899 | 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 ); 
29-5-19 15:06:48.901 | 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) ); 
29-5-19 15:06:48.904 | 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) ); 
29-5-19 15:06:48.907 | 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) ); 
29-5-19 15:06:48.910 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:06:48.910 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:06:48.911 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:06:48.917 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:06:48.919 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:06:48.922 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:06:48.924 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:06:48.926 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:06:48.928 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:06:48.928 | 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'; 
29-5-19 15:06:48.931 | 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'; 
29-5-19 15:06:48.933 | 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; 
29-5-19 15:06:48.935 | 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'; 
29-5-19 15:06:48.938 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:06:48.938 | 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; 
29-5-19 15:06:48.941 | 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; 
29-5-19 15:06:48.943 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:06:48.943 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:06:48.943 | 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; 
29-5-19 15:06:48.946 | DownOperation   | Test worker    | INFO : 
29-5-19 15:06:48.946 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
29-5-19 15:06:48.946 | DownOperation   | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.946 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@283a5f6e) ...
29-5-19 15:06:48.946 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:06:48.947 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.947 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:06:48.947 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
29-5-19 15:06:48.947 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:06:48.947 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@21964375) ...
29-5-19 15:06:48.947 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:06:48.947 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
29-5-19 15:06:48.947 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@32f0ce10) ...
29-5-19 15:06:48.947 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@2a6dc2fd) ...
29-5-19 15:06:48.947 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1559142408788] ...
29-5-19 15:06:48.947 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1559142408788]
29-5-19 15:06:48.948 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1559142408788] ...
29-5-19 15:06:48.948 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
29-5-19 15:06:48.948 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-190529150340085-50780-client-B/.syncany/cache/database-A-0000000001
29-5-19 15:06:48.948 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@1c570573) ...
29-5-19 15:06:48.949 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
29-5-19 15:06:48.949 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-190529150340085-50780-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:48.950 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142408734
29-5-19 15:06:48.950 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-190529150340085-50780-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
29-5-19 15:06:48.951 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
29-5-19 15:06:48.951 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1559142408734], B=[]}
29-5-19 15:06:48.951 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
29-5-19 15:06:48.951 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1559142408734
29-5-19 15:06:48.951 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
29-5-19 15:06:48.951 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1559142408734
29-5-19 15:06:48.951 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: []
29-5-19 15:06:48.951 | DownOperation   | Test worker    | INFO :   + Nothing to purge locally. No conflicts. Only updates. Nice!
29-5-19 15:06:48.951 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
29-5-19 15:06:48.951 | DatabaseReconci | Test worker    | INFO : Losers Branch: []
29-5-19 15:06:48.951 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1559142408734]
29-5-19 15:06:48.951 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
29-5-19 15:06:48.951 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1559142408734]
29-5-19 15:06:48.951 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
29-5-19 15:06:48.951 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-190529150340085-50780-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:06:48.952 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142408734
29-5-19 15:06:48.952 | DownOperation   | Test worker    | INFO : Determine file system actions ...
29-5-19 15:06:48.953 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:06:48.954 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
29-5-19 15:06:48.954 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
29-5-19 15:06:48.954 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
29-5-19 15:06:48.962 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=10, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/etc/hosts, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]
29-5-19 15:06:48.962 | FileVersionComp | Test worker    | INFO :      - [DELETED]: Local file DIFFERS from file version, expected EXISTS = true, but actual EXISTS = false, for file symlink-name
29-5-19 15:06:48.963 | FileSystemActio | Test worker    | INFO :      -> (2) Deleted: Local file does NOT exist, but it should, winning version not known: FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=10, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/etc/hosts, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-] AND /tmp/syncanytest/syncany-190529150340085-50780-client-B/symlink-name
29-5-19 15:06:48.963 | FileSystemActio | Test worker    | INFO :      -> NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=10, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/etc/hosts, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:48.963 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
29-5-19 15:06:48.963 | FileSystemActio | Test worker    | INFO :    Sorted actions:
29-5-19 15:06:48.963 | FileSystemActio | Test worker    | INFO :    + NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=10, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/etc/hosts, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:48.963 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
29-5-19 15:06:48.963 | DownOperation   | Test worker    | FINE :    +  NewFileSystemAction [file1=null, file2=FileVersion [version=1, path=symlink-name, type=SYMLINK, status=NEW, size=10, lastModified=Wed May 29 15:06:48 UTC 2019, linkTarget=/etc/hosts, checksum=null, updated=Wed May 29 15:06:48 UTC 2019, posixPermissions=rwxrwxrwx, dosAttributes=--a-]]
29-5-19 15:06:48.963 | FileSystemActio | Test worker    | INFO :      - Creating symlink at /tmp/syncanytest/syncany-190529150340085-50780-client-B/symlink-name (target: /etc/hosts) ...
29-5-19 15:06:48.963 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
29-5-19 15:06:48.963 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
29-5-19 15:06:48.963 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1559142408734, chunks=0, multiChunks=0, fileContents=0, fileHistories=1]
29-5-19 15:06:48.977 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1559142408788] ...
29-5-19 15:06:48.985 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1559142408788]
29-5-19 15:06:48.986 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:06:48.986 | Cache           | Test worker    | INFO : Cache size okay (0 KB), no need to clean (keep size is 500 MB)
29-5-19 15:06:48.986 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@66132f6f) ...
29-5-19 15:06:48.986 | DownOperation   | Test worker    | INFO : Sync down done.