From owner-freebsd-database Fri Apr 23 11:16:33 1999 Delivered-To: freebsd-database@freebsd.org Received: from mailgw01.execpc.com (mailgw01.execpc.com [169.207.2.78]) by hub.freebsd.org (Postfix) with ESMTP id 849D414F79 for ; Fri, 23 Apr 1999 11:15:04 -0700 (PDT) (envelope-from dpoland@execpc.com) Received: from pop04.execpc.com (pop04.execpc.com [169.207.2.82]) by mailgw01.execpc.com (8.9.1) id NAA18513; Fri, 23 Apr 1999 13:12:33 -0500 Received: from egypt (najiba-1-16.mdm.fox.execpc.com [169.207.126.16]) by pop04.execpc.com (8.8.8) id NAA22615; Fri, 23 Apr 1999 13:12:30 -0500 From: "Doug Poland" To: Cc: Subject: Sybase saga continues... Date: Fri, 23 Apr 1999 13:08:06 -0500 Message-ID: <000001be8db4$dbe1ca70$b16f6478@egypt> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0001_01BE8D8A.F30ECFB0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk 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... 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. 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