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

Closed
icinga-migration opened this Issue Feb 5, 2012 · 7 comments

Comments

Projects
None yet
1 participant
Member

icinga-migration commented Feb 5, 2012

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:

Member

icinga-migration commented Feb 5, 2012

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

Member

icinga-migration commented Feb 22, 2012

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.

Member

icinga-migration commented Apr 2, 2012

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

Member

icinga-migration commented Apr 3, 2012

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

see my tests in #2342

Member

icinga-migration commented Apr 3, 2012

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

  • Status changed from Feedback to Resolved
Member

icinga-migration commented May 2, 2012

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

Member

icinga-migration commented Dec 8, 2014

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

icinga-migration added this to the 1.7 milestone Jan 17, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment