Informix - Problem description
Problem IT04602 | Status: Closed |
THE CDR CHECK REPL UTILITY CORE DUMPS WHEN IT ENCOUNTERS AN EMPTY OWNER FIELD IN SYSINDICES | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
In certain circumstances, cdr check repl will look through the indices associated with a replicate table and if the owner of a unique index is an empty string, the process will report a segmentation violation and halt without reporting a meaningful error message. Using a debugger, the stack at the time of the segmentation violation is: Program received signal SIGSEGV, Segmentation fault. in __strlen_sse42 () from /lib64/libc.so.6 (gdb) where #0 in __strlen_sse42 () from /lib64/libc.so.6 #1 in stringCpy () #2 in findIdx () #3 in getPKCols () #4 in checkRepl () #5 in cdr_check () #6 in check_repl () #7 in main () This indicates the SEGV happened in a call made to strlen() from the stringCpy() function and is a good indicator of this problem. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * any customer using ER * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
Local Fix: | |
Workaround: Fix the index owner value. The best way is to identify the unique index or constraint, drop it and recreate it with a valid owner (i.e. not an empty owner string). The following SQL might help: select * from sysindices where tabid in (select tabid from systables where tabname="replicate_table_name_here"); select * from sysconstraints where tabid in (select tabid from systables where tabname="replicate_table_name_here"); | |
Solution | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.09.2014 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |