Class org.syncany.tests.integration.scenarios.FirstVersionDirtyScenarioTest

1

tests

0

failures

0

ignored

0.958s

duration

100%

successful

Tests

Test Duration Result
testFirstVersionDirty 0.958s passed

Standard error

29-5-19 15:05:22.137 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:05:22.138 | LocalTransferMa | Test worker    | INFO : testTargetExists: Target exists.
29-5-19 15:05:22.162 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:05:22.163 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150308467-30934-client-A' ...
29-5-19 15:05:22.163 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:05:22.163 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:05:22.163 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:05:22.163 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:05:22.163 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:05:22.163 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:05:22.163 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:05:22.164 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:05:22.164 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:05:22.164 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150308467-30934-client-A' ...
29-5-19 15:05:22.164 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:05:22.164 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:05:22.164 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:05:22.164 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:05:22.164 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:05:22.164 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:05:22.164 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:05:22.164 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:05:22.164 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:05:22.164 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:05:22.166 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:05:22.166 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:05:22.191 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:05:22.191 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:05:22.200 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:05:22.203 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:05:22.204 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:05:22.210 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:05:22.210 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:05:22.210 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:05:22.210 | 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:05:22.213 | 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:05:22.216 | 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:05:22.218 | 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:05:22.220 | 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:05:22.222 | 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:05:22.225 | 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:05:22.227 | 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:05:22.229 | 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:05:22.231 | 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:05:22.233 | 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:05:22.235 | 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:05:22.237 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:05:22.237 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:05:22.238 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:05:22.241 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:05:22.243 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:05:22.245 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:05:22.247 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:05:22.249 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:05:22.252 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:05:22.252 | 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:05:22.255 | 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:05:22.257 | 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:05:22.260 | 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:05:22.263 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:05:22.263 | 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:05:22.265 | 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:05:22.268 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:05:22.268 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:05:22.268 | 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:05:22.271 | UpOperation     | Test worker    | INFO : 
29-5-19 15:05:22.271 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client A ...
29-5-19 15:05:22.271 | UpOperation     | Test worker    | INFO : --------------------------------------------
29-5-19 15:05:22.271 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@5a1d4e47) ...
29-5-19 15:05:22.272 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:22.272 | StatusOperation | Test worker    | INFO : 
29-5-19 15:05:22.272 | StatusOperation | Test worker    | INFO : Running 'Status' at client A ...
29-5-19 15:05:22.272 | StatusOperation | Test worker    | INFO : --------------------------------------------
29-5-19 15:05:22.272 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
29-5-19 15:05:22.272 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@6021da3f) ...
29-5-19 15:05:22.273 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-190529150308467-30934-client-A ...
29-5-19 15:05:22.273 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
29-5-19 15:05:22.273 | StatusOperation | Test worker    | FINE : - New file: A-file1.jpg
29-5-19 15:05:22.273 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@3a1da7c3) ...
29-5-19 15:05:22.273 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:05:22.273 | UpOperation     | Test worker    | INFO : Force (--force-upload) is enabled, ignoring potential remote changes.
29-5-19 15:05:22.273 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-A-1559142322166] ...
29-5-19 15:05:22.273 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-A-1559142322166]
29-5-19 15:05:22.274 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-A-1559142322166] ...
29-5-19 15:05:22.274 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:22.278 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
29-5-19 15:05:22.282 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
29-5-19 15:05:22.282 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@250a3c40) ...
29-5-19 15:05:22.282 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
29-5-19 15:05:22.282 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-190529150308467-30934-client-A/A-file1.jpg
29-5-19 15:05:22.282 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-190529150308467-30934-client-A/A-file1.jpg
29-5-19 15:05:22.316 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 77e9517e862a7b3df2907adc44b64f02360ed818
29-5-19 15:05:22.317 | Indexer         | AsyncI/syncany | FINE : - +MultiChunk fa7273cec5620779aad3df69994544f9b9c32869
29-5-19 15:05:22.332 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 77e9517e862a7b3df2907adc44b64f02360ed818 > fa7273cec5620779aad3df69994544f9b9c32869
29-5-19 15:05:22.332 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 77e9517e862a7b3df2907adc44b64f02360ed818 > /tmp/syncanytest/syncany-190529150308467-30934-client-A/A-file1.jpg
29-5-19 15:05:22.347 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 657bd53b3946c4b834a0a09f4c7bf815ae41242a
29-5-19 15:05:22.360 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 657bd53b3946c4b834a0a09f4c7bf815ae41242a > fa7273cec5620779aad3df69994544f9b9c32869
29-5-19 15:05:22.360 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 657bd53b3946c4b834a0a09f4c7bf815ae41242a > /tmp/syncanytest/syncany-190529150308467-30934-client-A/A-file1.jpg
29-5-19 15:05:22.360 | Indexer         | AsyncI/syncany | FINE : - /File: A-file1.jpg (checksum 92ed30c76738a6e139e13cd400cbe1a11b2ce69f)
29-5-19 15:05:22.361 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: A-file1.jpg, checksum: 92ed30c76738a6e139e13cd400cbe1a11b2ce69f)
29-5-19 15:05:22.361 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file A-file1.jpg
29-5-19 15:05:22.361 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=A-file1.jpg, type=FILE, status=NEW, size=1048576, lastModified=Wed May 29 15:05:22 UTC 2019, linkTarget=null, checksum=92ed30c76738a6e139e13cd400cbe1a11b2ce69f, updated=Wed May 29 15:05:22 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]
29-5-19 15:05:22.361 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
29-5-19 15:05:22.361 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@283fd82d) ...
29-5-19 15:05:22.367 | Indexer         | AsyncI/syncany | FINE : - /MultiChunk fa7273cec5620779aad3df69994544f9b9c32869
29-5-19 15:05:22.367 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@113926f5) ...
29-5-19 15:05:22.367 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142322282, chunks=2, multiChunks=1, fileContents=1, fileHistories=1]
29-5-19 15:05:22.367 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@c4b3694) ...
29-5-19 15:05:22.367 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
29-5-19 15:05:22.367 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
29-5-19 15:05:22.368 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
29-5-19 15:05:22.368 | UpOperation     | Test worker    | INFO : - Uploading multichunk fa7273cec5620779aad3df69994544f9b9c32869 from /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/multichunk-fa7273cec5620779aad3df69994544f9b9c32869 to RemoteFile[name=multichunk-fa7273cec5620779aad3df69994544f9b9c32869] ...
29-5-19 15:05:22.368 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/multichunk-fa7273cec5620779aad3df69994544f9b9c32869 -> Temp. remote file: RemoteFile[name=temp-aOAhS-multichunk-fa7273cec5620779aad3df69994544f9b9c32869], final location: RemoteFile[name=multichunk-fa7273cec5620779aad3df69994544f9b9c32869]
29-5-19 15:05:22.368 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=A/(A1)/T=1559142322368, chunks=2, multiChunks=1, fileContents=1, fileHistories=1]
29-5-19 15:05:22.368 | UpOperation     | Test worker    | INFO : Saving local delta database, version A/(A1)/T=1559142322368 to file /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/database-A-0000000001 ... 
29-5-19 15:05:22.368 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/database-A-0000000001 ...
29-5-19 15:05:22.369 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
29-5-19 15:05:22.369 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/database-A-0000000001 to RemoteFile[name=database-A-0000000001] ...
29-5-19 15:05:22.369 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/database-A-0000000001 -> Temp. remote file: RemoteFile[name=temp-cgklJ-database-A-0000000001], final location: RemoteFile[name=database-A-0000000001]
29-5-19 15:05:22.370 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
29-5-19 15:05:22.370 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
29-5-19 15:05:22.372 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
29-5-19 15:05:22.373 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/temp-transaction-14374217240894877982.tmp
29-5-19 15:05:22.374 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@464644c5) ...
29-5-19 15:05:22.374 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-532148f6] ...
29-5-19 15:05:22.374 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
29-5-19 15:05:22.374 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@46d1e014) ...
29-5-19 15:05:22.374 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/multichunk-fa7273cec5620779aad3df69994544f9b9c32869 to temp. file RemoteFile[name=temp-aOAhS-multichunk-fa7273cec5620779aad3df69994544f9b9c32869] ...
29-5-19 15:05:22.376 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@1f1e8f0b) ...
29-5-19 15:05:22.376 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150308467-30934-client-A/.syncany/cache/database-A-0000000001 to temp. file RemoteFile[name=temp-cgklJ-database-A-0000000001] ...
29-5-19 15:05:22.384 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-aOAhS-multichunk-fa7273cec5620779aad3df69994544f9b9c32869] to final location RemoteFile[name=multichunk-fa7273cec5620779aad3df69994544f9b9c32869] ...
29-5-19 15:05:22.384 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-cgklJ-database-A-0000000001] to final location RemoteFile[name=database-A-0000000001] ...
29-5-19 15:05:22.386 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-532148f6] ...
29-5-19 15:05:22.386 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
29-5-19 15:05:22.386 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
29-5-19 15:05:22.386 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version A/(A1)/T=1559142322368) ...
29-5-19 15:05:22.397 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
29-5-19 15:05:22.405 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=A/(A1)/T=1559142322368, chunks=2, multiChunks=1, fileContents=1, fileHistories=1]
29-5-19 15:05:22.405 | UpOperation     | Test worker    | INFO : Committing local database.
29-5-19 15:05:22.405 | UpOperation     | Test worker    | FINE : Waiting for new database version.
29-5-19 15:05:22.405 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142322372, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
29-5-19 15:05:22.405 | UpOperation     | Test worker    | INFO : Sync up done.
29-5-19 15:05:22.407 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-A-1559142322166] ...
29-5-19 15:05:22.411 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-A-1559142322166]
29-5-19 15:05:22.411 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:05:22.412 | Cache           | Test worker    | INFO : Cache size okay (1025 KB), no need to clean (keep size is 500 MB)
29-5-19 15:05:22.412 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@2ec2d831) ...
29-5-19 15:05:22.615 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:05:22.616 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150308467-30934-client-B' ...
29-5-19 15:05:22.616 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:05:22.616 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:05:22.616 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:05:22.616 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:05:22.616 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:05:22.616 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:05:22.617 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:05:22.617 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:05:22.617 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:05:22.617 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150308467-30934-client-B' ...
29-5-19 15:05:22.617 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:05:22.617 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:05:22.617 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:05:22.617 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:05:22.617 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:05:22.617 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:05:22.617 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:05:22.617 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:05:22.617 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:05:22.617 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:05:22.618 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:05:22.618 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:05:22.659 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint start
29-5-19 15:05:22.660 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose start
29-5-19 15:05:22.669 | hsqldb.db.HSQLD | Test worker    | FINE : log close size: 0
29-5-19 15:05:22.673 | hsqldb.db.HSQLD | Test worker    | INFO : checkpointClose end
29-5-19 15:05:22.674 | hsqldb.db.HSQLD | Test worker    | INFO : Checkpoint end - txts: 1
29-5-19 15:05:22.680 | DatabaseConnect | Test worker    | INFO : Found 0 tables.
29-5-19 15:05:22.680 | DatabaseConnect | Test worker    | INFO : Database has no tables. Creating tables from script.create.all.sql
29-5-19 15:05:22.680 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Tables
29-5-19 15:05:22.680 | 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:05:22.682 | 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:05:22.684 | 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:05:22.686 | 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:05:22.688 | 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:05:22.691 | 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:05:22.693 | 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:05:22.696 | 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:05:22.698 | 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:05:22.701 | 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:05:22.703 | 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:05:22.706 | 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:05:22.709 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Non-primary indices
29-5-19 15:05:22.709 | SqlRunner       | Test worker    | INFO : SQL:   CREATE INDEX idx_databaseversion_status ON databaseversion (status); 
29-5-19 15:05:22.710 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open start
29-5-19 15:05:22.713 | hsqldb.db.HSQLD | Test worker    | INFO : dataFileCache open end
29-5-19 15:05:22.715 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_databaseversion_vectorclock_serialized ON databaseversion (vectorclock_serialized); 
29-5-19 15:05:22.717 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_path ON fileversion (path); 
29-5-19 15:05:22.720 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_status ON fileversion (status); 
29-5-19 15:05:22.722 | SqlRunner       | Test worker    | INFO : SQL: CREATE INDEX idx_fileversion_filecontent_checksum ON fileversion (filecontent_checksum); 
29-5-19 15:05:22.724 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Views
29-5-19 15:05:22.724 | 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:05:22.727 | 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:05:22.730 | 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:05:22.732 | 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:05:22.735 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Full Views
29-5-19 15:05:22.736 | 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:05:22.738 | 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:05:22.790 | SqlRunner       | Test worker    | INFO : SQL (comment): -- Functions
29-5-19 15:05:22.790 | SqlRunner       | Test worker    | INFO : SQL (new delimiter): end;
29-5-19 15:05:22.790 | 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:05:22.798 | UpOperation     | Test worker    | INFO : 
29-5-19 15:05:22.798 | UpOperation     | Test worker    | INFO : Running 'Sync up' at client B ...
29-5-19 15:05:22.798 | UpOperation     | Test worker    | INFO : --------------------------------------------
29-5-19 15:05:22.798 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpStartSyncExternalEvent@7e509128) ...
29-5-19 15:05:22.799 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:22.799 | StatusOperation | Test worker    | INFO : 
29-5-19 15:05:22.799 | StatusOperation | Test worker    | INFO : Running 'Status' at client B ...
29-5-19 15:05:22.799 | StatusOperation | Test worker    | INFO : --------------------------------------------
29-5-19 15:05:22.799 | StatusOperation | Test worker    | INFO : Querying current file tree from database ...
29-5-19 15:05:22.799 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusStartSyncExternalEvent (org.syncany.operations.daemon.messages.StatusStartSyncExternalEvent@5572d355) ...
29-5-19 15:05:22.800 | StatusOperation | Test worker    | INFO : Analyzing local folder /tmp/syncanytest/syncany-190529150308467-30934-client-B ...
29-5-19 15:05:22.800 | StatusOperation | Test worker    | FINE : - Ignoring file (syncany app-related): .syncany
29-5-19 15:05:22.800 | StatusOperation | Test worker    | FINE : - New file: A-file1.jpg
29-5-19 15:05:22.800 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event StatusEndSyncExternalEvent (org.syncany.operations.daemon.messages.StatusEndSyncExternalEvent@3541857d) ...
29-5-19 15:05:22.800 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:05:22.800 | UpOperation     | Test worker    | INFO : Force (--force-upload) is enabled, ignoring potential remote changes.
29-5-19 15:05:22.800 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-up-B-1559142322618] ...
29-5-19 15:05:22.800 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-up-B-1559142322618]
29-5-19 15:05:22.801 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-up-B-1559142322618] ...
29-5-19 15:05:22.801 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:22.810 | TransactionAwar | Test worker    | INFO : Done rolling back previous transactions.
29-5-19 15:05:22.810 | AsyncIndexer    | AsyncI/syncany | INFO : Starting Indexing.
29-5-19 15:05:22.811 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexStartSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexStartSyncExternalEvent@27fd2398) ...
29-5-19 15:05:22.811 | Indexer         | AsyncI/syncany | FINE : - Looking for deleted files ...
29-5-19 15:05:22.811 | Indexer         | AsyncI/syncany | FINE : - +File /tmp/syncanytest/syncany-190529150308467-30934-client-B/A-file1.jpg
29-5-19 15:05:22.811 | Indexer         | AsyncI/syncany | FINE : - +FileContent: /tmp/syncanytest/syncany-190529150308467-30934-client-B/A-file1.jpg
29-5-19 15:05:22.824 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 77e9517e862a7b3df2907adc44b64f02360ed818
29-5-19 15:05:22.824 | Indexer         | AsyncI/syncany | FINE : - +MultiChunk 8456d84201a3a043013c5e1ef9e5d7b87b52009b
29-5-19 15:05:22.834 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 77e9517e862a7b3df2907adc44b64f02360ed818 > 8456d84201a3a043013c5e1ef9e5d7b87b52009b
29-5-19 15:05:22.834 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 77e9517e862a7b3df2907adc44b64f02360ed818 > /tmp/syncanytest/syncany-190529150308467-30934-client-B/A-file1.jpg
29-5-19 15:05:22.848 | Indexer         | AsyncI/syncany | FINE : - Chunk new: 657bd53b3946c4b834a0a09f4c7bf815ae41242a
29-5-19 15:05:22.883 | Indexer         | AsyncI/syncany | FINE : - Chunk > MultiChunk: 657bd53b3946c4b834a0a09f4c7bf815ae41242a > 8456d84201a3a043013c5e1ef9e5d7b87b52009b
29-5-19 15:05:22.883 | Indexer         | AsyncI/syncany | FINE : - Chunk > FileContent: 657bd53b3946c4b834a0a09f4c7bf815ae41242a > /tmp/syncanytest/syncany-190529150308467-30934-client-B/A-file1.jpg
29-5-19 15:05:22.883 | Indexer         | AsyncI/syncany | FINE : - /File: A-file1.jpg (checksum 92ed30c76738a6e139e13cd400cbe1a11b2ce69f)
29-5-19 15:05:22.890 | Indexer         | AsyncI/syncany | FINE :    * No old file history found, starting new history (path: A-file1.jpg, checksum: 92ed30c76738a6e139e13cd400cbe1a11b2ce69f)
29-5-19 15:05:22.892 | FileVersionComp | AsyncI/syncany | INFO :      - [DELETED]: Local file DIFFERS from file version, actual file is NULL, for file A-file1.jpg
29-5-19 15:05:22.892 | Indexer         | AsyncI/syncany | INFO :    * Added file version:    FileVersion [version=1, path=A-file1.jpg, type=FILE, status=NEW, size=1048576, lastModified=Wed May 29 15:05:22 UTC 2019, linkTarget=null, checksum=92ed30c76738a6e139e13cd400cbe1a11b2ce69f, updated=Wed May 29 15:05:22 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]
29-5-19 15:05:22.892 | Indexer         | AsyncI/syncany | INFO :      based on file version: null
29-5-19 15:05:22.892 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexChangesDetectedSyncExternalEvent@6d57585e) ...
29-5-19 15:05:22.893 | Indexer         | AsyncI/syncany | FINE : - /MultiChunk 8456d84201a3a043013c5e1ef9e5d7b87b52009b
29-5-19 15:05:22.893 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexEndSyncExternalEvent@1f37debd) ...
29-5-19 15:05:22.893 | Indexer         | AsyncI/syncany | FINE : Processed new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142322810, chunks=2, multiChunks=1, fileContents=1, fileHistories=1]
29-5-19 15:05:22.893 | InternalEventBu | AsyncI/syncany | INFO : Event bus 'LocalEventBus': Posting event UpIndexMidSyncExternalEvent (org.syncany.operations.daemon.messages.UpIndexMidSyncExternalEvent@9b75095) ...
29-5-19 15:05:22.894 | UpOperation     | Test worker    | INFO : No DIRTY data found in database (no dirty databases); Nothing to do here.
29-5-19 15:05:22.895 | UpOperation     | Test worker    | INFO : Last vector clock was: ()
29-5-19 15:05:22.896 | UpOperation     | Test worker    | INFO : Uploading new multichunks ...
29-5-19 15:05:22.897 | UpOperation     | Test worker    | INFO : - Uploading multichunk 8456d84201a3a043013c5e1ef9e5d7b87b52009b from /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b to RemoteFile[name=multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b] ...
29-5-19 15:05:22.897 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b -> Temp. remote file: RemoteFile[name=temp-HydQg-multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b], final location: RemoteFile[name=multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b]
29-5-19 15:05:22.897 | UpOperation     | Test worker    | INFO : Uploading database: DatabaseVersion [header=B/(B1)/T=1559142322896, chunks=2, multiChunks=1, fileContents=1, fileHistories=1]
29-5-19 15:05:22.897 | UpOperation     | Test worker    | INFO : Saving local delta database, version B/(B1)/T=1559142322896 to file /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-B-0000000001 ... 
29-5-19 15:05:22.897 | UpOperation     | Test worker    | INFO : - Saving database to /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-B-0000000001 ...
29-5-19 15:05:22.899 | UpOperation     | Test worker    | INFO : - Uploading local delta database file ...
29-5-19 15:05:22.899 | UpOperation     | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-B-0000000001 to RemoteFile[name=database-B-0000000001] ...
29-5-19 15:05:22.899 | RemoteTransacti | Test worker    | INFO : - Adding file to TX for UPLOAD: /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-B-0000000001 -> Temp. remote file: RemoteFile[name=temp-wxijP-database-B-0000000001], final location: RemoteFile[name=database-B-0000000001]
29-5-19 15:05:22.899 | UpOperation     | Test worker    | INFO : Adding shutdown hook (to allow resuming the upload) ...
29-5-19 15:05:22.899 | RemoteTransacti | Test worker    | INFO : Starting TX.commit() ...
29-5-19 15:05:22.904 | RemoteTransacti | Test worker    | INFO : Wrote transaction manifest to temporary file: /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/temp-transaction-10510822866404578119.tmp
29-5-19 15:05:22.904 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileSyncExternalEvent@3c2abfe3) ...
29-5-19 15:05:22.904 | RemoteTransacti | Test worker    | INFO : - Uploading remote transaction file RemoteFile[name=transaction-34dd1f1] ...
29-5-19 15:05:22.905 | RemoteTransacti | Test worker    | INFO : - Starting to upload data in commit.
29-5-19 15:05:22.905 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@6fe3c1eb) ...
29-5-19 15:05:22.905 | AsyncIndexer    | AsyncI/syncany | INFO : Stopping indexing. Signal end of stream with empty databaseversion
29-5-19 15:05:22.906 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b to temp. file RemoteFile[name=temp-HydQg-multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b] ...
29-5-19 15:05:22.907 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpUploadFileInTransactionSyncExternalEvent (org.syncany.operations.daemon.messages.UpUploadFileInTransactionSyncExternalEvent@4a0bbfac) ...
29-5-19 15:05:22.907 | RemoteTransacti | Test worker    | INFO : - Uploading /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-B-0000000001 to temp. file RemoteFile[name=temp-wxijP-database-B-0000000001] ...
29-5-19 15:05:22.908 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-HydQg-multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b] to final location RemoteFile[name=multichunk-8456d84201a3a043013c5e1ef9e5d7b87b52009b] ...
29-5-19 15:05:22.909 | RemoteTransacti | Test worker    | INFO : - Moving temp. file RemoteFile[name=temp-wxijP-database-B-0000000001] to final location RemoteFile[name=database-B-0000000001] ...
29-5-19 15:05:22.909 | RemoteTransacti | Test worker    | INFO : - Deleting remote transaction file RemoteFile[name=transaction-34dd1f1] ...
29-5-19 15:05:22.909 | RemoteTransacti | Test worker    | INFO : END of TX.commmit(): Succesfully committed transaction.
29-5-19 15:05:22.909 | RemoteTransacti | Test worker    | INFO : END of TX.delTemp(): Sucessfully deleted final files.
29-5-19 15:05:22.909 | UpOperation     | Test worker    | INFO : Persisting local SQL database (new database version B/(B1)/T=1559142322896) ...
29-5-19 15:05:22.919 | UpOperation     | Test worker    | INFO : Removing DIRTY database versions from database ...
29-5-19 15:05:22.930 | UpOperation     | Test worker    | INFO : Adding database version to result changes:DatabaseVersion [header=B/(B1)/T=1559142322896, chunks=2, multiChunks=1, fileContents=1, fileHistories=1]
29-5-19 15:05:22.930 | UpOperation     | Test worker    | INFO : Committing local database.
29-5-19 15:05:22.930 | UpOperation     | Test worker    | FINE : Waiting for new database version.
29-5-19 15:05:22.930 | UpOperation     | Test worker    | FINE : Took new database version: DatabaseVersion [header=UnknownMachine/()/T=1559142322905, chunks=0, multiChunks=0, fileContents=0, fileHistories=0]
29-5-19 15:05:22.931 | UpOperation     | Test worker    | INFO : Sync up done.
29-5-19 15:05:22.933 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-up-B-1559142322618] ...
29-5-19 15:05:22.940 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-up-B-1559142322618]
29-5-19 15:05:22.941 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:05:22.941 | Cache           | Test worker    | INFO : Cache size okay (1025 KB), no need to clean (keep size is 500 MB)
29-5-19 15:05:22.941 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event UpEndSyncExternalEvent (org.syncany.operations.daemon.messages.UpEndSyncExternalEvent@3395e279) ...
29-5-19 15:05:22.941 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:05:22.941 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150308467-30934-client-B' ...
29-5-19 15:05:22.941 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:05:22.941 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:05:22.941 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:05:22.941 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:05:22.941 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:05:22.941 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:05:22.941 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:05:22.941 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:05:22.941 | org.syncany.plu | Test worker    | FINE : Validating required fields
29-5-19 15:05:22.942 | TransferManager | Test worker    | INFO : Building LocalTransferManager from config 'syncany-190529150308467-30934-client-B' ...
29-5-19 15:05:22.942 | TransferManager | Test worker    | INFO : - With feature ReadAfterWriteConsistent
29-5-19 15:05:22.942 | TransferManager | Test worker    | INFO : - With feature Retriable
29-5-19 15:05:22.942 | TransferManager | Test worker    | INFO : - With feature PathAware
29-5-19 15:05:22.942 | TransferManager | Test worker    | INFO : - With feature TransactionAware
29-5-19 15:05:22.942 | TransferManager | Test worker    | FINE : - Checking if selected features supported ...
29-5-19 15:05:22.942 | TransferManager | Test worker    | FINE : - Checking for duplicate features ...
29-5-19 15:05:22.942 | TransferManager | Test worker    | FINE : - Checking required feature TransactionAware in LocalTransferManager ...
29-5-19 15:05:22.942 | TransferManager | Test worker    | FINE : - Checking required feature Retriable in LocalTransferManager ...
29-5-19 15:05:22.942 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature ReadAfterWriteConsistent
29-5-19 15:05:22.942 | TransferManager | Test worker    | FINE : - Wrapping TransferManager LocalTransferManager in RetriableFeatureTransferManager
29-5-19 15:05:22.942 | TransferManager | Test worker    | INFO : - SKIPPING unsupported optional feature PathAware
29-5-19 15:05:22.942 | TransferManager | Test worker    | FINE : - Wrapping TransferManager RetriableFeatureTransferManager in TransactionAwareFeatureTransferManager
29-5-19 15:05:22.950 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:22.950 | DownOperation   | Test worker    | INFO : 
29-5-19 15:05:22.950 | DownOperation   | Test worker    | INFO : Running 'Sync down' at client B ...
29-5-19 15:05:22.950 | DownOperation   | Test worker    | INFO : --------------------------------------------
29-5-19 15:05:22.951 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownStartSyncExternalEvent (org.syncany.operations.daemon.messages.DownStartSyncExternalEvent@7802c58a) ...
29-5-19 15:05:22.951 | AbstractTransfe | Test worker    | INFO : Looking for other running remote operations ...
29-5-19 15:05:22.952 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:22.952 | LsRemoteOperati | Test worker    | INFO : 
29-5-19 15:05:22.952 | LsRemoteOperati | Test worker    | INFO : Running 'Remote Status' at client B ...
29-5-19 15:05:22.952 | LsRemoteOperati | Test worker    | INFO : --------------------------------------------
29-5-19 15:05:22.952 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteStartSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteStartSyncExternalEvent@6b18501a) ...
29-5-19 15:05:22.953 | LsRemoteOperati | Test worker    | INFO : Retrieving remote database list.
29-5-19 15:05:22.953 | LsRemoteOperati | Test worker    | INFO : - Remote database database-A-0000000001 is new.
29-5-19 15:05:22.953 | LsRemoteOperati | Test worker    | INFO : - Remote database database-B-0000000001 is already known (in local database). Ignoring.
29-5-19 15:05:22.953 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event LsRemoteEndSyncExternalEvent (org.syncany.operations.daemon.messages.LsRemoteEndSyncExternalEvent@e5c2811) ...
29-5-19 15:05:22.953 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownChangesDetectedSyncExternalEvent (org.syncany.operations.daemon.messages.DownChangesDetectedSyncExternalEvent@6e2b1459) ...
29-5-19 15:05:22.953 | ActionFileHandl | Test worker    | INFO : Starting action for RemoteFile[name=action-down-B-1559142322942] ...
29-5-19 15:05:22.953 | ActionFileHandl | Test worker    | INFO : Uploading action file: RemoteFile[name=action-down-B-1559142322942]
29-5-19 15:05:22.953 | ActionFileHandl | Test worker    | INFO : Scheduling action renewal task for every 2 minutes, for RemoteFile[name=action-down-B-1559142322942] ...
29-5-19 15:05:22.954 | DownOperation   | Test worker    | INFO : Downloading unknown databases.
29-5-19 15:05:22.954 | DownOperation   | Test worker    | INFO : - Downloading database-A-0000000001 to local cache at /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-A-0000000001
29-5-19 15:05:22.954 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownDownloadFileSyncExternalEvent (org.syncany.operations.daemon.messages.DownDownloadFileSyncExternalEvent@2c092ed1) ...
29-5-19 15:05:22.955 | DownOperation   | Test worker    | INFO : Loading database headers, creating branches ...
29-5-19 15:05:22.955 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (HEADER_ONLY) from file /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:05:22.957 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142322368
29-5-19 15:05:22.958 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-190529150308467-30934-repo/databases/database-A-0000000001; maybe invalid file name pattern. Ignoring file.
29-5-19 15:05:22.958 | LocalTransferMa | Test worker    | INFO : Cannot create instance of CleanupRemoteFile for file /tmp/syncanytest/syncany-190529150308467-30934-repo/databases/database-B-0000000001; maybe invalid file name pattern. Ignoring file.
29-5-19 15:05:22.958 | ApplicationSqlD | Test worker    | INFO : SQL (general_settings): Read cleanupNumber  = (not set)
29-5-19 15:05:22.959 | DownOperation   | Test worker    | INFO : Populated unknown branches: {A=[A/(A1)/T=1559142322368], B=[B/(B1)/T=1559142322896]}
29-5-19 15:05:22.959 | DownOperation   | Test worker    | INFO : Determine winner using database reconciliator ...
29-5-19 15:05:22.959 | DatabaseReconci | Test worker    | INFO : Adding database version to winning branch: A/(A1)/T=1559142322368
29-5-19 15:05:22.959 | DatabaseReconci | Test worker    | INFO : Ignoring databaseVersion: B/(B1)/T=1559142322896
29-5-19 15:05:22.961 | DatabaseReconci | Test worker    | INFO : - Winner is A with branch: 
29-5-19 15:05:22.961 | DatabaseReconci | Test worker    | INFO :   + A/(A1)/T=1559142322368
29-5-19 15:05:22.961 | DownOperation   | Test worker    | INFO : - Database versions to REMOVE locally: [B/(B1)/T=1559142322896]
29-5-19 15:05:22.961 | DownOperation   | Test worker    | INFO :   + Marking databases as DIRTY locally ...
29-5-19 15:05:22.962 | DownOperation   | Test worker    | INFO :     * MASTER->DIRTY: B/(B1)/T=1559142322896
29-5-19 15:05:22.966 | DownOperation   | Test worker    | INFO :     * Deleting own remote database file RemoteFile[name=database-B-0000000001] ...
29-5-19 15:05:22.967 | DatabaseReconci | Test worker    | INFO : Finding winnersApplyBranch.
29-5-19 15:05:22.967 | DatabaseReconci | Test worker    | INFO : Losers Branch: [B/(B1)/T=1559142322896]
29-5-19 15:05:22.967 | DatabaseReconci | Test worker    | INFO : Winners Branch: [A/(A1)/T=1559142322368]
29-5-19 15:05:22.967 | DownOperation   | Test worker    | INFO : - Cleanup occurred: false
29-5-19 15:05:22.967 | DownOperation   | Test worker    | INFO : - Database versions to APPLY locally: [A/(A1)/T=1559142322368]
29-5-19 15:05:22.967 | DownOperation   | Test worker    | INFO : Loading winners database (DEFAULT) ...
29-5-19 15:05:22.967 | DatabaseXmlSeri | Test worker    | INFO : - Loading database (FULL) from file /tmp/syncanytest/syncany-190529150308467-30934-client-B/.syncany/cache/database-A-0000000001 ...
29-5-19 15:05:22.969 | DatabaseXmlPars | Test worker    | INFO :    + Added database version A/(A1)/T=1559142322368
29-5-19 15:05:22.971 | DownOperation   | Test worker    | INFO : Determine file system actions ...
29-5-19 15:05:22.972 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:22.977 | FileSystemActio | Test worker    | INFO : - Loading current file tree...
29-5-19 15:05:22.979 | FileSystemActio | Test worker    | INFO : - Determine filesystem actions ...
29-5-19 15:05:22.979 | FileSystemActio | Test worker    | INFO :   + Comparing local version: null
29-5-19 15:05:22.979 | FileSystemActio | Test worker    | INFO :     with winning version   : FileVersion [version=1, path=A-file1.jpg, type=FILE, status=NEW, size=1048576, lastModified=Wed May 29 15:05:22 UTC 2019, linkTarget=null, checksum=92ed30c76738a6e139e13cd400cbe1a11b2ce69f, updated=Wed May 29 15:05:22 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-]
29-5-19 15:05:23.000 | FileSystemActio | Test worker    | INFO :      -> (1) Equals: Nothing to do, winning version equals winning file: FileVersion [version=1, path=A-file1.jpg, type=FILE, status=NEW, size=1048576, lastModified=Wed May 29 15:05:22 UTC 2019, linkTarget=null, checksum=92ed30c76738a6e139e13cd400cbe1a11b2ce69f, updated=Wed May 29 15:05:22 UTC 2019, posixPermissions=rw-rw-r--, dosAttributes=--a-] AND /tmp/syncanytest/syncany-190529150308467-30934-client-B/A-file1.jpg
29-5-19 15:05:23.001 | Downloader      | Test worker    | INFO : Downloading and extracting multichunks ...
29-5-19 15:05:23.002 | FileSystemActio | Test worker    | INFO :    Sorted actions:
29-5-19 15:05:23.002 | DownOperation   | Test worker    | FINE : - Applying file system actions (sorted!) ...
29-5-19 15:05:23.002 | DownOperation   | Test worker    | INFO : - Adding database versions to SQL database ...
29-5-19 15:05:23.002 | DownOperation   | Test worker    | INFO :   + Applying database version (A1)
29-5-19 15:05:23.002 | DownOperation   | Test worker    | FINE :   + Contents: DatabaseVersion [header=A/(A1)/T=1559142322368, chunks=2, multiChunks=1, fileContents=1, fileHistories=1]
29-5-19 15:05:23.020 | ActionFileHandl | Test worker    | INFO : Finishing action for RemoteFile[name=action-down-B-1559142322942] ...
29-5-19 15:05:23.025 | ActionFileHandl | Test worker    | INFO : Deleting action file: RemoteFile[name=action-down-B-1559142322942]
29-5-19 15:05:23.025 | AbstractTransfe | Test worker    | INFO : Cleaning own old action files ...
29-5-19 15:05:23.026 | Cache           | Test worker    | INFO : Cache size okay (1027 KB), no need to clean (keep size is 500 MB)
29-5-19 15:05:23.026 | InternalEventBu | Test worker    | INFO : Event bus 'LocalEventBus': Posting event DownEndSyncExternalEvent (org.syncany.operations.daemon.messages.DownEndSyncExternalEvent@502e1243) ...
29-5-19 15:05:23.026 | DownOperation   | Test worker    | INFO : Sync down done.
29-5-19 15:05:23.027 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:23.028 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:23.029 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:23.029 | DatabaseConnect | Test worker    | INFO : Found 12 tables.
29-5-19 15:05:23.090 | TestAssertUtil  | Test worker    | FINE :  Comparing database table: select CHECKSUM, DATABASEVERSION_ID, SIZE from chunk order by CHECKSUM asc