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
[-- Attachment #1 --]
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
[-- Attachment #2 --]
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
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
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
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 = 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 = 1).
[-- Attachment #3 --]
20/04/0099 11:17:57 PM Sybinit/11.0.3/P/Linux Intel/Linux 2.0.36 i586/1/OPT/Thu Sep
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
software contains confidential and trade secret information of
Sybase,
Inc. Use, duplication or disclosure of the software and
documentation by
the U.S. Government is subject to
restrictions set forth in a license
agreement between the
Government and Sybase, Inc. or other written
agreement
specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase,
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
not recommended for a Server device.
20/04/0099 11:18:44 PM '/usr/opt/sybase/master.dat' is a regular file that already
exists. It will be overwritten.
20/04/0099 11:19:32 PM WARNING: '/usr/opt/sybase/master.dat' is a regular file which is
not recommended for a Server device.
20/04/0099 11:19:52 PM '/usr/opt/sybase/master.dat' is a regular file that already
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
-d/usr/opt/sybase/master.dat -s15360 >
/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
4 MB
6 MB
8 MB
10 MB
12 MB
14 MB
16 MB
18 MB
20 MB
22 MB
24 MB
25 MB
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 >
/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
'SQL Server' in message cache.
20/04/0099 11:40:42 PM Check the log (/usr/opt/sybase/init/logs/log0420.001) for more
information. Please make a note of this error and contact your
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
'SQL Server' in message cache.
20/04/0099 11:42:26 PM Check the log (/usr/opt/sybase/init/logs/log0420.001) for more
information. Please make a note of this error and contact your
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
'/usr/opt/sybase/init/logs/log0420.001'.
20/04/0099 11:42:34 PM Log close.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000001be8db4$dbe1ca70$b16f6478>