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 |
|
| 12.10.xC5.W1 |
|