[Building Sakai] Problem with clustering??

[Matthew Jones]

Hi Omer,

I messaged to Dave Horwitz some concerns about this on
https://jira.sakaiproject.org/browse/KNL-734
and
https://jira.sakaiproject.org/browse/KNL-725

The intention was to fix cluster problems when daylight savings time
changed, but it seemed like it would break more than it would fix. He
assured me that there was research done that all of this was safe, but I
don't have any way to test on Oracle (and not much vested interest in
Oracle) so accepted this.

Oracle is kind of tricky because it has 3 time zone types

   -

   TIMESTAMP <http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006050>(No
   timezone data stored, stored as-is)
   -

   TIMESTAMP WITH TIME ZONE
<http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006081>(Timezone
   data actually stored in the column)
   -

   TIMESTAMP WITH LOCAL TIME ZONE
<http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006169>(Time
   stored as in TIMESTAMP, but time returned as if timezone stored on demand)

These columns got changed from DATE (In oracle) to TIMESTAMP WITH TIMEZONE.
In mysql they got changed from DATETIME to TIMESTAMP. In oracle the
datatype contains timezone information where in mysql it doesn't, because
mysql doesn't have a TIMESTAMP WITH TIME ZONE equivalent..

It's very likely it should have been converted to TIMESTAMP WITH LOCAL TIME
ZONE. Then it would have been at least equal to Mysql.

I'm less sure about this fix now, but still don't have a great way to test
it.

On Wed, Sep 26, 2012 at 6:11 PM, Omer A Piperdi <omer at rice.edu> wrote:

> We are seeing that sakai_cluster table is storing the wrong
> 'UPDATE_TIME'. Because UPDATE_TIME is converted to timestamp in 2.9 in
> Oracle. It should be writing 'GMT minus or plus your time zone' but it
> is updating the current time.
>
> Does anyone running 2.9 on Oracle 11g?
>
> Thanks
> Omer
> On 9/20/2012 11:47 AM, Omer A Piperdi wrote:
> > Hi,
> >
> > We are seeing app. server disappearing from sakai_cluster table, which
> > leads to closing the session like below from server which is still in
> pool.
> >
> > 2012-09-12 15:56:29,113  INFO SakaiClusterService.Maintenance
> > org.sakaiproject.cluster.impl.SakaiClusterService - Closed 2 orphaned
> > usage session records
> > 2012-09-12 15:57:29,191  INFO SakaiClusterService.Maintenance
> > org.sakaiproject.cluster.impl.SakaiClusterService - Closed 1 orphaned
> > usage session records
> >
> > Any idea or suggestion? This is on 2.9.x and Oracle 11g.
> >
> > Thanks
> > Omer
> > _______________________________________________
> > sakai-dev mailing list
> > sakai-dev at collab.sakaiproject.org
> > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> >
> > TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
> >
> > !DSPAM:2294,505b48b5192264830910053!
> >
> >
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120926/7a836173/attachment.html