Ad Widget

**dimir** · 28-05-2012, 11:16

Did you also load data.sql for proxy database? For a proxy database only the schema should be loaded to clean database.

**gigatec** · 02-06-2012, 13:49

Sorry for delay - with loading just schema.sql everything seems to work as expected.

Problem solved :-)

**markl** · 15-06-2012, 14:24

Thanks for posting this. I've just encountered the exact same error and was wondering what the heck I'd done wrong.

Instructions for installation don't mention only loading the schema for the proxy (unless I've missed something).

Thanks again.

Mark.

**dimir** · 15-06-2012, 14:32

http://www.zabbix.com/documentation/...zabbix_daemons

In section "3. Create Zabbix database" it is mentioned:

[...]
SQL scripts are provided for creating database schema and, with Zabbix server, inserting a default dataset as well.
[...]

However, I agree that this is not mentioned explicitly enough. We will fix that in documentation. Thanks for pointing this out.

**skygge** · 15-06-2012, 15:33

Hello,

I have problems with proxy database (mysql 5.5) after upgrade.
I did everything as mentioned above during proxy update from 1.8 to 2.0 (drop database, create empty database, import "schema.sql"). At this step I have no errors.

But in zabbix_proxy.log I see:
22442:20120615:151902.273 Received configuration data from server. Datalen 178475
22442:20120615:151902.529 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`config`, CONSTRAINT `c_config_2` FOREIGN KEY (`discovery_groupid`) REFERENCES `groups` (`groupid`)) [insert into config (configid,refresh_unsupported,discovery_groupid,sn mptrap_logging) values (1,600,0,1);
]
22442:20120615:151902.529 failed to update local proxy cofiguration copy: database error

and then:
22479:20120615:151934.139 cannot send list of active checks to [192.168.54.14]: host [db-xxx] not found
22485:20120615:151937.834 cannot send list of active checks to [192.168.49.1]: host [rtr-yyy] not found
22483:20120615:151941.193 cannot send list of active checks to [192.168.59.1]: host [rtr-zzz] not found
...
...
all hosts "not found".

Manually execute this SQL query returns error:

mysql> insert into config (configid,refresh_unsupported,discovery_groupid,sn mptrap_logging) values (1,600,0,1);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`config`, CONSTRAINT `c_config_2` FOREIGN KEY (`discovery_groupid`) REFERENCES `groups` (`groupid`))

What is wrong?
Thanx
Skygge

**dimir** · 15-06-2012, 16:42

Are you using 1.8 server with proxy 2.0?

**skygge** · 15-06-2012, 19:59

No, of course not. Server was updated before.

I dropped this foreign key:
mysql> ALTER TABLE `config` DROP FOREIGN KEY `c_config_2`;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

Then created it once again:
mysql> ALTER TABLE `config` ADD CONSTRAINT `c_config_2` FOREIGN KEY (`discovery_groupid`) REFERENCES `groups` (`groupid`);
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

And the Insert:
mysql> insert into config (configid,refresh_unsupported,discovery_groupid,sn mptrap_logging) values (1,600,0,1);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`config`, CONSTRAINT `c_config_2` FOREIGN KEY (`discovery_groupid`) REFERENCES `groups` (`groupid`))

**skygge** · 18-07-2012, 13:21

UP.

I almost gave up.

I exported whole zabbix database, each table into separate text file, only data without table schema.

Then I created empty database, created schema from source 2.0 directory, and imported previously exported tables into new database. Everything went fine without any errors.

I configured Zabbix server and web interface to use this new database and I started it up.

On Zabbix Proxy I dropped database and re-created it from script.

Zabbix Proxy start and....

Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`config`, CONSTRAINT `c_config_2` FOREIGN KEY (`discovery_groupid`) REFERENCES `groups` (`groupid`)) [insert into config (configid,refresh_unsupported,discovery_groupid,sn mptrap_logging) values (1,600,0,1);

I almost lost my hope...

**dimir** · 18-07-2012, 16:19

Are you sure the proxy uses this new freshly created database?

**skygge** · 08-08-2012, 09:59

OK, I solved this issue.

I removed completely zabbix server database and whole database software including MySQL rpms and rm -fr /var/lib/mysql dir (database size was over 100GB

).

I installed newest MySQL version from scratch, created new empty database from source dir and imported every table one by one (data only, without the structure).

Now I have problems with triggers - all disappeared, but at last my Zabbix is collecting data. I'll fix the triggers manually.

Edit: Triggers fixed. See you on the next update!

**gigatec** · 17-08-2012, 16:12

Sorry to bring this up again - the proxy problem came back:

Code:

[Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [insert into applications (applicationid,hostid) values (100100000000463,100100000010053);
insert into applications (applicationid,hostid) values (100100000000665,100100000010053);

[Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`app
insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000011,'WEBSITE NAME',100100000000463,300,'','gigatec Monitoring',0,'','');
insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000013,'WEBSITE NAME',100100000000463,300,'','gigatec Monitoring',0,'','');
insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'WEBSITE NAME',100100000000665,300,'','gigatec Monitoring',0,'','');
insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'WEBSITE NAME',100100000000665,300,'','gigatec Monitoring',0,'','');

...

Both server and proxy are version 2.0.2, I've already deleted the proxy database and restarted with a fresh 2.0.2 schema.sql on the proxy. Errors above appear on initial sync with the server. At least the last added webcheck which should run on the proxy keeps in state unknown.

MySQL: Server version: 5.1.63-0+squeeze1 (Debian)

Any help is welcome...

Thanks
Stephan

**lana_paradinha** · 19-03-2014, 15:54

i received this erros

21586:20140319:104842.159 Received configuration data from server. Datalen 14107
21586:20140319:104842.388 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`host_discovery`, CONSTRAINT `c_host_discovery_3` FOREIGN KEY (`parent_itemid`) REFERENCES `items` (`itemid`)) [delete from items where (itemid between 10055 and 10059 or itemid between 22700 and 22744 or itemid between 22755 and 22789 or itemid between 22796 and 22846 or itemid between 22851 and 22863 or itemid between 22867 and 22886 or itemid between 22891 and 22903 or itemid between 22907 and 22914 or itemid between 22920 and 22924 or itemid between 22938 and 22954 or itemid between 22980 and 22994 or itemid between 22996 and 23005 or itemid between 23011 and 23036 or itemid between 23058 and 23063 or itemid between 23067 and 23078 or itemid between 23108 and 23131 or itemid between 23134 and 23138 or itemid between 23158 and 23165 or itemid between 23167 and 23329 or itemid between 23340 and 23360 or itemid between 23542 and 23569 or itemid between 23575 and 23579 or itemid between 23595 and 23608 or itemid between 23628 and 23659 or itemid in (10009,10010,10013,10014,10016,10019,10020,10025,1 0026,10030,17318,17350,17352,17354,17356,17358,173 60,17362,22181,22183,22185,22187,22189,22191,22196 ,22199,22219,22231,22232,22396,22399,22400,22401,2 2402,22404,22406,22408,22410,22412,22414,22416,224 18,22420,22422,22424,22426,22428,22430,22444,22446 ,22448,22450,22452,22454,22456,22458,22665,22668,2 2671,22674,22677,22680,22683,22686,22689,22746,227 49,22793,22848,22888,22917,22918,22933,22934,22961 ,22962,22963,22965,22968,22971,22972,22973,22974,2 2978,23007,23039,23041,23042,23043,23053,23054,231 40,23143,23144,23145,23147,23148,23149,23150,23540 ,23572,23573,23585,23586,23587,23588,23593,23620,2 3625))]
21586:20140319:104842.423 failed to update local proxy configuration copy: database error

My zabbix server is 2.2.2 and proxy is 2.2.2

Ad Widget

Proxy database update error

Proxy database update error

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment