List:General Discussion« Previous MessageNext Message »
From:John Meyer Date:June 26 2013 11:18pm
Subject:Re: NOW() is stuck...
View as plain text  
Well, if you want to get unstuck in time, maybe you need to call Billy 
Pilgrim ;-)
Andy Wallace wrote:
> 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
>
>

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