Author Topic: SQL query failed , удаляется Node  (Read 569 times)

hayarm

  • Newbie
  • *
  • Posts: 42
    • View Profile
SQL query failed , удаляется Node
« on: November 20, 2019, 03:30:41 pm »
удаляется Node (mikrotik) без каких либо причин, причем один и тот же mikrotik, изменил ip address, название и т.д не помогает



server.log

Code: [Select]
2019.11.20 12:38:33.050 *E* [db.drv             ] SQL query failed (Query = "CREATE TABLE idata_68872 (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) null,raw_value varchar(255) null)"): Table 'idata_68872' already exists
2019.11.20 12:38:33.050 *E* [db.drv             ] SQL query failed (Query = "CREATE INDEX idx_idata_68872_id_timestamp ON idata_68872(item_id,idata_timestamp DESC)"): Duplicate key name 'idx_idata_68872_id_timestamp'
2019.11.20 12:38:33.082 *E* [db.drv             ] SQL query failed (Query = "CREATE TABLE tdata_68872 (item_id integer not null,tdata_timestamp integer not null,tdata_value longtext null)"): Table 'tdata_68872' already exists
2019.11.20 12:38:33.082 *E* [db.drv             ] SQL query failed (Query = "CREATE INDEX idx_tdata_68872 ON tdata_6816872(item_id,tdata_timestamp)"): Duplicate key name 'idx_tdata_68872'
2019.11.20 14:16:44.380 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO idata_4072 (item_id,idata_timestamp,idata_value,raw_value) VALUES (3514,1574244999,'Loading...Null value','Loading...Null value')"): Server shutdown in progress
2019.11.20 14:16:44.380 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO idata_4051 (item_id,idata_timestamp,idata_value,raw_value) VALUES (3415,1574244999,'Loading...Null value','Loading...Null value')"): Server shutdown in progress
2019.11.20 14:16:44.380 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO idata_4100 (item_id,idata_timestamp,idata_value,raw_value) VALUES (2722,1574244999,'Loading...Null value','Loading...Null value')"): Server shutdown in progress
2019.11.20 14:16:45.785 *E* [db.drv             ] SQL query failed (Query = "UPDATE raw_dci_values SET raw_value=?,transformed_value=?,last_poll_time=? WHERE item_id=?"): Server shutdown in progress
2019.11.20 14:16:45.863 *E* [db.drv             ] SQL query failed (Query = "UPDATE alarms SET alarm_state=?,ack_by=?,term_by=?,last_change_time=?,current_severity=?,repeat_count=?,hd_state=?,hd_ref=?,timeout=?,timeout_event=?,message=?,resolved_by=?,ack_timeout=?,source_object_id=?,dci_id=?,alarm_category_ids=?,rule_guid=?,event_tags=? WHERE alarm_id=?"): Server shutdown in progress



Code: [Select]
2019.10.30 14:20:38.934 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.10.30 16:21:33.884 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.10.30 18:22:24.055 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.10.30 20:23:18.635 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.10.31 06:55:59.789 *E* [                   ] Thread "Syncer Thread" does not respond to watchdog thread
2019.10.31 06:56:08.375 *I* [                   ] Thread "Syncer Thread" returned to running state
2019.11.01 02:08:32.516 *E* [db.driver          ] SQL query failed (Query = "INSERT INTO idata_4928 (item_id,idata_timestamp,idata_value,raw_value) VALUES (4164,1572559656,'DOWN','2')"): Lock wait timeout exceeded; try restarting transaction
2019.11.01 08:54:25.254 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.11.01 10:55:19.955 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.11.01 12:56:14.770 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.11.01 14:48:51.476 *E* [                   ] Thread "Syncer Thread" does not respond to watchdog thread
2019.11.01 14:48:54.658 *I* [                   ] Thread "Syncer Thread" returned to running state
2019.11.01 14:57:08.191 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.11.02 02:05:35.226 *E* [                   ] Thread "Syncer Thread" does not respond to watchdog thread
2019.11.02 02:05:48.078 *I* [                   ] Thread "Syncer Thread" returned to running state
2019.11.03 03:28:20.873 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.11.03 05:29:07.757 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.11.03 07:30:03.197 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)
2019.11.03 09:31:00.412 *E* [                   ] Call to GetIpNetTable() failed (???????? ??????? ?????????.)






Code: [Select]
2019.11.25 10:55:10.176 *D* [sync               ] Syncer wakeup
2019.11.25 10:55:10.176 *D* [db.cpool           ] Handle 00000026C2D362B0 acquired (call from c:\source\netxms-3.0\src\server\core\syncer.cpp:191)
2019.11.25 10:55:10.176 *D* [sync               ] 7866 objects to process
2019.11.25 10:55:10.176 *D* [obj.sync           ] Object Mikrotik [70975] marked for deletion
2019.11.25 10:55:10.176 *D* [obj.sync           ] Unable to delete object with id 70975 because it is being referenced 474 time(s)
2019.11.25 10:55:10.176 *D* [obj.sync           ] Object Mikrotik [71311] marked for deletion
2019.11.25 10:55:10.176 *D* [obj.sync           ] Unable to delete object with id 71311 because it is being referenced 16 time(s)
2019.11.25 10:55:10.176 *D* [sync               ] Save objects completed
2019.11.25 10:55:10.176 *D* [sync               ] Saving user database
2019.11.25 10:55:10.176 *D* [sync               ] Saving NXSL persistent storage
2019.11.25 10:55:10.176 *D* [db.cpool           ] Handle 00000026C2D362B0 released
2019.11.25 10:55:10.176 *D* [sync               ] Syncer run completed
« Last Edit: November 25, 2019, 10:31:02 am by hayarm »