suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    das ultimative Tool für Informix

    pfeil  
Neueste VersionenFixList
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT29116 Status: Geschlossen

RUNNING A QUERY WITH MERGE FAILS WITH ERRORS -959/-172 AND CREATES AN
ASSERTION

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
****************************************************************
* 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:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.05.2019
24.09.2019
24.09.2019
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC13
Problem behoben lt. FixList in der Version
Informix EditionenInformix Editionen
Informix Editionen
DokumentationDokumentation
Dokumentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download