[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 |
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 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. |