• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[SOLVED] Fusioninventory plugin disable database
#1
Hello,

I have one issue. When I activate fusioninventory plugin for glpi (Glpi 9.4 - fusioninventory plugin - 2.4 for glpi 9.4 - mariadb 10.4) then my database instance are corrupt.  When disable plugin then GLPI work ok, mariadb work ok.

In log file i have this:

Code:
Working directory at /var/lib/mysql
Resource Limits:
Limit                     Soft Limit           Hard Limit           Units
Max cpu time              unlimited            unlimited            seconds
Max file size             unlimited            unlimited            bytes
Max data size             unlimited            unlimited            bytes
Max stack size            8388608              unlimited            bytes
Max core file size        unlimited            unlimited            bytes
Max resident set          unlimited            unlimited            bytes
Max processes             38710                38710                processes
Max open files            32186                32186                files
Max locked memory         65536                65536                bytes
Max address space         unlimited            unlimited            bytes
Max file locks            unlimited            unlimited            locks
Max pending signals       38710                38710                signals
Max msgqueue size         819200               819200               bytes
Max nice priority         0                    0
Max realtime priority     0                    0
Max realtime timeout      unlimited            unlimited            us
2020-10-26 19:34:28 0 [Note] InnoDB: Using Linux native AIO
2020-10-26 19:34:28 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-26 19:34:28 0 [Note] InnoDB: Uses event mutexes
2020-10-26 19:34:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-26 19:34:28 0 [Note] InnoDB: Number of pools: 1
2020-10-26 19:34:28 0 [Note] InnoDB: Using generic crc32 instructions
2020-10-26 19:34:28 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2020-10-26 19:34:28 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-26 19:34:28 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-26 19:34:28 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-26 19:34:28 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=102805136021
2020-10-26 19:34:28 0 [ERROR] InnoDB: Missing MLOG_FILE_NAME or MLOG_FILE_DELETE before MLOG_CHECKPOINT for tablespace 412
2020-10-26 19:34:28 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2020-10-26 19:34:28 0 [Note] InnoDB: Starting shutdown...
2020-10-26 19:34:29 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-10-26 19:34:29 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-10-26 19:34:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-10-26 19:34:29 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-10-26 19:34:29 0 [ERROR] Aborting

MariaDB status:

Code:
service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB 10.4 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Mon 2020-10-26 19:34:29 CET; 1min 33s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 96372 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
    Process: 96398 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
    Process: 96433 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
   Main PID: 96433 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 576ms

Oct 26 19:34:27 helpdesk systemd[1]: Starting MariaDB 10.4 database server...
Oct 26 19:34:27 helpdesk mysql-check-socket[96372]: Socket file /var/lib/mysql/mysql.sock exists.
Oct 26 19:34:27 helpdesk mysql-check-socket[96372]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically.
Oct 26 19:34:28 helpdesk mysql-prepare-db-dir[96398]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Oct 26 19:34:28 helpdesk mysql-prepare-db-dir[96398]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.
Oct 26 19:34:28 helpdesk mysqld[96433]: 2020-10-26 19:34:28 0 [Note] /usr/libexec/mysqld (mysqld 10.4.14-MariaDB) starting as process 96433 ...
Oct 26 19:34:29 helpdesk systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 26 19:34:29 helpdesk systemd[1]: mariadb.service: Failed with result 'exit-code'.
Oct 26 19:34:29 helpdesk systemd[1]: Failed to start MariaDB 10.4 database server.

I've noticed that after activating the plugin, the database memory usage keeps increasing

Code:
2020-11-15 17:18:55 0 [ERROR] InnoDB: Space id and page no stored in the page, read in are [page id: space=412, page number=632648], should be [page id: space=593, page number=330]
2020-11-15 17:19:01 0 [ERROR] InnoDB: N heap is wrong 1050, 592
  Reply
#2
Hello,

i found where the problem was. I noticed in the logs, that few tables are have invalid indexes.

1. I TRUNCATE this tables.
2. Create backup of mariadb.
4. Reinstall mariadb.
5. Restore databases.
5. Install plugin fusioninventory.

Everything work fine. :-)
  Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)