[Building Sakai] autocommit
Steve Swinsburg
steve.swinsburg at gmail.com
Mon Nov 5 15:13:07 PST 2012
Hi Jeremy
Those queries are from the Sakai Db Service. Hibernate properties probably won't affect it ( unless it takes them into account). Your best bet would be to tune the jdbc connection with the relevant jdbc properties that are available.
There are MySQL 5.0 docs but would be the same:
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
Sent from my iPhone
On 06/11/2012, at 6:46, "Kusnetz, Jeremy" <JKusnetz at APUS.EDU> wrote:
> We set hibernate.connection.autocommit=true on a couple of our nodes to see what the impact would be. Unfortunately I’m seeing those nodes still have very long running transactions (since the tomcat restart). I’m thinking either hibernate.connection.autocommit=true isn’t doing what I thought, or these long running transactions are not coming from hibernate.
>
> Any thoughts?
>
> From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Kusnetz, Jeremy
> Sent: Tuesday, October 30, 2012 10:18 AM
> To: Steve Swinsburg
> Cc: sakai-dev at collab.sakaiproject.org
> Subject: Re: [Building Sakai] autocommit
>
> Thanks Steve.
>
> I have the utility installed. Unfortunately it seems to seg fault fairly regularly preventing me from finding really long running transactions. But that said, here is the output for checking transactions running longer than 60 seconds, and it’s quite a lot of them. Something doesn’t seem right here.
>
> Monitoring any interface..
> Listening port 3306..
> Logging transactions that take more than 60000 milliseconds..
>
> From 10.0.42.129:46285
> 2012/10/30 10:11:41.364119 ->
> select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE where ( SITE_ID = x'313934363534' )
> 2012/10/30 10:11:41.364298 <-
> GOT_RES
> 2012/10/30 10:11:41.364303 <-
> GOT_RES
> 2012/10/30 10:11:41.365075 ->
> select PAGE_ID, TITLE, LAYOUT, POPUP from SAKAI_SITE_PAGE where SITE_ID = x'313934363534' order by SITE_ORDER ASC
> 2012/10/30 10:11:41.365395 <-
> GOT_RES
> 2012/10/30 10:11:41.365402 <-
> GOT_RES
> 2012/10/30 10:11:41.366952 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'61386136633234642D366232612D346436302D393062652D626164376439343837323662'
> 2012/10/30 10:11:41.368993 <-
> GOT_RES
> 2012/10/30 10:11:41.369560 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'65383430626430342D373063612D343866642D393836352D346665663132396163376130'
> 2012/10/30 10:11:41.369673 <-
> GOT_RES
> 2012/10/30 10:11:41.370131 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'65383430626430342D373063612D343866642D393836352D346665663132396163376130'
> 2012/10/30 10:11:41.370333 <-
> GOT_RES
> 2012/10/30 10:11:41.370980 ->
> select SITE_ID from SAKAI_SITE where ( SITE_ID = x'313932353431' )
> 2012/10/30 10:11:41.371203 <-
> GOT_RES
> 2012/10/30 10:11:41.371806 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'65383430626430342D373063612D343866642D393836352D346665663132396163376130'
> 2012/10/30 10:11:41.371923 <-
> GOT_RES
> 2012/10/30 10:11:41.372694 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'65383430626430342D373063612D343866642D393836352D346665663132396163376130'
> 2012/10/30 10:11:41.372884 <-
> GOT_RES
> 2012/10/30 10:11:41.373729 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'65383430626430342D373063612D343866642D393836352D346665663132396163376130'
> 2012/10/30 10:11:41.373850 <-
> GOT_RES
> 2012/10/30 10:11:41.374275 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'64333163626162342D653830392D346634372D383538652D626436663035356131666636'
> 2012/10/30 10:11:41.375360 <-
> GOT_RES
> 2012/10/30 10:11:41.375751 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'64333163626162342D653830392D346634372D383538652D626436663035356131666636'
> 2012/10/30 10:11:41.376936 <-
> GOT_RES
> 2012/10/30 10:11:41.377555 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'63363233383061342D346636372D346135392D393265332D613566363131383263316536'
> 2012/10/30 10:11:41.377673 <-
> GOT_RES
> 2012/10/30 10:11:41.378344 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'61353164656366302D386539352D343664632D616664322D323834353334343633353237'
> 2012/10/30 10:11:41.378451 <-
> GOT_RES
> 2012/10/30 10:11:41.379150 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'62333365353437392D366661642D343734632D623133332D613530666566306136663731'
> 2012/10/30 10:11:41.379265 <-
> GOT_RES
> 2012/10/30 10:11:41.379976 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'31313937363435342D663433632D343236322D613437332D666162653733646162366465'
> 2012/10/30 10:11:41.380087 <-
> GOT_RES
> 2012/10/30 10:11:41.380732 ->
> select SITE_ID from SAKAI_SITE where ( SITE_ID = x'323038333036' )
> 2012/10/30 10:11:41.380827 <-
> GOT_RES
> 2012/10/30 10:11:41.381146 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'62396365633130362D616634622D346137382D613232662D326163306331336630633461'
> 2012/10/30 10:11:41.381257 <-
> GOT_RES
> 2012/10/30 10:11:42.215156 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'30613733343161632D383865652D346662612D626633352D353732376237656663653565'
> 2012/10/30 10:11:42.215289 <-
> GOT_RES
> 2012/10/30 10:11:42.250216 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'62396662383563662D633765652D343737612D616236622D383631343765353434666639'
> 2012/10/30 10:11:42.250323 <-
> GOT_RES
> 2012/10/30 10:11:46.823026 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'39306364646539642D376565642D343966352D383966392D616161323339646533376233'
> 2012/10/30 10:11:46.823166 <-
> GOT_RES
> 2012/10/30 10:13:01.769093 ->
> select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE where ( SITE_ID = x'313837343933' )
> 2012/10/30 10:13:01.769277 <-
> GOT_RES
> 2012/10/30 10:13:01.769284 <-
> GOT_RES
> 2012/10/30 10:13:01.770469 ->
> select PAGE_ID, TITLE, LAYOUT, POPUP from SAKAI_SITE_PAGE where SITE_ID = x'313837343933' order by SITE_ORDER ASC
> 2012/10/30 10:13:01.770773 <-
> GOT_RES
> 2012/10/30 10:13:01.770780 <-
> GOT_RES
> 2012/10/30 10:13:01.771996 ->
> select PAGE_ID, NAME, VALUE from SAKAI_SITE_PAGE_PROPERTY where ( SITE_ID = x'313837343933' )
> 2012/10/30 10:13:01.772232 <-
> GOT_RES
> 2012/10/30 10:13:01.772237 <-
> GOT_RES
> 2012/10/30 10:13:01.773957 ->
> select TOOL_ID, PAGE_ID, REGISTRATION, TITLE, LAYOUT_HINTS, PAGE_ORDER from SAKAI_SITE_TOOL where SITE_ID = x'313837343933' order by PAGE_ID, PAGE_ORDER ASC
> 2012/10/30 10:13:01.774336 <-
> GOT_RES
> 2012/10/30 10:13:01.774345 <-
> GOT_RES
> 2012/10/30 10:13:01.775318 ->
> select SS.GROUP_ID, SS.TITLE, SS.DESCRIPTION from SAKAI_SITE_GROUP SS where SS.SITE_ID = x'313837343933'
> 2012/10/30 10:13:01.775446 <-
> GOT_RES
> 2012/10/30 10:13:01.776420 ->
> select NAME, VALUE from SAKAI_SITE_PROPERTY where ( SITE_ID = x'313837343933' )
> 2012/10/30 10:13:01.776561 <-
> GOT_RES
> 2012/10/30 10:13:01.781869 ->
> select TOOL_ID, NAME, VALUE from SAKAI_SITE_TOOL_PROPERTY where ( SITE_ID = x'313837343933' )
> 2012/10/30 10:13:01.782057 <-
> GOT_RES
> 2012/10/30 10:13:01.789535 ->
> select GROUP_ID, NAME, VALUE from SAKAI_SITE_GROUP_PROPERTY where ( SITE_ID = x'313837343933' )
> 2012/10/30 10:13:01.789664 <-
> GOT_RES
> 2012/10/30 10:13:01.791178 ->
> select SAKAI_USER.USER_ID,SAKAI_USER.EMAIL,SAKAI_USER.EMAIL_LC,SAKAI_USER.FIRST_NAME,SAKAI_USER.LAST_NAME,SAKAI_USER.TYPE,SAKAI_USER.PW,SAKAI_USER.CREATEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON from SAKAI_USER where ( USER_ID = x'37623431336233352D396236372D343831652D623633382D653935373639626162343666' )
> 2012/10/30 10:13:01.791314 <-
> GOT_RES
> 2012/10/30 10:13:01.792565 ->
> select count(1) from SAKAI_REALM_RL_FN MAINTABLE LEFT JOIN SAKAI_REALM_RL_GR GRANTED_ROLES ON (MAINTABLE.REALM_KEY = GRANTED_ROLES.REALM_KEY AND MAINTABLE.ROLE_KEY = GRANTED_ROLES.ROLE_KEY), SAKAI_REALM REALMS, SAKAI_REALM_ROLE ROLES, SAKAI_REALM_FUNCTION FUNCTIONS where (ROLES.ROLE_NAME in('.anon','.auth') or (GRANTED_ROLES.USER_ID = x'37623431336233352D396236372D343831652D623633382D653935373639626162343666' AND GRANTED_ROLES.ACTIVE = 1)) AND FUNCTIONS.FUNCTION_NAME = x'736974652E757064' AND REALMS.REALM_ID in (x'2F736974652F2161646D696E') AND MAINTABLE.REALM_KEY = REALMS.REALM_KEY AND MAINTABLE.FUNCTION_KEY = FUNCTIONS.FUNCTION_KEY AND MAINTABLE.ROLE_KEY = ROLES.ROLE_KEY
> 2012/10/30 10:13:01.792976 <-
> GOT_RES
> 2012/10/30 10:13:01.793907 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313837343933',x'2F757365722F37623431336233352D396236372D343831652D623633382D653935373639626162343666',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'736974652E7669736974') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'37623431336233352D396236372D343831652D623633382D653935373639626162343666' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313837343933',x'2F757365722F37623431336233352D396236372D343831652D623633382D653935373639626162343666',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:01.795097 <-
> GOT_RES
> 2012/10/30 10:13:01.818264 ->
> select areaimpl0_.ID as ID95_0_, membership1_.ID as ID102_1_, areaimpl0_.VERSION as VERSION95_0_, areaimpl0_.UUID as UUID95_0_, areaimpl0_.CREATED as CREATED95_0_, areaimpl0_.CREATED_BY as CREATED5_95_0_, areaimpl0_.MODIFIED as MODIFIED95_0_, areaimpl0_.MODIFIED_BY as MODIFIED7_95_0_, areaimpl0_.CONTEXT_ID as CONTEXT8_95_0_, areaimpl0_.NAME as NAME95_0_, areaimpl0_.HIDDEN as HIDDEN95_0_, areaimpl0_.TYPE_UUID as TYPE11_95_0_, areaimpl0_.ENABLED as ENABLED95_0_, areaimpl0_.SENDEMAILOUT as SENDEMA13_95_0_, areaimpl0_.LOCKED as LOCKED95_0_, areaimpl0_.MODERATED as MODERATED95_0_, areaimpl0_.AUTO_MARK_THREADS_READ as AUTO16_95_0_, areaimpl0_.AVAILABILITY_RESTRICTED as AVAILAB17_95_0_, areaimpl0_.AVAILABILITY as AVAILAB18_95_0_, areaimpl0_.OPEN_DATE as OPEN19_95_0_, areaimpl0_.CLOSE_DATE as CLOSE20_95_0_, membership1_.VERSION as VERSION102_1_, membership1_.UUID as UUID102_1_, membership1_.CREATED as CREATED102_1_, membership1_.CREATED_BY as CREATED5_102_1_, membership1_.MODIFIED as MODIFIED102_1_, membership1_.MODIFIED_BY as MODIFIED7_102_1_, membership1_.NAME as NAME102_1_, membership1_.TYPE as TYPE102_1_, membership1_.PERMISSION_LEVEL_NAME as PERMISSION10_102_1_, membership1_.PERMISSION_LEVEL as PERMISSION11_102_1_, membership1_.t_surrogateKey as t12_102_1_, membership1_.of_surrogateKey as of13_102_1_, membership1_.a_surrogateKey as a14_102_1_, membership1_.a_surrogateKey as a14_0__, membership1_.ID as ID0__ from MFR_AREA_T
> 2012/10/30 10:13:01.818529 <-
> GOT_RES
> 2012/10/30 10:13:01.818536 <-
> GOT_RES
> 2012/10/30 10:13:01.819589 ->
> commit
>
> From 10.0.40.254:57687
> 2012/10/30 10:11:59.744714 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'535731333937'
> 2012/10/30 10:11:59.744849 <-
> GOT_RES
> 2012/10/30 10:12:25.341623 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'66663462633931322D366363362D343732642D613237372D336436303830303534343564'
> 2012/10/30 10:12:25.341758 <-
> GOT_RES
> 2012/10/30 10:12:51.993613 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'34383530663537372D343565312D343965302D626662372D373933303263363835376432'
> 2012/10/30 10:12:51.993748 <-
> GOT_RES
> 2012/10/30 10:13:10.32060 ->
> select SAKAI_USER.USER_ID,SAKAI_USER.EMAIL,SAKAI_USER.EMAIL_LC,SAKAI_USER.FIRST_NAME,SAKAI_USER.LAST_NAME,SAKAI_USER.TYPE,SAKAI_USER.PW,SAKAI_USER.CREATEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON from SAKAI_USER where ( USER_ID = x'31613030353363652D313364382D346563362D623864642D343664653238393538303635' )
> 2012/10/30 10:13:10.32300 <-
> GOT_RES
> 2012/10/30 10:13:11.864500 ->
> select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE where ( SITE_ID = x'313937393430' )
> 2012/10/30 10:13:11.864693 <-
> GOT_RES
> 2012/10/30 10:13:11.864699 <-
> GOT_RES
> 2012/10/30 10:13:11.865694 ->
> select PAGE_ID, TITLE, LAYOUT, POPUP from SAKAI_SITE_PAGE where SITE_ID = x'313937393430' order by SITE_ORDER ASC
> 2012/10/30 10:13:11.866019 <-
> GOT_RES
> 2012/10/30 10:13:11.866023 <-
> GOT_RES
> 2012/10/30 10:13:11.867318 ->
> select PAGE_ID, NAME, VALUE from SAKAI_SITE_PAGE_PROPERTY where ( SITE_ID = x'313937393430' )
> 2012/10/30 10:13:11.867561 <-
> GOT_RES
> 2012/10/30 10:13:11.867565 <-
> GOT_RES
> 2012/10/30 10:13:11.868391 ->
> select TOOL_ID, PAGE_ID, REGISTRATION, TITLE, LAYOUT_HINTS, PAGE_ORDER from SAKAI_SITE_TOOL where SITE_ID = x'313937393430' order by PAGE_ID, PAGE_ORDER ASC
> 2012/10/30 10:13:11.868767 <-
> GOT_RES
> 2012/10/30 10:13:11.868774 <-
> GOT_RES
> 2012/10/30 10:13:11.869372 ->
> select SS.GROUP_ID, SS.TITLE, SS.DESCRIPTION from SAKAI_SITE_GROUP SS where SS.SITE_ID = x'313937393430'
> 2012/10/30 10:13:11.869497 <-
> GOT_RES
> 2012/10/30 10:13:11.869850 ->
> select NAME, VALUE from SAKAI_SITE_PROPERTY where ( SITE_ID = x'313937393430' )
> 2012/10/30 10:13:11.869995 <-
> GOT_RES
> 2012/10/30 10:13:11.870384 ->
> select TOOL_ID, NAME, VALUE from SAKAI_SITE_TOOL_PROPERTY where ( SITE_ID = x'313937393430' )
> 2012/10/30 10:13:11.870570 <-
> GOT_RES
> 2012/10/30 10:13:11.870863 ->
> select GROUP_ID, NAME, VALUE from SAKAI_SITE_GROUP_PROPERTY where ( SITE_ID = x'313937393430' )
> 2012/10/30 10:13:11.870996 <-
> GOT_RES
> 2012/10/30 10:13:11.871554 ->
> select count(1) from SAKAI_REALM_RL_FN MAINTABLE LEFT JOIN SAKAI_REALM_RL_GR GRANTED_ROLES ON (MAINTABLE.REALM_KEY = GRANTED_ROLES.REALM_KEY AND MAINTABLE.ROLE_KEY = GRANTED_ROLES.ROLE_KEY), SAKAI_REALM REALMS, SAKAI_REALM_ROLE ROLES, SAKAI_REALM_FUNCTION FUNCTIONS where (ROLES.ROLE_NAME in('.anon','.auth') or (GRANTED_ROLES.USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' AND GRANTED_ROLES.ACTIVE = 1)) AND FUNCTIONS.FUNCTION_NAME = x'736974652E757064' AND REALMS.REALM_ID in (x'2F736974652F2161646D696E') AND MAINTABLE.REALM_KEY = REALMS.REALM_KEY AND MAINTABLE.FUNCTION_KEY = FUNCTIONS.FUNCTION_KEY AND MAINTABLE.ROLE_KEY = ROLES.ROLE_KEY
> 2012/10/30 10:13:11.871928 <-
> GOT_RES
> 2012/10/30 10:13:11.872452 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'736974652E7669736974') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.873522 <-
> GOT_RES
> 2012/10/30 10:13:11.874309 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'616E6E632E72656164') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.875248 <-
> GOT_RES
> 2012/10/30 10:13:11.875877 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'63616C656E6461722E72656164') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.876955 <-
> GOT_RES
> 2012/10/30 10:13:11.877451 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F6369746174696F6E7341646D696E2F')
> 2012/10/30 10:13:11.877579 <-
> GOT_RES
> 2012/10/30 10:13:11.877933 ->
> select XML, BINARY_ENTITY from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F6369746174696F6E7341646D696E2F636F6E6669672F636F6E6669672E786D6C')
> 2012/10/30 10:13:11.878041 <-
> GOT_RES
> 2012/10/30 10:13:11.880928 ->
> select start_flag,complete_flag from melete_migrate_status
> 2012/10/30 10:13:11.881018 <-
> GOT_RES
> 2012/10/30 10:13:11.882385 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'6772616465626F6F6B2E766965774F776E477261646573') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.883367 <-
> GOT_RES
> 2012/10/30 10:13:11.883920 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'736974652E757064') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.884753 <-
> GOT_RES
> 2012/10/30 10:13:11.885429 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'7369746573746174732E76696577') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.886325 <-
> GOT_RES
> 2012/10/30 10:13:11.886840 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'736974652E616464') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.887534 <-
> GOT_RES
> 2012/10/30 10:13:11.888544 ->
> select meleteuser0_.PREF_ID as PREF1_69_, meleteuser0_.USER_ID as USER2_69_, meleteuser0_.EDITOR_CHOICE as EDITOR3_69_, meleteuser0_.EXP_CHOICE as EXP4_69_, meleteuser0_.LTI_CHOICE as LTI5_69_ from melete_user_preference meleteuser0_ where meleteuser0_.USER_ID=''
> 2012/10/30 10:13:11.888676 <-
> GOT_RES
> 2012/10/30 10:13:11.889431 ->
> select meletesite0_.PREF_SITE_ID as PREF1_72_, meletesite0_.PRINTABLE as PRINTABLE72_, meletesite0_.AUTONUMBER as AUTONUMBER72_ from melete_site_preference meletesite0_ where meletesite0_.PREF_SITE_ID='monitor'
> 2012/10/30 10:13:11.889546 <-
> GOT_RES
> 2012/10/30 10:13:11.893382 ->
> select meletesite0_.PREF_SITE_ID as PREF1_72_, meletesite0_.PRINTABLE as PRINTABLE72_, meletesite0_.AUTONUMBER as AUTONUMBER72_ from melete_site_preference meletesite0_ where meletesite0_.PREF_SITE_ID='monitor'
> 2012/10/30 10:13:11.893474 <-
> GOT_RES
> 2012/10/30 10:13:11.894444 ->
> select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID = SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and SAKAI_SITE.IS_DELETED='N' and SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by SAKAI_SITE.TITLE ASC
> 2012/10/30 10:13:11.895215 <-
> GOT_RES
> 2012/10/30 10:13:11.895534 <-
> GOT_RES
> 2012/10/30 10:13:11.895823 <-
> GOT_RES
> 2012/10/30 10:13:11.895848 <-
> GOT_RES
> 2012/10/30 10:13:11.896013 <-
> GOT_RES
> 2012/10/30 10:13:11.896109 <-
> GOT_RES
> 2012/10/30 10:13:11.896272 <-
> GOT_RES
> 2012/10/30 10:13:11.896366 <-
> GOT_RES
> 2012/10/30 10:13:11.896563 <-
> GOT_RES
> 2012/10/30 10:13:11.896585 <-
> GOT_RES
> 2012/10/30 10:13:11.896588 <-
> GOT_RES
> 2012/10/30 10:13:11.897650 ->
> select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE where ( SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236' )
> 2012/10/30 10:13:11.897794 <-
> GOT_RES
> 2012/10/30 10:13:11.897805 <-
> GOT_RES
> 2012/10/30 10:13:11.898554 ->
> select PAGE_ID, TITLE, LAYOUT, POPUP from SAKAI_SITE_PAGE where SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236' order by SITE_ORDER ASC
> 2012/10/30 10:13:11.898812 <-
> GOT_RES
> 2012/10/30 10:13:11.899378 ->
> select PAGE_ID, NAME, VALUE from SAKAI_SITE_PAGE_PROPERTY where ( SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236' )
> 2012/10/30 10:13:11.899579 <-
> GOT_RES
> 2012/10/30 10:13:11.899987 ->
> select TOOL_ID, PAGE_ID, REGISTRATION, TITLE, LAYOUT_HINTS, PAGE_ORDER from SAKAI_SITE_TOOL where SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236' order by PAGE_ID, PAGE_ORDER ASC
> 2012/10/30 10:13:11.900301 <-
> GOT_RES
> 2012/10/30 10:13:11.900309 <-
> GOT_RES
> 2012/10/30 10:13:11.900797 ->
> select SS.GROUP_ID, SS.TITLE, SS.DESCRIPTION from SAKAI_SITE_GROUP SS where SS.SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236'
> 2012/10/30 10:13:11.900929 <-
> GOT_RES
> 2012/10/30 10:13:11.901273 ->
> select NAME, VALUE from SAKAI_SITE_PROPERTY where ( SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236' )
> 2012/10/30 10:13:11.901405 <-
> GOT_RES
> 2012/10/30 10:13:11.901786 ->
> select TOOL_ID, NAME, VALUE from SAKAI_SITE_TOOL_PROPERTY where ( SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236' )
> 2012/10/30 10:13:11.902054 <-
> GOT_RES
> 2012/10/30 10:13:11.902058 <-
> GOT_RES
> 2012/10/30 10:13:11.902632 ->
> select GROUP_ID, NAME, VALUE from SAKAI_SITE_GROUP_PROPERTY where ( SITE_ID = x'7E32666361333763662D343132642D343663642D626138342D613662313639356239386236' )
> 2012/10/30 10:13:11.902742 <-
> GOT_RES
> 2012/10/30 10:13:11.903354 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F736974652F7E32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'736974652E7669736974') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'32666361333763662D343132642D343663642D626138342D613662313639356239386236' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F736974652F7E32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'2F757365722F32666361333763662D343132642D343663642D626138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:11.904013 <-
> GOT_RES
> 2012/10/30 10:13:11.904633 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F')
> 2012/10/30 10:13:11.904756 <-
> GOT_RES
> 2012/10/30 10:13:11.906308 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F')
> 2012/10/30 10:13:11.906435 <-
> GOT_RES
> 2012/10/30 10:13:11.907738 ->
> select count(IN_COLLECTION) from CONTENT_RESOURCE where IN_COLLECTION = x'2F67726F75702F6D6F6E69746F722F'
> 2012/10/30 10:13:11.907891 <-
> GOT_RES
> 2012/10/30 10:13:11.908204 ->
> select count(IN_COLLECTION) from CONTENT_COLLECTION where IN_COLLECTION = x'2F67726F75702F6D6F6E69746F722F'
> 2012/10/30 10:13:11.908338 <-
> GOT_RES
> 2012/10/30 10:13:11.909192 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'636F6E74656E742E72656164') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = null and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') )
> 2012/10/30 10:13:11.909425 <-
> GOT_RES
> 2012/10/30 10:13:11.910089 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'636F6E74656E742E6E6577') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = null and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') )
> 2012/10/30 10:13:11.910564 <-
> GOT_RES
> 2012/10/30 10:13:11.911441 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'636F6E74656E742E64656C6574652E616E79') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = null and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') )
> 2012/10/30 10:13:11.911917 <-
> GOT_RES
> 2012/10/30 10:13:11.912687 ->
> insert into SAKAI_PRESENCE (SESSION_ID,LOCATION_ID) values ( x'39373430623535322D373233612D343633302D623030392D386438636165323833623661', x'3139373934302D70726573656E6365')
> 2012/10/30 10:13:11.912814 <-
> GOT_OK
> 2012/10/30 10:13:11.913081 ->
> commit
>
> From 10.0.42.131:36707
> 2012/10/30 10:12:02.31675 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'35363962343566342D393238642D343937392D393531322D636335373330323966663439'
> 2012/10/30 10:12:02.31825 <-
> GOT_RES
> 2012/10/30 10:12:02.54718 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'33616461306233352D393964362D346430642D613739322D653533323830356361613134'
> 2012/10/30 10:12:02.54831 <-
> GOT_RES
> 2012/10/30 10:13:11.49366 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'63633636623133662D663962652D346136372D616233332D616535623437303038386333'
> 2012/10/30 10:13:11.49502 <-
> GOT_RES
> 2012/10/30 10:13:13.237139 ->
> select RESOURCE_ID from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F6C6573736F6E735F6C696E6B2E676966')
> 2012/10/30 10:13:13.237301 <-
> GOT_RES
> 2012/10/30 10:13:13.238730 ->
> select XML, BINARY_ENTITY from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F6C6573736F6E735F6C696E6B2E676966')
> 2012/10/30 10:13:13.238853 <-
> GOT_RES
> 2012/10/30 10:13:13.239592 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F')
> 2012/10/30 10:13:13.239708 <-
> GOT_RES
> 2012/10/30 10:13:13.240672 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F')
> 2012/10/30 10:13:13.240778 <-
> GOT_RES
> 2012/10/30 10:13:13.241466 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F')
> 2012/10/30 10:13:13.241582 <-
> GOT_RES
> 2012/10/30 10:13:13.242373 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F')
> 2012/10/30 10:13:13.242478 <-
> GOT_RES
> 2012/10/30 10:13:13.243051 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F')
> 2012/10/30 10:13:13.243157 <-
> GOT_RES
> 2012/10/30 10:13:13.244242 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F6C6573736F6E735F6C696E6B2E676966',x'2F736974652F617274732D616E642D68756D616E69746965732D636F6D6D6F6E',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'636F6E74656E742E72656164') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'64343031316162612D373662312D343263362D623531322D376631326263633538346532' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F',x'2F636F6E74656E742F67726F75702F617274732
> 2012/10/30 10:13:13.245173 <-
> GOT_RES
> 2012/10/30 10:13:13.246029 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F6C6573736F6E735F6C696E6B2E676966',x'2F736974652F617274732D616E642D68756D616E69746965732D636F6D6D6F6E',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'636F6E74656E742E68696464656E') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'64343031316162612D373662312D343263362D623531322D376631326263633538346532' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F',x'2F636F6E74656E742F67726F75702F61727
> 2012/10/30 10:13:13.246960 <-
> GOT_RES
> 2012/10/30 10:13:13.252650 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'39333530343831642D313333382D343565622D386635342D343563386237376332333565'
> 2012/10/30 10:13:13.252784 <-
> GOT_RES
> 2012/10/30 10:13:13.253996 ->
> select gradebook0_.ID as ID73_, gradebook0_.VERSION as VERSION73_, gradebook0_.GRADEBOOK_UID as GRADEBOOK3_73_, gradebook0_.NAME as NAME73_, gradebook0_.SELECTED_GRADE_MAPPING_ID as SELECTED5_73_, gradebook0_.ASSIGNMENTS_DISPLAYED as ASSIGNME6_73_, gradebook0_.COURSE_GRADE_DISPLAYED as COURSE7_73_, gradebook0_.ALL_ASSIGNMENTS_ENTERED as ALL8_73_, gradebook0_.LOCKED as LOCKED73_, gradebook0_.GRADE_TYPE as GRADE10_73_, gradebook0_.CATEGORY_TYPE as CATEGORY11_73_, gradebook0_.IS_EQUAL_WEIGHT_CATS as IS12_73_, gradebook0_.IS_SCALED_EXTRA_CREDIT as IS13_73_, gradebook0_.DO_SHOW_MEAN as DO14_73_, gradebook0_.DO_SHOW_MEDIAN as DO15_73_, gradebook0_.DO_SHOW_MODE as DO16_73_, gradebook0_.DO_SHOW_RANK as DO17_73_, gradebook0_.DO_SHOW_ITEM_STATS as DO18_73_, gradebook0_.DO_SHOW_STATISTICS_CHART as DO19_73_ from GB_GRADEBOOK_T gradebook0_ where gradebook0_.GRADEBOOK_UID='198706'
> 2012/10/30 10:13:13.254163 <-
> GOT_RES
> 2012/10/30 10:13:13.254167 <-
> GOT_RES
> 2012/10/30 10:13:13.255086 ->
> select grademappi0_.ID as ID81_3_, grademappi0_.VERSION as VERSION81_3_, grademappi0_.GRADEBOOK_ID as GRADEBOOK4_81_3_, grademappi0_.GB_GRADING_SCALE_T as GB5_81_3_, grademappi0_.OBJECT_TYPE_ID as OBJECT2_81_3_, gradebook1_.ID as ID73_0_, gradebook1_.VERSION as VERSION73_0_, gradebook1_.GRADEBOOK_UID as GRADEBOOK3_73_0_, gradebook1_.NAME as NAME73_0_, gradebook1_.SELECTED_GRADE_MAPPING_ID as SELECTED5_73_0_, gradebook1_.ASSIGNMENTS_DISPLAYED as ASSIGNME6_73_0_, gradebook1_.COURSE_GRADE_DISPLAYED as COURSE7_73_0_, gradebook1_.ALL_ASSIGNMENTS_ENTERED as ALL8_73_0_, gradebook1_.LOCKED as LOCKED73_0_, gradebook1_.GRADE_TYPE as GRADE10_73_0_, gradebook1_.CATEGORY_TYPE as CATEGORY11_73_0_, gradebook1_.IS_EQUAL_WEIGHT_CATS as IS12_73_0_, gradebook1_.IS_SCALED_EXTRA_CREDIT as IS13_73_0_, gradebook1_.DO_SHOW_MEAN as DO14_73_0_, gradebook1_.DO_SHOW_MEDIAN as DO15_73_0_, gradebook1_.DO_SHOW_MODE as DO16_73_0_, gradebook1_.DO_SHOW_RANK as DO17_73_0_, gradebook1_.DO_SHOW_ITEM_STATS as DO18_73_0_, gradebook1_.DO_SHOW_STATISTICS_CHART as DO19_73_0_, grademappi2_.ID as ID81_1_, grademappi2_.VERSION as VERSION81_1_, grademappi2_.GRADEBOOK_ID as GRADEBOOK4_81_1_, grademappi2_.GB_GRADING_SCALE_T as GB5_81_1_, grademappi2_.OBJECT_TYPE_ID as OBJECT2_81_1_, gradingsca3_.ID as ID77_2_, gradingsca3_.VERSION as VERSION77_2_, gradingsca3_.SCALE_UID as SCALE4_77_2_, gradingsca3_.NAME as NAME77_2_, gradingsca3_.UNAVAILABLE as UNAVAILA6_77_2_ from
> 2012/10/30 10:13:13.255322 <-
> GOT_RES
> 2012/10/30 10:13:13.255328 <-
> GOT_RES
> 2012/10/30 10:13:13.255983 ->
> select defaultbot0_.GRADING_SCALE_ID as GRADING1_0_, defaultbot0_.`PERCENT` as PERCENT2_0_, defaultbot0_.LETTER_GRADE as LETTER3_0_ from GB_GRADING_SCALE_PERCENTS_T defaultbot0_ where defaultbot0_.GRADING_SCALE_ID=2
> 2012/10/30 10:13:13.256118 <-
> GOT_RES
> 2012/10/30 10:13:13.256627 ->
> select grades0_.GRADING_SCALE_ID as GRADING1_0_, grades0_.LETTER_GRADE as LETTER2_0_, grades0_.GRADE_IDX as GRADE3_0_ from GB_GRADING_SCALE_GRADES_T grades0_ where grades0_.GRADING_SCALE_ID=2
> 2012/10/30 10:13:13.256750 <-
> GOT_RES
> 2012/10/30 10:13:13.257625 ->
> select grademap0_.GRADE_MAP_ID as GRADE1_0_, grademap0_.`PERCENT` as PERCENT2_0_, grademap0_.LETTER_GRADE as LETTER3_0_ from GB_GRADE_TO_PERCENT_MAPPING_T grademap0_ where grademap0_.GRADE_MAP_ID=141034
> 2012/10/30 10:13:13.257777 <-
> GOT_RES
> 2012/10/30 10:13:13.258621 ->
> commit
>
> From 10.0.42.142:36085
> 2012/10/30 10:12:02.830874 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'65633335343832642D646665382D346266362D623166612D333736653163363066333836'
> 2012/10/30 10:12:02.831011 <-
> GOT_RES
> 2012/10/30 10:12:02.840858 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'464D31303139'
> 2012/10/30 10:12:02.841106 <-
> GOT_RES
> 2012/10/30 10:12:30.21981 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313937323133' and SRRG.USER_ID = x'35353738366139342D393239612D343138612D623834342D613265366333396630386462' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:30.23766 <-
> GOT_RES
> 2012/10/30 10:12:30.28813 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313937323133' and SRRG.USER_ID = x'35353738366139342D393239612D343138612D623834342D613265366333396630386462' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:30.29279 <-
> GOT_RES
> 2012/10/30 10:12:42.12751 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'35656462313161662D656231312D343836392D613062342D333238303763643264366236'
> 2012/10/30 10:12:42.12879 <-
> GOT_RES
> 2012/10/30 10:13:15.841653 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313933393630' and SRRG.USER_ID = x'4D4B31393934' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:15.841855 <-
> GOT_RES
> 2012/10/30 10:13:15.844904 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'34343032643161382D643835612D343662302D613731392D663836316436663962643230'
> 2012/10/30 10:13:15.845052 <-
> GOT_RES
> 2012/10/30 10:13:15.845682 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66656164346632382D663839322D346130352D626339662D613039633061363237386532'
> 2012/10/30 10:13:15.845812 <-
> GOT_RES
> 2012/10/30 10:13:15.846423 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66656164346632382D663839322D346130352D626339662D613039633061363237386532'
> 2012/10/30 10:13:15.846552 <-
> GOT_RES
> 2012/10/30 10:13:15.847520 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'62663164633463372D326666382D343166662D626665392D383035623064646333336537'
> 2012/10/30 10:13:15.847713 <-
> GOT_RES
> 2012/10/30 10:13:15.848654 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'62663164633463372D326666382D343166662D626665392D383035623064646333336537'
> 2012/10/30 10:13:15.848793 <-
> GOT_RES
> 2012/10/30 10:13:15.849488 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'39373430623535322D373233612D343633302D623030392D386438636165323833623661'
> 2012/10/30 10:13:15.849615 <-
> GOT_RES
> 2012/10/30 10:13:15.850240 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66633761326664642D333239622D343465322D393166632D383733303666313234626632'
> 2012/10/30 10:13:15.850366 <-
> GOT_RES
> 2012/10/30 10:13:15.850889 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66633761326664642D333239622D343465322D393166632D383733303666313234626632'
> 2012/10/30 10:13:15.851015 <-
> GOT_RES
> 2012/10/30 10:13:15.851833 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66633761326664642D333239622D343465322D393166632D383733303666313234626632'
> 2012/10/30 10:13:15.851949 <-
> GOT_RES
> 2012/10/30 10:13:15.852392 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66633761326664642D333239622D343465322D393166632D383733303666313234626632'
> 2012/10/30 10:13:15.852515 <-
> GOT_RES
> 2012/10/30 10:13:15.853448 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'62396365633130362D616634622D346137382D613232662D326163306331336630633461'
> 2012/10/30 10:13:15.853566 <-
> GOT_RES
> 2012/10/30 10:13:15.858998 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313933393630' and SRRG.USER_ID = x'4D4B31393934' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:15.859236 <-
> GOT_RES
> 2012/10/30 10:13:20.501417 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F323038373930' and SRRG.USER_ID = x'38623732386234392D316334612D343436322D396263632D663636316162656363623636' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:20.501614 <-
> GOT_RES
> 2012/10/30 10:13:20.503395 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F323038373930' and SRRG.USER_ID = x'38623732386234392D316334612D343436322D396263632D663636316162656363623636' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:20.503550 <-
> GOT_RES
> 2012/10/30 10:13:20.509573 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F323038373930' and SRRG.USER_ID = x'38623732386234392D316334612D343436322D396263632D663636316162656363623636' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:20.509729 <-
> GOT_RES
> 2012/10/30 10:13:20.515496 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F323038373930' and SRRG.USER_ID = x'38623732386234392D316334612D343436322D396263632D663636316162656363623636' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:20.515651 <-
> GOT_RES
> 2012/10/30 10:13:20.517333 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F323038373930' and SRRG.USER_ID = x'38623732386234392D316334612D343436322D396263632D663636316162656363623636' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:20.517488 <-
> GOT_RES
> 2012/10/30 10:13:21.841691 ->
> select AX.SESSION_ID,AX.SESSION_SERVER,AX.SESSION_USER,AX.SESSION_IP,AX.SESSION_HOSTNAME,AX.SESSION_USER_AGENT,AX.SESSION_START,AX.SESSION_END,AX.SESSION_ACTIVE from SAKAI_SESSION AX inner join SAKAI_PRESENCE A ON AX.SESSION_ID = A.SESSION_ID where AX.SESSION_ACTIVE=1 and A.LOCATION_ID = x'3139343534362D70726573656E6365'
> 2012/10/30 10:13:21.841942 <-
> GOT_RES
> 2012/10/30 10:13:21.843788 ->
> select privacyrec0_.id as id216_, privacyrec0_.lockId as lockId216_, privacyrec0_.contextId as contextId216_, privacyrec0_.recordType as recordType216_, privacyrec0_.userId as userId216_, privacyrec0_.viewable as viewable216_ from SAKAI_PRIVACY_RECORD privacyrec0_ where privacyrec0_.contextId='/site/194546' and privacyrec0_.recordType='system_record' and (privacyrec0_.userId in ('4c1925bd-1757-40e2-803e-da24ce7889f6' , 'cdc02421-6e21-4928-818e-5fd151087698'))
> 2012/10/30 10:13:21.843957 <-
> GOT_RES
> 2012/10/30 10:13:21.844540 ->
> select privacyrec0_.id as id216_, privacyrec0_.lockId as lockId216_, privacyrec0_.contextId as contextId216_, privacyrec0_.recordType as recordType216_, privacyrec0_.userId as userId216_, privacyrec0_.viewable as viewable216_ from SAKAI_PRIVACY_RECORD privacyrec0_ where privacyrec0_.contextId='/site/194546' and privacyrec0_.recordType='user_record' and (privacyrec0_.userId in ('4c1925bd-1757-40e2-803e-da24ce7889f6' , 'cdc02421-6e21-4928-818e-5fd151087698'))
> 2012/10/30 10:13:21.844915 <-
> GOT_RES
> 2012/10/30 10:13:21.845244 ->
> commit
>
> From 10.0.40.245:39042
> 2012/10/30 10:11:34.364435 ->
> select SAKAI_USER.USER_ID,SAKAI_USER.EMAIL,SAKAI_USER.EMAIL_LC,SAKAI_USER.FIRST_NAME,SAKAI_USER.LAST_NAME,SAKAI_USER.TYPE,SAKAI_USER.PW,SAKAI_USER.CREATEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON from SAKAI_USER where ( USER_ID = x'61613032376630622D336137302D343737342D393435342D346330643264643133333736' )
> 2012/10/30 10:11:34.364679 <-
> GOT_RES
> 2012/10/30 10:11:34.383823 ->
> select SAKAI_USER.USER_ID,SAKAI_USER.EMAIL,SAKAI_USER.EMAIL_LC,SAKAI_USER.FIRST_NAME,SAKAI_USER.LAST_NAME,SAKAI_USER.TYPE,SAKAI_USER.PW,SAKAI_USER.CREATEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON from SAKAI_USER where ( USER_ID = x'35333236383335612D326465362D346630392D616634632D646235633138376335376662' )
> 2012/10/30 10:11:34.384103 <-
> GOT_RES
> 2012/10/30 10:12:18.716692 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'38653863376263322D336565312D343039622D626633392D396634386233343737373661'
> 2012/10/30 10:12:18.716839 <-
> GOT_RES
> 2012/10/30 10:13:30.954562 ->
> select XML from ANNOUNCEMENT_MESSAGE where (CHANNEL_ID = x'2F616E6E6F756E63656D656E742F6368616E6E656C2F61636331613261612D333531342D343631352D386331342D3136663330623962626136372F6D61696E' )order by MESSAGE_DATE asc
> 2012/10/30 10:13:30.954919 <-
> GOT_RES
> 2012/10/30 10:13:30.955286 <-
> GOT_RES
> 2012/10/30 10:13:30.955290 <-
> GOT_RES
> 2012/10/30 10:13:30.955295 <-
> GOT_RES
> 2012/10/30 10:13:30.955794 <-
> GOT_RES
> 2012/10/30 10:13:30.955829 <-
> GOT_RES
> 2012/10/30 10:13:30.955912 <-
> GOT_RES
> 2012/10/30 10:13:30.955915 <-
> GOT_RES
> 2012/10/30 10:13:30.963844 ->
> select count(1) from SAKAI_REALM_RL_FN MAINTABLE LEFT JOIN SAKAI_REALM_RL_GR GRANTED_ROLES ON (MAINTABLE.REALM_KEY = GRANTED_ROLES.REALM_KEY AND MAINTABLE.ROLE_KEY = GRANTED_ROLES.ROLE_KEY), SAKAI_REALM REALMS, SAKAI_REALM_ROLE ROLES, SAKAI_REALM_FUNCTION FUNCTIONS where (ROLES.ROLE_NAME in('.anon','.auth') or (GRANTED_ROLES.USER_ID = x'37656530386530622D626530652D343633302D623833642D383335346438616364313032' AND GRANTED_ROLES.ACTIVE = 1)) AND FUNCTIONS.FUNCTION_NAME = x'616E6E632E616C6C2E67726F757073' AND REALMS.REALM_ID in (x'2F736974652F61636331613261612D333531342D343631352D386331342D313666333062396262613637') AND MAINTABLE.REALM_KEY = REALMS.REALM_KEY AND MAINTABLE.FUNCTION_KEY = FUNCTIONS.FUNCTION_KEY AND MAINTABLE.ROLE_KEY = ROLES.ROLE_KEY
> 2012/10/30 10:13:30.964377 <-
> GOT_RES
> 2012/10/30 10:13:36.572547 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F63393132656336652D646562622D343662322D383434302D383866626361626134653031' and SRRG.USER_ID = x'65316438356262612D653532342D343335312D383534382D373637613265393839313033' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:36.573053 <-
> GOT_RES
> 2012/10/30 10:13:36.584021 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F63393132656336652D646562622D343662322D383434302D383866626361626134653031' and SRRG.USER_ID = x'65316438356262612D653532342D343335312D383534382D373637613265393839313033' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:36.584186 <-
> GOT_RES
> 2012/10/30 10:13:36.597985 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F63393132656336652D646562622D343662322D383434302D383866626361626134653031' and SRRG.USER_ID = x'65316438356262612D653532342D343335312D383534382D373637613265393839313033' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:36.598391 <-
> GOT_RES
> 2012/10/30 10:13:36.607930 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F63393132656336652D646562622D343662322D383434302D383866626361626134653031' and SRRG.USER_ID = x'65316438356262612D653532342D343335312D383534382D373637613265393839313033' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:36.608822 <-
> GOT_RES
> 2012/10/30 10:13:36.615379 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F63393132656336652D646562622D343662322D383434302D383866626361626134653031' and SRRG.USER_ID = x'65316438356262612D653532342D343335312D383534382D373637613265393839313033' and SRRG.ACTIVE = '1'
> 2012/10/30 10:13:36.615528 <-
> GOT_RES
> 2012/10/30 10:13:36.817952 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'39636363316433312D613331382D343061322D393230392D353530386161323963666639'
> 2012/10/30 10:13:36.818215 <-
> GOT_RES
> 2012/10/30 10:13:36.826287 ->
> select SAKAI_REALM.REALM_ID,SAKAI_REALM.PROVIDER_ID,(select MAX(ROLE_NAME) from SAKAI_REALM_ROLE where ROLE_KEY = MAINTAIN_ROLE),SAKAI_REALM.CREATEDBY,SAKAI_REALM.MODIFIEDBY,SAKAI_REALM.CREATEDON,SAKAI_REALM.MODIFIEDON,SAKAI_REALM.REALM_KEY from SAKAI_REALM where ( REALM_ID = x'2F736974652F63313433396361622D643130312D346564392D393237332D666364303266313930623739' )
> 2012/10/30 10:13:36.826459 <-
> GOT_RES
> 2012/10/30 10:13:36.826846 ->
> SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_FUNCTION.FUNCTION_NAME FROM SAKAI_REALM_RL_FN INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_FN.REALM_KEY AND SAKAI_REALM.REALM_ID = x'2F736974652F63313433396361622D643130312D346564392D393237332D666364303266313930623739' INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_FN.ROLE_KEY INNER JOIN SAKAI_REALM_FUNCTION ON SAKAI_REALM_FUNCTION.FUNCTION_KEY = SAKAI_REALM_RL_FN.FUNCTION_KEY
> 2012/10/30 10:13:36.828013 <-
> GOT_RES
> 2012/10/30 10:13:36.828375 <-
> GOT_RES
> 2012/10/30 10:13:36.828640 <-
> GOT_RES
> 2012/10/30 10:13:36.828717 <-
> GOT_RES
> 2012/10/30 10:13:36.829170 <-
> GOT_RES
> 2012/10/30 10:13:36.829176 <-
> GOT_OK
> 2012/10/30 10:13:36.830804 ->
> SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_ROLE_DESC.DESCRIPTION, SAKAI_REALM_ROLE_DESC.PROVIDER_ONLY FROM SAKAI_REALM_ROLE_DESC INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_ROLE_DESC.REALM_KEY AND SAKAI_REALM.REALM_ID = x'2F736974652F63313433396361622D643130312D346564392D393237332D666364303266313930623739' INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_ROLE_DESC.ROLE_KEY
> 2012/10/30 10:13:36.831026 <-
> GOT_RES
> 2012/10/30 10:13:36.831344 ->
> SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_RL_GR.USER_ID, SAKAI_REALM_RL_GR.ACTIVE, SAKAI_REALM_RL_GR.PROVIDED FROM SAKAI_REALM_RL_GR INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_GR.REALM_KEY AND SAKAI_REALM.REALM_ID = x'2F736974652F63313433396361622D643130312D346564392D393237332D666364303266313930623739' INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_GR.ROLE_KEY
> 2012/10/30 10:13:36.831582 <-
> GOT_RES
> 2012/10/30 10:13:36.831588 <-
> GOT_RES
> 2012/10/30 10:13:36.886078 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'39636363316433312D613331382D343061322D393230392D353530386161323963666639'
> 2012/10/30 10:13:36.886277 <-
> GOT_RES
> 2012/10/30 10:13:36.886970 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'39636363316433312D613331382D343061322D393230392D353530386161323963666639'
> 2012/10/30 10:13:36.887361 <-
> GOT_RES
> 2012/10/30 10:13:36.903759 ->
> select areaimpl0_.ID as ID95_0_, membership1_.ID as ID102_1_, areaimpl0_.VERSION as VERSION95_0_, areaimpl0_.UUID as UUID95_0_, areaimpl0_.CREATED as CREATED95_0_, areaimpl0_.CREATED_BY as CREATED5_95_0_, areaimpl0_.MODIFIED as MODIFIED95_0_, areaimpl0_.MODIFIED_BY as MODIFIED7_95_0_, areaimpl0_.CONTEXT_ID as CONTEXT8_95_0_, areaimpl0_.NAME as NAME95_0_, areaimpl0_.HIDDEN as HIDDEN95_0_, areaimpl0_.TYPE_UUID as TYPE11_95_0_, areaimpl0_.ENABLED as ENABLED95_0_, areaimpl0_.SENDEMAILOUT as SENDEMA13_95_0_, areaimpl0_.LOCKED as LOCKED95_0_, areaimpl0_.MODERATED as MODERATED95_0_, areaimpl0_.AUTO_MARK_THREADS_READ as AUTO16_95_0_, areaimpl0_.AVAILABILITY_RESTRICTED as AVAILAB17_95_0_, areaimpl0_.AVAILABILITY as AVAILAB18_95_0_, areaimpl0_.OPEN_DATE as OPEN19_95_0_, areaimpl0_.CLOSE_DATE as CLOSE20_95_0_, membership1_.VERSION as VERSION102_1_, membership1_.UUID as UUID102_1_, membership1_.CREATED as CREATED102_1_, membership1_.CREATED_BY as CREATED5_102_1_, membership1_.MODIFIED as MODIFIED102_1_, membership1_.MODIFIED_BY as MODIFIED7_102_1_, membership1_.NAME as NAME102_1_, membership1_.TYPE as TYPE102_1_, membership1_.PERMISSION_LEVEL_NAME as PERMISSION10_102_1_, membership1_.PERMISSION_LEVEL as PERMISSION11_102_1_, membership1_.t_surrogateKey as t12_102_1_, membership1_.of_surrogateKey as of13_102_1_, membership1_.a_surrogateKey as a14_102_1_, membership1_.a_surrogateKey as a14_0__, membership1_.ID as ID0__ from MFR_AREA_T
> 2012/10/30 10:13:36.904078 <-
> GOT_RES
> 2012/10/30 10:13:36.904091 <-
> GOT_RES
> 2012/10/30 10:13:36.904994 ->
> commit
>
> From 10.0.40.250:33003
> 2012/10/30 10:12:00.279640 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'524D393238'
> 2012/10/30 10:12:00.279775 <-
> GOT_RES
> 2012/10/30 10:12:49.506595 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'524D31313831'
> 2012/10/30 10:12:49.506763 <-
> GOT_RES
> 2012/10/30 10:13:37.195507 ->
> select XML, BINARY_ENTITY from CONTENT_RESOURCE where (RESOURCE_ID = x'2F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C')
> 2012/10/30 10:13:37.195681 <-
> GOT_RES
> 2012/10/30 10:13:37.196396 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F7075626C69632F')
> 2012/10/30 10:13:37.196532 <-
> GOT_RES
> 2012/10/30 10:13:37.197185 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F')
> 2012/10/30 10:13:37.197293 <-
> GOT_RES
> 2012/10/30 10:13:37.198128 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F7075626C69632F',x'2F636F6E74656E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'636F6E74656E742E72656164') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'31363163306635382D373437632D343261342D623432622D353662646534653733626461' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F7075626C69632F',x'2F636F6E74656E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:37.198564 <-
> GOT_RES
> 2012/10/30 10:13:37.199520 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F7075626C69632F',x'2F636F6E74656E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'636F6E74656E742E68696464656E') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = x'31363163306635382D373437632D343261342D623432622D353662646534653733626461' and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F7075626C69632F',x'2F636F6E74656E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> 2012/10/30 10:13:37.199830 <-
> GOT_RES
> 2012/10/30 10:13:37.222312 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F616E6E6F756E63656D656E742F6368616E6E656C2F7E31363163306635382D373437632D343261342D623432622D3536626465346537336264612F6D61696E',x'2F736974652F7E31363163306635382D373437632D343261342D623432622D353662646534653733626461',x'21736974652E68656C706572') and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = x'616E6E632E72656164') and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = null and REALM_KEY in (select REALM_KEY from SAKAI_REALM where SAKAI_REALM.REALM_ID IN (x'2F616E6E6F756E63656D656E742F6368616E6E656C2F7E31363163306635382D373437632D343261342D623432622D3536626465346537336264612F6D61696E',x'2F736974652F7E31363163306635382D373437632D343261342D623432622D353662646534653733626461',x'21736974652E68656C706572'))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') )
> 2012/10/30 10:13:37.222712 <-
> GOT_RES
> 2012/10/30 10:13:37.223476 ->
> select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID = SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = x'31363163306635382D373437632D343261342D623432622D353662646534653733626461' and SAKAI_SITE.IS_DELETED='N' and SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by SAKAI_SITE.TITLE ASC
> 2012/10/30 10:13:37.226220 <-
> GOT_RES
> 2012/10/30 10:13:37.227072 <-
> GOT_RES
> 2012/10/30 10:13:37.227806 <-
> GOT_RES
> 2012/10/30 10:13:37.227855 <-
> GOT_RES
> 2012/10/30 10:13:37.228468 <-
> GOT_RES
> 2012/10/30 10:13:37.228542 <-
> GOT_RES
> 2012/10/30 10:13:37.228625 <-
> GOT_RES
> 2012/10/30 10:13:37.229473 <-
> GOT_RES
> 2012/10/30 10:13:37.230433 <-
> GOT_RES
> 2012/10/30 10:13:37.231629 <-
> GOT_RES
> 2012/10/30 10:13:37.231633 <-
> GOT_RES
> 2012/10/30 10:13:37.233175 <-
> GOT_RES
> 2012/10/30 10:13:37.234236 <-
> GOT_RES
> 2012/10/30 10:13:37.234395 <-
> GOT_RES
> 2012/10/30 10:13:37.235160 <-
> GOT_RES
> 2012/10/30 10:13:37.235289 <-
> GOT_RES
> 2012/10/30 10:13:37.236610 <-
> GOT_RES
> 2012/10/30 10:13:37.237596 <-
> GOT_RES
> 2012/10/30 10:13:37.239224 <-
> GOT_RES
> 2012/10/30 10:13:37.239230 <-
> GOT_RES
> 2012/10/30 10:13:37.242872 ->
> select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID = SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = x'65656531663830312D353231352D343438302D613430362D373934613437613864383039' and SAKAI_SITE.IS_DELETED='N' and SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by SAKAI_SITE.TITLE ASC
> 2012/10/30 10:13:37.243477 <-
> GOT_RES
> 2012/10/30 10:13:37.243484 <-
> GOT_RES
> 2012/10/30 10:13:37.244780 ->
> insert into SAKAI_PRESENCE (SESSION_ID,LOCATION_ID) values ( x'30633662343734322D376665382D346466392D393830662D326463373761656262356437', x'3139343432322D70726573656E6365')
> 2012/10/30 10:13:37.244915 <-
> GOT_OK
> 2012/10/30 10:13:37.245941 ->
> commit
>
> From 10.0.42.143:48240
> 2012/10/30 10:12:30.144661 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'4D4431343937'
> 2012/10/30 10:12:30.144876 <-
> GOT_RES
> 2012/10/30 10:12:59.970547 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'63343831353739652D363934642D343664392D616535392D323139386231366236393932'
> 2012/10/30 10:12:59.970682 <-
> GOT_RES
> 2012/10/30 10:13:38.861208 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'4C4331313433'
> 2012/10/30 10:13:38.861337 <-
> GOT_RES
> 2012/10/30 10:13:38.863859 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'434232313136'
> 2012/10/30 10:13:38.863956 <-
> GOT_RES
> 2012/10/30 10:13:39.636588 ->
> select assignment0_.SUBMISSION_ID as SUBMISSION1_172_0_, submission1_.SUBMISSION_VERSION_ID as SUBMISSION1_173_1_, feedbackat2_.SUBMISSION_ATTACH_ID as SUBMISSION1_174_2_, submission3_.SUBMISSION_ATTACH_ID as SUBMISSION1_174_3_, assignment0_.VERSION as VERSION172_0_, assignment0_.ASSIGNMENT_ID as ASSIGNMENT3_172_0_, assignment0_.USER_ID as USER4_172_0_, assignment0_.RESUBMIT_CLOSE_DATE as RESUBMIT5_172_0_, assignment0_.NUM_SUB_ALLOWED as NUM6_172_0_, assignment0_.COMPLETED as COMPLETED172_0_, assignment0_.CREATED_BY as CREATED8_172_0_, assignment0_.CREATED_DATE as CREATED9_172_0_, assignment0_.MODIFIED_BY as MODIFIED10_172_0_, assignment0_.MODIFIED_DATE as MODIFIED11_172_0_, submission1_.VERSION as VERSION173_1_, submission1_.SUBMISSION_ID as SUBMISSION3_173_1_, submission1_.SUBMITTED_DATE as SUBMITTED4_173_1_, submission1_.SUBMITTED_VERSION_NUMBER as SUBMITTED5_173_1_, submission1_.FEEDBACK_RELEASED_DATE as FEEDBACK6_173_1_, submission1_.SUBMITTED_TEXT as SUBMITTED7_173_1_, submission1_.HONOR_PLEDGE as HONOR8_173_1_, submission1_.ANNOTATED_TEXT as ANNOTATED9_173_1_, submission1_.FEEDBACK_NOTES as FEEDBACK10_173_1_, submission1_.DRAFT as DRAFT173_1_, submission1_.CREATED_BY as CREATED12_173_1_, submission1_.CREATED_DATE as CREATED13_173_1_, submission1_.MODIFIED_BY as MODIFIED14_173_1_, submission1_.MODIFIED_DATE as MODIFIED15_173_1_, submission1_.LAST_FEEDBACK_BY as LAST16_173_1_, submission1_.LAST_FEEDBACK_DATE as LAS
> 2012/10/30 10:13:39.638061 <-
> GOT_RES
> 2012/10/30 10:13:39.638808 <-
> GOT_RES
> 2012/10/30 10:13:39.638816 <-
> GOT_RES
> 2012/10/30 10:13:39.638825 <-
> GOT_RES
> 2012/10/30 10:13:39.641605 ->
> select assignment0_.ASSIGNMENT_ID as ASSIGNMENT1_169_0_, assignment0_.VERSION as VERSION169_0_, assignment0_.GRADEBOOK_ITEM_ID as GRADEBOOK3_169_0_, assignment0_.CONTEXT as CONTEXT169_0_, assignment0_.TITLE as TITLE169_0_, assignment0_.DRAFT as DRAFT169_0_, assignment0_.SORT_INDEX as SORT7_169_0_, assignment0_.OPEN_DATE as OPEN8_169_0_, assignment0_.ACCEPT_UNTIL_DATE as ACCEPT9_169_0_, assignment0_.GRADED as GRADED169_0_, assignment0_.DUE_DATE as DUE11_169_0_, assignment0_.HONOR_PLEDGE as HONOR12_169_0_, assignment0_.INSTRUCTIONS as INSTRUC13_169_0_, assignment0_.REQUIRES_SUBMISSION as REQUIRES14_169_0_, assignment0_.SUBMISSION_TYPE as SUBMISSION15_169_0_, assignment0_.SEND_SUBMISSION_NOTIF as SEND16_169_0_, assignment0_.HAS_ANNOUNCEMENT as HAS17_169_0_, assignment0_.ANNOUNCEMENT_ID as ANNOUNC18_169_0_, assignment0_.ADDED_TO_SCHEDULE as ADDED19_169_0_, assignment0_.EVENT_ID as EVENT20_169_0_, assignment0_.NUM_SUB_ALLOWED as NUM21_169_0_, assignment0_.CONTENT_REVIEW_ENABLED as CONTENT22_169_0_, assignment0_.CONTENT_REVIEW_REF as CONTENT23_169_0_, assignment0_.MODEL_ANSWER_ENABLED as MODEL24_169_0_, assignment0_.MODEL_ANSWER_TEXT as MODEL25_169_0_, assignment0_.MODEL_ANSWER_DISPLAY_RULE as MODEL26_169_0_, assignment0_.CREATOR as CREATOR169_0_, assignment0_.CREATE_DATE as CREATE28_169_0_, assignment0_.MODIFIED_BY as MODIFIED29_169_0_, assignment0_.MODIFIED_DATE as MODIFIED30_169_0_, assignment0_.REMOVED as REMOVED169_0_ fr
> 2012/10/30 10:13:39.641820 <-
> GOT_RES
> 2012/10/30 10:13:39.641827 <-
> GOT_RES
> 2012/10/30 10:13:39.643109 ->
> select assignment0_.ASSIGNMENT_ID as ASSIGNMENT1_169_0_, assignment0_.VERSION as VERSION169_0_, assignment0_.GRADEBOOK_ITEM_ID as GRADEBOOK3_169_0_, assignment0_.CONTEXT as CONTEXT169_0_, assignment0_.TITLE as TITLE169_0_, assignment0_.DRAFT as DRAFT169_0_, assignment0_.SORT_INDEX as SORT7_169_0_, assignment0_.OPEN_DATE as OPEN8_169_0_, assignment0_.ACCEPT_UNTIL_DATE as ACCEPT9_169_0_, assignment0_.GRADED as GRADED169_0_, assignment0_.DUE_DATE as DUE11_169_0_, assignment0_.HONOR_PLEDGE as HONOR12_169_0_, assignment0_.INSTRUCTIONS as INSTRUC13_169_0_, assignment0_.REQUIRES_SUBMISSION as REQUIRES14_169_0_, assignment0_.SUBMISSION_TYPE as SUBMISSION15_169_0_, assignment0_.SEND_SUBMISSION_NOTIF as SEND16_169_0_, assignment0_.HAS_ANNOUNCEMENT as HAS17_169_0_, assignment0_.ANNOUNCEMENT_ID as ANNOUNC18_169_0_, assignment0_.ADDED_TO_SCHEDULE as ADDED19_169_0_, assignment0_.EVENT_ID as EVENT20_169_0_, assignment0_.NUM_SUB_ALLOWED as NUM21_169_0_, assignment0_.CONTENT_REVIEW_ENABLED as CONTENT22_169_0_, assignment0_.CONTENT_REVIEW_REF as CONTENT23_169_0_, assignment0_.MODEL_ANSWER_ENABLED as MODEL24_169_0_, assignment0_.MODEL_ANSWER_TEXT as MODEL25_169_0_, assignment0_.MODEL_ANSWER_DISPLAY_RULE as MODEL26_169_0_, assignment0_.CREATOR as CREATOR169_0_, assignment0_.CREATE_DATE as CREATE28_169_0_, assignment0_.MODIFIED_BY as MODIFIED29_169_0_, assignment0_.MODIFIED_DATE as MODIFIED30_169_0_, assignment0_.REMOVED as REMOVED169_0_ fr
> 2012/10/30 10:13:39.643289 <-
> GOT_RES
> 2012/10/30 10:13:39.643296 <-
> GOT_RES
> 2012/10/30 10:13:39.644504 ->
> select assignment0_.ASSIGNMENT_ID as ASSIGNMENT1_169_0_, assignment0_.VERSION as VERSION169_0_, assignment0_.GRADEBOOK_ITEM_ID as GRADEBOOK3_169_0_, assignment0_.CONTEXT as CONTEXT169_0_, assignment0_.TITLE as TITLE169_0_, assignment0_.DRAFT as DRAFT169_0_, assignment0_.SORT_INDEX as SORT7_169_0_, assignment0_.OPEN_DATE as OPEN8_169_0_, assignment0_.ACCEPT_UNTIL_DATE as ACCEPT9_169_0_, assignment0_.GRADED as GRADED169_0_, assignment0_.DUE_DATE as DUE11_169_0_, assignment0_.HONOR_PLEDGE as HONOR12_169_0_, assignment0_.INSTRUCTIONS as INSTRUC13_169_0_, assignment0_.REQUIRES_SUBMISSION as REQUIRES14_169_0_, assignment0_.SUBMISSION_TYPE as SUBMISSION15_169_0_, assignment0_.SEND_SUBMISSION_NOTIF as SEND16_169_0_, assignment0_.HAS_ANNOUNCEMENT as HAS17_169_0_, assignment0_.ANNOUNCEMENT_ID as ANNOUNC18_169_0_, assignment0_.ADDED_TO_SCHEDULE as ADDED19_169_0_, assignment0_.EVENT_ID as EVENT20_169_0_, assignment0_.NUM_SUB_ALLOWED as NUM21_169_0_, assignment0_.CONTENT_REVIEW_ENABLED as CONTENT22_169_0_, assignment0_.CONTENT_REVIEW_REF as CONTENT23_169_0_, assignment0_.MODEL_ANSWER_ENABLED as MODEL24_169_0_, assignment0_.MODEL_ANSWER_TEXT as MODEL25_169_0_, assignment0_.MODEL_ANSWER_DISPLAY_RULE as MODEL26_169_0_, assignment0_.CREATOR as CREATOR169_0_, assignment0_.CREATE_DATE as CREATE28_169_0_, assignment0_.MODIFIED_BY as MODIFIED29_169_0_, assignment0_.MODIFIED_DATE as MODIFIED30_169_0_, assignment0_.REMOVED as REMOVED169_0_ fr
> 2012/10/30 10:13:39.644682 <-
> GOT_RES
> 2012/10/30 10:13:39.644688 <-
> GOT_RES
> 2012/10/30 10:13:39.645922 ->
> select assignment0_.ASSIGNMENT_ID as ASSIGNMENT1_169_0_, assignment0_.VERSION as VERSION169_0_, assignment0_.GRADEBOOK_ITEM_ID as GRADEBOOK3_169_0_, assignment0_.CONTEXT as CONTEXT169_0_, assignment0_.TITLE as TITLE169_0_, assignment0_.DRAFT as DRAFT169_0_, assignment0_.SORT_INDEX as SORT7_169_0_, assignment0_.OPEN_DATE as OPEN8_169_0_, assignment0_.ACCEPT_UNTIL_DATE as ACCEPT9_169_0_, assignment0_.GRADED as GRADED169_0_, assignment0_.DUE_DATE as DUE11_169_0_, assignment0_.HONOR_PLEDGE as HONOR12_169_0_, assignment0_.INSTRUCTIONS as INSTRUC13_169_0_, assignment0_.REQUIRES_SUBMISSION as REQUIRES14_169_0_, assignment0_.SUBMISSION_TYPE as SUBMISSION15_169_0_, assignment0_.SEND_SUBMISSION_NOTIF as SEND16_169_0_, assignment0_.HAS_ANNOUNCEMENT as HAS17_169_0_, assignment0_.ANNOUNCEMENT_ID as ANNOUNC18_169_0_, assignment0_.ADDED_TO_SCHEDULE as ADDED19_169_0_, assignment0_.EVENT_ID as EVENT20_169_0_, assignment0_.NUM_SUB_ALLOWED as NUM21_169_0_, assignment0_.CONTENT_REVIEW_ENABLED as CONTENT22_169_0_, assignment0_.CONTENT_REVIEW_REF as CONTENT23_169_0_, assignment0_.MODEL_ANSWER_ENABLED as MODEL24_169_0_, assignment0_.MODEL_ANSWER_TEXT as MODEL25_169_0_, assignment0_.MODEL_ANSWER_DISPLAY_RULE as MODEL26_169_0_, assignment0_.CREATOR as CREATOR169_0_, assignment0_.CREATE_DATE as CREATE28_169_0_, assignment0_.MODIFIED_BY as MODIFIED29_169_0_, assignment0_.MODIFIED_DATE as MODIFIED30_169_0_, assignment0_.REMOVED as REMOVED169_0_ fr
> 2012/10/30 10:13:39.646098 <-
> GOT_RES
> 2012/10/30 10:13:39.646105 <-
> GOT_RES
> 2012/10/30 10:13:39.647205 ->
> select assignment0_.ASSIGNMENT_ID as ASSIGNMENT1_169_0_, assignment0_.VERSION as VERSION169_0_, assignment0_.GRADEBOOK_ITEM_ID as GRADEBOOK3_169_0_, assignment0_.CONTEXT as CONTEXT169_0_, assignment0_.TITLE as TITLE169_0_, assignment0_.DRAFT as DRAFT169_0_, assignment0_.SORT_INDEX as SORT7_169_0_, assignment0_.OPEN_DATE as OPEN8_169_0_, assignment0_.ACCEPT_UNTIL_DATE as ACCEPT9_169_0_, assignment0_.GRADED as GRADED169_0_, assignment0_.DUE_DATE as DUE11_169_0_, assignment0_.HONOR_PLEDGE as HONOR12_169_0_, assignment0_.INSTRUCTIONS as INSTRUC13_169_0_, assignment0_.REQUIRES_SUBMISSION as REQUIRES14_169_0_, assignment0_.SUBMISSION_TYPE as SUBMISSION15_169_0_, assignment0_.SEND_SUBMISSION_NOTIF as SEND16_169_0_, assignment0_.HAS_ANNOUNCEMENT as HAS17_169_0_, assignment0_.ANNOUNCEMENT_ID as ANNOUNC18_169_0_, assignment0_.ADDED_TO_SCHEDULE as ADDED19_169_0_, assignment0_.EVENT_ID as EVENT20_169_0_, assignment0_.NUM_SUB_ALLOWED as NUM21_169_0_, assignment0_.CONTENT_REVIEW_ENABLED as CONTENT22_169_0_, assignment0_.CONTENT_REVIEW_REF as CONTENT23_169_0_, assignment0_.MODEL_ANSWER_ENABLED as MODEL24_169_0_, assignment0_.MODEL_ANSWER_TEXT as MODEL25_169_0_, assignment0_.MODEL_ANSWER_DISPLAY_RULE as MODEL26_169_0_, assignment0_.CREATOR as CREATOR169_0_, assignment0_.CREATE_DATE as CREATE28_169_0_, assignment0_.MODIFIED_BY as MODIFIED29_169_0_, assignment0_.MODIFIED_DATE as MODIFIED30_169_0_, assignment0_.REMOVED as REMOVED169_0_ fr
> 2012/10/30 10:13:39.647404 <-
> GOT_RES
> 2012/10/30 10:13:39.647411 <-
> GOT_RES
> 2012/10/30 10:13:39.648717 ->
> select assignment0_.ASSIGNMENT_ID as ASSIGNMENT1_169_0_, assignment0_.VERSION as VERSION169_0_, assignment0_.GRADEBOOK_ITEM_ID as GRADEBOOK3_169_0_, assignment0_.CONTEXT as CONTEXT169_0_, assignment0_.TITLE as TITLE169_0_, assignment0_.DRAFT as DRAFT169_0_, assignment0_.SORT_INDEX as SORT7_169_0_, assignment0_.OPEN_DATE as OPEN8_169_0_, assignment0_.ACCEPT_UNTIL_DATE as ACCEPT9_169_0_, assignment0_.GRADED as GRADED169_0_, assignment0_.DUE_DATE as DUE11_169_0_, assignment0_.HONOR_PLEDGE as HONOR12_169_0_, assignment0_.INSTRUCTIONS as INSTRUC13_169_0_, assignment0_.REQUIRES_SUBMISSION as REQUIRES14_169_0_, assignment0_.SUBMISSION_TYPE as SUBMISSION15_169_0_, assignment0_.SEND_SUBMISSION_NOTIF as SEND16_169_0_, assignment0_.HAS_ANNOUNCEMENT as HAS17_169_0_, assignment0_.ANNOUNCEMENT_ID as ANNOUNC18_169_0_, assignment0_.ADDED_TO_SCHEDULE as ADDED19_169_0_, assignment0_.EVENT_ID as EVENT20_169_0_, assignment0_.NUM_SUB_ALLOWED as NUM21_169_0_, assignment0_.CONTENT_REVIEW_ENABLED as CONTENT22_169_0_, assignment0_.CONTENT_REVIEW_REF as CONTENT23_169_0_, assignment0_.MODEL_ANSWER_ENABLED as MODEL24_169_0_, assignment0_.MODEL_ANSWER_TEXT as MODEL25_169_0_, assignment0_.MODEL_ANSWER_DISPLAY_RULE as MODEL26_169_0_, assignment0_.CREATOR as CREATOR169_0_, assignment0_.CREATE_DATE as CREATE28_169_0_, assignment0_.MODIFIED_BY as MODIFIED29_169_0_, assignment0_.MODIFIED_DATE as MODIFIED30_169_0_, assignment0_.REMOVED as REMOVED169_0_ fr
> 2012/10/30 10:13:39.648932 <-
> GOT_RES
> 2012/10/30 10:13:39.648939 <-
> GOT_RES
> 2012/10/30 10:13:39.650025 ->
> select assignment0_.ASSIGNMENT_ID as ASSIGNMENT1_169_0_, assignment0_.VERSION as VERSION169_0_, assignment0_.GRADEBOOK_ITEM_ID as GRADEBOOK3_169_0_, assignment0_.CONTEXT as CONTEXT169_0_, assignment0_.TITLE as TITLE169_0_, assignment0_.DRAFT as DRAFT169_0_, assignment0_.SORT_INDEX as SORT7_169_0_, assignment0_.OPEN_DATE as OPEN8_169_0_, assignment0_.ACCEPT_UNTIL_DATE as ACCEPT9_169_0_, assignment0_.GRADED as GRADED169_0_, assignment0_.DUE_DATE as DUE11_169_0_, assignment0_.HONOR_PLEDGE as HONOR12_169_0_, assignment0_.INSTRUCTIONS as INSTRUC13_169_0_, assignment0_.REQUIRES_SUBMISSION as REQUIRES14_169_0_, assignment0_.SUBMISSION_TYPE as SUBMISSION15_169_0_, assignment0_.SEND_SUBMISSION_NOTIF as SEND16_169_0_, assignment0_.HAS_ANNOUNCEMENT as HAS17_169_0_, assignment0_.ANNOUNCEMENT_ID as ANNOUNC18_169_0_, assignment0_.ADDED_TO_SCHEDULE as ADDED19_169_0_, assignment0_.EVENT_ID as EVENT20_169_0_, assignment0_.NUM_SUB_ALLOWED as NUM21_169_0_, assignment0_.CONTENT_REVIEW_ENABLED as CONTENT22_169_0_, assignment0_.CONTENT_REVIEW_REF as CONTENT23_169_0_, assignment0_.MODEL_ANSWER_ENABLED as MODEL24_169_0_, assignment0_.MODEL_ANSWER_TEXT as MODEL25_169_0_, assignment0_.MODEL_ANSWER_DISPLAY_RULE as MODEL26_169_0_, assignment0_.CREATOR as CREATOR169_0_, assignment0_.CREATE_DATE as CREATE28_169_0_, assignment0_.MODIFIED_BY as MODIFIED29_169_0_, assignment0_.MODIFIED_DATE as MODIFIED30_169_0_, assignment0_.REMOVED as REMOVED169_0_ fr
> 2012/10/30 10:13:39.650272 <-
> GOT_RES
> 2012/10/30 10:13:39.650277 <-
> GOT_RES
> 2012/10/30 10:13:39.651153 ->
> commit
>
> From 10.0.42.138:44737
> 2012/10/30 10:12:19.886782 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'63613234336135372D346632372D343034652D383165612D356632636530363266386635'
> 2012/10/30 10:12:19.886910 <-
> GOT_RES
> 2012/10/30 10:12:19.887437 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'34316431343663342D306537612D346462372D616265632D393264303638616632366531'
> 2012/10/30 10:12:19.887548 <-
> GOT_RES
> 2012/10/30 10:12:19.887970 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'34316431343663342D306537612D346462372D616265632D393264303638616632366531'
> 2012/10/30 10:12:19.888095 <-
> GOT_RES
> 2012/10/30 10:12:19.888741 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66656164346632382D663839322D346130352D626339662D613039633061363237386532'
> 2012/10/30 10:12:19.888854 <-
> GOT_RES
> 2012/10/30 10:12:19.889433 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66656164346632382D663839322D346130352D626339662D613039633061363237386532'
> 2012/10/30 10:12:19.889767 <-
> GOT_RES
> 2012/10/30 10:12:19.890327 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66656164346632382D663839322D346130352D626339662D613039633061363237386532'
> 2012/10/30 10:12:19.890441 <-
> GOT_RES
> 2012/10/30 10:12:19.891006 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'66656164346632382D663839322D346130352D626339662D613039633061363237386532'
> 2012/10/30 10:12:19.891130 <-
> GOT_RES
> 2012/10/30 10:12:19.891660 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'65393239633331312D643937642D343364662D393034652D643434356363633134343235'
> 2012/10/30 10:12:19.891796 <-
> GOT_RES
> 2012/10/30 10:12:19.892379 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'36383764656264372D356334302D346230612D383437392D626132333366323431316132'
> 2012/10/30 10:12:19.892597 <-
> GOT_RES
> 2012/10/30 10:12:19.945387 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313934343231' and SRRG.USER_ID = x'63663665363261302D303831352D346634322D613531322D363362363462363233656561' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:19.945563 <-
> GOT_RES
> 2012/10/30 10:12:30.252991 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'32616563303466622D343638372D343633622D383065632D373863393431393132353566'
> 2012/10/30 10:12:30.254541 <-
> GOT_RES
> 2012/10/30 10:12:30.351800 ->
> select RESOURCE_ID from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F55382D5136372E676966')
> 2012/10/30 10:12:30.352160 <-
> GOT_RES
> 2012/10/30 10:12:30.352666 ->
> select XML, BINARY_ENTITY from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F55382D5136372E676966')
> 2012/10/30 10:12:30.352854 <-
> GOT_RES
> 2012/10/30 10:12:30.353366 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F')
> 2012/10/30 10:12:30.353666 <-
> GOT_RES
> 2012/10/30 10:12:30.354135 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F')
> 2012/10/30 10:12:30.354358 <-
> GOT_RES
> 2012/10/30 10:12:30.355071 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F')
> 2012/10/30 10:12:30.355238 <-
> GOT_RES
> 2012/10/30 10:12:30.355887 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F')
> 2012/10/30 10:12:30.356196 <-
> GOT_RES
> 2012/10/30 10:12:30.356942 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F')
> 2012/10/30 10:12:30.357131 <-
> GOT_RES
> 2012/10/30 10:12:30.357845 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F')
> 2012/10/30 10:12:30.358137 <-
> GOT_RES
> 2012/10/30 10:12:30.358922 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F')
> 2012/10/30 10:12:30.359173 <-
> GOT_RES
> 2012/10/30 10:12:30.359843 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F')
> 2012/10/30 10:12:30.359966 <-
> GOT_RES
> 2012/10/30 10:12:30.360930 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E69745465737473
> 2012/10/30 10:12:30.363616 <-
> GOT_RES
> 2012/10/30 10:12:30.364902 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E69745465737473
> 2012/10/30 10:12:30.367518 <-
> GOT_RES
> 2012/10/30 10:12:30.391630 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'32616563303466622D343638372D343633622D383065632D373863393431393132353566'
> 2012/10/30 10:12:30.392457 <-
> GOT_RES
> 2012/10/30 10:12:32.610462 ->
> select RESOURCE_ID from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F55382D513131352E676966')
> 2012/10/30 10:12:32.610759 <-
> GOT_RES
> 2012/10/30 10:12:32.611084 ->
> select XML, BINARY_ENTITY from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F55382D513131352E676966')
> 2012/10/30 10:12:32.611896 <-
> GOT_RES
> 2012/10/30 10:12:32.612192 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F')
> 2012/10/30 10:12:32.612410 <-
> GOT_RES
> 2012/10/30 10:12:32.612912 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F')
> 2012/10/30 10:12:32.613177 <-
> GOT_RES
> 2012/10/30 10:12:32.613606 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F')
> 2012/10/30 10:12:32.613763 <-
> GOT_RES
> 2012/10/30 10:12:32.614969 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F')
> 2012/10/30 10:12:32.615305 <-
> GOT_RES
> 2012/10/30 10:12:32.616150 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F')
> 2012/10/30 10:12:32.616352 <-
> GOT_RES
> 2012/10/30 10:12:32.616765 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F')
> 2012/10/30 10:12:32.616995 <-
> GOT_RES
> 2012/10/30 10:12:32.617797 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F')
> 2012/10/30 10:12:32.618075 <-
> GOT_RES
> 2012/10/30 10:12:32.618777 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F')
> 2012/10/30 10:12:32.618994 <-
> GOT_RES
> 2012/10/30 10:12:32.619640 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E69745465737473
> 2012/10/30 10:12:32.633075 <-
> GOT_RES
> 2012/10/30 10:12:32.633790 ->
> select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID IN (x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E69745465737473
> 2012/10/30 10:12:32.638982 <-
> GOT_RES
> 2012/10/30 10:12:35.37739 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313934343231' and SRRG.USER_ID = x'63663665363261302D303831352D346634322D613531322D363362363462363233656561' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:35.38402 <-
> GOT_RES
> 2012/10/30 10:12:35.39686 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313934343231' and SRRG.USER_ID = x'63663665363261302D303831352D346634322D613531322D363362363462363233656561' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:35.41383 <-
> GOT_RES
> 2012/10/30 10:12:35.45972 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313934343231' and SRRG.USER_ID = x'63663665363261302D303831352D346634322D613531322D363362363462363233656561' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:35.46347 <-
> GOT_RES
> 2012/10/30 10:12:35.56145 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313934343231' and SRRG.USER_ID = x'63663665363261302D303831352D346634322D613531322D363362363462363233656561' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:35.57139 <-
> GOT_RES
> 2012/10/30 10:12:35.59280 ->
> select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SRRG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = SRR.ROLE_KEY where SR.REALM_ID = x'2F736974652F313934343231' and SRRG.USER_ID = x'63663665363261302D303831352D346634322D613531322D363362363462363233656561' and SRRG.ACTIVE = '1'
> 2012/10/30 10:12:35.60121 <-
> GOT_RES
> 2012/10/30 10:12:38.830954 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'414C31373839'
> 2012/10/30 10:12:38.831091 <-
> GOT_RES
> 2012/10/30 10:12:47.577545 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'445331373036'
> 2012/10/30 10:12:47.577682 <-
> GOT_RES
> 2012/10/30 10:12:57.787376 ->
> select EID from SAKAI_USER_ID_MAP where USER_ID=x'535731333937'
> 2012/10/30 10:12:57.787510 <-
> GOT_RES
> 2012/10/30 10:13:41.856600 ->
> select RESOURCE_ID from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F55382D5135312E676966')
> 2012/10/30 10:13:41.856801 <-
> GOT_RES
> 2012/10/30 10:13:41.857581 ->
> select XML, BINARY_ENTITY from CONTENT_RESOURCE where (RESOURCE_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F55382D5135312E676966')
> 2012/10/30 10:13:41.857707 <-
> GOT_RES
> 2012/10/30 10:13:41.858470 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F')
> 2012/10/30 10:13:41.858685 <-
> GOT_RES
> 2012/10/30 10:13:41.859400 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F556E697454657374732F')
> 2012/10/30 10:13:41.859869 <-
> GOT_RES
> 2012/10/30 10:13:41.860286 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C617373387765656B732F')
> 2012/10/30 10:13:41.860414 <-
> GOT_RES
> 2012/10/30 10:13:41.861111 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F')
> 2012/10/30 10:13:41.861251 <-
> GOT_RES
> 2012/10/30 10:13:41.861933 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F')
> 2012/10/30 10:13:41.862049 <-
> GOT_RES
> 2012/10/30 10:13:41.862552 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F')
> 2012/10/30 10:13:41.862712 <-
> GOT_RES
> 2012/10/30 10:13:41.863525 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F67726F75702F')
> 2012/10/30 10:13:41.863717 <-
> GOT_RES
> 2012/10/30 10:13:41.864284 ->
> select XML, BINARY_ENTITY from CONTENT_COLLECTION where (COLLECTION_ID = x'2F')
> 2012/10/30 10:13:41.864382 <-
> GOT_RES
> 2012/10/30 10:13:41.866445 ->
> select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_HOSTNAME,SESSION_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from SAKAI_SESSION where SESSION_ID = x'32616563303466622D343638372D343633622D383065632D373863393431393132353566'
> 2012/10/30 10:13:41.866692 <-
> GOT_RES
> 2012/10/30 10:13:42.910060 ->
> select unreadstat0_.ID as ID94_, unreadstat0_.VERSION as VERSION94_, unreadstat0_.TOPIC_C as TOPIC3_94_, unreadstat0_.MESSAGE_C as MESSAGE4_94_, unreadstat0_.USER_C as USER5_94_, unreadstat0_.READ_C as READ6_94_ from MFR_UNREAD_STATUS_T unreadstat0_ where unreadstat0_.MESSAGE_C=18147845 and unreadstat0_.TOPIC_C=2939727 and unreadstat0_.USER_C='cf6e62a0-0815-4f42-a512-63b64b623eea'
> 2012/10/30 10:13:42.910233 <-
> GOT_RES
> 2012/10/30 10:13:42.911055 ->
> commit
>
> From: Steve Swinsburg [mailto:steve.swinsburg at gmail.com]
> Sent: Monday, October 29, 2012 8:08 PM
> To: Kusnetz, Jeremy
> Cc: sakai-dev at collab.sakaiproject.org
> Subject: Re: [Building Sakai] autocommit
>
> This post has some info about tracking long running transactions:
> http://yoshinorimatsunobu.blogspot.com.au/2011/04/tracking-long-running-transactions-in.html
>
> It would be interesting to see what queries are being run inside the transactions. Transactions should be discrete and atomic, there shouldn't be 1000s of queries inside one, that sounds bad!
>
> cheers,
> Steve
>
>
>
>
>
> On 30/10/2012, at 10:49 AM, "Kusnetz, Jeremy" <JKusnetz at APUS.EDU> wrote:
>
>
> I’m not sure how to tell. I asked oracle and they didn’t really answer directly other than saying 1000’s of queries could have been run in the transaction. Any idea how to tell what they were?
>
> From: Steve Swinsburg [mailto:steve.swinsburg at gmail.com]
> Sent: Monday, October 29, 2012 7:21 PM
> To: Kusnetz, Jeremy
> Cc: sakai-dev at collab.sakaiproject.org
> Subject: Re: [Building Sakai] autocommit
>
> Hi Jeremy,
>
> Do you have any idea what transactions are running for so long? I agree, anything over a few seconds is too long.
>
> cheers,
> Steve
>
>
> On 30/10/2012, at 6:00 AM, "Kusnetz, Jeremy" <JKusnetz at APUS.EDU> wrote:
>
>
>
> We are having Oracle look at our MySQL performance. We had a pretty big database performance hit for a short time last night. They noted the following about long running transactions that haven’t been commited. I’ve read this thread: http://collab.sakaiproject.org/pipermail/sakai-dev/2009-July/002772.html But has there been any change? If things still stand as of 2.8 to where they were in this thread it looks like it’s possibly not cycling through our connection pools resetting that transaction. We were thinking about trying to turn on autocommit on a node or two to see what happens, but now that I read this there looks like there may be issues.
>
> On the MySQL end I thought about changing wait_timeout to something reasonable, right now ours is set to pretty much never timeout (1 year!). But what kind of problem would it cause if it closes one of those transactions that was open for a long time but not commited. Would it just get recycled? What other things could it timeout and close that shouldn’t be? I’m thinking this might be the right path to go. What value would make sense? I was thinking of starting conservatively, maybe 8-24 hours and go down from there. As you will see, Oracle recommends 1 minute which I think is way too short.
>
> Here is what I got from Oracle:
>
> Having an old TRANSACTION can become a very serious problem. What he noted was that some of your transactions have been active for more than 64 hours without either issuing a COMMIT command or a ROLLBACK command. Except in extremely rare situations, I cannot imagine a need for any transaction to remain active for more than about half an hour. In fact, I prefer to design my code so that transactions start and complete in less than a few seconds. Having several transactions lasting multiple DAYS seems like horribly incorrect application design and can lead to horrible database performance.
>
> I would make sense to me to have a wait_timeout set to 60 seconds or less. However, I did not write your applications so I cannot say what may be an appropriate value for wait_timeout. There are four things you need to check:
>
> 1) Did your application or your connection parameters incorrectly disable autocommit?
> 2) Does your connection pool have a timer for 'most time a connection can remain idle in the pool before being killed'
> 3) Are there execution paths in your application that result in a valid START TRANSACTION that would not be followed by a COMMIT or ROLLBACK before the connection is returned to the pool?
> 4) Does your application return connections to the pool by abandoning the connection object or does it do the appropriate .Close() method for your connection library?
>
> What you see is almost always the result of either bad configuration choices or sloppy programming. Setting the wait_timeout timer to a very low value can force those connections to close but if the application is not prepared to repeat the contents of a valid transaction that may be force-terminated when the connection is killed by the timer, it may start giving you new problems.
>
> The simple thing to do is to first double-check that your application and connection parameters are not accidentally disabling the default autocommit behavior.
> This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
>
> _______________________________________________
> 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"
>
> This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
>
>
> This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
>
> This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121106/84dcfbbd/attachment.html
More information about the sakai-dev
mailing list