Zabbix 1.6 + oracle: LIBSQLORA8 Memory allocation error

[ZhidkovAN]

Hello!

I have problem:
Zabbix server crashed after several minutes. In log:

29604:20080922:155032 Query::select t.triggerid,t.expression,t.description,t.url,t.com ments,t.status,t.value,t.priority from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.status in (0) and t.value not in (2) and i.itemid=20935
29604:20080922:155032 Query failed:SLQORALIB *** FATAL *** : allocation of statement failedLIBSQLORA8-30002: Memory allocation error.

p.s. server running under SLES 9

[Alexei]

Anyone else having this problem?

[ZhidkovAN]

add info

1. sql query different at different crashes.
2. server crashed ~ after 30 min.

DBfree_result ??? The same problem in zbx 1.1.2 and solved in 1.1.3

[Alexei]

Thanks for the hint! Yes, DBfree_result() is missing there causing memory leak. It will be fixed asap.

[ZhidkovAN]

Solution

Hi!

I found it. Function DBupdate_item_status_to_notsupported in src\libs\zbxdbhigh\db.c

# diff db.old db.c
965c965,967
<
---
>
> DBfree_result(result);
>

[Alexei]

This problem was registered as ZBX-488.

[teferi]

This problem was registered as ZBX-488.

Is it possible that this also caused https://support.zabbix.com/browse/ZBX-467 ??

[Alexei]

Is it possible that this also caused https://support.zabbix.com/browse/ZBX-467 ??

I don't know. We are unable to repeat this problem.

I would be very interested to hear that it resolves ZBX-467 as well.

[teferi]

I don't know. We are unable to repeat this problem.

I would be very interested to hear that it resolves ZBX-467 as well.

I have triggers for it(and a script that restarts proxy =)), so in a few days I'll post here if the problem is gone.

[Alexei]

Ok, cool. I am looking forward to hearing from you soon. Why don't all the weird things happen in our test environments?!

[minervino]

I fix the .c and the server now is ok

[teferi]

Still cannot be sure for 100% but it seems like my problem with postgres is also gone.

[pace]

Still leaking...

I think I'm not doing the right thing to get this patched: I downloaded 1.6 again and recompiled it, but I'm still leaking. Can someone point me in the right direction for patching this?


Thanks!
pace

[jansonz]

The same problem

Hello,

I have the same error: Query failed:SLQORALIB *** FATAL *** : allocation of statement failedLIBSQLORA8-30002: Memory allocation error.


What can I do to fix this bug?

[Silvery]

I don't have this error message. But my servers memory is leaking, too.
The servers has 768MB memory and after a few hours there are only 7MB left. This happened from the start when no hosts and items where created.

Adding DBfree_result(result); into Function DBupdate_item_status_to_notsupported didn't change anything...