Topic: Probleme Mysql et CEntos

Bonsoir,

Je viens demander conseil pour un souci sur mon serveur !

Je tourne sous CentOS release 5.7 (Final) et Mysql 5.5.14-1.el5.remi

Sur cette base, rien de bien particulier. Juste une base de données pour un Wordpress (à jour).

Depuis plusieurs temps, Mysql se stoppe.
Sans action de ma part.

Voici le log tout frais de cette nuit :

(...)120103 19:00:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.14'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
120104 00:23:57 mysqld_safe Number of processes running now: 0
120104 00:23:57 mysqld_safe mysqld restarted
120104  0:24:00 [Note] Plugin 'FEDERATED' is disabled.
120104  0:24:00 InnoDB: The InnoDB memory heap is disabled
120104  0:24:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120104  0:24:00 InnoDB: Compressed tables use zlib 1.2.3
120104  0:24:00 InnoDB: Using Linux native AIO
120104  0:24:00 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
120104  0:24:00 InnoDB: Completed initialization of buffer pool
120104  0:24:00 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120104  0:24:00 [ERROR] Plugin 'InnoDB' init function returned error.
120104  0:24:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120104  0:24:00 [ERROR] Unknown/unsupported storage engine: InnoDB
120104  0:24:00 [ERROR] Aborting

120104  0:24:01 [Note] /usr/libexec/mysqld: Shutdown complete

120104 00:24:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120104 18:56:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
(...)

Pouvez-vous m'aider ?

Merci.

Re: Probleme Mysql et CEntos

Désolé de reposter si vite.

J'ai vu en parcourant le net que cela pourrait être du a ib_logfile0 et 1.
Leur taille est de 5Mo a cet instant :

[root@serveurmysql]# ls -lh ib*
-rw-rw---- 1 mysql mysql  18M jan  4 19:05 ibdata1
-rw-rw---- 1 mysql mysql 5,0M jan  4 19:05 ib_logfile0
-rw-rw---- 1 mysql mysql 5,0M jan  4 19:05 ib_logfile1

Est-ce que cette taille peut jouer sur les soucis actuels ?

Re: Probleme Mysql et CEntos

Je ne vois pas d'explication...

Qu'est ce qui se passe à 0h24 et qui expliquerait une relance du service ?
personnellement je ne le relance que lors des mise à jour.

Une mise à jour vers la dernière version (5.5.19) permettrait de bénéficier des dernières corrections de bug (peut-être un bug concernant ce soucis).

Est-ce que le mysql_upgrade a été passé ?

Quelle est la configuration du serveur (/etc/my.cnf) et de la machine (mémoire, ...) ?

Laptop:  Fedora 40 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: AlmaLinux 8 with EPEL, rpmfusion, remi

Re: Probleme Mysql et CEntos

Voilà le souci, il ne ce passe rien... enfin rien venant de moi du moins :s

mysql-upgrade effectuée !

Voici les infos que tu demandes :

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Semisynchronous Replication

# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so

# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1


;performance_schema

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Pour la machine, est-ce que tu souhaites ?:

[root@serveur~]# ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 7928
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 7928
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

Sinon, la machine dispose de :

[root@serveur~]# free -m
             total       used       free     shared    buffers     cached
Mem:           956        843        113          0         15        101
-/+ buffers/cache:        726        230
Swap:          509        225        284

Et puis interessant, que je lance l'update :

[root@serveuryum.repos.d]# yum update mysql* --enablerepo=remi
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
 * atrpms-stable: mirrors.ircam.fr
 * epel: mirrors.ircam.fr
 * remi: rpms.famillecollet.com
remi                                                     | 2.5 kB     00:00
remi/primary_db                                          | 265 kB     00:00
Excluding Packages in global exclude list
Finished
Reducing CentOS-5 - Plus to included packages only
Finished
931 packages excluded due to repository priority protections
Setting up Update Process
Resolving Dependencies
--> Running transaction check
--> Processing Dependency: mysql-libs = 5.5.14-1.el5.remi for package: mysql-server
--> Processing Dependency: mysql-libs = 5.5.14-1.el5.remi for package: mysql
---> Package mysql-libs.x86_64 0:5.5.19-1.el5.remi set to be updated
--> Finished Dependency Resolution
mysql-5.5.14-1.el5.remi.x86_64 from installed has depsolving problems
  --> Missing Dependency: mysql-libs = 5.5.14-1.el5.remi is needed by package mysql-5.5.14-1.el5.remi.x86_64 (installed)
mysql-server-5.5.14-1.el5.remi.x86_64 from installed has depsolving problems
  --> Missing Dependency: mysql-libs = 5.5.14-1.el5.remi is needed by package mysql-server-5.5.14-1.el5.remi.x86_64 (installed)
Error: Missing Dependency: mysql-libs = 5.5.14-1.el5.remi is needed by package mysql-5.5.14-1.el5.remi.x86_64 (installed)
Error: Missing Dependency: mysql-libs = 5.5.14-1.el5.remi is needed by package mysql-server-5.5.14-1.el5.remi.x86_64 (installed)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest

Merci pour ton aide !

Re: Probleme Mysql et CEntos

> 931 packages excluded due to repository priority protections

Donc essaie sans plugin (option --noplugins)

Laptop:  Fedora 40 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: AlmaLinux 8 with EPEL, rpmfusion, remi

Re: Probleme Mysql et CEntos

Effectivement, si j’oublie ça...

C'est mis à jour.

Je te tiens au courant si jamais cela recommence...
En tout cas, il reste un mystère :

Que peut-il bien se passer à 00h24....

Merci wink

Re: Probleme Mysql et CEntos

Salut,

Bon me revoilà...
Et pour le même souci !

C'est à ni rien comprendre..

120105 20:41:53 [Note] Event Scheduler: Loaded 0 events
120105 20:41:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.19'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
120112 13:39:14 mysqld_safe Number of processes running now: 0
120112 13:39:14 mysqld_safe mysqld restarted
120112 13:39:17 [Note] Plugin 'FEDERATED' is disabled.
120112 13:39:17 InnoDB: The InnoDB memory heap is disabled
120112 13:39:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120112 13:39:17 InnoDB: Compressed tables use zlib 1.2.3
120112 13:39:17 InnoDB: Using Linux native AIO
120112 13:39:18 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
120112 13:39:18 InnoDB: Completed initialization of buffer pool
120112 13:39:18 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120112 13:39:18 [ERROR] Plugin 'InnoDB' init function returned error.
120112 13:39:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120112 13:39:18 [ERROR] Unknown/unsupported storage engine: InnoDB
120112 13:39:18 [ERROR] Aborting

120112 13:39:18 [Note] /usr/libexec/mysqld: Shutdown complete

120112 13:39:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

De toutes façons, c'est InnoDB qui pose pb...