zabbix 1.4 is not running

[Slimm2]

zabbix 1.4 is not running (OS RedHat EL 4)

18602:20070626:124432 Starting zabbix_server. ZABBIX 1.4.
18602:20070626:124432 **** Enabled features ****
18602:20070626:124432 SNMP monitoring: YES
18602:20070626:124432 WEB monitoring: NO
18602:20070626:124432 Jabber notifications: NO
18602:20070626:124432 **************************
18610:20070626:124433 server #6 started [Trapper]
18612:20070626:124433 server #7 started [Trapper]
18614:20070626:124433 server #8 started [Trapper]
18616:20070626:124433 server #9 started [Trapper]
18618:20070626:124433 server #10 started [Trapper]
18620:20070626:124433 server #11 started [ICMP pinger]
18623:20070626:124433 server #12 started [Alerter]
18624:20070626:124433 server #13 started [Housekeeper]
18624:20070626:124433 Executing housekeeper
18629:20070626:124433 server #14 started [Timer]
18632:20070626:124433 server #16 started [Node watcher. Node ID:0]
18602:20070626:124433 server #0 started [Watchdog]
18602:20070626:124433 One child process died. Exiting ...
18602:20070626:124435 ZABBIX Server stopped

[Alexei]

It is quite likely that ou hit one of known issues of 1.4. Please wait a couple of days for release of 1.4.1.

[agehring]

Check to see if you have a entry in the "nodes" table of the sql database.

I f you do, and your not using distributed setup, there should not be any entry in that table.

Andrew

[Slimm2]

realy, table "nodes" is not empty
i'm recreate database now
bat resault is not change

[agehring]

Recreated database?

Check again. If it exists, simply do a "delete where" in the mysql database, and start the server.

If you have a Node id in your conf, then you'll continue to add one every time you start the server...

if your stating the server with the -n option you are adding one.. don't start with the -n option...

[Slimm2]

mysqladmin drop zabbix
mysqladmin create zabbix
mysql zabbix < schema/mysql.sql
mysql zabbix < data/data.sql
mysql zabbix < data/images_mysql.sql

mysql -e "select * from nodes" zabbix
<empty>

grep NodeID /etc/zabbix/zabbix_server.conf
NodeID=0

/usr/local/bin/zabbix_server

cat /tmp/zabbix_server.log
8758:20070629:144915 Starting zabbix_server. ZABBIX 1.4.
8758:20070629:144915 **** Enabled features ****
8758:20070629:144915 SNMP monitoring: YES
8758:20070629:144915 WEB monitoring: NO
8758:20070629:144915 Jabber notifications: NO
8758:20070629:144915 **************************
8766:20070629:144915 server #6 started [Trapper]
8768:20070629:144915 server #7 started [Trapper]
8770:20070629:144915 server #8 started [Trapper]
8772:20070629:144915 server #9 started [Trapper]
8774:20070629:144915 server #10 started [Trapper]
8776:20070629:144915 server #11 started [ICMP pinger]
8779:20070629:144915 server #12 started [Alerter]
8781:20070629:144915 server #13 started [Housekeeper]
8781:20070629:144915 Executing housekeeper
8785:20070629:144915 server #14 started [Timer]
8788:20070629:144915 server #16 started [Node watcher. Node ID:0]
8758:20070629:144915 server #0 started [Watchdog]
8758:20070629:144915 One child process died. Exiting ...
8758:20070629:144917 ZABBIX Server stopped

[Slimm2]

download zabbix-1.4.1
tar -zxf zabbix-1.4.1.tar.gz
cd zabbix-1.4.1
export CFLAGS=-lssl
./configure --enable-server --with-mysql --with-net-snmp
make
make install

grep -v ^# /etc/zabbix/zabbix_server.conf
NodeID=0
SenderFrequency=30
DebugLevel=3
Timeout=5
PidFile=/tmp/zabbix_server.pid
LogFile=/tmp/zabbix_server.log
AlertScriptsPath=/home/zabbix/bin/
DBHost=localhost
DBName=zabbix
DBUser=root
DBSocket=/var/lib/mysql/mysql.sock

start zabbix server:
/usr/local/bin/zabbix_server

cat /tmp/zabbix_server.log
27790:20070701:195658 Starting zabbix_server. ZABBIX 1.4.1.
27790:20070701:195658 **** Enabled features ****
27790:20070701:195658 SNMP monitoring: YES
27790:20070701:195658 WEB monitoring: NO
27790:20070701:195658 Jabber notifications: NO
27790:20070701:195658 **************************
27798:20070701:195658 server #6 started [Trapper]
27800:20070701:195658 server #7 started [Trapper]
27802:20070701:195658 server #8 started [Trapper]
27804:20070701:195658 server #9 started [Trapper]
27806:20070701:195658 server #10 started [Trapper]
27808:20070701:195658 server #11 started [ICMP pinger]
27811:20070701:195658 server #12 started [Alerter]
27813:20070701:195658 server #13 started [Housekeeper]
27813:20070701:195658 Executing housekeeper
27817:20070701:195658 server #14 started [Timer]
27820:20070701:195658 server #16 started [Node watcher. Node ID:0]
27790:20070701:195658 server #0 started [Watchdog]
27790:20070701:195658 One child process died. Exiting ...
27790:20070701:195700 ZABBIX Server stopped


Help me,
In my system (RedHat EL 4 ) something does not suffice.
I tasted other versions (1.0, 1.1.7), errors same.

[Slimm2]

help me

cat /tmp/zabbix_server.log
25284:20070709:184106 Starting zabbix_server. ZABBIX 1.4.1.
25284:20070709:184106 **** Enabled features ****
25284:20070709:184106 SNMP monitoring: YES
25284:20070709:184106 WEB monitoring: NO
25284:20070709:184106 Jabber notifications: NO
25284:20070709:184106 **************************
25284:20070709:184106 Query [select refresh_unsupported from config where configid>=100000000000000*0 and configid<=(100000000000000*0+99999999999999) ]
25284:20070709:184106 Query [select masterid from nodes where nodeid=0]
25284:20070709:184106 In DBupdate_triggers_after_restart()
25284:20070709:184106 Query [select distinct t.triggerid,t.expression,t.description,t.status,t. priority,t.value,t.url,t.comments from 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<1183992066 and i.key_<>'status' and h.status not in (4,3) and i.type not in (2)]
25284:20070709:184106 Query [select min(i.nextcheck+i.delay) from 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<>0 and t.triggerid=12768 and i.type not in (2)]
25284:20070709:184106 No triggers to update (2)
25284:20070709:184106 Query [select min(i.nextcheck+i.delay) from 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<>0 and t.triggerid=12769 and i.type not in (2)]
25284:20070709:184106 No triggers to update (2)
...
25284:20070709:184106 No triggers to update (2)
25284:20070709:184106 Query [select min(i.nextcheck+i.delay) from 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<>0 and t.triggerid=12811 and i.type not in (2)]
25284:20070709:184106 No triggers to update (2)
25284:20070709:184106 End of DBupdate_triggers_after_restart()
25292:20070709:184106 In child_trapper_main()
25292:20070709:184106 server #6 started [Trapper]
25294:20070709:184106 In child_trapper_main()
25294:20070709:184106 server #7 started [Trapper]
25296:20070709:184106 In child_trapper_main()
25296:20070709:184106 server #8 started [Trapper]
25299:20070709:184106 In child_trapper_main()
25299:20070709:184106 server #10 started [Trapper]
25301:20070709:184106 server #11 started [ICMP pinger]
25301:20070709:184106 In main_pinger_loop(num:1)
25301:20070709:184106 In create_host_file()
25301:20070709:184107 Query [select distinct h.ip from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.status=0 and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
25301:20070709:184107 Query [select distinct h.dns from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.status=0 and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
25301:20070709:184107 In do_ping()
25304:20070709:184107 server #12 started [Alerter]
25304:20070709:184107 Query [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,mt.mediatypeid,mt.type,mt.description, mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_ path,mt.gsm_modem,mt.username,mt.passwd from alerts a,media_type mt where a.status=0 and a.retries<3 and a.mediatypeid=mt.mediatypeid and mt.mediatypeid>=100000000000000*0 and mt.mediatypeid<=(100000000000000*0+99999999999999) order by a.clock]
25306:20070709:184107 server #13 started [Housekeeper]
25306:20070709:184107 Executing housekeeper
25297:20070709:184107 In child_trapper_main()
25297:20070709:184107 server #9 started [Trapper]
25306:20070709:184107 Query [begin;]
25307:20070709:184107 server #14 started [Timer]
25307:20070709:184107 Query [select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i, functions f where h i.status=0 and f.function in ('nodata','date','dayofweek','time','now') and i.itemid=f.itemid and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
25306:20070709:184107 In housekeeping_history_and_trends(1183992067)
25306:20070709:184107 Query [select itemid,history,trends from items]
25306:20070709:184107 In delete_history(history,10001,5085207206488440839,0 )
25306:20070709:184107 Query [select min(clock) from history where itemid=10001]
25306:20070709:184107 In delete_history(history_uint,10001,5085207206488440 839,0)
25306:20070709:184107 Query [select min(clock) from history_uint where itemid=10001]
25314:20070709:184107 server #16 started [Node watcher. Node ID:0]
25314:20070709:184107 In main_nodeupdater_loop()
25314:20070709:184107 Starting sync with nodes
25306:20070709:184107 In delete_history(history_str,10001,50852072064884408 39,0)
25306:20070709:184107 Query [select min(clock) from history_str where itemid=10001]
25314:20070709:184107 Query [begin;]
25314:20070709:184107 In calculate_checksums
25314:20070709:184107 Query [delete from node_cksum where cksumtype=1]
25306:20070709:184107 In delete_history(history_str,10001,50852072064884408 39,0)
25306:20070709:184107 Query [select min(clock) from history_str where itemid=10001]
25284:20070709:184107 server #0 started [Watchdog]
25306:20070709:184107 In delete_history(history_log,10001,50852072064884408 39,0)
25306:20070709:184107 Query [select min(clock) from history_log where itemid=10001]
25314:20070709:184107 Query [select nodeid from nodes]
25284:20070709:184107 In init_config()
25284:20070709:184107 Query [select mt.mediatypeid, mt.type, mt.description, mt.smtp_server, mt.smtp_helo, mt.smtp_email, mt.exec_path, mt.gsm_modem, mt.username, mt.passwd, m.mediaid,m.userid,m.mediatypeid,m.sendto,m.severi ty,m.period from media m, users_groups u, config c,media_type mt where m.userid=u.userid and u.usrgrpid=c.alert_usrgrpid and m.mediatypeid=mt.mediatypeid and m.active=0]
25306:20070709:184108 In delete_history(trends,10001,5085207206488441197,0)
25306:20070709:184108 Query [select min(clock) from trends where itemid=10001]
25314:20070709:184108 Query [select curr.nodeid,curr.tablename,curr.recordid from node_cksum prev, node_cksum curr where curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.fieldname=prev.fieldname and curr.nodeid=prev.nodeid and curr.cksum<>prev.cksum and curr.cksumtype=1 and prev.cksumtype=0]
25284:20070709:184108 One child process died. Exiting ...
25306:20070709:184108 Got signal. Exiting ...
25294:20070709:184108 Got signal. Exiting ...
25296:20070709:184108 Got signal. Exiting ...
25297:20070709:184108 Got signal. Exiting ...
25301:20070709:184108 Got signal. Exiting ...
25304:20070709:184108 Got signal. Exiting ...
25307:20070709:184108 Got signal. Exiting ...
25314:20070709:184108 Got signal. Exiting ...
25292:20070709:184108 Got signal. Exiting ...
25299:20070709:184108 Got signal. Exiting ...
25308:20070709:184108 Got signal. Exiting ...
25290:20070709:184108 Got signal. Exiting ...
25287:20070709:184108 Got signal. Exiting ...
25288:20070709:184108 Got signal. Exiting ...
25316:20070709:184108 Got signal. Exiting ...
25284:20070709:184110 ZABBIX Server stopped

[Alexei]

Please download pre 1.4.2 from www.zabbix.com/developers.php and report back if it solves your problem. Thank you.

[Slimm2]

It has not solved a problem
Whether there are more constructive ways of the decision of a problem?
I tested, server starting, if make without net-snmp
I posted log, can them help you to see what's the problem in? Can give another information if it is necessary.

[Alexei]

I would appreciate if you could post FULL log file with Debug level 4, for a server running pre 1.4.2 code. Thank you.

[Slimm2]

18015:20070710:143442 Starting zabbix_server. ZABBIX 1.4.1.
18015:20070710:143442 **** Enabled features ****
18015:20070710:143442 SNMP monitoring: YES
18015:20070710:143442 WEB monitoring: NO
18015:20070710:143442 Jabber notifications: NO
18015:20070710:143442 **************************
18015:20070710:143442 Query [select refresh_unsupported from config where configid>=100000000000000*0 and configid<=(100000000000000*0+99999999999999) ]
18015:20070710:143442 Query [select masterid from nodes where nodeid=0]
18015:20070710:143442 In DBupdate_triggers_after_restart()
18015:20070710:143442 Query [select distinct t.triggerid,t.expression,t.description,t.status,t. priority,t.value,t.url,t.comments from 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<1184063682 and i.key_<>'status' and h.status not in (4,3) and i.type not in (2)]
18015:20070710:143442 Query [select min(i.nextcheck+i.delay) from 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<>0 and t.triggerid=12768 and i.type not in (2)]
18015:20070710:143442 No triggers to update (2)
18015:20070710:143442 Query [select min(i.nextcheck+i.delay) from 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<>0 and t.triggerid=12769 and i.type not in (2)]
18015:20070710:143442 No triggers to update (2)
...
18015:20070710:143442 End of DBupdate_triggers_after_restart()
18023:20070710:143442 In child_trapper_main()
18023:20070710:143442 server #6 started [Trapper]
18025:20070710:143442 In child_trapper_main()
18025:20070710:143442 server #7 started [Trapper]
18027:20070710:143442 In child_trapper_main()
18027:20070710:143442 server #8 started [Trapper]
18029:20070710:143442 In child_trapper_main()
18029:20070710:143442 server #9 started [Trapper]
18031:20070710:143442 In child_trapper_main()
18031:20070710:143442 server #10 started [Trapper]
18033:20070710:143442 server #11 started [ICMP pinger]
18033:20070710:143442 In main_pinger_loop(num:1)
18033:20070710:143442 In create_host_file()
18033:20070710:143442 Query [select distinct h.ip from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.status=0 and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
18033:20070710:143442 Query [select distinct h.dns from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.status=0 and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
18033:20070710:143442 In do_ping()
18037:20070710:143442 server #13 started [Housekeeper]
18037:20070710:143442 Executing housekeeper
18037:20070710:143442 In housekeeping_history_and_trends(1184063682)
18037:20070710:143442 Query [select itemid,history,trends from items]
18037:20070710:143442 In delete_history(history,10001,5085514790571343879,8 642548)
18037:20070710:143442 Query [select min(clock) from history where itemid=10001]
18037:20070710:143442 In delete_history(history_uint,10001,5085514790571343 879,8642548)
...
18039:20070710:143442 server #14 started [Timer]
18039:20070710:143442 Query [select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i, functions f where h.hostid=i.hostid and h.status=0 and i.status=0 and f.function in ('nodata','date','dayofweek','time','now') and i.itemid=f.itemid and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
18036:20070710:143442 server #12 started [Alerter]
18036:20070710:143442 Query [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,mt.mediatypeid,mt.type,mt.description, mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_ path,mt.gsm_modem,mt.username,mt.passwd from alerts a,media_type mt where a.status=0 and a.retries<3 and a.mediatypeid=mt.mediatypeid and mt.mediatypeid>=100000000000000*0 and mt.mediatypeid<=(100000000000000*0+99999999999999) order by a.clock]
18037:20070710:143442 In delete_history(history_log,10032,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_log where itemid=10032]
18037:20070710:143442 In delete_history(trends,10032,5085514790571344237,86 42548)
...
18045:20070710:143442 server #16 started [Node watcher. Node ID:0]
18045:20070710:143442 In main_nodeupdater_loop()
18045:20070710:143442 Starting sync with nodes
18045:20070710:143442 Query [begin;]
18045:20070710:143442 In calculate_checksums
18045:20070710:143442 Query [delete from node_cksum where cksumtype=1]
18037:20070710:143442 In delete_history(history_text,10036,5085514790571343 879,8642548)
18045:20070710:143442 Query [select nodeid from nodes]
18037:20070710:143442 Query [select min(clock) from history_text where itemid=10036]
18037:20070710:143442 In delete_history(history_log,10036,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_log where itemid=10036]
18045:20070710:143442 Query [select curr.nodeid,curr.tablename,curr.recordid from node_cksum prev, node_cksum curr where curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.fieldname=prev.fieldname and curr.nodeid=prev.nodeid and curr.cksum<>prev.cksum and curr.cksumtype=1 and prev.cksumtype=0]
18037:20070710:143442 In delete_history(trends,10036,5085514790571344237,86 42548)
18037:20070710:143442 Query [select min(clock) from trends where itemid=10036]
18037:20070710:143442 In delete_history(history,10037,5085514790571343879,8 642548)
18045:20070710:143442 Query [select curr.nodeid,curr.tablename,curr.recordid from node_cksum curr left join node_cksum prev on curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.fieldname=prev.fieldname and curr.nodeid=prev.nodeid and curr.cksumtype<>prev.cksumtype where prev.cksumid is null and curr.cksumtype=1]
18037:20070710:143442 Query [select min(clock) from history where itemid=10037]
18037:20070710:143442 In delete_history(history_uint,10037,5085514790571343 879,8642548)
18037:20070710:143442 Query [select min(clock) from history_uint where itemid=10037]
18045:20070710:143442 Query [select curr.nodeid,curr.tablename,curr.recordid from node_cksum curr left join node_cksum prev on curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.fieldname=prev.fieldname and curr.nodeid=prev.nodeid and curr.cksumtype<>prev.cksumtype where prev.cksumid is null and curr.cksumtype=0]
18037:20070710:143442 In delete_history(history_str,10037,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_str where itemid=10037]
18037:20070710:143442 In delete_history(history_text,10037,5085514790571343 879,8642548)
18045:20070710:143442 Query [delete from node_cksum where cksumtype=0]
18037:20070710:143442 Query [select min(clock) from history_text where itemid=10037]
18045:20070710:143442 Query [update node_cksum set cksumtype=0 where cksumtype=1]

[Slimm2]

18037:20070710:143442 In delete_history(history_log,10037,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_log where itemid=10037]
18045:20070710:143442 In main_nodesender()
18045:20070710:143442 Query [select nodeid from nodes where nodetype=1]
18037:20070710:143442 In delete_history(trends,10037,5085514790571344237,86 42548)
18037:20070710:143442 Query [select min(clock) from trends where itemid=10037]
18045:20070710:143442 Query [commit;]
18037:20070710:143442 In delete_history(history,10038,5085514790571343879,8 642548)
18045:20070710:143442 In main_eventsender()
18037:20070710:143442 Query [select min(clock) from history where itemid=10038]
18045:20070710:143442 Query [begin;]
18045:20070710:143442 In get_master_node(0)
18037:20070710:143442 In delete_history(history_uint,10038,5085514790571343 879,8642548)
18045:20070710:143442 Query [select masterid from nodes where nodeid=0]
18037:20070710:143442 Query [select min(clock) from history_uint where itemid=10038]
18045:20070710:143442 Query [commit;]
18037:20070710:143442 In delete_history(history_str,10038,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_str where itemid=10038]
18045:20070710:143442 In main_historysender()
18045:20070710:143442 Query [begin;]
18037:20070710:143442 In delete_history(history_text,10038,5085514790571343 879,8642548)
18045:20070710:143442 In get_master_node(0)
18037:20070710:143442 Query [select min(clock) from history_text where itemid=10038]
18045:20070710:143442 Query [select masterid from nodes where nodeid=0]
18037:20070710:143442 In delete_history(history_log,10038,50855147905713438 79,8642548)
18045:20070710:143442 Query [commit;]
18037:20070710:143442 Query [select min(clock) from history_log where itemid=10038]
18045:20070710:143442 Sleeping 10 seconds
18037:20070710:143442 In delete_history(trends,10038,5085514790571344237,86 42548)
18037:20070710:143442 Query [select min(clock) from trends where itemid=10038]
18037:20070710:143442 In delete_history(history,10039,5085514790571343879,8 642548)
18037:20070710:143442 Query [select min(clock) from history where itemid=10039]
18037:20070710:143442 In delete_history(history_uint,10039,5085514790571343 879,8642548)
18037:20070710:143442 Query [select min(clock) from history_uint where itemid=10039]
18037:20070710:143442 In delete_history(history_str,10039,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_str where itemid=10039]
18037:20070710:143442 In delete_history(history_text,10039,5085514790571343 879,8642548)
18037:20070710:143442 Query [select min(clock) from history_text where itemid=10039]
18037:20070710:143442 In delete_history(history_log,10039,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_log where itemid=10039]
18015:20070710:143442 server #0 started [Watchdog]
18037:20070710:143442 In delete_history(trends,10039,5085514790571344237,86 42548)
18037:20070710:143442 Query [select min(clock) from trends where itemid=10039]
18037:20070710:143442 In delete_history(history,10040,5085514790571343879,8 642548)
18037:20070710:143442 Query [select min(clock) from history where itemid=10040]
18015:20070710:143442 In init_config()
18015:20070710:143442 Query [select mt.mediatypeid, mt.type, mt.description, mt.smtp_server, mt.smtp_helo, mt.smtp_email, mt.exec_path, mt.gsm_modem, mt.username, mt.passwd, m.mediaid,m.userid,m.mediatypeid,m.sendto,m.severi ty,m.period from media m, users_groups u, config c,media_type mt where m.userid=u.userid and u.usrgrpid=c.alert_usrgrpid and m.mediatypeid=mt.mediatypeid and m.active=0]
18037:20070710:143442 In delete_history(history_uint,10040,5085514790571343 879,8642548)
18037:20070710:143442 Query [select min(clock) from history_uint where itemid=10040]
18037:20070710:143442 In delete_history(history_str,10040,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_str where itemid=10040]
18037:20070710:143442 In delete_history(history_text,10040,5085514790571343 879,8642548)
18037:20070710:143442 Query [select min(clock) from history_text where itemid=10040]
18015:20070710:143442 In ping_database()
18037:20070710:143442 In delete_history(history_log,10040,50855147905713438 79,8642548)
18037:20070710:143442 Query [select min(clock) from history_log where itemid=10040]
18037:20070710:143442 In delete_history(trends,10040,5085514790571344237,86 42548)
18037:20070710:143442 Query [select min(clock) from trends where itemid=10040]
18015:20070710:143442 Watchdog: Database is up
18037:20070710:143442 In delete_history(history,10046,5085514790571343879,8 642548)
18037:20070710:143442 Query [select min(clock) from history where itemid=10046]
...
18037:20070710:143442 In delete_history(history_uint,17017,5085514790571343 879,8642548)
18037:20070710:143442 Query [select min(clock) from history_uint where itemid=17017]
18015:20070710:143442 One child process died. Exiting ...
18047:20070710:143442 Got signal. Exiting ...
18025:20070710:143442 Got signal. Exiting ...
18037:20070710:143442 In delete_history(history_str,17017,50855147905713438 79,8642548)
18037:20070710:143442 Got signal. Exiting ...
18027:20070710:143442 Got signal. Exiting ...
18029:20070710:143442 Got signal. Exiting ...
18045:20070710:143442 Got signal. Exiting ...
18031:20070710:143442 Got signal. Exiting ...
18039:20070710:143442 Got signal. Exiting ...
18036:20070710:143442 Got signal. Exiting ...
18033:20070710:143442 Got signal. Exiting ...
18023:20070710:143442 Got signal. Exiting ...
18015:20070710:143444 ZABBIX Server stopped