Oninit cdi / Archive
Talk to an expert →

SDS_ENABLE - error rootchunk

Posted in 2008

Topics: High Availability & Replication, Backup & Restore, Storage & Space Management, SQL Development & Query Writing, Stored Procedures & SPL, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life

R Fo — — source: IIUG Forums & Mailing Lists

Hi gurus, I'm using VMWARE with RED HAT 4.4 in a notebook with 2 GB of RAM - Win XP Professional. All of these VMW is builting with 512 MB of RAM. I prepared a teste instance with IDS 11.10.UC2 and in one of the VMW I executed the steps: ontape -s -L 0 (TAPEDEV to disk in a "standard" or 'standalone' instance)FTP of the file of level 0 backup to other VMW (in disk) ontape -p (in the second VMW) and at the end:defined the first as th primary instance (onmode -d primary <instance secondary>) defining the second VMW as the secondary instance - HDR (onmode -d secondary <instance primary>) FTP of level 0 backup to a third VMW (in disk) ontape -p (in the third VMW) and at the end:defined the first as th primary instance (onmode -d add RSS <instance rss in the thirt VMW>) defining the RSS instance in VMW as the RSS instance (onmode -d RSS <instance primary>) All of these steps were running Ok ... After that, I bring offline all instances in order: 1-RSS instance 2-Secondary instance 3-Primary instance After that, I tried to start all instances and at the first step in the "primary instance", I got the following error: [informix@vmware-48]$ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/opt/IDS11/etc/onconfig.vmware48'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creating infos file "/opt/IDS11/etc/.infos.ol_vmware48"...succeeded Linking conf file "/opt/IDS11/etc/.conf.ol_vmware48"...succeeded Writing to infos file...succeeded Checking config parameters...succeeded Allocating and attaching to shared memory...succeeded Creating resident pool 4584 kbytes...succeeded Allocating 24016 kbytes for buffer pool of 2K page size...succeeded Initializing rhead structure...succeeded Initializing ASF...succeeded Initializing Dictionary Cache and SPL Routine Cache...succeeded Bringing up ADM VP...succeeded Creating VP classes...succeeded Onlining 1 additional cpu vps...succeeded Onlining 2 IO vps...succeeded Initialization of Encryption...succeeded Forking main_loop thread...succeeded Initializing DR structures...succeeded Forking 1 'soctcp' listener threads...[informix@vmware-48 ~]$ succeeded Starting tracing...succeeded Initializing 1 flushers...succeeded Initializing SDS Server network connections...FAILED Can not initialize SDS - SDS_ENABLE is not set, but the rootchunk indicates a shared disk environment [informix@vmware-48]$ [informix@vmware-48]$ onstat - shared memory not initialized for INFORMIXSERVER 'ol_vmware48' CHECKING THE ONLINE.LOG FILE, I FOUND (take look, I tried twice): Wed Apr 9 11:19:16 2008 11:19:16 Event alarms enabled. ALARMPROG = '/opt/IDS11/etc/alarmprogram.sh' 11:19:16 Booting Language <c> from module <> 11:19:16 Loading Module <CNULL> 11:19:16 Booting Language <builtin> from module <> 11:19:16 Loading Module <BUILTINNULL> 11:19:21 DR: DRAUTO is 0 (Off) 11:19:21 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 11:19:21 Event notification facility epoll enabled. 11:19:21 IBM Informix Dynamic Server Version 11.10.UC2 Software Serial Number AAA#B000000 11:19:22 Can not initialize SDS - SDS_ENABLE is not set, but the rootchunk indicates a shared disk environment 11:19:22 IBM Informix Dynamic Server Stopped. 11:19:22 mt_shm_remove: WARNING: may not have removed all/correct segments 11:22:07 IBM Informix Dynamic Server Started. Wed Apr 9 11:22:08 2008 11:22:08 Event alarms enabled. ALARMPROG = '/opt/IDS11/etc/alarmprogram.sh' 11:22:08 Booting Language <c> from module <> 11:22:08 Loading Module <CNULL> 11:22:08 Booting Language <builtin> from module <> 11:22:08 Loading Module <BUILTINNULL> 11:22:13 DR: DRAUTO is 0 (Off) 11:22:13 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 11:22:13 Event notification facility epoll enabled. 11:22:13 IBM Informix Dynamic Server Version 11.10.UC2 Software Serial Number AAA#B000000 11:22:14 Can not initialize SDS - SDS_ENABLE is not set, but the rootchunk indicates a shared disk environment 11:22:14 IBM Informix Dynamic Server Stopped. 11:22:14 mt_shm_remove: WARNING: may not have removed all/correct segments Has somebody got the same error??? I guess it's a Bug , but you know if there is a fix, already ? All helps are welcome. I restored all instances , and after I repeat all of the steps and the instances were running ok until take offline... the error occurs again when try to start. Thanks folks and best regards. Roberto FERRONATO _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt= en-us

↪ replying to R Fo
Art S. Kagel (Oninit) — — source: IIUG Forums & Mailing Lists

R Fo wrote: > Hi gurus, > Wait, but if you restored all of these instances on the same box under different VMs, weren't they sharing the same disk chunks? Didn't each restore just overwrite the existing data on disk (admittedly with the same data)? Maybe that's why the startup detection when you tried to restart the primary thought that it was an SDS secondary and it couldn't find a primary running? Did you rename the chunks for each instance during the restores? If not, I think you have to restore the original primary's archive again and start the whole process over again. Art S. Kagel Oninit > I'm using VMWARE with RED HAT 4.4 in a notebook with 2 GB of RAM - Win XP > Professional. > > All of these VMW is builting with 512 MB of RAM. > I prepared a teste instance with IDS 11.10.UC2 and in one of the VMW I > executed > > the steps: > ontape -s -L 0 (TAPEDEV to disk in a "standard" or 'standalone' instance)> FTP of the file of level 0 backup to other VMW (in disk) > > ontape -p (in the second VMW) and at the end:> defined the first as th primary instance > (onmode -d primary <instance secondary>) > > defining the second VMW as the secondary instance - HDR > (onmode -d secondary <instance primary>) > > FTP of level 0 backup to a third VMW (in disk) > > ontape -p (in the third VMW) and at the end:> defined the first as th primary instance > (onmode -d add RSS <instance rss in the thirt VMW>) > > defining the RSS instance in VMW as the RSS instance > (onmode -d RSS <instance primary>) > > All of these steps were running Ok ... > > After that, I bring offline all instances in order: > 1-RSS instance > 2-Secondary instance > 3-Primary instance > > After that, I tried to start all instances and at the first step in the > "primary > > instance", I got the following error: > > [informix@vmware-48]$ oninit -v > Checking group membership to determine server run mode...succeeded > Reading configuration file '/opt/IDS11/etc/onconfig.vmware48'...succeeded > Creating /INFORMIXTMP/.infxdirs...succeeded > Creating infos file "/opt/IDS11/etc/.infos.ol_vmware48"...succeeded > Linking conf file "/opt/IDS11/etc/.conf.ol_vmware48"...succeeded > Writing to infos file...succeeded > Checking config parameters...succeeded > Allocating and attaching to shared memory...succeeded > Creating resident pool 4584 kbytes...succeeded > Allocating 24016 kbytes for buffer pool of 2K page size...succeeded > Initializing rhead structure...succeeded > Initializing ASF...succeeded > Initializing Dictionary Cache and SPL Routine Cache...succeeded > Bringing up ADM VP...succeeded > Creating VP classes...succeeded > Onlining 1 additional cpu vps...succeeded > Onlining 2 IO vps...succeeded > Initialization of Encryption...succeeded > Forking main_loop thread...succeeded > Initializing DR structures...succeeded > Forking 1 'soctcp' listener threads...[informix@vmware-48 ~]$ succeeded > Starting tracing...succeeded > Initializing 1 flushers...succeeded > Initializing SDS Server network connections...FAILED > Can not initialize SDS - > SDS_ENABLE is not set, but the rootchunk indicates a shared disk environment > [informix@vmware-48]$ > [informix@vmware-48]$ onstat - > shared memory not initialized for INFORMIXSERVER 'ol_vmware48' > > CHECKING THE ONLINE.LOG FILE, I FOUND (take look, I tried twice): > Wed Apr 9 11:19:16 2008 > > 11:19:16 Event alarms enabled. ALARMPROG = '/opt/IDS11/etc/alarmprogram.sh' > 11:19:16 Booting Language <c> from module <> > 11:19:16 Loading Module <CNULL> > 11:19:16 Booting Language <builtin> from module <> > 11:19:16 Loading Module <BUILTINNULL> > 11:19:21 DR: DRAUTO is 0 (Off) > 11:19:21 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 11:19:21 Event notification facility epoll enabled. > 11:19:21 IBM Informix Dynamic Server Version 11.10.UC2 Software Serial > > Number AAA#B000000 > 11:19:22 Can not initialize SDS - > SDS_ENABLE is not set, but the rootchunk indicates a shared disk environment > 11:19:22 IBM Informix Dynamic Server Stopped. > > 11:19:22 mt_shm_remove: WARNING: may not have removed all/correct segments > 11:22:07 IBM Informix Dynamic Server Started. > > Wed Apr 9 11:22:08 2008 > > 11:22:08 Event alarms enabled. ALARMPROG = '/opt/IDS11/etc/alarmprogram.sh' > 11:22:08 Booting Language <c> from module <> > 11:22:08 Loading Module <CNULL> > 11:22:08 Booting Language <builtin> from module <> > 11:22:08 Loading Module <BUILTINNULL> > 11:22:13 DR: DRAUTO is 0 (Off) > 11:22:13 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 11:22:13 Event notification facility epoll enabled. > 11:22:13 IBM Informix Dynamic Server Version 11.10.UC2 Software Serial > > Number AAA#B000000 > 11:22:14 Can not initialize SDS - > SDS_ENABLE is not set, but the rootchunk indicates a shared disk environment > 11:22:14 IBM Informix Dynamic Server Stopped. > > 11:22:14 mt_shm_remove: WARNING: may not have removed all/correct segments > > Has somebody got the same error??? > > I guess it's a Bug , but you know if there is a fix, already ? > > All helps are welcome. > > I restored all instances , and after I repeat all of the steps and the > instances > > were running ok until take offline... the error occurs again when try to > start. > > Thanks folks and best regards. > > Roberto FERRONATO > > _________________________________________________________________ > Invite your mail contacts to join your friends list with Windows Live Spaces. > It's easy! > > http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt= en-us > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > > >

↪ replying to Art S. Kagel (Oninit)
R Fo — — source: IIUG Forums & Mailing Lists

Art, Thanks for your answer. At each VMWare "machine" has its own set of disks. It's a very little instance , the "backup file" built by a "ontape -s -L 0" have size: 29.4 MB. Each virtual machine has a set of disks: PLEASE, TAKE A LOOK OF THE FOLLOWING.... Take look: host vmware-48 is the 'primary', hostname vmware-51 is 'secondary' and vmware-52 is the 'RSS' instance. [informix@vmware-48 ~]$ uname -a Linux vmware-51 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 2006 i686 i686 i386 GNU/Linux [informix@vmware-48 ~]$ hostname vmware-48 [informix@vmware-48 ~]$ df -km Filesystem 1M-blocks Used Available Use% Mounted on /dev/sda1 5907 3249 2358 58% / none 252 0 252 0% /dev/shm /dev/sda5 1884 345 1444 20% /opt [informix@vmware-48 ~]$ ls -la /opt/IDS11/ifmxdata/ total 8 drwxr-xr-x 2 root root 4096 Apr 4 17:43 . drwxr-xr-x 26 informix informix 4096 Apr 4 15:53 .. lrwxrwxrwx 1 root root 27 Apr 4 17:43 ck_dat1 -> /dev/mapper/ids11vg-lvdata1 lrwxrwxrwx 1 root root 27 Apr 4 17:43 ck_idx1 -> /dev/mapper/ids11vg-lvindx1 lrwxrwxrwx 1 root root 28 Apr 4 17:42 ck_llog -> /dev/mapper/ids11vg-lvllog01 lrwxrwxrwx 1 root root 28 Apr 4 17:42 ck_plog -> /dev/mapper/ids11vg-lvplog01 lrwxrwxrwx 1 root root 28 Apr 4 15:41 ck_root01 -> /dev/mapper/ids11vg-lvroot01 lrwxrwxrwx 1 root root 27 Apr 4 17:42 ck_tmp1 -> /dev/mapper/ids11vg-lvtemp1 [informix@vmware-48 ~]$ ls -la /dev/mapper total 0 drwxr-xr-x 2 root root 180 Apr 9 20:15 . drwxr-xr-x 10 root root 5660 Apr 9 20:15 .. crw------- 1 root root 10, 63 Apr 9 20:15 control brw-rw---- 1 informix informix 253, 4 Apr 9 20:15 ids11vg-lvdata1 brw-rw---- 1 informix informix 253, 5 Apr 9 20:15 ids11vg-lvindx1 brw-rw---- 1 informix informix 253, 2 Apr 9 20:15 ids11vg-lvllog01 brw-rw---- 1 informix informix 253, 1 Apr 9 20:15 ids11vg-lvplog01 brw-rw---- 1 informix informix 253, 0 Apr 9 20:15 ids11vg-lvroot01 brw-rw---- 1 informix informix 253, 3 Apr 9 20:15 ids11vg-lvtemp1 [informix@vmware-51 ~]$ hostname vmware-51 [informix@vmware-51 ~]$ df -km Filesystem 1M-blocks Used Available Use% Mounted on /dev/sda1 5907 3266 2341 59% / none 252 0 252 0% /dev/shm /dev/sda5 1884 390 1399 22% /opt [informix@vmware-51 ~]$ ls -la /dev/mapper total 0 drwxr-xr-x 2 root root 180 Apr 9 22:09 . drwxr-xr-x 10 root root 5660 Apr 9 22:09 .. crw------- 1 root root 10, 63 Apr 9 22:09 control brw-rw---- 1 informix informix 253, 3 Apr 9 22:09 ids11vg-lvdata1 brw-rw---- 1 informix informix 253, 4 Apr 9 22:09 ids11vg-lvindx1 brw-rw---- 1 informix informix 253, 1 Apr 9 22:09 ids11vg-lvllog01 brw-rw---- 1 informix informix 253, 5 Apr 9 22:09 ids11vg-lvplog01 brw-rw---- 1 informix informix 253, 0 Apr 9 22:09 ids11vg-lvroot01 brw-rw---- 1 informix informix 253, 2 Apr 9 22:09 ids11vg-lvtemp1 [informix@vmware-51 ~]$ ls -la /opt/IDS11/ifmxdata/ total 8 drwxr-xr-x 2 root root 4096 Apr 4 18:04 . drwxr-xr-x 26 informix informix 4096 Apr 4 15:53 .. lrwxrwxrwx 1 root root 27 Apr 4 18:04 ck_dat1 -> /dev/mapper/ids11vg-lvdata1 lrwxrwxrwx 1 root root 27 Apr 4 18:04 ck_idx1 -> /dev/mapper/ids11vg-lvindx1 lrwxrwxrwx 1 root root 28 Apr 4 18:04 ck_llog -> /dev/mapper/ids11vg-lvllog01 lrwxrwxrwx 1 root root 28 Apr 4 18:04 ck_plog -> /dev/mapper/ids11vg-lvplog01 lrwxrwxrwx 1 root root 28 Apr 4 15:41 ck_root01 -> /dev/mapper/ids11vg-lvroot01 lrwxrwxrwx 1 root root 27 Apr 4 18:04 ck_tmp1 -> /dev/mapper/ids11vg-lvtemp1 AS I cannot start the 'primary' instance, I started the 'secondary' , to show you the dbspaces and chunks (remember all instances have the same set of dbspaces and chunks). [informix@vmware-51 ~]$ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/opt/IDS11/etc/onconfig.vmware51'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creating infos file "/opt/IDS11/etc/.infos.ol_vmware51"...succeeded Linking conf file "/opt/IDS11/etc/.conf.ol_vmware51"...succeeded Writing to infos file...succeeded Checking config parameters...succeeded Allocating and attaching to shared memory...succeeded Creating resident pool 2560 kbytes...succeeded Allocating 24016 kbytes for buffer pool of 2K page size...succeeded Initializing rhead structure...succeeded Initializing ASF...succeeded Initializing Dictionary Cache and SPL Routine Cache...succeeded Bringing up ADM VP...succeeded Creating VP classes...succeeded Onlining 0 additional cpu vps...succeeded Onlining 2 IO vps...succeeded Initialization of Encryption...succeeded Forking main_loop thread...succeeded Initializing DR structures...[informix@vmware-51 ~]$ succeeded Forking 1 'soctcp' listener threads...succeeded Starting tracing...succeeded Initializing 1 flushers...succeeded Initializing SDS Server network connections...succeeded Initializing log/checkpoint information...succeeded Initializing dbspaces...succeeded Opening primary chunks...succeeded Opening mirror chunks...succeeded Validating chunks...succeeded Initialize Async Log Flusher...succeeded Forking btree cleaner...succeeded Initializing DBSPACETEMP list...succeeded Initializing dataskip structure...succeeded Forking onmode_mon thread...succeeded Verbose output complete: mode = 2 [informix@vmware-51 ~]$ onstat - IBM Informix Dynamic Server Version 11.10.UC2 -- Read-Only (Sec) -- Up 00:00:22 -- 59748 Kbytes [informix@vmware-51 ~]$ onstat -m IBM Informix Dynamic Server Version 11.10.UC2 -- Read-Only (Sec) -- Up 00:00:28 -- 59748 Kbytes Message Log File: /opt/IDS11/logs/online.log 22:12:44 Loading Module <BUILTINNULL> 22:12:49 DR: DRAUTO is 0 (Off) 22:12:49 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)22:12:49 Event notification facility epoll enabled. 22:12:49 IBM Informix Dynamic Server Version 11.10.UC2 Software Serial Number AAA#B000000 22:12:50 Performance Advisory: The current size of the physical log buffer is smaller than recommended. 22:12:50 Results: Transaction performance might not be optimal. 22:12:50 Action: For better performance, increase the physical log buffer size to 128. 22:12:50 The current size of the logical log buffer is smaller than recommended. 22:12:50 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 22:12:50 Physical Recovery Started at Page (2:440). 22:12:50 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 22:12:50 DR: Owner of the disk is set as ol_vmware51. 22:12:50 DR: Trying to connect to primary server = ol_vmware48 22:12:50 DR: Cannot connect to primary server 22:12:50 DR: Turned off on secondary server 22:12:50 Dataskip is now OFF for all dbspaces 22:12:50 Restartable Restore has been ENABLED 22:12:50 Recovery Mode [informix@vmware-51 ~]$ onstat -d IBM Informix Dynamic Server Version 11.10.UC2 -- Read-Only (Sec) -- Up 00:02:04 -- 59748 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 45bb17f0 1 0x40401 1 1 2048 NP B informix rootdbs 45c692a0 2 0x40401 2 1 2048 NP

Related threads

Glossary