IC73338: ERROR 9791 AND SEGV IN NEXTRANGE() WITH INSERT ... SELECT STATEMENT ON SYNONYM

APAR status

• Closed as fixed if next.

Error description

• In a Stored procedure, when running INSERT ... SELECT statement
  like:
  
  insert into
  czk_guest(CardNO,MemberID,CardType,SheetID,Secrety,ShopID,UnitNa
  me,Buyer,Money,Detail,
  
  Indate,EndDate,SheetIDNew,Mode,VerifyFlag,IfNewCard,IFVIP)
  select
  a.CardNo,b.memberid,a.cardtype,__SheetID,a.Secrety,__ShopID,__Sh
  opID,__ShopID,0,0,
         __SDate,b.enddate,__SheetID,'1',c.VerifyFlag,1,1
         from Guest0 a,tmp_memberGuest b,cardtype c
         where a.cardno=b.cardno and a.cardtype=c.cardtype and
  c.flag=2;
  
  Where some tables are defined as synonyms in a remote database,
  we received Error -9791 and following stack:
  
  13:32:43  Assert Failed: Exception Caught. Type: MT_EX_OS,
  Context: mem
  13:32:43   Who: Session(39, informix@graal, 270714,
  700000020386120)
                  Thread(92, sqlexec, 700000020348be0, 1)
                  File: mtex.c Line: 417
  13:32:43   Action: Please notify IBM Informix Technical Support.
  13:32:44  Raw hex dump of stack located in
  /usr2/support/chunks/IDS1150FC8/af.44463eb.rawstk
  13:32:44  Stack for thread: 92 sqlexec
  
   base: 0x070000002179f000
    len:   69632
     pc: 0x00000001000b7474
    tos: 0x07000000217ac290
  state: running
     vp: 1
  
  (oninit)afstack
  (oninit)afhandler
  (oninit)mt_ex_throw_sig
  (oninit)afsig_handler
  (oninit)nextrange
  (oninit)nextrange
  (oninit)scan_open
  (oninit)join_open
  (oninit)join_open
  (oninit)insert_open
  (oninit)prepselect
  (oninit)doinsert
  (oninit)aud_doinsert
  (oninit)excommand
  (oninit)ip_evalsql
  (oninit)runproc
  (oninit)udrlm_spl_execute
  (oninit)udrlm_exec_routine
  (oninit)udr_execute
  (oninit)udr_spl_curnext
  (oninit)ip_curnext
  (oninit)ip_fetch
  (oninit)getrow
  (oninit)fetchrow
  (oninit)exfetch
  (oninit)sql_nfetch
  (oninit)sq_nfetch
  (oninit)sqmain
  (oninit)listen_verify
  (oninit)spawn_thread
  (oninit)startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This problem is seen only with remote tables defined with    *
  * ROWIDS or CDR columns and the remote IDS Versions is         *
  * 11.10.xx or higher.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Users can see -9791 and/or memory corruption when doing      *
  * INSERT into a remote table, when the remote table is defined *
  * with ROWIDS.                                                 *
  *                                                              *
  * One of the scenarios where this was seen was when running    *
  * this INSERT into remote_tab SELECT * from local_tab inside a *
  * Stored Procedure.                                            *
  * This was the stack from that scenario.                       *
  *                                                              *
  * 13:32:44  Stack for thread: 92 sqlexec                       *
  *                                                              *
  *                                                              *
  *                                                              *
  * base: 0x070000002179f000                                     *
  *                                                              *
  *   len:  69632                                                *
  *                                                              *
  *   pc: 0x00000001000b7474                                     *
  *                                                              *
  *   tos: 0x07000000217ac290                                    *
  *                                                              *
  * state: running                                               *
  *                                                              *
  *   vp: 1                                                      *
  *                                                              *
  *                                                              *
  *                                                              *
  * (oninit)afstack                                              *
  *                                                              *
  * (oninit)afhandler                                            *
  *                                                              *
  * (oninit)mt_ex_throw_sig                                      *
  *                                                              *
  * (oninit)afsig_handler                                        *
  *                                                              *
  * (oninit)nextrange                                            *
  *                                                              *
  * (oninit)nextrange                                            *
  *                                                              *
  * (oninit)scan_open                                            *
  *                                                              *
  * (oninit)join_open                                            *
  *                                                              *
  * (oninit)join_open                                            *
  *                                                              *
  * (oninit)insert_open                                          *
  *                                                              *
  * (oninit)prepselect                                           *
  *                                                              *
  * (oninit)doinsert                                             *
  *                                                              *
  * (oninit)aud_doinsert                                         *
  *                                                              *
  * (oninit)excommand                                            *
  *                                                              *
  * (oninit)ip_evalsql                                           *
  *                                                              *
  * (oninit)runproc                                              *
  *                                                              *
  * (oninit)udrlm_spl_execute                                    *
  *                                                              *
  * (oninit)udrlm_exec_routine                                   *
  *                                                              *
  * (oninit)udr_execute                                          *
  *                                                              *
  * (oninit)udr_spl_curnext                                      *
  *                                                              *
  * (oninit)ip_curnext                                           *
  *                                                              *
  * (oninit)ip_fetch                                             *
  *                                                              *
  * (oninit)getrow                                               *
  *                                                              *
  * (oninit)fetchrow                                             *
  *                                                              *
  * (oninit)exfetch                                              *
  *                                                              *
  * (oninit)sql_nfetch                                           *
  *                                                              *
  * (oninit)sq_nfetch                                            *
  *                                                              *
  * (oninit)sqmain                                               *
  *                                                              *
  * (oninit)listen_verify                                        *
  *                                                              *
  * (oninit)spawn_thread                                         *
  *                                                              *
  * (oninit)startup                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS version 11.50.xC9                             *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
  For download information, go to:
  http://www.ibm.com/support/fixcentral
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• RB15 PSY

     UP