[JBoss JIRA] Created: (GTNPORTAL-1811) Bad performance of query for get all Pages when many users in database
by Marek Posolda (JIRA)
Bad performance of query for get all Pages when many users in database
----------------------------------------------------------------------
Key: GTNPORTAL-1811
URL: https://issues.jboss.org/browse/GTNPORTAL-1811
Project: GateIn Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Performance
Affects Versions: 3.1.0-GA
Reporter: Marek Posolda
Fix For: 3.2.0-GA
This performance bottleneck can be seen when there are many users in database (I tried with 2100 and 5000). It can be simulated by doing one of these things:
* login as "root" and go to page http://localhost:8080/portal/private/classic/administration/pageManagement
* login as "root" and go to page http://localhost:8080/portal/private/classic/portalnavigation -> click to "Edit navigation" of some portal -> Click "Add node"
Both of these are showing UIPageBrowser and calling method UIPageBrowser.feedDataWithQuery(Query<Page> query) which creates and execute Query for load all Page instances of all owners and owner types: Query<Page>(null, null, null, null, Page.class)
Execution of this query is internally running this JCR query: SELECT * FROM mop:page WHERE jcr:path LIKE '/production/mop:workspace/%/%/mop:rootpage/mop:children/mop:pages/mop:children/%'
And this is the cause of bottleneck. Running of this JCR query took me 55 seconds when running for first time and around 30 seconds for second and other times (I am using MySQL 5.1 as database). And I have 2100 users in portal, which means that node "/production/mop:workspace/mop:usersites" has 2100 subnodes.
With 5000 users, I have 126 seconds for first execution of query and around 45 seconds for next executions.
Good thing is that UIPageBrowser is shown only from admin portlets and so bottleneck should not affect normal portal users...
I am attaching part of server log in file pageQueryBottleneck-log.txt (Enabled DEBUG logging for "org.exoplatform.portal.pom.config.ExecutorDispatcher" and "exo.jcr.component.core.QueryImpl" )
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months
[JBoss JIRA] Created: (GTNPORTAL-1757) NPE when click link to request a new password for the username in mail after delete user
by Hang Nguyen (JIRA)
NPE when click link to request a new password for the username in mail after delete user
----------------------------------------------------------------------------------------
Key: GTNPORTAL-1757
URL: https://issues.jboss.org/browse/GTNPORTAL-1757
Project: GateIn Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Reporter: Hang Nguyen
* Add new user
* Click forgot user/pass
* Input user name/pass and click Send
* Login in portal
* Go to Organization Management
* Delete new user
* Comeback to mail
* Click link to request a new password for the username
=> Unknown error and show exception in cygwin
java.lang.NullPointerException
at org.exoplatform.portal.webui.login.UIResetPassword.setUser(UIResetPassword.java:77)
at org.exoplatform.portal.webui.portal.UIPortalComponentActionListener$RecoveryPasswordAndUs
ernameActionListener.execute(UIPortalComponentActionListener.java:440)
at org.exoplatform.webui.event.Event.broadcast(Event.java:89)
at org.exoplatform.webui.core.lifecycle.Lifecycle.processAction(Lifecycle.java:56)
at org.exoplatform.webui.core.UIComponent.processAction(UIComponent.java:133)
at org.exoplatform.portal.webui.workspace.UIPortalApplicationLifecycle.processAction(UIPorta
lApplicationLifecycle.java:73)
at org.exoplatform.portal.webui.workspace.UIPortalApplicationLifecycle.processAction(UIPorta
lApplicationLifecycle.java:37)
at org.exoplatform.webui.core.UIComponent.processAction(UIComponent.java:133)
at org.exoplatform.webui.core.UIApplication.processAction(UIApplication.java:120)
at org.exoplatform.portal.application.PortalRequestHandler.execute(PortalRequestHandler.java
:110)
at org.exoplatform.web.WebAppController.service(WebAppController.java:161)
at org.exoplatform.portal.application.PortalController.onService(PortalController.java:127)
at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHttpServlet.java:132)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months