Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 23 Apr 1999 13:08:06 -0500
From:      "Doug Poland" <dpoland@execpc.com>
To:        <SYBASE-L@UCSBVM.ucsb.edu>
Cc:        <freebsd-database@FreeBSD.ORG>
Subject:   Sybase saga continues...
Message-ID:  <000001be8db4$dbe1ca70$b16f6478@egypt>

Next in thread | Raw E-Mail | Index | Archive | Help
This is a multi-part message in MIME format.

------=_NextPart_000_0001_01BE8D8A.F30ECFB0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Many thanks to those who have helped me out the last couple of days...

To continue, I'm trying to install Sybase (Linux) and FreeBSD 3.1-RELEASE.
I've fixed the shared memory problem by recompiling the kernel with SHMMAX
and SHMMAXPGS options that Vladimir Silyaev recommended.  The latest problem
is
when sybinit attempts to boot the server.  This is what I'm seeing...

<snip>
Running task: update the SQL Server runserver file.
Task succeeded: update the SQL Server runserver file.
Running task: boot the SQL Server.
Calling the shell with '/usr/opt/sybase/install/RUN_SYBASE >
                       /usr/opt/sybase/init/logs/tmp 2>&1 '.
waiting for server 'SYBASE' to boot...
INTERNAL ERROR: Could not locate message number '514' for product
'SQL Server' in message cache.
<snip>

The "strange" thing is, I do a "ps" and the dataserver is running and has
16MB of memory allocated and using about 7MB.

I tried to talk to the dataserver using isql -SSYBASE -Usa -P but got a
connection timeout.

On the successful side, I did configure the backup server.  I went through
the whole configuration and it booted!  Unfortunately, a message similar to

	"Warning" this process needs 1024 file descriptors but only has 512"

appeared.

So I'm wondering, where do I go now?  Am I still seeing a shared memory
problem?
Does the files descriptors offer a clue?

Thanks very much for your help.  I've attached the detailed log and error
files for your convenience.

--
Doug Poland
dpoland@execpc.com

------=_NextPart_000_0001_01BE8D8A.F30ECFB0
Content-Type: application/octet-stream;
	name="errorlog"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="errorlog"

00:1999/04/20 23:20:01.23 kernel  Using config area from primary master =
device.
00:1999/04/20 23:20:01.32 kernel  Warning: Using default file =
'/usr/opt/sybase/SYBASE.cfg' since a configuration file was not =
specified. Specify a configuration file name in the RUNSERVER file to =
avoid this message.
00:1999/04/20 23:20:01.40 kernel  Using 531 file descriptors.
00:1999/04/20 23:20:01.40 kernel  SQL Server/11.0.3.3/P/Linux =
Intel/Linux 2.0.36 i586/1/OPT/Thu Sep 10 13:42:44 CEST 1998
00:1999/04/20 23:20:01.40 kernel  (c) Copyright 1987, 1998.
00:1999/04/20 23:20:01.40 kernel  Sybase, Inc.  All rights reserved.
00:1999/04/20 23:20:01.40 kernel  =20
00:1999/04/20 23:20:01.41 kernel  Unpublished rights reserved under U.S. =
copyright laws.
00:1999/04/20 23:20:01.41 kernel  This software contains confidential =
and trade secret information of Sybase,
00:1999/04/20 23:20:01.41 kernel  Inc.   Use,  duplication or disclosure =
of the software and documentation by
00:1999/04/20 23:20:01.41 kernel  the  U.S.  Government  is  subject  to =
 restrictions set forth in a license
00:1999/04/20 23:20:01.41 kernel  agreement  between  the  Government  =
and  Sybase,  Inc.  or  other  written
00:1999/04/20 23:20:01.41 kernel  agreement  specifying  the  =
Government's rights to use the software and any
00:1999/04/20 23:20:01.41 kernel  applicable FAR provisions, for =
example, FAR 52.227-19.
00:1999/04/20 23:20:01.41 kernel =20
00:1999/04/20 23:20:01.41 kernel  Sybase, Inc. 6475 Christie Avenue, =
Emeryville, CA 94608, USA.
00:1999/04/20 23:20:01.41 kernel  Using '/usr/opt/sybase/SYBASE.cfg' for =
configuration information.
00:1999/04/20 23:20:01.41 kernel  Logging SQL Server messages in file =
'/usr/opt/sybase/install/errorlog'
.
00:1999/04/20 23:20:01.45 kernel  Network and device connection limit is =
521.
00:1999/04/20 23:20:01.52 server  Number of proc buffers allocated: 480.
00:1999/04/20 23:20:01.75 server  Number of blocks left for proc =
headers: 527.
00:1999/04/20 23:20:01.75 server  Memory allocated for the default data =
cache cache: 3600 Kb
00:1999/04/20 23:20:01.76 server  Size of the 2K memory pool: 3600 Kb
00:1999/04/20 23:20:01.76 kernel  Initializing virtual device 0, =
'/usr/opt/sybase/master.dat'
00:1999/04/20 23:20:01.76 kernel  Virtual device 0 started using =
standard unix i/o.
00:1999/04/20 23:20:01.77 server  No active traceflags
00:1999/04/20 23:20:01.87 server  Opening Master Database ...
00:1999/04/20 23:20:02.08 server  Loading SQL Server's default sort =
order and character set
00:1999/04/20 23:20:02.09 kernel  network name phoencia.nrc.com, type =
ether, port 7100
00:1999/04/20 23:20:02.11 kernel  ninit: set process group 308, No such =
process
00:1999/04/20 23:20:02.15 server  Recovering database 'master'
00:1999/04/20 23:20:02.19 server  Recovery dbid 1 ckpt (1511,17)
00:1999/04/20 23:20:02.19 server  Recovery no active transactions before =
ckpt.
00:1999/04/20 23:20:02.27 server  1 transactions rolled forward.
00:1999/04/20 23:20:02.30 server  Database 'master' is now online.
00:1999/04/20 23:20:02.32 server  The transaction log in the database =
'master' will use I/O size of 2 Kb.
00:1999/04/20 23:20:02.32 server  0 dump conditions detected at boot =
time
00:1999/04/20 23:20:02.35 server  server is unnamed
00:1999/04/20 23:20:02.42 server  Recovering database 'model'.
00:1999/04/20 23:20:02.42 server  Recovery dbid 3 ckpt (406,10)
00:1999/04/20 23:20:02.42 server  Recovery no active transactions before =
ckpt.
00:1999/04/20 23:20:02.46 server  The transaction log in the database =
'model' will use I/O size of 2 Kb.
00:1999/04/20 23:20:02.46 server  Database 'model' is now online.
00:1999/04/20 23:20:02.49 server  Clearing temp db=20
00:1999/04/20 23:20:02.64 server  The transaction log in the database =
'tempdb' will use I/O size of 2 Kb.
00:1999/04/20 23:20:02.70 server  The transaction log in the database =
'tempdb' will use I/O size of 2 Kb.
00:1999/04/20 23:20:02.71 server  Database 'tempdb' is now online.
00:1999/04/20 23:20:02.71 server  Recovery complete.
00:1999/04/20 23:20:02.71 server  SQL Server's default sort order is:
00:1999/04/20 23:20:02.71 server  	'bin_iso_1' (ID =3D 50)
00:1999/04/20 23:20:02.71 server  on top of default character set:
00:1999/04/20 23:20:02.71 server  	'iso_1' (ID =3D 1).

------=_NextPart_000_0001_01BE8D8A.F30ECFB0
Content-Type: application/octet-stream;
	name="log0420.001"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="log0420.001"

20/04/0099 11:17:57 PM Sybinit/11.0.3/P/Linux Intel/Linux 2.0.36 =
i586/1/OPT/Thu Sep=20
                       10 13:46:13 CEST 1998
20/04/0099 11:17:57 PM (c) Copyright 1987, 1998.
Sybase, Inc.  All rights reserved.

                       Unpublished rights reserved under U.S. copyright =
laws.
This=20
                       software contains confidential and trade secret =
information of=20
                       Sybase,
Inc.   Use,  duplication or disclosure of the software and=20
                       documentation by
the  U.S.  Government  is  subject  to=20
                       restrictions set forth in a license
agreement  between  the=20
                       Government  and  Sybase,  Inc.  or  other  =
written
agreement=20
                       specifying  the  Government's rights to use the =
software and any

                       applicable FAR provisions, for example, FAR =
52.227-19.

Sybase,=20
                       Inc. 6475 Christie Avenue, Emeryville, CA 94608, =
USA.

20/04/0099 11:17:57 PM BEGIN ENVIRONMENT INFORMATION

USER ENVIRONMENT
----------------------------------------
user name:                     sybase
current directory:             /usr/opt/sybase/install
character set:                 iso_1
language:                      us_english
sybinit release directory:     /usr/opt/sybase
working release directory:     /usr/opt/sybase


20/04/0099 11:17:57 PM END ENVIRONMENT INFORMATION
20/04/0099 11:18:43 PM WARNING: '/usr/opt/sybase/master.dat' is a =
regular file which is=20
                       not recommended for a Server device.
20/04/0099 11:18:44 PM '/usr/opt/sybase/master.dat' is a regular file =
that already=20
                       exists. It will be overwritten.
20/04/0099 11:19:32 PM WARNING: '/usr/opt/sybase/master.dat' is a =
regular file which is=20
                       not recommended for a Server device.
20/04/0099 11:19:52 PM '/usr/opt/sybase/master.dat' is a regular file =
that already=20
                       exists. It will be overwritten.
20/04/0099 11:19:52 PM Running task: create the master device.
20/04/0099 11:19:53 PM Calling the shell with =
'/usr/opt/sybase/bin/buildmaster=20
                       -d/usr/opt/sybase/master.dat -s15360   >=20
                       /usr/opt/sybase/init/logs/tmp 2>&1 '.
20/04/0099 11:19:53 PM Building the master device
20/04/0099 11:19:58 PM Done
20/04/0099 11:19:58 PM Begin output from 'buildmaster':
Master device: /usr/opt/sybase/master.dat
writing configuration area
writing the MASTER database
writing the MODEL database
writing allocation pages for remaining 25 MB, (12800 pages)
2 MB     =0D4 MB     =0D6 MB     =0D8 MB     =0D10 MB     =0D12 MB     =
=0D14 MB     =0D16 MB     =0D18 MB     =0D20 MB     =0D22 MB     =0D24 =
MB     =0D25 MB    =20
Buildmaster complete
20/04/0099 11:19:58 PM End output from 'buildmaster'.
20/04/0099 11:19:58 PM Task succeeded: create the master device.
20/04/0099 11:19:58 PM Running task: update the SQL Server runserver =
file.
20/04/0099 11:19:59 PM Task succeeded: update the SQL Server runserver =
file.
20/04/0099 11:20:00 PM Running task: boot the SQL Server.
20/04/0099 11:20:00 PM Calling the shell with =
'/usr/opt/sybase/install/RUN_SYBASE >=20
                       /usr/opt/sybase/init/logs/tmp 2>&1 '.
20/04/0099 11:20:01 PM waiting for server 'SYBASE' to boot...
20/04/0099 11:38:27 PM INTERNAL ERROR: Could not locate message number =
'514' for product=20
                       'SQL Server' in message cache.
20/04/0099 11:40:42 PM Check the log =
(/usr/opt/sybase/init/logs/log0420.001) for more=20
                       information.  Please make a note of this error =
and contact your=20
                       Sybase representative.
20/04/0099 11:40:42 PM waiting for server 'SYBASE' to boot...
20/04/0099 11:42:23 PM INTERNAL ERROR: Could not locate message number =
'514' for product=20
                       'SQL Server' in message cache.
20/04/0099 11:42:26 PM Check the log =
(/usr/opt/sybase/init/logs/log0420.001) for more=20
                       information.  Please make a note of this error =
and contact your=20
                       Sybase representative.
20/04/0099 11:42:26 PM waiting for server 'SYBASE' to boot...
20/04/0099 11:42:29 PM Tasklist terminated at the user's behest
20/04/0099 11:42:34 PM Exiting.
20/04/0099 11:42:34 PM The log file for this session is=20
                       '/usr/opt/sybase/init/logs/log0420.001'.
20/04/0099 11:42:34 PM Log close.

------=_NextPart_000_0001_01BE8D8A.F30ECFB0--



To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message




Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?000001be8db4$dbe1ca70$b16f6478>