[Building Sakai] autocommit

Mon Nov 5 11:46:08 PST 2012

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_DES
C,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_S
ITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAK
AI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CR
EATEDBY,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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'61386136633234642D366232612D346436302D393062652D6261643764393438373236
62'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'65383430626430342D373063612D343866642D393836352D3466656631323961633761
30'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'65383430626430342D373063612D343866642D393836352D3466656631323961633761
30'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'65383430626430342D373063612D343866642D393836352D3466656631323961633761
30'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'65383430626430342D373063612D343866642D393836352D3466656631323961633761
30'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'65383430626430342D373063612D343866642D393836352D3466656631323961633761
30'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'64333163626162342D653830392D346634372D383538652D6264366630353561316666
36'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'64333163626162342D653830392D346634372D383538652D6264366630353561316666
36'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'63363233383061342D346636372D346135392D393265332D6135663631313832633165
36'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'61353164656366302D386539352D343664632D616664322D3238343533343436333532
37'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'62333365353437392D366661642D343734632D623133332D6135306665663061366637
31'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'31313937363435342D663433632D343236322D613437332D6661626537336461623664
65'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'62396365633130362D616634622D346137382D613232662D3261633063313366306334
61'

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'30613733343161632D383865652D346662612D626633352D35373237623765
6663653565'

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'62396662383563662D633765652D343737612D616236622D38363134376535
3434666639'

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'39306364646539642D376565642D343966352D383966392D61616132333964
6533376233'

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_DES
C,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_S
ITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAK
AI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CR
EATEDBY,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.CREA
TEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON
from SAKAI_USER where ( USER_ID =
x'37623431336233352D396236372D343831652D623633382D6539353736396261623436
66' )

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'37623431336233352D396236372D343831652D623633382D6539353736396261623436
66' 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'2F757365722F37623431336233352D396236372D3
43831652D623633382D653935373639626162343666',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'37623431336233352D396236372D343831652D623633382D6539353736396261623436
66'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313837343933',x'2F757365722F37623431336233352D396236372D3
43831652D623633382D653935373639626162343666',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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'66663462633931322D366363362D343732642D613237372D33643630383030
3534343564'

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'34383530663537372D343565312D343965302D626662372D37393330326336
3835376432'

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.CREA
TEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON
from SAKAI_USER where ( USER_ID =
x'31613030353363652D313364382D346563362D623864642D3436646532383935383036
35' )

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_DES
C,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_S
ITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAK
AI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CR
EATEDBY,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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36' 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'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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'2F67726F75702F6369746174696F6E7341646D696E2F636F6E6669672F636F6E666967
2E786D6C')

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'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F313937393430',x'2F757365722F32666361333763662D343132642D3
43663642D626138342D613662313639356239386236',x'21757365722E74656D706C617
4652E72656769737465726564',x'21757365722E74656D706C617465',x'21736974652
E68656C706572')))  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_DES
C,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_S
ITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAK
AI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CR
EATEDBY,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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36' 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_DES
C,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_S
ITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAK
AI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CR
EATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON
,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE where ( SITE_ID =
x'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236' )

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'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236' 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'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236' )

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'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236' 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'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236'

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'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236' )

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'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236' )

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'7E32666361333763662D343132642D343663642D626138342D61366231363935623938
6236' )

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'2F736974652F7E32666361333763662D343132642D343663642D626138342D6136623
13639356239386236',x'2F757365722F32666361333763662D343132642D343663642D6
26138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656
769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706
572') 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'32666361333763662D343132642D343663642D626138342D6136623136393562393862
36'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F736974652F7E32666361333763662D343132642D343663642D626138342D6136623
13639356239386236',x'2F757365722F32666361333763662D343132642D343663642D6
26138342D613662313639356239386236',x'21757365722E74656D706C6174652E72656
769737465726564',x'21757365722E74656D706C617465',x'21736974652E68656C706
572')))  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'2F636F6E74656
E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736
974652E68656C706572') 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'2F636F6E74656
E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736
974652E68656C706572')))  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'2F636F6E74656
E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736
974652E68656C706572') 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'2F636F6E74656
E742F67726F75702F6D6F6E69746F722F',x'2F736974652F6D6F6E69746F72',x'21736
974652E68656C706572')))  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'39373430623535322D373233612D343633302D623030392D3864386361653238336236
61', 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'35363962343566342D393238642D343937392D393531322D63633537333032
3966663439'

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'33616461306233352D393964362D346430642D613739322D65353332383035
6361613134'

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'63633636623133662D663962652D346136372D616233332D61653562343730
3038386333'

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'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F43
4F4C4C3130302F496D616765732F6C6573736F6E735F6C696E6B2E676966')

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'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F43
4F4C4C3130302F496D616765732F6C6573736F6E735F6C696E6B2E676966')

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'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F43
4F4C4C3130302F496D616765732F')

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'2F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F43
4F4C4C3130302F')

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'2F636F6E74656
E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F'
,x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732
D636F6D6D6F6E2F434F4C4C3130302F',x'2F636F6E74656E742F67726F75702F6172747
32D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D61676
5732F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746
965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F6C6573736F6E735F6C696
E6B2E676966',x'2F736974652F617274732D616E642D68756D616E69746965732D636F6
D6D6F6E',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'64343031316162612D373662312D343263362D623531322D3766313262636335383465
32'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656
E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F'
,x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732
D636F6D6D6F6E2F434F4C4C3130302F',x'2F636F6E74656E742F67726F75702F6172747
32

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'2F636F6E74656
E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F'
,x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732
D636F6D6D6F6E2F434F4C4C3130302F',x'2F636F6E74656E742F67726F75702F6172747
32D616E642D68756D616E69746965732D636F6D6D6F6E2F434F4C4C3130302F496D61676
5732F',x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746
965732D636F6D6D6F6E2F434F4C4C3130302F496D616765732F6C6573736F6E735F6C696
E6B2E676966',x'2F736974652F617274732D616E642D68756D616E69746965732D636F6
D6D6F6E',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'64343031316162612D373662312D343263362D623531322D3766313262636335383465
32'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F636F6E74656E742F',x'2F636F6E74656E742F67726F75702F',x'2F636F6E74656
E742F67726F75702F617274732D616E642D68756D616E69746965732D636F6D6D6F6E2F'
,x'2F636F6E74656E742F67726F75702F617274732D616E642D68756D616E69746965732
D636F6D6D6F6E2F434F4C4C3130302F',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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'39333530343831642D313333382D343565622D386635342D3435633862373763323335
65'

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'65633335343832642D646665382D346266362D623166612D33373665316336
3066333836'

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'35353738366139342D393239612D343138612D623834342D6132653663333966303864
62' 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'35353738366139342D393239612D343138612D623834342D6132653663333966303864
62' 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'35656462313161662D656231312D343836392D613062342D33323830376364
3264366236'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'34343032643161382D643835612D343662302D613731392D6638363164366639626432
30'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66656164346632382D663839322D346130352D626339662D6130396330613632373865
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66656164346632382D663839322D346130352D626339662D6130396330613632373865
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'62663164633463372D326666382D343166662D626665392D3830356230646463333365
37'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'62663164633463372D326666382D343166662D626665392D3830356230646463333365
37'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'39373430623535322D373233612D343633302D623030392D3864386361653238336236
61'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66633761326664642D333239622D343465322D393166632D3837333036663132346266
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66633761326664642D333239622D343465322D393166632D3837333036663132346266
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66633761326664642D333239622D343465322D393166632D3837333036663132346266
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66633761326664642D333239622D343465322D393166632D3837333036663132346266
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'62396365633130362D616634622D346137382D613232662D3261633063313366306334
61'

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'38623732386234392D316334612D343436322D396263632D6636363161626563636236
36' 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'38623732386234392D316334612D343436322D396263632D6636363161626563636236
36' 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'38623732386234392D316334612D343436322D396263632D6636363161626563636236
36' 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'38623732386234392D316334612D343436322D396263632D6636363161626563636236
36' 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'38623732386234392D316334612D343436322D396263632D6636363161626563636236
36' 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.SESSI
ON_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.CREA
TEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON
from SAKAI_USER where ( USER_ID =
x'61613032376630622D336137302D343737342D393435342D3463306432646431333337
36' )

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.CREA
TEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON
from SAKAI_USER where ( USER_ID =
x'35333236383335612D326465362D346630392D616634632D6462356331383763353766
62' )

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'38653863376263322D336565312D343039622D626633392D39663438623334
3737373661'

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'2F616E6E6F756E63656D656E742F6368616E6E656C2F61636331613261612D33353134
2D343631352D386331342D3136663330623962626136372F6D61696E' )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'37656530386530622D626530652D343633302D623833642D3833353464386163643130
32' AND GRANTED_ROLES.ACTIVE = 1)) AND FUNCTIONS.FUNCTION_NAME =
x'616E6E632E616C6C2E67726F757073' AND REALMS.REALM_ID in
(x'2F736974652F61636331613261612D333531342D343631352D386331342D313666333
062396262613637')   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'2F736974652F63393132656336652D646562622D343662322D383434302D3838666263
61626134653031' and SRRG.USER_ID =
x'65316438356262612D653532342D343335312D383534382D3736376132653938393130
33' 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'2F736974652F63393132656336652D646562622D343662322D383434302D3838666263
61626134653031' and SRRG.USER_ID =
x'65316438356262612D653532342D343335312D383534382D3736376132653938393130
33' 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'2F736974652F63393132656336652D646562622D343662322D383434302D3838666263
61626134653031' and SRRG.USER_ID =
x'65316438356262612D653532342D343335312D383534382D3736376132653938393130
33' 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'2F736974652F63393132656336652D646562622D343662322D383434302D3838666263
61626134653031' and SRRG.USER_ID =
x'65316438356262612D653532342D343335312D383534382D3736376132653938393130
33' 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'2F736974652F63393132656336652D646562622D343662322D383434302D3838666263
61626134653031' and SRRG.USER_ID =
x'65316438356262612D653532342D343335312D383534382D3736376132653938393130
33' 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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'39636363316433312D613331382D343061322D393230392D3535303861613239636666
39'

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'2F736974652F63313433396361622D643130312D346564392D393237332D6663643032
66313930623739' )

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'2F736974652F63313433396361622D643130312D346564392D393237332D6663643032
66313930623739' 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'2F736974652F63313433396361622D643130312D346564392D393237332D6663643032
66313930623739' 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'2F736974652F63313433396361622D643130312D346564392D393237332D6663643032
66313930623739' 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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'39636363316433312D613331382D343061322D393230392D3535303861613239636666
39'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'39636363316433312D613331382D343061322D393230392D3535303861613239636666
39'

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'2F636F6E746
56E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C') 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'31363163306635382D373437632D343261342D623432622D3536626465346537336264
61'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F636F6E74656E742F',x'2F636F6E74656E742F7075626C69632F',x'2F636F6E746
56E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C')))  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'2F636F6E746
56E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C') 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'31363163306635382D373437632D343261342D623432622D3536626465346537336264
61'  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where
SAKAI_REALM.REALM_ID IN
(x'2F636F6E74656E742F',x'2F636F6E74656E742F7075626C69632F',x'2F636F6E746
56E742F7075626C69632F6D79776F726B73706163655F696E666F2E68746D6C')))  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'2F616E6E6F756E63656D656E742F6368616E6E656C2F7E31363163306635382D37343
7632D343261342D623432622D3536626465346537336264612F6D61696E',x'2F7369746
52F7E31363163306635382D373437632D343261342D623432622D3536626465346537336
26461',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'2F616E6E6F756E63656D656E742F6368616E6E656C2F7E31363163306635382D37343
7632D343261342D623432622D3536626465346537336264612F6D61696E',x'2F7369746
52F7E31363163306635382D373437632D343261342D623432622D3536626465346537336
26461',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_DES
C,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_S
ITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAK
AI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CR
EATEDBY,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'31363163306635382D373437632D343261342D623432622D3536626465346537336264
61' 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_DES
C,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_S
ITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAK
AI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CR
EATEDBY,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'65656531663830312D353231352D343438302D613430362D3739346134376138643830
39' 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'30633662343734322D376665382D346466392D393830662D3264633737616562623564
37', 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'63343831353739652D363934642D343664392D616535392D32313938623136
6236393932'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'63613234336135372D346632372D343034652D383165612D3566326365303632663866
35'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'34316431343663342D306537612D346462372D616265632D3932643036386166323665
31'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'34316431343663342D306537612D346462372D616265632D3932643036386166323665
31'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66656164346632382D663839322D346130352D626339662D6130396330613632373865
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66656164346632382D663839322D346130352D626339662D6130396330613632373865
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66656164346632382D663839322D346130352D626339662D6130396330613632373865
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'66656164346632382D663839322D346130352D626339662D6130396330613632373865
32'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'65393239633331312D643937642D343364662D393034652D6434343563636331343432
35'

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'36383764656264372D356334302D346230612D383437392D6261323333663234313161
32'

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'63663665363261302D303831352D346634322D613531322D3633623634623632336565
61' 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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'32616563303466622D343638372D343633622D383065632D3738633934313931323535
66'

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
55382D5136372E676966')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
55382D5136372E676966')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F')

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'2F636F6E74656
E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6
F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686
E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F7
36369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414
C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E7
42F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6
E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6
173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742
F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2
F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D617
3746572436C617373387765656B732F556E69745465737473

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'2F636F6E74656
E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6
F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686
E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F7
36369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414
C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E7
42F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6
E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6
173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742
F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2
F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D617
3746572436C617373387765656B732F556E69745465737473

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'32616563303466622D343638372D343633622D383065632D3738633934313931323535
66'

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
55382D513131352E676966')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
55382D513131352E676966')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F')

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'2F636F6E74656
E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6
F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686
E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F7
36369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414
C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E7
42F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6
E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6
173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742
F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2
F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D617
3746572436C617373387765656B732F556E69745465737473

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'2F636F6E74656
E742F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6
F6E2F',x'2F636F6E74656E742F67726F75702F736369656E63652D616E642D746563686
E6F6C6F67792D636F6D6D6F6E2F4D6174682F',x'2F636F6E74656E742F67726F75702F7
36369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414
C4C4465706172746D656E74616C4D4154483131306974656D732F',x'2F636F6E74656E7
42F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6
E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D6
173746572436C617373387765656B732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F',x'2F636F6E74656E742F67726F75702F73636
9656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2F4D6174682F414C4C4
465706172746D656E74616C4D4154483131306974656D732F4D6173746572436C6173733
87765656B732F556E697454657374732F556E6974384769662F',x'2F636F6E74656E742
F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F6E2
F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D617
3746572436C617373387765656B732F556E69745465737473

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'63663665363261302D303831352D346634322D613531322D3633623634623632336565
61' 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'63663665363261302D303831352D346634322D613531322D3633623634623632336565
61' 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'63663665363261302D303831352D346634322D613531322D3633623634623632336565
61' 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'63663665363261302D303831352D346634322D613531322D3633623634623632336565
61' 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'63663665363261302D303831352D346634322D613531322D3633623634623632336565
61' 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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
55382D5135312E676966')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
55382D5135312E676966')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F556E6974384769662F
')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F556E697454657374732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F414C4C4465706172746D656E74616C4D4154483131306974656D732F4D
6173746572436C617373387765656B732F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F4D6174682F')

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'2F67726F75702F736369656E63652D616E642D746563686E6F6C6F67792D636F6D6D6F
6E2F')

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,SESSI
ON_USER_AGENT,SESSION_START,SESSION_END,SESSION_ACTIVE from
SAKAI_SESSION where SESSION_ID =
x'32616563303466622D343638372D343633622D383065632D3738633934313931323535
66'

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
<mailto: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
<http://collab.sakaiproject.org/pipermail/sakai-dev/2009-July/002772.htm
l>   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
<mailto:sakai-dev at collab.sakaiproject.org> 
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
<http://collab.sakaiproject.org/mailman/listinfo/sakai-dev> 

TO UNSUBSCRIBE: send email to
sakai-dev-unsubscribe at collab.sakaiproject.org
<mailto: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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121105/52e61782/attachment.html 