Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53

    Unanswered: Unable to initialize v10 database

    Hi All,

    I have installed Informix v10.00.UC6 on AIX v5.3. There are two databases already running on this machine. While trying to initialize a new database i am getting errors. Here is the output of oninit -v

    aix>oninit -v
    Checking group membership to determine server run mode...succeeded
    Reading configuration file '/informix10/etc/onconfig_sst'...succeeded
    Creating /INFORMIXTMP/.infxdirs...succeeded
    Creating infos file "/informix10/etc/.infos.onlineipc_sst"...succeeded
    Linking conf file "/informix10/etc/.conf.onlineipc_sst"...succeeded
    Writing to infos file...succeeded
    Checking config parameters...succeeded
    Allocating and attaching to shared memory...succeeded
    Creating resident pool 28168 kbytes...succeeded
    Allocating 20016 kbytes for buffer pool of 4K page size...succeeded
    Initializing rhead structure...succeeded
    Initializing ASF...succeeded
    Initializing Dictionary Cache and SPL Routine Cache...succeeded
    Bringing up ADM VP...succeeded
    Creating VP classes...succeeded
    Onlining 1 additional cpu vps...succeeded
    Onlining 2 IO vps...succeeded
    Initialization of Encryption...succeeded
    Forking main_loop thread...succeeded
    Initializing DR structures...succeeded
    Forking 1 'ipcshm' listener threads...succeeded
    Forking 1 'soctcp' listener threads...succeeded
    Starting tracing...succeeded
    Initializing 16 flushers...succeeded
    oninit: Cannot open chunk '/e_sst/dblinks/ROOTDBS_SST'. errno = 1
    oninit: Fatal error in shared memory initialization

    I have created logical volumes and linked it to the file as follows

    lrwxrwxrwx 1 informix informix 13 Jul 04 10:45 DB0_SST -> /dev/rdb0_sst
    lrwxrwxrwx 1 informix informix 13 Jul 04 10:45 DB1_SST -> /dev/rdb1_sst
    lrwxrwxrwx 1 informix informix 13 Jul 04 10:45 DB2_SST -> /dev/rdb2_sst
    lrwxrwxrwx 1 informix informix 13 Jul 04 10:45 DB3_SST -> /dev/rdb3_sst
    lrwxrwxrwx 1 informix informix 13 Jul 04 10:45 DB4_SST -> /dev/rdb4_sst
    lrwxrwxrwx 1 informix informix 13 Jul 04 10:45 DB5_SST -> /dev/rdb5_sst
    lrwxrwxrwx 1 informix informix 13 Jul 04 10:45 DB6_SST -> /dev/rdb6_sst
    lrwxrwxrwx 1 informix informix 16 Jul 04 10:46 PHYLOG_SST -> /dev/rphylog_sst
    lrwxrwxrwx 1 root informix 17 Jul 04 12:37 ROOTDBS_SST -> /dev/rrootdbs_sst
    lrwxrwxrwx 1 informix informix 17 Jul 04 10:46 TEMPDB1_SST -> /dev/rtempdb1_sst
    lrwxrwxrwx 1 informix informix 17 Jul 04 10:46 TEMPDB2_SST -> /dev/rtempdb2_sst

    Am i missing on anything? I am not able to figure out on why this database isnt initializing.

    Appreciate your response.

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    Copy here the last log messages (onstat -m)... will be useful...

    check the SERVERNUM on ONCONFIG...
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53
    I have checked the SERVERNUM and its unique. Here's the copy of onstat -m

    shared memory not initialized for INFORMIXSERVER 'onlineipc_sst'

    Message Log File: /informix10/online_sst.log
    10:33:34 DR: DRAUTO is 0 (Off)
    10:33:34 AIX MP latch code enabled
    10:33:34 Requested shared memory segment size rounded from 2072KB to 2080KB
    10:33:34 IBM Informix Dynamic Server Version 10.00.UC6 Software Serial Numb
    er AAA#B000000
    10:33:35 Assert Warning: chunk failed sanity check

    10:33:35 IBM Informix Dynamic Server Version 10.00.UC6
    10:33:35 Who: Session(1, informix@ddaix, 0, 50232018)
    Thread(7, main_loop(), 50209018, 1)
    File: rspartn.c Line: 8686
    10:33:35 Results: Chunk 1 is being taken OFFLINE.
    10:33:35 Action: Restore chunk from archive.
    10:33:35 stack trace for pid 17662 written to /informix10/tmp/af.3ef203f
    10:33:35 See Also: /informix10/tmp/af.3ef203f
    10:33:36 chunk failed sanity check

    10:33:36 I/O error, Primary Chunk '/exe_sst/dblinks/ROOTDBS_SST' -- Offline (sa
    nity)
    10:33:36 IBM Informix Dynamic Server Stopped.

    10:33:36 mt_shm_remove: WARNING: may not have removed all/correct segments

    Contents of /informix10/tmp/af.3ef203f

    10:33:35 sane_chopeng_addr 0:0 != expected 1:2
    page
    page
    508b9800: 00000000 00000000 00000000 00000000 ........ ........
    508b9810 *
    10:33:35
    10:33:35 IBM Informix Dynamic Server Version 10.00.UC6 Software Serial Numb
    er AAA#B000000

    10:33:35 Assert Warning: chunk failed sanity check

    10:33:35 Who: Session(1, informix@ddaix, 0, 50232018)
    Thread(7, main_loop(), 50209018, 1)
    File: rspartn.c Line: 8686
    10:33:35 Results: Chunk 1 is being taken OFFLINE.
    10:33:35 Action: Restore chunk from archive.
    10:33:35 Stack for thread: 7 main_loop()

    base: 0x50847000
    len: 69632
    pc: 0x1006e820
    tos: 0x50856a68
    state: running

    vp: 1

    0x1006e9b4 (oninit)afstack (0x20006a70, 0x44fe, 0x50856ba4, 0xf0b2, 0x0, 0x60054
    015, 0x600684da, 0x0)
    0x100701dc (oninit)afhandler(0x1, 0x50858fe0, 0x20297000, 0x508f3b78, 0x401, 0x1
    , 0x2013e708, 0x21ee)
    0x1010a1e0 (oninit)sane_chopen(0x1, 0x20215b20, 0x50a9e018, 0x20214ad8, 0x50a9ea
    98, 0x20215b24, 0xa, 0x200076b0)
    0x101197ec (oninit)chopen_util(0xa, 0xf01c4bc8, 0x508573e8, 0x82000822, 0xd023d4
    04, 0x4007f2cc, 0x1, 0x4007e7d4)
    0x1001a358 (oninit)initpzero(0x2005fc14, 0x0, 0x1, 0x50a8416c, 0x0, 0x60050014,
    0x0, 0x0)
    0x1001656c (oninit)initseg (0x508576d8, 0x2005e7c8, 0x200613d0, 0x2000ab80, 0x0,
    0x10010779, 0x10010779, 0x0)
    0x10008650 (oninit)main_loop(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
    0x10a8eec8 (oninit)startup (0x3e, 0x50858990, 0x5067dfd0, 0x990, 0xa0ed72f1, 0x0
    , 0x65, 0x5083ece8)
    0x00000000


    10:33:35 See Also: /informix10/tmp/af.3ef203f

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

    Assertion Failure Type: Warning
    Host Name: ddaix
    Database Server Name: onlineipc_sst
    Time of failure: Thu Jul 5 10:33:36 NZST 2007
    AF file: /informix10/tmp/af.3ef203f
    Shared memory file: None
    System Blocking: OFF


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

    10:33:36 sh /informix10/etc/evidence.sh 1 0 /informix10/tmp/af.3ef203f 1 0x5020
    9018 7 0x5083eba0 1025 0 0 0 0
    10:33:36
    ------------------ End of assertion failure 0 -----------------

  4. #4
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53
    Its very interesting here.

    In order to verify if there was any issue with the disk or OS, i installed Informix v9.34UCX1 and initialized this database using this version of informix. Surprisingly, i was able to initialize without any problems.

    So, i shutdown the informix datase, changed the $INFORMIXDIR to v10, changed the onconfig file to that of v10 and start the database. Everything went fine with the conversion and now i have a new database on v10.

    I wonder why v10 was complaining about sanity of the chunk.

  5. #5
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    realy... this is very weird...

    if you can, send this to IBM Support... sounds like a bug...


    sorry my bad english..
    Last edited by ceinma; 07-05-07 at 09:24.
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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