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

Тема в разделе "Администрирование серверов", создана пользователем fairbug, 14 мар 2015.

Модераторы: mefish, stooper
  1. fairbug

    fairbug

    Регистр.:
    1 май 2013
    Сообщения:
    190
    Симпатии:
    67
    Всем доброго, такая ситуёвина:
    надо было обновить мускул с 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у чёт нормального ничего нагуглить не могу, может кто сталкивался, подскажите?
     
  2. fairbug

    fairbug

    Регистр.:
    1 май 2013
    Сообщения:
    190
    Симпатии:
    67
    всё, сам решил...
    my.cnf
    закомментировать строку
    skip-locking
    с 5.5 скула убрали функцию
     
  3. fairbug

    fairbug

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

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

    Moderator
    Регистр.:
    20 ноя 2009
    Сообщения:
    832
    Симпатии:
    488
    а почему не пользоваться yum update?