Forum GLPI-Project

anyqov

Member

Registered: 2019-04-29

Posts: 21

Mail reception errors GLPI 9.4.2

Hello.
For earlier apologize for my English.

I see a problem in versions 9.4.0-9.4.2. Receive mail freezes. Mailgate has been in "Running" mode for an infinitely long time. After stopping the hung process, it automatically runs and does it successfully. After a while, it freezes again (a few hours). In the cron.log writes: "Unable to lock database".

Run mode mailgate: CLI
Run mode queuednotification: CLI

What could be the problem?

$ sudo crontab -e:

PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin
*/1 * * * * /usr/bin/php /var/www/glpi/front/cron.php &>/dev/null

/var/www/glpi/files/_log/cron.log:

2019-04-29 20:11:01
External #1: Launch mailgate
2019-04-29 20:12:01
External #1: There is nothing to run
2019-04-29 20:13:01
External #1: There is nothing to run
2019-04-29 20:14:01
External #1: Launch queuednotification
2019-04-29 20:15:01
External #1: There is nothing to run
2019-04-29 20:16:01
External #1: Launch mailgate
2019-04-29 20:17:01
Unable to lock database
2019-04-29 20:18:01
Unable to lock database
2019-04-29 20:19:02
Unable to lock database
2019-04-29 20:20:01
Unable to lock database
2019-04-29 20:21:01
Unable to lock database
...
2019-04-29 20:58:01
Unable to lock database
2019-04-29 20:59:01
Unable to lock database
2019-04-29 21:00:01
External #1: Launch queuednotification
2019-04-29 21:00:01
External #2: Launch mailgateerror
2019-04-29 21:01:02
External #1: There is nothing to run
2019-04-29 21:02:01
External #1: There is nothing to run
2019-04-29 21:03:01
External #1: There is nothing to run
2019-04-29 21:04:01
External #1: There is nothing to run
2019-04-29 21:05:02
External #1: Launch queuednotification
2019-04-29 21:06:01
External #1: There is nothing to run

Information about system installation and configuration

GLPI 9.4.2 ( => /var/www/glpi)
Installation mode: TARBALL

Server

Operating system: Linux glpi-smarts 3.10.0-957.10.1.el7.x86_64 #1 SMP Tue Mar 12 16:11:28 CDT 2019 x86_64
PHP 7.3.4 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apcu, bz2, calendar, ctype,
    curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, json, ldap, libxml, mbstring, mysqli, mysqlnd,
    openssl, pcre, pdo_mysql, pdo_sqlite, session, sockets, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter,
    xsl, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="256M" safe_mode="" session.save_handler="files"
    upload_max_filesize="256M"
Software: Apache/2.4.6 (Scientific Linux) OpenSSL/1.0.2k-fips PHP/7.3.4 ()
    Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36
Server Software: MariaDB Server
    Server Version: 10.3.14-MariaDB
    Server SQL Mode:
    Parameters: glpi@localhost/glpi
    Host info: Localhost via UNIX socket

olivosistemas

Member

Registered: 2019-05-17

Posts: 10

Re: Mail reception errors GLPI 9.4.2

lograste solucionarlo?, tengo el mismo problema como lograste solucionarlo

Last edited by olivosistemas (2019-05-17 18:24:29)

lotze1234

Member

Registered: 2019-05-21

Posts: 5

Re: Mail reception errors GLPI 9.4.2

Hi yes got the same problem.

it works for ca. 24 hours. than it hold on. "Running...."

Any idea?

Regards

lotze1234

Member

Registered: 2019-05-21

Posts: 5

Re: Mail reception errors GLPI 9.4.2

Hi again, just report that i found my solution for that.

I change the interval to 15 min in GLPI and setup the cron job to 5 min.

This works now fine without problems. The problem is that sometimes the database locking is still running, sometime the unlock take longer than 5min.

Regards

lotze1234

Member

Registered: 2019-05-21

Posts: 5

Re: Mail reception errors GLPI 9.4.2

Just new info from my site! After 7 days ... same again.

danidosreis

Member

Registered: 2019-12-11

Posts: 2

Re: Mail reception errors GLPI 9.4.2

I have the same problem with version 9.1. Several times a day cron mailgate crashes in running status. Has anyone had this same problem? I don't know what it can be.

PotterSpellman

Member

Registered: 2020-05-30

Posts: 1

Re: Mail reception errors GLPI 9.4.2

Hi there. I have the same problem.
I could identified that this happens when a mail in the inbox has a file attachment or a inline image, but it doesn't reports any error on error log.
Any ideas?

My version is 9.4.4

Last edited by PotterSpellman (2020-05-30 19:11:42)