Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Errors occurred while cleaning dbspace

    Posted Tue December 05, 2023 10:37 AM

    Hi,

    IDS put a warning in message log when starting:

    18:13:19  Assert Warning: Errors occurred while cleaning dbspace 'dbs01
                                                                  informix                        '
    18:13:19  IBM Informix Dynamic Server Version 11.70.FC5XE
    18:13:19   Who: Session(1, informix@elids5, 0, 700001f18a7c028)
                    Thread(10, main_loop(), 700001f18a3a028, 1)
                    File: rspartn.c Line: 12320
    18:13:19   Results: Unused temp tables and/or deferred indexes may remain
    18:13:19   Action: Cleanup will be reattempted during next initialization
    18:13:19  stack trace for pid 6947492 written to /tmp/af.3f23e0f
    18:13:19   See Also: /tmp/af.3f23e0f
    18:13:19  Errors occurred while cleaning dbspace 'dbs01
                                                  informix                        '

    /tmp/af.3f23e0f:

    18:13:19  Cannot drop temp partnum 0x901833, iserrno 113
    18:13:19
    18:13:19  IBM Informix Dynamic Server Version 11.70.FC5XE Software Serial Number AAA#B000000

    18:13:19  Assert Warning: Errors occurred while cleaning dbspace 'dbs01                                                                                                                           informix                        '
    18:13:19   Who: Session(1, informix@elids5, 0, 700001f18a7c028)
                    Thread(10, main_loop(), 700001f18a3a028, 1)
                    File: rspartn.c Line: 12320
    18:13:19   Results: Unused temp tables and/or deferred indexes may remain
    18:13:19   Action: Cleanup will be reattempted during next initialization
    18:13:19  Raw hex dump of stack located in /tmp/af.3f23e0f.rawstk
    18:13:19  Stack for thread: 10 main_loop()

     base: 0x0700001f1c2a8000
      len:   69632
       pc: 0x0000000100096cec
      tos: 0x0700001f1c2b71d0
    state: running
       vp: 1

    0x0000000100096a98 (oninit)afstack
    0x000000010009603c (oninit)afhandler
    0x00000001000963ec (oninit)afwarn_interface
    0x000000010038dbcc (oninit)clean_pp
    0x000000010038ee00 (oninit)clean_dbspaces
    0x0000000100008f8c (oninit)main_loop
    0x0000000101489440 (oninit)startup


    18:13:19   See Also: /tmp/af.3f23e0f

    ---------------------------------
    Begin System Alarm Program Output
    ---------------------------------

    Assertion Failure Type: Warning
    Host Name:              elids5
    Database Server Name:   elids5
    Time of failure:        Tue Dec  5 18:13:19 2023
    AF file:                /tmp/af.3f23e0f
    Shared memory file:     None
    System Blocking:        OFF


    -------------------------------
    End System Alarm Program Output
    -------------------------------

    18:13:19  sh /opt/informix/11.70fc5xe/etc/evidence.sh 1 0 /tmp/af.3f23e0f 1 0x700001f18a3a028 10 0x700001f1c29d560 1025 0 0 0 0
    18:13:19
    ------------------ End of assertion failure 0 -----------------

    Can it result in something bad?



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


  • 2.  RE: Errors occurred while cleaning dbspace

    Posted Wed December 06, 2023 01:37 AM

    If

    SELECT * FROM sysmaster:sysptnhdr WHERE partnum = '0x901833'::INT

    returns 0 rows, can I be sure that the possible problem has gone?



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

    Original Message


  • 3.  RE: Errors occurred while cleaning dbspace

    Posted Wed December 06, 2023 04:12 AM

    So this has occurred, as promised - did you restart once again?

    Cleanup will be reattempted during next initialization



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

    Original Message


  • 4.  RE: Errors occurred while cleaning dbspace

    Posted Wed December 06, 2023 04:17 AM

    No.



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

    Original Message


  • 5.  RE: Errors occurred while cleaning dbspace

    Posted Wed December 06, 2023 04:22 AM

    Then it seems to have been a case of some internal activity having allocated a temp partition early on, before/during temp partition cleaning (hence iserrno 113), and the partition got cleaned up automatically once that activity completed.



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

    Original Message


Related Content