delay of proxy

[kc5kse]

it sounds to me like zabbix is unable to connect to the database.
shut zabbix server down, start it and check the zabbix server logfile immediately after that.
also check mysql error log.

from mysqld.log:

091006 14:34:58 mysqld started
091006 14:35:01 InnoDB: Started; log sequence number 2051 1390811215
091006 14:35:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

from zabbix_server.log:

/usr/local/sbin/zabbix_server [7885]: DEBUG: ZABBIX semaphores already exist, trying to recreate.
7885:20091006:143621 Starting zabbix_server. ZABBIX 1.6.6 (revision 7836).
7885:20091006:143621 **** Enabled features ****
7885:20091006:143621 SNMP monitoring: YES
7885:20091006:143621 WEB monitoring: YES
7885:20091006:143621 Jabber notifications: NO
7885:20091006:143621 ODBC: NO
7885:20091006:143621 IPv6 support: NO
7885:20091006:143621 **************************
7885:20091006:143621 Query [SET CHARACTER SET utf8]
7885:20091006:143621 Query [select refresh_unsupported from config where 1=1 and configid between 100000000000000 and 1999999999999
99]
7885:20091006:143621 Query [select masterid from nodes where nodeid=1]
7885:20091006:143621 In DBupdate_triggers_after_restart()
7885:20091006:143621 Query [select distinct t.triggerid,t.expression,t.description,t.status,t. priority,t.value,t.url,t.comments fro
m hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.
delay<1254857781 and i.key_<>'status' and h.status not in (4,3) and i.type not in (2)]

[richlv]

that looks like debuglevel=4. set it to 3, restart server, make it stop accepting connections on port 10051, check logfile.
a sidenote, when server stops accepting connections... is it still running ?

[kc5kse]

that looks like debuglevel=4. set it to 3, restart server, make it stop accepting connections on port 10051, check logfile.
a sidenote, when server stops accepting connections... is it still running ?

Yes, log file continues to update.

I've restarted zabbix master server with debug set to 3. I have 5 proxies. I started one and now see movement on the Administration->Queues screen. Master server is still listening on port 10051. I'll start up another proxy and see how it goes.

[kc5kse]

Noticed this in the zabbix log:

8268:20091006:163048 [Z3005] Query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid']
8231:20091006:163048 [Z3005] Query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid']

[kc5kse]

After 4 proxies added, I am now unable to telnet to the master server on port 10051 from anywhere. Unable to find anything in the master logs.

Proxy logs show:

29549:20091006:163455 Unable connect to the server [10.10.220.133]:10051 [Cannot connect to [10.10.220.133:10051] [Interrupted system call]]

[kc5kse]

I've disabled a lot of hosts that were not really important. All proxies are working and data is going through, I think. I am unable to view Latest Data at all. Overview works but I can't bring up latest data.