RAC Nodes with Time Wrong on One Node - Database Discussions
This is a discussion on RAC Nodes with Time Wrong on One Node - Database Discussions ; We have two RAC nodes, one shows 2pm and the other shows 3pm. I am assuming this is a DST issue. However, if I select sysdate from dual: ten times, I will get 2pm and 3pm interspersed, and it appears ...
 |
| | LinkBack | Thread Tools | Display Modes |
|
#1
11-05-2009, 04:09 PM
| |||
| |||
 RAC Nodes with Time Wrong on One Node I am assuming this is a DST issue. However, if I select sysdate from dual: ten times, I will get 2pm and 3pm interspersed, and it appears that data rows are being timestamped with either the right time or the right time + 1 hour (2pm vs 3pm) depending upon their node. Why doesn't RAC evict the server with the bad time? Is it because it is the "right" time but with DST turned off while the other also has the right time with DST turned on? If we correct the wrong server's DST setting, will the dates that are stored as timestamps on the data rows still be wrong or will they recognize the change in DST? We are using Sun Solaris.  |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Best setup with 4 Nodes | Database Administrator | sqlserver-server | 1 | 09-26-2008 05:48 PM |
| Feedback for WHILE diagram being wrong | Database Administrator | sqlserver-programming | 1 | 04-17-2008 11:37 AM |
| Can I add nodes to a cluster without restarting it? | domregchief | mysql | 0 | 04-14-2008 04:39 AM |
| Can I run multiple nodes on a single computer? | domregchief | mysql | 0 | 04-14-2008 04:37 AM |
| [GENERAL] wrong query result | Database Administrator | postgresql | 0 | 04-09-2008 04:24 AM |
All times are GMT -4. The time now is 09:21 AM.
