Hello,
I have this trace in my log:2021-09-10 07:25:31.248 ** ERROR ** [V9.2.0] CRON abnormally stopped
2021-09-10 08:01:05.628 ** ERROR ** [V9.2.0] Exception-[25P01] SQLSTATE[25P01]: No active sql transaction: 7 ERREUR: LOCK TABLE peut seulement être utilisé dans des blocs de transaction
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] For query : LOCK TABLE mutex IN ACCESS EXCLUSIVE MODE
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] Strack trace :
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] #0 Sql->query called at [/home/projtma/public_html/model/Mutex.php:52]
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] #1 Mutex->reserve called at [/home/projtma/public_html/model/KpiValue.php:123]
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] #2 KpiValue->calculateKpiExecute called at [/home/projtma/public_html/model/KpiValueRequest.php:86]
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] #3 KpiValueRequest->triggerCalculation called at [/home/projtma/public_html/tool/cronExecutionStandard.php:191]
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] #4 kpiCalculate called at [/home/projtma/public_html/model/Cron.php:544]
2021-09-10 08:01:05.634 ** ERROR ** [V9.2.0] #5 Cron->run called at [/home/projtma/public_html/tool/cronRun.php:33]
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] Exception-[25P01] SQLSTATE[25P01]: No active sql transaction: 7 ERREUR: LOCK TABLE peut seulement être utilisé dans des blocs de transaction
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] For query : LOCK TABLE mutex IN ACCESS EXCLUSIVE MODE
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] Strack trace :
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] #0 Sql->query called at [/home/projtma/public_html/model/Mutex.php:52]
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] #1 Mutex->reserve called at [/home/projtma/public_html/model/KpiValue.php:123]
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] #2 KpiValue->calculateKpiExecute called at [/home/projtma/public_html/model/KpiValueRequest.php:86]
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] #3 KpiValueRequest->triggerCalculation called at [/home/projtma/public_html/tool/cronExecutionStandard.php:191]
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] #4 kpiCalculate called at [/home/projtma/public_html/model/Cron.php:544]
2021-09-10 08:01:05.674 ** ERROR ** [V9.2.0] #5 Cron->run called at [/home/projtma/public_html/tool/cronRun.php:33]
And for me some KPI don't runnning correctly.
Have you an idea or already view this error ?
Thanks.
Bruno.
after a quick check pearps is a bug specific with postgresql, in mutex.php i have this specific code for lock:
function reserve()
{
if (!$this->lockname) return;
if (Sql::isMysql()) {
$rs = Sql::query("SELECT GET_LOCK('".$this->lockname."', ".$this->timeout.") as mutex");
$line=Sql::fetchLine($rs);
$this->locked = $line['mutex'];
//mysqli_free_result($rs);
} else if (Sql::isPgsql()) {
$prefix=Parameter::getGlobalParameter('paramDbPrefix');
$rs=Sql::query("LOCK TABLE ".$prefix."mutex IN ACCESS EXCLUSIVE MODE");
$rs=Sql::query("SELECT * FROM ".$prefix."mutex WHERE name='".$this->lockname."'");
if (!is_array($rs) or count($rs)==0) {
$rs=Sql::query("INSERT INTO ".$prefix."mutex (name) VALUES ('".$this->lockname."')");
}
}
}
It seems you are using old version that was not tagged as Stable V9.2.0.
Please migrate to V9.2.3
Hello,
thanks for your answer after the migration i have the same error:
2021-09-16 10:01:01.175 ** ERROR ** [V9.2.3] Exception-[25P01] SQLSTATE[25P01]: No active sql transaction: 7 ERREUR: LOCK TABLE peut seulement être utilisé dans des blocs de transaction
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] For query : LOCK TABLE mutex IN ACCESS EXCLUSIVE MODE
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] Strack trace :
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] #0 Sql->query called at [/home/projtma/public_html/model/Mutex.php:52]
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] #1 Mutex->reserve called at [/home/projtma/public_html/model/KpiValue.php:123]
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] #2 KpiValue->calculateKpiExecute called at [/home/projtma/public_html/model/KpiValueRequest.php:86]
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] #3 KpiValueRequest->triggerCalculation called at [/home/projtma/public_html/tool/cronExecutionStandard.php:191]
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] #4 kpiCalculate called at [/home/projtma/public_html/model/Cron.php:545]
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] #5 Cron->run called at [/home/projtma/public_html/model/Cron.php:411]
2021-09-16 10:01:01.176 ** ERROR ** [V9.2.3] #6 Cron->relaunch called at [/home/projtma/public_html/tool/cronRelaunch.php:30]
Issue recorded as Ticket #5700