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

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 27 février (10h30-12h)

Mardi 19 mars (16h-17h30)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

14 et 15 février (9h - 12h30)

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

21 et 22 février (9h - 12h30)

10 et 11 avril (9h - 12h30)

 

 

 
 

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 Connexion 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 Connexion 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 Connexion 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 Connexion 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 Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.040 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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