From owner-freebsd-database Sun Jan 6 11:28:48 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 3C7FC37B400 for ; Sun, 6 Jan 2002 11:28:46 -0800 (PST) Received: (qmail 66750 invoked by uid 1001); 6 Jan 2002 19:28:45 -0000 Date: Sun, 6 Jan 2002 19:28:45 +0000 From: "Jim C. Nasby" To: freebsd-database@freebsd.org Subject: Re: Anyone have sybase working under FBSD 4.4? Message-ID: <20020106192845.A2894@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 Ooops, I forgot to mention this is Sybase 11.0.3 (not sure if there's any other versions available for FBSD). -- 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 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 From owner-freebsd-database Sun Jan 6 15:34:25 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 BAED937B404 for ; Sun, 6 Jan 2002 15:34:21 -0800 (PST) Received: (qmail 67840 invoked by uid 1001); 6 Jan 2002 23:34:21 -0000 Date: Sun, 6 Jan 2002 23:34:21 +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 #2 Message-ID: <20020106233421.C2894@flake.decibel.org> Reply-To: jim@nasby.net References: <20020105210112.P46007@flake.decibel.org> <20020106232041.B2894@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: <20020106232041.B2894@flake.decibel.org>; from jim@nasby.net on Sun, Jan 06, 2002 at 11:20:41PM +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 Looks like I spoke too soon; just got another infected with 11 error, this time without web access running on the local box: 00:2002/01/06 23:20:37.55 kernel current process (0x25a0068) infected with 11 00:2002/01/06 23:20:37.55 kernel ************************************ 00:2002/01/06 23:20:37.55 kernel SQL causing error : Daily_Summary.PROJECT_ID = 5 and r.PROJECT_ID = 5 and r.OVERALL_RANK = 1 -- -- Top Team Info for Yesterday -- update Daily_Summary set TOP_YTEAM 00:2002/01/06 23:20:37.55 kernel curdb = 5 pstat = 0x10100 lasterror = 515 00:2002/01/06 23:20:37.55 kernel preverror = 0 transtate = 0 00:2002/01/06 23:20:37.56 kernel curcmd = 197 program = sqsh 00:2002/01/06 23:20:37.56 kernel pc 0x82c94d5 ucbacktrace+0x61(0x0,0x1,0x83f2ad4,0xb,0x2) 00:2002/01/06 23:20:37.56 kernel pc 0x8083e29 terminate_process+0x389(0x0,0xffffffff,0xb,0x2,0x8) 00:2002/01/06 23:20:37.56 kernel pc 0x82d7d9b kisignal+0x83(0xb,0xdcd5002f,0x3007002f,0x2f,0x3007002f) 00:2002/01/06 23:20:37.56 kernel pc 0xbfbfffbf init_dummy+0xb78ef35b(0x2,0x307c5224,0x0,0x83f2ad4,0x307c51f8) 00:2002/01/06 23:20:37.56 kernel pc 0x283ce899 init_dummy+0x200bdc35(0x307c5208,0xf,0x83f2ad4,0x304300fc,0x304300cc) 00:2002/01/06 23:20:37.56 kernel pc 0x809cc6b ex_raise+0x1af(0x5,0xf,0x10,0x3,0xa) 00:2002/01/06 23:20:37.57 kernel pc 0x811e1da nullerr+0x2b2(0x311e944c,0x30610740,0x311e9228,0x83f2ad4,0x311e9158) 00:2002/01/06 23:20:37.57 kernel pc 0x8112fa6 run+0x40de(0x311e9158,0x311e9338,0x83f2ad4,0x0,0x311e9338) 00:2002/01/06 23:20:37.57 kernel pc 0x81f373b exec_eop+0x877(0x311e9158,0x311e9338,0x30432390,0x311e9158,0x0) 00:2002/01/06 23:20:37.57 kernel pc 0x81f29a0 execute+0x6a8(0x311e9100,0x311e9158,0xc5,0x30432390,0x83f2ad4) 00:2002/01/06 23:20:37.57 kernel Handler execerr (0x81f6950) installed by the following function: 00:2002/01/06 23:20:37.57 kernel pc 0x81f07bf ex_cleanup(0x83f2ad4,0x0,0x21,0x0,0x65742e74) 00:2002/01/06 23:20:37.57 kernel pc 0x8126880 sequencer+0x9ec(0x311fc000,0x83f2ad4,0x0,0x21,0x0) 00:2002/01/06 23:20:37.58 kernel Handler aritherr (0x8194e30) installed by the following function: 00:2002/01/06 23:20:37.58 kernel pc 0x824e03a s_execute+0x15d2(0x0,0x0,0x0,0x0,0x0) 00:2002/01/06 23:20:37.58 kernel pc 0x81acbaf conn_hdlr+0x148b(0x1,0x30432564,0x895eed31,0x0,0x5374616b) 00:2002/01/06 23:20:37.58 kernel Handler s_handle (0x8127d48) installed by the following function: 00:2002/01/06 23:20:37.58 kernel pc 0x81434f3 tdsrecv_language+0x28b(0x0,0x5374616b,0x0,0x0,0x0) 00:2002/01/06 23:20:37.58 kernel pc 0x895eed31 init_dummy+0x812de0cd(0x0,0x0,0x0,0x0,0x0) 00:2002/01/06 23:20:37.58 kernel end of stack trace, spid 8, kpid 39452776, suid 6 The SQL is from http://cvs.distributed.net/cvsweb.cgi/stats-proc/daily/dy_dailyblocks.sql?rev=1.9&content-type=text/x-cvsweb-markup As you can see, that's one big batch statement. I don't know if that's why it failed or not. -- 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 From owner-freebsd-database Sun Jan 6 15:36:27 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 C58F837B402 for ; Sun, 6 Jan 2002 15:36:24 -0800 (PST) Received: (qmail 67871 invoked by uid 1001); 6 Jan 2002 23:36:24 -0000 Date: Sun, 6 Jan 2002 23:36:24 +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 #2 Message-ID: <20020106233624.D2894@flake.decibel.org> Reply-To: jim@nasby.net References: <20020105210112.P46007@flake.decibel.org> <20020106232041.B2894@flake.decibel.org> <20020106233421.C2894@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: <20020106233421.C2894@flake.decibel.org>; from jim@nasby.net on Sun, Jan 06, 2002 at 11:34:21PM +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 I failed to mention that unlike most other times, this was the *only* error generated. There weren't a flurry of timeslice errors, which is what normally happens. -- 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 From owner-freebsd-database Wed Jan 9 10:18:37 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 8AFDE37B41F for ; Wed, 9 Jan 2002 10:18:32 -0800 (PST) Received: (qmail 83766 invoked by uid 1001); 9 Jan 2002 18:18:31 -0000 Date: Wed, 9 Jan 2002 18:18:31 +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 #2 Message-ID: <20020109181831.H2894@flake.decibel.org> Reply-To: jim@nasby.net References: <20020105210112.P46007@flake.decibel.org> <20020106232041.B2894@flake.decibel.org> <20020106233421.C2894@flake.decibel.org> <20020106233624.D2894@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: <20020106233624.D2894@flake.decibel.org>; from jim@nasby.net on Sun, Jan 06, 2002 at 11:36:24PM +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 The signal 11 issue appears to be solved. There was a misconfiguration of FreeTDS; apparently the version number in the config file wasn't correct. We still can't get multiple engines running though, so any help in that area would be most appreciated. -- 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 From owner-freebsd-database Fri Jan 11 2:59: 2 2002 Delivered-To: freebsd-database@freebsd.org Received: from rubicon.soft.lv (ilg01-195-114-52-166.hi.delfi.lv [195.114.52.166]) by hub.freebsd.org (Postfix) with ESMTP id EC73A37B426 for ; Fri, 11 Jan 2002 02:58:51 -0800 (PST) Received: by rubicon.soft.lv (Postfix, from userid 1016) id 1B04B2727; Fri, 11 Jan 2002 12:58:50 +0200 (EET) Received: from blacksun (unknown [62.85.35.1]) by rubicon.soft.lv (Postfix) with ESMTP id 75DD1271D for ; Fri, 11 Jan 2002 12:58:45 +0200 (EET) Message-ID: <00cd01c19a8f$2bee4180$8501a8c0@bis.lv> From: To: Subject: SAP DB Date: Fri, 11 Jan 2002 13:00:24 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 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 Hello, Anybody tried to compile SAP DB on FreeBSD? http://www.sapdb.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message