Professional Web Applications Themes

rebuilding database through DR fails - Informix

hi there if i try to rebuild a database from scratch (dbexport schema+unload data) on the primary the secondary crashes. versions are equal and chunk setup at both sides is identical. is there a limit to how much data can be ted in a burst? any help appreciated regards hoyte primary: Linux vfs1 2.4.21 #2 Wed Aug 13 12:23:17 CEST 2003 i686 unknown IBM Informix Dynamic Server Version 9.40.UC2E1 -- On-Line -- Up 01:55:29 -- 471464 Kbytes secondary: Linux dsl 2.4.22 #10 Wed Oct 22 21:14:37 CEST 2003 i686 unknown IBM Informix Dynamic Server Version 9.40.UC2E1 -- Fast Recovery (Sec) ...

  1. #1

    Default rebuilding database through DR fails

    hi there
    if i try to rebuild a database from scratch (dbexport schema+unload data)
    on the primary the secondary crashes.
    versions are equal and chunk setup at both sides is identical.

    is there a limit to how much data can be ted in a burst?

    any help appreciated
    regards
    hoyte

    primary:
    Linux vfs1 2.4.21 #2 Wed Aug 13 12:23:17 CEST 2003 i686 unknown
    IBM Informix Dynamic Server Version 9.40.UC2E1 -- On-Line -- Up
    01:55:29 -- 471464 Kbytes

    secondary:
    Linux dsl 2.4.22 #10 Wed Oct 22 21:14:37 CEST 2003 i686 unknown
    IBM Informix Dynamic Server Version 9.40.UC2E1 -- Fast Recovery (Sec) --
    Up 00:00:31 -- 279464 Kbytes
    Blocked:CKPT


    22:57:38 Assert Failed: DR: Log Record Apply Thread Exited Abnormally.
    Internal Error.
    A restart of the database server shall be required to correct
    this problem.

    22:57:38 IBM Informix Dynamic Server Version 9.40.UC2E1
    22:57:38 Who: Session(18, informix, 0, 0x5141cb28)
    Thread(43, dr_secapply, 513ed478, 1)
    File: rshdr.c Line: 5497
    22:57:38 Results: Dynamic Server must abort
    22:57:38 Action: Reinitialize shared memory
    22:57:38 stack trace for pid 13209 written to /ids940uc2e1/dump/af.413e3c0
    22:57:39 See Also: /ids940uc2e1/dump/af.413e3c0
    SENDER IS NULL NO MAIL WILL BE SENT
    *** WARNING: IBM Informix Dynamic Server is no longer running. ***

    *** WARNING: IBM Informix Dynamic Server is no longer running. ***

    *** WARNING: IBM Informix Dynamic Server is no longer running. ***

    SENDER IS NULL NO MAIL WILL BE SENT
    22:57:47 rshdr.c, line 5497, thread 43, proc id 13209, DR: Log Record Apply
    Thread Exited Abnormally. Internal Error.
    A restart of the database server shall be required to correct
    this problem.
    ..
    22:57:47 The Master Daemon Died
    22:57:47 PANIC: Attempting to bring system down







    Hoyte Swager Guest

  2. #2

    Default Re: rebuilding database through DR fails

    Not sure. Ajay - can you respond?

    M.Pruet

    "Hoyte Swager" <h.swagerchello.nl> wrote in message
    news:VQBmb.377037$lh.97615776amsnews02.chello.com ...
    > hi there
    > if i try to rebuild a database from scratch (dbexport schema+unload data)
    > on the primary the secondary crashes.
    > versions are equal and chunk setup at both sides is identical.
    >
    > is there a limit to how much data can be ted in a burst?
    >
    > any help appreciated
    > regards
    > hoyte
    >
    > primary:
    > Linux vfs1 2.4.21 #2 Wed Aug 13 12:23:17 CEST 2003 i686 unknown
    > IBM Informix Dynamic Server Version 9.40.UC2E1 -- On-Line -- Up
    > 01:55:29 -- 471464 Kbytes
    >
    > secondary:
    > Linux dsl 2.4.22 #10 Wed Oct 22 21:14:37 CEST 2003 i686 unknown
    > IBM Informix Dynamic Server Version 9.40.UC2E1 -- Fast Recovery (Sec) --
    > Up 00:00:31 -- 279464 Kbytes
    > Blocked:CKPT
    >
    >
    > 22:57:38 Assert Failed: DR: Log Record Apply Thread Exited Abnormally.
    > Internal Error.
    > A restart of the database server shall be required to
    correct
    > this problem.
    >
    > 22:57:38 IBM Informix Dynamic Server Version 9.40.UC2E1
    > 22:57:38 Who: Session(18, informix, 0, 0x5141cb28)
    > Thread(43, dr_secapply, 513ed478, 1)
    > File: rshdr.c Line: 5497
    > 22:57:38 Results: Dynamic Server must abort
    > 22:57:38 Action: Reinitialize shared memory
    > 22:57:38 stack trace for pid 13209 written to
    /ids940uc2e1/dump/af.413e3c0
    > 22:57:39 See Also: /ids940uc2e1/dump/af.413e3c0
    > SENDER IS NULL NO MAIL WILL BE SENT
    > *** WARNING: IBM Informix Dynamic Server is no longer running. ***
    >
    > *** WARNING: IBM Informix Dynamic Server is no longer running. ***
    >
    > *** WARNING: IBM Informix Dynamic Server is no longer running. ***
    >
    > SENDER IS NULL NO MAIL WILL BE SENT
    > 22:57:47 rshdr.c, line 5497, thread 43, proc id 13209, DR: Log Record
    Apply
    > Thread Exited Abnormally. Internal Error.
    > A restart of the database server shall be required to
    correct
    > this problem.
    > .
    > 22:57:47 The Master Daemon Died
    > 22:57:47 PANIC: Attempting to bring system down
    >
    >
    >
    >
    >
    >
    >

    Madison Pruet Guest

  3. #3

    Default Re: rebuilding database through DR fails

    although my question remains, in the mean time i was able to find the reason
    for the crash. i had a long transaction aborted error on the primary that
    apparently
    is able to take down the secondary. anyway, i rebuild the server on the
    primary
    without any logging on, made an ontape -s -L 0, recovered on the secondary
    with ontape -p, did the onmode -d again and everything works like a charm.
    this is great! i now am able to hdr to an offsite location and on top of
    that
    can cluster two databaseservers in "update anywhere" mode greatly increasing
    the maintenance possibilities.
    whats the added value of xps if you can do all this with ids ? ;-)
    regards
    hoyte

    "Hoyte Swager" <h.swagerchello.nl> wrote in message
    news:VQBmb.377037$lh.97615776amsnews02.chello.com ...
    > hi there
    > if i try to rebuild a database from scratch (dbexport schema+unload data)
    > on the primary the secondary crashes.
    > versions are equal and chunk setup at both sides is identical.
    >
    > is there a limit to how much data can be ted in a burst?
    >
    > any help appreciated
    > regards
    > hoyte
    >
    > primary:
    > Linux vfs1 2.4.21 #2 Wed Aug 13 12:23:17 CEST 2003 i686 unknown
    > IBM Informix Dynamic Server Version 9.40.UC2E1 -- On-Line -- Up
    > 01:55:29 -- 471464 Kbytes
    >
    > secondary:
    > Linux dsl 2.4.22 #10 Wed Oct 22 21:14:37 CEST 2003 i686 unknown
    > IBM Informix Dynamic Server Version 9.40.UC2E1 -- Fast Recovery (Sec) --
    > Up 00:00:31 -- 279464 Kbytes
    > Blocked:CKPT
    >
    >
    > 22:57:38 Assert Failed: DR: Log Record Apply Thread Exited Abnormally.
    > Internal Error.
    > A restart of the database server shall be required to
    correct
    > this problem.
    >
    > 22:57:38 IBM Informix Dynamic Server Version 9.40.UC2E1
    > 22:57:38 Who: Session(18, informix, 0, 0x5141cb28)
    > Thread(43, dr_secapply, 513ed478, 1)
    > File: rshdr.c Line: 5497
    > 22:57:38 Results: Dynamic Server must abort
    > 22:57:38 Action: Reinitialize shared memory
    > 22:57:38 stack trace for pid 13209 written to
    /ids940uc2e1/dump/af.413e3c0
    > 22:57:39 See Also: /ids940uc2e1/dump/af.413e3c0
    > SENDER IS NULL NO MAIL WILL BE SENT
    > *** WARNING: IBM Informix Dynamic Server is no longer running. ***
    >
    > *** WARNING: IBM Informix Dynamic Server is no longer running. ***
    >
    > *** WARNING: IBM Informix Dynamic Server is no longer running. ***
    >
    > SENDER IS NULL NO MAIL WILL BE SENT
    > 22:57:47 rshdr.c, line 5497, thread 43, proc id 13209, DR: Log Record
    Apply
    > Thread Exited Abnormally. Internal Error.
    > A restart of the database server shall be required to
    correct
    > this problem.
    > .
    > 22:57:47 The Master Daemon Died
    > 22:57:47 PANIC: Attempting to bring system down
    >
    >
    >
    >
    >
    >
    >

    Hoyte Swager Guest

  4. #4

    Default Re: rebuilding database through DR fails

    Hoyte Swager wrote:
    > although my question remains, in the mean time i was able to find the reason
    > for the crash. i had a long transaction aborted error on the primary that
    > apparently
    > is able to take down the secondary. anyway, i rebuild the server on the
    > primary
    > without any logging on, made an ontape -s -L 0, recovered on the secondary
    > with ontape -p, did the onmode -d again and everything works like a charm.
    > this is great! i now am able to hdr to an offsite location and on top of
    > that

    What you did, and well, was workaround an existing problem.
    In the latest versions of IDS we've seen a constant change in the engine behaviour when the dr_secapply thread dies.
    What I personnaly would love to see was a throughout investigation on why the hell the thread dies, and specially why does it die with risk of leaving the server in an inconsistent
    and unrecoverable error.

    I've seen it happen because of "excessive" amount of I/O on the secondary.
    Not a reason that I would consider acceptable.


    Regards.

    Fernando Nunes Guest

Similar Threads

  1. Rebuilding a logo
    By catxnc webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 8
    Last Post: September 28th, 02:35 AM
  2. clamav install on Sid fails on retrieving database
    By Pim Bliek | PingWings in forum Debian
    Replies: 1
    Last Post: August 3rd, 08:20 PM
  3. Rebuilding the kernel - establishing the default settings
    By Sean in forum Linux Setup, Configuration & Administration
    Replies: 1
    Last Post: July 4th, 10:23 PM
  4. Database creation fails
    By Shravana Kumar in forum Oracle Server
    Replies: 2
    Last Post: December 12th, 07:56 AM
  5. Rebuilding indexes
    By emmet ryan in forum Oracle Server
    Replies: 1
    Last Post: December 8th, 03:02 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139