Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    15

    Unanswered: Assert Failed Problem -- How to do ?

    Hi,

    Can anyone help me with this error: (take it from online.log)

    15:42:36 Assert Failed: next_possible_data_page:bad bitmap page
    15:42:36 Informix Dynamic Server Version 7.31.UC5
    15:42:36 Who: Session(51375, hnmadm@impsathnm, 21365, 172743256)
    Thread(51409, sqlexec, a49a288, 1)
    File: rsbuff.c Line: 2203
    15:42:36 Results: affirm:"hnmadm".arg_nrt_calm_2
    15:42:36 Action: Run 'oncheck -cD 2097250'
    15:42:46 See Also: /tmp/af.ccb994ac, shmem.ccb994ac.0
    15:42:46 Process exited with return code 1: /bin/sh /bin/sh -c /opt/informix/log_full.sh 3 1
    "Table failure: 'next_possible_data_page:bad bitmap page'." "next_possib

    some guys tell me that it is necesary to re-initialize all the Database.

    I'll really appreciated any comments.

    Thanks in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Marshall, MN
    Posts
    2

    Re: Assert Failed Problem -- How to do ?

    Have you run a oncheck -cD 2097250 yet? If you can figure out which database and table, you should try running the following.

    oncheck -cDI <name of database> "informix":<name of table>

    I had a lot of problems with bad data pages and/or indexes. This command will allow you figure out if it is an index problem or a data page problem. If it is an index problem, it's easy to fix. Drop and recreate the index. However, if it is a data page problem, you may have restore to another location, unload the table giving you the problems and then load a good table into production.

    I hope I didn't confuse you more.

    Good Luck!

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    15

    Talking

    Thnaks a lot, You have got the point. There was a problem with the indexes..

    I just solve the problem,

    Thnaks

Posting Permissions

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