From owner-freebsd-ports@FreeBSD.ORG Thu Mar 10 18:19:37 2005 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EC83E16A4CE; Thu, 10 Mar 2005 18:19:36 +0000 (GMT) Received: from mail.terralink.de (mail.tlink.de [217.9.16.16]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0E6C543D3F; Thu, 10 Mar 2005 18:19:36 +0000 (GMT) (envelope-from me@daniel.stefan.haischt.name) Received: from smtp.abyssworld.de (daniel-s-haischt.biz [84.252.66.2]) by mail.terralink.de (Postfix) with ESMTP id 57BA3B92C; Thu, 10 Mar 2005 19:19:35 +0100 (CET) Received-SPF: none (smtp.abyssworld.de: 192.168.1.6 is neither permitted nor denied by domain of daniel.stefan.haischt.name) client-ip=192.168.1.6; envelope-from=me@daniel.stefan.haischt.name; helo=[192.168.120.239]; Received: from [192.168.120.239] (smtp.abyssworld.de [192.168.1.6]) by smtp.abyssworld.de (Postfix) with ESMTP id CA899173FC; Thu, 10 Mar 2005 19:19:21 +0100 (CET) Message-ID: <42308FA6.1000701@daniel.stefan.haischt.name> Date: Thu, 10 Mar 2005 19:19:18 +0100 From: "Daniel S. Haischt" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: ale@FreeBSD.org X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------020408030306070401000805" X-Processed-By: GNU Anubis v4.0 X-Purified-With: DSPAM, Clam AntiVirus cc: ports@FreeBSD.org Subject: FreeBSD Port: mysql-scripts-5.0.2_1 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: me@daniel.stefan.haischt.name List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 10 Mar 2005 18:19:37 -0000 --------------020408030306070401000805 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Hello, I am using MySQL 5.x on FreeBSD 5.4-PRE together with libpthread. These are the knobs I did provide to make: FORCE_PKG_REGISTER=yes \ WITH_OPENSSL=yes \ BUILD_OPTIMIZED=yes \ WITH_PROC_SCOPE_PTH=yes If executing the following SQL query, mysqld will quit with a SIGSEGV signal. SELECT post_urltitle FROM evo_posts WHERE post_urltitle REGEXP '^erster_eintrag(_[0-9]+)?$' AND ID <> 0; Attached you will find the transscript of a complete GDB session. Do you think this is a MySQL bug or could it be that this is an issue only found on FreeBSD systems? -- Mit freundlichen Gruessen / With kind regards DAn.I.El S. Haischt Want a complete signature??? Type at a shell prompt: $ > finger -l haischt@daniel.stefan.haischt.name --------------020408030306070401000805 Content-Type: text/plain; name="mysqld-gdb-trace.txt" Content-Transfer-Encoding: 8bit Content-Disposition: inline; filename="mysqld-gdb-trace.txt" Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 5.0.2-alpha-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SELECT post_urltitle FROM evo_posts WHERE post_urltitle REGEXP '^erster_eintrag(_[0-9]+)?$' AND ID <> 0; **** (gdb) set args --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/abyssone.abyssworld.de.pid --bind-address=192.168.120.29 (gdb) run Starting program: /usr/ports/databases/mysql50-server/work/mysql-5.0.2-alpha/sql/mysqld --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/abyssone.abyssworld.de.pid --bind-address=192.168.120.29 050310 19:05:42 InnoDB: Started; log sequence number 0 44764 /usr/ports/databases/mysql50-server/work/mysql-5.0.2-alpha/sql/mysqld: ready for connections. Version: '5.0.2-alpha-debug' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.2 Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 3 (LWP 100348)] p_ere (p=0xbf8ed5f0, stop=128) at regcomp.c:866 866 else if (my_islower(charset,ch)) Current language: auto; currently c (gdb) bt full #0 p_ere (p=0xbf8ed5f0, stop=128) at regcomp.c:866 c = 0 '\0' prevback = 188671256 prevfwd = 188671256 conc = 1 first = 1 #1 0x084022e4 in regcomp (preg=0xb3ed478, pattern=0xa5bcb20 "^erster_eintrag(_[0-9]+)?$", cflags=186002432, charset=0xb162c50) at regcomp.c:177 pa = {next = 0xa5bcb22 "rster_eintrag(_[0-9]+)?$", end = 0xa5bcb3a "", error = 0, strip = 0xb176500, ssize = 40, slen = 2, ncsalloc = 0, g = 0xb162c00, pbegin = {0, 0, 0, 0, 0, 0, 0, 0, 0, 0}, pend = {0, 0, 0, 0, 0, 0, 0, 0, 0, 0}, charset = 0x84cf280} g = (struct re_guts *) 0xb162c00 i = 0 len = 186002512 #2 0x0807feb6 in Item_func_regex::fix_fields (this=0xb3ed408, thd=0x1a, tables=0xb3ed478, ref=0xb3ed704) at sql_string.h:89 buff = "\000\000\000\000\004×\216¿\030×\216¿@\204\020\bg\b\000\000üÖ\216¿\000×\216¿\004×\216¿\000\000\000\000\000\000\000\000\000\000\001", '\0' , "°Ð>\vxÑ>\v\020Ñ>\vhØ\216¿\\\211\020\b\000p\033\vxÑ>\v Ð>\v Ð>\v\r\000\000\000<Ñ>\v\000\000\000\000\000\000\000\000\001\000\000\000\020Ñ>\v\001\000\000\000\000\000\000\000a\224F\ba\224F\001\r\000\000\000 Ð>\v\000\000\000\000\000\000\000\000àØ\034\v\000\000\000\001", '\0' , "\001\000\000\000ðä>\v\000p\033\vÈÚ\216¿Ð`\005\b\000p\033\v°Ð>\vÈÚ\216¿\200a\005\bà"... tmp = {Ptr = 0xbf8ed6d0 "", str_length = 766, Alloced_length = 766, alloced = false, str_charset = 0x84e8440} res = (class String *) 0x84cf280 error = 0 __func__ = "fix_fields" #3 0x0807eb49 in Item_cond::fix_fields (this=0xb3ed660, thd=0xb1b7000, tables=0xb3ed178, ref=0xb3ee4ac) at sql_list.h:323 tmp_table_map = Unhandled dwarf expression opcode 0x93 --------------020408030306070401000805--