Re: Problem doing SELECTs with date fields

[Terry Brown]

At 13:49 04/10/99, Jani Tolonen wrote:
>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.

Hi All,

Firstly, the problem is solved, this is just FYI.

All the tables were fine 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.
I had a look through the debugging chapter of the manual and used the 
configure line suggested there:

CC=gcc CFLAGS="-O6" CXX=gcc CXXFLAGS="-O6 -felide-constructors 
-fno-exceptions -fno-rtti" ./configure

and this seemed to do the trick.

As I said, we are using gcc2.95.1 which had only recently been 
upgraded.  Still not sure what the problem was but using the above line did 
fix it.  My c/c++ is non existent, are there any implications for running a 
production server with a mysqld configured with this command line (what do 
all of the options mean)?

Many thanks to all for pointing me in the right direction.
Terry

________________________________________________________
Terry Brown				http://numedsun.ncl.ac.uk/
	C&IT Development Officer		
	UNIX System Administrator

Faculty of Medicine Computing Centre, University of Newcastle,
NE2 4HH     Tel: [phone]	Fax: [phone]