Problem initializing engine with raw device for "phydbs"...
Posted in 1999
Topics: Storage & Space Management, Error Codes & Troubleshooting, Server Administration, Logging & Checkpoints, Platform-Specific Issues
This is a multi-part message in MIME format.
------=_NextPart_000_0174_01BF42FD.0B375D00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi Listers,
IDS won't recognize the raw device that I created for the PHYSDBS.
It will only initialize if I specify that the PHYSDBS be placed in the
rootdbs.
I'll attach the appropriate configuration files.
The platform is Solaris 2.5.1.
The IDS version is 7.30.UC3
Thanks in advance,
Denmark W.
------=_NextPart_000_0174_01BF42FD.0B375D00
Content-Type: application/octet-stream;
name="online.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="online.log"
=0A=
Thu Dec 9 11:51:56 1999=0A=
=0A=
11:51:56 Event alarms enabled. ALARMPROG =3D =
'/usr/informix/etc/log_full.sh'=0A=
11:52:01 DR: DRAUTO is 0 (Off)=0A=
11:52:02 Requested shared memory segment size rounded from 600KB to =
608KB=0A=
11:52:02 Informix Dynamic Server Version 7.30.UC3 Software Serial =
Number AAC#A447827=0A=
11:52:03 Informix Dynamic Server Initialized -- Complete Disk =
Initialized.=0A=
11:52:04 Checkpoint Completed: duration was 0 seconds.=0A=
11:52:04 Dataskip is now OFF for all dbspaces=0A=
11:52:04 On-Line Mode=0A=
11:52:04 Building 'sysmaster' database ...=0A=
11:52:10 Logical Log 1 Complete.=0A=
11:52:13 Logical Log 2 Complete.=0A=
11:52:14 Checkpoint Completed: duration was 0 seconds.=0A=
11:52:17 Logical Log 3 Complete.=0A=
11:52:20 Logical Log 4 Complete.=0A=
11:52:25 'sysmaster' database built successfully.=0A=
11:52:25 'sysutils' database built successfully.=0A=
12:07:33 Checkpoint Completed: duration was 1 seconds.=0A=
12:22:33 Checkpoint Completed: duration was 0 seconds.=0A=
12:53:48 Informix Dynamic Server Stopped.=0A=
=0A=
Thu Dec 9 12:53:52 1999=0A=
=0A=
12:53:52 Event alarms enabled. ALARMPROG =3D =
'/usr/informix/etc/log_full.sh'=0A=
12:53:58 DR: DRAUTO is 0 (Off)=0A=
12:53:58 Requested shared memory segment size rounded from 600KB to =
608KB=0A=
12:53:58 Informix Dynamic Server Version 7.30.UC3 Software Serial =
Number AAC#A447827=0A=
12:53:58 Informix Dynamic Server Initialized -- Shared Memory =
Initialized.=0A=
12:53:59 Physical Recovery Started.=0A=
12:53:59 Physical Recovery Complete: 0 Pages Restored.=0A=
12:53:59 Logical Recovery Started.=0A=
12:54:01 Logical Recovery Complete.=0A=
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks=0A=
=0A=
12:54:01 DBspace(/dev/physdbs) for Physical Log File not found.=0A=
=0A=
12:54:02 Informix Dynamic Server Stopped.=0A=
12:54:02 mt_shm_remove: WARNING: may not have removed all/correct =
segments=0A=
=0A=
=0A=
Thu Dec 9 12:56:50 1999=0A=
=0A=
12:56:50 Event alarms enabled. ALARMPROG =3D =
'/usr/informix/etc/log_full.sh'=0A=
12:56:56 DR: DRAUTO is 0 (Off)=0A=
12:56:56 Requested shared memory segment size rounded from 600KB to =
608KB=0A=
12:56:57 Informix Dynamic Server Version 7.30.UC3 Software Serial =
Number AAC#A447827=0A=
12:56:57 Informix Dynamic Server Initialized -- Shared Memory =
Initialized.=0A=
12:56:57 Physical Recovery Started.=0A=
12:56:57 Physical Recovery Complete: 0 Pages Restored.=0A=
12:56:57 Logical Recovery Started.=0A=
12:57:00 Logical Recovery Complete.=0A=
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks=0A=
=0A=
12:57:00 Onconfig parameter LOGSMAX modified from 6 to 100.=0A=
12:57:00 Dataskip is now OFF for all dbspaces=0A=
12:57:00 On-Line Mode=0A=
12:57:00 Checkpoint Completed: duration was 0 seconds.=0A=
12:57:10 Checkpoint Completed: duration was 0 seconds.=0A=
12:57:11 Informix Dynamic Server Stopped.=0A=
=0A=
Thu Dec 9 12:57:14 1999=0A=
=0A=
12:57:14 Event alarms enabled. ALARMPROG =3D =
'/usr/informix/etc/log_full.sh'=0A=
12:57:20 DR: DRAUTO is 0 (Off)=0A=
12:57:20 Requested shared memory segment size rounded from 600KB to =
608KB=0A=
12:57:20 Informix Dynamic Server Version 7.30.UC3 Software Serial =
Number AAC#A447827=0A=
12:57:20 Informix Dynamic Server Initialized -- Shared Memory =
Initialized.=0A=
12:57:20 Physical Recovery Started.=0A=
12:57:20 Physical Recovery Complete: 0 Pages Restored.=0A=
12:57:20 Logical Recovery Started.=0A=
12:57:23 Logical Recovery Complete.=0A=
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks=0A=
=0A=
12:57:23 Dataskip is now OFF for all dbspaces=0A=
12:57:23 Quiescent Mode=0A=
12:57:23 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:20 Checkpoint Completed: duration was 14 seconds.=0A=
13:22:20 Logical Log 5 Complete.=0A=
13:22:21 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:23 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:25 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:26 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:27 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:28 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:29 Checkpoint Completed: duration was 0 seconds.=0A=
13:22:31 Process exited with return code 141: /bin/sh /bin/sh -c =
/usr/informix/etc/log_full.sh 2 23 "Logical Log 5 Complete." "Logical =
Log 5 Complete." =0A=
15:23:25 Informix Dynamic Server Stopped.=0A=
=0A=
Thu Dec 9 15:23:37 1999=0A=
=0A=
15:23:37 Event alarms enabled. ALARMPROG =3D =
'/usr/informix/etc/log_full.sh'=0A=
15:23:43 DR: DRAUTO is 0 (Off)=0A=
15:23:43 Requested shared memory segment size rounded from 600KB to =
608KB=0A=
15:23:43 Informix Dynamic Server Version 7.30.UC3 Software Serial =
Number AAC#A447827=0A=
15:23:44 Assert Failed: Page Check Error in bfput=0A=
15:23:44 Informix Dynamic Server Version 7.30.UC3 =0A=
15:23:44 Who: Session(1, informix@bbankmain, 0, 0)=0A=
Thread(7, main_loop(), 0, 1)=0A=
File: rsdebug.c Line: 1003=0A=
15:23:54 See Also: /tmp/af.7751f, shmem.7751f.0=0A=
15:24:46 Assert Failed: Dynamic Server must abort=0A=
15:24:46 Informix Dynamic Server Version 7.30.UC3 =0A=
15:24:46 Who: Session(1, informix@bbankmain, 0, 0)=0A=
Thread(7, main_loop(), 0, 1)=0A=
File: rsbuff.c Line: 2502=0A=
15:25:02 See Also: /tmp/af.7751f, shmem.7751f.1=0A=
15:26:56 shmget: [EEXIST][17]: key 52564801: shared memory already =
exists=0A=
15:26:56 mt_shm_init: can't create resident segment=0A=
=0A=
15:27:39 rsbuff.c, line 2502, thread 7, proc id 8858, Dynamic Server =
must abort.=0A=
15:27:40 PANIC: Attempting to bring system down=0A=
=0A=
Thu Dec 9 16:22:51 1999=0A=
=0A=
16:22:51 Event alarms enabled. ALARMPROG =3D =
'/usr/informix/etc/log_full.sh'=0A=
16:22:57 DR: DRAUTO is 0 (Off)=0A=
16:22:57 Requested shared memory segment size rounded from 600KB to =
608KB=0A=
16:22:58 Informix Dynamic Server Version 7.30.UC3 Software Serial =
Number AAC#A447827=0A=
16:22:59 Informix Dynamic Server Initialized -- Complete Disk =
Initialized.=0A=
16:22:59 Checkpoint Completed: duration was 0 seconds.=0A=
16:22:59 Dataskip is now OFF for all dbspaces=0A=
16:22:59 On-Line Mode=0A=
16:22:59 Building 'sysmaster' database ...=0A=1
>
> Hi Listers,
Hi !
Check your permissions - chmod 666 chunk_name. Also, try initialise phys log
in rootdbs, then remove it to the separate dbspace.
HTH.
--
-------------------------------------------------
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
>
> IDS won't recognize the raw device that I created for the PHYSDBS.
> It will only initialize if I specify that the PHYSDBS be placed in the
> rootdbs.
>
> I'll attach the appropriate configuration files.
> The platform is Solaris 2.5.1.
> The IDS version is 7.30.UC3
>
> Thanks in advance,
>
> Denmark W.
>
>
> ------=_NextPart_000_0174_01BF42FD.0B375D00
> Content-Type: application/octet-stream;
> name="online.log"
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: attachment;
> filename="online.log"
>
> =0A=
> Thu Dec 9 11:51:56 1999=0A=
> =0A=
> 11:51:56 Event alarms enabled. ALARMPROG =3D =
> '/usr/informix/etc/log_full.sh'=0A=
> 11:52:01 DR: DRAUTO is 0 (Off)=0A=
> 11:52:02 Requested shared memory segment size rounded from 600KB to =
> 608KB=0A=
> 11:52:02 Informix Dynamic Server Version 7.30.UC3 Software Serial =
> Number AAC#A447827=0A=
> 11:52:03 Informix Dynamic Server Initialized -- Complete Disk =
> Initialized.=0A=
> 11:52:04 Checkpoint Completed: duration was 0 seconds.=0A=
> 11:52:04 Dataskip is now OFF for all dbspaces=0A=
> 11:52:04 On-Line Mode=0A=
> 11:52:04 Building 'sysmaster' database ...=0A=
> 11:52:10 Logical Log 1 Complete.=0A=
> 11:52:13 Logical Log 2 Complete.=0A=
> 11:52:14 Checkpoint Completed: duration was 0 seconds.=0A=
> 11:52:17 Logical Log 3 Complete.=0A=
> 11:52:20 Logical Log 4 Complete.=0A=
> 11:52:25 'sysmaster' database built successfully.=0A=
> 11:52:25 'sysutils' database built successfully.=0A=
> 12:07:33 Checkpoint Completed: duration was 1 seconds.=0A=
> 12:22:33 Checkpoint Completed: duration was 0 seconds.=0A=
> 12:53:48 Informix Dynamic Server Stopped.=0A=
> =0A=
> Thu Dec 9 12:53:52 1999=0A=
> =0A=
> 12:53:52 Event alarms enabled. ALARMPROG =3D =
> '/usr/informix/etc/log_full.sh'=0A=
> 12:53:58 DR: DRAUTO is 0 (Off)=0A=
> 12:53:58 Requested shared memory segment size rounded from 600KB to =
> 608KB=0A=
> 12:53:58 Informix Dynamic Server Version 7.30.UC3 Software Serial =
> Number AAC#A447827=0A=
> 12:53:58 Informix Dynamic Server Initialized -- Shared Memory =
> Initialized.=0A=
> 12:53:59 Physical Recovery Started.=0A=
> 12:53:59 Physical Recovery Complete: 0 Pages Restored.=0A=
> 12:53:59 Logical Recovery Started.=0A=
> 12:54:01 Logical Recovery Complete.=0A=> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks=0A=
> =0A=
> 12:54:01 DBspace(/dev/physdbs) for Physical Log File not found.=0A=
> =0A=
> 12:54:02 Informix Dynamic Server Stopped.=0A=
> 12:54:02 mt_shm_remove: WARNING: may not have removed all/correct =
> segments=0A=
> =0A=
> =0A=
> Thu Dec 9 12:56:50 1999=0A=
> =0A=
> 12:56:50 Event alarms enabled. ALARMPROG =3D =
> '/usr/informix/etc/log_full.sh'=0A=
> 12:56:56 DR: DRAUTO is 0 (Off)=0A=
> 12:56:56 Requested shared memory segment size rounded from 600KB to =
> 608KB=0A=
> 12:56:57 Informix Dynamic Server Version 7.30.UC3 Software Serial =
> Number AAC#A447827=0A=
> 12:56:57 Informix Dynamic Server Initialized -- Shared Memory =
> Initialized.=0A=
> 12:56:57 Physical Recovery Started.=0A=
> 12:56:57 Physical Recovery Complete: 0 Pages Restored.=0A=
> 12:56:57 Logical Recovery Started.=0A=
> 12:57:00 Logical Recovery Complete.=0A=> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks=0A=
> =0A=
> 12:57:00 Onconfig parameter LOGSMAX modified from 6 to 100.=0A=
> 12:57:00 Dataskip is now OFF for all dbspaces=0A=
> 12:57:00 On-Line Mode=0A=
> 12:57:00 Checkpoint Completed: duration was 0 seconds.=0A=
> 12:57:10 Checkpoint Completed: duration was 0 seconds.=0A=
> 12:57:11 Informix Dynamic Server Stopped.=0A=
> =0A=
> Thu Dec 9 12:57:14 1999=0A=
> =0A=
> 12:57:14 Event alarms enabled. ALARMPROG =3D =
> '/usr/informix/etc/log_full.sh'=0A=
> 12:57:20 DR: DRAUTO is 0 (Off)=0A=
> 12:57:20 Requested shared memory segment size rounded from 600KB to =
> 608KB=0A=
> 12:57:20 Informix Dynamic Server Version 7.30.UC3 Software Serial =
> Number AAC#A447827=0A=
> 12:57:20 Informix Dynamic Server Initialized -- Shared Memory =
> Initialized.=0A=
> 12:57:20 Physical Recovery Started.=0A=
> 12:57:20 Physical Recovery Complete: 0 Pages Restored.=0A=
> 12:57:20 Logical Recovery Started.=0A=
> 12:57:23 Logical Recovery Complete.=0A=> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks=0A=
> =0A=
> 12:57:23 Dataskip is now OFF for all dbspaces=0A=
> 12:57:23 Quiescent Mode=0A=
> 12:57:23 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:20 Checkpoint Completed: duration was 14 seconds.=0A=
> 13:22:20 Logical Log 5 Complete.=0A=
> 13:22:21 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:23 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:25 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:26 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:27 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:28 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:29 Checkpoint Completed: duration was 0 seconds.=0A=
> 13:22:31 Process exited with return code 141: /bin/sh /bin/sh -c =
> /usr/informix/etc/log_full.sh 2 23 "Logical Log 5 Complete." "Logical =
> Log 5 Complete." =0A=
> 15:23:25 Informix Dynamic Server Stopped.=0A=
> =0A=
> Thu Dec 9 15:23:37 1999=0A=
> =0A=
> 15:23:37 Event alarms enabled. ALARMPROG =3D =
> '/usr/informix/etc/log_full.sh'=0A=
> 15:23:43 DR: DRAUTO is 0 (Off)=0A=
> 15:23:43 Requested shared memory segment size rounded from 600KB to =
> 608KB=0A=
> 15:23:43 Informix Dynamic Server Version 7.30.UC3 Software Serial =
> Number AAC#A447827=0A=
> 15:23:44 Assert Failed: Page Check Error in bfput=0A=
> 15:23:44 Informix Dynamic Server Version 7.30.UC3 =0A=
> 15:23:44 Who: Session(1, informix@bbankmain, 0, 0)=0A=
> Thread(7, main_loop(), 0, 1)=0A=
> File: rsdebug.c Line: 1003=0A=
> 15:23:54 See Also: /tmp/af.7751f, shmem.7751f.0=0A=
> 15:24:46 Assert Failed: Dynamic Server must abort=0A=
> 15:24:46 Informix Dynamic Server Version 7.30.UC3 =0A=
> 15:24:46 Who: Session(1, informix@bbankmain, 0, 0)=0A=
> Thread(7, main_loop(), 0, 1)=0A=
> File: rsbuff.c Line: 2502=0A=
> 15:25:02 See Also: /tmp/af.7751f, shmem.7751f.1=0A=
> 15:26:56 shmget: [EEXIST][17]: key 52564801: shared memory already =
> exists=0A=
> 15:26:56 mt_shm_init: can't create resident segment=0A=
> =0A=
> 15:27:39 rsbuff.c, line 2502, thread 7, proc id 8858, Dynamic Server =
> must abort.=0A=
> 15:27:40 PANIC: Attempting to bring system down=0A=
> =0A=
> Thu Dec 9 16:22:51 1999=0A=
> =0A=@
this is correct - when you initialize informix the physdbs must be in the rootdbs. after initialization you can move the physdbs to a different dbs. hope that helps. Sari Denmark Weatherburn wrote: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_0174_01BF42FD.0B375D00 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > > Hi Listers, > > IDS won't recognize the raw device that I created for the PHYSDBS. > It will only initialize if I specify that the PHYSDBS be placed in the > rootdbs. > > I'll attach the appropriate configuration files. > The platform is Solaris 2.5.1. > The IDS version is 7.30.UC3 > > Thanks in advance, > > Denmark W. > -- Sari Nathans SAP Basis Senior Manager, Seventh Wave Technology www.seventhwavetech.com Certified SAP R/3 Technical Consultant Certified Informix Professional 'SAP R/3 for the Informix DBA' author, published by Prenhall 12/99 snathans@gateway.net 813-335-4310
Related threads
- Conversion to differeent characters sets
- Problem in changing locale via dbexport/dbimport
- RE: openlink error "Unable to load locale categories"