Forum

Cron stopped...
 
Notifications
Retirer tout

Cron stopped...

8 Posts
2 Utilisateurs
0 Reactions
6,163 Vu
(@durou-c)
Posts: 468
Contributor
Début du sujet
 
[#5412]

Why the cron stopped itself ?


 
Posté : 11 Sep PM 12:099
(@babynus)
Posts: 14952
Membre Admin
 

Possibly some error.
Please report any error in log file.


 
Posté : 11 Sep PM 13:099
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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'


 
Posté : 11 Sep PM 13:099
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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'


 
Posté : 11 Sep PM 13:099
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 11 Sep PM 14:099
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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?


 
Posté : 3 Oct PM 16:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

last log file:

2018-10-03 09:13:39.496 ===== TRACE ===== Cron started at 03/10/2018 09:13:39
2018-10-03 09:14:09.753 ===== TRACE ===== Cron normally stopped at 03/10/2018 09:14:09
2018-10-03 09:14:11.605 ===== TRACE ===== Cron started at 03/10/2018 09:14:11
2018-10-03 10:00:02.231 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - Projets : 67,80,144,185,187,188,197,234,235,240,292,363,376,380,381,421,425,428,432,433,435,437,457,460,462,466,468,473,476,477,479,480,481,482,483,489,490,491,492,494,498,500,501,505,508,517,523,526,527,528,529,530
2018-10-03 10:00:03.490 ** ERROR ** [V7.2.3] EXCEPTION **
2018-10-03 10:00:03.490
** ERROR ** [V7.2.3] on file '/var/www/projeqtor/model/persistence/Sql.php' at line (179)
2018-10-03 10:00:03.490
** ERROR ** [V7.2.3] cause = There is already an active transaction
2018-10-03 10:00:03.490
** ERROR ** [V7.2.3] => #0 /var/www/projeqtor/model/persistence/Sql.php (179) -> beginTransaction()
2018-10-03 10:00:03.490
** ERROR ** [V7.2.3] => #1 /var/www/projeqtor/model/PlannedWork.php (1186) -> beginTransaction()
2018-10-03 10:00:03.490
** ERROR ** [V7.2.3] => #2 /var/www/projeqtor/tool/cronExecutionStandard.php (46) -> plan()
2018-10-03 10:00:03.490
** ERROR ** [V7.2.3] => #3 /var/www/projeqtor/model/Cron.php (427) -> cronPlanningDifferential()
2018-10-03 10:00:03.490
** ERROR ***** [V7.2.3] => #4 /var/www/projeqtor/tool/cronRun.php (31) -> run()
2018-10-03 10:00:03.490 ===== TRACE ===== Cron error : Une exception est survenue le 2018-10-03 à 10:00:03


 
Posté : 3 Oct PM 16:1010
(@babynus)
Posts: 14952
Membre Admin
 

Issue confirmed.
Ticket #3601 recorded
Will be fixed on next patch.


 
Posté : 5 Oct AM 10:1010
Share:
Retour en haut