Serge Paquin wrote:
>
> I've been having some problems over the last few days with regard to a
> large query that I need to run which has started to crash the server
> EVERY TIME the query is run.
>
> I think I have localized the problem to RedHat Linux Enterprise
> Edition. It has changes some low level disk IO stuff (that's what the
> docs say anyway). I have used mysqldump to dump the database off of a
> running system using redhat linux 6.2 (the free one). To test I
> reimported it on that same system with no problem the query runs fine.
>
> I then try to import into a system running the Enterprise Edition and it
> crashes the server. I then tried another system that I have also
> running the Enterprise edition of Linux and it crashes MySQL their also.
>
> Is their any known issues with this? I have tried the source RPM and
> the binary RPM to see if it was a compile problem but they both give the
> same effect..
>
> Does anyone have any ideas? I could build from the tar.gz file but I'm
> not sure if that would have any change from the source RPM.
>
> Any input would be appriciated.
>
> Serge.
From your experiences, the solution seems quite obvious - do not use the
Enterprise Edition until they have fixed their bugs :-)
You can send a bug report to them in the form of MySQL crashing the server with
your query on your tables.
--
Sasha Pachev
+------------------------------------------------------------------+
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
