ZABBIX Forums  
  #1  
Old 18-12-2011, 07:25
frankymryao frankymryao is offline
Member
 
Join Date: Oct 2011
Location: Shanghai
Posts: 51
Default patch C code for TX lock of Oracle

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.
Reply With Quote
  #2  
Old 18-12-2011, 21:55
eskytthe eskytthe is offline
Senior Member
Zabbix Certified Specialist
 
Join Date: May 2011
Location: Denmark
Posts: 348
Default

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
Reply With Quote
  #3  
Old 08-01-2012, 17:34
mcadorette mcadorette is offline
Junior Member
 
Join Date: Nov 2011
Posts: 2
Default 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?
Reply With Quote
  #4  
Old 31-01-2012, 07:57
frankymryao frankymryao is offline
Member
 
Join Date: Oct 2011
Location: Shanghai
Posts: 51
Default

Quote:
Originally Posted by mcadorette View Post
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 frankymryao@gmail.com? I can't reply you in time because of the time zone. Thank you.
Reply With Quote
  #5  
Old 03-04-2012, 15:57
frankymryao frankymryao is offline
Member
 
Join Date: Oct 2011
Location: Shanghai
Posts: 51
Default

hi my friends, I have changed my mail box from frankymryao@gmail.com to baniu.yao@gmail.com. Today I checked my old mail box and found some emails about zabbix. Please send to baniu.yao@gmail.com and we would talk together.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 09:04.