[dev.icinga.com #2303] ORA-24811 when writing CLOBs

[icinga-migration]

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

Created by Tommi on 2012-02-05 16:58:24 +00:00

Assignee: Tommi
Status: Closed (closed on 2012-04-03 19:07:56 +00:00)
Target Version: 1.7
Last Update: 2014-12-08 14:37:31 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

---

sometimes Oracle Error "ORA-24811: less data provided for writing than indicated" appears in ido2db debug log. This data will not be written

Changesets

2012-02-05 17:59:31 +00:00 by Tommi 575815a

idoutils: fix for oracle clob issue #2303
refs #2303

2012-04-02 18:34:50 +00:00 by Tommi 703426f

idoutils:enhance clob bind functions #2342,#2303
refs #2303,#2342

2012-04-03 18:48:27 +00:00 by Tommi 0906122

idoutils:fix wrong lob variable assignments, set lob chunk size back to 2048
refs #2303, #2342

---

Relations:

• relates #2303

[icinga-migration]

Updated by Tommi on 2012-02-05 17:03:50 +00:00

• Status changed from New to Assigned

it happens not this much, but was observed when writing a string like "HTTP CRITICAL - Konnte TCP socket nicht öffnen\n". strlen is 49, but oracle counts only 48. Looks like Backslashes doesnt count or there is a charset problem. Will provide bytecount instead of charcount and add more logging

[icinga-migration]

Updated by Tommi on 2012-02-22 18:32:32 +00:00

• Status changed from Assigned to Resolved
• Done % changed from 0 to 100

Problem occured with diffent counting of bytes and chars with UTF8. Replaced Error with warning. Looks OK for now.

[icinga-migration]

Updated by Tommi on 2012-04-02 18:54:51 +00:00

• Status changed from Resolved to Feedback
• Target Version set to 1.7

the same error came up along #2342. Added additional patch

[icinga-migration]

Updated by mfriedrich on 2012-04-03 11:32:12 +00:00

see my tests in #2342

[icinga-migration]

Updated by Tommi on 2012-04-03 19:07:56 +00:00

• Status changed from Feedback to Resolved

[icinga-migration]

Updated by Tommi on 2012-05-02 18:59:53 +00:00

• Status changed from Resolved to Closed

no more comments, will close this now

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:37:31 +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