Installing mariadb-server-5.1 fails when upgrading from mysql with different innodb_log_file_size and replacing /etc/mysql/my.cnf
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Low
|
Kristian Nielsen | ||
OurDelta |
Fix Released
|
Low
|
Unassigned | ||
Percona-XtraDB |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
I upgraded an Ubuntu 8.04 mysql-server-5.0 to mariadb-server-5.1 (5.1.39-
The install failed, since the old mysql config used a non-default value for innodb_
Now this situation is actually user error. I am not sure the package should try to be clever and automagically handle a non-default innodb_
However, I think we could still improve this situation for the user, by at least allowing the install to succeed, even if the server will then not be able to start until the .cnf is fixed. Currently, the mysqld --bootstrap commands needed to update system tables etc. fails, leaving a broken install that must be fixed with apt-get install --fix-broken or similar.
I suggest to make this more robust by running the mysqld --bootstrap commands with innodb and pbxt disabled:
MYSQL_
This should allow install to succeed. The user would not have to fix a broken package install (but still need to fix the my.cnf before being able to start the server, of course).
Related branches
- Arjen Lentz: Approve
-
Diff: 147 lines (+20/-30)3 files modifiedbakery/debian-5.1/additions/debian-start (+4/-0)
bakery/debian-5.1/dist/Debian/mariadb-server-5.1.postinst (+8/-15)
bakery/debian-5.1/dist/Ubuntu/mariadb-server-5.1.postinst (+8/-15)
Changed in maria: | |
importance: | Undecided → Low |
status: | New → Confirmed |
Changed in maria: | |
assignee: | Kristian Nielsen (knielsen) → nobody |
Changed in maria: | |
assignee: | nobody → Kristian Nielsen (knielsen) |
Changed in maria: | |
status: | Confirmed → Fix Committed |
Changed in ourdelta: | |
status: | New → Fix Committed |
Changed in percona-xtradb: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Changed in ourdelta: | |
status: | Fix Committed → Fix Released |
Changed in percona-xtradb: | |
status: | Fix Committed → Fix Released |
Hi Kristian
On 17/11/2009, at 8:47 PM, Kristian Nielsen wrote: ="/usr/ sbin/mysqld --bootstrap --user=mysql --skip- storage- engine= myisam"
> I suggest to make this more robust by running the mysqld --bootstrap
> commands with innodb and pbxt disabled:
>
> MYSQL_BOOTSTRAP
> grant-tables --innodb=OFF --pbxt=OFF --default-
Sounds good.
There's a feature request for XtraDB, to have XtraDB able to increase
log file size.
As part of my original feature request was to have XtraDB just use the
actual log file size, rather than complain about the config setting.
Cheers, openquery. com)
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://
Exceptional Services for MySQL at a fixed budget.
Follow our blog at http:// openquery. com/blog/ ourdelta. org
OurDelta: packages for MySQL and MariaDB @ http://