View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - KPI error and error in log - ProjeQtOr
 
 

KPI error and error in log

More
10 Sep 2021 08:32 #1 by pipobru
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.

Please Log in or Create an account to join the conversation.

More
10 Sep 2021 09:04 #2 by pipobru
Replied by pipobru on topic KPI error and error in log
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;
//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."')");
}
}
}

Please Log in or Create an account to join the conversation.

More
14 Sep 2021 17:32 #3 by babynus
Replied by babynus on topic KPI error and error in log
It seems you are using old version that was not tagged as Stable V9.2.0.
Please migrate to V9.2.3

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: pipobru

Please Log in or Create an account to join the conversation.

More
16 Sep 2021 10:19 #4 by pipobru
Replied by pipobru on topic KPI error and error in log
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]

Please Log in or Create an account to join the conversation.

More
17 Sep 2021 13:00 #5 by babynus
Replied by babynus on topic KPI error and error in log
Issue recorded as Ticket #5700

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.042 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.