Skip to main content

[Issue 18] New - When a user signs into the portal occasionally the sign in hangs

  • From: johnmac100 <johnmac100@...>
  • To: issues@...
  • Subject: [Issue 18] New - When a user signs into the portal occasionally the sign in hangs
  • Date: 18 Mar 2010 18:30:44 -0000
  • Mailing-list: contact issues-help@...; run by ezmlm

https://webspace.dev.java.net/issues/show_bug.cgi?id=18
                 Issue #|18
                 Summary|When a user signs into the portal occasionally the 
sig
                        |n in hangs
               Component|webspace
                 Version|current
                Platform|Other
              OS/Version|Linux
                     URL|
                  Status|NEW
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|www
             Assigned to|issues@webspace
             Reported by|johnmac100






------- Additional comments from johnmac100@... Thu Mar 18 18:30:43 +0000 
2010 -------
When a user signs into the webspace portal occasionally the sign in hangs. The
hang has been isolated to a particular update query:

update User_ set uuid_='[redacted]', companyId=[redacted],
createDate='2010-01-14 19:37:18', modifiedDate='2010-01-22 14:31:13',
defaultUser=0, contactId=[redacted], password_='[redacted]',
passwordEncrypted=1, passwordReset=0, passwordModifiedDate='2010-01-16
21:36:57', reminderQueryQuestion='', reminderQueryAnswer='', 
graceLoginCount=0,
screenName='[redacted]', emailAddress='[redacted]', openId='', 
portraitId=12001,
languageId='en_US', timeZoneId='UTC', greeting='[redacted]', comments='',
firstName='[redacted]', middleName='', lastName='[redacted]', jobTitle='',
loginDate='2010-03-02 08:38:44', loginIP='[redacted]', 
lastLoginDate='2010-03-02
07:34:13', lastLoginIP='207.47.120.74', lastFailedLoginDate=null,
failedLoginAttempts=0, lockout=0, lockoutDate=null, agreedToTermsOfUse=0,
active_=1 where userId=[redacted]

Glassfish: Enterprise v2.1
Webspace: 10
Mysql Version: 5.1.44
Webspace OS: Fedora 2.6.30.9-96.fc11.x86_64
Mysql OS: Same condition exists on both FC11 and RHEL4

- Transaction isolation level @ mysql has been modified multiple times. It is
currently @ READ COMMITTED

- By killing the ACTIVE transaction in mysql manually it is possible to free 
the
hang and the user can sign in

- The issue affects more than one unique user

- It seems to occur after long periods of inactivity. Ex: If a user is logged
in, logs out, then logs back in again there is generally not an issue. Also
after the first user is logged in with activity others seem to be able to 
login
with no issue




[Issue 18] New - When a user signs into the portal occasionally the sign in hangs

johnmac100 03/18/2010
 
 
Close
loading
Please Confirm
Close