List:General Discussion« Previous MessageNext Message »
From:Rick James Date:June 26 2013 11:08pm
Subject:RE: NOW() is stuck...
View as plain text  
Submit a bug:
http://bugs.mysql.com
Alas, you probably cannot provide a reproducible test case.  Still, someone might start at
the code and discover a possible cause.

> -----Original Message-----
> From: Andy Wallace [mailto:awallace@stripped]
> Sent: Wednesday, June 26, 2013 3:10 PM
> To: mysql list
> Subject: NOW() is stuck...
> 
> We've been having some issues with one of our MySQL servers lately, and
> currently the dang thing is "stuck". For at least the last hour, NOW() is
> returning the same
> value:
> 
> mysql> select now();
> +---------------------+
> | now()               |
> +---------------------+
> | 2013-06-26 02:27:14 |
> +---------------------+
> 
> The system variable "timestamp" also has that same time value stored in
> it. How can we kick this loose so that the values are more current with
> real time? (it is currently 3:08PM here, despite our MySQL instance
> thinking it's 2am. The system time on the machine is correct:
> 
> $ date
> Wed Jun 26 15:08:56 PDT 2013
> 
> 
> This is MySQL 5.1.46 running on solaris2.10.
> 
> Any ideas short of restarting the MySQL engine? I'm willing to do that,
> but would much rather wait and not do it in the middle of the day.
> 
> Thanks,
> Andy
> 
> 
> --
> Andy Wallace
> iHOUSEweb, Inc.
> awallace@stripped
> (866) 645-7700 ext 219
> --
> "Sometimes it pays to stay in bed on Monday, rather than spending the rest
> of the week debugging Monday's code."
> - Christopher Thompson
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
NOW() is stuck...Andy Wallace26 Jun
  • RE: NOW() is stuck...Rick James26 Jun
  • Re: NOW() is stuck...John Meyer26 Jun
    • Re: NOW() is stuck...Eric Bergen27 Jun
      • Re: NOW() is stuck...Andy Wallace27 Jun
        • Re: NOW() is stuck...Nick Khamis27 Jun
          • Re: NOW() is stuck...Andy Wallace27 Jun
  • Re: NOW() is stuck...Benjamin Stillman27 Jun
    • Re: NOW() is stuck...Andy Wallace27 Jun
      • Re: NOW() is stuck...Benjamin Stillman27 Jun
        • Re: NOW() is stuck...Andy Wallace27 Jun
          • Re: NOW() is stuck...Eric Bergen27 Jun
            • Re: NOW() is stuck...Andy Wallace27 Jun
          • Re: NOW() is stuck...Claudio Nanni27 Jun
            • Re: NOW() is stuck...Andy Wallace27 Jun
          • Re: NOW() is stuck...walter harms28 Jun
            • Re: NOW() is stuck...Andy Wallace28 Jun
              • Re: NOW() is stuck...Claudio Nanni28 Jun
Re: NOW() is stuck...Johan De Meersman27 Jun