Informix - Problem description
Problem IT29116 | Status: Closed |
RUNNING A QUERY WITH MERGE FAILS WITH ERRORS -959/-172 AND CREATES AN ASSERTION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A query executed with MERGE fails with errors -959/-172 and creates an assertion. $ dbaccess mydb query Database selected. Explain set. 959: The current transaction has been rolled back due to an internal error. 172: ISAM error: Unexpected internal error Error in line 44 Near character position 50 $ 02/25/19 17:24:57 Maximum server connections 1 02/25/19 17:24:57 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 155, Llog used 473 02/25/19 17:26:04 Explain file for session 38 : /media/informix/usr2/work/cases/TS001904483_merge/Repro/sqexplai n.out 02/25/19 17:26:30 Assert Failed: No Exception Handler 02/25/19 17:26:30 IBM Informix Dynamic Server Version 12.10.FC12W1AEE 02/25/19 17:26:30 Who: Session(38, informix@nnnnnn, 5836, 0x450afcd8) Thread(142, sqlexec, 4506c458, 1) File: mtex.c Line: 508 02/25/19 17:26:30 Results: Exception Caught. Type: MT_EX_OS, Context: mem 02/25/19 17:26:30 Action: Please notify IBM Informix Technical Support. 02/25/19 17:26:30 See Also: /media/informix/usr2/prods/12.10/FC12W1/tmp/af.4766b96 02/25/19 17:26:32 Thread ID 142 will now be suspended. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Running a query with MERGE fails with errors -959/-172 and * * creates an assertion failure. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.05.2019 24.09.2019 24.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |