Select with sequence from view generates assert failure; v 10.0 and 9.4
A poster reported that selecting a sequence's NEXTVAL from a view (e.g. a 'dual'-style view over systables) crashes the server with an assertion failure/access violation in the view-folding code (walkvexpr/processview), seen on IDS 10.00.TC3TL and 9.40.TC2E1. An IBM responder identified it as known bug 174914 ("SELECTING FROM A SEQUENCE IN A VIEW CAUSES ASSERTION FAILURE"), fixed in 9.40.UC8, advising contact with tech support for the patch/upgrade. The rest of the thread argued about reporting bugs without a support contract, and the poster noted it was still listed as open for 10.00.xC4.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi everybody,
yet another bug that needs to be submitted.
create view dual (x) as
select 1 from "informix".systables x0 where (x0.tabid = 100);
create sequence seq_docid;
select seq_docid.nextval from dual
generates af file with such stack trace
Exception happened at address=0x004ed780
Exception is EXCEPTION_ACCESS_VIOLATION (code 0xc0000005)
Attempt to read location 0x64
Register Contents:
EAX=0x00000064 ESI=0x01c30048 EFLAGS=0x00010202
EBX=0x2dfcfb28 EDI=0x00020000 EIP=0x004ed780
ECX=0x2dfccb18 ESP=0x2df3e22c
EDX=0x00000064 EBP=0x2df3e274
Call Stack for thread #44 - sqlexec
0x004ed780 (oninit)_walkvexpr (0x2dfccb18, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e274
0x004edfd6 (oninit)_walkvexpr (0x2dfcc83c, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e2dc
0x004ee01f (oninit)_walkvexpr (0x2dfceb38, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e344
0x004edfd6 (oninit)_walkvexpr (0x2dfcfeac, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e3ac
0x004ee01f (oninit)_walkvexpr (0x2dfceccc, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e414
0x004ecc48 (oninit)_walkvcb (0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28, 0x0)
ebp=0x2df3e480
0x004eae6e (oninit)_process_view_colltbl_expr (0x2dfcfb28, 0x2dfe5078,
0x2dfcfce8, 0x2df3e550) ebp=0x2df3e4f4
0x004ec4a5 (oninit)_processview (0x2dfcfb28, 0x2, 0x2df3e550,
0x2dfcfce8) ebp=0x2df3e530
0x00722b6e (oninit)_foldviews (0x2dfcfb28, 0x20000, 0x1c30048,
0x2dfcfb28) ebp=0x2df3e56c
0x0047cd64 (oninit)_sqoptim (0x2dfcfb28, 0x0, 0x2dac02e0, 0x2da3e8ce)
ebp=0x2df3e6c4
0x004c8f43 (oninit)_bldstructs (0x2dfcfb28, 0x2df3e6f8, 0x0, 0x2)
ebp=0x2df3e6e4
0x004c8d7c (oninit)_sqcmd (0x0, 0x0, 0x0, 0x0) ebp=0x2df3e708
0x004c86d2 (oninit)_sq_cmnd (0x2, 0x2df3e7e0, 0x4a2d74, 0x2da68158)
ebp=0x2df3e728
0x004c8745 (oninit)_sq_prepare (0x2da68158, 0x0, 0x2, 0x74636f73)
ebp=0x2df3e734
0x004a2d74 (oninit)_sqmain (0x2d7fbad2, 0x0, 0x1c30048, 0x0)
ebp=0x2df3e7e0
0x00ae93e7 (oninit)_listen_verify (0x0, 0x2d9fdec0, 0x0, 0x61676576)
ebp=0x2df3ea54
0x00ae8936 (oninit)_spawn_thread (0x0, 0x0, 0x0, 0x0) ebp=0x2df3efbc
0x00acd914 (oninit)_startup (0xf, 0x2df40518, 0x2dd55fc0, 0x1518)
ebp=0x2df3eff8
Frame Pointer is NULL!
Unable to continue stack trace back
14:45:06
14:45:06 IBM Informix Dynamic Server Version 10.00.TC3TL Software
Serial Number
Tested on versions 10.0 and 9.4TC2E1
smitin@gmail.com said:
> Hi everybody,
>
> yet another bug that needs to be submitted.
Well? Why are you telling US? Why don't you submit it?
> create view dual (x) as
> select 1 from "informix".systables x0 where (x0.tabid = 100);>
> create sequence seq_docid;>
> select seq_docid.nextval from dual>
> generates af file with such stack trace
>
> Exception happened at address=0x004ed780
> Exception is EXCEPTION_ACCESS_VIOLATION (code 0xc0000005)
> Attempt to read location 0x64
> Register Contents:
> EAX=0x00000064 ESI=0x01c30048 EFLAGS=0x00010202
> EBX=0x2dfcfb28 EDI=0x00020000 EIP=0x004ed780
> ECX=0x2dfccb18 ESP=0x2df3e22c
> EDX=0x00000064 EBP=0x2df3e274
> Call Stack for thread #44 - sqlexec
> 0x004ed780 (oninit)_walkvexpr (0x2dfccb18, 0x2dfcfce8, 0x2df3e4e4,
> 0x2dfcfb28) ebp=0x2df3e274
> 0x004edfd6 (oninit)_walkvexpr (0x2dfcc83c, 0x2dfcfce8, 0x2df3e4e4,
> 0x2dfcfb28) ebp=0x2df3e2dc
> 0x004ee01f (oninit)_walkvexpr (0x2dfceb38, 0x2dfcfce8, 0x2df3e4e4,
> 0x2dfcfb28) ebp=0x2df3e344
> 0x004edfd6 (oninit)_walkvexpr (0x2dfcfeac, 0x2dfcfce8, 0x2df3e4e4,
> 0x2dfcfb28) ebp=0x2df3e3ac
> 0x004ee01f (oninit)_walkvexpr (0x2dfceccc, 0x2dfcfce8, 0x2df3e4e4,
> 0x2dfcfb28) ebp=0x2df3e414
> 0x004ecc48 (oninit)_walkvcb (0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28, 0x0)
> ebp=0x2df3e480
> 0x004eae6e (oninit)_process_view_colltbl_expr (0x2dfcfb28, 0x2dfe5078,
> 0x2dfcfce8, 0x2df3e550) ebp=0x2df3e4f4
> 0x004ec4a5 (oninit)_processview (0x2dfcfb28, 0x2, 0x2df3e550,
> 0x2dfcfce8) ebp=0x2df3e530
> 0x00722b6e (oninit)_foldviews (0x2dfcfb28, 0x20000, 0x1c30048,
> 0x2dfcfb28) ebp=0x2df3e56c
> 0x0047cd64 (oninit)_sqoptim (0x2dfcfb28, 0x0, 0x2dac02e0, 0x2da3e8ce)
> ebp=0x2df3e6c4
> 0x004c8f43 (oninit)_bldstructs (0x2dfcfb28, 0x2df3e6f8, 0x0, 0x2)
> ebp=0x2df3e6e4
> 0x004c8d7c (oninit)_sqcmd (0x0, 0x0, 0x0, 0x0) ebp=0x2df3e708
> 0x004c86d2 (oninit)_sq_cmnd (0x2, 0x2df3e7e0, 0x4a2d74, 0x2da68158)
> ebp=0x2df3e728
> 0x004c8745 (oninit)_sq_prepare (0x2da68158, 0x0, 0x2, 0x74636f73)
> ebp=0x2df3e734
> 0x004a2d74 (oninit)_sqmain (0x2d7fbad2, 0x0, 0x1c30048, 0x0)
> ebp=0x2df3e7e0
> 0x00ae93e7 (oninit)_listen_verify (0x0, 0x2d9fdec0, 0x0, 0x61676576)
> ebp=0x2df3ea54
> 0x00ae8936 (oninit)_spawn_thread (0x0, 0x0, 0x0, 0x0) ebp=0x2df3efbc
> 0x00acd914 (oninit)_startup (0xf, 0x2df40518, 0x2dd55fc0, 0x1518)
> ebp=0x2df3eff8
> Frame Pointer is NULL!
> Unable to continue stack trace back
> 14:45:06
> 14:45:06 IBM Informix Dynamic Server Version 10.00.TC3TL Software
> Serial Number
>
>
> Tested on versions 10.0 and 9.4TC2E1
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
--
Bye now,
Obnoxio
Information within this post contains forward looking statements within
the meaning of Section 27A of the Securities Act of 1933 and Section 21B
of the S E C Act of 1934. Statements that involve discussions with respect
to projections of future events are not statements of historical fact and
may be forward looking statements. Don't rely on them to make a decision.
The poster is not a reporting company registered under the Exchange Act of
1934.
I have received a life peerage from Her Majesty, who is not an officer,
minister or affiliate Labour party member.
I intend to recover my loan now, which could cause the parliamentary
majority to go down, resulting in losses for you. Today's Labour party
has: an accumulated deficit and a reliance on loans from officers and
affiliates to pay expenses. It is not an operating political party. The
party is going to need financing to continue as a going concern. A failure
to finance could cause the party to go out of business. This report shall
not be construed as any kind of investment advice or solicitation. You can
lose all your money by investing in this party.
Hi,
You are hitting a known problem, bug number 174914.
174914 - SELECTING FROM A SEQUENCE IN A VIEW CAUSES ASSERTION FAILURE
This is fixed in 9.40.UC8. Contact tech-support to upgrade/get a patch.
Thanks,
Nita.
"smitin@gmail.com" <smitin@gmail.com>
Sent by: informix-list-bounces@iiug.org
03/23/2006 01:25 PM
To
informix-list@iiug.org
cc
Subject
Select with sequence from view generates assert failure; v 10.0 and
9.4
Hi everybody,
yet another bug that needs to be submitted.
create view dual (x) as
select 1 from "informix".systables x0 where (x0.tabid = 100);
create sequence seq_docid;
select seq_docid.nextval from dual
generates af file with such stack trace
Exception happened at address=0x004ed780
Exception is EXCEPTION_ACCESS_VIOLATION (code 0xc0000005)
Attempt to read location 0x64
Register Contents:
EAX=0x00000064 ESI=0x01c30048 EFLAGS=0x00010202
EBX=0x2dfcfb28 EDI=0x00020000 EIP=0x004ed780
ECX=0x2dfccb18 ESP=0x2df3e22c
EDX=0x00000064 EBP=0x2df3e274
Call Stack for thread #44 - sqlexec
0x004ed780 (oninit)_walkvexpr (0x2dfccb18, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e274
0x004edfd6 (oninit)_walkvexpr (0x2dfcc83c, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e2dc
0x004ee01f (oninit)_walkvexpr (0x2dfceb38, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e344
0x004edfd6 (oninit)_walkvexpr (0x2dfcfeac, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e3ac
0x004ee01f (oninit)_walkvexpr (0x2dfceccc, 0x2dfcfce8, 0x2df3e4e4,
0x2dfcfb28) ebp=0x2df3e414
0x004ecc48 (oninit)_walkvcb (0x2dfcfce8, 0x2df3e4e4, 0x2dfcfb28, 0x0)
ebp=0x2df3e480
0x004eae6e (oninit)_process_view_colltbl_expr (0x2dfcfb28, 0x2dfe5078,
0x2dfcfce8, 0x2df3e550) ebp=0x2df3e4f4
0x004ec4a5 (oninit)_processview (0x2dfcfb28, 0x2, 0x2df3e550,
0x2dfcfce8) ebp=0x2df3e530
0x00722b6e (oninit)_foldviews (0x2dfcfb28, 0x20000, 0x1c30048,
0x2dfcfb28) ebp=0x2df3e56c
0x0047cd64 (oninit)_sqoptim (0x2dfcfb28, 0x0, 0x2dac02e0, 0x2da3e8ce)
ebp=0x2df3e6c4
0x004c8f43 (oninit)_bldstructs (0x2dfcfb28, 0x2df3e6f8, 0x0, 0x2)
ebp=0x2df3e6e4
0x004c8d7c (oninit)_sqcmd (0x0, 0x0, 0x0, 0x0) ebp=0x2df3e708
0x004c86d2 (oninit)_sq_cmnd (0x2, 0x2df3e7e0, 0x4a2d74, 0x2da68158)
ebp=0x2df3e728
0x004c8745 (oninit)_sq_prepare (0x2da68158, 0x0, 0x2, 0x74636f73)
ebp=0x2df3e734
0x004a2d74 (oninit)_sqmain (0x2d7fbad2, 0x0, 0x1c30048, 0x0)
ebp=0x2df3e7e0
0x00ae93e7 (oninit)_listen_verify (0x0, 0x2d9fdec0, 0x0, 0x61676576)
ebp=0x2df3ea54
0x00ae8936 (oninit)_spawn_thread (0x0, 0x0, 0x0, 0x0) ebp=0x2df3efbc
0x00acd914 (oninit)_startup (0xf, 0x2df40518, 0x2dd55fc0, 0x1518)
ebp=0x2df3eff8
Frame Pointer is NULL!
Unable to continue stack trace back
14:45:06
14:45:06 IBM Informix Dynamic Server Version 10.00.TC3TL Software
Serial Number
Tested on versions 10.0 and 9.4TC2E1
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Care to provide a link on IBM site to submit a bug for person with no support contract ?
smitin@gmail.com said: > Care to provide a link on IBM site to submit a bug for person with no > support contract ? Oh right. So you don't have a support contract? Hmmm. -- Bye now, Obnoxio Information within this post contains forward looking statements within the meaning of Section 27A of the Securities Act of 1933 and Section 21B of the S E C Act of 1934. Statements that involve discussions with respect to projections of future events are not statements of historical fact and may be forward looking statements. Don't rely on them to make a decision. The poster is not a reporting company registered under the Exchange Act of 1934. I have received a life peerage from Her Majesty, who is not an officer, minister or affiliate Labour party member. I intend to recover my loan now, which could cause the parliamentary majority to go down, resulting in losses for you. Today's Labour party has: an accumulated deficit and a reliance on loans from officers and affiliates to pay expenses. It is not an operating political party. The party is going to need financing to continue as a going concern. A failure to finance could cause the party to go out of business. This report shall not be construed as any kind of investment advice or solicitation. You can lose all your money by investing in this party.
as this problem is resolved in a neweer version of the software than the version you have it looks like its time to buy a support contract so you obtain the fix
as this problem is resolved in a newer version of the software than the version you have it looks like its time to buy a support contract so you obtain the fix
as this problem is resolved in a newer version of the software than the version you have it looks like its time to buy a support contract so you obtain the fix
as this problem is resolved in a newer version of the software than the version you have it looks like its time to buy a support contract so you obtain the fix
as this problem is resolved in a newer version of the software than the version you have it looks like its time to buy a support contract so you obtain the fix
as this problem is resolved in a newer version of the software than the version you have it looks like its time to buy a support contract so you obtain the fix
For one, it's not my problem. I just make sure stack trace is searchible by google. For two, the original guy reported it on v.10. As of 10.00.xC4 it's in the list of known bugs yet.