informix down
A user reported an Informix secondary (backup/HDR-type) node going down with an "I/O chunk is inconsistent chunk 9, pagenum 345244" error on a chunk belonging to the logical log dbspace. One responder asked for version, machine architecture, and the tail of online.log from both the failed and primary nodes, but these were never supplied. Art Kagel advised that with an inconsistent chunk the best course is to rebuild/restore the secondary instance from the primary, and stressed finding the underlying cause of the corruption; the poster agreed the root cause had been passed to the system/storage admins. No confirmed outcome is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi informix is down on a backup node (clr), the logs mention a I/O error I/O chunk is inconsistent chunk 9, pagenum 345244, pagecnt 1 the chunk number 9 is member of the log dbspace can you help ?
Hello. Please provide further information: 1) Informix version and machine arch 2) Last online.log messages of the down node. 3) Last online.log messages of the primary node, in the time of secondary crash. Regards, Alexandre Marini ________________________________________ De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de SMITH JOHN <daylight@webmails.com> Enviado: segunda-feira, 4 de abril de 2016 13:00 Para: ids@iiug.org Assunto: informix down [36893] Hi informix is down on a backup node (clr), the logs mention a I/O error I/O chunk is inconsistent chunk 9, pagenum 345244, pagecnt 1 the chunk number 9 is member of the log dbspace can you help ? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
With an inconsistent chunk, the best solution is to restore the backup instance from the primary. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Apr 4, 2016 at 12:00 PM, SMITH JOHN <daylight@webmails.com> wrote: > Hi > > informix is down on a backup node (clr), the logs mention a I/O error > > I/O chunk is inconsistent chunk 9, pagenum 345244, pagecnt 1 > > the chunk number 9 is member of the log dbspace > > can you help ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113eb9b27a19b7052faaee8a
Oh, forgot to mention: It would be prudent to try to determine what damaged the inconsistent chunk in the first place! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Apr 4, 2016 at 12:07 PM, Art Kagel <art.kagel@gmail.com> wrote: > With an inconsistent chunk, the best solution is to restore the backup > instance from the primary. > > Art > > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > > On Mon, Apr 4, 2016 at 12:00 PM, SMITH JOHN <daylight@webmails.com> wrote: > >> Hi >> >> informix is down on a backup node (clr), the logs mention a I/O error >> >> I/O chunk is inconsistent chunk 9, pagenum 345244, pagecnt 1 >> >> the chunk number 9 is member of the log dbspace >> >> can you help ? >> >> >> >> ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --047d7bdc08a6f3c8a5052faaf070
absolutely Art, that is what i said to system/storage admin, the original matter has to be figured out