Informix

 View Only
Expand all | Collapse all

Shrink after successful repack made Informix to exit

  • 1.  Shrink after successful repack made Informix to exit

    Posted Sat December 30, 2023 06:05 AM

    Informix 11.70.FC5XE

    Repack of a large table finished successfully, after that, shrink caused the server to exit abnormally.

    $MSGPATH :

    12:56:09  Repacked 153972346 rows in bluebird:informix.ord_l_curr
    12:56:09  SCHAPI table repack  bluebird:informix.ord_l_curr succeeded
    12:56:15  SCHAPI Shrink for bluebird:informix.ord_l_curr started
    12:56:15  stack trace for pid 8127188 written to /tmp/af.15e93f
    12:56:16  Recursive Exception - Server exiting
    12:56:16  Recursive Exception - Server exiting
    12:56:16  Fatal error in ADM VP at mt.c:14093
    12:56:16  Unexpected virtual processor termination, pid = 8127188, exit = 0x100

    12:56:16  PANIC: Attempting to bring system down
    12:56:16  semctl: errno = 22

    12:56:16  cannot wake idle processor

    /tmp/af.15e93f :

    12:56:15  Context ptr = 0x00000001103f1690
    12:56:16  Siginfo ptr = 0x00000001103f1940
    12:56:16  IAR        0x0000000100099dd8 gpr 0      0x0700001f0fc06028
    12:56:16  gpr 1(SP)  0x00000001103f1b88 gpr 2      0x0000000110308f48
    12:56:16  gpr 3      0x0001000000001337 gpr 4      0x070000004006c000
    12:56:16  Reg 5      0x000000000000000e Reg 6      0x0000000000000000
    12:56:16  Reg 7      0x070000392adb61c8 Reg 8      0x0000000000000000
    12:56:16  Reg 9      0xf1000a0380435800 Reg 10     0x0000000000000000
    12:56:16  Reg 11     0x09001000a0095380 Reg 12     0x0000000048000228
    12:56:16  Reg 13     0x000000011044dbe0 Reg 14     0x0000000000000000
    12:56:16  Reg 15     0x0000000000000000 Reg 16     0x0000000000000000
    12:56:16  Reg 17     0x0000000000000000 Reg 18     0xffffffffffffffaf
    12:56:16  Reg 19     0x0000000000000000 Reg 20     0x0000000000000000
    12:56:16  Reg 21     0x0000000000000001 Reg 22     0x0000000110316298
    12:56:16  Reg 23     0x00000001103f2138 Reg 24     0x00000001103a767c
    12:56:16  Reg 25     0x0000000110316220 Reg 26     0x000000000000000e
    12:56:16  Reg 27     0x0700001f0fc26450 Reg 28     0x070000339e0719a8
    12:56:16  Reg 29     0x00000001014f5dbc Reg 30     0x0000000000000000
    12:56:16  Reg 31     0x070000339e0719a8
    12:56:16  Raw hex dump of stack located in /tmp/af.15e93f.rawstk
    12:56:16  Stack for thread: 0 idle

     base: 0x00000001103ea128
      len:   32768
       pc: 0x0000000100096cec
      tos: 0x00000001103f0fd0
    state: running
       vp: 21

    0x0000000100096a98 (oninit)afstack
    0x0000000100503fdc (oninit)mt_ex_throw_sig@AF11_4
    0x0000000100073fb8 (oninit)afsig_handler
    0x0000000100099dd8 (oninit)search_evar
    0x0000000110316298 (*nosymtab*)0x110316298
    0x000000010009be80 (oninit)idx_ggetenv_ses@AF40_18
    0x00000001000794fc (oninit)mt_memsync_scan
    0x0000000100078ee4 (oninit)yield_processor_mvp
    0x0000000100075754 (oninit)idle_processor
    0x0000000101489440 (oninit)startup

    Is it a known bug in 11.70?

    Is it safe to retry shrink?



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------


  • 2.  RE: Shrink after successful repack made Informix to exit

    IBM Champion
    Posted Thu January 04, 2024 05:17 AM

    The crash stack doesn't look 'shrink' specific at all (it's not even a session thread that's crashing), so any relation to shrink so far would only be coincidental.

    Shrinking a partition as such should be a fairly simple operation, with little potential to corrupt any memory, so yes, I'd try it again, maybe at some quiet time of day.



    ------------------------------
    Andreas Legner
    ------------------------------