Date: Thu, 10 Mar 2005 19:19:18 +0100 From: "Daniel S. Haischt" <me@daniel.stefan.haischt.name> To: ale@FreeBSD.org Cc: ports@FreeBSD.org Subject: FreeBSD Port: mysql-scripts-5.0.2_1 Message-ID: <42308FA6.1000701@daniel.stefan.haischt.name>
next in thread | raw e-mail | index | archive | help
--------------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' <repeats 17 times>, "°Ð>\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' <repeats 236 times>, "\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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42308FA6.1000701>