[Rt-devel] wrong time inserted into sessions table on Pg 8.1.3

[k b]

Hi.
I am testing out RT 3.6.0pre0, but i have the same
problem om 3.5.7.
i am using RT with Postgresgql 8.1.3 that does not run
on the same machine as apache. 

when i log in (only tested with root) i get logged in,
then as soon as i click a link, the login screen is
presented to me, if i log in again, the same thing
happens again.

so, i had a look in the sessions table in the database
and found out that:
a. the time in the column lastupdated is exactly one
hour less then the real time.
b. the lastupdated column is not updated when i log in
a second time.

both the machines in question (web server and db
server), are running FC4 with all updates.
if i give the clock command they show,
[root at web]# clock
Sun 26 Feb 2006 10:41:41 AM CET  -0.744519 seconds

[root at sql]# clock
Sun 26 Feb 2006 10:42:20 AM CET  -0.626471 seconds

CET = central european time.
the clocks are not perfectly synchronized but still
not one hour apart.



for the current session i can see the following in the
sessions table:

rt3=# select lastupdated from sessions order by
lastupdated desc limit 1;
        lastupdated
----------------------------
 2006-02-26 09:40:16.497154
(1 row)


(as you can see, this is one hour wrong, compared to
the clock output).




if i manually insert a row into the sessions table i
get the following:

rt3=# start transaction;
START TRANSACTION
rt3=# insert into sessions(id, a_session)
values('123', 'B');
INSERT 0 1
rt3=# select * from sessions order by lastupdated desc
limit 1;
                id                | a_session |       
lastupdated
----------------------------------+-----------+---------------------------
 123                              | B         |
2006-02-26 10:46:51.59215
(1 row)

rt3=# rollback;
ROLLBACK


as you can see, the time is given correctly this time.
so it feels like something is happening within the
RT-code, something that tries to fix something with
the time but fails.


end of report
Karl

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com