SYS_DB_QUERY_FAILED @ CentOS + NetXMS 4.5.6 + Timescaledb

[vmdb0dpk0]

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

[Filipp Sudanov]

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.