Flying while programming in modern Java and C++

Hi, my name is Ján! In this corner of the web I vent about everyday struggles of being a private pilot and a software engineer.

Back

Upgrade OpenSolaris 2009.06 111b to OpenIndiana

Finally, after months of doubts, I decided to upgrade my only production server from very very very old OpenSolaris build 111b to newest stable OpenIndiana system.

Following how-tos (wikis) http://wiki.openindiana.org/oi/2.+Installing+or+Upgrading and blog http://blogs.oracle.com/observatory/entry/upgrading_from_opensolaris_2009_06 and probably many more I started to prepare my server for the worst.

Removing "Problematic" and Custom built packages

vega@james ~ $ pkg list -s | grep '(webstack)'
phpmyadmin (webstack) phpMyAdmin is a web application written in PHP used for administering a MySQL database. See project website at http://www.phpmyadmin.net/
vega@james ~ $ pfexec pkg uninstall phpmyadmin

I also built one custom package to add lzma command for my installation. For sure, I removed it:

vega@james ~ $ pfexec pkgrm SFElzma

Removing repositories

vega@james ~ $ pfexec pkg unset-publisher webstack
vega@james ~ $ pfexec pkg unset-publisher localhost

Create a New Boot Environment

vega@james ~ $ pfexec beadm create opensolaris-2011-05-14

Update the OpenSolaris Image

According to OpenIndiana Wiki:

"In order to upgrade, you should be running OpenSolaris build 134 (snv_134) or 134b (snv_134b), the last releases published by Oracle (Sun). Upgrading from later builds including 145 and 146 may work, but is unsupported."

Well, let's do that.

vega@james ~ $ pfexec pkg install SUNWipkg SUNWipkg-um SUNWipkg-gui
vega@james ~ $ pfexec pkg set-publisher -O http://pkg.openindiana.org/legacy opensolaris.org
vega@james ~ $ pfexec pkg image-update -v --be-name=opensolaris-b134

MySQL 5.0 to 5.1 migration

Looks like MySQL version 5.0 was removed from build 134. Mine 5.0 was located in zone0, so we need to move old data and migrate them.

First copy the manifest>

james ~ # mkdir /export/zones/zone0/root/var/svc/manifest/application/database/
james ~ # cp /var/svc/manifest/application/database/mysql_51.xml /export/zones/zone0/root/var/svc/manifest/application/database/

Login to zone0 and import the manifest:

zone0 ~ # svccfg import /var/svc/manifest/application/database/mysql_51.xml

Start the database:

zone0 ~ # svcadm enable svc:/application/database/mysql:version_51

Check the log if it works correctly:

zone0 ~ # tail -f /var/svc/log/application-database-mysql\:version_51.log

I want to use 64bit version of MySQL:

zone0 ~ # svccfg -s svc:/application/database/mysql:version_51
svc:/application/database/mysql:version_51> setprop mysql/enable_64bit = boolean: true

Delete all sample data from 5.1 and copy old 5.0 data:

zone0 ~ # rm -rf /var/mysql/5.1/data/ && cp -r /var/mysql/5.0/data/ /var/mysql/5.1/

Okay, now the configs. Sample fonfigs will not work (at least not with InnoDB engine), because they are from the Maria Theresa ages (MySQL 4.x). If you need to use InnoDB (like I do), copy e.g. my-huge.cnf or my.innodb-heavy-4G.cnf to my.cnf:

zone0 5.1 # cp my-huge.cnf my.cnf

Now find lines:

# Uncomment the following if you are using InnoDB tables

and uncomment them. This is the most important step - make sure you delete / comment / wipe and forget the following line:

innodb_log_arch_dir = /var/mysql/5.1/data/

because this is a reason why MySQL will keep restarting and fail into maintenence. And another reason why InnoDB plugin will refuse to start is its logs. This is what helped me - comment / remove / whatever the following lines in my.cnf:

innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M

and then delete the logfiles in /var/mysql/5.1/data/:

zone0 5.1 # rm /var/mysql/5.1/data/ib_logfile*

Optionally add MySQL error log and disable binlog if you don't need it:

Error log - add this line to the [mysqld] section of my.cnf:

log-error = /var/svc/log/application-database-mysql:version_51.err

and make sure it is writable for mysql.

To disable binlog delete / comment out the following lines in my.cnf:

log-bin=mysql-bin
binlog_format=mixed

Finally run the upgrade process:

zone0 ~ # /usr/mysql/5.1/bin/mysql_upgrade -u root -p

Try to run the database and check logs for messages:

zone0 ~ # svcadm enable svc:/application/database/mysql:version_51

Update all zones

for z in zone0 zone1 zone2 zone3 zone4
do
    zoneadm -z ${z} detach
    zoneadm -z ${z} attach -u
done

Once one of my zones just failed to upgrade during the process. If so, follow http://voyager-eng.livejournal.com/2446.html, it solved the problem.

Check your zones

As Maverck's blog says:

"You may want to boot your zones and check, if they run properly, before going for the final upgrade."

Mine worked as a charm :)

Update OpenSolaris build 134 to OpenIndiana

Simply follow the steps described at OpenIndiana wiki http://wiki.openindiana.org/oi/Upgrading+from+OpenSolaris.

Update all zones in OpenIndiana - not "The Standard Way"

Okay, this is the tricky part. Simple zone upgrade like described a few steps above will fail with message:

ERROR: Could not update attaching zone Result: Attach Failed.

Solution to this problem is described at blog o' less:

If you are lazy to read, you can just use this fragment of code:

zoneadm -z zonename halt
pkg -R /zones/zonename/root image-update -v
Previous

Contact

Tell us!
Menu

Items marked with * are required