Terry Brown writes:
> Hi All,
>
> This is a bizarre one and I'm very confused so I thought the list may be
> able to help.
>
> I've been running mysql 3.22.25 for some time now without any problems but
> last week, decided to upgrade some of our system software so I downloaded
> mysql (3.22.26) along with all of our the latest gnu software (fileutils,
> findutils, .... all of the general packages + gcc 2.95.1 (we were running
> 2.95)).
>
> After the upgrade, I can retrieve lines from the database with dates in but
> if I ask for something on a specific date (e.g. '1999-10-20') I get a core
> dump and lose the connection to the database.
>
> I can see the core file in /usr/local/var but have no idea how to analyse
> it to see what went wrong (I'm only a baby sys-admin!). I have since tried
> downgrading to 3.22.25 but the same problem persists so I'm wondering if
> it's been one of the gnu distributions that's messed it up?
>
> Rather than overloading people now with every piece of information I have,
> could people give me some idea as to what they would need to know before I
> can get round to solving the problem?
>
> Many thanks,
> Terry
Hi Terry,
First, please check your tables with isamchk.
If the tables are ok and you still get core dumps, please configure
MySQL with --with-debug, start mysqld with options --debug and --log
and include the output from both the log file and trace file when the
core dump happens.
You can find more information about debugging under section
'Debugging a MySQL server' from the manual.
Regards,
- Jani
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
