You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Teijo Lallukka (JIRA)" <je...@portals.apache.org> on 2005/08/09 22:48:35 UTC
[jira] Created: (JS2-324) Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
------------------------------------------------------------------------------------------------------
Key: JS2-324
URL: http://issues.apache.org/jira/browse/JS2-324
Project: Jetspeed 2
Type: Bug
Versions: 2.0-M2
Environment: Linux
Reporter: Teijo Lallukka
Priority: Minor
I bulk loaded 500 users to jetspeed and noticed that management portlets(add user, add user to group and so on) don't work any more.
I found out that queries to db are slow and creation of one index is good workaround. I haven't tested latest version that will it be fixed there.
Workaround: create index SECURITY_CREDENTIAL_PRINID_IDX on SECURITY_CREDENTIAL (PRINCIPAL_ID)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Assigned: (JS2-324) Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS2-324?page=all ]
Ate Douma reassigned JS2-324:
-----------------------------
Assign To: Ate Douma
> Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
> ------------------------------------------------------------------------------------------------------
>
> Key: JS2-324
> URL: http://issues.apache.org/jira/browse/JS2-324
> Project: Jetspeed 2
> Type: Bug
> Versions: 2.0-M2
> Environment: Linux
> Reporter: Teijo Lallukka
> Assignee: Ate Douma
> Priority: Minor
>
> I bulk loaded 500 users to jetspeed and noticed that management portlets(add user, add user to group and so on) don't work any more.
> I found out that queries to db are slow and creation of one index is good workaround. I haven't tested latest version that will it be fixed there.
> Workaround: create index SECURITY_CREDENTIAL_PRINID_IDX on SECURITY_CREDENTIAL (PRINCIPAL_ID)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Updated: (JS2-324) Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS2-324?page=all ]
Ate Douma updated JS2-324:
--------------------------
Version: 2.0-POST
(was: 2.0-M2)
Forgot to set the Fix Version to 2.0-FINAL
> Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
> ------------------------------------------------------------------------------------------------------
>
> Key: JS2-324
> URL: http://issues.apache.org/jira/browse/JS2-324
> Project: Jetspeed 2
> Type: Bug
> Versions: 2.0-POST
> Environment: Linux
> Reporter: Teijo Lallukka
> Priority: Minor
>
> I bulk loaded 500 users to jetspeed and noticed that management portlets(add user, add user to group and so on) don't work any more.
> I found out that queries to db are slow and creation of one index is good workaround. I haven't tested latest version that will it be fixed there.
> Workaround: create index SECURITY_CREDENTIAL_PRINID_IDX on SECURITY_CREDENTIAL (PRINCIPAL_ID)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Assigned: (JS2-324) Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS2-324?page=all ]
Ate Douma reassigned JS2-324:
-----------------------------
Assign To: (was: Ate Douma)
I'm unassigning my last two 2.0-FINAL issues as I don't have time left to complete these.
If someone else wants to pick these up, feel free to sign up for.
> Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
> ------------------------------------------------------------------------------------------------------
>
> Key: JS2-324
> URL: http://issues.apache.org/jira/browse/JS2-324
> Project: Jetspeed 2
> Type: Bug
> Versions: 2.0-POST
> Environment: Linux
> Reporter: Teijo Lallukka
> Priority: Minor
>
> I bulk loaded 500 users to jetspeed and noticed that management portlets(add user, add user to group and so on) don't work any more.
> I found out that queries to db are slow and creation of one index is good workaround. I haven't tested latest version that will it be fixed there.
> Workaround: create index SECURITY_CREDENTIAL_PRINID_IDX on SECURITY_CREDENTIAL (PRINCIPAL_ID)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org