| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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) | |
