I was worried that would be the case. I'll look into some scripts to do this.
Cheers.
Cheers.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts MenuQuote from: gdodd on October 05, 2021, 04:10:21 AM
- Fixed bug in centralized agent upgrade on Windows
Does that mean once server and agent are on 3.9.298, future centralized agent upgrades should work? Or should it work with just server on 3.9.298?
I am trying to upgrade Windows agents 3.9.280 from Linux server 3.9.298 and get the "Agent's version doesn't match..." error message.
# nxdbmgr check
NetXMS Database Manager Version 3.8.314 Build 3.8-314-g9d14b98df7 (UNICODE)
Checking database (excluding collected data):
* Zone object properties [PASSED]
* Node object properties [PASSED]
* Node to subnet bindings [PASSED]
* Interface object properties [PASSED]
* Interface bindings [PASSED]
* Network service object properties [PASSED]
* Network service bindings [PASSED]
* Cluster object properties [PASSED]
* Cluster member nodes [PASSED]
* Template to node mapping [PASSED]
* Object properties [PASSED]
* Container membership [PASSED]
* Event processing policy [PASSED]
* Network map links [PASSED]
* Data tables [PASSED]
* Orphaned data tables [ 12% ]
Data collection table tdata_1124 belongs to deleted object and no longer in use. Delete it? (Y/N) (Yes/No/All/Skip) a
SQL query failed (2BP01 ERROR: cannot drop table tdata_1124 because other objects depend on it
DETAIL: constraint tdata_records_1124_record_id_fkey on table tdata_records_1124 depends on table tdata_1124
HINT: Use DROP ... CASCADE to drop the dependent objects too.):
DROP TABLE tdata_1124
* Orphaned data tables [ 12% ]
Data collection table tdata_1126 belongs to deleted object and no longer in use. Delete it? (Y/N) (Yes/No/All/Skip) Y
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
DROP TABLE tdata_1126
* Orphaned data tables [ 12% ]
Data collection table tdata_1128 belongs to deleted object and no longer in use. Delete it? (Y/N) (Yes/No/All/Skip) Y
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
DROP TABLE tdata_1128
* Orphaned data tables [ 12% ]
Data collection table tdata_1130 belongs to deleted object and no longer in use. Delete it? (Y/N) (Yes/No/All/Skip) Y
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
DROP TABLE tdata_1130
* Orphaned data tables [ 13% ]
Data collection table tdata_1132 belongs to deleted object and no longer in use. Delete it? (Y/N) (Yes/No/All/Skip) Y
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
DROP TABLE tdata_1132
* Orphaned data tables [ 13% ]
Data collection table tdata_1189 belongs to deleted object and no longer in use. Delete it? (Y/N) (Yes/No/All/Skip) Y
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
DROP TABLE tdata_1189
* Orphaned data tables [ 13% ]
<<SNIPPED>>
<<SNIPPED>>
* Orphaned data tables [ERROR ]
* DCI configuration [ 0SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT item_id,node_id FROM items WHERE node_id NOT IN (SELECT object_id FROM object_properties)
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT item_id,node_id FROM dc_tables WHERE node_id NOT IN (SELECT object_id FROM object_properties)
[PASSED]
* Raw DCI values table [ 0SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT item_id FROM raw_dci_values
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT count(*) FROM raw_dci_values WHERE last_poll_time>1620602557
[PASSED]
* DCI thresholds [ 0SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT threshold_id,item_id FROM thresholds
[PASSED]
* Table DCI thresholds [ 0SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT id,table_id FROM dct_thresholds
[PASSED]
100 errors was found, 0 errors was corrected
Database still contain errors
Database check completed