[collectd] collectd crash/exit on oracle connection error

[Bob Cotton]

collectd 4.6.2
Oracle 10g
Linux centos 5.3

Trying out the oracle plugin. When the database is down it causes collectd
to exit or crash (i'm guessing exit).

Last syslogs:

Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin:
o_read_database_query: OCIStmtExecute failed: ORA-03113: end-of-file on
communication channel
Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin:
o_read_database_query: Failing statement was: select sum(vf.PHYBLKRD)*8192
as PHY_BLK_R, sum(vf.PHYBLKWRT)*8192 as PHY_BLK_W, 'tablespace' AS i_prefix,
dt.tablespace_name from ((dba_data_files dd join v$filestat vf on dd.file_id
= vf.file# ) join dba_tablespaces dt on dd.tablespace_name =
dt.tablespace_name) group by
dt.tablespace_name

Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin:
o_read_database_query: OCIStmtExecute failed: ORA-03114: not connected to
ORACLE
Apr 20 00:06:29 crushdb collectd[6553]: oracle plugin:
o_read_database_query: Failing statement was: select
round(sum(decode(METRIC_NAME, 'Database Wait Time Ratio', value)),2) as
DATABASE_WAIT_TIME_RATIO, round(sum(decode(METRIC_NAME, 'Database CPU Time
Ratio', value)),2) as DATABASE_CPU_TIME_RATIO, 'DB_EFFICIENCY' AS
DB_EFFICIENCY from SYS.V_$SYSMETRIC where   METRIC_NAME IN ('Database CPU
Time Ratio', 'Database Wait Time Ratio') AND INTSIZE_CSEC = (select
max(INTSIZE_CSEC) from SYS.V_$SYSMETRIC)

Where else should I look?

Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.verplant.org/pipermail/collectd/attachments/20090420/ea985dae/attachment.htm