View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Cron stopped... - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

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

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Cron stopped...

More
11 Sep 2018 10:39 #1 by Durou C
Cron stopped... was created by Durou C
Why the cron stopped itself ?

Please Connexion or Create an account to join the conversation.

More
11 Sep 2018 11:25 #2 by babynus
Replied by babynus on topic Cron stopped...
Possibly some error.
Please report any error in log file.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
11 Sep 2018 11:42 #3 by Durou C
Replied by Durou C on topic Cron stopped...
the last log file:
2018-09-11 07:56:13.013 ===== TRACE ===== NEW CONNECTED USER 'LOL'
2018-09-11 08:24:34.106 ===== TRACE ===== Login error for user 'jop'
2018-09-11 08:24:41.690 ===== TRACE ===== NEW CONNECTED USER 'jop'
2018-09-11 09:01:09.030 ===== TRACE ===== NEW CONNECTED USER 'par'
2018-09-11 09:02:22.790 ===== TRACE ===== NEW CONNECTED USER 'fch'
2018-09-11 09:06:51.352 ===== TRACE ===== NEW CONNECTED USER 'sba'
2018-09-11 09:10:20.079 ===== TRACE ===== sendMailIfMailable : Mails without dest
2018-09-11 09:11:00.722 ===== TRACE ===== DISCONNECTED USER 'fch'
2018-09-11 09:11:13.523 ===== TRACE ===== NEW CONNECTED USER 'fch'
2018-09-11 09:17:27.728 ===== TRACE ===== NEW CONNECTED USER 'JSD' (using remember me feature)
2018-09-11 09:29:07.977 ===== TRACE ===== DISCONNECTED USER 'JSD'
2018-09-11 10:35:59.526 ===== TRACE ===== NEW CONNECTED USER 'dep'
2018-09-11 10:38:36.750 ===== TRACE ===== Cron started at 11/09/2018 10:38:36
2018-09-11 10:38:44.729 ===== TRACE ===== BackupDatabase has been done by the Cron
2018-09-11 10:38:44.839 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - Projets : 3,5,20,33,67,68,80,87,93,124,144,184,185,187,188,197,225,234,235,237,240,292,348,349,350,363,364,376,380,381,392,421,425,428,432,433,435,437,457,458,460,462,466,467,468,469,473,476,477,479,480,481,482,483,484,489,490,491,492,494,498,500,501,505,507,508,512,513
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] EXCEPTION *****
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] on file '/var/www/projeqtor/model/persistence/Sql.php' at line (179)
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] cause = There is already an active transaction
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] => #0 /var/www/projeqtor/model/persistence/Sql.php (179) -> beginTransaction()
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] => #1 /var/www/projeqtor/model/PlannedWork.php (1186) -> beginTransaction()
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] => #2 /var/www/projeqtor/tool/cronExecutionStandard.php (46) -> plan()
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] => #3 /var/www/projeqtor/model/Cron.php (427) -> cronPlanningDifferential()
2018-09-11 10:38:46.698 ***** ERROR ***** [V7.2.2] => #4 /var/www/projeqtor/tool/cronRun.php (31) -> run()
2018-09-11 10:40:15.136 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2018-09-11 10:40:15.136 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2018-09-11 10:40:15.137 ===== TRACE ===== - Projet
2018-09-11 10:40:15.142 ===== TRACE ===== Les customisations ont été corrigées automatiquement
2018-09-11 10:40:39.610 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2018-09-11 10:40:39.610 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2018-09-11 10:40:39.610 ===== TRACE ===== - Projet
2018-09-11 10:40:39.612 ===== TRACE ===== Les customisations ont été corrigées automatiquement
2018-09-11 10:40:43.054 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2018-09-11 10:40:43.054 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2018-09-11 10:40:43.054 ===== TRACE ===== - Projet
2018-09-11 10:40:43.056 ===== TRACE ===== Les customisations ont été corrigées automatiquement
2018-09-11 10:43:30.783 ===== TRACE ===== Cron started at 11/09/2018 10:43:30
2018-09-11 10:59:32.271 ***** ERROR ***** [V7.2.2] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket.idOrganization' in 'where clause'
2018-09-11 10:59:32.271 ***** ERROR ***** [V7.2.2] For query : select ticket.id as id, T1.name as nameProject, T2.name as nameActivity, T3.name as nameTicketType, ticket.name as name, T4.fullName as nameContact, ticket.idContact as idContact, T5.fullName as nameResource, ticket.idResource as idResource, convert(concat(COALESCE(T6.sortOrder,''),'#split#',T6.name,'#split#',COALESCE(T6.color,'')) using utf8) as colorNameUrgency, convert(concat(COALESCE(T7.sortOrder,''),'#split#',T7.name,'#split#',COALESCE(T7.color,'')) using utf8) as colorNamePriority, convert(concat(COALESCE(T8.sortOrder,''),'#split#',T8.name,'#split#',COALESCE(T8.color,'')) using utf8) as colorNameStatus, ticket.actualDueDateTime as actualDueDateTime, ticket.handled as handled, ticket.done as done, ticket.idle as idle, workelement.plannedWork as plannedWork, workelement.realWork as realWork, workelement.leftWork as leftWork,ticket.idProject as idproject from ticket left join project as T1 on ticket.idProject = T1.id left join activity as T2 on ticket.idActivity = T2.id left join type as T3 on ticket.idTicketType = T3.id left join resource as T4 on ticket.idContact = T4.id left join resource as T5 on ticket.idResource = T5.id left join urgency as T6 on ticket.idUrgency = T6.id left join priority as T7 on ticket.idPriority = T7.id left join status as T8 on ticket.idStatus = T8.id left join workelement as workelement on (workelement.refId=ticket.id and workelement.refType='Ticket') where ticket.idle=0 and ticket.idProject in (0, 512) and ( (ticket.idProject not in (0) or ticket.idProject is null ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idResource='12') ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idUser='12') ) ) and (ticket.idOrganization IN (5)) order by ticket.id desc
2018-09-11 10:59:32.271 ***** ERROR ***** [V7.2.2] Strack trace :
2018-09-11 10:59:32.271 ***** ERROR ***** [V7.2.2] #0 Sql->query called at [/var/www/projeqtor/tool/jsonQuery.php:565]
2018-09-11 11:05:26.413 ===== TRACE ===== DISCONNECTED USER 'APO'

Please Connexion or Create an account to join the conversation.

More
11 Sep 2018 11:43 #4 by Durou C
Replied by Durou C on topic Cron stopped...
yesterday log file:

2018-09-10 08:14:09.130 ===== TRACE ===== NEW CONNECTED USER 'chd'
2018-09-10 08:23:44.473 ===== TRACE ===== NEW CONNECTED USER 'JRI'
2018-09-10 08:27:10.882 ===== TRACE ===== Login error for user 'jop'
2018-09-10 08:27:28.829 ===== TRACE ===== Login error for user 'jop'
2018-09-10 08:27:33.382 ===== TRACE ===== Login error for user 'jop'
2018-09-10 08:27:37.847 ===== TRACE ===== NEW CONNECTED USER 'jop'
2018-09-10 09:26:20.761 ===== TRACE ===== NEW CONNECTED USER 'dep'
2018-09-10 09:56:17.968 ===== TRACE ===== NEW CONNECTED USER 'fca'
2018-09-10 09:58:36.592 ***** ERROR ***** [V7.2.2] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'work.rate' in 'field list'
2018-09-10 09:58:36.593 ***** ERROR ***** [V7.2.2] For query : select work.id as id, T1.fullName as nameResource, work.idResource as idResource, T2.name as nameProject, work.rate as rate, work.idle as idle,work.idProject as idproject from work left join resource as T1 on work.idResource = T1.id left join project as T2 on work.idProject = T2.id where 1=1 and idResource in (18, 35, 55, 40, 62, 12, 25, 13, 60, 69, 59, 5, 41, 23, 71, 8, 63, 42, 9, 49, 52, 39, 57, 65, 58, 28, 70, 6, 22, 67, 48, 51, 31, 24, 33, 53, 44, 66, 30, 61, 21, 68, 1, 2, 47) order by work.id desc
2018-09-10 09:58:36.593 ***** ERROR ***** [V7.2.2] Strack trace :
2018-09-10 09:58:36.593 ***** ERROR ***** [V7.2.2] #0 Sql->query called at [/var/www/projeqtor/tool/jsonQuery.php:565]
2018-09-10 10:17:35.820 ===== TRACE ===== NEW CONNECTED USER 'ASE'
2018-09-10 10:18:20.579 ===== TRACE ===== DISCONNECTED USER 'ASE'
2018-09-10 10:53:51.943 ===== TRACE ===== NEW CONNECTED USER 'sba'
2018-09-10 15:53:58.258 ===== TRACE ===== NEW CONNECTED USER 'par'
2018-09-10 16:03:18.329 ===== TRACE ===== NEW CONNECTED USER 'APO'
2018-09-10 16:03:26.037 ===== TRACE ===== DISCONNECTED USER 'par'
2018-09-10 16:36:38.718 ===== TRACE ===== NEW CONNECTED USER 'fch'
2018-09-10 17:26:48.631 ===== TRACE ===== NEW CONNECTED USER 'ASE'
2018-09-10 17:27:07.789 ===== TRACE ===== DISCONNECTED USER 'ASE'
2018-09-10 18:07:26.320 ===== TRACE ===== DISCONNECTED USER 'fch'
2018-09-10 18:14:40.453 ===== TRACE ===== Cron started at 10/09/2018 18:14:40
2018-09-10 18:14:40.568 ***** ERROR ***** [V7.2.2] ERROR *****
2018-09-10 18:14:40.568 ***** ERROR ***** [V7.2.2] on file '/var/www/projeqtor/tool/generateImputationAlert.php' at line (104)
2018-09-10 18:14:40.568 ***** ERROR ***** [V7.2.2] cause = Missing argument 1 for generateImputationAlert(), called in /var/www/projeqtor/model/Cron.php on line 427 and defined
2018-09-10 18:14:46.747 ===== TRACE ===== Cron started at 10/09/2018 18:14:46
2018-09-10 18:14:54.368 ===== TRACE ===== BackupDatabase has been done by the Cron
2018-09-10 18:14:54.472 ===== TRACE ===== Cron::run() - Calcul Imputation Alert for Resource
2018-09-10 18:15:25.381 ===== TRACE ===== Cron::run() - generateImputationAlert for cronImputationAlertCronResource at 1536332400 MAIL NO NO NO
2018-09-10 18:15:25.481 ===== TRACE ===== Calcul automatique du planning : calcul complet - Projets : tous
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] EXCEPTION *****
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] on file '/var/www/projeqtor/model/persistence/Sql.php' at line (179)
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] cause = There is already an active transaction
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] => #0 /var/www/projeqtor/model/persistence/Sql.php (179) -> beginTransaction()
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] => #1 /var/www/projeqtor/model/PlannedWork.php (1186) -> beginTransaction()
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] => #2 /var/www/projeqtor/tool/cronExecutionStandard.php (62) -> plan()
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] => #3 /var/www/projeqtor/model/Cron.php (427) -> cronPlanningComplete()
2018-09-10 18:15:27.536 ***** ERROR ***** [V7.2.2] => #4 /var/www/projeqtor/tool/cronRun.php (31) -> run()
2018-09-10 18:19:41.986 ===== TRACE ===== DISCONNECTED USER 'dep'
2018-09-10 18:20:46.590 ===== TRACE ===== DISCONNECTED USER 'jop'

Please Connexion or Create an account to join the conversation.

More
11 Sep 2018 12:11 #5 by babynus
Replied by babynus on topic Cron stopped...
Hi,

Try and delete line in table cronexecution where functionName = 'cronImputationAlert'
(you should have 4 remaining lines where functionName starts with 'cronImputationAlert')

This will be included in patch V7.2.3

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
03 Oct 2018 14:51 #6 by Durou C
Replied by Durou C on topic Cron stopped...
I have the lastest version of Projeqtor, I had delete all of line in table cronexecution with "alert", and also the cron start for a few minutes and stop itself.

what's the mistake?

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.073 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.