patch C code for TX lock of Oracle

[frankymryao]

Hi all,

We are using zabbix for monitoring our all servers and the number of items reached 30w. Our back-end database is Oracle. Last week, the issue of TX lock occurred to us. Once oracle have more than ONE TX lock(get from 'ora active | grep TX | wc -l'), the whole zabbix is out of work. We tried to make our intervals of items longer - 1400 value per second to 600 value per second. But it didn't make any sense. After our analyzing oracle performance, we found that the TX lock is caused by updating the table 'ids' in data base. Further, the root cause is the method of getting 'eventid' for concurrency(in src/libs/zbxdbhigh/db.c). We modified the source code for using 'sequence' in oracle instead the traditional method. After a week' observation, zabbix works well.

And now I'd like to share this experience for zabbix users.

[eskytthe]

Beside putting it here in the forum, a good place is also the zabbix jira (site for bugs and features):

https://support.zabbix.com/secure/Dashboard.jspa

You only need to make a new user account in the system.
BR
Erik

[mcadorette]

Please Share...

We have faced the same issue with Oracle as our backend. Can you share the modifications you made to use a sequence as well as what you had to do to implement it?

[frankymryao]

We have faced the same issue with Oracle as our backend. Can you share the modifications you made to use a sequence as well as what you had to do to implement it?

Hi, can you send email to [email protected]? I can't reply you in time because of the time zone. Thank you.

[frankymryao]

hi my friends, I have changed my mail box from [email protected] to [email protected]. Today I checked my old mail box and found some emails about zabbix. Please send to [email protected] and we would talk together.