IDS 11.7 ,Inplace Upgrade Failed
An in-place upgrade from IDS 11.50 to 11.70 on Solaris/ZFS failed at startup with "Cannot Open Primary Chunk ... errno = 2" and a fatal shared-memory initialization error. The cause was the ZFS mountpoint swap: remounting the new 11.70 filesystem at /informix left the old chunk files (and their symlinks) under /ids11.5, so the server couldn't find them. After fixing the chunk paths/links, the conversion succeeded. Posters also clarified that renaming the sysadmin database applies only to pre-11.10 upgrades, not 11.5 to 11.7.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I'm trying to upgrade IDS11.5 to IDS11.7 to benefit the features of IDS 11.7.
From Informix migration guide,I know that I've to rename sysadmin database
before doing the migration, but How to do it?
Before doing the migration,I've do the Level 0 archive
the storage of informix is raw type and OS is Solaris 10 SPARC version
Here is some info of what I'm doing:
tank/ids11.7 99G 736M 13G 6% /ids11.7
tank/informix 99G 1.4G 13G 10% /informix
$ id
uid=100(informix) gid=100(informix)
$ onstat -
IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up 04:13:25 --3091456 Kbytes
$ onmode -ky
$ onstat -shared memory not initialized for INFORMIXSERVER 'mitiis'
$ exit
root@m3k # zfs set mountpoint=/ids11.5 tank/informix
root@m3k # zfs set mountpoint=/informix tank/ids11.7
root@m3k # su - informixSun Microsystems Inc. SunOS 5.10 Generic January 2005
$ onstat -VIBM Informix Dynamic Server Version 11.70.FC1 Software Serial Number
AAA#B000000
$ oninit -vChecking group membership to determine server run mode...succeeded
Reading configuration file '/informix/etc/onconfig.mitiis'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 119486 kbytes...succeeded
Allocating 886800 kbytes for buffer pool of 2K page size...succeeded
Creating infos file "/informix/etc/.infos.mitiis"...succeeded
Linking conf file "/informix/etc/.conf.mitiis"...succeeded
Initializing rhead structure...succeeded
Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 3 additional cpu vps...succeeded
Onlining 1 IO vps...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'tlitcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 2 flushers...succeeded
oninit: Fatal error in shared memory initialization
WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.
$
Message Log File: /informix/online.mitiis
21:19:58 Event alarms enabled. ALARMPROG = '/informix/etc/alarmprogram.sh'
21:19:58 Booting Language <c> from module <>
21:19:58 Loading Module <CNULL>
21:19:58 Booting Language <builtin> from module <>
21:19:58 Loading Module <BUILTINNULL>
21:20:03 DR: DRAUTO is 0 (Off)
21:20:03 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
21:20:03 Fast poll /dev/poll enabled.
21:20:03 IBM Informix Dynamic Server Version 11.70.FC1 Software Serial Number
AAA#B000000
21:20:03 Warning: stat() failed for chunk file /informix/data/mitiis/rootchk1
21:20:03 Cannot Open Primary Chunk '/informix/data/mitiis/rootchk1', errno = 2
21:20:03 oninit: Fatal error in shared memory initialization
21:20:03 IBM Informix Dynamic Server Stopped.
21:20:03 mt_shm_remove: WARNING: may not have removed all/correct segments
In 11.5 your chunks are under /informix/data/mitiis/
I suppose that zfs commands are some kind of mounting (I do not speak
solaris), so
you "unmount" tank/informix from /informix and you "mount" tank/ids11.7
to /informix.
Your original spaces are now on /ids11.5/data/mitiis/.
So you have to copy all chunks to /informix:
cd /ids11.5
tar cf - data | (cd /informix; tar xf -)
If your spaces inside data dir are links, man you are lucky. If not,
this will have to
copy all data.
HTH
Hrvoje
On 18.05.2011. 8:32, NOOR ANSARI AB RAZAK wrote:
> I'm trying to upgrade IDS11.5 to IDS11.7 to benefit the features of IDS 11.7.
>
> > From Informix migration guide,I know that I've to rename sysadmin database
> before doing the migration, but How to do it?
>
> Before doing the migration,I've do the Level 0 archive
>
> the storage of informix is raw type and OS is Solaris 10 SPARC version
>
> Here is some info of what I'm doing:
>
> tank/ids11.7 99G 736M 13G 6% /ids11.7
> tank/informix 99G 1.4G 13G 10% /informix
> $ id
> uid=100(informix) gid=100(informix)
> $ onstat ->
> IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up 04:13:25 --> 3091456 Kbytes
>
> $ onmode -ky
> $ onstat -> shared memory not initialized for INFORMIXSERVER 'mitiis'
> $ exit
> root@m3k # zfs set mountpoint=/ids11.5 tank/informix
> root@m3k # zfs set mountpoint=/informix tank/ids11.7
> root@m3k # su - informix> Sun Microsystems Inc. SunOS 5.10 Generic January 2005
> $ onstat -V> IBM Informix Dynamic Server Version 11.70.FC1 Software Serial Number
> AAA#B000000
> $ oninit -v> Checking group membership to determine server run mode...succeeded
> Reading configuration file '/informix/etc/onconfig.mitiis'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 119486 kbytes...succeeded
> Allocating 886800 kbytes for buffer pool of 2K page size...succeeded
> Creating infos file "/informix/etc/.infos.mitiis"...succeeded
> Linking conf file "/informix/etc/.conf.mitiis"...succeeded
> Initializing rhead structure...succeeded
> Writing to infos file...succeeded
> Initialization of Encryption...succeeded
> Initializing ASF...succeeded
> Initializing Dictionary Cache and SPL Routine Cache...succeeded
> Bringing up ADM VP...succeeded
> Creating VP classes...succeeded
> Onlining 3 additional cpu vps...succeeded
> Onlining 1 IO vps...succeeded
> Forking main_loop thread...succeeded
> Initializing DR structures...succeeded
> Forking 1 'tlitcp' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 2 flushers...succeeded
> oninit: Fatal error in shared memory initialization
>
> WARNING: server initialization failed, or possibly timed out (if -w was
used).
> Check the message log, online.log, for errors.
> $
>
> Message Log File: /informix/online.mitiis
> 21:19:58 Event alarms enabled. ALARMPROG = '/informix/etc/alarmprogram.sh'
> 21:19:58 Booting Language<c> from module<>
> 21:19:58 Loading Module<CNULL>
> 21:19:58 Booting Language<builtin> from module<>
> 21:19:58 Loading Module<BUILTINNULL>
> 21:20:03 DR: DRAUTO is 0 (Off)
> 21:20:03 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
> 21:20:03 Fast poll /dev/poll enabled.
> 21:20:03 IBM Informix Dynamic Server Version 11.70.FC1 Software Serial Number
> AAA#B000000
> 21:20:03 Warning: stat() failed for chunk file /informix/data/mitiis/rootchk1
> 21:20:03 Cannot Open Primary Chunk '/informix/data/mitiis/rootchk1', errno =
2
> 21:20:03 oninit: Fatal error in shared memory initialization
>
> 21:20:03 IBM Informix Dynamic Server Stopped.
>
> 21:20:03 mt_shm_remove: WARNING: may not have removed all/correct segments
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Yes you' re right.Error 2 mean -2 No such file or directory.
An operating-system error code with the meaning shown was unexpectedly
returned to the database server. Look for other operating-system error
messages that might give more information.
Ok I've fix the path/links and Finally the conversion is success.
But actually do I need to rename the sysadmin database,because I've tried
several times to rename the database but I can't?
The conversion is successfull although I did not rename the database...
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
21 sysadmin DR Wait 5 0 0 - Off
20 sysadmin DR Wait 5 0 0 - Off
19 sysadmin DR Wait 5 0 0 - Off
$ dbaccess sysmaster -
Database selected.
> rename database sysadmin to sysadmin2;
425: Database is currently opened by another user.
107: ISAM error: record is locked.
Error in line 1Near character position 36
Why do you think you have to rename sysadmin database?
In-place upgrade will do any changes if needed.
HTH
Hrvoje
On 18.05.2011. 19:40, NOOR ANSARI AB RAZAK wrote:
> Yes you' re right.Error 2 mean -2 No such file or directory.
>
> An operating-system error code with the meaning shown was unexpectedly
> returned to the database server. Look for other operating-system error
> messages that might give more information.
>
> Ok I've fix the path/links and Finally the conversion is success.
>
> But actually do I need to rename the sysadmin database,because I've tried
> several times to rename the database but I can't?
>
> The conversion is successfull although I did not rename the database...
>
> Sess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers Explain
> 21 sysadmin DR Wait 5 0 0 - Off
> 20 sysadmin DR Wait 5 0 0 - Off
> 19 sysadmin DR Wait 5 0 0 - Off
>
> $ dbaccess sysmaster ->
> Database selected.
>
>> rename database sysadmin to sysadmin2;
> 425: Database is currently opened by another user.>
> 107: ISAM error: record is locked.
> Error in line 1> Near character position 36
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Because it stated in Informix Migration Guide to rename the sysadmin database before upgrading... A new system database called sysadmin was introduced in IDS 11.10 . If you have a database called sysadmin, you must rename it prior to upgrading to 11.10 or 11.50
On Wed, May 18, 2011 at 20:13, NOOR ANSARI AB RAZAK <ansari@miti.gov.my>wrote: > Because it stated in Informix Migration Guide > > to rename the sysadmin database before upgrading... > > A new system database called sysadmin was introduced > in IDS 11.10 . If you have a database called sysadmin, you > must rename it prior to upgrading to 11.10 or 11.50 > There is no absolute rule against creating databases with names starting 'sys' - though you would be ill-advised to do so. If it so happened that you had called one of your databases 'sysadmin', then you needed to give it a new name before the upgrade. If, however, you had no such database of your own creation - just one created by the system - then you have nothing to do. So, the intention was that if you have a 9.40 or 10.00 or some earlier version of IDS and there was a database 'sysadmin' in the old instance, then you need to rename it. If you have 11.10 or 11.50 (or 11.70), the sysadmin database will be the one created by IDS and there is no need to do anything with it. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --0015175cdaf24f0f5904a39a83c2
You're doing 11.5 -> 11.7 migration, so you do not have non system sysadmin database. This is only for pre 11 migrations. Hrvoje On 18.05.2011. 22:13, NOOR ANSARI AB RAZAK wrote: > Because it stated in Informix Migration Guide > > to rename the sysadmin database before upgrading... > > A new system database called "sysadmin" was introduced > in IDS 11.10 . If you have a database called "sysadmin", you > must rename it prior to upgrading to 11.10 or 11.50 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >