From owner-freebsd-database Sat Jan 5 13: 1:18 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 580C137B41C for ; Sat, 5 Jan 2002 13:01:13 -0800 (PST) Received: (qmail 34454 invoked by uid 1001); 5 Jan 2002 21:01:12 -0000 Date: Sat, 5 Jan 2002 21:01:12 +0000 From: "Jim C. Nasby" To: freebsd-database@freebsd.org Subject: Anyone have sybase working under FBSD 4.4? Message-ID: <20020105210112.P46007@flake.decibel.org> Reply-To: jim@nasby.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i 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 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: - Running more than one engine results in random connections periodically hanging for long periods of time (60+ seconds). Whenever this happens, we get 'ninit: set process group xxxxx, no such process'. Also, attempting to dump/backup the database would result in sybase just hanging (backups work fine with a single engine, though) - 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) This is happening on a Dell 6400 4-way Xeon with 1G of memory. The database is being accessed mainly by apache/PHP using FreeTDS (http://stats.distributed.net/), and our batch processing uses sqsh 2.1 (we're currently running a linux binary due to problems getting sqsh to work properly on FBSD natively). All of the code is available at http://cvs.distributed.net/; the web code is at http://cvs.distributed.net/cvsweb.cgi/stats-html/ and the batch processing code is at http://cvs.distributed.net/cvsweb.cgi/stats-proc/. -- 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