Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 33

Thread: mysql server

  1. #11
    Join Date
    Feb 2011
    Beans
    Hidden!
    Distro
    Ubuntu 10.10 Maverick Meerkat

    Re: mysql server

    You need to look in the logs and see exactly why its failing.

    Should be in "/var/log/mysql/error.log" or something similar.

  2. #12
    Join Date
    Aug 2006
    Location
    India
    Beans
    301
    Distro
    Ubuntu 11.04 Natty Narwhal

    Re: mysql server

    Quote Originally Posted by bjje View Post
    sudo service mysql start
    start: Job failed to start
    That is not giving much details try

    Code:
    sudo /etc/init.d/mysql start
    also post the mysql error log entries.

  3. #13
    Join Date
    Feb 2010
    Location
    New York
    Beans
    61
    Distro
    Ubuntu 16.04 Xenial Xerus

    Re: mysql server

    Code:
    sudo /etc/init.d/mysql start
    Rather than invoking init scripts through /etc/init.d, use the service(8)
    utility, e.g. service mysql start
    
    Since the script you are attempting to invoke has been converted to an
    Upstart job, you may also use the start(8) utility, e.g. start mysql
    start: Job failed to start
    $ start mysql
    start: Rejected send message, 1 matched rules; type="method_call", sender=":1.79" (uid=1000 pid=10045 comm="start mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply=0 destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init"))
    /var/log/mysql$

    Code:
    110523  9:05:30 [Note] Plugin 'FEDERATED' is disabled.
    110523  9:05:30  InnoDB: Initializing buffer pool, size = 8.0M
    110523  9:05:30  InnoDB: Completed initialization of buffer pool
    110523  9:05:30  InnoDB: Started; log sequence number 0 44233
    110523  9:05:31  InnoDB: Starting shutdown...
    110523  9:05:36  InnoDB: Shutdown completed; log sequence number 0 44233
    110523  9:05:36 [Note] Plugin 'FEDERATED' is disabled.
    110523  9:05:36  InnoDB: Initializing buffer pool, size = 8.0M
    110523  9:05:36  InnoDB: Completed initialization of buffer pool
    110523  9:05:36  InnoDB: Started; log sequence number 0 44233
    ERROR: 1050  Table 'plugin' already exists
    110523  9:05:36 [ERROR] Aborting
    
    110523  9:05:36  InnoDB: Starting shutdown...
    110523  9:05:41  InnoDB: Shutdown completed; log sequence number 0 44233
    110523  9:05:41 [Note] /usr/sbin/mysqld: Shutdown complete

  4. #14
    Join Date
    Aug 2006
    Location
    India
    Beans
    301
    Distro
    Ubuntu 11.04 Natty Narwhal

    Re: mysql server

    If this is a new mysql installation try this

    Code:
    sudo dpkg -P mysql-server-5.1 mysql-server
    sudo apt-get install mysql-server
    Let me know, if the error persists.

  5. #15
    Join Date
    Feb 2010
    Location
    New York
    Beans
    61
    Distro
    Ubuntu 16.04 Xenial Xerus

    Re: mysql server

    dpkg runs but;

    sudo apt-get install mysql-server

    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    mysql-server is already the newest version.
    0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
    2 not fully installed or removed.
    After this operation, 0 B of additional disk space will be used.
    Do you want to continue [Y/n]? y
    Setting up mysql-server-5.1 (5.1.54-1ubuntu4) ...
    start: Job failed to start
    invoke-rc.d: initscript mysql, action "start" failed.
    dpkg: error processing mysql-server-5.1 (--configure):
    subprocess installed post-installation script returned error exit status 1
    dpkg: dependency problems prevent configuration of mysql-server:
    mysql-server depends on mysql-server-5.1; however:
    Package mysql-server-5.1 is not configured yet.
    dpkg: error processing mysql-server (--configure):
    dependency problems - leaving unconfigured
    No apport report written because the error message indicates its a followup error from a previous failure.
    Errors were encountered while processing:
    mysql-server-5.1
    mysql-server
    E: Sub-process /usr/bin/dpkg returned an error code (1)

  6. #16
    Join Date
    Aug 2006
    Location
    India
    Beans
    301
    Distro
    Ubuntu 11.04 Natty Narwhal

    Re: mysql server

    ok, execute following commands and also paste the result of each of them.

    Code:
    sudo dpkg -P mysql-server mysql-server-5.1
    sudo apt-get autoremove
    sudo apt-get clean
    dpkg -l | grep -i mysql
    sudo rm -rvf /var/lib/mysql
    sudo apt-get install mysql-server
    Again, I am assuming that this is a new mysql installation with no database created.

  7. #17
    Join Date
    Feb 2010
    Location
    New York
    Beans
    61
    Distro
    Ubuntu 16.04 Xenial Xerus

    Re: mysql server

    It's new only to the extent that I have previously removed it trying to fix this. Remember that my problem happened in the middle of installing some packages and it broke my ability to install any or update. Thanks,

    Code:
    sudo dpkg -P mysql-server mysql-server-5.1
    (Reading database ... 262011 files and directories currently installed.)
    Removing mysql-server ...
    Removing mysql-server-5.1 ...
    Purging configuration files for mysql-server-5.1 ...
    Processing triggers for man-db ...
    Processing triggers for ureadahead ...
    ureadahead will be reprofiled on next reboot
     sudo apt-get autoremove
    Reading package lists... Done
    Building dependency tree       
    Reading state information... Done
    0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
    sudo apt-get clean
     dpkg -l | grep -i mysql
    ii  libdbd-mysql-perl                     4.016-1                                    Perl5 database interface to the MySQL database
    ii  libmysqlclient16                      5.1.54-1ubuntu4                            MySQL database client library
    ii  libqt4-sql-mysql                      4:4.7.2-0ubuntu6.1                         Qt 4 MySQL database driver
    ii  mysql-client-5.1                      5.1.54-1ubuntu4                            MySQL database client binaries
    ii  mysql-client-core-5.1                 5.1.54-1ubuntu4                            MySQL database core client binaries
    ii  mysql-common                          5.1.54-1ubuntu4                            MySQL database common files, e.g. /etc/mysql/my.cnf
    ii  mysql-server-core-5.1                 5.1.54-1ubuntu4                            MySQL database server binaries
    ii  php5-mysql                            5.3.5-1ubuntu7.2                           MySQL module for php5
    ii  python-mysqldb                        1.2.2-10build2                             A Python interface to MySQL
    sudo rm -rvf /var/lib/mysql
    removed `/var/lib/mysql/debian-5.1.flag'
    removed `/var/lib/mysql/mysql/help_relation.MYI'
    removed `/var/lib/mysql/mysql/time_zone_leap_second.MYI'
    removed `/var/lib/mysql/mysql/help_category.frm'
    removed `/var/lib/mysql/mysql/tables_priv.MYI'
    removed `/var/lib/mysql/mysql/user.MYI'
    removed `/var/lib/mysql/mysql/time_zone_name.frm'
    removed `/var/lib/mysql/mysql/help_topic.MYI'
    removed `/var/lib/mysql/mysql/host.frm'
    removed `/var/lib/mysql/mysql/slow_log.frm'
    removed `/var/lib/mysql/mysql/time_zone_leap_second.frm'
    removed `/var/lib/mysql/mysql/db.MYD'
    removed `/var/lib/mysql/mysql/procs_priv.MYD'
    removed `/var/lib/mysql/mysql/plugin.frm'
    removed `/var/lib/mysql/mysql/time_zone.frm'
    removed `/var/lib/mysql/mysql/time_zone_transition_type.frm'
    removed `/var/lib/mysql/mysql/user.frm'
    removed `/var/lib/mysql/mysql/time_zone_transition_type.MYD'
    removed `/var/lib/mysql/mysql/columns_priv.MYI'
    removed `/var/lib/mysql/mysql/proc.MYD'
    removed `/var/lib/mysql/mysql/ndb_binlog_index.MYI'
    removed `/var/lib/mysql/mysql/general_log.frm'
    removed `/var/lib/mysql/mysql/help_keyword.MYD'
    removed `/var/lib/mysql/mysql/tables_priv.frm'
    removed `/var/lib/mysql/mysql/time_zone.MYI'
    removed `/var/lib/mysql/mysql/help_topic.MYD'
    removed `/var/lib/mysql/mysql/help_relation.MYD'
    removed `/var/lib/mysql/mysql/time_zone_leap_second.MYD'
    removed `/var/lib/mysql/mysql/db.frm'
    removed `/var/lib/mysql/mysql/help_topic.frm'
    removed `/var/lib/mysql/mysql/servers.MYI'
    removed `/var/lib/mysql/mysql/host.MYI'
    removed `/var/lib/mysql/mysql/host.MYD'
    removed `/var/lib/mysql/mysql/time_zone.MYD'
    removed `/var/lib/mysql/mysql/user.MYD'
    removed `/var/lib/mysql/mysql/proc.MYI'
    removed `/var/lib/mysql/mysql/slow_log.CSV'
    removed `/var/lib/mysql/mysql/event.frm'
    removed `/var/lib/mysql/mysql/columns_priv.frm'
    removed `/var/lib/mysql/mysql/servers.MYD'
    removed `/var/lib/mysql/mysql/tables_priv.MYD'
    removed `/var/lib/mysql/mysql/time_zone_transition.MYI'
    removed `/var/lib/mysql/mysql/ndb_binlog_index.frm'
    removed `/var/lib/mysql/mysql/general_log.CSM'
    removed `/var/lib/mysql/mysql/time_zone_name.MYI'
    removed `/var/lib/mysql/mysql/plugin.MYI'
    removed `/var/lib/mysql/mysql/ndb_binlog_index.MYD'
    removed `/var/lib/mysql/mysql/columns_priv.MYD'
    removed `/var/lib/mysql/mysql/help_keyword.frm'
    removed `/var/lib/mysql/mysql/time_zone_transition_type.MYI'
    removed `/var/lib/mysql/mysql/slow_log.CSM'
    removed `/var/lib/mysql/mysql/db.MYI'
    removed `/var/lib/mysql/mysql/procs_priv.MYI'
    removed `/var/lib/mysql/mysql/time_zone_transition.frm'
    removed `/var/lib/mysql/mysql/general_log.CSV'
    removed `/var/lib/mysql/mysql/time_zone_name.MYD'
    removed `/var/lib/mysql/mysql/servers.frm'
    removed `/var/lib/mysql/mysql/help_category.MYD'
    removed `/var/lib/mysql/mysql/proc.frm'
    removed `/var/lib/mysql/mysql/plugin.MYD'
    removed `/var/lib/mysql/mysql/event.MYD'
    removed `/var/lib/mysql/mysql/event.MYI'
    removed `/var/lib/mysql/mysql/func.MYD'
    removed `/var/lib/mysql/mysql/help_category.MYI'
    removed `/var/lib/mysql/mysql/help_relation.frm'
    removed `/var/lib/mysql/mysql/func.frm'
    removed `/var/lib/mysql/mysql/help_keyword.MYI'
    removed `/var/lib/mysql/mysql/time_zone_transition.MYD'
    removed `/var/lib/mysql/mysql/procs_priv.frm'
    removed `/var/lib/mysql/mysql/func.MYI'
    removed directory: `/var/lib/mysql/mysql'
    removed `/var/lib/mysql/ibdata1'
    removed `/var/lib/mysql/ib_logfile0'
    removed `/var/lib/mysql/ib_logfile1'
    removed directory: `/var/lib/mysql'
     sudo apt-get install mysql-server
    Reading package lists... Done
    Building dependency tree       
    Reading state information... Done
    The following extra packages will be installed:
      mysql-server-5.1
    Suggested packages:
      tinyca mailx
    The following NEW packages will be installed:
      mysql-server mysql-server-5.1
    0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
    Need to get 6,265 kB of archives.
    After this operation, 13.6 MB of additional disk space will be used.
    Do you want to continue [Y/n]? y
    Get:1 http://us.archive.ubuntu.com/ubuntu/ natty/main mysql-server-5.1 i386 5.1.54-1ubuntu4 [6,258 kB]
    Get:2 http://us.archive.ubuntu.com/ubuntu/ natty/main mysql-server all 5.1.54-1ubuntu4 [6,828 B]
    Fetched 6,265 kB in 4s (1,398 kB/s)
    Preconfiguring packages ...
    Selecting previously deselected package mysql-server-5.1.
    (Reading database ... 261932 files and directories currently installed.)
    Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.54-1ubuntu4_i386.deb) ...
    Selecting previously deselected package mysql-server.
    Unpacking mysql-server (from .../mysql-server_5.1.54-1ubuntu4_all.deb) ...
    Processing triggers for ureadahead ...
    Processing triggers for man-db ...
    Setting up mysql-server-5.1 (5.1.54-1ubuntu4) ...
    start: Job failed to start
    invoke-rc.d: initscript mysql, action "start" failed.
    dpkg: error processing mysql-server-5.1 (--configure):
     subprocess installed post-installation script returned error exit status 1
    dpkg: dependency problems prevent configuration of mysql-server:
     mysql-server depends on mysql-server-5.1; however:
      Package mysql-server-5.1 is not configured yet.
    dpkg: error processing mysql-server (--configure):
     dependency problems - leaving unconfigured
    No apport report written because the error message indicates its a followup error from a previous failure.
                              Errors were encountered while processing:
     mysql-server-5.1
     mysql-server
    E: Sub-process /usr/bin/dpkg returned an error code (1)

  8. #18
    Join Date
    Aug 2006
    Location
    India
    Beans
    301
    Distro
    Ubuntu 11.04 Natty Narwhal

    Re: mysql server

    It seems autoremove is not removing the dep. try

    Code:
    sudo dpkg -P mysql-server mysql-server-5.1 mysql-common mysql-server-core-5.1 php5-mysql mysql-client-5.1 mysql-client-core-5.1
    sudo apt-get install mysql-server
    paste the result of above commands and result of logs, if the issue persists.

    Code:
    sudo start mysql;sudo tail -20 /var/log/mysql/error.log

  9. #19
    Join Date
    Feb 2010
    Location
    New York
    Beans
    61
    Distro
    Ubuntu 16.04 Xenial Xerus

    Re: mysql server

    Same old thing'
    Code:
    sudo dpkg -P mysql-server mysql-server-5.1 mysql-common mysql-server-core-5.1 php5-mysql mysql-client-5.1 mysql-client-core-5.1
    dpkg: warning: there's no installed package matching mysql-server
    dpkg: warning: there's no installed package matching mysql-server-5.1
    dpkg: warning: there's no installed package matching php5-mysql
    dpkg: dependency problems prevent removal of mysql-common:
     libmysqlclient16 depends on mysql-common (>= 5.1.54-1ubuntu4).
    dpkg: error processing mysql-common (--purge):
     dependency problems - not removing
    dpkg: dependency problems prevent removal of mysql-server-core-5.1:
     akonadi-server depends on mysql-server-core-5.1.
    dpkg: error processing mysql-server-core-5.1 (--purge):
     dependency problems - not removing
    dpkg: dependency problems prevent removal of mysql-client-5.1:
     mythtv-common depends on mysql-client; however:
      Package mysql-client is not installed.
      Package mysql-client-5.1 which provides mysql-client is to be removed.
    dpkg: error processing mysql-client-5.1 (--purge):
     dependency problems - not removing
    dpkg: dependency problems prevent removal of mysql-client-core-5.1:
     mysql-client-5.1 depends on mysql-client-core-5.1.
     akonadi-server depends on mysql-client-core-5.1.
    dpkg: error processing mysql-client-core-5.1 (--purge):
     dependency problems - not removing
    Errors were encountered while processing:
     mysql-common
     mysql-server-core-5.1
     mysql-client-5.1
     mysql-client-core-5.1

  10. #20
    Join Date
    Feb 2010
    Location
    New York
    Beans
    61
    Distro
    Ubuntu 16.04 Xenial Xerus

    Re: mysql server

    Code:
     sudo start mysql;sudo tail -20 /var/log/mysql/error.log
    start: Job failed to start
    110524 13:24:28  InnoDB: Shutdown completed; log sequence number 0 44233
    110524 13:24:28 [Note] /usr/sbin/mysqld: Shutdown complete
    
    110524 13:24:28 [Note] Plugin 'FEDERATED' is disabled.
    110524 13:24:28  InnoDB: Initializing buffer pool, size = 8.0M
    110524 13:24:28  InnoDB: Completed initialization of buffer pool
    110524 13:24:28  InnoDB: Started; log sequence number 0 44233
    110524 13:24:28  InnoDB: Starting shutdown...
    110524 13:24:33  InnoDB: Shutdown completed; log sequence number 0 44233
    110524 13:24:33 [Note] Plugin 'FEDERATED' is disabled.
    110524 13:24:33  InnoDB: Initializing buffer pool, size = 8.0M
    110524 13:24:33  InnoDB: Completed initialization of buffer pool
    110524 13:24:33  InnoDB: Started; log sequence number 0 44233
    ERROR: 1050  Table 'plugin' already exists
    110524 13:24:33 [ERROR] Aborting
    
    110524 13:24:33  InnoDB: Starting shutdown...
    110524 13:24:39  InnoDB: Shutdown completed; log sequence number 0 44233
    110524 13:24:39 [Note] /usr/sbin/mysqld: Shutdown complete

Page 2 of 4 FirstFirst 1234 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •