Microsoft Windows [Version 10.0.19045.3448]
(c) Microsoft Corporation. Wszelkie prawa zastrzeżone.
C:\Users\dynatech>cd "c:\VDM Sync"
c:\VDM Sync>vdmsync.exe
---- VDM SYNC AGENT ----
Version: 1.0.5
c:\VDM Sync\data
badger 2023/10/04 15:51:00 INFO: All 0 tables opened in 0s
badger 2023/10/04 15:51:00 INFO: Discard stats nextEmptySlot: 0
badger 2023/10/04 15:51:00 INFO: Set nextTxnTs to 1
Listening on port 19341
┌───────────────────────────────────────────────────┐
│ Fiber v2.45.0 │
│ http://127.0.0.1:19341 │
│ (bound on host 0.0.0.0 and port 19341) │
│ │
│ Handlers ............ 13 Processes ........... 1 │
│ Prefork ....... Disabled PID .............. 3960 │
└───────────────────────────────────────────────────┘
Running scheduler
Running SQS broker
Watcher starting
Scheduler starting
Watcher cycle
Interval [] Key not found
Scheduler cycle
Broker stop
DSN = sqlserver://sa:sps@127.0.0.1/EXP_2008?database=dynatech&encrypt=disable&tlsmin=1.0
Syncing table: Drawers
Table Drawers count: 143
Query: SELECT * FROM Drawers
Table Drawers count 143
Table state. Checksum 2cb8ddce57b79d41de1a6e88c661aebe. Offset 143
No changes for table: Drawers
Syncing table: DrawerChannels
Table DrawerChannels count: 0
Query: SELECT * FROM DrawerChannels
Table DrawerChannels count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: DrawerChannels
Syncing table: DrawerCompartmentItems
Table DrawerCompartmentItems count: 1859
Query: SELECT * FROM DrawerCompartmentItems
Table DrawerCompartmentItems count 1859
Table state. Checksum dffdffd164e2afdf6d5f7b7e803e1ceb. Offset 1859
No changes for table: DrawerCompartmentItems
Syncing table: DrawerCompartments
Table DrawerCompartments count: 1859
Query: SELECT * FROM DrawerCompartments
Table DrawerCompartments count 1859
Table state. Checksum f62ece757254f5f643ed1e24c18c565b. Offset 1859
No changes for table: DrawerCompartments
Syncing table: DrawerLids
Table DrawerLids count: 0
Query: SELECT * FROM DrawerLids
Table DrawerLids count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: DrawerLids
Syncing table: HardwareEvents
Table HardwareEvents count: 0
Query: SELECT * FROM HardwareEvents
Table HardwareEvents count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: HardwareEvents
Syncing table: ItemGroups
Table ItemGroups count: 6
Query: SELECT * FROM ItemGroups
Table ItemGroups count 6
Table state. Checksum 47749a63367f9cfa55dcfd496f783557. Offset 6
No changes for table: ItemGroups
Syncing table: ItemGroups_History
Table ItemGroups_History count: 3
Query: SELECT * FROM ItemGroups_History
Table ItemGroups_History count 3
Table state. Checksum 55c344483410d141e57b203a63b3e2ac. Offset 3
No changes for table: ItemGroups_History
Syncing table: ItemSerialNumberStatus
Table ItemSerialNumberStatus count: 0
Query: SELECT * FROM ItemSerialNumberStatus
Table ItemSerialNumberStatus count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: ItemSerialNumberStatus
Syncing table: ItemSubGroups_History
Table ItemSubGroups_History count: 0
Query: SELECT * FROM ItemSubGroups_History
Table ItemSubGroups_History count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: ItemSubGroups_History
Syncing table: ItemSubGroups
Table ItemSubGroups count: 0
Query: SELECT * FROM ItemSubGroups
Table ItemSubGroups count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: ItemSubGroups
Syncing table: Items
Table Items count: 36
Query: SELECT * FROM Items
Table Items count 36
Table state. Checksum b8257355e2520e594cb1a56c9828ea6f. Offset 36
No changes for table: Items
Syncing table: Items_History
Table Items_History count: 126
Query: SELECT * FROM Items_History
Table Items_History count 126
Table state. Checksum d38449c515dd1019cc59542ddec641ef. Offset 126
No changes for table: Items_History
Syncing table: MachineGroups
Table MachineGroups count: 0
Query: SELECT * FROM MachineGroups
Table MachineGroups count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: MachineGroups
Syncing table: MachineGroups_History
Table MachineGroups_History count: 0
Query: SELECT * FROM MachineGroups_History
Table MachineGroups_History count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: MachineGroups_History
Syncing table: Machines_VendingMachineAssignment
Table Machines_VendingMachineAssignment count: 0
Query: SELECT * FROM Machines_VendingMachineAssignment
Table Machines_VendingMachineAssignment count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: Machines_VendingMachineAssignment
Syncing table: Machines
Table Machines count: 0
Query: SELECT * FROM Machines
Table Machines count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: Machines
Syncing table: Machines_History
Table Machines_History count: 0
Query: SELECT * FROM Machines_History
Table Machines_History count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: Machines_History
Syncing table: Rationing
Table Rationing count: 41
Query: SELECT * FROM Rationing
Table Rationing count 41
Table state. Checksum b8f1c9c96c67ad2af39759cd3b51af82. Offset 41
No changes for table: Rationing
Syncing table: Restrictions2
Table Restrictions2 count: 121
Query: SELECT * FROM Restrictions2
Table Restrictions2 count 121
Table state. Checksum 000dabd1075b4b63a57008924fa35dc7. Offset 121
No changes for table: Restrictions2
Syncing table: Suppliers
Table Suppliers count: 0
Query: SELECT * FROM Suppliers
Table Suppliers count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: Suppliers
Syncing table: TransactionLog
Table TransactionLog count: 436088
Query: SELECT * FROM TransactionLog ORDER BY TLID OFFSET 0 ROWS
mssql: Incorrect syntax near 'OFFSET'.
Syncing table: UserCostCenterMembership
Table UserCostCenterMembership count: 0
Query: SELECT * FROM UserCostCenterMembership
Table UserCostCenterMembership count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: UserCostCenterMembership
Syncing table: UserCostCenters
Table UserCostCenters count: 0
Query: SELECT * FROM UserCostCenters
Table UserCostCenters count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: UserCostCenters
Syncing table: UserCostCenters_History
Table UserCostCenters_History count: 0
Query: SELECT * FROM UserCostCenters_History
Table UserCostCenters_History count 0
Table state. Checksum d751713988987e9331980363e24189ce. Offset 0
No changes for table: UserCostCenters_History
Syncing table: UserGroupMembership
Table UserGroupMembership count: 2069
Query: SELECT * FROM UserGroupMembership
Table UserGroupMembership count 2069
Table state. Checksum 73850c7847b60ad44ddd2befb3700b64. Offset 2069
No changes for table: UserGroupMembership
Syncing table: UserGroupTransactions
Table UserGroupTransactions count: 12
Query: SELECT * FROM UserGroupTransactions
Table UserGroupTransactions count 12
Table state. Checksum 538f3c53abd67f0ea7ff659b33149622. Offset 12
No changes for table: UserGroupTransactions
Syncing table: UserGroups
Table UserGroups count: 12
Query: SELECT * FROM UserGroups
Table UserGroups count 12
Table state. Checksum 3bbc978b8fc8e5667acc928ef9db0daa. Offset 12
No changes for table: UserGroups
Syncing table: UserGroups_History
Table UserGroups_History count: 12
Query: SELECT * FROM UserGroups_History
Table UserGroups_History count 12
Table state. Checksum ba0c5d5864b81ac4d0c6b57b0a573930. Offset 12
No changes for table: UserGroups_History
Syncing table: UserGroups_VendingMachineAssignment
Table UserGroups_VendingMachineAssignment count: 36
Query: SELECT * FROM UserGroups_VendingMachineAssignment
Table UserGroups_VendingMachineAssignment count 36
Table state. Checksum b2449432d061eec4b609c3864e44bb93. Offset 36
No changes for table: UserGroups_VendingMachineAssignment
Syncing table: UserTransactions
Table UserTransactions count: 1318
Query: SELECT * FROM UserTransactions
Table UserTransactions count 1318
Table state. Checksum . Offset 0
Syncing table: Users
Table Users count: 2057
Query: SELECT * FROM Users
Table Users count 2057
Table state. Checksum . Offset 0
Syncing table: Users_History
Table Users_History count: 8027
Query: SELECT * FROM Users_History
Table Users_History count 8027
Table state. Checksum . Offset 0
Syncing table: Users_VendingMachineAssignment
Table Users_VendingMachineAssignment count: 6168
Query: SELECT * FROM Users_VendingMachineAssignment
Table Users_VendingMachineAssignment count 6168
Table state. Checksum . Offset 0
Syncing table: VendingMachineItems
Table VendingMachineItems count: 86
Query: SELECT * FROM VendingMachineItems
Table VendingMachineItems count 86
Table state. Checksum . Offset 0
Syncing table: VendingMachineItems_History
Table VendingMachineItems_History count: 0
Query: SELECT * FROM VendingMachineItems_History
Table VendingMachineItems_History count 0
Table state. Checksum . Offset 0
Syncing table: VendingMachineSuppliers
Table VendingMachineSuppliers count: 0
Query: SELECT * FROM VendingMachineSuppliers
Table VendingMachineSuppliers count 0
Table state. Checksum . Offset 0
Syncing table: VendingMachineSuppliers_History
Table VendingMachineSuppliers_History count: 0
Query: SELECT * FROM VendingMachineSuppliers_History
Table VendingMachineSuppliers_History count 0
Table state. Checksum . Offset 0
Syncing table: VendingMachines
Table VendingMachines count: 3
Query: SELECT * FROM VendingMachines
Table VendingMachines count 3
Table state. Checksum . Offset 0
Syncing table: VendingMachines_History
Table VendingMachines_History count: 5
Query: SELECT * FROM VendingMachines_History
Table VendingMachines_History count 5
Table state. Checksum . Offset 0
Rows count: 17664
c:\VDM Sync>
Paste Hosted With By Wklejamy.pl