SupermanInNY
Verified User
- Joined
- Sep 28, 2004
- Messages
- 419
Hi All,
I had a power failure in my server and mysql is now throwing an error that affects httpd and dovecot.
I tried upgrading mysql, downgrading mysql, changed to previous kernel, but still same error.
Any pointers?
Thanks,
-Alon.
I had a power failure in my server and mysql is now throwing an error that affects httpd and dovecot.
100222 23:42:11 mysqld started
100222 23:42:11 [Warning] Asked for 196608 thread stack, but got 126976
InnoDB: Error: pthread_create returned 11
100222 23:42:12 mysqld ended
I tried upgrading mysql, downgrading mysql, changed to previous kernel, but still same error.
server.domain.com:/usr/local/directadmin/custombuild # ./build mysql
Cannot find /usr/bin/mysqldump
Found /usr/local/directadmin/custombuild/mysql/MySQL-client-5.0.90-1.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-devel-5.0.90-1.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-server-5.0.90-1.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-shared-5.0.90-1.i386.rpm
Stopping mysqld ...
/etc/init.d/mysqld: line 260: my_print_defaults: command not found
/etc/init.d/mysqld: line 263: my_print_defaults: command not found
MySQL manager or server PID file could not be found! [FAILED]
Cannot find /usr/bin/mysql, installing MySQL
warning: MySQL-client-5.0.90-1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-shared ########################################### [ 25%]
2:MySQL-client ########################################### [ 50%]
3:MySQL-devel ########################################### [ 75%]
4:MySQL-server ########################################### [100%]
100222 23:42:01 [Warning] Asked for 196608 thread stack, but got 126976
100222 23:42:01 [Warning] Asked for 196608 thread stack, but got 126976
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h server.domain.com password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQL..Manager of pid-file quit without updating file.[FAILED]
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Running 'mysqlcheck'...
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: unknown option '--fix-db-names'
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL..Manager of pid-file quit without updating f[FAILED]
It is recommended to do "./build php n" after MySQL update.
server.domain.com:/usr/local/directadmin/custombuild # less /var/lib/mysql/server.domain.com.err
100222 23:09:54 mysqld started
100222 23:09:54 [Warning] Asked for 196608 thread stack, but got 126976
InnoDB: Error: pthread_create returned 11
100222 23:09:55 mysqld ended
Any pointers?
Thanks,
-Alon.