- Posts: 22
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
urgent: login, surveys not working
- gsoto
- Topic Author
- Offline
- Junior Member
Less
More
3 years 11 months ago #199026
by gsoto
Replied by gsoto on topic urgent: login, surveys not working
If storage shortage is part of the issue – won't a long session time add to this bottleneck? And following up, what triggers when a session file is deleted? This is all assuming that the piling up of large session files contributes to the problem, which was my understanding before your last comment.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
3 years 11 months ago #199032
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic urgent: login, surveys not working
Previously we try to offer allow updating of HP sessuion lifetime, but since it's a lot disable by hoster : we removge the option (a lot of bug report about this).
BUT : we leave it for DB session
manual.limesurvey.org/Optional_settings#...table-based_sessions
BUT : we leave it for DB session
manual.limesurvey.org/Optional_settings#...table-based_sessions
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- gsoto
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
- Thank you received: 1
3 years 11 months ago #199124
by gsoto
Replied by gsoto on topic urgent: login, surveys not working
Together with our hosting provider, we have now decided to implement the following measures:
Hopefully, this will prevent the problem in the future. Thanks again for your help.
- Optimizing the survey design
- Adjusting the PHP gargabe collector
- Changing to table-based sessions
- Adjusting the session lifetime for table-based sessions
Hopefully, this will prevent the problem in the future. Thanks again for your help.
The topic has been locked.
- gsoto
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
- Thank you received: 1
3 years 6 months ago #207220
by gsoto
Replied by gsoto on topic urgent: login, surveys not working
Update: We have since changed our sessions to table based sessions. On a running survey with a large number of participants, the server collapsed almost instantly (within two minutes). Our hosting provider identified the problem: session entries are deleted from lime_sessions based on the value in the column 'expire'. Since this column did not have an index, the request took longer and longer as the session table was growing, blocking the table for other requests. By creating an index on the column 'expire', the issue could be resolved.
I realize that this is only an issue when there is a huge amounts of entries in the session table. However: could it be an option to make it the standard way for LS to create the session table with an index on 'expire'?
I realize that this is only an issue when there is a huge amounts of entries in the session table. However: could it be an option to make it the standard way for LS to create the session table with an index on 'expire'?
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
3 years 6 months ago #207221
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic urgent: login, surveys not working
Yes , sure , can you report the issue please :
community.limesurvey.org/bug-tracker/
community.limesurvey.org/bug-tracker/
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.