Forum GLPI-Project

spea

Member

Registered: 2012-12-17

Posts: 52

GLPI90 monitoring & MySQL query error

Hi,

a lot of log entries in "files/_log/sql-errors.log"

*** MySQL query error:
  SQL: INSERT
                   INTO `glpi_plugin_monitoring_unavailabilitystates` (`plugin_monitoring_services_id`) VALUES (\'200\')
  Error: Duplicate entry '0' for key 'PRIMARY'
  Backtrace :
  inc/commondbtm.class.php:425
  inc/commondbtm.class.php:831                       CommonDBTM->addToDB()
  ...monitoring/inc/unavailabilitystate.class.php:78 CommonDBTM->add()
  ...ins/monitoring/inc/unavailability.class.php:274 PluginMonitoringUnavailabilityState->getLastID()
  ...ins/monitoring/inc/unavailability.class.php:244 PluginMonitoringUnavailability::runUnavailability()
  :                                                  PluginMonitoringUnavailability::cronUnavailability()
  inc/crontask.class.php:799                         call_user_func()
  front/cron.php:88                                  CronTask::launch()

 
# GLPI Version: 0.90/bugfixes
   
accounts             Name: Accounts                       Version: 2.1.1      State: Enabled
fields               Name: Additionnal fields             Version: 0.90-1.1   State: Enabled
badges               Name: Badges                         Version: 2.1.1      State: Enabled
connections          Name: Connections                    Version: 0.90-1.7.3 State: Enabled
dashboard            Name: Dashboard                      Version: 0.6.9      State: Not installed
databases            Name: Databases                      Version: 1.8.1      State: Enabled
domains              Name: Domains                        Version: 1.7.0      State: Enabled
environment          Name: Environment                    Version: 1.9.0      State: Enabled
datainjection        Name: File injection                 Version: 2.4.1      State: Enabled
fusioninventory      Name: FusionInventory                Version: 0.90+1.0+TECLIB_16 State: Enabled
itilcategorygroups   Name: ItilCategory Groups            Version: 0.90+1.0.2 State: Enabled
monitoring           Name: Monitoring                     Version: 0.85+1.3   State: Enabled
moreticket           Name: More ticket                    Version: 1.2.2      State: Enabled
moreldap             Name: MoreLDAP                       Version: 0.2.1      State: Enabled
genericobject        Name: Objects management             Version: 0.85-1.0   State: Enabled
order                Name: Orders management              Version: 0.85+1.1   State: Enabled
example              Name: Plugin Example                 Version: 7.0        State: Not activated
purgelogs            Name: Purge history                  Version: 0.85+1.1   State: Enabled
racks                Name: Rack Gehäuse Verwaltung        Version: 1.6.1      State: Enabled
shellcommands        Name: Shell Commands                 Version: 1.9.1      State: Enabled
simcard              Name: Sim cards management           Version: 1.4.1      State: Enabled
manufacturersimports Name: Suppliers imports              Version: 1.8.0      State: Enabled
tag                  Name: Tag Management                 Version: 0.90-1.0   State: Not activated
behaviors            Name: Verhalten                      Version: 0.90       State: Enabled
webapplications      Name: Web applications               Version: 2.1.1      State: Enabled
webservices          Name: Webdienste                     Version: 1.6.0      State: Enabled
certificates         Name: Zertifikate                    Version: 2.1.1      State: Enabled

Operating system: Linux ltdev203 3.19.0-25-generic #26~14.04.1-Ubuntu SMP Fri Jul 24 21:16:20 UTC 2015 x86_64
PHP 5.5.9-1ubuntu4.14 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, bcmath, bz2,
    calendar, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap,
    libxml, mbstring, mhash, mysql, mysqli, openssl, pcre, pdo_mysql, posix, readline, session, shmop, snmp, soap, sockets,
    standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
    upload_max_filesize="10M"
Software: Apache/2.4.7 (Ubuntu) (Apache/2.4.7 (Ubuntu) Server at inventory Port 443)
    Mozilla/5.0 (Windows NT 10.0; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0
Server Software: (Ubuntu)
    Server Version: 5.5.46-0ubuntu0.14.04.2
    Server SQL Mode:
    Parameters: itservice@127.0.0.1:3306/itservice
    Host info: 127.0.0.1 via TCP/IP

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: GLPI90 monitoring & MySQL query error

hi,
can you check with phpmyadmin if
glpi_plugin_monitoring_unavailabilitystates.id  type is AUTOINCREMENT

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

spea

Member

Registered: 2012-12-17

Posts: 52

Re: GLPI90 monitoring & MySQL query error

Hi,

here is the output

mysql> desc glpi_plugin_monitoring_unavailabilitystates;
+------------------------------------+---------+------+-----+---------+-------+
| Field                              | Type    | Null | Key | Default | Extra |
+------------------------------------+---------+------+-----+---------+-------+
| id                                 | int(11) | NO   | PRI | 0       |       |
| plugin_monitoring_services_id      | int(11) | NO   | MUL | 0       |       |
| plugin_monitoring_serviceevents_id | int(11) | NO   |     | 0       |       |
+------------------------------------+---------+------+-----+---------+-------+

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: GLPI90 monitoring & MySQL query error

I guess EXTRA value for id should be AUTO_INCREMENT
you have to alter table

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

spea

Member

Registered: 2012-12-17

Posts: 52

Re: GLPI90 monitoring & MySQL query error

Hi,

It's really works. Thanks for your answer!

mysql> ALTER TABLE glpi_plugin_monitoring_unavailabilitystates ADD INDEX `id` (id), MODIFY id int auto_increment;
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> desc glpi_plugin_monitoring_unavailabilitystates;
+------------------------------------+---------+------+-----+---------+----------------+
| Field                              | Type    | Null | Key | Default | Extra          |
+------------------------------------+---------+------+-----+---------+----------------+
| id                                 | int(11) | NO   | PRI | NULL    | auto_increment |
| plugin_monitoring_services_id      | int(11) | NO   | MUL | 0       |                |
| plugin_monitoring_serviceevents_id | int(11) | NO   |     | 0       |                |
+------------------------------------+---------+------+-----+---------+----------------+
3 rows in set (0.00 sec)