Date: Tue, 27 Apr 1999 08:42:06 -0500 From: "Doug Poland" <dpoland@execpc.com> To: <vns@maxa01.tm.odessa.ua> Cc: <SYBASE-L@UCSBVM.ucsb.edu>, <freebsd-database@FreeBSD.ORG> Subject: RE: Sybase saga continues... Message-ID: <000b01be90b3$c0ec7420$0a6f6478@egypt> In-Reply-To: <372589D9.7C14@maxa01.tm.odessa.ua>
index | next in thread | previous in thread | raw e-mail
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 <dataserver pid>.
>
> 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
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000b01be90b3$c0ec7420$0a6f6478>