home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 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 IT04185 Status: Geschlossen

GETTING AF ON SELECT FROM VTI EXPRESSION TABLE

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
Doing a select containing a where condition like 
select * from vts where  tmstamp > today 
 
will generate an Af file, displays error messages 
 244: Could not do a physical-order read to fetch next row. 
 
12803: Error in executing an access_method routine execution 
sequence. 
 
and writes also error message 9871 to the online.log 
14:49:47  Assert Failed: Exception Caught. Type: MT_EX_OS, 
Context: mem 
14:49:47  IBM Informix Dynamic Server Version 12.10.FC4X1 
14:49:47   Who: Session(30, informix@bosshost, 11817, 10aaa9648) 
                Thread(61, sqlexec, 10aa690a8, 1) 
                File: mtex.c Line: 420 
14:49:47   Action: Please notify IBM Informix Technical Support. 
14:49:47  stack trace for pid 11583 written to /dump/af.4256b65 
14:49:48   See Also: /dump/af.4256b65 
14:49:54  Exception Caught. Type: MT_EX_OS, Context: mem 
14:49:54  (-9791): ERROR: Routine execution trap -- 
procname=<ts_vtam_beginscan> procid=581 
    reason: mem 
14:51:20  Checkpoint Completed:  duration was 0 seconds. 
14:51:20  Mon Sep  1 - loguniq 32, logpos 0xa14018, timestamp: 
0x229aee Interval: 1208 
 
 
this is the stack on Solaris: 
14:49:41  Stack for thread: 61 sqlexec 
... 
0xffffffff7c168504 ts_vtam_sem_log_record_dump 
0xffffffff7c16b218 ts_vtam_pdq_foreground_send_command 
0xffffffff7c16c128 ts_vtam_beginscan 
0x1006f3b4c oninit :: udrlm_clang_execute_interna 
0x1006f2634 oninit :: udrlm_clang_execute 
0x1006ebdac oninit :: udrlm_exec_routine 
0x1002ff710 oninit :: udr_execute 
0x10145c4d4 oninit :: vti_vii_udr_execute 
0x101453060 oninit :: vti_beginscan 
0x1014535b4 oninit :: vti_getnext 
0x1012c1c24 oninit :: fmread 
0x100430edc oninit :: readseq_single 
0x10042fcd4 oninit :: gettupl 
0x10042a850 oninit :: scan_next 
0x10044816c oninit :: getrow 
0x100447d8c oninit :: fetchrow 
0x1001db9e0 oninit :: exfetch 
0x10068f8b4 oninit :: sql_nfetch 
0x10068f25c oninit :: sq_nfetch 
0x1007567f0 oninit :: sqmain
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* timeseries vti queries using "today" as the qualifier        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IDS-12.10.xC5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.09.2014
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
12.10.xC5 FixList
12.10.xC5.W1 FixList