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

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

3 décembre (16h-17h30)

9 janvier 2025 (10h30-12h)

4 février 2025 (16h-17h30)

6 mars 2025 (10h30-12h)

 
 

Planifiez avec ProjeQtOr

19 et 20 novembre (14h-17h30)

21 et 22 janvier 2025 (9h-12h30)

18 et 19 mars 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

26 et 27 novembre (14h-17h30)

28 et 29 janvier (9h-12h30)

25 et 26 mars (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.035 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.