Print Page - Issue with Query

Title: Issue with Query
Post by: FHSRZ on February 19, 2018, 10:22:26 AM

Hello Community,

i have an issue with a SQL Query. This is how the netxmsd Log looks like. If i have this Error Message NetXMS Service will stop.

2018.02.17 05:48:12.995 *E* SQL query failed (Query = "INSERT INTO idata_1 (item_id,idata_timestamp,idata_value) VALUES (1,0,'\004\004')"): 42P01 FEHLER: Relation idata_1 existiert nicht LINE 1: INSERT INTO idata_1 (item_id,idata_timestamp,idata_value) VA...

Any help?

Best Regards

Title: Re: Issue with Query
Post by: Victor Kirhenshtein on February 20, 2018, 09:16:47 PM

Hi,

seems to be a bug in server. What version you are running and on what OS? Do you have crash dumps?

Best regards,
Victor

Title: Re: Issue with Query
Post by: FHSRZ on February 21, 2018, 09:45:48 AM

Hi,

i run a Debian 9.3.0 (Stretch) with NetXMS 2.2.2
No, i don't have Crash Dumps

Best Regards

Title: Re: Issue with Query
Post by: Victor Kirhenshtein on February 21, 2018, 01:12:17 PM

Hi,

on Debian core dump generation disabled by default. Please try to enable it and provide us with core file. There are also slight chance that this is known issue fixed in 2.2.3 or upcoming 2.2.4 (will be released within few days).

Best regards,
Victor

NetXMS Support Forum

English Support => General Support => Topic started by: FHSRZ on February 19, 2018, 10:22:26 AM