Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Informix IDS 9.21.FC4 crashes with onarchive

Jens Ebert
Frequent Advisor

Informix IDS 9.21.FC4 crashes with onarchive

We upgraded to IDS 9.21.FC4 on our HP-UX 11.0 system and have various problems with onarchive. Onarchive crashes the database system. Here are some of the errors. If you have any comments on this, please let me know.

ARC-E-01846, Error received from Informix server while processing archive or backup.
IFMX-E-API, ISAM error: cannot allocate memory.
Archive request 00000044 failed.

ARC-E-01731, Error while trying to free some logical disk space.
ARC-E-01202, Communication to cataloger not open.

08:46:48 Assert Failed: No Exception Handler
08:46:48 Informix Dynamic Server 2000 Version 9.21.FC4
08:46:48 Who: Session(129, informix@server3, 19984, 268785320)
Thread(166, ontape, c00000001002c028, 3)
File: mtex.c Line: 405
08:46:48 Results: Exception Caught. Type: MT_EX_OS, Context: mem
08:46:48 Action: Please notify Informix Technical Support.
08:46:48 stack trace for pid 7277 written to
/home/Server_SW/IDS921FC4/af.48ee257
08:46:48 See Also: /home/Server_SW/IDS921FC4/af.48ee257,
shmem.48ee257.0
08:47:20 mtex.c, line 405, thread 166, proc id 7277, No Exception
Handler.
08:47:20 Fatal error in ADM VP at mt.c:11462
08:47:20 Unexpected virtual processor termination, pid = 7277, exit =
0x100

08:47:20 PANIC: Attempting to bring system down
09:08:56 Informix Dynamic Server 2000 Started.
09:08:58 Segment locked: addr=0x2d5000, size=263593984

7 REPLIES
Animesh Chakraborty
Honored Contributor

Re: Informix IDS 9.21.FC4 crashes with onarchive

Hi,
Is it crashing at the beginning of the backup or on the midway ?

Regards
Animesh
Did you take a backup?
Animesh Chakraborty
Honored Contributor

Re: Informix IDS 9.21.FC4 crashes with onarchive

Hi,
Is it crashing at the beginning of the backup or on the midway and archiving to hardisk or tape?

Regards
Animesh
Did you take a backup?
Jens Ebert
Frequent Advisor

Re: Informix IDS 9.21.FC4 crashes with onarchive

onarchive requests a tape and crashes right away writing it's dump file.
Informix/IBM requests to rebuild the sysmaster database. Any comment on this?

Re: Informix IDS 9.21.FC4 crashes with onarchive

Before rebuilding the sysmaster database, you should keep in mind that you may lost some other informations of your instance. If this is a Production Server then don't play with building the sysmaster database. I hope you have to rebuild the sysutil database. If you can attach the onconfig and bar_act.log file that will be helpful for me.
Thanks
Zafar
Win/Win
Animesh Chakraborty
Honored Contributor

Re: Informix IDS 9.21.FC4 crashes with onarchive

Hi,
If you rebuild the sysmaster database, need to use buildsmi script in $INFORMIX/etc directory.
When you use buildsmi, the existing sysmaster database is dropped and
then re-created; if you have information in the ON-Archive catalog tables, it will be
overwritten.
Best of luck
Animesh
Did you take a backup?
Jens Ebert
Frequent Advisor

Re: Informix IDS 9.21.FC4 crashes with onarchive

Yes, it is a production server and yes, Informix/IBM requests to rebuild the sysmaster database using the buildsmi script. Beside the tables where onarchive holds it's information (arc_xyz), what else could be lost??

What about the sysutil database? Would it make sense to rebuild this one? How can this be done?

I have attached the onconfig file.
Jens Ebert
Frequent Advisor

Re: Informix IDS 9.21.FC4 crashes with onarchive

We can close this thread, the problem was solved by re-creating the sysmaster database. We can now use onarchive and ontape without crashing the server. Thank you for checking into this.

Jens