List:General Discussion« Previous MessageNext Message »
From:Benjamin Stillman Date:June 27 2013 5:31pm
Subject:Re: NOW() is stuck...
View as plain text  
Timestamp is a session variable, so it must have been set to something
other than 0 (1372228034 epoch is the date you're showing) in your current
session.


mysql> set timestamp = 1372228034;
Query OK, 0 rows affected (0.00 sec)


mysql> select now(), sysdate();
+---------------------+---------------------+
| now()               | sysdate()           |
+---------------------+---------------------+
| 2013-06-26 02:27:14 | 2013-06-27 13:20:48 |
+---------------------+---------------------+
1 row in set (0.00 sec)


mysql> set timestamp = 0;
Query OK, 0 rows affected (0.00 sec)


mysql> select now(), sysdate();
+---------------------+---------------------+
| now()               | sysdate()           |
+---------------------+---------------------+
| 2013-06-27 13:21:34 | 2013-06-27 13:21:34 |
+---------------------+---------------------+
1 row in set (0.00 sec)



Cliff's notes: set timestamp = 0;








On 6/26/13 6:10 PM, "Andy Wallace" <awallace@stripped> 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
>
>
>--
>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
>


________________________________

Notice: This communication may contain privileged and/or confidential information. If you
are not the intended recipient, please notify the sender by email, and immediately delete
the message and any attachments without copying or disclosing them. LBI may, for any
reason, intercept, access, use, and disclose any information that is communicated by or
through, or which is stored on, its networks, applications, services, and devices.
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