2.3.1 - Error Code: sessionwaiterr / Session Lock Error

2.3.1 - Error Code: sessionwaiterr / Session Lock Error

by 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?

Average of ratings: -
In reply to Ron Houtman

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

by 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
Average of ratings: Useful (1)
In reply to Dan Poltawski

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

by mohamed mohammedi -

Bonjour Dan et bonjour les Moodellers smile

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

Merci

Average of ratings: -
In reply to Ron Houtman

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

by 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

Average of ratings: -
In reply to Bob Ross

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

by 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()

sad

Average of ratings: -
In reply to Lorenzzo Mollinar

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

by 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? 

 

 

Average of ratings: -
In reply to Olaf Kienas

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

by 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()
Average of ratings: -
In reply to Ricky R

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

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

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

Average of ratings: Useful (2)
In reply to Howard Miller

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

by 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 smile

Average of ratings: -
In reply to Dennys Patricio Villacrés Jiménez

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

by Serg Tolpygin -

is not good solution - storing session in database ?

Average of ratings: -