Skip to Content.
Sympa Menu

grouper-users - [grouper-users] UI hang during login

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] UI hang during login

Chronological Thread 
  • From: "Black, Carey M." <>
  • To: Gouper Users List <>
  • Subject: [grouper-users] UI hang during login
  • Date: Wed, 10 Jan 2018 15:44:38 +0000
  • Accept-language: en-US
  • Authentication-results: spf=pass (sender IP is;; dkim=none (message not signed) header.d=none;; dmarc=pass action=none;
  • Ironport-phdr: 9a23:srI6PRS5/17wtbi9wy0aBINVUNpsv+yvbD5Q0YIujvd0So/mwa6zYRCN2/xhgRfzUJnB7Loc0qyK6/mmATRIyK3CmUhKSIZLWR4BhJdetC0bK+nBN3fGKuX3ZTcxBsVIWQwt1Xi6NU9IBJS2PAWK8TW94jEIBxrwKxd+KPjrFY7OlcS30P2594HObwlSizexfa5+IA+qoQnNq8IbnZZsJqEtxxXTv3BGYf5WxWRmJVKSmxbz+MK994N9/ipTpvws6ddOXb31cKokQ7NYCi8mM30u683wqRbDVwqP6WACXWgQjxFFHhLK7BD+Xpf2ryv6qu9w0zSUMMHqUbw5Xymp4rx1QxH0ligIKz858HnWisNuiqJbvAmhrAF7z4LNfY2ZKOZycqbbcNgHR2ROQ9xRWjRBDI2icoUPE+QPM+VZr4bhqFUBogCzBRW1BO7r1jNEmmP60bM83u88EQ/GxgsgH9cWvXjasdj1ML0dXvy2zKXQ0D7OcelZ2S3j54nIbxsvpuuAUbxtesfW0kYvExnKgUmTqYD/Ij+ZyOoAvnOc7+p7SOKjkXAopBxsojW2wMonl4rHhpoNx1za7yp13Js5KNilREJmfNKpFZVQui6GO4dqR84iTX9ntSknxrADvJO2fjQGx48/yxLCdfCKcJKE7g/sWeuQOzt0mX1odKiiixqv7ESs0uP8Wde33VpWqydIl9nBuWwR2Bzd78WLVPRw80a81juK2A3e6uNJLE4xmKXHMJEu2aQ/m5wOukrZBCD2gl/5jKqOe0Uk5Oeo7+Pnb63+qJKAMIF4lhzyPr0zl8KnD+k0Kw8OUHOF9uim073j4FH5T65Njv0rlKnWrYrWJdwBpq6+Hw9azJos6wq+Dzeh1tQUh34HLE9ZeBKDiIjpPFLOLOrkAve4hlSgiDZrx/bYMb39GpjBMGLMnKv8cbt49kJQ1Rc/wNVR559bFr0NPPf+WkHvu9HXExM0Ngm5zuT7BNpmzo8eXHiAAq6dMKPcq1+I4ecvLvGXa48RojnyN/sl6+TzgXMnl1IQZq6p3YAKaHyiAPtpPliZbWL2gtgdCWcKohY+TOvyhV2NSz5TYGuyX7oi6TEhEY6mEJzDSZ63gLyaxyq7GpxWZntaClCXD3vkbYSEW/EQaC2MOM9hlCILVaS/R4M7yx6hqRL6mPJbKb/7/TAAuIir6cN4/fabsRAp6XQgAN6aznmAVSRphW4SXBc32rxyu0pw1g3F3KRl1a92D9tWsrljVg4xNtqU5OVgBsG6f0SLNoODTF+tQZP/W2oZSckshdICfhAuSJ2Zkhnf0n/yUPcunLuRCclxq/qE0g==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

I found the UI in an odd state this morning.

After a bit of poking about I think I see what was going on , but I have no
idea how to fix it or avoid it in the future. ( Thus this email.) Any
suggestions/ideas would be appreciated.

User auth'ed into the app.
Left column was displayed... but the main content area had
the "spinning wheel of death"... eventually the AJAX timeout happened and the
user got the ajax error.

Q1: Has anyone else experience this kind of issue with the UI?


It turned out that the DB had a long running query on the grouper_audit_entry
table. Which apparently was hanging other reads. ( Which does not really make
sense to me. I am still waiting on the DB getting into the office to bend his
ear about it.)
Killed the hung process (query?)... and things returned to normal.

Query that was hanging for the UI was specifically....
select as id1_10_,
auditentry0_.hibernate_version_number as hibernat2_10_,
auditentry0_.act_as_member_id as act_as_m3_10_,
auditentry0_.audit_type_id as audit_ty4_10_, auditentry0_.context_id as
auditentry0_.created_on as created_6_10_, auditentry0_.description as
auditentry0_.env_name as env_name8_10_, auditentry0_.grouper_engine as
auditentry0_.grouper_version as grouper10_10_, auditentry0_.int01 as
int11_10_, auditentry0_.int02 as int12_10_,
auditentry0_.int03 as int13_10_, auditentry0_.int04 as int14_10_,
auditentry0_.int05 as int15_10_,
auditentry0_.last_updated as last_up16_10_, auditentry0_.logged_in_member_id
as logged_17_10_,
auditentry0_.server_host as server_18_10_, auditentry0_.string01 as
auditentry0_.string02 as string20_10_, auditentry0_.string03 as string21_10_,
auditentry0_.string04 as string22_10_, auditentry0_.string05 as string23_10_,
auditentry0_.string06 as string24_10_, auditentry0_.string07 as string25_10_,
auditentry0_.string08 as string26_10_, auditentry0_.duration_microseconds as
auditentry0_.query_count as query_c28_10_, auditentry0_.user_ip_address as
auditentry0_.server_user_name as server_30_10_
from grouper_audit_entry auditentry0_ where
auditentry0_.act_as_member_id='GUID_FOR_MY_USER_:)' order by
auditentry0_.created_on desc limit 6
There is an index on act_as_member_id and the search returns in just a few
ms's. ( when not blocked )


My first thought:
Get some DBA help. ( not sure that will fix it... Maybe an overnight
backup process hung? Maybe the analyze process hung?... Just not sure yet...)

My second thought:
Is to "stop doing that on login" to try to avoid a fully
non-functional login event like this.
Q2: How can I alter the "landing page" for a user to avoid
this search? ( Maybe land on a more "static content page"? )
Q3: Is there a way to get to "Recent activity" other than the
"Home" link/page? ( Maybe with more than 6 records? Some kind of filter by
day/month/type of objects, etc..?)

My third thought:
Q4: Is there a way to make the app "timeout" faster for *that* SQL
call, to avoid the fail though to the AJAX error? ( At least that way the
user might get in and be able to do other things... *maybe* )

Carey Matthew

  • [grouper-users] UI hang during login, Black, Carey M., 01/10/2018

Archive powered by MHonArc 2.6.19.

Top of Page