Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2011
    Posts
    5

    Unanswered: INTO TEMP clause caused the database crash

    INformix IDS 11.10.
    I ran the following script. The database just shutdown itself.
    The total records of the query should be 8000.
    Do you think is the Temprory DBSPACE problem?

    Select rid, rec_year, rec_num, rec_date,
    round(((complete_date-rec_date)*24*60+(floor(complete_time/10000)-floor(rec_time/10000))*60+(mod(floor(complete_time/100),100)-mod(floor(rec_time/100),100))+(mod(complete_time,100)-mod(rec_time,100))/60),1) rec_complete
    From rec_data
    WHERE rec_date>='06/01/2011' AND rec_date<='06/09/2011'
    INTO TEMP tmp_rec_june WITH NO LOG;

  2. #2
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    Hi,

    What is the message on online.log of that informix server?
    LS

  3. #3
    Join Date
    Aug 2011
    Posts
    5

    online log

    09:33:42 Logical Log 100623 Complete, timestamp: 0xb3ae5150.
    09:33:42 Logical Log 100623 - Backup Started
    09:33:43 Logical Log 100623 - Backup Completed
    09:33:53 stack trace for pid 11524 written to /usr2/informix_11FC2/tmp/af.7dae14c1
    09:33:53 stack trace for pid 11582 written to /usr2/informix_11FC2/tmp/af.7def14c1
    09:33:53 Assert Failed: Memory free block header corruption detected in mt_shm_malloc_segid 3
    09:33:53 IBM Informix Dynamic Server Version 11.10.FC2
    09:33:53 Who: Session(92635, user1255@rms01, 22685, 0x9da0ebf0)
    Thread(96720, sqlexec, 85f7ca48, 3)
    File: mtshpool.c Line: 3494
    09:33:53 Results: Unable to repair pool
    09:33:53 Action: Please notify IBM Informix Technical Support.
    09:33:53 stack trace for pid 11552 written to /usr2/informix_11FC2/tmp/af.7db814c1
    09:33:53 Assert Failed: Memory block header corruption detected in mt_shm_free 1
    09:33:53 IBM Informix Dynamic Server Version 11.10.FC2
    09:33:53 Who: Session(79354, user1591@rms01, 12935, 0x7a84f388)
    Thread(82202, sqlexec, 6ecbfbc8, 4)
    File: mtshpool.c Line: 3349
    09:33:53 Results: Unable to repair pool
    09:33:53 Action: Please notify IBM Informix Technical Support.
    09:33:53 stack trace for pid 11553 written to /usr2/informix_11FC2/tmp/af.450214c1
    09:33:53 Recursive Exception - Server exiting
    09:33:53 ERROR: Exception recursion in afhandler (thread 96720).
    09:33:53 Recursive Exception - Server exiting
    09:33:53 Recursive Exception - Server exiting
    09:33:53 See Also: /usr2/informix_11FC2/tmp/af.450214c1, shmem.450214c1.0, gcore.450214c1.0.11553
    09:33:53 stack trace for pid 12160 written to /usr2/informix_11FC2/tmp/af.3f314c1
    09:33:53 Fatal error in ADM VP at mt.c:13388
    09:33:53 Unexpected virtual processor termination, pid = 11552, exit = 0x100

  4. #4
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    It seams you are having some problems with space for memory with your server. Or those calculations are to much extensive and there is't enough space or your shared memory is not well configured.
    Did you try FAQS at IBM informix site for that version?
    LS

  5. #5
    Join Date
    Aug 2011
    Posts
    5
    We opened a ticket with IBM. They haven't found the real cause yet.
    Thanks.

  6. #6
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    You are welcome
    LS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •