On Thursday 22 March 2007 22:49:38 Christian Hammers wrote:
> tags 415898 + moreinfo
>
> Hello Ricardo
>
> On 2007-03-22 Ricardo Galli wrote:
> > The server dies with the SELECT query shown below. The three times
> > occured right after a WHERE MATCH () AGAINST ('"word"' IN BOOLEAN MODE)
> > where " were used and the word's first character was an utf-8 accented
> > char.
>
> Please send me a "mysqldump --opt ... links" dump and preferably the
> binary files from /var/lib/mysql/<database>/links.* so that I can verify
> the problem. If they contain private data just send me the output from
> "SHOW CREATE TABLE links;" and maybe one or two example lines that can be
> used to try your query.
I just created a tar.bz2, it's about 84 MB, so you can downloaded from
http://meneame.net/archives/links.tar.bz2
I just checked last logs and found another which stored the last sql, which is
similar:
Mar 20 22:15:02 web4 mysqld[12222]: Trying to get some variables.
Mar 20 22:15:02 web4 mysqld[12222]: Some pointers may be invalid and cause the
dump to abort...
Mar 20 22:15:02 web4 mysqld[12222]: thd->query at 0xd77690 = SELECT count(*)
FROM links WHERE MATCH (link_url, link_url_title, link_title, link_content,
link_tags) AGAINST ('"único"' IN BOOLEAN MODE) AND (link_status != 'discard'
OR (link_status = 'discard' AND link_date > date_sub(now(), interval 7 day)
AND link_votes > 0))
Thanks,
--
ricardo galli GPG id C8114D34
http://mnm.uib.es/gallir/
