From owner-freebsd-database Sun Jan 6 15:20:47 2002 Delivered-To: freebsd-database@freebsd.org Received: from flake.decibel.org (flake.decibel.org [216.254.40.10]) by hub.freebsd.org (Postfix) with SMTP id CE13637B405 for ; Sun, 6 Jan 2002 15:20:42 -0800 (PST) Received: (qmail 67762 invoked by uid 1001); 6 Jan 2002 23:20:42 -0000 Date: Sun, 6 Jan 2002 23:20:41 +0000 From: "Jim C. Nasby" To: freebsd-database@freebsd.org Cc: statsdev@distributed.net Subject: Re: Anyone have sybase working under FBSD 4.4? - UPDATE Message-ID: <20020106232041.B2894@flake.decibel.org> Reply-To: jim@nasby.net References: <20020105210112.P46007@flake.decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20020105210112.P46007@flake.decibel.org>; from jim@nasby.net on Sat, Jan 05, 2002 at 09:01:12PM +0000 X-Operating-System: FreeBSD 4.4-STABLE i386 X-Distributed: Join the Effort! http://www.distributed.net Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Sat, Jan 05, 2002 at 09:01:12PM +0000, Jim C. Nasby wrote: > I know people have been able to get sybase running under 3.4, but we're > having lots of problems with it under 4.4: > > - We're occasionally getting crashes, along with some nasty things in our > http logs. (sybase errorlog: http://distributed.net/~decibel/errorlog.txt, > apache log: http://stats.distributed.net/~paul/errors.txt) It turns out that this only happens when PHP is running on the database server. If it's off, or if we run it on another box, everything is fine. This is PHP4 with FreeTDS (I didn't configure it, so that's all the detail I have atm). Worst case, we could run a seperate box just for web hosting, but that doesn't make a lot of sense if we can avoid it. I'd alse definitely appreciate suggestions on the multiple engine issue. We've already tried the trick of launching sybase using #!/usr/bin/perl use POSIX; setsid(); exec $ARGV[0] and also running #!/bin/sh pid=`ps -ax|awk '/dataserver/&&!/awk/{print $1;exit;}'` echo dataserver pid is $pid while true; do kill -IO $pid || break done but these didn't help. -- Jim C. Nasby (aka Decibel!) jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message