<?xml version="1.0" encoding="UTF-8" ?>

<bugzilla version="5.2"
          urlbase="https://bugzilla.altlinux.org/"
          
          maintainer="jenya@basealt.ru"
>

    <bug>
          <bug_id>34956</bug_id>
          
          <creation_ts>2018-05-28 16:51:09 +0300</creation_ts>
          <short_desc>После обновления до MySQL-server-5.7.21-alt4.S1 не запускается</short_desc>
          <delta_ts>2018-05-28 19:27:17 +0300</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>4</classification_id>
          <classification>Development</classification>
          <product>Sisyphus</product>
          <component>MySQL-server</component>
          <version>unstable</version>
          <rep_platform>all</rep_platform>
          <op_sys>Linux</op_sys>
          <bug_status>CLOSED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>P3</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Vitaly Lipatov">lav</reporter>
          <assigned_to name="Anton Farygin">rider</assigned_to>
          <cc>mike</cc>
    
    <cc>nickel</cc>
    
    <cc>rider</cc>
    
    <cc>shaba</cc>
          
          <qa_contact>qa-sisyphus</qa_contact>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>171337</commentid>
    <comment_count>0</comment_count>
    <who name="Vitaly Lipatov">lav</who>
    <bug_when>2018-05-28 16:51:09 +0300</bug_when>
    <thetext>После обновления до MySQL-server-5.7.21-alt4.S1 не запускается:

# /etc/init.d/mysqld start
/etc/init.d/mysqld: line 36: [: missing `]&apos;
Adjusting environment for mysqld:                                                                                                                                                                          [ DONE ]
Starting mysqld service: 2018-05-28T13:49:24.962562Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-28T13:49:24.966790Z 0 [ERROR] Fatal error: Please read &quot;Security&quot; section of the manual to find out how to run mysqld as root!

2018-05-28T13:49:24.966855Z 0 [ERROR] Aborting

2018-05-28T13:49:24.966920Z 0 [Note] Binlog end
Initialization of mysqld failed: 0


Ну про [] это там пробел пропущен:
+ &apos;[&apos; &apos;!&apos; -d &apos;/var/lib/mysql/db/mysql]&apos;
/etc/init.d/mysqld: line 36: [: missing `]&apos;</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>171343</commentid>
    <comment_count>1</comment_count>
    <who name="Vitaly Lipatov">lav</who>
    <bug_when>2018-05-28 17:19:45 +0300</bug_when>
    <thetext>(В ответ на комментарий №0)
...&gt; 2018-05-28T13:49:24.966790Z 0 [ERROR] Fatal error: Please read &quot;Security&quot;
&gt; section of the manual to find out how to run mysqld as root!
Эта проблема решилась
# mv /etc/my.cnf.rpmnew /etc/my.cnf
 
 
&gt; Ну про [] это там пробел пропущен:
&gt; + &apos;[&apos; &apos;!&apos; -d &apos;/var/lib/mysql/db/mysql]&apos;
&gt; /etc/init.d/mysqld: line 36: [: missing `]&apos;
Эта остаётся

Далее запуск всё равно проваливается
# tail /var/lib/mysql/log/mysqld.log

2018-05-28T14:10:07.857727Z 0 [Warning] Gtid table is not ready to be used. Table &apos;mysql.gtid_executed&apos; cannot be opened.
2018-05-28T14:10:07.857806Z 0 [ERROR] /usr/sbin/mysqld: Can&apos;t create/write to file &apos;/var/lib/mysql/mysqld.pid&apos; (Errcode: 2 - No such file or directory)
2018-05-28T14:10:07.857818Z 0 [ERROR] Can&apos;t start server: can&apos;t create PID file: No such file or directory</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>171344</commentid>
    <comment_count>2</comment_count>
    <who name="Vitaly Lipatov">lav</who>
    <bug_when>2018-05-28 17:22:25 +0300</bug_when>
    <thetext>(В ответ на комментарий №1)
...

&gt; 2018-05-28T14:10:07.857806Z 0 [ERROR] /usr/sbin/mysqld: Can&apos;t create/write to
&gt; file &apos;/var/lib/mysql/mysqld.pid&apos; (Errcode: 2 - No such file or directory)
&gt; 2018-05-28T14:10:07.857818Z 0 [ERROR] Can&apos;t start server: can&apos;t create PID
&gt; file: No such file or directory
После создания симлинка
# ls /var/lib/mysql/var/lib/mysql  -l
lrwxrwxrwx 1 root root 15 мая 28 17:20 /var/lib/mysql/var/lib/mysql -&gt; /var/lib/mysql/

получил ошибку
2018-05-28T14:20:56.019329Z 0 [ERROR] /usr/sbin/mysqld: Can&apos;t create/write to file &apos;/var/lib/mysql/mysqld.pid&apos; (Errcode: 40 - Too many levels of symbolic links)
2018-05-28T14:20:56.019341Z 0 [ERROR] Can&apos;t start server: can&apos;t create PID file: Too many levels of symbolic links

Уж явно путаница в чруте.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>171360</commentid>
    <comment_count>3</comment_count>
    <who name="Anton Farygin">rider</who>
    <bug_when>2018-05-28 19:23:38 +0300</bug_when>
    <thetext>mysql_upgrade нужно запустить. Смотри обновление пакета mysql в Sisyphus</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>171361</commentid>
    <comment_count>4</comment_count>
    <who name="Anton Farygin">rider</who>
    <bug_when>2018-05-28 19:24:56 +0300</bug_when>
    <thetext>Вообще странно у тебя как-то отвалилось, у меня такого не наблюдается.
Системы правда на systemd.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>171363</commentid>
    <comment_count>5</comment_count>
    <who name="Anton Farygin">rider</who>
    <bug_when>2018-05-28 19:27:17 +0300</bug_when>
    <thetext>исправлено в 5.7.27-alt5</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>