If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > onbar problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-08-04, 10:03
lgaxiola lgaxiola is offline
Registered User
 
Join Date: Aug 2004
Posts: 99
onbar problem

Hi everyone,

Last night the backup process for our production server failed with the next error:

03:10:10 mt_aio_wait(1fc619dc)
03:10:10 chunkio(10, 0x18000000, 0x7aea8, 1, 0x1fc0d27c, 33, 1) errno 5
AIOREQ *a
20393ca0: 00000000 00000000 00000000 00000000 ........ ........
20393cb0: 00000000 00000000 941bc61f 2418c61f ........ ....$...
20393cc0: c0010000 41494f72 65710000 00000000 ....AIOr eq......
20393cd0: d1070000 00000000 03000000 01040000 ........ ........
20393ce0: 0b000000 02000000 01000000 00000000 ........ ........
20393cf0: 01000000 501ac61f 00000000 01000000 ....P... ........
20393d00: 05000000 01000000 00000000 00000000 ........ ........
20393d10: 00000000 ....
03:10:10
03:10:10 Informix Dynamic Server Version 7.30.UC6

03:10:10 Assert Failed: arc_very_old_page
03:10:10 Who: Session(15, informix@ncr4400a, 26980, 0)
Thread(95, arcbackup1, 0, 5)
File: rsarcbu.c Line: 2507
03:10:10 Results: Could not get page 0x87aea8

I ran oncheck -cD to verify the data pages but it came back without any error, my next step is to run oncheck -cI to verify indexes but I have to wait until tonight since this is the production server.

Meanwhile I'm trying to research to see if I can come up with a quick solution to the problem, any help will be greatly appreciated.

Thanks in advance,

Luis Torres
Reply With Quote
  #2 (permalink)  
Old 10-08-04, 10:51
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hola Luis,

Esto es un bug de la versión de Informix.
Me ha pasado lo mismo y he tenido que migrar a la versión siguiente.

Gustavo.
Reply With Quote
  #3 (permalink)  
Old 10-08-04, 11:38
lgaxiola lgaxiola is offline
Registered User
 
Join Date: Aug 2004
Posts: 99
Hola Gustavo,

Gracias por tu respuesta, he tenido muchisimos problemas con esta version de informix, empece a trabajar hace poco tiempo en esta empresa y el sistema se esta migrando a Oracle por lo que desafortunadamente no puedo migrar a otra version, tengo que mantenerlo hasta el final de anio. He estado haciendo el backup por algun tiempo y no me habia dado problemas, el fin de semana voy a hacer un bounce a Informix para ver si de casualidad eso ayuda.

Gracias nuevamente y espero que tengas un excelente fin de semana.

Luis
Reply With Quote
  #4 (permalink)  
Old 10-11-04, 15:58
lgaxiola lgaxiola is offline
Registered User
 
Join Date: Aug 2004
Posts: 99
Just a quick update for anyone interested. The problem is a documented bug for that version of informix. I found a "work around" to it, the bug only appears if the backup is run with the engine in quiescent mode, but it works perfectly ok with the engine in online mode.

Thanks

Luis Torres
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On