Помогите с запуском mysql после обновления

fairbug · 14 Мар 2015

Всем доброго, такая ситуёвина:
надо было обновить мускул с 5.1.* сделал:
# yum remove MySQL mysql-*
# yum install mysql-server
вроде всё без косяков обновилось выдало

Код:

Install       1 Package(s)
Upgrade      13 Package(s)

Total download size: 29 M
Is this ok [y/N]: y
Downloading Packages:
(1/14): mysql-5.5.42-28.el6.art.i686.rpm                 | 5.8 MB     01:11
(2/14): mysql-libs-5.5.42-28.el6.art.i686.rpm            | 760 kB     00:08
(3/14): mysql-server-5.5.42-28.el6.art.i686.rpm          |  10 MB     02:06
(4/14): mysqlclient16-5.1.59-2.el6.art.i686.rpm          | 1.4 MB     00:17
(5/14): php-5.4.38-44.el6.art.i686.rpm                   | 2.7 MB     00:07
(6/14): php-cli-5.4.38-44.el6.art.i686.rpm               | 2.7 MB     00:29
(7/14): php-common-5.4.38-44.el6.art.i686.rpm            | 940 kB     00:07
(8/14): php-devel-5.4.38-44.el6.art.i686.rpm             | 2.6 MB     00:08
(9/14): php-gd-5.4.38-44.el6.art.i686.rpm                | 141 kB     00:00
(10/14): php-mbstring-5.4.38-44.el6.art.i686.rpm         | 940 kB     00:01
(11/14): php-mcrypt-5.4.38-44.el6.art.i686.rpm           |  50 kB     00:00
(12/14): php-mysql-5.4.38-44.el6.art.i686.rpm            | 130 kB     00:00
(13/14): php-pdo-5.4.38-44.el6.art.i686.rpm              | 116 kB     00:00
(14/14): php-xml-5.4.38-44.el6.art.i686.rpm              | 166 kB     00:00
--------------------------------------------------------------------------------
Total                                           102 kB/s |  29 MB     04:46
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : php-common-5.4.38-44.el6.art.i686                           1/27
  Updating   : php-cli-5.4.38-44.el6.art.i686                              2/27
  Updating   : mysql-libs-5.5.42-28.el6.art.i686                           3/27
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
  Updating   : php-pdo-5.4.38-44.el6.art.i686                              4/27
  Updating   : mysql-5.5.42-28.el6.art.i686                                5/27
  Installing : mysqlclient16-5.1.59-2.el6.art.i686                         6/27
  Updating   : php-mysql-5.4.38-44.el6.art.i686                            7/27
  Updating   : php-devel-5.4.38-44.el6.art.i686                            8/27
  Updating   : php-5.4.38-44.el6.art.i686                                  9/27
  Updating   : php-mcrypt-5.4.38-44.el6.art.i686                          10/27
  Updating   : php-gd-5.4.38-44.el6.art.i686                              11/27
  Updating   : php-mbstring-5.4.38-44.el6.art.i686                        12/27
  Updating   : php-xml-5.4.38-44.el6.art.i686                             13/27
  Updating   : mysql-server-5.5.42-28.el6.art.i686                        14/27
  Cleanup    : mysql-server-5.1.73-3.el6_5.i686                           15/27
  Cleanup    : php-5.4.37-43.el6.art.i686                                 16/27
  Cleanup    : php-mysql-5.4.37-43.el6.art.i686                           17/27
  Cleanup    : php-pdo-5.4.37-43.el6.art.i686                             18/27
  Cleanup    : mysql-5.1.73-3.el6_5.i686                                  19/27
  Cleanup    : php-xml-5.4.37-43.el6.art.i686                             20/27
  Cleanup    : php-devel-5.4.37-43.el6.art.i686                           21/27
  Cleanup    : php-cli-5.4.37-43.el6.art.i686                             22/27
  Cleanup    : php-mbstring-5.4.37-43.el6.art.i686                        23/27
  Cleanup    : php-gd-5.4.37-43.el6.art.i686                              24/27
  Cleanup    : php-mcrypt-5.4.37-43.el6.art.i686                          25/27
  Cleanup    : php-common-5.4.37-43.el6.art.i686                          26/27
  Cleanup    : mysql-libs-5.1.73-3.el6_5.i686                             27/27
  Verifying  : php-mcrypt-5.4.38-44.el6.art.i686                           1/27
  Verifying  : php-gd-5.4.38-44.el6.art.i686                               2/27
  Verifying  : php-mysql-5.4.38-44.el6.art.i686                            3/27
  Verifying  : php-common-5.4.38-44.el6.art.i686                           4/27
  Verifying  : php-cli-5.4.38-44.el6.art.i686                              5/27
  Verifying  : php-pdo-5.4.38-44.el6.art.i686                              6/27
  Verifying  : mysql-libs-5.5.42-28.el6.art.i686                           7/27
  Verifying  : php-mbstring-5.4.38-44.el6.art.i686                         8/27
  Verifying  : php-devel-5.4.38-44.el6.art.i686                            9/27
  Verifying  : php-5.4.38-44.el6.art.i686                                 10/27
  Verifying  : mysqlclient16-5.1.59-2.el6.art.i686                        11/27
  Verifying  : php-xml-5.4.38-44.el6.art.i686                             12/27
  Verifying  : mysql-server-5.5.42-28.el6.art.i686                        13/27
  Verifying  : mysql-5.5.42-28.el6.art.i686                               14/27
  Verifying  : php-mbstring-5.4.37-43.el6.art.i686                        15/27
  Verifying  : php-common-5.4.37-43.el6.art.i686                          16/27
  Verifying  : mysql-libs-5.1.73-3.el6_5.i686                             17/27
  Verifying  : php-xml-5.4.37-43.el6.art.i686                             18/27
  Verifying  : php-cli-5.4.37-43.el6.art.i686                             19/27
  Verifying  : mysql-server-5.1.73-3.el6_5.i686                           20/27
  Verifying  : php-pdo-5.4.37-43.el6.art.i686                             21/27
  Verifying  : php-mcrypt-5.4.37-43.el6.art.i686                          22/27
  Verifying  : php-mysql-5.4.37-43.el6.art.i686                           23/27
  Verifying  : php-devel-5.4.37-43.el6.art.i686                           24/27
  Verifying  : php-gd-5.4.37-43.el6.art.i686                              25/27
  Verifying  : php-5.4.37-43.el6.art.i686                                 26/27
  Verifying  : mysql-5.1.73-3.el6_5.i686                                  27/27

Dependency Installed:
  mysqlclient16.i686 0:5.1.59-2.el6.art

Updated:
  mysql-server.i686 0:5.5.42-28.el6.art

Dependency Updated:
  mysql.i686 0:5.5.42-28.el6.art        mysql-libs.i686 0:5.5.42-28.el6.art
  php.i686 0:5.4.38-44.el6.art          php-cli.i686 0:5.4.38-44.el6.art
  php-common.i686 0:5.4.38-44.el6.art   php-devel.i686 0:5.4.38-44.el6.art
  php-gd.i686 0:5.4.38-44.el6.art       php-mbstring.i686 0:5.4.38-44.el6.art
  php-mcrypt.i686 0:5.4.38-44.el6.art   php-mysql.i686 0:5.4.38-44.el6.art
  php-pdo.i686 0:5.4.38-44.el6.art      php-xml.i686 0:5.4.38-44.el6.art

Complete!

далее

# service mysqld start
но нифига, выдаёт
# /etc/init.d/mysqld start
MySQL Daemon failed to start.
Запускается mysqld: [СБОЙ ]

Код:

150314 20:57:45 [ERROR] /usr/libexec/mysqld: unknown option '--skip-locking'
150314 20:57:45 [ERROR] Aborting

150314 20:57:45  InnoDB: Starting shutdown...
150314 20:57:46  InnoDB: Shutdown completed; log sequence number 32532740883
150314 20:57:46 [Note] /usr/libexec/mysqld: Shutdown complete

150314 20:57:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150314 21:19:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150314 21:19:58 [Note] libgovernor.so not found
150314 21:19:58 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
150314 21:19:58 [Note] Plugin 'FEDERATED' is disabled.
150314 21:19:58 InnoDB: The InnoDB memory heap is disabled
150314 21:19:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150314 21:19:58 InnoDB: Compressed tables use zlib 1.2.3
150314 21:19:58 InnoDB: Using Linux native AIO
150314 21:19:58 InnoDB: Initializing buffer pool, size = 128.0M
150314 21:19:58 InnoDB: Completed initialization of buffer pool
150314 21:19:58 InnoDB: highest supported file format is Barracuda.
150314 21:19:58  InnoDB: Waiting for the background threads to start
150314 21:19:59 InnoDB: 5.5.42 started; log sequence number 32532740883
150314 21:19:59 [ERROR] /usr/libexec/mysqld: unknown option '--skip-locking'
150314 21:19:59 [ERROR] Aborting

150314 21:19:59  InnoDB: Starting shutdown...
150314 21:20:00  InnoDB: Shutdown completed; log sequence number 32532740883
150314 21:20:00 [Note] /usr/libexec/mysqld: Shutdown complete

150314 21:20:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150314 21:21:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150314 21:21:46 [Note] libgovernor.so not found
150314 21:21:46 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
150314 21:21:46 [Note] Plugin 'FEDERATED' is disabled.
150314 21:21:46 InnoDB: The InnoDB memory heap is disabled
150314 21:21:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150314 21:21:46 InnoDB: Compressed tables use zlib 1.2.3
150314 21:21:46 InnoDB: Using Linux native AIO
150314 21:21:46 InnoDB: Initializing buffer pool, size = 128.0M
150314 21:21:46 InnoDB: Completed initialization of buffer pool
150314 21:21:46 InnoDB: highest supported file format is Barracuda.
150314 21:21:47  InnoDB: Waiting for the background threads to start
150314 21:21:48 InnoDB: 5.5.42 started; log sequence number 32532740883
150314 21:21:48 [ERROR] /usr/libexec/mysqld: unknown option '--skip-locking'
150314 21:21:48 [ERROR] Aborting

150314 21:21:48  InnoDB: Starting shutdown...
150314 21:21:48  InnoDB: Shutdown completed; log sequence number 32532740883
150314 21:21:48 [Note] /usr/libexec/mysqld: Shutdown complete

150314 21:21:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

по errorу чёт нормального ничего нагуглить не могу, может кто сталкивался, подскажите?

fairbug · 14 Мар 2015

всё, сам решил...
my.cnf
закомментировать строку
skip-locking
с 5.5 скула убрали функцию

fairbug · 14 Мар 2015

теперь новая возня, всё вроде работает но не даёт покоя сообщение:
Версия клиентской библиотеки MySQL (5.1.73) отличается от версии установленного MySQL-сервера (5.5.42). Это может привести к некорректной работе.
как эти библиотеки обновить?

efs · 15 Мар 2015

а почему не пользоваться yum update?

Помогите с запуском mysql после обновления

fairbug

Гуру форума

fairbug

Гуру форума

fairbug

Гуру форума

efs

SEO оптимизатор дискрипторов одностраничных сайтов