Forum GLPI-Project

ivan.ramirez

Member

From: España

Registered: 2017-12-02

Posts: 2

mailqueue and ticketrecurrent freezed

I have glpi 9.1.6 installed on Centos 7 virtual Machine
I have many problems with automatick task mailqueue and ticketrecurrent. I have configured mailqueue by pseudo-cron task mode (by cli mode failed as well) and ticket recurrent by cli task mode.

Interno #1: Ejecutar mailgate
2017-12-02 21:53:01 [@glpi-gs01]
No se puede obtener el bloqueo de la BD
2017-12-02 21:54:01 [@glpi-gs01]
No se puede obtener el bloqueo de la BD

2017-12-02 22:00:01 [@glpi-gs01]
Externo #1: Ejecutar ticketrecurrent
2017-12-02 22:01:01 [@glpi-gs01]
No se puede obtener el bloqueo de la BD
2017-12-02 22:02:01 [@glpi-gs01]
No se puede obtener el bloqueo de la BD

I think it could be a Mariadb problem

2017-12-02 21:31:55 [64@glpi-gs01]
  *** MySQL query error:
  SQL: SELECT  `id` FROM `glpi_notimportedemails` WHERE `mailcollectors_id` = 23
  Error: MySQL server has gone away
  Backtrace :
  inc/dbmysql.class.php:872                         
  inc/dbmysql.class.php:558                          DBmysqlIterator->__construct()
  inc/commondbtm.class.php:3780                      DBmysql->request()
  inc/mailcollector.class.php:497                    CommonDBTM->deleteByCriteria()
  inc/mailcollector.class.php:1618                   MailCollector->collect()
  :                                                  MailCollector::cronMailgate()
  inc/crontask.class.php:832                         call_user_func()
  front/cron.php:66                                  CronTask::launch()

2017-12-02 22:00:01 [@glpi-gs01]
  *** PHP Warning(2): Invalid argument supplied for foreach()
  Backtrace :
  inc/ticket.class.php:1633                         
  inc/commondbtm.class.php:815                       Ticket->prepareInputForAdd()
  inc/ticketrecurrent.class.php:481                  CommonDBTM->add()
  inc/ticketrecurrent.class.php:424                  TicketRecurrent::createTicket()
  :                                                  TicketRecurrent::cronTicketRecurrent()
  inc/crontask.class.php:832                         call_user_func()
  front/cron.php:88                                  CronTask::launch()

21:55:14 [64@glpi-gs01]
  *** MySQL query error:
  SQL: UPDATE `glpi_crontasks`
                SET `state` = \'1\'
                WHERE `id` = \'9\'
                      AND `state` = \'2\'
  Error: MySQL server has gone away
  Backtrace :
  inc/crontask.class.php:287                         
  inc/crontask.class.php:833                         CronTask->end()
  front/cron.php:66                                  CronTask::launch()

2017-12-02 21:55:14 [64@glpi-gs01]
  *** MySQL query error:
  SQL: SELECT RELEASE_LOCK(\'glpi.glpicron.80068\')
  Error: MySQL server has gone away
  Backtrace :
  inc/dbmysql.class.php:700                         
  inc/crontask.class.php:772                         DBmysql->releaseLock()
  inc/crontask.class.php:865                         CronTask::release_lock()
  front/cron.php:66                                  CronTask::launch()

Could you help me please?

ivan.ramirez

Member

From: España

Registered: 2017-12-02

Posts: 2

Re: mailqueue and ticketrecurrent freezed

Today I see that i have a problem on my mariadb database:

2017-12-03 06:10:03 [64@glpi-gs01]
  *** PHP Notice(8): Undefined index: users_id_recipient
  Backtrace :
  inc/ticket.class.php:2293
  inc/ticket.class.php:2270                          Ticket->canAddFollowups()
  inc/document.class.php:131                         Ticket->canAddItem()
  inc/commondbtm.class.php:2475                      Document->canCreateItem()
  inc/commondbtm.class.php:2566                      CommonDBTM->can()
  front/document.form.php:50                         CommonDBTM->check()

¿Could you help me? i am new in the database structure of glpi

Thank you

jpsbatista

Member

Registered: 2017-11-30

Posts: 8

Re: mailqueue and ticketrecurrent freezed

I have same problem on environment Windows Server with Xammp.