From owner-freebsd-database@FreeBSD.ORG Wed Mar 22 21:54:00 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 668AE16A401 for ; Wed, 22 Mar 2006 21:54:00 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8989843D5A for ; Wed, 22 Mar 2006 21:53:59 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (76.mnetw.more.net [207.160.138.76]) by libby.lpmo.org (Postfix) with ESMTP id A18E72841B; Wed, 22 Mar 2006 15:53:31 -0600 (CST) Received: by gkar.earthdome.org (Postfix, from userid 503) id 98229562C36; Wed, 22 Mar 2006 15:51:10 -0600 (CST) Date: Wed, 22 Mar 2006 15:51:10 -0600 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060322215109.GC8904@gkar.earthdome.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i Subject: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Mar 2006 21:54:00 -0000 MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 We recently put four FreeBSD 6.0 servers with MySQL 4.1 into production. MySQL on three of these servers is moderately busy. Each requiring between 60-200 threads to handle anywhere from 6-40 queries per second during business hours. One is a Master DB, the other two are RO Slaves. The fourth where we haven't seen any problems is a hotbackup slave. Since going into production three days ago the Master DB has failed twice. The RO Slaves are failing 1-4 times per hour. In all cases the failure is a signal 10 for a SIGBUS error. The mysqld_safe script successfully restarts mysqld after each failure. I am posting on this list first to see if anyone has any ideas of how to resolve this problem before submitting either a FreeBSD or MySQL bug report. I enabled core files with the "--core-file" argument to the start script. I have examined six core files now. All look very similar. Core was generated by `mysqld'. Program terminated with signal 10, Bus error. (gdb) bt #0 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 #1 0x285190a2 in sigaction () from /usr/lib/libpthread.so.2 #2 0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2 #3 0x0815a1bf in ?? () #4 0x0841b000 in ?? () #5 0x0000000a in ?? () #6 0xbfbfdee8 in ?? () #7 0x0000000a in ?? () #8 0xbfbfe230 in ?? () #9 0x0000000a in ?? () #10 0xbfbfdef8 in ?? () #11 0x080aaf95 in ?? () #12 0x0000000a in ?? () #13 0x0835b8da in ?? () #14 0x000403fb in ?? () #15 0x00000000 in ?? () #16 0xbfbfdf30 in ?? () #17 0x2852c4b4 in ?? () from /usr/lib/libpthread.so.2 #18 0xbfbfdf28 in ?? () #19 0x28517252 in sigaction () from /usr/lib/libpthread.so.2 (gdb) info threads * 166 Thread 0x841b000 (LWP 100330) 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 165 Thread 0x841bc00 (LWP 100188) 0x28529277 in pthread_testcancel () from /usr/lib/libpthread.so.2 164 Thread 0x841be00 (LWP 100206) 0x28529337 in pthread_testcancel () from /usr/lib/libpthread.so.2 163 Thread 0xb22a400 (LWP 100205) 0x28573833 in read () from /lib/libc.so.6 162 Thread 0xb22a600 (LWP 100175) 0x28529277 in pthread_testcancel () from /usr/lib/libpthread.so.2 161 Thread 0xb22a800 (LWP 100211) 0x28529277 in pthread_testcancel () from /usr/lib/libpthread.so.2 160 Thread 0xb22aa00 (LWP 100204) 0x28573833 in read () from /lib/libc.so.6 159 Thread 0xb22ac00 (LWP 100257) 0x28573833 in read () from /lib/libc.so.6 158 Thread 0xb22ae00 (LWP 100258) 0x28573833 in read () from /lib/libc.so.6 157 Thread 0xb2eb000 (LWP 100259) 0x28573833 in read () from /lib/libc.so.6 ... In every case the SIGBUS error is occurring when mysql is killing off some threads. MySQL has a varible for setting the thread_cache_size. By default it is 0, meaning mysql creates threads as needed and kills off threads which are no longer needed almost immediately. We configured the thread_cache_size=50 so that mysql would maintain a pool of threads to reduce the frequency at which it did a thread kill. This has reduced the frequency of failures down to less than once an hour. We are using mysql-server-4.1.18_2 from ports with native threads. Here is some information on the system hardware and kernel config. vai and blackmore: Dell PowerEdge 1850 2x2.8 Ghz P4 1024 MB 2 x 36 GB disks (RAID1) FreeBSD vai.kinetic.more.net 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Mon Jan 30 15:40:24 CST 2006 FreeBSD blackmore.kinetic.more.net 6.0-RELEASE-p5 FreeBSD 6.0-RELEASE-p5 #1: Tue Mar 21 13:44:15 CST 2006 hendrix and satriani: Dell PowerEdge 2650 2 x 2.8 Ghz P4 2048 MB 2 x 36 GB disks (RAID1) FreeBSD satriani.kinetic.more.net 6.0-RELEASE-p4 FreeBSD 6.0-RELEASE-p4 #0: Tue Mar 7 14:32:43 CST 2006 FreeBSD hendrix.kinetic.more.net 6.0-RELEASE-p5 FreeBSD 6.0-RELEASE-p5 #0: Wed Mar 15 10:54:10 CST 2006 The kernel on both platforms is the same (we include GENERIC and add a couple of options): # QUOTAS_SMP include GENERIC ident MOREnet-SMP maxusers 0 options IPFILTER #ipfilter support options IPFILTER_LOG #ipfilter logging # To make an SMP kernel, the next line is needed options SMP # Symmetric MultiProcessor Kernel options QUOTA Hyper Threading is disabled in the BIOS on all four servers. Thanks, Glenn Nielsen ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ---------------------------------------------------------------------- From owner-freebsd-database@FreeBSD.ORG Wed Mar 22 21:58:38 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EEFB516A425 for ; Wed, 22 Mar 2006 21:58:38 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id F35AC43D5C for ; Wed, 22 Mar 2006 21:58:32 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (76.mnetw.more.net [207.160.138.76]) by libby.lpmo.org (Postfix) with ESMTP id D367D28444 for ; Wed, 22 Mar 2006 15:58:05 -0600 (CST) Received: by gkar.earthdome.org (Postfix, from userid 503) id EF8D7562C96; Wed, 22 Mar 2006 15:55:44 -0600 (CST) Date: Wed, 22 Mar 2006 15:55:44 -0600 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060322215544.GA9720@gkar.earthdome.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i Subject: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Mar 2006 21:58:39 -0000 MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 We recently put four FreeBSD 6.0 servers with MySQL 4.1 into production. MySQL on three of these servers is moderately busy. Each requiring between 60-200 threads to handle anywhere from 6-40 queries per second during business hours. One is a Master DB, the other two are RO Slaves. The fourth where we haven't seen any problems is a hotbackup slave. Since going into production three days ago the Master DB has failed twice. The RO Slaves are failing 1-4 times per hour. In all cases the failure is a signal 10 for a SIGBUS error. The mysqld_safe script successfully restarts mysqld after each failure. I am posting on this list first to see if anyone has any ideas of how to resolve this problem before submitting either a FreeBSD or MySQL bug report. I enabled core files with the "--core-file" argument to the start script. I have examined six core files now. All look very similar. Core was generated by `mysqld'. Program terminated with signal 10, Bus error. (gdb) bt #0 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 #1 0x285190a2 in sigaction () from /usr/lib/libpthread.so.2 #2 0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2 #3 0x0815a1bf in ?? () #4 0x0841b000 in ?? () #5 0x0000000a in ?? () #6 0xbfbfdee8 in ?? () #7 0x0000000a in ?? () #8 0xbfbfe230 in ?? () #9 0x0000000a in ?? () #10 0xbfbfdef8 in ?? () #11 0x080aaf95 in ?? () #12 0x0000000a in ?? () #13 0x0835b8da in ?? () #14 0x000403fb in ?? () #15 0x00000000 in ?? () #16 0xbfbfdf30 in ?? () #17 0x2852c4b4 in ?? () from /usr/lib/libpthread.so.2 #18 0xbfbfdf28 in ?? () #19 0x28517252 in sigaction () from /usr/lib/libpthread.so.2 (gdb) info threads * 166 Thread 0x841b000 (LWP 100330) 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 165 Thread 0x841bc00 (LWP 100188) 0x28529277 in pthread_testcancel () from /usr/lib/libpthread.so.2 164 Thread 0x841be00 (LWP 100206) 0x28529337 in pthread_testcancel () from /usr/lib/libpthread.so.2 163 Thread 0xb22a400 (LWP 100205) 0x28573833 in read () from /lib/libc.so.6 162 Thread 0xb22a600 (LWP 100175) 0x28529277 in pthread_testcancel () from /usr/lib/libpthread.so.2 161 Thread 0xb22a800 (LWP 100211) 0x28529277 in pthread_testcancel () from /usr/lib/libpthread.so.2 160 Thread 0xb22aa00 (LWP 100204) 0x28573833 in read () from /lib/libc.so.6 159 Thread 0xb22ac00 (LWP 100257) 0x28573833 in read () from /lib/libc.so.6 158 Thread 0xb22ae00 (LWP 100258) 0x28573833 in read () from /lib/libc.so.6 157 Thread 0xb2eb000 (LWP 100259) 0x28573833 in read () from /lib/libc.so.6 ... In every case the SIGBUS error is occurring when mysql is killing off some threads. MySQL has a varible for setting the thread_cache_size. By default it is 0, meaning mysql creates threads as needed and kills off threads which are no longer needed almost immediately. We configured the thread_cache_size=50 so that mysql would maintain a pool of threads to reduce the frequency at which it did a thread kill. This has reduced the frequency of failures down to less than once an hour. We are using mysql-server-4.1.18_2 from ports with native threads. Here is some information on the system hardware and kernel config. vai and blackmore: Dell PowerEdge 1850 2x2.8 Ghz P4 1024 MB 2 x 36 GB disks (RAID1) FreeBSD vai.kinetic.more.net 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Mon Jan 30 15:40:24 CST 2006 FreeBSD blackmore.kinetic.more.net 6.0-RELEASE-p5 FreeBSD 6.0-RELEASE-p5 #1: Tue Mar 21 13:44:15 CST 2006 hendrix and satriani: Dell PowerEdge 2650 2 x 2.8 Ghz P4 2048 MB 2 x 36 GB disks (RAID1) FreeBSD satriani.kinetic.more.net 6.0-RELEASE-p4 FreeBSD 6.0-RELEASE-p4 #0: Tue Mar 7 14:32:43 CST 2006 FreeBSD hendrix.kinetic.more.net 6.0-RELEASE-p5 FreeBSD 6.0-RELEASE-p5 #0: Wed Mar 15 10:54:10 CST 2006 The kernel on both platforms is the same (we include GENERIC and add a couple of options): # QUOTAS_SMP include GENERIC ident MOREnet-SMP maxusers 0 options IPFILTER #ipfilter support options IPFILTER_LOG #ipfilter logging # To make an SMP kernel, the next line is needed options SMP # Symmetric MultiProcessor Kernel options QUOTA Hyper Threading is disabled in the BIOS on all four servers. Thanks, Glenn Nielsen ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ---------------------------------------------------------------------- From owner-freebsd-database@FreeBSD.ORG Thu Mar 23 05:48:35 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0BD6E16A400 for ; Thu, 23 Mar 2006 05:48:35 +0000 (UTC) (envelope-from lists@complx.LF.net) Received: from complx.LF.net (complx.LF.net [212.9.190.63]) by mx1.FreeBSD.org (Postfix) with ESMTP id A6D0343D46 for ; Thu, 23 Mar 2006 05:48:34 +0000 (GMT) (envelope-from lists@complx.LF.net) Received: from lists by complx.LF.net with local (Exim 4.43) id 1FMIgR-000CEm-46; Thu, 23 Mar 2006 06:48:31 +0100 Date: Thu, 23 Mar 2006 06:48:31 +0100 From: Kurt Jaeger To: Glenn Nielsen Message-ID: <20060323054831.GA1342@complx.LF.net> References: <20060322215109.GC8904@gkar.earthdome.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060322215109.GC8904@gkar.earthdome.org> Cc: freebsd-database@freebsd.org Subject: Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Mar 2006 05:48:35 -0000 Hi! On Wed, Mar 22, 2006 at 03:51:10PM -0600, Glenn Nielsen wrote: > MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 [...] > (gdb) bt > #0 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 > #1 0x285190a2 in sigaction () from /usr/lib/libpthread.so.2 > #2 0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2 [...] > We are using mysql-server-4.1.18_2 from ports with native threads. There were some discussions on -current and -stable about this topic. See http://bugs.mysql.com/bug.php?id=12251 for some details. Greg seems to work on it somehow. See also http://www.krellis.org/unix-stuff/mysql-freebsd-threads.html and have a look into http://lists.freebsd.org/mailman/htdig/freebsd-stable/2005-March/013241.html There was some discussion on compiling it with linuxthreads instead of pthreads. -- MfG/Best regards, Kurt Jaeger 14 years to go ! LF.net GmbH fon +49 711 90074-23 pi@LF.net Ruppmannstr. 27 fax +49 711 90074-33 D-70565 Stuttgart mob +49 171 3101372 From owner-freebsd-database@FreeBSD.ORG Thu Mar 23 08:19:32 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8D38E16A41F for ; Thu, 23 Mar 2006 08:19:32 +0000 (UTC) (envelope-from justin.bastedo@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by mx1.FreeBSD.org (Postfix) with ESMTP id 16C6C43D4C for ; Thu, 23 Mar 2006 08:19:31 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: by wproxy.gmail.com with SMTP id i5so603351wra for ; Thu, 23 Mar 2006 00:19:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=q9CcxDZHMGuR0s1SBTuOaTWeMEgK/p2Cpgw83ULraPk3ofJETICXAdAQUZNfemjPDx/EsD74bDBuhDRlzyS+I7Cgm7KDqM6+lQMB+sKyHJY467ytFx8f8bYUzZd8YSFVdko53gT7KXoJbMQnYpphKE6brJsPxFmvUwv+CNnc8TQ= Received: by 10.35.50.9 with SMTP id c9mr2361995pyk; Thu, 23 Mar 2006 00:19:07 -0800 (PST) Received: by 10.35.131.1 with HTTP; Thu, 23 Mar 2006 00:19:07 -0800 (PST) Message-ID: <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com> Date: Thu, 23 Mar 2006 00:19:07 -0800 From: "Justin Bastedo" To: "Kurt Jaeger" In-Reply-To: <20060323054831.GA1342@complx.LF.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20060322215109.GC8904@gkar.earthdome.org> <20060323054831.GA1342@complx.LF.net> Cc: freebsd-database@freebsd.org Subject: Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Mar 2006 08:19:32 -0000 There was also this thread on ther freebsd-database list a while back. http://www.daemonnews.org/mailinglists/FreeBSD/freebsd-database/msg01178.ht= ml couldn't search through the actual freebsd site for some reason but google found it. There the author said dropping back down to 4.11 seemed to solve the problem. I am running a MySQL 5 server on a dual, dualcore amd 64 system with a max queries persecond i think we hit was in the 200 - 300 range. If I remember back to the conversations then, I think the problem started to surface at about 500 or so queries persecond. I haven't had any problems with MySQL 5 and I really think its worth the step up. It seems some people at MySQL looked into the problem for that thread I linked to but i don't know if any type of solution was found on the MySQL side. It just seems the 4.x doesn't like the high loads on FreeBSD for some reason. On 3/22/06, Kurt Jaeger wrote: > Hi! -- Justin Bastedo At Gmail Dot Com -------------------------------------------------- http://www.thebastedo.com > > On Wed, Mar 22, 2006 at 03:51:10PM -0600, Glenn Nielsen wrote: > > MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 > [...] > > (gdb) bt > > #0 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 > > #1 0x285190a2 in sigaction () from /usr/lib/libpthread.so.2 > > #2 0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2 > [...] > > We are using mysql-server-4.1.18_2 from ports with native threads. > From owner-freebsd-database@FreeBSD.ORG Thu Mar 23 15:18:54 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 31FFF16A510 for ; Thu, 23 Mar 2006 15:18:54 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id C0A4F43D64 for ; Thu, 23 Mar 2006 15:18:53 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (76.mnetw.more.net [207.160.138.76]) by libby.lpmo.org (Postfix) with ESMTP id E4C042841B for ; Thu, 23 Mar 2006 09:18:18 -0600 (CST) Received: by gkar.earthdome.org (Postfix, from userid 503) id AB445564668; Thu, 23 Mar 2006 09:16:01 -0600 (CST) Date: Thu, 23 Mar 2006 09:16:01 -0600 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060323151601.GA13609@gkar.earthdome.org> References: <20060322215109.GC8904@gkar.earthdome.org> <20060323054831.GA1342@complx.LF.net> <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Subject: Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Mar 2006 15:18:54 -0000 Thanks for the reply. I had already found the below in a Google search. Today I am going to try and reproduce the bug on test box. If I can reproduce the bug I will first try building mysql with linux threads to see if that solves the problem. Glenn On Thu, Mar 23, 2006 at 12:19:07AM -0800, Justin Bastedo wrote: > There was also this thread on ther freebsd-database list a while back. > > http://www.daemonnews.org/mailinglists/FreeBSD/freebsd-database/msg01178.html > > couldn't search through the actual freebsd site for some reason but > google found it. > > There the author said dropping back down to 4.11 seemed to solve the > problem. I am running a MySQL 5 server on a dual, dualcore amd 64 > system with a max queries persecond i think we hit was in the 200 - > 300 range. If I remember back to the conversations then, I think the > problem started to surface at about 500 or so queries persecond. I > haven't had any problems with MySQL 5 and I really think its worth the > step up. It seems some people at MySQL looked into the problem for > that thread I linked to but i don't know if any type of solution was > found on the MySQL side. It just seems the 4.x doesn't like the high > loads on FreeBSD for some reason. > > > > On 3/22/06, Kurt Jaeger wrote: > > Hi! > > -- > Justin Bastedo At Gmail Dot Com > -------------------------------------------------- > http://www.thebastedo.com > > > > > > On Wed, Mar 22, 2006 at 03:51:10PM -0600, Glenn Nielsen wrote: > > > MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 > > [...] > > > (gdb) bt > > > #0 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 > > > #1 0x285190a2 in sigaction () from /usr/lib/libpthread.so.2 > > > #2 0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2 > > [...] > > > We are using mysql-server-4.1.18_2 from ports with native threads. > > ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ---------------------------------------------------------------------- From owner-freebsd-database@FreeBSD.ORG Thu Mar 23 15:20:42 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C478716A400 for ; Thu, 23 Mar 2006 15:20:42 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7167243D46 for ; Thu, 23 Mar 2006 15:20:42 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (76.mnetw.more.net [207.160.138.76]) by libby.lpmo.org (Postfix) with ESMTP id 7B6A02841B for ; Thu, 23 Mar 2006 09:20:10 -0600 (CST) Received: by gkar.earthdome.org (Postfix, from userid 503) id B869E56468F; Thu, 23 Mar 2006 09:17:53 -0600 (CST) Date: Thu, 23 Mar 2006 09:17:53 -0600 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060323151753.GB13609@gkar.earthdome.org> References: <20060322215109.GC8904@gkar.earthdome.org> <20060323054831.GA1342@complx.LF.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060323054831.GA1342@complx.LF.net> User-Agent: Mutt/1.4.2.1i Subject: Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Mar 2006 15:20:42 -0000 Thanks for the reply. I had run across most of your links below in my Google search. Today I am going to try and reproduce the bug on a test box. If I can reproduce the bug the first thing I will try is building mysql with linux threads to see if that solves the problem. Glenn On Thu, Mar 23, 2006 at 06:48:31AM +0100, Kurt Jaeger wrote: > Hi! > > On Wed, Mar 22, 2006 at 03:51:10PM -0600, Glenn Nielsen wrote: > > MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 > [...] > > (gdb) bt > > #0 0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2 > > #1 0x285190a2 in sigaction () from /usr/lib/libpthread.so.2 > > #2 0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2 > [...] > > We are using mysql-server-4.1.18_2 from ports with native threads. > > There were some discussions on -current and -stable about this topic. > > See > > http://bugs.mysql.com/bug.php?id=12251 > > for some details. Greg seems to work on it somehow. > > See also > > http://www.krellis.org/unix-stuff/mysql-freebsd-threads.html > > and have a look into > > http://lists.freebsd.org/mailman/htdig/freebsd-stable/2005-March/013241.html > > There was some discussion on compiling it with linuxthreads instead > of pthreads. > > -- > MfG/Best regards, Kurt Jaeger 14 years to go ! > LF.net GmbH fon +49 711 90074-23 pi@LF.net > Ruppmannstr. 27 fax +49 711 90074-33 > D-70565 Stuttgart mob +49 171 3101372 ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ---------------------------------------------------------------------- From owner-freebsd-database@FreeBSD.ORG Fri Mar 24 12:43:18 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6D79C16A41F for ; Fri, 24 Mar 2006 12:43:18 +0000 (UTC) (envelope-from gatis@is.lv) Received: from smtp1.apollo.lv (smtp1.apollo.lv [80.232.168.211]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8233643D49 for ; Fri, 24 Mar 2006 12:43:16 +0000 (GMT) (envelope-from gatis@is.lv) X-Virusscan: Clamd Received: by smtp1.apollo.lv (CommuniGate Pro PIPE 4.3.5) with PIPE id 98393129; Fri, 24 Mar 2006 14:43:06 +0200 Received: from [194.8.21.33] (HELO D80295) by smtp1.apollo.lv (CommuniGate Pro SMTP 4.3.5) with ESMTP id 98393097 for freebsd-database@freebsd.org; Fri, 24 Mar 2006 14:42:59 +0200 From: "Gatis" To: Date: Fri, 24 Mar 2006 14:42:56 +0200 MIME-Version: 1.0 X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcZPQHm3xIsNLqAhQuiRzaCYm6wbDQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-ID: X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on smtp1.apollo.lv X-Spam-Level: + X-Spam-Status: No, score=2.0 required=7.0 tests=HTML_60_70,HTML_MESSAGE, MSGID_FROM_MTA_ID autolearn=no version=3.0.4 Content-Type: text/plain; charset="windows-1257" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: How many people do you need Oracle Instant Client8 on FreeBSD? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 24 Mar 2006 12:43:18 -0000 Hi! I'd like to know is it possible to get development version of this future port (makefile. config.m4...other files) (http://www.freebsd.org/cgi/query-pr.cgi?pr=3D86580) - i'd like to test = this one? This is a very actual and neccery for me, cause all my servers are running on freebsd and now i'm stucked with a connections to oracle db = over php. Maybe you could to tell oncoming date of this port in current = ports? =20 i'm really waiting for this: build PHP on FBSD with --> --with-oci8 or --with-oci8=3Dinstantclient,/path/to/instantclient/libs or --with-oci8-instant-client=3D/path/to/instantclient/libs =20 i home this feature also will be in php(4|5)-extensions added. =20 p.s maybe you could explain how to get connection to oracle db while = this port is not finished? =20 Gatis Rumbens Vado=F0ais telekomunik=E2ciju in=FEenieris TDVD VSSPN Vad=EEbas sist=E7mu sektors =20