[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Date problem
From:       Van <vanboers () dedserius ! com>
Date:       1999-08-29 1:52:12
[Download RAW message or body]

Danny,
How about changing your date field to a datetime field.  This, in addition
to Monty's logging suggestion could give you a clue as to what's
happening.
Van 

=========================================================================
Linux rocks!!!   http://www.dedserius.com
=========================================================================

On Sun, 29 Aug 1999, Michael Widenius wrote:

> >>>>> "Danny" == Danny Arseneau <danny@mamma.com> writes:
> 
> Danny> Hi guys, I hope that someone can help me out here. We are using mysql to
> Danny> store various bits of data about activity on our website. For each visit
> Danny> to our site we insert some information into a table.
> 
> Danny> The table is defined as follows
> 
> Danny> table queries
> Danny> (
> Danny>     query  char(255),
> Danny>     querydate date,
> Danny>     qtype int,
> Danny>     partner char(30)
> Danny>     primary key (querydate)
> Danny> );
> 
> 
> Danny> We use the following insert query
> 
> Danny> insert into queries (query, querydate, qtype, partner) values ('XXXXX',
> Danny> now(), 1, 'XXXXXX');
> 
> Danny> This query is performed approximately 140,000 times a day from 5
> Danny> different servers.
> 
> Danny> Our problem is that after about 4 days we see about 20 entries where the
> Danny> field querydate is set to (0000-00-00).
> 
> Danny> Has anyone else seen this behaviour? Is there something wrong with our
> Danny> setup? What could possibly be causing this to happen?
> 
> Danny> We are running mysql-3.22.19 on a Dual Pentium III (550Mhz) with RedHat
> Danny> Linux 6.0
> Danny> -- 
> 
> Danny> Danny Arseneau
> Danny> Chief Technology Officer
> Danny> Mamma Systems Inc.
> 
> Hi!
> 
> Sorry, but this is not a known problem :(
> 
> Any change you can run mysqld with --log and try to find one of the
> wrong rows in the log to verify this?
> 
> Regards,
> Monty
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread11637@lists.mysql.com
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@lists.mysql.com instead.
> 


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread11638@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]