[JBoss JIRA] (GTNPORTAL-2745) Bad performance of accessing /platform/users in groupManagement when many users in database
4:23 a.m.
Marek Posolda created GTNPORTAL-2745:
----------------------------------------
Summary: Bad performance of accessing /platform/users in groupManagement when
many users in database
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:39 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Michal Vanco updated GTNPORTAL-2745:
------------------------------------
Attachment: manyUsers-access-users-portlet.txt
Hi Marek, I'm attaching log from accessing users management portlet with 1 million
users.
It ends up with:
javax.jcr.InvalidItemStateException: This kind of operation is forbidden after a
session.logout()
and portlet is displayed then.
I'll verify the same with changed countPaginatedUsers param as you suggested.
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Attachments: manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:48 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Marek Posolda updated GTNPORTAL-2745:
-------------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request: https://github.com/gatein/gatein-portal/pull/289
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Attachments: manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:48 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Michal Vanco commented on GTNPORTAL-2745:
-----------------------------------------
countPaginatedUsers set to false helped a lot for accessing users management portlet, but
there is still bad performance of accessing platform/users
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Attachments: manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:56 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Marek Posolda updated GTNPORTAL-2745:
-------------------------------------
Attachment: exoadmin.war
I am attaching exoadmin.war with applied patch from Pull request 289. Adding this file
instead of original GATEIN_HOME/gatein/gatein.ear/exoadmin.war should help a lot with
performance for accessing /platform/users from group tree.
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:44 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Michal Vanco commented on GTNPORTAL-2745:
-----------------------------------------
I just verified attached patched exoadmin.war at JPP 6.0 ER03 with countPaginatedUsers set
to false and it brought big improvement, I'm able to access any group or users within
few seconds (instead of nothing or waiting few minutes as before). Thanks!!! Let's
find some more operations which are lacking.
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:30 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Marek Posolda updated GTNPORTAL-2745:
-------------------------------------
Status: Pull Request Sent (was: Pull Request Sent)
Git Pull Request: https://github.com/gatein/gatein-portal/pull/290 (was:
https://github.com/gatein/gatein-portal/pull/289)
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:42 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Boleslaw Dawidowicz updated GTNPORTAL-2745:
-------------------------------------------
Status: Resolved (was: Pull Request Sent)
Resolution: Done
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:44 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
Marek Posolda updated GTNPORTAL-2745:
-------------------------------------
Labels: EPP6.0-Test-Dev (was: )
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Labels: EPP6.0-Test-Dev
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:46 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
RH Bugzilla Integration updated GTNPORTAL-2745:
-----------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=882932
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Labels: EPP6.0-Test-Dev
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:48 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
RH Bugzilla Integration commented on GTNPORTAL-2745:
----------------------------------------------------
mposolda(a)redhat.com made a comment on [bug
882932|https://bugzilla.redhat.com/show_bug.cgi?id=882932]
Thanks Michal! I linked thus BZ with another jira GTNPORTAL-2745 which is also related to
manyUsers scenario.
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Labels: EPP6.0-Test-Dev
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:15 a.m.
[
https://issues.jboss.org/browse/GTNPORTAL-2745?page=com.atlassian.jira.pl...
]
RH Bugzilla Integration commented on GTNPORTAL-2745:
----------------------------------------------------
mposolda(a)redhat.com changed the Status of [bug
882932|https://bugzilla.redhat.com/show_bug.cgi?id=882932] from NEW to MODIFIED
Bad performance of accessing /platform/users in groupManagement when
many users in database
-------------------------------------------------------------------------------------------
Key: GTNPORTAL-2745
URL: https://issues.jboss.org/browse/GTNPORTAL-2745
Project: GateIn Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Identity integration, Performance
Affects Versions: 3.5.0.Beta02
Environment: - GateIn on JBoss AS7
- MySQL
- 100k users added to plidm database. All these users are in group
"/platform/users".
Reporter: Marek Posolda
Assignee: Marek Posolda
Labels: EPP6.0-Test-Dev
Fix For: 3.6.0.Final
Attachments: exoadmin.war, manyUsers-access-users-portlet.txt
Login as john, go to organizationManagement and in Group Management tree, I want show
group "/platform/users". It took few minutes to complete this request.
It's due to missing pagination, which forces all members of
"/platform/users" to be loaded at once.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4424
days inactive
4429
days old
11 comments
4 participants
participants (4)
-
Boleslaw Dawidowicz (JIRA) -
Marek Posolda (JIRA)
-
Michal Vanco (JIRA)
-
RH Bugzilla Integration (JIRA)