[dev.icinga.com #2509] OCI-21500 [17099] Error on Oracle when freeing lobs on solaris

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/2509

Created by Tommi on 2012-04-09 06:20:39 +00:00

Assignee: Tommi
Status: Resolved (closed on 2012-04-25 16:44:34 +00:00)
Target Version: 1.7
Last Update: 2014-12-08 14:37:38 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

---

I ran into this error occasional on solaris. After digging into dbx there should be no problem from ido2db code perspective

lob_l = OCI_LobCreate(idi->dbinfo.oci_connection, OCI_CLOB);
...
if (lob_l) OCI_LobFree(lob_l);

dbx output:

OCI-21500: internal error code, arguments: [17099], [], [], [], [], [], [],
[]
t@1 (l@1) signal SEGV (no mapping at the fault address) in slaac_int at
0xffffffff7b43ab84
0xffffffff7b43ab84: slaac_int+0x02c4:   ldsb     [%l4], %o5
Current function is ido2db_query_insert_servicecheckdata_add
 1699           if (lob_l) OCI_LobFree(lob_l);
(dbx) where
current thread: t@1
  [1] slaac_int(0x0, 0x100, 0xffffffff7c51cb80, 0x0, 0xffffffff7e1a57a4,
0xffffffff7fffa5f0), at 0xffffffff7b43ab84
  [2] kgdsdaaddr(0x0, 0xffffffff7ffea320, 0x0, 0xffffffff7fffa53c, 0x0,
0x2), at 0xffffffff7b030704
  [3] kgdsdst(0xffffffff7fffa5f0, 0x43, 0x0, 0x10, 0x48,
0xffffffff7c31a0c8), at 0xffffffff7b02f744
  [4] skgudmp(0x1001f6458, 0x9b0, 0x2800, 0x1e2f790, 0xffffffff7c51cb80,
0x800), at 0xffffffff7a6ed454
  [5] kgeriv_int(0x1001f6458, 0xffffffff7c30f090, 0x0, 0x0,
0xffffffff7a6ed3e0, 0xffffffff7fffa968), at 0xffffffff7afcc9e4
  [6] kgesiv(0x1001f6458, 0x100200fa8, 0x42cb, 0x0, 0xffffffff7fffa968,
0x14a0), at 0xffffffff7afcfc24
  [7] kgesic0(0x1001f6458, 0x100200fa8, 0x42cb, 0x30c8, 0x1a0,
0xffffffffffffffff), at 0xffffffff7afcf9e0
  [8] kpultfr(0x10023a2d8, 0x10023baa8, 0x10033b4b8, 0x0, 0x0, 0x1), at
0xffffffff7a58b150
  [9] OCI_LobFree(0x10016e940, 0x2, 0x100055678, 0x1, 0x1, 0x1), at
0xffffffff7e71e484
=>[10] ido2db_query_insert_servicecheckdata_add(idi = 0xffffffff7fffea90,
data = 0xffffffff7fffe3a8), line 1699 in "dbqueries.c"
  [11] ido2db_handle_servicecheckdata(idi = 0xffffffff7fffea90), line 2698
in "dbhandlers.c"
  [12] ido2db_end_input_data(idi = 0xffffffff7fffea90), line 2145 in
"ido2db.c"
  [13] ido2db_handle_client_input(idi = 0xffffffff7fffea90, buf =
0x100656350 "999"), line 1813 in "ido2db.c"
  [14] ido2db_check_for_client_input(idi = 0xffffffff7fffea90), line 1485 in
"ido2db.c"
  [15] ido2db_handle_client_connection(sd = 7), line 1363 in "ido2db.c"
  [16] ido2db_wait_for_connections(), line 1165 in "ido2db.c"
  [17] main(argc = 4, argv = 0xffffffff7ffff768), line 312 in "ido2db.c"
(dbx) display lob_l
lob_l = 0x10016e940

Environment
icinga: 1.7.0dev
OS: SunOS 5.10 Generic_125100-10 sun4u sparc SUNW,Sun-Fire-V890 Solaris
cc: Sun C 5.9 SunOS_sparc Patch 124867-01 2007/07/12
ocilib:3.9.2
Oracle Instantclient 11.2 64bit

Changesets

2012-04-09 06:56:28 +00:00 by Tommi 717b9c8

idoutils: fix OCI-21500 when freeing lobs #2509
refs #2509

2012-04-28 09:22:00 +00:00 by Tommi 0d087fb

idoutils: fix OCI-21500 when freeing lobs #2509
refs #2509

Conflicts:

	Changelog

[icinga-migration]

Updated by Tommi on 2012-04-09 06:37:07 +00:00

• Status changed from New to Assigned

According to oracle metalink(ID 138565.1,Bug 5682121) this is in most cases a multithreading issue. I saw ocilib is not initialized with multithreading. I will add this mode (OCI_ENV_THREADED) to the code.

[icinga-migration]

Updated by Tommi on 2012-04-09 09:03:09 +00:00

• Status changed from Assigned to Feedback

applied in changeset 717b9c8. Maybe there is a performance impact, which should be observed if any. But the error doesnt came back until now.

[icinga-migration]

Updated by mfriedrich on 2012-04-19 13:08:30 +00:00

• Done % changed from 0 to 100

oh. thanks for the catch. it's running fine over here as well.

[icinga-migration]

Updated by mfriedrich on 2012-04-25 16:44:34 +00:00

• Status changed from Feedback to Resolved

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:37:38 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category changed from 61 to IDOUtils
• Icinga Version set to 1
• OS Version set to any