Informix - Problem description
Problem IT18144 | Status: Closed |
PDQ INSERT WHEN SELECT FROM AN EXTERNAL TABLE WITH WRONG DELIMITER CAN ASSERT AN XLCNV THREAD | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A PDQ insert when selecting from an external table with a wrong delimiter can cause an assert failure: afstack mt_ex_throw_sig afsig_handler (/usr/lib/hpux64/libc.so.1)_doprnt (/usr/lib/hpux64/libc.so.1)_doprnt (/usr/lib/hpux64/libc.so.1)_sprintf xlc_reject_rec xlc_next producer_thread startup coroutine_start Stack on IDS 12.10.FC8 (linux x86_64) (oninit) afstack (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) (/lib64/libc-2.5.so) __GI_strlen (/lib64/libc-2.5.so) _IO_vfprintf_internal (/lib64/libc-2.5.so) __IO_vsprintf (/lib64/libc-2.5.so) __GI_sprintf (oninit) xlc_reject_rec (oninit) xlc_next (oninit) producer_thread (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC1 through 12.10.xC8 and in all released * * versions of IDS 11.70. * **************************************************************** * PROBLEM DESCRIPTION: * * A query selecting from an external table may result in * * assertion failure under the following conditions: * * - the external table definition has wrong delimiter * * specified (delimited format) * * - PDQ is enabled * * - the result from selection from the external table is * * being inserted into another table * * - a reject file is also specified * **************************************************************** * RECOMMENDATION: * * Update to IDS 12.10.xC9+ or request a special build (if * * supported) on a later version of 11.70. * **************************************************************** | |
Local Fix: | |
The simple workaround is to use the correct delimiter. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.11.2016 31.10.2019 31.08.2020 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.0, 12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |