re-initialization of shared memory fails

I've been testing a third party backup/restore software (Netbackup) on a test database on IDS 7.31 on Sparc, Sol 2.7. Everytime I try to restore the small test database I seem to have corrupted the root chunk, as I am unable to do an oninit -s. This is from my online.log file: 14:22:27 Informix Dynamic Server Initialized -- Shared Memory Initialized. 14:22:27 Physical Recovery Started. 14:22:27 Physical Recovery Complete: 0 Pages Restored. 14:22:27 Logical Recovery Started. 14:22:30 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 14:22:31 Informix Dynamic Server Stopped. 14:22:31 mt_shm_remove: WARNING: may not have removed all/correct segments I did an ipcs and there were no shared memory segments hanging there that belongs to Informix. Any thoughts on how to solvis this without doing an oninit -i? Thanks! Rebecca Sent via Deja.com http://www.deja.com/ Before you buy.

<rhoag@ihs.com> wrote in message news:8cb3lm$17$1@nnrp1.deja.com... > I've been testing a third party backup/restore software (Netbackup) on a > test database on IDS 7.31 on Sparc, Sol 2.7. Everytime I try to restore > the small test database I seem to have corrupted the root chunk, as I am > unable to do an oninit -s. This is from my online.log file: > 14:22:27 Informix Dynamic Server Initialized -- Shared Memory > Initialized. > 14:22:27 Physical Recovery Started. > 14:22:27 Physical Recovery Complete: 0 Pages Restored. > 14:22:27 Logical Recovery Started. > 14:22:30 Logical Recovery Complete. > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > 14:22:31 Informix Dynamic Server Stopped. > 14:22:31 mt_shm_remove: WARNING: may not have removed all/correct > segments Please, post full log with restore activities. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > I did an ipcs and there were no shared memory segments hanging there > that belongs to Informix. Any thoughts on how to solvis this without > doing an oninit -i? > Thanks! > Rebecca > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

I've seen this type of problem when there were Informix instances claiming more memory than was available on the machine - they all got tied up in a knot and the engine either didn't come back up or, when it did, it went into an immediate panic and shutdown. Only other time was memory fragments left over, can you bounce the whe whole machine? Glyn In article <8ccjpf$1oh$1@hyppo.gu.net>, "Yuri Dovgart" <y_dovgart@tci.ukrtel.net> wrote: > <rhoag@ihs.com> wrote in message news:8cb3lm$17$1@nnrp1.deja.com... > > I've been testing a third party backup/restore software (Netbackup) on a > > test database on IDS 7.31 on Sparc, Sol 2.7. Everytime I try to restore > > the small test database I seem to have corrupted the root chunk, as I am > > unable to do an oninit -s. This is from my online.log file: > > 14:22:27 Informix Dynamic Server Initialized -- Shared Memory > > Initialized. > > 14:22:27 Physical Recovery Started. > > 14:22:27 Physical Recovery Complete: 0 Pages Restored. > > 14:22:27 Logical Recovery Started. > > 14:22:30 Logical Recovery Complete. > > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 14:22:31 Informix Dynamic Server Stopped. > > 14:22:31 mt_shm_remove: WARNING: may not have removed all/correct > > segments > > Please, post full log with restore activities. > > -- > ------------------------------------------------- > With best regards, Yuri Dovgart > SAP R/3, Informix technical consultant, > Informix Certified Professional, > Senior System Consultant > System Architecture and High Availability Systems, > 'Telecominvest' company > Email y_dovgart@tci.ukrtel.net > ICQ 39284285 > > > I did an ipcs and there were no shared memory segments hanging there > > that belongs to Informix. Any thoughts on how to solvis this without > > doing an oninit -i? > > Thanks! > > Rebecca > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.

Here's the restore log (bar_act.log) 2000-04-03 10:21:30 5146 5145 /opt/informix/bin/onbar_d -r -p rootdbs 2000-04-03 10:24:10 5146 5145 Successfully connected to Storage Manager. 2000-04-03 10:27:16 5146 5145 Begin cold level 0 restore rootdbs. 2000-04-03 10:27:33 5146 5145 Completed cold level 0 restore rootdbs. 2000-04-03 10:27:33 5146 5145 WARNING: Physical restore complete. Logical restore required before work can continue. 2000-04-03 10:27:35 5171 5170 /opt/informix/bin/onbar_d -r -l rootdbs 2000-04-03 10:27:35 5171 5170 WARNING: DB/BLOBspace names ignored for fake backup or whole system backup/restore or log restore or log salvage. 2000-04-03 10:27:36 5171 5170 Successfully connected to Storage Manager. 2000-04-03 10:27:57 5171 5170 Begin restore logical log 1. 2000-04-03 10:28:07 5171 5170 Completed restore logical log 1. 2000-04-03 10:28:09 5171 5170 XBSA Error (BSAEndTxn): A system error occurred. Aborting XBSA session. 2000-04-03 10:28:09 5171 5170 bar_sighdlr: Received signal 11. Process 5171 exiting... 2000-04-04 00:11:18 5601 5600 /opt/informix/bin/onbar_d -b -L 0 rootdbs 2000-04-04 00:11:18 5601 5600 ERROR: Unable to open connection to server: Info rmix Dynamic Server Stopped.. And from my bp_rest log (from third party SM, Netbackup): 0:18:50 INF - bphdb exit normal 10:18:50 INF - Processing /usr/openv/netbackup/ext/db_ext/informix/scripts/infor mix_onbar_restore_rootdbs 10:18:50 INF - Executing script /usr/openv/netbackup/ext/db_ext/informix/scripts /informix_onbar_restore_rootdbs 10:18:50 INF - bphdb still working. 10:18:50 INF - Keepalives will be sent every 120 seconds. 10:20:50 INF - bphdb still working. 10:22:50 INF - bphdb still working. 10:24:50 INF - bphdb still working. 10:26:50 INF - bphdb still working. 10:28:10 ERR - Script exited with status = 141 10:28:10 ERR - bphdb exit status = 5: the restore failed to recover the requested files I did a rofferr on 141 and it makes no sense because I haven't even changed the TBLSPACE_STATS parameter (set to 1) and I only have one table in my one database on rootdbs. Thanks in advance! > > I've been testing a third party backup/restore software (Netbackup)on a > > test database on IDS 7.31 on Sparc, Sol 2.7. Everytime I try to restore > > the small test database I seem to have corrupted the root chunk, as I am > > unable to do an oninit -s. This is from my online.log file: > > 14:22:27 Informix Dynamic Server Initialized -- Shared Memory > > Initialized. > > 14:22:27 Physical Recovery Started. > > 14:22:27 Physical Recovery Complete: 0 Pages Restored. > > 14:22:27 Logical Recovery Started. > > 14:22:30 Logical Recovery Complete. > > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 14:22:31 Informix Dynamic Server Stopped. > > 14:22:31 mt_shm_remove: WARNING: may not have removed all/correct > > segments > > Please, post full log with restore activities. > > -- > ------------------------------------------------- > With best regards, Yuri Dovgart > SAP R/3, Informix technical consultant, > Informix Certified Professional, > Senior System Consultant > System Architecture and High Availability Systems, > 'Telecominvest' company > Email y_dovgart@tci.ukrtel.net > ICQ 39284285 > > > I did an ipcs and there were no shared memory segments hanging there > > that belongs to Informix. Any thoughts on how to solvis this without > > doing an oninit -i? > > Thanks! > > Rebecca > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.