IT43242: AF RAISED AFTER NEW FRAGMENT ADDED TO A TABLE WHILE RUNNING UPDATE STATISTICS WITH PDQ.

APAR status

• Closed as program error.

Error description

• The table in question is fragmented by expression using a date
  so that each fragment partition contains a separate month.
  
  An empty fragment is added to store the next months data.
  
  An update statistics will result in an AF ...
  
  15:56:20  Please run 'oncheck -cI db:"name".tab#idx'
  Btree Record Cursor (btcs_t):
  07000200012540f0: 494e4658 00000000 07000300 000722d0   INFX....
  ......".
  0700020001254100: 000002c9 00556be7 00003712 00000002   .....Uk.
  ..7.....
  ...
  Index Node:
  070003000022f000: 000038d5 0002536d 004b0090 0e2800a8   ..8...Sm
  .K...(..
  070003000022f010: 000000af 00000186 31323439 2d323032   ........
  1249-202
  ...
  
  15:56:20  Assert Failed: Code assertion at rsbtcs.c:349
  15:56:20   Who: Session(88, informix@ifx1, 37552400,
  700020000521da8)
                  Thread(390, updstat 2, 7000200004e7188, 1)
                  File: rsdebug.c Line: 3604
  15:56:20   Results: rowoff (700030000cce044) + BT_RIDL_FLAG_SIZE
  (1) + sizeof(int4) (4) > cs->bc_slotptr (700030000cce018) +
  cs->bc_slotlen (48)
  
  0x00000001000d5564 (oninit)afstack
  0x00000001000d42e0 (oninit)afhandler
  0x00000001000d4798 (oninit)affail_interface
  0x00000001001b6098 (oninit)rsam_assert
  0x000000010110fa2c (oninit)ridl_ld_elem
  0x0000000101111320 (oninit)ridl_ridlist
  0x00000001011ec798 (oninit)btree_stats
  0x00000001011ee8dc (oninit)rsidxinfo
  0x00000001011ef978 (oninit)rs_index_info
  0x00000001017e2920 (oninit)startup
  
  tid      name     rstcb            flags    curstk   status
  383      sqlexec  7000200004e7a68  ---P---  20768    join wait
  388       -
  388      updstat  7000200004e5fc8  ----R--  13040    running-
  389      updstat  7000200004e68a8  ----R--  13040    running-
  390      updstat  7000200004e7188  ----R--  13040    running-
  
  scb              sqscb            optofc   pdqpriority
  optcompind  directives
  700020000dd10c0  700020000f26028  0        10          0
  1
  
  Sess       SQL            Current            Iso Lock       SQL
  ISAM F.E.
  Id         Stmt type      Database           Lvl Mode       ERR
  ERR  Vers  Explain
  88         UPDATE STATIST db                CR  Not Wait   0
  0    9.24  Off
  
  Current SQL statement (3) :
    update statistics low for table tab drop distributions force
  
  An oncheck -cDI reports that the index is bad and needs to
  dropped and recreated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 14.10.xC11.                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 14.10.xC11.                       *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC11.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels