News:

We really need your input in this questionnaire

Main Menu

Recent posts

#1
Version 4.5.7 of UI client application and web UI is available in download archive. It should fix object tree update problem reported by multiple users. If you are using version 4.5, try to update your client to version 4.5.7 and report if object tree update issue is still there or is finally solved.

Best regards,
Victor
#2
General Support / Re: SYS_DB_QUERY_FAILED @ Cent...
Last post by Filipp Sudanov - Today at 12:09:16 PM
you can turn on sql trace for some time, from linux command line

nxadm -c "debug sql on"
and
nxadm -c "debug sql off"
afterwards.

This will turn on detailed sql query logging, log will be huge, but there will be more detailed information.

object_properties table is updated when objects are updated (renamed, custom attributes changed, etc). Changes are saved into db once per minute.

#3
General Support / Re: new desktop client - unbou...
Last post by normalcy - Today at 05:16:46 AM
Quote from: Victor Kirhenshtein on May 11, 2024, 10:59:09 AMI just updated client application so that nodes without parent objects in infrastructure tree are not shown as root level objects. This change will be part of release 5.0.3.
Best regards,
Victor
Thanks Victor, look forward to it.

Quote from: Filipp Sudanov on May 10, 2024, 08:47:24 PMNot sure why this is happening. Can you run the script I've shared manually (via Execute Script from context menu) on a couple of nodes which we bound to that container, but should not and share the output.

Hi Filip, attached is a screenshot of executing the script on a node that had an existing parent.  It always seems to return true whether on a node that has no other parent or an existing node.
#4
General Support / Re: Database upgrade after Net...
Last post by maredcz - Today at 12:37:56 AM
.. have backups, have restored the database. Look's nobody else is observing the same issue. Try activate MariaDB logging if you are ending on updating network maps

.. "Prepare UPDATE network_maps SET link_styling_script=?,filter=? WHERE id=?"
#5
General Support / SYS_DB_QUERY_FAILED @ CentOS +...
Last post by vmdb0dpk0 - May 14, 2024, 09:13:20 PM
Hello team!

We've facing new error after upgrade to 4.5.6
It says:
netxmsd[739160]: [db.drv            ] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,map_image,drilldown_object_id,country,region,city,district,street_address,postcode,maint_event_id,state_before_maint,state,flags,creation_time,maint_initiator,alias,name_on_map,category,comments_source,asset_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT (object_id) DO UPDATE SET name=excluded.name,status=excluded.status,is_deleted=excluded.is_deleted,inherit_access_rights=excluded.inherit_access_rights,last_modified=excluded.last_modified,status_calc_alg=excluded.status_calc_alg,status_prop_alg=excluded.status_prop_alg,status_fixed_val=excluded.status_fixed_val,status_shift=excluded.status_shift,status_translation=excluded.status_translation,status_single_threshold=excluded.status_single_threshold,status_thresholds=excluded.status_thresholds,comments=excluded.comments,is_system=excluded.is_system,location_type=excluded.location_type,latitude=excluded.latitude,longitude=excluded.longitude,location_accuracy=excluded.location_accuracy,location_timestamp=excluded.location_timestamp,guid=excluded.guid,map_image=excluded.map_image,drilldown_object_id=excluded.drilldown_object_id,country=excluded.country,region=excluded.region,city=excluded.city,district=excluded.district,street_address=excluded.street_address,postcode=excluded.postcode,maint_event_id=excluded.maint_event_id,state_before_maint=excluded.state_before_maint,state=excluded.state,flags=excluded.flags,creation_time=excluded.creation_time,maint_initiator=excluded.maint_initiator,alias=excluded.alias,name_on_map=excluded.name_on_map,category=excluded.category,comments_source=excluded.comments_source,asset_id=excluded.asset_id"): 22P02 ERROR:  invalid input syntax for type integer: "-("
How could we determine which 'flag' caused this error?

Thanks in advance!

--
Best regards, Igor
#6
General Support / Re: Server not starting after ...
Last post by deepb - May 13, 2024, 02:29:53 PM
No error in MariaDB...

2024-05-13 16:46:02 0 [Note] C:\Program Files\MariaDB 10.4\bin\mysqld.exe (initiated by: unknown): Normal shutdown
2024-05-13 16:46:02 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-05-13 16:46:02 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-13 16:46:02 0 [Note] InnoDB: Starting shutdown...
2024-05-13 16:46:02 0 [Note] InnoDB: Dumping buffer pool(s) to C:\Program Files\MariaDB 10.4\data\ib_buffer_pool
2024-05-13 16:46:02 0 [Note] InnoDB: Instance 0, restricted to 16054 pages due to innodb_buf_pool_dump_pct=25
2024-05-13 16:46:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 240513 16:46:02
2024-05-13 16:46:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-13 16:46:04 0 [Note] InnoDB: Shutdown completed; log sequence number 12673536826768; transaction id 626221754
2024-05-13 16:46:04 0 [Note] C:\Program Files\MariaDB 10.4\bin\mysqld.exe: Shutdown complete

2024-05-13 16:46:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-05-13 16:46:04 0 [Note] InnoDB: Uses event mutexes
2024-05-13 16:46:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-13 16:46:04 0 [Note] InnoDB: Number of pools: 1
2024-05-13 16:46:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-13 16:46:04 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2024-05-13 16:46:04 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-13 16:46:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-13 16:46:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-13 16:46:07 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-13 16:46:07 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2024-05-13 16:46:07 0 [Note] InnoDB: Waiting for purge to start
2024-05-13 16:46:07 0 [Note] InnoDB: 10.4.25 started; log sequence number 12673536826768; transaction id 626221755
2024-05-13 16:46:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MariaDB 10.4\data\ib_buffer_pool
2024-05-13 16:46:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-13 16:46:07 0 [Note] Server socket created on IP: '::'.
2024-05-13 16:46:07 0 [Note] Reading of all Master_info entries succeeded
2024-05-13 16:46:07 0 [Note] Added new Master_info '' to hash table
2024-05-13 16:46:07 0 [Note] C:\Program Files\MariaDB 10.4\bin\mysqld.exe: ready for connections.
Version: '10.4.25-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2024-05-13 16:46:22 8 [Warning] Aborted connection 8 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets)
2024-05-13 16:47:00 0 [Note] InnoDB: Buffer pool(s) load completed at 240513 16:47:00
2024-05-13 16:48:20 9 [Warning] Aborted connection 9 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets)
2024-05-13 16:49:23 10 [Warning] Aborted connection 10 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets)

I didn't keep a database backup. I don't know what to do now!!

This upgrade has proved to be too costly for me.
#7
General Support / Re: Server not starting after ...
Last post by Alex Kirhenshtein - May 13, 2024, 01:47:48 PM
Check MariaDB logs, it looks like a database problem (maybe just out of space?)
#8
General Support / Re: Server not starting after ...
Last post by deepb - May 13, 2024, 01:46:18 PM
Windows event logs have the below MariaDB error:

Aborted connection 40 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets) 

Do I have to upgrade MariaDB?

Please help in resolving this issue.
#9
General Support / Re: Server not starting after ...
Last post by Alex Kirhenshtein - May 13, 2024, 01:32:19 PM
Check windows event log, maybe nxdbmgr crashed
#10
General Support / Re: Database upgrade after Net...
Last post by deepb - May 13, 2024, 01:31:08 PM
I'm facing exactly the same issue. I didn't take database backup so cannot go back to the old schema version either.