Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
IDS 9.21.UC4
ESQL 9.16.UC1
Solaris 2.6
One of our clients use a very old C application which updates a
TEXT field. I don't know what it does, but once it updates it
causes informix to crash. From the af file I traced it to Informix
bug 155840.
I have little control over the application and when I saw that the
crash is something to do with buffer and blob data type, I created
a blob dbspace and moved that TEXT column to that dbspace. By doing
that at least we don't have to deal with buffers. As I expected,
this stopped crashing the server. However it created a new problem.
After updating the text field, we can no longer process that row.
Attempt to select that row results in error -602 (isam error -165).
Attempt to delete that row results in error -240 (isam error -105).
It is clear that the application is doing something wrong with the
TEXT field. But why should it cause the server to behave like this.
I think the server should insulate itself from application programming
errors.
Anyhow has anyone come across this bug? Any workaround.
thanks.
Ravi.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.