Informix - Problem description
Problem IT04185 | Status: Closed |
GETTING AF ON SELECT FROM VTI EXPRESSION TABLE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * timeseries vti queries using "today" as the qualifier * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.09.2014 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |