Unable to get lock on session_client

daniel

Hi,

I have problem during instalation from "easyinstall.php":



Type: 256

Message: Unable to get lock on session_client name=08523a6cfb073819ee7dbfd694c1be4f cid=0

File: /usr/local/apache/www/htdocs/crm.domena.eu/epesi/include/session.php

Line=85

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "Unable to get lock on session_client name=08523a6cfb073819ee7dbfd694c1be4f cid=0", "/usr/local/apache/www/htdocs/crm.domena.eu/epesi/include/session.php", 85, Array ("08523a6cfb073819ee7dbfd694c1be4f", "a:1:{s:14:\"num_of_clients\";i:1;}"))

File: /usr/local/apache/www/htdocs/crm.domena.eu/epesi/include/session.php

    line 85

    function called: trigger_error("Unable to get lock on session_client name=08523a6cfb073819ee7dbfd694c1be4f cid=0", 256)

[PHP core called function]

    function called: read("08523a6cfb073819ee7dbfd694c1be4f")

File: /usr/local/apache/www/htdocs/crm.domena.eu/epesi/include/session.php

    line 198

    function called: session_start()

File: /usr/local/apache/www/htdocs/crm.domena.eu/epesi/include.php

    line 24

    function called: require_once("/usr/local/apache/www/htdocs/crm.domena.eu/epesi/include/session.php")

File: /usr/local/apache/www/htdocs/crm.domena.eu/epesi/process.php

    line 21

    function called: require_once("/usr/local/apache/www/htdocs/crm.domena.eu/epesi/include.php")

Best regards,

Daniel

daniel

I tried to install the full version from zip file but after section:
Setup will now check for available modules and will install them.This operation may take several minutes.

is:

Failure (500)

🙁

jasiek

Daniel,

The session problem is triggered by this code:

public static function read($name) {

        if(DATABASE_DRIVER=='mysqlt') {

            if(!READ_ONLY_SESSION && !DB::GetOne('SELECT GET_LOCK(%s,%d)',array($name,ini_get('max_execution_time'))))

                trigger_error('Unable to get lock on session name='.$name,E_USER_ERROR);

Which indicates that you have a problem with a database connection. Check if you have a driver for MySQL enabled in your php.ini.
Did you read this post: viewtopic.php?f=6&t=496 ?

As for Failure 500 - this is a general error - it could be anything. Again - check your php error log for details.

ethnar

Hello,

The first error message suggest that the MySQL user you created for EPESI doesn't have permission to lock tables. You should review the permissions on your MySQL user to make sure you allow locking tables. It's best to simply allow all operations on your selected database to avoid problems of this nature.

Kind regards,
Arek

daniel

Hi,

I have a solution of this problem. The first instalation with the error was made on MySQL 5.5.
After using MySQL 5.0 all is ok 🙂

Best regards,

Daniel

[deleted]

Hi,

This issue due to max_execution_time.

Simply change max_execution_time = 30 instead max_execution_time = 0 in php.ini.

Thank you,

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge