Hello,
My cron stop with this trouble :
i can't find solution or what happen ?
2023-12-11 13:56:42.488 ** ERROR ** [V11.0.2] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'paused' in 'where clause'
2023-12-11 13:56:42.489 ** ERROR ** [V11.0.2] For query : select * from meeting where (exists (select 'x' from assignment x where x.refType='Meeting' and x.refId=meeting.id and x.idResource=13)) and idle=0 and done=0 and paused=0 and idProject not in (0, 364) LIMIT 201
2023-12-11 13:56:42.489 ** ERROR ** [V11.0.2] Strack trace :
2023-12-11 13:56:42.489 ** ERROR ** [V11.0.2] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2965]
2023-12-11 13:56:42.489 ** ERROR ** [V11.0.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1461]
2023-12-11 13:56:42.489 ** ERROR ** [V11.0.2] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1345]
2023-12-11 13:56:42.489 ** ERROR ** [V11.0.2] #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:234]
2023-12-11 13:56:42.494 ** ERROR ** [V11.0.2] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'paused' in 'where clause'
2023-12-11 13:56:42.494 ** ERROR ** [V11.0.2] For query : select * from testsession where (exists (select 'x' from assignment x where x.refType='TestSession' and x.refId=testsession.id and x.idResource=13)) and idle=0 and done=0 and paused=0 and idProject not in (0, 364) LIMIT 201
2023-12-11 13:56:42.494 ** ERROR ** [V11.0.2] Strack trace :
2023-12-11 13:56:42.494 ** ERROR ** [V11.0.2] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2965]
2023-12-11 13:56:42.494 ** ERROR ** [V11.0.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1467]
2023-12-11 13:56:42.494 ** ERROR ** [V11.0.2] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1345]
2023-12-11 13:56:42.495 ** ERROR ** [V11.0.2] #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:234]
i also have this one :
2023-12-11 08:43:41.658 ** ERROR ** [V11.0.2] Error sending mail
2023-12-11 08:43:41.659 ** ERROR ** [V11.0.2] SMTP Server : SSL0.OVH.NET
2023-12-11 08:43:41.659 ** ERROR ** [V11.0.2] SMTP Port : 465
2023-12-11 08:43:41.659 ** ERROR ** [V11.0.2] Mail stored in Database : #9520
2023-12-11 08:43:41.659 ** ERROR ** [V11.0.2] PHPMail error : You must provide at least one recipient email address.
2023-12-11 08:43:41.659 ** ERROR ** [V11.0.2] PHPMail debug :
2023-12-11 08:43:41.843 ** ERROR ** [V11.0.2] Error sending mail
2023-12-11 08:43:41.843 ** ERROR ** [V11.0.2] SMTP Server : SSL0.OVH.NET
2023-12-11 08:43:41.843 ** ERROR ** [V11.0.2] SMTP Port : 465
2023-12-11 08:43:41.843 ** ERROR ** [V11.0.2] Mail stored in Database : #9521
2023-12-11 08:43:41.843 ** ERROR ** [V11.0.2] PHPMail error : You must provide at least one recipient email address.
2023-12-11 08:43:41.843 ** ERROR ** [V11.0.2] PHPMail debug :
so i don't know witch one is sptopping the cron and what to do ?
Thanks
LR
None of these errors should stop the Cron.
First is error generated by today page, so not "cronable" script.
Second is just an email sending issue, that does not stop the Cron.
Most common Cron Stop issue is scheduled reports.
Error in the report may stop the Cron.
Try and disable all scheduled repord and check if Cron still stops.
It not, reenable scheduled reports one by one until you find the one that stops the Cron, then sent us information about this report.
Thanks, i delete all my repport on today but still have the trouble.
I desactivate also mail to manager cause sometime activities have "non manager" but my trouble still present :
2023-12-13 00:49:54.775 ** ERROR ** [V11.0.3] CRON abnormally stopped
2023-12-13 00:49:54.775 ** ERROR ** [V11.0.3] === Trace Stack for last error ===
2023-12-13 00:49:54.775 ** ERROR ** [V11.0.3] => /var/www/projeqtor/model/Cron.php at line 319 calling debugPrintTraceStack()
2023-12-13 00:49:54.775 ** ERROR ** [V11.0.3] => /var/www/projeqtor/tool/cronRun.php at line 35 calling Cron:abort()
2023-12-13 00:49:54.775 ** ERROR ** [V11.0.3] => calling cronAbort()
2023-12-13 00:49:54.776 ** ERROR ** [V11.0.3] ===
2023-12-13 00:49:54.777 ** ERROR ** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] For query : select id as id, name as name from status where (idle=0 ) order by status.sortOrder, status.name
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] Strack trace :
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlList.php:149]
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] #1 SqlList->fetchList called at [/var/www/projeqtor/model/persistence/SqlList.php:63]
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] #2 SqlList->getList called at [/var/www/projeqtor/model/persistence/SqlList.php:446]
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] #3 SqlList->getStatusList called at [/var/www/projeqtor/model/persistence/SqlElement.php:9048]
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] #4 SqlElement->getFirstStatus called at [/var/www/projeqtor/model/persistence/SqlElement.php:8326]
2023-12-13 00:49:54.778 ** ERROR ** [V11.0.3] #5 SqlElement->getExtraRequiredFields called at [/var/www/projeqtor/model/persistence/SqlElement.php:4979]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #6 SqlElement->control called at [/var/www/projeqtor/model/persistence/SqlElement.php:1252]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #7 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #8 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #9 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #10 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #11 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #12 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.779 ** ERROR ** [V11.0.3] #13 cronAbort called at
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] For query : desc mail
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] Strack trace :
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:4170]
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #1 SqlElement->getFormatList called at [/var/www/projeqtor/model/persistence/SqlElement.php:3671]
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #2 SqlElement->getDataType called at [/var/www/projeqtor/model/persistence/SqlElement.php:5043]
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #3 SqlElement->control called at [/var/www/projeqtor/model/persistence/SqlElement.php:1252]
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #4 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #5 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #6 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.780 ** ERROR ** [V11.0.3] #7 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] #8 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] #9 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] #10 cronAbort called at
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] For query : select * from checklistable where checklistable.name='Mail'
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] Strack trace :
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2969]
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:3289]
2023-12-13 00:49:54.781 ** ERROR ** [V11.0.3] #2 SqlElement->getSingleSqlElementFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:5410]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #3 SqlElement->control called at [/var/www/projeqtor/model/persistence/SqlElement.php:1252]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #4 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #5 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #6 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #7 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #8 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #9 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.782 ** ERROR ** [V11.0.3] #10 cronAbort called at
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] For query : insert into mail ( mailDateTime , mailTo , mailStatus , idle , mailTitle , mailBody ) values ('2023-12-13 00:49', 'abc-gdp@abc-essais.com', 'WAIT', '0', '[ABC-Gestion des projets] Cron abnormally stopped', 'Cron was stopped for an undefined reason (abort).
Please check log file at 2023-12-13 00:49:54 for more information.')
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] Strack trace :
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1559]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1316]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #3 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #4 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #5 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #6 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #7 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.783 ** ERROR ** [V11.0.3] #8 cronAbort called at
2023-12-13 00:49:54.784 ** ERROR ** [V11.0.3] Error storing email in table : SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:55.434 ** ERROR ** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] For query : insert into mail ( mailDateTime , mailTo , mailStatus , idle , mailTitle , mailBody ) values ('2023-12-13 00:49', 'XXXXXXXXXXXX', 'OK', '0', '[ABC-Gestion des projets] Cron abnormally stopped', 'Cron was stopped for an undefined reason (abort).
Please check log file at 2023-12-13 00:49:54 for more information.')
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] Strack trace :
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1559]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1316]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #3 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #4 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2637]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #5 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #6 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #7 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:55.435 ** ERROR ** [V11.0.3] #8 cronAbort called at
Seems to be more this red message in imputation page ...
ERROR : Narrowing occurred during type inference of ZEND_FETCH_DIM_W. Please file a bug report on https://github.com/php/php-src/issues
in ImputationLine.php
at line 482
LR
Issue on Imputation page will not stop the Cron.
The error is : "MySQL server has gone away"
It seems your MySql server is stopped.
Possibly it is a maintenance operation, for cold backup, but the Cron does not like it....
023-12-27 00:03:24.581 ** ERROR ** [V11.0.3] CRON abnormally stopped
2023-12-27 00:03:24.582 ** ERROR ** [V11.0.3] === Trace Stack for last error ===
2023-12-27 00:03:24.582 ** ERROR ** [V11.0.3] => /var/www/projeqtor/model/Cron.php at line 319 calling debugPrintTraceStack()
2023-12-27 00:03:24.582 ** ERROR ** [V11.0.3] => /var/www/projeqtor/tool/cronRun.php at line 35 calling Cron:abort()
2023-12-27 00:03:24.582 ** ERROR ** [V11.0.3] => calling cronAbort()
My cron stopping every max 15min and i've got no message in 90% of case ... exept this morning ... no planned repport ( all deleted ), i desactivate mail...
Thanks for your support.
LR
Possibly PHP timeout.
The cron try to extend execution to unlimited, but your PHP configuration may forbit it.
Thanks for your support, i'll investigate.
LR
Thanks a lot ... a 30s inside !!! ...