SQL query failed , удаляется Node
-
удаляется Node (mikrotik) без каких либо причин, причем один и тот же mikrotik, изменил ip address, название и т.д не помогает
server.log
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 progress2019.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 (???????? ??????? ?????????.)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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login