Informix - Problem description
Problem IT14159 | Status: Closed |
9810 AND 12097 ERRORS WHEN SELECTING SMART BLOBS (SLOBS) THAT WERE JUST UPDATED ON RSS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When you update a sblob on an RSS, it's possible for a subsequent query of that sblob from the RSS will return 9810/12097 errors. If you trap for the 9810, the stack when the error occurs looks comparable to: (/vobs/tristarm/sqldist/bin/oninit) afstack (/vobs/tristarm/sqldist/bin/oninit) afhandler (/vobs/tristarm/sqldist/bin/oninit) affail_interface (/vobs/tristarm/sqldist/bin/oninit) check_traperror (/vobs/tristarm/sqldist/bin/oninit) sqerr (/vobs/tristarm/sqldist/bin/oninit) sq_lo_open (/vobs/tristarm/sqldist/bin/oninit) sq_lo_to_buff_withseek (/vobs/tristarm/sqldist/bin/oninit) sq_lo_to_buff (/vobs/tristarm/sqldist/bin/oninit) mi_lo_to_buffer (/vobs/tristarm/sqldist/bin/oninit) bson_to_char (/vobs/tristarm/sqldist/bin/oninit) bson_output (/vobs/tristarm/sqldist/bin/oninit) udrlm_clang_execute_internal (/vobs/tristarm/sqldist/bin/oninit) udrlm_clang_execute (/vobs/tristarm/sqldist/bin/oninit) udrlm_exec_routine (/vobs/tristarm/sqldist/bin/oninit) udr_execute (/vobs/tristarm/sqldist/bin/oninit) exroutine (/vobs/tristarm/sqldist/bin/oninit) geval (/vobs/tristarm/sqldist/bin/oninit) geval (/vobs/tristarm/sqldist/bin/oninit) bson_get (/vobs/tristarm/sqldist/bin/oninit) geval (/vobs/tristarm/sqldist/bin/oninit) ev_geval (/vobs/tristarm/sqldist/bin/oninit) new_eval (/vobs/tristarm/sqldist/bin/oninit) gettupl (/vobs/tristarm/sqldist/bin/oninit) scan_next (/vobs/tristarm/sqldist/bin/oninit) next_row (/vobs/tristarm/sqldist/bin/oninit) get_first_row_from_producer (/vobs/tristarm/sqldist/bin/oninit) group_open (/vobs/tristarm/sqldist/bin/oninit) filltemp (/vobs/tristarm/sqldist/bin/oninit) scan_open (/vobs/tristarm/sqldist/bin/oninit) materialize_viewtmp (/vobs/tristarm/sqldist/bin/oninit) materialize_viewtmp (/vobs/tristarm/sqldist/bin/oninit) prepselect (/vobs/tristarm/sqldist/bin/oninit) open_cursor (/vobs/tristarm/sqldist/bin/oninit) sql_open (/vobs/tristarm/sqldist/bin/oninit) sq_open (/vobs/tristarm/sqldist/bin/oninit) sqmain (/vobs/tristarm/sqldist/bin/oninit) spawn_thread (/vobs/tristarm/sqldist/bin/oninit) th_init_initgls (/vobs/tristarm/sqldist/bin/oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.03.2016 29.06.2016 29.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |