2.3.1 - Error Code: sessionwaiterr / Session Lock Error

2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Ron Houtman -
Number of replies: 9

On a new installation of Moodle 2.3.1 - 
Windows Server 2008 R2 x64, SQL, IIS - App server in one VM, SQL in another - 8GB RAM for both

While trying to restore courses from same version (2.3.1) (8MB, 20MB, 35MB)- getting the following:

Timed out while waiting for session lock. Wait for your current requests to finish and try again later.

 

Debug info: 
Error code: sessionwaiterr

 

Stack trace:
  • line 1339 of \lib\dml\sqlsrv_native_moodle_database.php: dml_sessionwait_exception thrown
  • line 593 of \lib\sessionlib.php: call to sqlsrv_native_moodle_database->get_session_lock()
  • line ? of unknownfile: call to database_session->handler_read()
  • line 184 of \lib\sessionlib.php: call to session_start()
  • line 473 of \lib\sessionlib.php: call to session_stub->__construct()
  • line 60 of \lib\sessionlib.php: call to database_session->__construct()
  • line 728 of \lib\setup.php: call to session_get_instance()
  • line 27 of \config.php: call to require_once()
  • line 31 of \index.php: call to require_once()

Anyone have a hint about this?

Ngā whakawākanga toharite: -
In reply to Ron Houtman

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Dan Poltawski -
Hi Ron,

This tends to happen when there are multiple requests on the same session tying up your request. Its usually indicative of another problem, a slow running query/request etc. You might want to look at other requests which are going on at the same time.

cheers,
dan
Ngā whakawākanga toharite: Useful (1)
In reply to Dan Poltawski

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā mohamed mohammedi -

Bonjour Dan et bonjour les Moodellers menemene

Pourriez-vous nous expliquer un peu plus sur comment découvrirez ces autres requêtes qui sont émis en même temps ?

Merci

Ngā whakawākanga toharite: -
In reply to Ron Houtman

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Bob Ross -

Hi Ron

I'm having exactly the same issue that you've reported here, just on Moodle 2.6. Were you able to figure out a solution for fixing the timeout?

 

Moodle 2.6, Server 2008 R2 x64, IIS, MSSQL, PHP for MSSQL driver.

 

Thanks

Nick

Ngā whakawākanga toharite: -
In reply to Bob Ross

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Lorenzzo Mollinar -

I have the same problem in Moodle 2.6 +, can anyone give me a suggestion to the problem? hugs

 

Tempo esgotado enquanto aguardava trava de sessão. 
Aguarde a finalização de requisição e tente novamente mais tarde.

Debug info: 
Error code: sessionwaiterr
Stack trace:
  • line 1269 of /lib/dml/pgsql_native_moodle_database.php: dml_sessionwait_exception thrown
  • line 178 of /lib/classes/session/database.php: call to pgsql_native_moodle_database->get_session_lock()
  • line ? of unknownfile: call to core\session\database->handler_read()
  • line 42 of /lib/classes/session/handler.php: call to session_start()
  • line 77 of /lib/classes/session/manager.php: call to core\session\handler->start()
  • line 805 of /lib/setup.php: call to core\session\manager::start()
  • line 25 of /config.php: call to require_once()
  • line 27 of /login/index.php: call to require()

pōuri

Ngā whakawākanga toharite: -
In reply to Lorenzzo Mollinar

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Olaf Kienas -

have you found a solution to the problem?

If so ? What ? Does it have any thing to do with the time out on the server? 

 

 

Ngā whakawākanga toharite: -
In reply to Olaf Kienas

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Ricky R -

Hi there,

I'm having the same problem in 2.6.  Has anyone found a solution to this problem?

Debug info: 
Error code: sessionwaiterr
Stack trace:
  • line 1571 of \lib\dml\mysqli_native_moodle_database.php: dml_sessionwait_exception thrown
  • line 178 of \lib\classes\session\database.php: call to mysqli_native_moodle_database->get_session_lock()
  • line ? of unknownfile: call to core\session\database->handler_read()
  • line 42 of \lib\classes\session\handler.php: call to session_start()
  • line 77 of \lib\classes\session\manager.php: call to core\session\handler->start()
  • line 775 of \lib\setup.php: call to core\session\manager::start()
  • line 721 of \config.php: call to require_once()
Ngā whakawākanga toharite: -
In reply to Ricky R

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Howard Miller -
Pikitia o Core developers Pikitia o Documentation writers Pikitia o Particularly helpful Moodlers Pikitia o Peer reviewers Pikitia o Plugin developers

Don't use the database to store sessions. In my experience, it doesn't work. 

Ngā whakawākanga toharite: Useful (2)
In reply to Howard Miller

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Dennys Patricio Villacrés Jiménez -

Hi Howard.


But I have a cluster?


I do not have memchache, the sessions store normally in a glusterfs.


Thank you menemene

Ngā whakawākanga toharite: -
In reply to Dennys Patricio Villacrés Jiménez

Re: 2.3.1 - Error Code: sessionwaiterr / Session Lock Error

Nā Serg Tolpygin -

is not good solution - storing session in database ?

Ngā whakawākanga toharite: -