IDS Forum

Re: Issue about logical restore

Posted By: JACQUES RENAUT
Date: Wednesday, 27 February 2013, at 11:55 a.m.

In Response To: Issue about logical restore (Francesco Alfano)

Original post:

Hi,
I need help on an issue which occur during logical restore on Informix
Dynamic Server Version 9.30.UC2
can someone help me?

When I run a logical restore, I get an the error message such as the
one reported at the end of email.
How can I limit the number of virtual shared memory segment used during
logical restore ?

Dynamically allocated new virtual shared memory segment (size 10132KB)
15:00:37 Dynamically allocated new virtual shared memory segment (size
10132KB)
15:00:37 Dynamically allocated new virtual shared memory segment (size
10132KB)
15:00:37 Size of resident + virtual segments 165320KB + 2751156KB >
2910000KB
15:00:37 total allowed by configuration parameter SHMTOTAL
15:00:37 out of virtual shared memory

15:00:37 Assert Failed: ISAM error: An error has occurred during
logical restore.

15:00:37 Informix Dynamic Server Version 9.30.UC2
15:00:37 Who: Session(18, root@server4, 0, 348602480)

Thread(30, logrecover, 14c47c18, 1)

File: rsarcutl.c Line: 127
15:00:37 Action: dologrecvr()/add_Qbuf
15:00:37 stack trace for pid 20705 written to /tmp/af.406e285
15:00:37 See Also: /tmp/af.406e285
15:00:37 ISAM error: An error has occurred during logical restore.

Thanks in advance, Francesco.

<stuff removed>

Response:

This looks to be a defect. It appears to have something to do with recovery and running out of memory, which your server appears to be having memory issues based on the MSGPATH output you've included (the "out of virtual shared memory messages" prior to the rest of the failure). You could try increasing SHMTOTAL to allow more memory, or possibly reduce the memory requirements for the secondary...like by decreasing the number of recovery threads (OFF_RECVRY_THREADS), or what do you have LOGBUFF set to? That's another parameter that impacts the amount of memory required for the restore and HDR to function. Obviously to change LOGBUFF you would have to also change it on the primary as that needs to match between the 2 servers.

So you should be able to work around the issue if you can avoid the out of memory failures while HDR is starting up and trying to sync.

Jacques Renaut
IBM Informix Advanced Support

Messages In This Thread

• Issue about logical restore
  Francesco Alfano -- Wednesday, 27 February 2013, at 9:20 a.m.
  • Re: Issue about logical restore
    Art Kagel -- Wednesday, 27 February 2013, at 9:41 a.m.
    • Re: Issue about logical restore
      Francesco Alfano -- Wednesday, 27 February 2013, at 9:56 a.m.
      • Re: Issue about logical restore
        Art Kagel -- Wednesday, 27 February 2013, at 10:17 a.m.
        • Re: Issue about logical restore
          Francesco Alfano -- Wednesday, 27 February 2013, at 10:25 a.m.
          • Re: Issue about logical restore
            Keith Simmons -- Wednesday, 27 February 2013, at 10:43 a.m.
            • Re: Issue about logical restore
              Francesco Alfano -- Wednesday, 27 February 2013, at 10:58 a.m.
          • Re: Issue about logical restore
            Art Kagel -- Wednesday, 27 February 2013, at 11:13 a.m.
        • Re: Issue about logical restore
          Francesco Alfano -- Friday, 1 March 2013, at 9:35 a.m.
          • Re: Issue about logical restore
            Art Kagel -- Friday, 1 March 2013, at 10:29 a.m.
  • Re: Issue about logical restore
    JACQUES RENAUT -- Wednesday, 27 February 2013, at 11:55 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.