[ZBX-6545] PostgreSQL SQL errors during node configuration sync Created: 2013 Apr 29  Updated: 2017 May 30  Resolved: 2013 Dec 29

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.0.6
Fix Version/s: 2.0.11rc1, 2.2.2rc1, 2.3.0

Type: Incident report Priority: Critical
Reporter: Federico Di Gregorio Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: distributed, postgresql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Zabbix from deb packages on Debian GNU/Linux unstable with PostgreSQL 9.1.9.



 Description   

After configuring 2 nodes as explained in the documentation the master (node 1) logs several SQL errors like:

24562:20130429:165953.158 NODE 1: Received configuration changes from slave node 2 for node 2 datalen 2773601
24562:20130429:165954.256 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at or near "1"
LINE 1427: ...00\\350\\235
345Tx p\\020\\354|\\353\\177\\247_\'1\\177
22...
^
and the configuration sync doesn't finish correctly (some data is visible while other, like templates, is not).



 Comments   
Comment by Federico Di Gregorio [ 2013 Apr 29 ]

The problem can be fixed by setting the following parameters in postgresql.conf:

backslash_quote = on
standard_conforming_strings = off

Note that as explained on PostgreSQL documentation (http://www.postgresql.org/docs/9.1/static/runtime-config-compatible.html) using those settings has security implications.

Comment by Alexander Vladishev [ 2013 Dec 29 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-6545

Comment by Andris Zeila [ 2014 Jan 02 ]

Successfully tested

Comment by Alexander Vladishev [ 2014 Jan 02 ]

Fixed in pre-2.0.11 r41218, pre-2.2.2 r41220 and pre-2.3.0 (trunk) r41221.

Generated at Thu Mar 28 19:07:47 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.