[ZBX-4644] server can not survive some oracle-down conditions Created: 2012 Feb 10  Updated: 2017 May 30  Resolved: 2012 Sep 04

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.9
Fix Version/s: None

Type: Incident report Priority: Critical
Reporter: richlv Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: crash, database, oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

oracle 11.203

Issue Links:
Duplicate
duplicates ZBX-4661 server crash when Oracle database is ... Closed

 Description   

while zabbix server tries to survive database down conditions, sometimes it does die with signal 6 (sigabrt)

19119:20120210:104009.143 server #681 started history syncer #30
19119:20120210:113143.724 [Z3005] query failed: [-1] ORA-04031: unable to allocate 3912 bytes of shared memory
18410:20120210:113143.760 One child process died (PID:19119,exitcode/signal:6). Exiting ...

for the record, there seemed to be other message occurrences like that, which didn't seem to result in immediate process death (although it might be just a question of time)

19150:20120210:113143.691 [Z3005] query failed: [-1] ORA-04031: unable to allocate 4120 bytes of shared memory
19119:20120210:113143.724 [Z3005] query failed: [-1] ORA-04031: unable to allocate 3912 bytes of shared memory
19114:20120210:113143.725 [Z3005] query failed: [-1] ORA-04031: unable to allocate 4104 bytes of shared memory
19141:20120210:113143.782 [Z3005] query failed: [-1] ORA-04031: unable to allocate 4104 bytes of shared memory
19104:20120210:113143.849 [Z3005] query failed: [-1] ORA-04031: unable to allocate 1560 bytes of shared memory
18410:20120210:113239.779 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
18410:20120210:113241.236 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
18410:20120210:113251.252 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
18410:20120210:113301.254 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
18410:20120210:113311.256 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
18410:20120210:113321.258 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-12528: TNS:listener: all appropriate instances are blocking new connections
18410:20120210:113331.280 [Z3001] connection to database '//oracle:1521/O' failed: [-1] ORA-01033: ORACLE initialization or shutdown in progress

 Comments   
Comment by Alexei Vladishev [ 2012 Feb 10 ]

Have a look at http://ora-04031.ora-code.com/. That's something on Oracle server side, IMHO.

Comment by richlv [ 2012 Feb 11 ]

the inability to allocate memory - definitely. but zabbix server was supposed to survive db being down & retry - apparently, in this case it's not (and it dies with sigabrt)

edit : if course, if this is coming from the oci library and can not be avoided, this issue should be closed. the fact that there is no backtrace makes me slightly suspicious

Comment by Oleksii Zagorskyi [ 2012 Feb 15 ]

very similar but seems another issue is ZBX-4661

Comment by Alexei Vladishev [ 2012 Sep 04 ]

I am closing it. I think ZBX-4661 is exactly the same issue.

Generated at Thu Apr 25 19:29:17 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.