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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000001be8db4$dbe1ca70$b16f6478>