Fwd: Found there the problem with core dump is.

[Michael Widenius]

Hi!

Peter> Yesterday I wrote about core dump. Now I have found the query which
Peter> crases MYSQLD 3.23.8. Of couse this is not to nice to use such queries
Peter> and I allready told our programmers not to use this query but this is
Peter> anyway is not too good behavior for mysqld to core dump because of
Peter> some internal limits:

Peter> Here is the query:

Peter>  SELECT ct00l02groups.link, ct00l02groups.level, ct00l02groups.id,
Peter>                  group_lang.name, md_rights.group_id 
Peter>           FROM ct00l02groups
Peter>           LEFT OUTER JOIN md_rights ON 
Peter>                  md_rights.group_id=ct00l02groups.id AND 
Peter>                  md_rights.moderator='1', group_lang 
Peter>           WHERE  ( ct00l02groups.id=0 OR ct00l02groups.id=1 OR ct00l02groups.id=2 OR ct00l02groups.id=3 OR ct00l02groups.id=4 OR ct00l02groups.id=5 OR ct00l02groups.id=6 OR ct00l02groups.id=7 OR ct00l02groups.id=8 OR ct00l02groups.id=9 OR ct00l02groups.id=10 OR ct00l02groups.id=11 OR ct00l02groups.id=12 OR ct00l02groups.id=13 OR ct00l02groups.id=14 OR ct00l02groups.id=17 OR ct00l02groups.id=18 OR ct00l02groups.id=19 OR ct00l02groups.id=20 OR ct00l02groups.id=21 OR ct00l02groups.id=22 OR ct00l02groups.id=23 OR ct00l02groups.id=24 OR ct00l02groups.id=25 OR ct00l02groups.id=26 OR ct00l02groups.id=27 OR ct00l02groups.id=28 OR ct00l02groups.id=29 OR ct00l02groups.id=30 OR ct00l02groups.id=31 OR ct00l02groups.id=32 OR ct00l02groups.id=33 OR ct00l02groups.id=34 OR ct00l02groups.id=35 OR ct00l02groups.id=36 OR ct00l02groups.id=37 OR ct00l02groups.id=38 OR ct00l02groups.id=39 OR ct00l02groups.id=40 OR ct00l02groups.id=41 OR ct00l02groups.id=42 OR ct00l02groups.id=43 OR ct00l02groups.id!
<cut>

Can you mail me a copy of the tables with about 10 rows / table ?

Anyway, if this is a stack problem, you can proably fix this by
starting mysqld with:

-O thread_stack=128K

You can also change the query to be:


.. WHERE (ct00l02groups.id in (0,1,2,3,4,...))

which is MUCH faster than the OR as MySQL uses a binary search on the
IN part.

Anyway, I would like to have a copy of the tables to fix the core dump

Regards,
Monty