uPortal IRC Logs-2009-05-13

Owned by Apereo Infrastructure
Last updated: May 13, 2009Version comment
6 min read

[03:22:17 EDT(-0400)] * higmad (n=chatzill@pcit-8752.HIG.SE) has joined ##uportal
[08:17:16 EDT(-0400)] * tsnfoo (n=tsnfoo@cpe-173-88-27-191.columbus.res.rr.com) has joined ##uportal
[08:33:34 EDT(-0400)] * fj4000 (n=Main@CPE0018f85ab63e-CM001692f5798c.cpe.net.cable.rogers.com) has joined ##uportal
[09:03:41 EDT(-0400)] * tsnfoo (n=tsnfoo@wso-mbp15.test.denison.edu) has joined ##uportal
[09:16:06 EDT(-0400)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[10:04:28 EDT(-0400)] <Tuomaz> athena: did you run at 2am??
[10:04:46 EDT(-0400)] <athena> i did not
[10:04:52 EDT(-0400)] <athena> (smile)
[10:48:53 EDT(-0400)] * michelled (n=michelle@142.150.154.193) has joined ##uportal
[10:59:48 EDT(-0400)] * michelled (n=team@142.150.154.193) has joined ##uportal
[11:07:29 EDT(-0400)] * EricDalquist (n=dalquist@bohemia.doit.wisc.edu) has joined ##uportal
[11:21:39 EDT(-0400)] * jessm (n=Jess@c-71-232-1-65.hsd1.ma.comcast.net) has joined ##uportal
[11:37:27 EDT(-0400)] * holdorph (n=holdorph@uni1.unicon.net) has joined ##uportal
[11:37:41 EDT(-0400)] * lennard2 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[12:32:07 EDT(-0400)] * holdorph (n=holdorph@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[13:24:44 EDT(-0400)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[13:28:02 EDT(-0400)] * EricDalquist (n=dalquist@bohemia.doit.wisc.edu) has joined ##uportal
[13:32:02 EDT(-0400)] * Sememmon (n=Sememmon@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[14:53:08 EDT(-0400)] * SusanBramhall (i=susanbra@susan-x200.its.yale.edu) has joined ##uportal
[14:54:56 EDT(-0400)] <SusanBramhall> i have a question about db stats logger in 3.1 for EricDalquist
[14:55:04 EDT(-0400)] <EricDalquist> hi SusanBramhall
[14:55:07 EDT(-0400)] <EricDalquist> what's up?
[14:55:09 EDT(-0400)] <SusanBramhall> hi
[14:55:13 EDT(-0400)] <EricDalquist> other than lack of documentation (sad)
[14:55:50 EDT(-0400)] <SusanBramhall> the wiki says the db stats logger is off by default but turns out is got turned on in last revision
[14:56:08 EDT(-0400)] <SusanBramhall> i discovered the growing tables by accident...
[14:56:28 EDT(-0400)] <EricDalquist> oh
[14:56:34 EDT(-0400)] <EricDalquist> oops
[14:56:38 EDT(-0400)] <EricDalquist> it should be off by default
[14:56:47 EDT(-0400)] <EricDalquist> can you file a Jira issue?
[14:56:49 EDT(-0400)] <SusanBramhall> should the uncommented portions of statsContext be reverted
[14:56:56 EDT(-0400)] <EricDalquist> yes
[14:57:11 EDT(-0400)] <EricDalquist> and I think there is a reference in schedulerContext too
[14:57:41 EDT(-0400)] <SusanBramhall> happy to jira but i guess i better get it out of the release we just tagged for production first... heh
[14:58:17 EDT(-0400)] <SusanBramhall> thanks!
[14:58:19 EDT(-0400)] <EricDalquist> yup
[15:12:08 EDT(-0400)] <athena> EricDalquist: i noticed that the getChannel(id) and getChannel(fname) methods behave differently
[15:12:26 EDT(-0400)] <EricDalquist> ?
[15:12:29 EDT(-0400)] <athena> getting a channel by id grabs the locale metadata and portlet preferences, which the fname version doesn't
[15:12:36 EDT(-0400)] <athena> is that how it's supposed to be?
[15:12:45 EDT(-0400)] <EricDalquist> what are we talking about?
[15:13:10 EDT(-0400)] <athena> ugh, sorry
[15:13:10 EDT(-0400)] <athena> lol
[15:13:19 EDT(-0400)] * athena has clearly been too far buried in code all day
[15:13:23 EDT(-0400)] * michelled (n=team@142.150.154.193) has left ##uportal
[15:13:31 EDT(-0400)] <athena> i'm looking at the existing RDBMChannelRegistryStore code
[15:13:41 EDT(-0400)] <athena> and slowly moving pieces over into JPA
[15:14:08 EDT(-0400)] <EricDalquist> ah
[15:14:14 EDT(-0400)] * dstn (n=dstn@unaffiliated/dstn) has joined ##uportal
[15:15:05 EDT(-0400)] <EricDalquist> I don't see getChannel methods in RDBMChannelRegistryStore
[15:15:45 EDT(-0400)] <athena> getChannelDefinition, rather
[15:15:50 EDT(-0400)] <athena> starts around line 355
[15:15:51 EDT(-0400)] <EricDalquist> ah ok
[15:16:05 EDT(-0400)] <athena> oh!
[15:16:17 EDT(-0400)] <athena> apparently it actually calls the get by id method
[15:16:18 EDT(-0400)] <athena> ouch.
[15:16:28 EDT(-0400)] <athena> so it does a sql query to figure out the id
[15:16:31 EDT(-0400)] <athena> then calls the get by id
[15:16:34 EDT(-0400)] <EricDalquist> ah
[15:16:39 EDT(-0400)] <athena> well, i guess that explains that - never mind
[15:16:39 EDT(-0400)] <EricDalquist> neat
[15:16:49 EDT(-0400)] <athena> for some interesting definition of neat (smile)
[15:16:53 EDT(-0400)] <EricDalquist> lol
[15:17:10 EDT(-0400)] <EricDalquist> the neat part will be when you replace that 1200 lines of code with a about 150
[15:17:27 EDT(-0400)] <athena> yes
[15:17:28 EDT(-0400)] <EricDalquist> with better db support, referential integrity and caching
[15:17:30 EDT(-0400)] <athena> hoping we can get there
[15:17:45 EDT(-0400)] <athena> just realized we can't map the existing channel parameter table as an entity, as it has no id
[15:19:29 EDT(-0400)] <dstn> so I have a question...
[15:19:40 EDT(-0400)] <dstn> based on reading http://www.ja-sig.org/wiki/display/UPC/Database+Event+Logger
[15:19:50 EDT(-0400)] <EricDalquist> yeah ... I figured with any -> JPA conversion we're going to be redoing the object model
[15:20:01 EDT(-0400)] <dstn> nm, susan already asked
[15:20:04 EDT(-0400)] <EricDalquist> a lot of it just wasn't setup well for a CRUD type layer
[15:20:07 EDT(-0400)] <EricDalquist> (smile)
[15:20:08 EDT(-0400)] <athena> yeah
[15:20:16 EDT(-0400)] <athena> the problem is that we're working with pretty limited time here
[15:20:23 EDT(-0400)] <EricDalquist> yeah
[15:20:34 EDT(-0400)] <athena> i'm sort of hoping to do the bare minimum to point us in the right direction, and we can iteratively improve it
[15:20:53 EDT(-0400)] <athena> i'd like to check in something at the end of the week which is a working improvement
[15:21:31 EDT(-0400)] <EricDalquist> sounds grea
[15:21:33 EDT(-0400)] <EricDalquist> great
[16:07:11 EDT(-0400)] * SusanB (i=susanbra@vpn128036126049.central.yale.edu) has joined ##uportal
[16:17:06 EDT(-0400)] * athena cheers
[16:17:22 EDT(-0400)] <athena> i have the portal coming up reading channels and parameters via jpa!
[16:18:19 EDT(-0400)] <EricDalquist> yay!
[16:18:40 EDT(-0400)] <athena> yeah (smile)
[16:18:56 EDT(-0400)] <athena> now i can look at wiring in the persistence half of the code
[16:19:27 EDT(-0400)] <athena> i was able to set it up without changing the data model
[16:19:33 EDT(-0400)] <athena> presumaby we'll eventually want to do that
[16:19:46 EDT(-0400)] <athena> but hopefully having the code dumped into jpa will make it easier to modify later
[16:20:17 EDT(-0400)] <athena> the one thing that probably has to change is the id generation
[16:20:18 EDT(-0400)] <EricDalquist> yeah
[16:20:23 EDT(-0400)] <EricDalquist> yeah
[16:20:33 EDT(-0400)] <EricDalquist> it would be very good to use the idgen approach the portlet objects are using
[16:20:48 EDT(-0400)] <EricDalquist> instead of the uportal custom sequence code
[16:20:52 EDT(-0400)] <athena> yeah
[16:21:18 EDT(-0400)] <athena> i'm assuming that will mean one will have to do an initdb to get the portal running after this commit
[16:21:33 EDT(-0400)] <athena> since the sequences might not match up
[16:21:53 EDT(-0400)] <EricDalquist> yup
[16:22:23 EDT(-0400)] <EricDalquist> I'm assuming the CP_CHANNEL table has different constraints on it now too
[16:22:31 EDT(-0400)] <EricDalquist> er UP_*
[16:22:40 EDT(-0400)] <EricDalquist> so we can remove that from tables.xml
[16:22:47 EDT(-0400)] <EricDalquist> along with the params table hopefully too
[16:23:56 EDT(-0400)] <athena> yeah
[16:23:59 EDT(-0400)] <athena> that's my hope
[16:24:35 EDT(-0400)] <athena> we'll probably need to take a look and see what we really want for indices, allowable null columns, etc.
[16:24:41 EDT(-0400)] <EricDalquist> yup
[17:00:47 EDT(-0400)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has left ##uportal
[17:05:10 EDT(-0400)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[17:35:43 EDT(-0400)] <athena> hm.
[17:35:46 EDT(-0400)] <athena> so, this finally worked
[17:35:53 EDT(-0400)] <athena> but i'm wondering if something's broken in the trunk
[17:36:05 EDT(-0400)] <EricDalquist> other problems?
[17:36:08 EDT(-0400)] <athena> yeah
[17:36:19 EDT(-0400)] <athena> have you tried running an "ant initdb" lately in trunk?
[17:36:25 EDT(-0400)] <athena> i'm getting
[17:36:26 EDT(-0400)] <athena> Caused by: org.postgresql.util.PSQLException: ERROR: column "layout_id" is of type integer but expression is of type character varying
[17:36:44 EDT(-0400)] <EricDalquist> probably drew's import/export work
[17:36:46 EDT(-0400)] <athena> on layout import
[17:36:46 EDT(-0400)] <athena> yeah
[17:36:49 EDT(-0400)] <athena> hm
[17:36:51 EDT(-0400)] <EricDalquist> if those objects are not correctly typed
[17:37:00 EDT(-0400)] <EricDalquist> the problem is CRN is weakly typed for the most part
[17:37:08 EDT(-0400)] <athena> i may have to find a temporary fix to be able to go forward with my work
[17:37:08 EDT(-0400)] <athena> yeah
[17:37:10 EDT(-0400)] <EricDalquist> so if he is treating layout_id as a String in crn that's ok
[17:37:16 EDT(-0400)] <athena> since i probably can't bring up my portal now (smile)
[17:37:27 EDT(-0400)] <EricDalquist> but the Spring JDBC APIs set the SQL type based on the object type
[17:37:37 EDT(-0400)] <EricDalquist> can you bug him about that?
[17:37:39 EDT(-0400)] <athena> gotcha
[17:37:41 EDT(-0400)] <athena> no
[17:37:54 EDT(-0400)] <athena> i'll take a look at it though
[17:38:12 EDT(-0400)] <athena> i'm very much hoping drew's not reading work email right now (smile)
[17:38:30 EDT(-0400)] <EricDalquist> vacation?
[17:38:40 EDT(-0400)] <athena> new baby!
[17:39:32 EDT(-0400)] <athena> so maybe i'll try and see if i can find a quick fix for that one
[17:39:45 EDT(-0400)] <EricDalquist> exciting
[17:40:00 EDT(-0400)] <EricDalquist> yeah, it should be an issue of finding where that value is coming from in the crn script
[17:40:10 EDT(-0400)] <EricDalquist> and coercing it to an Integer or Long
[17:40:16 EDT(-0400)] <athena> yeah
[17:40:19 EDT(-0400)] <athena> that makes sense
[17:41:26 EDT(-0400)] <athena> ok, i found it
[17:41:38 EDT(-0400)] <athena> yeah you're right - it's trying to insert a String "1"
[17:41:59 EDT(-0400)] <EricDalquist> http://ehcache.sourceforge.net/
[17:42:07 EDT(-0400)] <EricDalquist> ehcache 1.6 is getting closer
[17:42:18 EDT(-0400)] <athena> excellent (smile)
[17:42:23 EDT(-0400)] <athena> good new stuff?
[17:42:26 EDT(-0400)] <EricDalquist> claims of 80x faster gets, 22x puts and 42x removes
[17:42:42 EDT(-0400)] <EricDalquist> looks like they switched from high level synchronize to the concurrent APIs
[17:43:51 EDT(-0400)] <athena> wow nice
[17:43:52 EDT(-0400)] <athena> (smile)
[17:44:07 EDT(-0400)] <athena> sounds good to me!
[17:44:19 EDT(-0400)] <EricDalquist> yeah
[17:46:15 EDT(-0400)] <athena> hm, issue with another script too
[17:46:21 EDT(-0400)] <athena> it's time for me to go outside
[17:46:24 EDT(-0400)] <EricDalquist> (smile)
[17:46:31 EDT(-0400)] <EricDalquist> time for me to go home soon
[17:46:51 EDT(-0400)] <athena> i'll look at this stuff when i get back
[17:46:53 EDT(-0400)] <athena> have a good evening
[17:46:54 EDT(-0400)] <athena> (smile)
[17:46:55 EDT(-0400)] <EricDalquist> sounds good
[17:46:56 EDT(-0400)] <EricDalquist> you too
[17:48:31 EDT(-0400)] <EricDalquist> http://gregluck.com/blog/archives/2009/02/i_have_been_wai.html
[17:48:36 EDT(-0400)] * EricDalquist wants ehcache 1.6 (tongue)
[17:48:53 EDT(-0400)] <athena> lol
[19:03:45 EDT(-0400)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has left ##uportal
[19:12:37 EDT(-0400)] * athena (n=athena@99.129.100.66) has joined ##uportal
[19:18:30 EDT(-0400)] * tsnfoo (n=tsnfoo@cpe-173-88-45-236.columbus.res.rr.com) has joined ##uportal
[19:43:34 EDT(-0400)] * athena (n=athena@99.129.100.66) has joined ##uportal
[21:16:20 EDT(-0400)] * JASIGLogBot (n=PircBot@jasig.Princeton.EDU) has joined ##uportal
[21:16:20 EDT(-0400)] * Topic is 'http://uportal.pastebin.com/ - http://www.ja-sig.org/wiki/display/UPC/uportal+IRC+Logs' set by EricDalquist on 2008-02-27 12:32:13 EST(-0500)
[22:34:52 EDT(-0400)] * tsnfoo (n=tsnfoo@cpe-173-88-27-191.columbus.res.rr.com) has joined ##uportal
[23:40:11 EDT(-0400)] * Sememmon (n=Sememmon@ip70-190-32-223.ph.ph.cox.net) has joined ##uportal