• Registered: 2009-05-04
  • Posts: 6

Topic: Centos4.6 x64 mysqld doesnt start

uname -a :
Linux cipsstandby 2.6.9-67.ELlargesmp #1 SMP Fri Nov 16 13:01:17 EST 2007 x86_64 x86_64 x86_64 GNU/Linux

I have upgraded mysql using :

yum --enablerepo=remi update mysql


rpm -qa | grep mysql :

mysql-devel-5.1.34-1.el4.remi
mysqlclient14-4.1.22-1.el4.remi
mod_auth_mysql-2.6.1-2.2
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
php-mysql-5.2.9-1.el4.remi
mysql-5.1.34-1.el4.remi
mysql-server-5.1.34-1.el4.remi
mysqlclient10-3.23.58-4.RHEL4.1
mysqlclient10-devel-3.23.58-4.RHEL4.1
freeradius-mysql-1.0.1-3.RHEL4.5
mysql-bench-5.1.34-1.el4.remi
mysql-libs-5.1.34-1.el4.remi
mysqlclient10-3.23.58-4.RHEL4.1


hereafter the error message I get when I do "service mysqld start"

090504 12:28:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090504 12:28:40 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 303 error messages,
but it should contain at least 630 error messages.
Check that the above file is the right version for this program!
/usr/libexec/mysqld: Unknown error 1146
090504 12:28:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090504 12:28:40  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090504 12:28:40  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090504 12:28:40  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090504 12:28:40  InnoDB: Started; log sequence number 0 0
090504 12:28:40 [ERROR] Aborting

090504 12:28:40  InnoDB: Starting shutdown...
090504 12:28:41  InnoDB: Shutdown completed; log sequence number 0 46409
090504 12:28:41 [Warning] Forcing shutdown of 1 plugins
090504 12:28:41 [Note]
090504 12:28:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Centos4.6 x64 mysqld doesnt start

Je pense que la migration depuis un vieux MySQL (en 4.6, c'est encore du 4.1.20 de mémoire) pose problème.

Est-ce qu'il y a des données ?

Il faudrait vider le répertoire /var/lib/mysql et relancer le service, cela va créer une base vierge.

Pour les données il faudrait mieux recharger un vidage logique (mysqldump).

+

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

Remi's Website

  • Registered: 2009-05-04
  • Posts: 6

Re: Centos4.6 x64 mysqld doesnt start

c'est ce que j'ai fait, je demarre avec /var/lib/mysql vide. la database initiale se cree mais l'erreur persiste.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Centos4.6 x64 mysqld doesnt start

Bon, je viens de refaire un essai sur une CentOS 4.7 à jour et je n'arrive pas à reproduire... sad

que retourne :

rpm --verify mysql mysql-libs mysql-server

(normalement rien...)

Bon, je cherche un peu de mon côté.
+

P.S. idée bête en passant, est-ce qu'il y a un fichier /etc/my.cnf.rpmnew (dans ce cas, c'est probablement l'ancienne conf de mysql 4.1 qui est utilisée, donc il faudrait mettre celle de mysql 5.1 à la place)

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

Remi's Website

  • Registered: 2009-05-04
  • Posts: 6

Re: Centos4.6 x64 mysqld doesnt start

rpm --verify mysql mysql-libs mysql-server :


warning: only V3 signatures can be verified, skipping V4 signature
warning: only V3 signatures can be verified, skipping V4 signature
S.5....T    /usr/bin/msql2mysql
S.5....T    /usr/bin/mysql_find_rows
S.5....T    /usr/bin/mysqlaccess
S.5....T  d /usr/share/info/mysql.info.gz
S.5....T  d /usr/share/man/man1/mysql.1.gz
S.5....T  d /usr/share/man/man1/mysqlaccess.1.gz
S.5....T  d /usr/share/man/man1/mysqladmin.1.gz
S.5....T  d /usr/share/man/man1/mysqldump.1.gz
S.5....T  d /usr/share/man/man1/mysqlshow.1.gz
S.5....T    /usr/share/mysql/charsets/Index.xml
S.5....T    /usr/share/mysql/charsets/README
S.5....T    /usr/share/mysql/charsets/armscii8.xml
S.5....T    /usr/share/mysql/charsets/ascii.xml
S.5....T    /usr/share/mysql/charsets/cp1250.xml
S.5....T    /usr/share/mysql/charsets/cp1251.xml
S.5....T    /usr/share/mysql/charsets/cp1256.xml
S.5....T    /usr/share/mysql/charsets/cp1257.xml
S.5....T    /usr/share/mysql/charsets/cp850.xml
S.5....T    /usr/share/mysql/charsets/cp852.xml
S.5....T    /usr/share/mysql/charsets/cp866.xml
S.5....T    /usr/share/mysql/charsets/dec8.xml
S.5....T    /usr/share/mysql/charsets/geostd8.xml
S.5....T    /usr/share/mysql/charsets/greek.xml
S.5....T    /usr/share/mysql/charsets/hebrew.xml
S.5....T    /usr/share/mysql/charsets/hp8.xml
S.5....T    /usr/share/mysql/charsets/keybcs2.xml
S.5....T    /usr/share/mysql/charsets/koi8r.xml
S.5....T    /usr/share/mysql/charsets/koi8u.xml
S.5....T    /usr/share/mysql/charsets/latin1.xml
S.5....T    /usr/share/mysql/charsets/latin2.xml
S.5....T    /usr/share/mysql/charsets/latin5.xml
S.5....T    /usr/share/mysql/charsets/latin7.xml
S.5....T    /usr/share/mysql/charsets/macce.xml
S.5....T    /usr/share/mysql/charsets/macroman.xml
S.5....T    /usr/share/mysql/charsets/swe7.xml
S.5....T    /usr/share/mysql/czech/errmsg.sys
S.5....T    /usr/share/mysql/danish/errmsg.sys
S.5....T    /usr/share/mysql/dutch/errmsg.sys
S.5....T    /usr/share/mysql/english/errmsg.sys
S.5....T    /usr/share/mysql/estonian/errmsg.sys
S.5....T    /usr/share/mysql/french/errmsg.sys
S.5....T    /usr/share/mysql/german/errmsg.sys
S.5....T    /usr/share/mysql/greek/errmsg.sys
S.5....T    /usr/share/mysql/hungarian/errmsg.sys
S.5....T    /usr/share/mysql/italian/errmsg.sys
S.5....T    /usr/share/mysql/japanese/errmsg.sys
S.5....T    /usr/share/mysql/korean/errmsg.sys
S.5....T    /usr/share/mysql/norwegian-ny/errmsg.sys
S.5....T    /usr/share/mysql/norwegian/errmsg.sys
S.5....T    /usr/share/mysql/polish/errmsg.sys
S.5....T    /usr/share/mysql/portuguese/errmsg.sys
S.5....T    /usr/share/mysql/romanian/errmsg.sys
S.5....T    /usr/share/mysql/russian/errmsg.sys
S.5....T    /usr/share/mysql/serbian/errmsg.sys
S.5....T    /usr/share/mysql/slovak/errmsg.sys
S.5....T    /usr/share/mysql/spanish/errmsg.sys
S.5....T    /usr/share/mysql/swedish/errmsg.sys
S.5....T    /usr/share/mysql/ukrainian/errmsg.sys
warning: only V3 signatures can be verified, skipping V4 signature
  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Centos4.6 x64 mysqld doesnt start

Ben visiblement l'installation c'est mal passée...

Pas d'explication sur la raison (espace disque ??) mais le plus simple serait de désinstaller les paquets et de les réinstaller et de vérifier ensuite que le "verify" est ok.

+

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

Remi's Website

  • Registered: 2009-05-04
  • Posts: 6

Re: Centos4.6 x64 mysqld doesnt start

merci du conseil. je vais faire la manip

  • Registered: 2009-05-04
  • Posts: 6

Re: Centos4.6 x64 mysqld doesnt start

j'ai desinstalle tout les rpm mysql puis j'ai re-installe avec yum
mysql, mysql-server. le verify donne tjrs la meme erreur.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Centos4.6 x64 mysqld doesnt start

Bon, par acquis de conscience, je viens de refaire un test complet
- installation CentOS 4.7 en x86_64 (minimum)
- configuration réseau
- configuration epel + remi
- installation MySQL 5.1.34
- lancement mysqld
- connexion à la base
=> aucun problème.

Donc, je vois vraiment pas d'où cela peut venir.
Tant que le "verify" ne sera pas correct, c'est que les fichiers installés ne sont pas conforme et donc ça peut pas trop marcher normalement.

Désolé...

P.S. il n'y aurait pas un processus de surveillance, genre Antivirus, qui tournerait sur cette machine ?

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

Remi's Website

  • Registered: 2009-05-04
  • Posts: 6

Re: Centos4.6 x64 mysqld doesnt start

j'ai force la desinstall de mysql-libs puis yum install ... et cela fonctionne.

j'avoue de pas avoir d'explication. merci de ton aide.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Centos4.6 x64 mysqld doesnt start

Super,
Le principal, c'est que maintenant cela fonctionne.

+

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

Remi's Website