[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Looks like this was due to corrupted tables, and there's no indication as to why they were corrupted. Kayode, thanks for sharing all the valuable data. Closing this bug as invalid. ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: Incomplete = Invalid -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
I could not backup the database with the instructions given. Eventually on the advise of a friend I moved the database: sudo mv /var/lib/mysql /var/lib/mysql.corrupted after doing: sudo apt-get purge mysql-server-5.1 then I was able to reinstall the server: sudo apt-get install mysql-server-5.1 Now MySQL server is working perfectly but I do not have access to my old database. Not too bad as I had no precious data in it. Even at that would do backup of non-precious data as you never know when the unexpected may happen. Thanks a lot for the assistance. -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Please find below the transactions on my terminal with trying to purge and reinstall the server. Hope it makes sense to someone: kay...@ubuntu:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.41-3ubuntu12.6 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: *** NONE *** +---+ | Database | +---+ | information_schema| | cssc_central_4_0 | | ihris_manage | | ihris_manage_demo | | manage_northern_ghana_4_0 | | manage_togo_4_0 | | manage_togo_4_0_dev | | mysql | | qualify_NMCN_4_0 | | qualify_demo | +---+ 10 rows in set (0.00 sec) mysql exit Bye kay...@ubuntu:~$ sudo apt-get purge mysql-server-5.1 [sudo] password for kayodu: Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: linux-headers-2.6.32-21 linux-headers-2.6.32-21-generic Use 'apt-get autoremove' to remove them. The following packages will be REMOVED: mysql-server-5.1* 0 upgraded, 0 newly installed, 1 to remove and 2 not upgraded. After this operation, 15.0MB disk space will be freed. Do you want to continue [Y/n]? y (Reading database ... 175042 files and directories currently installed.) Removing mysql-server-5.1 ... mysql stop/waiting Purging configuration files for mysql-server-5.1 ... Processing triggers for man-db ... Processing triggers for ureadahead ... kay...@ubuntu:~$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) kay...@ubuntu:~$ sudo apt-get install mysql-server-5.1 Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: linux-headers-2.6.32-21 linux-headers-2.6.32-21-generic Use 'apt-get autoremove' to remove them. Suggested packages: tinyca The following NEW packages will be installed: mysql-server-5.1 0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded. Need to get 0B/7,008kB of archives. After this operation, 15.0MB of additional disk space will be used. Preconfiguring packages ... Selecting previously deselected package mysql-server-5.1. (Reading database ... 174965 files and directories currently installed.) Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.41-3ubuntu12.6_i386.deb) ... Processing triggers for ureadahead ... Processing triggers for man-db ... Setting up mysql-server-5.1 (5.1.41-3ubuntu12.6) ... mysql start/running, process 18314 Processing triggers for libc-bin ... ldconfig deferred processing now taking place kay...@ubuntu:~$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) kay...@ubuntu:~$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) kay...@ubuntu:~$ -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Then two minutes later, without doing anything new: kay...@ubuntu:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.41-3ubuntu12.6 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: *** NONE *** +---+ | Database | +---+ | information_schema| | cssc_central_4_0 | | ihris_manage | | ihris_manage_demo | | manage_northern_ghana_4_0 | | manage_togo_4_0 | | manage_togo_4_0_dev | | mysql | | qualify_NMCN_4_0 | | qualify_demo | +---+ 10 rows in set (0.00 sec) mysql My old databases are still intact not purged or reinstalled with the supposedly new installation and the instability of the mysql-server-5.1 remains. Is there another way to get rid of the old databases that seem to have been corrupted and causing the server to crash? -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Even sudo-apt-get remove mysql-server-5.1 did not work: kay...@ubuntu:~$ sudo apt-get purge mysql-server-5.1 Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: linux-headers-2.6.32-21 linux-headers-2.6.32-21-generic Use 'apt-get autoremove' to remove them. The following packages will be REMOVED: mysql-server-5.1* 0 upgraded, 0 newly installed, 1 to remove and 2 not upgraded. After this operation, 15.0MB disk space will be freed. Do you want to continue [Y/n]? y (Reading database ... 175042 files and directories currently installed.) Removing mysql-server-5.1 ... mysql stop/waiting Purging configuration files for mysql-server-5.1 ... Processing triggers for man-db ... Processing triggers for ureadahead ... kay...@ubuntu:~$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) kay...@ubuntu:~$ sudo apt-get install mysql-server-5.1 Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: linux-headers-2.6.32-21 linux-headers-2.6.32-21-generic Use 'apt-get autoremove' to remove them. Suggested packages: tinyca The following NEW packages will be installed: mysql-server-5.1 0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded. Need to get 0B/7,008kB of archives. After this operation, 15.0MB of additional disk space will be used. Preconfiguring packages ... Selecting previously deselected package mysql-server-5.1. (Reading database ... 174965 files and directories currently installed.) Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.41-3ubuntu12.6_i386.deb) ... Processing triggers for ureadahead ... Processing triggers for man-db ... Setting up mysql-server-5.1 (5.1.41-3ubuntu12.6) ... mysql start/running, process 11500 Processing triggers for libc-bin ... ldconfig deferred processing now taking place kay...@ubuntu:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.41-3ubuntu12.6 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: *** NONE *** +---+ | Database | +---+ | information_schema| | cssc_central_4_0 | | ihris_manage | | ihris_manage_demo | | manage_northern_ghana_4_0 | | manage_togo_4_0 | | manage_togo_4_0_dev | | mysql | | qualify_NMCN_4_0 | | qualify_demo | +---+ 10 rows in set (0.36 sec) mysql exit Bye kay...@ubuntu:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.41-3ubuntu12.6 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: *** NONE *** +---+ | Database | +---+ | information_schema| | cssc_central_4_0 | | ihris_manage | | ihris_manage_demo | | manage_northern_ghana_4_0 | | manage_togo_4_0 | | manage_togo_4_0_dev | | mysql | | qualify_NMCN_4_0 | | qualify_demo | +---+ 10 rows in set (0.00 sec) mysql exit Bye kay...@ubuntu:~$ sudo apt-get remove mysql-server-5.1 [sudo] password for kayodu: Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: linux-headers-2.6.32-21 linux-headers-2.6.32-21-generic Use 'apt-get autoremove' to remove them. The following packages will be REMOVED: mysql-server-5.1 0 upgraded, 0 newly installed, 1 to remove and 2 not upgraded. After this operation, 15.0MB disk space will be freed. Do you want to continue [Y/n]? y (Reading database ... 175042 files and directories currently installed.) Removing mysql-server-5.1 ... mysql stop/waiting Processing triggers for man-db ... Processing triggers for ureadahead ... kay...@ubuntu:~$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) kay...@ubuntu:~$ sudo apt-get install mysql-server-5.1 Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Kayode, thanks for continuing to try to solve this issue. The databases are stored in /var/lib/mysql To back it up, do sudo tar -czf backup-mysql.tar.gz -C /var/lib mysql If the tarball of those database files is small enough, you can attach it here, and I will send the crash bug upstream to mysql, as regardless of what caused this, mysql should not crash so hard no matter what data is in the database. If (after backing up) you run apt-get remove mysql-server-core-5.1 dpkg --purge mysql-server-5.1 That should remove the database files completely. Then on install of the package, it should create a new blank database directory and start mysqld properly. -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Thanks but the purging and installing the mysql-server-5.1 did not help. My databases were not dropped. I tried dropping one of them after I login to mysql, then the server was gone as the error recurred. I would be glad to send my databases to you guys to help find the bug and help others in future as I intend to uninstall Ubuntu and reinstall everything all over again. I am not a geek so how do I copy and send you the databases as I am sure mysqldump would not work. I use phpMyAdmin to manage mysql server but it is unable to connect once the server has gone away, -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Tried forcing InnoDB recovery by adding innodb_force_recovery = 4 to my.cnf file under the section [mysqld] as suggested in http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html but it did not help. No change in the grep mysql /var/log/syslog output: Aug 16 03:26:46 ubuntu /etc/mysql/debian-start[13317]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 16 03:26:46 ubuntu /etc/mysql/debian-start[13317]: Looking for 'mysql' as: /usr/bin/mysql Aug 16 03:26:46 ubuntu /etc/mysql/debian-start[13317]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 16 03:26:46 ubuntu /etc/mysql/debian-start[13317]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 16 03:26:46 ubuntu /etc/mysql/debian-start[13324]: Checking for insecure root accounts. Aug 16 03:26:46 ubuntu /etc/mysql/debian-start[13328]: Triggering myisam-recover for all MyISAM tables Aug 16 03:26:46 ubuntu init: mysql main process (13297) terminated with status 1 Aug 16 03:26:46 ubuntu init: mysql main process ended, respawning Aug 16 03:26:46 ubuntu kernel: [ 1325.544609] type=1505 audit(1281943606.295:1053): operation=profile_replace pid=13335 name=/usr/sbin/mysqld Aug 16 03:26:47 ubuntu init: mysql main process (13339) terminated with status 1 Aug 16 03:26:47 ubuntu init: mysql main process ended, respawning -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Kayode, thanks for the updates. The hard innodb crash that you pasted in comment #4 is particularly concerning. You may want to try backing up your system, and doing *** THIS STEP WILL DELETE ALL OF YOUR DATA FILES *** apt-get purge mysql-server-5.1 apt-get install mysql-server-5.1 And then restore the data only (if you haven't changed anything, /var/lib/mysql) from the backup. That will at least restore the binaries and make sure its not a library/binary corruption problem. If you still get a crash like that, then we should look at filing a bug with MySQL. They may request a copy of your data files to help reproduce the problem. Once you've reinstalled mysql-server-5.1 and restored the data, restart mysql and then check /var/log/mysql/error.log to see if it started normally. -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Hi Kayode, thanks for reporting this and working with us to make Ubuntu better! Can you please paste the output of 'sudo stop mysql' and also any error messages printed by mysql in /var/log/syslog right after that? The best way would be to upload the output of grep mysql /var/log/syslog in a text file. Thank you! (Marking incomplete for now) ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: New = Incomplete -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
This is the output of grep mysql /var/log/syslog: usr/bin/mysql Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32467]: Checking for insecure root accounts. Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32471]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:10 ubuntu init: mysql main process (32440) terminated with status 1 Aug 15 19:28:10 ubuntu init: mysql main process ended, respawning Aug 15 19:28:10 ubuntu kernel: [ 978.217405] type=1505 audit(1281914890.965:760): operation=profile_replace pid=32478 name=/usr/sbin/mysqld Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32499]: Upgrading MySQL tables if necessary. Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32509]: Checking for insecure root accounts. Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32513]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:12 ubuntu init: mysql main process (32482) terminated with status 1 Aug 15 19:28:12 ubuntu init: mysql main process ended, respawning Aug 15 19:28:12 ubuntu kernel: [ 979.552106] type=1505 audit(1281914892.301:761): operation=profile_replace pid=32520 name=/usr/sbin/mysqld Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32541]: Upgrading MySQL tables if necessary. Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32551]: Checking for insecure root accounts. Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32555]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:13 ubuntu init: mysql main process (32524) terminated with status 1 Aug 15 19:28:13 ubuntu init: mysql main process ended, respawning Aug 15 19:28:13 ubuntu kernel: [ 980.878130] type=1505 audit(1281914893.625:762): operation=profile_replace pid=32562 name=/usr/sbin/mysqld Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32583]: Upgrading MySQL tables if necessary. Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32593]: Checking for insecure root accounts. Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32597]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:14 ubuntu init: mysql main process (32566) terminated with status 1 Aug 15 19:28:14 ubuntu init: mysql main process ended, respawning Aug 15 19:28:14 ubuntu kernel: [ 982.220520] type=1505 audit(1281914894.969:763): operation=profile_replace pid=32604 name=/usr/sbin/mysqld Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32625]: Upgrading MySQL tables if necessary. Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32635]: Checking for insecure root accounts. Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32639]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:16 ubuntu init: mysql main process (32608) terminated with status 1 Aug 15 19:28:16 ubuntu init: mysql main process ended, respawning Aug 15 19:28:16 ubuntu kernel: [ 983.562185]
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
Don't know if this would be of any help. I copied it from the error.log -/var/log/mysql/error.log: 100815 19:28:45 InnoDB: Started; log sequence number 1 637983031 InnoDB: Starting in background the rollback of uncommitted transactions InnoDB: Cleaning up trx with id 0 1738733 100815 19:28:45 InnoDB: Rollback of non-prepared transactions completed 100815 19:28:45 [Note] Event Scheduler: Loaded 0 events 100815 19:28:45 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.41-3ubuntu12.6' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 100815 19:28:46 InnoDB: Assertion failure in thread 2905140080 in file ../../../storage/innobase/fsp/fsp0fsp.c line 3314 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100815 19:28:46 - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_threads=151 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 345919 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = (nil) thread_stack 0x3 /usr/sbin/mysqld(my_print_stacktrace+0x2d) [0x7635ad] /usr/sbin/mysqld(handle_segfault+0x494) [0x42f3d4] [0x12d400] /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0xb27a82] /usr/sbin/mysqld(fseg_free_step_not_header+0x243) [0x6527c3] /usr/sbin/mysqld(+0x4f8b20) [0x6c0b20] /usr/sbin/mysqld(+0x4f9003) [0x6c1003] /usr/sbin/mysqld(trx_purge_fetch_next_rec+0x28c) [0x6c134c] /usr/sbin/mysqld(row_purge_step+0x42) [0x6a1252] /usr/sbin/mysqld(que_run_threads+0x5b0) [0x68caf0] /usr/sbin/mysqld(trx_purge+0x375) [0x6bf0a5] /usr/sbin/mysqld(srv_master_thread+0xf80) [0x6b5c90] /lib/tls/i686/cmov/libpthread.so.0(+0x596e) [0xf7b96e] /lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0xbc7a4e] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. This sequence of error is repeated about every two minutes. -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
The output of grep mysql /var/log/syslog after the error generated by sudo mysql stop: usr/bin/mysql Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32467]: Checking for insecure root accounts. Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32471]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:10 ubuntu init: mysql main process (32440) terminated with status 1 Aug 15 19:28:10 ubuntu init: mysql main process ended, respawning Aug 15 19:28:10 ubuntu kernel: [ 978.217405] type=1505 audit(1281914890.965:760): operation=profile_replace pid=32478 name=/usr/sbin/mysqld Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32499]: Upgrading MySQL tables if necessary. Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32502]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32509]: Checking for insecure root accounts. Aug 15 19:28:12 ubuntu /etc/mysql/debian-start[32513]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:12 ubuntu init: mysql main process (32482) terminated with status 1 Aug 15 19:28:12 ubuntu init: mysql main process ended, respawning Aug 15 19:28:12 ubuntu kernel: [ 979.552106] type=1505 audit(1281914892.301:761): operation=profile_replace pid=32520 name=/usr/sbin/mysqld Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32541]: Upgrading MySQL tables if necessary. Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32544]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32551]: Checking for insecure root accounts. Aug 15 19:28:13 ubuntu /etc/mysql/debian-start[32555]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:13 ubuntu init: mysql main process (32524) terminated with status 1 Aug 15 19:28:13 ubuntu init: mysql main process ended, respawning Aug 15 19:28:13 ubuntu kernel: [ 980.878130] type=1505 audit(1281914893.625:762): operation=profile_replace pid=32562 name=/usr/sbin/mysqld Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32583]: Upgrading MySQL tables if necessary. Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32586]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32593]: Checking for insecure root accounts. Aug 15 19:28:14 ubuntu /etc/mysql/debian-start[32597]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:14 ubuntu init: mysql main process (32566) terminated with status 1 Aug 15 19:28:14 ubuntu init: mysql main process ended, respawning Aug 15 19:28:14 ubuntu kernel: [ 982.220520] type=1505 audit(1281914894.969:763): operation=profile_replace pid=32604 name=/usr/sbin/mysqld Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32625]: Upgrading MySQL tables if necessary. Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: Looking for 'mysql' as: /usr/bin/mysql Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32628]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32635]: Checking for insecure root accounts. Aug 15 19:28:16 ubuntu /etc/mysql/debian-start[32639]: Triggering myisam-recover for all MyISAM tables Aug 15 19:28:16 ubuntu init: mysql main process (32608) terminated with status 1 Aug 15 19:28:16 ubuntu init: mysql main process ended, respawning Aug 15
[Bug 617678] Re: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
** Attachment added: .etc.apparmor.d.usr.sbin.mysqld.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489145/+files/.etc.apparmor.d.usr.sbin.mysqld.txt ** Attachment added: AptOrdering.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489146/+files/AptOrdering.txt ** Attachment added: Dependencies.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489147/+files/Dependencies.txt ** Attachment added: Df.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489148/+files/Df.txt ** Attachment added: Dmesg.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489149/+files/Dmesg.txt ** Attachment added: DpkgTerminalLog.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489150/+files/DpkgTerminalLog.txt ** Attachment added: Logs.var.log.daemon.log.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489151/+files/Logs.var.log.daemon.log.txt ** Attachment added: Logs.var.log.kern.log.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489152/+files/Logs.var.log.kern.log.txt ** Attachment added: MySQLConf.etc.mysql.my.cnf.txt https://bugs.launchpad.net/bugs/617678/+attachment/1489153/+files/MySQLConf.etc.mysql.my.cnf.txt -- package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 https://bugs.launchpad.net/bugs/617678 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs