Welcome Guest, Not a member yet? Register   Sign In
Commands out of sync error on database session driver
#1

Hi

I put the session driver on the database, The following error is frequently received in log files.

Code:
Query error: Commands out of sync; you can't run this command now - Invalid query: SELECT RELEASE_LOCK('690ff9aba88534c094a7efd3ea18f807') AS ci_session_lock

I have no problem with other parts or other operations of the database and only receive this error in session mode on the database.

Please help me to solve this problem
Best regards
Reply
#2

What version of CodeIgniter are you running?
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply
#3

(12-22-2020, 02:51 AM)InsiteFX Wrote: What version of CodeIgniter are you running?

php: 7.3

codeigniter: 3
Reply
#4

I would try to use the GitHub developer version 3.2 of CodeIgniter 3.

They may have fixed it on there.

CodeIgniter 3.2.0-dev
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply
#5

(12-21-2020, 06:04 AM)mehran.ranji Wrote: Hi

I put the session driver on the database, The following error is frequently received in log files.

Code:
Query error: Commands out of sync; you can't run this command now - Invalid query: SELECT RELEASE_LOCK('690ff9aba88534c094a7efd3ea18f807') AS ci_session_lock

I have no problem with other parts or other operations of the database and only receive this error in session mode on the database.

Hi Mehran

Have you been able to find what was the cause for this issue?
I get the same error.
Thank you!
Reply




Theme © iAndrew 2016 - Forum software by © MyBB