TCDBService Crashed

(Doc ID 2395093.1)

Last updated on MAY 07, 2018

Applies to:

Oracle Utilities Network Management System - Version 2.3.0.0.0 to 2.3.0.2.0 [Release 2.3]
Oracle Network Management for Utilities - DMS - Version 2.3.0.0.0 to 2.3.0.1.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

On : 2.3.0.0.0 version, NMS Infrastructure

TCDBService Crashed

The stack trace reads
Program terminated with signal 6, Aborted.
#0 0x00007fc08948454b in raise () from /lib64/libpthread.so.0
#0 0x00007fc08948454b in raise () from /lib64/libpthread.so.0
#1 0x00007fc086fed754 in skgesigOSCrash ()
from /u00/app/oracle/product/12.1.0/client_1/lib/libclntsh.so.12.1
#2 0x00007fc0872c4f76 in kpeDbgSignalHandler ()
from /u00/app/oracle/product/12.1.0/client_1/lib/libclntsh.so.12.1
#3 0x00007fc086fed945 in skgesig_sigactionHandler ()
from /u00/app/oracle/product/12.1.0/client_1/lib/libclntsh.so.12.1
#4 <signal handler called>
#5 0x00007fc0886bb207 in raise () from /lib64/libc.so.6
#6 0x00007fc0886bc8f8 in abort () from /lib64/libc.so.6
#7 0x00007fc0886b4026 in __assert_fail_base () from /lib64/libc.so.6
#8 0x00007fc0886b40d2 in __assert_fail () from /lib64/libc.so.6
#9 0x00007fc08a47528d in DBArray<oms::basic_string<char, std::char_traits<char>, std::allocator<char> > >::data_size(unsigned long) const ()
from /u00/nms/nms/product/2.3.0.0/lib/libWrapper.so
#10 0x00007fc0882625e9 in Oci8Binder::bind(OCIStmt&, OCIError&, DBVarBase&, unsigned long, unsigned long) () from /u00/nms/nms/product/2.3.0.0/lib/libomsdb.so
#11 0x00007fc08826475e in oms_oci::try_sql(char const*, std::vector<DBVarBase*, std::allocator<DBVarBase*> >&, int, bool, iommapstream*, ResultConsumer*) ()
from /u00/nms/nms/product/2.3.0.0/lib/libomsdb.so
#12 0x00007fc088265724 in oms_oci::do_sql(char const*, std::vector<DBVarBase*, std::allocator<DBVarBase*> >&, int, bool, iommapstream*, ResultConsumer*) ()
from /u00/nms/nms/product/2.3.0.0/lib/libomsdb.so
#13 0x00007fc0882660bc in oms::oci_base::sql(char const*, std::vector<DBVarBase*, std::allocator<DBVarBase*> >&, int, bool) ()
from /u00/nms/nms/product/2.3.0.0/lib/libomsdb.so
#14 0x000000000040b1c4 in db_sql(message*) ()
#15 0x000000000040b7b5 in db_mainloop() ()
#16 0x00000000004092e9 in main ()




The TCDBService log MAY contain this series of errors:
dbrdwr: Database.C:638: size_t DBArray<T>::data_size(size_t) const [with T = oms::basic_string<char, std::char_traits<char>, std::allocator<char> >; size_t = long unsigned int]: Assertion 'n < values.size()' failed.
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" **ERROR** DBOutboard msg_read(15) failed: Success
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" child process has terminated
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" *ERROR* - sql failed:
result=-1 error='dbrdwr is dead'
sql=[INSERT INTO job_notes (id, event_idx, note, user_id, log_time) VALUES (:id, :event_idx, :note, :user_id, TO_DATE(:log_time,'MM/DD/YYYY HH24:MI:SS'))]
host_vars=[{
id:{30137 }
event_idx:{18037277 }
note:{'send to field engineer. ' }
user_id:{'Mobile' }
log_time:{'04/18/2018 14:18:47' }
}]
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" **ERROR** Attempt to write message from DEAD DBOutboard
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" **ERROR** Attempt to read message from DEAD DBOutboard
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" sql error: (INSERT INTO job_notes (id, event_idx, note, user_id, log_time) VALUES (:id, :event_idx, :note, :user_id, TO_DATE(:log_time,'MM/DD/YYYY HH24:MI:SS'))) from (1/62:20895.0), result=-1
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" Database connection is dead, discarding it
04/18/18 14:18:47: 0x7f2a7f8da700,ctp=0x18936e8,"sql" DBConnection::close deleting rep 0x1809190

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms