Page 1 of 1

Upgrade of MySQL failed

Posted: Mon Feb 21, 2005 8:59 pm
by daveatmvn
I tried to upgrade my mysql server from the instructions on ART, but unfortunately it didn't complete successfully and now the site is down.

[root@u15166285 cleanserver]# rpm -e MySQL-Max MySQL-server MySQL-client MySQL-shared-compat --nodeps
error: package MySQL-Max is not installed
error: package MySQL-server is not installed
error: package MySQL-client is not installed
error: package MySQL-shared-compat is not installed
[root@u15166285 cleanserver]# yum install mysql-server mysql mysql-compat
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 9 - Atomic PSA-Compatible RPMS
Server: Atomic Rocket Turtle - 9 - Base OS RPMS mirror
Server: Atomic Rocket Turtle - 9 - SW-Soft PSA 7.5 RPMS
Server: Atomic Rocket Turtle - 9 - OS Update RPMS mirror
Finding updated packages
Downloading needed headers
Resolving dependencies
Dependencies resolved
I will do the following:
[install: mysql-compat 4.0.23a-1.rh90.art.i386]
[update: mysql-server 4.0.23a-1.rh90.art.i386]
[update: mysql 4.0.23a-1.rh90.art.i386]
Is this ok [y/N]: y
Downloading Packages
Getting mysql-server-4.0.23a-1.rh90.art.i386.rpm
mysql-server-4.0.23a-1.rh 100% |=========================| 1.4 MB 00:16
Getting mysql-4.0.23a-1.rh90.art.i386.rpm
mysql-4.0.23a-1.rh90.art. 100% |=========================| 7.4 MB 01:34
Getting mysql-compat-4.0.23a-1.rh90.art.i386.rpm
mysql-compat-4.0.23a-1.rh 100% |=========================| 243 kB 00:02
Running test transaction:
Test transaction complete, Success!
mysql 100 % done 1/5
mysql-compat 100 % done 2/5
mysql-server 100 % done 3/5
Completing update for mysql-server - 4/5
packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
packagemng: Unable to connect to the mysql database

System error 2: No such file or directory
packagemng: Unable to connect to the mysql database

System error 2: No such file or directory
error: %trigger(psa-7.5.2-rh9.build75050128.10) scriptlet failed, exit status 1
Installed: mysql-compat 4.0.23a-1.rh90.art.i386
Updated: mysql-server 4.0.23a-1.rh90.art.i386 mysql 4.0.23a-1.rh90.art.i386
Error from /var/log/mysqld.log
050221 20:04:02 mysqld started
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 640 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 6400 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
050221 20:04:02 Can't init databases
050221 20:04:02 Aborting

050221 20:04:02 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
050221 20:04:02 /usr/libexec/mysqld: Shutdown Complete

050221 20:04:02 mysqld ended

Posted: Mon Feb 21, 2005 9:23 pm
by daveatmvn
I had to remove the line for innodb_data_file_path=ibdata1:100M:autoextend from my.cnf

Question is will I still need that line in the configuration for something?
[mysqld]
;innodb_data_file_path=ibdata1:100M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
query_cache_type=1
query_cache_size=10m

#log=/tmp/mysql.log

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Posted: Mon Feb 21, 2005 9:34 pm
by daveatmvn
I love talking to myself :)

Plesk still shows mysql to be 3.23.58-1.9 in the component info page, so how do I know if I successfully installed 4?

Posted: Tue Feb 22, 2005 3:16 pm
by scott
Id check the rpm database, or do mysql --version

Posted: Tue Feb 22, 2005 6:16 pm
by daveatmvn
doing an mysql --version shows that 4x is installed, but Plesk still shows 3.23. Anyone know how to get Plesk to acknowledge the change?

Posted: Wed Feb 23, 2005 10:23 am
by scott
assuming its 7.1 or 7.5 its reading that from the rpm database