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

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

    <bug>
          <bug_id>24136</bug_id>
          
          <creation_ts>2010-09-22 11:50:18 +0400</creation_ts>
          <short_desc>Ошибки при service mysqld restart</short_desc>
          <delta_ts>2010-09-23 22:26:39 +0400</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="Anton Farygin">rider</reporter>
          <assigned_to name="Vitaly Kuznetsov">vitty</assigned_to>
          <cc>mike</cc>
    
    <cc>nickel</cc>
    
    <cc>rider</cc>
    
    <cc>shaba</cc>
    
    <cc>wrar</cc>
          
          <qa_contact>qa-sisyphus</qa_contact>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>112495</commentid>
    <comment_count>0</comment_count>
    <who name="Anton Farygin">rider</who>
    <bug_when>2010-09-22 11:50:18 +0400</bug_when>
    <thetext># service mysqld restart
Sending TERM signal to mysqld:                                                                                                               [ DONE ]
Waiting, while mysqld actualy stopped:                                                                                                       [ DONE ]
Installing all prepared tables
100922 11:48:24 [Note] Plugin &apos;InnoDB&apos; is disabled.
100922 11:48:24 [ERROR] /usr/sbin/mysqld: unknown option &apos;--skip-bdb&apos;
100922 11:48:24 [ERROR] Aborting

100922 11:48:24 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /var/lib/mysql/log for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &amp;
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell&gt; /usr/bin/mysql -u root mysql
mysql&gt; show tables

Try &apos;mysqld --help&apos; if you have problems with paths. Using --log
gives you a log in /var/lib/mysql/log that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: &apos;Problems running mysql_install_db&apos;,
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Adjusting environment for mysqld:                                                                                                            [ DONE ]
Starting mysqld service:                                                                                                                     [ DONE ]</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112496</commentid>
    <comment_count>1</comment_count>
    <who name="Andrey Rahmatullin">wrar</who>
    <bug_when>2010-09-22 11:53:37 +0400</bug_when>
    <thetext>Да, я тоже не понял, откуда оно взяло skip-bdb.
P.S. Два отдельных бага точно нужно?</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112497</commentid>
    <comment_count>2</comment_count>
    <who name="Vitaly Kuznetsov">vitty</who>
    <bug_when>2010-09-22 12:00:35 +0400</bug_when>
    <thetext>Почему-то не сработал триггер обновления.
 /var/lib/mysql/my.cnf в студию</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112498</commentid>
    <comment_count>3</comment_count>
    <who name="Andrey Rahmatullin">wrar</who>
    <bug_when>2010-09-22 12:03:24 +0400</bug_when>
    <thetext>[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
# old_passwords=1

# FIXME! bdb maybe work on x86/Linux and amd64/Linux
chroot=/var/lib/mysql
datadir=/db
#log=/log/queries
pid-file=/mysqld.pid
skip-external-locking
#skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112500</commentid>
    <comment_count>4</comment_count>
    <who name="Vitaly Kuznetsov">vitty</who>
    <bug_when>2010-09-22 12:05:36 +0400</bug_when>
    <thetext>*** Bug 24135 has been marked as a duplicate of this bug. ***</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112501</commentid>
    <comment_count>5</comment_count>
    <who name="Vitaly Kuznetsov">vitty</who>
    <bug_when>2010-09-22 12:08:09 +0400</bug_when>
    <thetext>Судя по этому - сработал.
А что в /etc/sysconfig/mysqld?</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112502</commentid>
    <comment_count>6</comment_count>
    <who name="Anton Farygin">rider</who>
    <bug_when>2010-09-22 12:12:59 +0400</bug_when>
    <thetext># cat /etc/sysconfig/mysqld 
# custom server charset
CHSET=

# mysqld process nice level (default 10)
NICE=

# other server opts
OPT=

# cat  /var/lib/mysql/my.cnf 
[mysqld]
chroot=/var/lib/mysql
datadir=/db
#log=/log/queries
pid-file=/mysqld.pid
skip-external-locking
skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112503</commentid>
    <comment_count>7</comment_count>
    <who name="Anton Farygin">rider</who>
    <bug_when>2010-09-22 12:16:28 +0400</bug_when>
    <thetext># fgrep skip-bdb /usr/sbin/mysql_install_db 
                         $mysqld --bootstrap --skip-innodb --skip-bdb --skip-ndbcluster \
                         $mysqld --bootstrap --skip-innodb --skip-bdb --skip-ndbcluster \</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112504</commentid>
    <comment_count>8</comment_count>
    <who name="Vitaly Kuznetsov">vitty</who>
    <bug_when>2010-09-22 12:19:22 +0400</bug_when>
    <thetext>(In reply to comment #7)
&gt; # fgrep skip-bdb /usr/sbin/mysql_install_db 
&gt;                          $mysqld --bootstrap --skip-innodb --skip-bdb
&gt; --skip-ndbcluster \
&gt;                          $mysqld --bootstrap --skip-innodb --skip-bdb
&gt; --skip-ndbcluster \

да, я уже нашёл. Попробуй удалить --skip-bdb и запустить. Если всё хорошо - я сейчас запатчу.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112506</commentid>
    <comment_count>9</comment_count>
    <who name="Vitaly Kuznetsov">vitty</who>
    <bug_when>2010-09-22 12:25:22 +0400</bug_when>
    <thetext>да, ndbcluster тоже лишний</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112507</commentid>
    <comment_count>10</comment_count>
    <who name="Anton Farygin">rider</who>
    <bug_when>2010-09-22 12:36:03 +0400</bug_when>
    <thetext>да, убрал - теперь перезапускается нормально</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112541</commentid>
    <comment_count>11</comment_count>
    <who name="Vitaly Kuznetsov">vitty</who>
    <bug_when>2010-09-22 16:02:53 +0400</bug_when>
    <thetext>Fixed in 5.1.50-alt3</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112581</commentid>
    <comment_count>12</comment_count>
    <who name="Michael Shigorin">mike</who>
    <bug_when>2010-09-23 16:31:25 +0400</bug_when>
    <thetext>Там ещё в /usr/sbin/mysql_migrate затесалось --skip-bdb.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>112614</commentid>
    <comment_count>13</comment_count>
    <who name="Vitaly Kuznetsov">vitty</who>
    <bug_when>2010-09-23 22:26:39 +0400</bug_when>
    <thetext>(In reply to comment #12)
&gt; Там ещё в /usr/sbin/mysql_migrate затесалось --skip-bdb.

Спасибо, и это тоже поправил.</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>