[Building Sakai] question about mediadata0
David Horwitz
david.horwitz at uct.ac.za
Mon Mar 25 02:24:13 PDT 2013
This looks like a query from Samigo (Tests and Quizzes). You may need to check the indexes on this table if its giving you trouble...
D
On Mon, 2013-03-25 at 16:45 +0800, Yuechuan Dai wrote:
Hi,
Our Mysql server received huge Query from Sakai app like:
select mediadata0_.MEDIAID as MEDIAID190_, mediadata0_.ITEMGRADINGID as
ITEMGRAD2_190_, mediadata0_.
And if this happen the MYSQL server will going to die.
Anyone know what is this QUERY?
Thanks
Yuechuan
-----邮件原件-----
发件人: sakai-dev-bounces at collab.sakaiproject.org<mailto:sakai-dev-bounces at collab.sakaiproject.org>
[mailto:sakai-dev-bounces at collab.sakaiproject.org] 代表
sakai-dev-request at collab.sakaiproject.org<mailto:sakai-dev-request at collab.sakaiproject.org>
发送时间: 2013年3月25日 3:00
收件人: sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
主题: sakai-dev Digest, Vol 49, Issue 24
Send sakai-dev mailing list submissions to
sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
To subscribe or unsubscribe via the World Wide Web, visit
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
or, via email, send a message with subject or body 'help' to
sakai-dev-request at collab.sakaiproject.org<mailto:sakai-dev-request at collab.sakaiproject.org>
You can reach the person managing the list at
sakai-dev-owner at collab.sakaiproject.org<mailto:sakai-dev-owner at collab.sakaiproject.org>
When replying, please edit your Subject line so it is more specific than
"Re: Contents of sakai-dev digest..."
Today's Topics:
1. Re: Oracle change LONG to CLOB (Neal Caidin)
2. Re: webservice for gradebook and roster? (Steve Swinsburg)
3. Re: mvn clean Install issue on ubuntu OS (Steve Swinsburg)
4. Re: Oracle change LONG to CLOB (Adams, David)
5. Re: SiteStats slow updates (Steve Swinsburg)
6. Re: webservice for gradebook and roster? (Aaron Zeckoski)
7. Re: "OutOfMemory: Permgen......" error deploying sakai 2.9.1
(Ese Egerega)
8. Re: webservice for gradebook and roster? (Steve Swinsburg)
9. Re: "OutOfMemory: Permgen......" error deploying sakai 2.9.1
(Steve Swinsburg)
10. Re: webservice for gradebook and roster? (Aaron Zeckoski)
----------------------------------------------------------------------
Message: 1
Date: Sat, 23 Mar 2013 16:34:56 -0400
From: Neal Caidin <nealcaidin at sakaifoundation.org<mailto:nealcaidin at sakaifoundation.org>>
Subject: Re: [Building Sakai] Oracle change LONG to CLOB
To: "Adams, David" <da1 at vt.edu<mailto:da1 at vt.edu>>
Cc: Sakai-Dev <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID: <BBB001B0-9298-4229-BA31-5214743A30F5 at sakaifoundation.org<mailto:BBB001B0-9298-4229-BA31-5214743A30F5 at sakaifoundation.org>>
Content-Type: text/plain; charset=us-ascii
Does this merit a Jira ticket, converting LONGs to CLOBs and Long RAWS to
BLOBs?
Thanks,
Neal
On Mar 22, 2013, at 9:16 PM, "Adams, David" <da1 at vt.edu<mailto:da1 at vt.edu>> wrote:
> I can verify that this has not been fixed as of 2.9.1, at least for all of
the should-be-CLOB-or-BLOB fields. However, to answer the original question,
it's completely safe and appropriate to just convert all the LONGs to CLOBs
and LONG RAWs to BLOBs.
>
> -dave
> ________________________________________
> From: sakai-dev-bounces at collab.sakaiproject.org<mailto:sakai-dev-bounces at collab.sakaiproject.org>
> [sakai-dev-bounces at collab.sakaiproject.org<mailto:sakai-dev-bounces at collab.sakaiproject.org>] On Behalf Of Matthew Jones
> [matthew at longsight.com<mailto:matthew at longsight.com>]
> Sent: Friday, March 22, 2013 5:27 PM
> To: Joshua Swink
> Cc: Sakai-Dev
> Subject: Re: [Building Sakai] Oracle change LONG to CLOB
>
> Yea, it seems like this should have been fixed sometime in 2.5 or 2.6.
>
> But you can run that and afterward you'd have to run a script to
> detect and repair indexes in an invalid state. Otherwise there's no
> problems. All LONGs really should be CLOBS
>
> Fix for invalid state indexes
> https://jira.sakaiproject.org/browse/SAK-16553
>
> Original comments for 2.5/2.6 to change LONG's to CLOBS
> https://jira.sakaiproject.org/browse/SAK-7977
>
>
> On Fri, Mar 22, 2013 at 5:06 PM, Joshua Swink
<joshua.swink at gmail.com<mailto:joshua.swink at gmail.com><mailto:joshua.swink at gmail.com>> wrote:
> Hi, wondering if I can just change ANNOUNCEMENT_MESSAGE's XML data type
from LONG to CLOB.
>
> While running sakai_2_8_0-2_8_1_oracle_conversion.sql, this is executed:
>
> update ANNOUNCEMENT_MESSAGE set MESSAGE_ORDER='1', XML=replace(XML, '
> subject=', ' message_order="1" subject=') where MESSAGE_ORDER is null;
>
> The db responds: ORA-00932: inconsistent datatypes: expected NUMBER
> got LONG
>
> Not sure why it said expected NUMBER, when that is a character field...
but anyway, it seems like a good solution is to convert XML to a CLOB as
follows:
>
> alter table ANNOUNCEMENT_MESSAGE modify (XML CLOB);
>
> Josh
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org><mailto:sakai-dev at collab.sakaiproject
> .org> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org><mailto:sakai-dev-unsubscribe at c
ollab.sakaiproject.org> with a subject of "unsubscribe"
>
> _______________________________________________
> 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
>
> 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"
------------------------------
Message: 2
Date: Sun, 24 Mar 2013 07:35:12 +1100
From: Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
Subject: Re: [Building Sakai] webservice for gradebook and roster?
To: Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>>
Cc: "sakai-user at collab.sakaiproject.org<mailto:sakai-user at collab.sakaiproject.org>"
<sakai-user at collab.sakaiproject.org<mailto:sakai-user at collab.sakaiproject.org>>,
"sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>"
<sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID: <2BCEA620-B511-48E7-AFAA-F182232646F5 at gmail.com<mailto:2BCEA620-B511-48E7-AFAA-F182232646F5 at gmail.com>>
Content-Type: text/plain; charset=us-ascii
Hi Gregory,
A REST endpoint will be added for both of these within the new few weeks (if
it doesn't already exist somewhere and if it does, it will be reviewed).
If anyone in the community has done the work, please let me know and we can
review and incorporate.
regards,
Steve
On 23/03/2013, at 12:13 AM, Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>> wrote:
> Is there a REST webservice that can do the equivalent of an export from
the roster & gradebook/allGrades pages?
>
> I want to do some overall class statistics and tracking for a class, and
currently the only way I see to get this is either manually from the GUI
which is not practical for ongoing usage, or from SQL queries to the
database.
>
> Maybe the new Keitai project will provide such things, or do they already
exist?
>
> I see some description of a "SearchForUsers" service, but I don't see it
installed or described now to use it.
>
> -------------------------------------------
> _______________________________________________
> 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
>
> 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"
------------------------------
Message: 3
Date: Sun, 24 Mar 2013 07:47:25 +1100
From: Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
Subject: Re: [Building Sakai] mvn clean Install issue on ubuntu OS
To: ashraf <mailme_habibi at rediffmail.com<mailto:mailme_habibi at rediffmail.com>>
Cc: "sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>"
<sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID: <6B0375EC-F107-4F90-AC02-FBA72E2E2EDA at gmail.com<mailto:6B0375EC-F107-4F90-AC02-FBA72E2E2EDA at gmail.com>>
Content-Type: text/plain; charset="us-ascii"
What version Maven are you using?
Send all output from:
mvn -v
cheers,
Steve
On 23/03/2013, at 2:38 AM, ashraf <mailme_habibi at rediffmail.com<mailto:mailme_habibi at rediffmail.com>> wrote:
> Hi,
>
> I am phasing the issue when I am doing mvn clean install from master, on
ubuntu os, I tried on 10.04 and 12.04.
> But I am facing same issue on both place, For kind of information , i
successfully did installation on windows 8 and it working fine.
> Below is the error which I am getting ..
>
> ashraf at ubuntu:/opt/sakai/sakai2.9.1/master$ mvn clean install [INFO]
> Scanning for projects...
> Downloading:
> http://repo1.maven.org/maven2/org/sonatype/oss/oss-parent/7/oss-parent
> -7.pom
> Downloading:
> http://repo.maven.apache.org/maven2/org/sonatype/oss/oss-parent/7/oss-
> parent-7.pom [ERROR] The build could not read 1 project -> [Help 1]
> [ERROR]
> [ERROR] The project org.sakaiproject:master:2.9.1
(/opt/sakai/sakai2.9.1/master/pom.xml) has 1 error
> [ERROR] Non-resolvable parent POM: Could not transfer artifact
org.sonatype.oss:oss-parent:pom:7 from/to default
(http://repo1.maven.org/maven2): repo1.maven.org: Name or service not known
and 'parent.relativePath' points at wrong local POM @ line 3, column 13:
Unknown host repo1.maven.org: Name or service not known -> [Help 2]
> [ERROR]
> [ERROR] To see the full stack trace of the errors, re-run Maven with the
-e switch.
> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
> [ERROR]
> [ERROR] For more information about the errors and possible solutions,
please read the following articles:
> [ERROR] [Help 1]
> http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingExcept
> ion [ERROR] [Help 2]
> http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelExce
> ption ashraf at ubuntu:/opt/sakai/sakai2.9.1/master$
>
> Please help me.
> Any suggestion or help is appreciable.
>
> Thanks
> Ashraf
>
>
> Get your own FREE website and domain with business email solutions,
> click here _______________________________________________
> 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
>
> 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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130324/79ae
d972/attachment-0001.html
------------------------------
Message: 4
Date: Sat, 23 Mar 2013 16:53:53 -0400
From: "Adams, David" <da1 at vt.edu<mailto:da1 at vt.edu>>
Subject: Re: [Building Sakai] Oracle change LONG to CLOB
To: Neal Caidin <nealcaidin at sakaifoundation.org<mailto:nealcaidin at sakaifoundation.org>>
Cc: Sakai-Dev <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID:
<F0952E2BC740394C8A5A0DB303AB885C3C7A2C4234 at rivendell.cc.w2k.vt.edu<mailto:F0952E2BC740394C8A5A0DB303AB885C3C7A2C4234 at rivendell.cc.w2k.vt.edu>>
Content-Type: text/plain; charset="us-ascii"
There is a ticket: https://jira.sakaiproject.org/browse/SAK-7977
It's a Hibernate auto ddl issue.
________________________________________
From: Neal Caidin [nealcaidin at sakaifoundation.org<mailto:nealcaidin at sakaifoundation.org>]
Sent: Saturday, March 23, 2013 4:34 PM
To: Adams, David
Cc: Matthew Jones; Joshua Swink; Sakai-Dev
Subject: Re: [Building Sakai] Oracle change LONG to CLOB
Does this merit a Jira ticket, converting LONGs to CLOBs and Long RAWS to
BLOBs?
Thanks,
Neal
On Mar 22, 2013, at 9:16 PM, "Adams, David" <da1 at vt.edu<mailto:da1 at vt.edu>> wrote:
> I can verify that this has not been fixed as of 2.9.1, at least for all of
the should-be-CLOB-or-BLOB fields. However, to answer the original question,
it's completely safe and appropriate to just convert all the LONGs to CLOBs
and LONG RAWs to BLOBs.
>
> -dave
> ________________________________________
> From: sakai-dev-bounces at collab.sakaiproject.org<mailto:sakai-dev-bounces at collab.sakaiproject.org>
> [sakai-dev-bounces at collab.sakaiproject.org<mailto:sakai-dev-bounces at collab.sakaiproject.org>] On Behalf Of Matthew Jones
> [matthew at longsight.com<mailto:matthew at longsight.com>]
> Sent: Friday, March 22, 2013 5:27 PM
> To: Joshua Swink
> Cc: Sakai-Dev
> Subject: Re: [Building Sakai] Oracle change LONG to CLOB
>
> Yea, it seems like this should have been fixed sometime in 2.5 or 2.6.
>
> But you can run that and afterward you'd have to run a script to
> detect and repair indexes in an invalid state. Otherwise there's no
> problems. All LONGs really should be CLOBS
>
> Fix for invalid state indexes
> https://jira.sakaiproject.org/browse/SAK-16553
>
> Original comments for 2.5/2.6 to change LONG's to CLOBS
> https://jira.sakaiproject.org/browse/SAK-7977
>
>
> On Fri, Mar 22, 2013 at 5:06 PM, Joshua Swink
<joshua.swink at gmail.com<mailto:joshua.swink at gmail.com><mailto:joshua.swink at gmail.com>> wrote:
> Hi, wondering if I can just change ANNOUNCEMENT_MESSAGE's XML data type
from LONG to CLOB.
>
> While running sakai_2_8_0-2_8_1_oracle_conversion.sql, this is executed:
>
> update ANNOUNCEMENT_MESSAGE set MESSAGE_ORDER='1', XML=replace(XML, '
> subject=', ' message_order="1" subject=') where MESSAGE_ORDER is null;
>
> The db responds: ORA-00932: inconsistent datatypes: expected NUMBER
> got LONG
>
> Not sure why it said expected NUMBER, when that is a character field...
but anyway, it seems like a good solution is to convert XML to a CLOB as
follows:
>
> alter table ANNOUNCEMENT_MESSAGE modify (XML CLOB);
>
> Josh
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org><mailto:sakai-dev at collab.sakaiproject
> .org> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org><mailto:sakai-dev-unsubscribe at c
ollab.sakaiproject.org> with a subject of "unsubscribe"
>
> _______________________________________________
> 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
>
> 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"
------------------------------
Message: 5
Date: Sun, 24 Mar 2013 07:59:20 +1100
From: Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
Subject: Re: [Building Sakai] SiteStats slow updates
To: Matthew Buckett <matthew.buckett at it.ox.ac.uk<mailto:matthew.buckett at it.ox.ac.uk>>
Cc: Sakai Developers <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID: <6CE4D74E-C46E-4999-9109-1FC16AEF989E at gmail.com<mailto:6CE4D74E-C46E-4999-9109-1FC16AEF989E at gmail.com>>
Content-Type: text/plain; charset=us-ascii
Thats a lot of indexes. And the same column is being indexes multiple times.
Is there some other FK relationship there?
Too many indexes slow down updates and inserts. What are the queries on that
table? Are all of those indexes used?
On 23/03/2013, at 1:51 AM, Matthew Buckett <matthew.buckett at it.ox.ac.uk<mailto:matthew.buckett at it.ox.ac.uk>>
wrote:
> We're seeing some slow queries against our MySQL database, this is
> from the slow query log. The only slow queries are from site stats
> doing updates on the SST_EVENTS table.
>
> # Time: 130320 9:47:49
> # Query_time: 6.013975 Lock_time: 0.000065 Rows_sent: 0
> Rows_examined: 1 SET timestamp=1363772869; update SST_EVENTS set
> USER_ID='?', SITE_ID='info', EVENT_ID='content.read',
> EVENT_DATE='2013-03-20', EVENT_COUNT=10605 where ID=6857853;
>
> The table is a few columns and several indexes and according to the
> slow query log it didn't do a scan and used the index as we have
> "Rows_examined: 1", the lock time is very low so I'm left wondering
> why this query took so long. We do have lots of updates happening
> against this table and in particular this row, but the slow queries
> pretty much always for this row (>90%).
>
>
> CREATE TABLE SST_EVENTS (
> ID BIGINT NOT NULL,
> USER_ID VARCHAR(99) NOT NULL,
> SITE_ID VARCHAR(99) NOT NULL,
> EVENT_ID VARCHAR(32) NOT NULL,
> EVENT_DATE DATE NOT NULL,
> EVENT_COUNT BIGINT NOT NULL,
> PRIMARY KEY (ID)
> ) ENGINE=InnoDB;
>
> CREATE INDEX SST_EVENTS_EVENT_ID_IX ON SST_EVENTS (EVENT_ID ASC);
>
> CREATE INDEX SST_EVENTS_DATE_IX ON SST_EVENTS (EVENT_DATE ASC);
>
> CREATE INDEX SST_EVENTS_SITEEVENTUSER_ID_IX ON SST_EVENTS (EVENT_ID
> ASC);
>
> CREATE INDEX SST_EVENTS_SITEEVENTUSER_ID_IX ON SST_EVENTS (SITE_ID
> ASC);
>
> CREATE INDEX SST_EVENTS_SITEEVENTUSER_ID_IX ON SST_EVENTS (USER_ID
> ASC);
>
> CREATE INDEX SST_EVENTS_USER_ID_IX ON SST_EVENTS (USER_ID ASC);
>
> CREATE INDEX SST_EVENTS_SITE_ID_IX ON SST_EVENTS (SITE_ID ASC);
>
> --
> Matthew Buckett, VLE Developer, IT Services, University of Oxford
> _______________________________________________
> 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
>
> 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"
------------------------------
Message: 6
Date: Sat, 23 Mar 2013 17:04:03 -0400
From: Aaron Zeckoski <azeckoski at unicon.net<mailto:azeckoski at unicon.net>>
Subject: Re: [Building Sakai] webservice for gradebook and roster?
To: Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
Cc: Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>>,
"sakai-user at collab.sakaiproject.org<mailto:sakai-user at collab.sakaiproject.org>"
<sakai-user at collab.sakaiproject.org<mailto:sakai-user at collab.sakaiproject.org>>,
"sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>"
<sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID:
<CAMTQKLktMPXm1pnLPAaNCz+vRY=Zf7n_-tbZYtoRcSiJvGnzpA at mail.gmail.com<mailto:CAMTQKLktMPXm1pnLPAaNCz+vRY=Zf7n_-tbZYtoRcSiJvGnzpA at mail.gmail.com>>
Content-Type: text/plain; charset=UTF-8
Already noted the Unicon one in the JIRA (just in case it wasn't noticed
yet) -AZ
On Sat, Mar 23, 2013 at 4:35 PM, Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
wrote:
> Hi Gregory,
>
> A REST endpoint will be added for both of these within the new few weeks
(if it doesn't already exist somewhere and if it does, it will be reviewed).
>
> If anyone in the community has done the work, please let me know and we
can review and incorporate.
>
> regards,
> Steve
>
>
> On 23/03/2013, at 12:13 AM, Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>> wrote:
>
>> Is there a REST webservice that can do the equivalent of an export from
the roster & gradebook/allGrades pages?
>>
>> I want to do some overall class statistics and tracking for a class, and
currently the only way I see to get this is either manually from the GUI
which is not practical for ongoing usage, or from SQL queries to the
database.
>>
>> Maybe the new Keitai project will provide such things, or do they already
exist?
>>
>> I see some description of a "SearchForUsers" service, but I don't see it
installed or described now to use it.
>>
>> -------------------------------------------
>> _______________________________________________
>> 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
>>
>> 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"
>
> _______________________________________________
> 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
>
> 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"
--
Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
------------------------------
Message: 7
Date: Sun, 24 Mar 2013 00:37:09 +0100
From: Ese Egerega <ese at cis.com.ng<mailto:ese at cis.com.ng>>
Subject: Re: [Building Sakai] "OutOfMemory: Permgen......" error
deploying sakai 2.9.1
To: Matthew Jones <matthew at longsight.com<mailto:matthew at longsight.com>>
Cc: dev sakai <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID:
<CAHtohn7q0K4aTQRimuHj4pws+PrDPaS2YaUvvB42V5Uffo5+=Q at mail.gmail.com<mailto:CAHtohn7q0K4aTQRimuHj4pws+PrDPaS2YaUvvB42V5Uffo5+=Q at mail.gmail.com>>
Content-Type: text/plain; charset="iso-8859-1"
Dear All,
Thanks so much for your help. My server is now up and running (see image
below)
On Sat, Mar 23, 2013 at 2:03 PM, Matthew Jones <matthew at longsight.com<mailto:matthew at longsight.com>>wrote:
> These are the options that should be enough to *start* Sakai on any
> system. You can either put them in a start script for Sakai or in a file
> called setenv.sh in the bin directory and they will be used as Aaron
> mentioned, they look similar to yours. I start it on one with only 2.5G of
> RAM with those options and use it fine for dev purposes.
>
> https://source.sakaiproject.org/svn/reference/trunk/demo/start-sakai.sh
>
> For a production system you would need a little more -Xmx and possibly
> -XX:MaxPermSize. (Though that should be more static)
>
>
> On Sat, Mar 23, 2013 at 2:35 AM, Ese Egerega <ese at cis.com.ng<mailto:ese at cis.com.ng>> wrote:
>
>> Can anyone be of help?
>>
>> I successfully deployed sakai 2.9.1 on a system with 8gig RAM. I am
>> however getting an "OutOfMemory: Permgen......" error when I try to
deploy
>> it on a server with 4gig RAM.
>>
>> Going by the documentation sakai should run on a system with 4gig RAM.
>> Correct?
>>
>> My environment variables are as follows:
>>
>> export JAVA_HOME=/usr/lib/jvm/java-7-oracle
>> export PATH=$PATH:$JAVA_HOME/bin
>> export MAVEN_HOME=/usr
>> export PATH=$PATH:$MAVEN_HOME/bin
>> export MAVEN_OPTS="-Xms128m -Xmx512m -XX:PermSize=128m
>> -XX:MaxPermSize=256m"
>> export CATALINA_HOME=/opt/tomcat
>> export PATH=$PATH:$CATALINA_HOME/bin
>> export SAKAI_HOME=/opt/tomcat/sakai
>> export JAVA_OPTS="-server -Xms512m -Xmx1024m -XX:PermSize=128m
>> -XX:MaxPermSize=512m -XX:NewSize=192m -XX:MaxNewSize=512m
>> -Djava.awtECHO.headless=true
>> -Dhttp.agent=Sakai -Dsakai.home=/opt/tomcat/sakai
>> -Dorg.apache.jasperRT.compiler.Parser.STRICT_QUOTE_ESCAPING=false
>> -Dsun.lang.ClassLoader.allowArraySyntax=true
>> -Dcom.sun.management.jmxremote"
>>
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>> 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"
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130324/8bc9
11a2/attachment-0001.html
------------------------------
Message: 8
Date: Sun, 24 Mar 2013 14:15:19 +1100
From: Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
Subject: Re: [Building Sakai] webservice for gradebook and roster?
To: Aaron Zeckoski <azeckoski at unicon.net<mailto:azeckoski at unicon.net>>
Cc: Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>>,
"sakai-user at collab.sakaiproject.org<mailto:sakai-user at collab.sakaiproject.org>"
<sakai-user at collab.sakaiproject.org<mailto:sakai-user at collab.sakaiproject.org>>,
"sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>"
<sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID: <36175486-0914-43F3-AD1F-29ECA6733AB3 at gmail.com<mailto:36175486-0914-43F3-AD1F-29ECA6733AB3 at gmail.com>>
Content-Type: text/plain; charset=us-ascii
This one? https://jira.sakaiproject.org/browse/SAK-23359
cheers.
On 24/03/2013, at 8:04 AM, Aaron Zeckoski <azeckoski at unicon.net<mailto:azeckoski at unicon.net>> wrote:
> Already noted the Unicon one in the JIRA (just in case it wasn't noticed
yet)
> -AZ
>
> On Sat, Mar 23, 2013 at 4:35 PM, Steve Swinsburg
> <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>> wrote:
>> Hi Gregory,
>>
>> A REST endpoint will be added for both of these within the new few weeks
(if it doesn't already exist somewhere and if it does, it will be reviewed).
>>
>> If anyone in the community has done the work, please let me know and we
can review and incorporate.
>>
>> regards,
>> Steve
>>
>>
>> On 23/03/2013, at 12:13 AM, Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>> wrote:
>>
>>> Is there a REST webservice that can do the equivalent of an export from
the roster & gradebook/allGrades pages?
>>>
>>> I want to do some overall class statistics and tracking for a class, and
currently the only way I see to get this is either manually from the GUI
which is not practical for ongoing usage, or from SQL queries to the
database.
>>>
>>> Maybe the new Keitai project will provide such things, or do they
already exist?
>>>
>>> I see some description of a "SearchForUsers" service, but I don't see it
installed or described now to use it.
>>>
>>> -------------------------------------------
>>> _______________________________________________
>>> 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
>>>
>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject<mailto:sakai-dev-unsubscribe at collab.sakaiproject>.
org with a subject of "unsubscribe"
>>
>> _______________________________________________
>> 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
>>
>> 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"
>
>
>
> --
> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
------------------------------
Message: 9
Date: Sun, 24 Mar 2013 14:20:41 +1100
From: Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
Subject: Re: [Building Sakai] "OutOfMemory: Permgen......" error
deploying sakai 2.9.1
To: Ese Egerega <ese at cis.com.ng<mailto:ese at cis.com.ng>>
Cc: dev sakai <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID: <7D14B4F7-3B1F-4D57-93A9-65B42B02A496 at gmail.com<mailto:7D14B4F7-3B1F-4D57-93A9-65B42B02A496 at gmail.com>>
Content-Type: text/plain; charset="iso-8859-1"
I have found that for 2.9+ builds I needed to increase my heap in
MAVEN_OPTS. I generally double what you have set.
cheers,
Steve
On 24/03/2013, at 10:37 AM, Ese Egerega <ese at cis.com.ng<mailto:ese at cis.com.ng>> wrote:
> Dear All,
>
> Thanks so much for your help. My server is now up and running (see image
below)
>
>
>
> On Sat, Mar 23, 2013 at 2:03 PM, Matthew Jones <matthew at longsight.com<mailto:matthew at longsight.com>>
wrote:
> These are the options that should be enough to *start* Sakai on any
system. You can either put them in a start script for Sakai or in a file
called setenv.sh in the bin directory and they will be used as Aaron
mentioned, they look similar to yours. I start it on one with only 2.5G of
RAM with those options and use it fine for dev purposes.
>
> https://source.sakaiproject.org/svn/reference/trunk/demo/start-sakai.sh
>
> For a production system you would need a little more -Xmx and possibly
-XX:MaxPermSize. (Though that should be more static)
>
>
> On Sat, Mar 23, 2013 at 2:35 AM, Ese Egerega <ese at cis.com.ng<mailto:ese at cis.com.ng>> wrote:
> Can anyone be of help?
>
> I successfully deployed sakai 2.9.1 on a system with 8gig RAM. I am
however getting an "OutOfMemory: Permgen......" error when I try to deploy
it on a server with 4gig RAM.
>
> Going by the documentation sakai should run on a system with 4gig RAM.
Correct?
>
> My environment variables are as follows:
>
> export JAVA_HOME=/usr/lib/jvm/java-7-oracle
> export PATH=$PATH:$JAVA_HOME/bin
> export MAVEN_HOME=/usr
> export PATH=$PATH:$MAVEN_HOME/bin
> export MAVEN_OPTS="-Xms128m -Xmx512m -XX:PermSize=128m
-XX:MaxPermSize=256m"
> export CATALINA_HOME=/opt/tomcat
> export PATH=$PATH:$CATALINA_HOME/bin
> export SAKAI_HOME=/opt/tomcat/sakai
> export JAVA_OPTS="-server -Xms512m -Xmx1024m -XX:PermSize=128m
-XX:MaxPermSize=512m -XX:NewSize=192m -XX:MaxNewSize=512m
-Djava.awtECHO.headless=true
> -Dhttp.agent=Sakai -Dsakai.home=/opt/tomcat/sakai
> -Dorg.apache.jasperRT.compiler.Parser.STRICT_QUOTE_ESCAPING=false
> -Dsun.lang.ClassLoader.allowArraySyntax=true
-Dcom.sun.management.jmxremote"
>
>
>
>
>
> _______________________________________________
> 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
>
> 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"
>
>
> _______________________________________________
> 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
>
> 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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130324/7adf
766e/attachment-0001.html
------------------------------
Message: 10
Date: Sun, 24 Mar 2013 07:30:42 -0400
From: Aaron Zeckoski <azeckoski at unicon.net<mailto:azeckoski at unicon.net>>
Subject: Re: [Building Sakai] webservice for gradebook and roster?
To: Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>>
Cc: Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>>,
"sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>"
<sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Message-ID:
<CAMTQKLkEQHqxk6YO=62dV=QGtppo=rU09RuyaCNB7aaLuBiSOA at mail.gmail.com<mailto:CAMTQKLkEQHqxk6YO=62dV=QGtppo=rU09RuyaCNB7aaLuBiSOA at mail.gmail.com>>
Content-Type: text/plain; charset=UTF-8
That's the one.
-AZ
On Sat, Mar 23, 2013 at 11:15 PM, Steve Swinsburg
<steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>> wrote:
> This one? https://jira.sakaiproject.org/browse/SAK-23359
>
> cheers.
>
>
> On 24/03/2013, at 8:04 AM, Aaron Zeckoski <azeckoski at unicon.net<mailto:azeckoski at unicon.net>> wrote:
>
>> Already noted the Unicon one in the JIRA (just in case it wasn't noticed
yet)
>> -AZ
>>
>> On Sat, Mar 23, 2013 at 4:35 PM, Steve Swinsburg
>> <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>> wrote:
>>> Hi Gregory,
>>>
>>> A REST endpoint will be added for both of these within the new few weeks
(if it doesn't already exist somewhere and if it does, it will be reviewed).
>>>
>>> If anyone in the community has done the work, please let me know and we
can review and incorporate.
>>>
>>> regards,
>>> Steve
>>>
>>>
>>> On 23/03/2013, at 12:13 AM, Gregory Guthrie <guthrie at mum.edu<mailto:guthrie at mum.edu>> wrote:
>>>
>>>> Is there a REST webservice that can do the equivalent of an export from
the roster & gradebook/allGrades pages?
>>>>
>>>> I want to do some overall class statistics and tracking for a class,
and currently the only way I see to get this is either manually from the GUI
which is not practical for ongoing usage, or from SQL queries to the
database.
>>>>
>>>> Maybe the new Keitai project will provide such things, or do they
already exist?
>>>>
>>>> I see some description of a "SearchForUsers" service, but I don't see
it installed or described now to use it.
>>>>
>>>> -------------------------------------------
>>>> _______________________________________________
>>>> 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
>>>>
>>>> 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"
>>>
>>> _______________________________________________
>>> 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
>>>
>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject<mailto:sakai-dev-unsubscribe at collab.sakaiproject>.
org with a subject of "unsubscribe"
>>
>>
>>
>> --
>> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
>
________________________________
UNIVERSITY OF CAPE TOWN
This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130325/b00cd37a/attachment.html
More information about the sakai-dev
mailing list