Exception : No closing quotation

[Johan_ANSELMET]

Hello,

I see some posts like this, but no one with a repair answer, so I try this post, thanks
We discover that theses errors are link to the fact that some of theses checks upload “quotation”, and others not, here a “green example”, and then, a red one

Check OK
[DC1-PROD][postgres@* ~]$ /home/postgres/fdj/scripts/check_pgactivity.sh -P /usr/pgsql-14/bin/psql -h/tmp -Ucheckmk -p* -d postgres -s backends -w 85% -c 95%
POSTGRES_BACKENDS OK: 17 connections on 797 | dls_db=14;677;757;0;797 postgres=3;677;757;0;797 maximum_connections=797;;;0;797

Check KO, with this error

[DC1-PROD][postgres@* ~]$ /home/postgres/fdj/scripts/check_pgactivity.sh -P /usr/pgsql-14/bin/psql -h/tmp -Ucheckmk -p* -d postgres -s longest_query -w 4h -c 10h
POSTGRES_LONGEST_QUERY OK: 2 running querie(s) | ‘postgres max’=0.000000s;14400;36000 ‘postgres avg’=0s;14400;36000 ‘postgres #queries’=1 ‘dls_db max’=0.000000s;14400;36000 ‘dls_db avg’=0s;14400;36000 ‘dls_db #queries’=1 ‘template1 max’=NaNs;14400;36000 ‘template1 avg’=NaNs;14400;36000 ‘template1 #queries’=0

CMK version:

1.6.0p27

OS version:

Linux * 3.10.0-1160.49.1.el7.x86_64 #1 SMP Tue Nov 9 16:09:48 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

Error message:

Internal error: No closing quotation

[robin.gierse]

With a Checkmk version as ancient as 1.6.0 it is unlikely, that you will receive much feedback.

The message is pretty clear, but I am not sure, we understand, what exactly you mean with your description. And I am not sure, if that is even the real cause of the issue.

[Johan_ANSELMET]

@robin.gierse

And I am not sure, if that is even the real cause of the issue.

Thanks for trying, and yes, i’m not sure that the rootcause is "CheckMK can’t use character " ’ " to integrate data here