From owner-freebsd-database Tue Apr 27 6:42:32 1999 Delivered-To: freebsd-database@freebsd.org Received: from mailgw00.execpc.com (mailgw00.execpc.com [169.207.1.78]) by hub.freebsd.org (Postfix) with ESMTP id 0DAC31541F for ; Tue, 27 Apr 1999 06:42:24 -0700 (PDT) (envelope-from dpoland@execpc.com) Received: from pop05.execpc.com (pop05.execpc.com [169.207.3.82]) by mailgw00.execpc.com (8.9.1) id IAA09811; Tue, 27 Apr 1999 08:42:14 -0500 Received: from egypt (xorth-2-41.mdm.fox.execpc.com [169.207.124.169]) by pop05.execpc.com (8.8.8) id IAA09230; Tue, 27 Apr 1999 08:42:12 -0500 From: "Doug Poland" To: Cc: , Subject: RE: Sybase saga continues... Date: Tue, 27 Apr 1999 08:42:06 -0500 Message-ID: <000b01be90b3$c0ec7420$0a6f6478@egypt> MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 In-Reply-To: <372589D9.7C14@maxa01.tm.odessa.ua> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Vladimir, Voila! It works perfectly. Thanks so much for your help. > -----Original Message----- > From: owner-freebsd-database@FreeBSD.ORG > [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of Vladimir > N.Silyaev > Sent: Tuesday, April 27, 1999 04:57 > To: Doug Poland > Cc: SYBASE-L@UCSBVM.ucsb.edu; freebsd-database@FreeBSD.ORG > Subject: Re: Sybase saga continues... > > > Doug Poland wrote: > > > 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? > No, You are already solved shared memory problem. > > > Does the files descriptors offer a clue? > > For example via sysctl interface: > sysctl -w kern.maxfiles=1536 && sysctl -w > kern.maxfilesperproc=1024 && \ > echo -n 'Change FileDescriptor ' > > > The rest of our problems there is a SIGIO problem, the next > instruction > intend for solve this problem. This is my second post of this text, > previous was delivered without subj. > > Please follow the next instruction. > 1. Create file sybaseio.sh > ----------------------- > #!/bin/sh > pid=`ps -ax|awk '/dataserver/&&!/awk/{print $1;exit;}'` > echo dataserver pid is $pid > while true; do > kill -IO $pid || break > done > ---------------------- > 2. At the stage of the installing Sybase SQL, when sybinit say: > > Running task: update the SQL Server runserver file. > Task succeeded: update the SQL Server runserver file. > Running task: boot the SQL Server. > waiting for server 'SYBASE' to boot... > > launch the sybaseio.sh script, the sybinit must print: > > Task succeeded: boot the SQL Server. > Running task: create the sybsystemprocs database. > > 3. When sybinit finished run isql -U sa, > enter password [empty], and after isql prompt: > sp_help > go > > 4. Shutdown dataserver: kill . > > 5. Create sybase.pl script > --------- > #!/usr/bin/perl5 > use POSIX; > > setsid(); > exec $ARGV[0] > --------- > > 6. Open in the editor file ${SYBASE}/install/RUN_SYBASE and > add the 'exec' word at the begin line where dataserver started, > for example: > ... > # interfaces: /opt/sybase > # > exec /opt/sybase/bin/dataserver \ > ... > > 7. Launch sybase.pl install/RUN_SYBASE and repeat step 3. > > > This is a symptom of the problem, which are hacked with sybaseio.sh > script. > > With best regards, V.Silyaev. > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message