[Bug 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
I tried using this patch on essex on an environment which got already corrupted, will it only work on new installations? I thought it should fix a corrupted environment? The environment is built from source though and the patch has been applied individually. (I know this is not a normal environment and not suggested, its using devstack to install essex on production envs) This is the error log: http://paste.openstack.org/show/28622/ -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Changed in: nova Milestone: folsom-1 = 2012.2 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Changed in: nova (Ubuntu) Status: In Progress = Fix Released -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
Ran through two verifications, one on a single node virtual instance with mysql and nova-api running locally and another on a live mulit node cluster with running instances and a populated database. Overview of the latter captured here: After deployment and configuration of nova packages 2012.1-0ubuntu2.3. Before upgrade, verification of bug: (...on mysql server) # mysql -u root mysql create database test_nova; mysql grant all privileges on test_nova.* to 'nova'@'localhost' identified by 'nova'; mysql Bye # mysqldump -u nova -p nova nova-backup-1.sql Enter password: # mysql -u nova -p test_nova nova-backup-1.sql Enter password: ERROR 1005 (HY000) at line 1071: Can't create table 'test_nova.projects' (errno: 150) After upgrade, verification of fix: (...on Nova node, precise-proposed enabled.) ~# apt-get upgrade ~# dpkg -l | grep nova-common ii nova-common 2012.1+stable~20120612-3ee026e-0ubuntu1 OpenStack Compute - common files ~# nova-manage db sync 2012-07-02 16:30:00 AUDIT nova.db.sqlalchemy.fix_dns_domains [-] Applying database fix for Essex dns_domains table. (...on mysql server) # mysqldump -u nova -p nova nova-backup-2.sql Enter password: # mysql -u nova -p test_nova nova-backup-2.sql Enter password: The database can be successfully restored from a backup. I've also verified there are no adverse affects post-upgrade in terms of usability of the cloud (instances still spawn, security groups can be created, floating IPs associated, API requests serviced fine, etc) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Tags removed: verification-needed ** Tags added: verification-done -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
This bug was fixed in the package nova - 2012.1+stable~20120612-3ee026e- 0ubuntu1 --- nova (2012.1+stable~20120612-3ee026e-0ubuntu1) precise-proposed; urgency=low * New upstream snapshot. (LP: #1010473) * Dropped, superseeded by new snapshot: - debian/patches/upstream/0001-fix-bug-where-nova-ignores-glance-host-in-imageref.patch - debian/patches/upstream/0002-Stop-libvirt-test-from-deleting-instances-dir.patch - debian/patches/upstream/0003-Allow-unprivileged-RADOS-users-to-access-rbd-volumes.patch - debian/patches/upstream/0004-Fixed-bug-962840-added-a-test-case.patch - debian/patches/upstream/0005-Populate-image-properties-with-project_id-again.patch - debian/patches/upstream/0006-Use-project_id-in-ec2.cloud._format_image.patc - debian/patches/CVE-2012-2101.patch - debian/patches/CVE-2012-2654.patch * Resynchronize with stable/essex: - 3ee026e Only invoke .lower() on non-None protocols. (LP: #1010514) - f0a9f47 Create a utf8 version of the dns_domains table. (LP: #993663) - 84a43e1 Report memory correctly on Xen. (LP: #997014) - 8c72924 Add libvirt get_console_output tests: pty and file. (LP: #990237) - 4e423cd Fix Multi_Scheduler to process host capabilities. (LP: #1000403) - 4aea7f1 Nail pep8 dependencies to 1.0.1 - 2b3bbc4 handle updated qemu-img info output. (LP: #1000261) - 2d7d51c Fix type of snapshot_id column to match db. (LP: #962615) - ec70c69 Generate a Changelog for Nova - e5e890f Fix nova.tests.test_nova_rootwrap on Fedora 17. (LP: #992916) - 9e9a554 Ec2 handle strings with 0x (LP: #983206) - 26dc6b7 QuantumManager will start dnsmasq during startup. Fixes (LP: #977759) - 7028d66 Introduced flag base_dir_name. (LP: #973194) - 76b525a Get unit tests functional in OS X. - facb936 Update KillFilter to handle 'deleted' exe's. (LP: #967931) - 1209af4 Checks if value is string or not before decode. (LP: #952176) - 1209af4 Fix timeout in EC2 CloudController.create_image(). (LP: #989764) - 108e74b Re-add console_log from console_console_output(). (LP: #987335) - 48a0768 Don't leak RPC connections on timeouts or other exceptions. (LP: #968843) - 7c64de9 Cloudpipe tap vpn not always working. (LP: #975043) - 5ab5051 add libvirt_inject_key flag fix (LP: #971640) - 6c68ef5 Xen: Pass session to destroy_vdi. (LP: #988615) - 015744e Delete fixed_ips when network is deleted. (LP: #754900) * Add debian/scripts/changelog.sh to help generate the changelog. * Add debian/nova-common.docs: - Include changelog and README.rst * debian/rules: Generate a tarball from git snapshot. * debian/patches/fix-pep8-errors.patch: Fix pep8 errors due to pep8 upstream migration. -- Chuck Short zul...@ubuntu.com Tue, 05 Jun 2012 09:50:59 -0400 ** Changed in: nova (Ubuntu Precise) Status: Fix Committed = Fix Released ** CVE added: http://www.cve.mitre.org/cgi- bin/cvename.cgi?name=2012-2101 ** CVE added: http://www.cve.mitre.org/cgi- bin/cvename.cgi?name=2012-2654 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Branch linked: lp:ubuntu/precise-updates/nova -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
Hello Dan, or anyone else affected, Accepted nova into precise-proposed. The package will build now and be available in a few hours. Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users. If this package fixes the bug for you please change the bug tag from verification-needed to verification-done. If it does not, change the tag to verification-failed. In either case details of your testing will help us make a better decision. Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance! ** Changed in: nova (Ubuntu Precise) Status: In Progress = Fix Committed ** Tags added: verification-needed -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Branch linked: lp:~ubuntu-branches/ubuntu/precise/nova/precise- proposed -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Changed in: nova/essex Status: Fix Committed = Fix Released -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Also affects: nova/essex Importance: Undecided Status: New ** Changed in: nova/essex Status: New = Fix Committed ** Changed in: nova/essex Milestone: None = 2012.1.1 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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 993663] Re: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8'
** Impact ** Create a utf8 version of the dns_domains table. The old dns_domains table was encoded in the 'latin1' charset and has its primary key length set to 512. This is too long to be a valid pkey in a proper 'utf8' encoded table and seems to cause a slew of errors like: 1) Dumping a database with mysqldump and trying to import it fails because this table is latin1 but fkeys to utf8 tables (projects). 2) Trying to alter the old dns_domains table fails with errors like: mysql ALTER TABLE dns_domains DROP PRIMARY KEY; ERROR 1025 (HY000): Error on rename of './nova/#sql-6cf_855' This patch creates an Essex fix that re-creates the dns_domains table with a shorter 'domain' column which works with the utf8 charset. This database upgrade will run on MySQL databases only which have a dns_domains table with a domain column length of VARCHAR(512). Fixes LP Bug #993663 on Essex. ** Development Fix ** This is fixed in the development trunk at https://review.openstack.org/7139 and in quantal ** Stable Fix ** This is fixed in the stable/essex branch at https://review.openstack.org/8356. ** Test Case ** 1. Make a database backup of the nova database. 2. Drop the nova database. 3. Try to restore the database. ** Regression Impact ** Minimal this has been tested in the openstack-ci lab. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/993663 Title: [SRU] dns_domains table mysql charset is 'latin1'. Should be 'utf8' To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/993663/+subscriptions -- 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
