View Issue Details

IDProjectCategoryView StatusLast Update
2729Composrcorepublic2016-07-18 16:23
ReporterPDStig Assigned ToChris Graham  
PriorityurgentSeverityminor 
Status resolvedResolutionfixed 
Summary2729: Session Prudence setting ignored
DescriptionI remember having this issue before. Sessions were not being saved in the database like I need them to for my radio system to function properly. It's happening again despite session prudence being on. Only guest sessions seem to be saved in the database.
TagsNo tags attached.
Attach Tags
Time estimation (hours)
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Activities

PDStig

2016-07-16 22:08

administrator   ~4142

Actually, upon further tests, sessions are working correctly for regular users. They are not however working for Facebook Connect users.

Chris Graham

2016-07-18 10:23

administrator   ~4151

Please clarify, are you saying when a Facebook user hits your website they are logged in but they have no corresponding row in the sessions table? That doesn't seem possible.
Or, are they not logging in at all?

PDStig

2016-07-18 11:15

administrator   ~4155

Yes, when a Facebook Connect user is logged in, there is no session row for them in the database. They do have a session cookie though. I tested it with my Lovinity account since it's facebook connected. I browsed around several pages and never got a session row in the database despite being logged in.

What I find weird is that this was working just fine on Thursday. Then sometime between Thursday and Saturday it's not working anymore. I didn't change anything on site.

Chris Graham

2016-07-18 16:23

administrator   ~4161

Didn't reproduce, but we'll assume it was because sessions weren't written if the table is locked. Maybe there was heavy load on that table for some reason, or racing between multiple parallel requests, or MySQL wasn't good at keeping track of locks.

I'll remove the table lock check from that table.

Issue History

Date Modified Username Field Change
2016-07-16 22:00 PDStig New Issue
2016-07-16 22:08 PDStig Note Added: 0004142
2016-07-18 10:23 Chris Graham Note Added: 0004151
2016-07-18 11:15 PDStig Note Added: 0004155
2016-07-18 16:23 Chris Graham Note Added: 0004161
2016-07-18 16:23 Chris Graham Status Not Assigned => Resolved
2016-07-18 16:23 Chris Graham Resolution open => fixed
2016-07-18 16:23 Chris Graham Assigned To => Chris Graham