milestone: mysql charm now works

Wed Oct 3 06:30:17 UTC 2012

Even changing from flavor=distro to flavor=percona and back again works! 

ubuntu at ip-10-72-254-179:~$ tail -f /var/log/juju/unit-mysql-0.log
2012/10/03 06:22:38 JUJU HOOK Setting up libaio1 (0.3.109-2ubuntu1) ...
2012/10/03 06:22:39 JUJU HOOK Setting up percona-server-common-5.5 (5.5.27-rel28.1-296.precise) ...
2012/10/03 06:22:39 JUJU HOOK Setting up percona-server-client-5.5 (5.5.27-rel28.1-296.precise) ...
2012/10/03 06:22:39 JUJU HOOK Setting up percona-server-server-5.5 (5.5.27-rel28.1-296.precise) ...
2012/10/03 06:22:39 JUJU HOOK Installing new version of config file /etc/mysql/debian-start ...
2012/10/03 06:22:39 JUJU HOOK * Stopping MySQL (Percona Server) mysqld
2012/10/03 06:22:39 JUJU HOOK ...done.
2012/10/03 06:22:47 JUJU HOOK 121003 6:22:47 [Note] Flashcache bypass: disabled
2012/10/03 06:22:47 JUJU HOOK 121003 6:22:47 [Note] Flashcache setup error is : setmntent failed
2012/10/03 06:22:47 JUJU HOOK
2012/10/03 06:23:12 JUJU HOOK * Starting MySQL (Percona Server) database server mysqld
2012/10/03 06:23:16 JUJU HOOK ...done.
2012/10/03 06:23:16 JUJU HOOK * Checking for corrupt, not cleanly closed and upgrade needing tables.
2012/10/03 06:23:16 JUJU HOOK Setting up percona-server-server (5.5.27-rel28.1-296.precise) ...
2012/10/03 06:23:16 JUJU HOOK Processing triggers for libc-bin ...
2012/10/03 06:23:16 JUJU HOOK ldconfig deferred processing now taking place
2012/10/03 06:23:18 JUJU mysql/0: dataset size in bytes: 1375731712
2012/10/03 06:23:18 JUJU hook succeeded
2012/10/03 06:23:18 JUJU hook complete
2012/10/03 06:23:49 JUJU running hook "config-changed"
2012/10/03 06:23:53 JUJU HOOK Preconfiguring packages ...
2012/10/03 06:23:53 JUJU HOOK (Reading database ... 26876 files and directories currently installed.)
2012/10/03 06:23:53 JUJU HOOK Removing percona-server-server ...
2012/10/03 06:23:53 JUJU HOOK Removing percona-server-server-5.5 ...
2012/10/03 06:23:54 JUJU HOOK * Stopping MySQL (Percona Server) mysqld
2012/10/03 06:23:56 JUJU HOOK ...done.
2012/10/03 06:23:56 JUJU HOOK Removing percona-server-client-5.5 ...
2012/10/03 06:23:56 JUJU HOOK Removing percona-server-common-5.5 ...
2012/10/03 06:23:57 JUJU HOOK Processing triggers for ureadahead ...
2012/10/03 06:23:57 JUJU HOOK Processing triggers for man-db ...
2012/10/03 06:23:58 JUJU HOOK Selecting previously unselected package mysql-common.
2012/10/03 06:23:58 JUJU HOOK (Reading database ... 26625 files and directories currently installed.)
2012/10/03 06:23:58 JUJU HOOK Unpacking mysql-common (from .../mysql-common_5.5.24-0ubuntu0.12.04.1_all.deb) ...
2012/10/03 06:23:58 JUJU HOOK Selecting previously unselected package mysql-client-core-5.5.
2012/10/03 06:23:58 JUJU HOOK Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb) ...
2012/10/03 06:23:59 JUJU HOOK Selecting previously unselected package mysql-client-5.5.
2012/10/03 06:23:59 JUJU HOOK Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb) ...
2012/10/03 06:24:00 JUJU HOOK Selecting previously unselected package mysql-server-core-5.5.
2012/10/03 06:24:00 JUJU HOOK Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb) ...
2012/10/03 06:24:02 JUJU HOOK Processing triggers for man-db ...
2012/10/03 06:24:04 JUJU HOOK Setting up mysql-common (5.5.24-0ubuntu0.12.04.1) ...
2012/10/03 06:24:04 JUJU HOOK Selecting previously unselected package mysql-server-5.5.
2012/10/03 06:24:04 JUJU HOOK (Reading database ... 26770 files and directories currently installed.)
2012/10/03 06:24:04 JUJU HOOK Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb) ...
2012/10/03 06:24:04 JUJU HOOK * Stopping MySQL (Percona Server) mysqld
2012/10/03 06:24:05 JUJU HOOK ...done.
2012/10/03 06:24:05 JUJU HOOK Obsolete conffile /etc/init.d/mysql has been modified by you, renaming to .dpkg-bak
2012/10/03 06:24:07 JUJU HOOK Selecting previously unselected package mysql-server.
2012/10/03 06:24:07 JUJU HOOK Unpacking mysql-server (from .../mysql-server_5.5.24-0ubuntu0.12.04.1_all.deb) ...
2012/10/03 06:24:07 JUJU HOOK Processing triggers for man-db ...
2012/10/03 06:24:09 JUJU HOOK Processing triggers for ureadahead ...
2012/10/03 06:24:09 JUJU HOOK Setting up mysql-client-core-5.5 (5.5.24-0ubuntu0.12.04.1) ...
2012/10/03 06:24:09 JUJU HOOK Setting up mysql-client-5.5 (5.5.24-0ubuntu0.12.04.1) ...
2012/10/03 06:24:09 JUJU HOOK Setting up mysql-server-core-5.5 (5.5.24-0ubuntu0.12.04.1) ...
2012/10/03 06:24:09 JUJU HOOK Setting up mysql-server-5.5 (5.5.24-0ubuntu0.12.04.1) ...
2012/10/03 06:24:09 JUJU HOOK Installing new version of config file /etc/mysql/debian-start ...
2012/10/03 06:24:45 JUJU HOOK mysql start/running, process 10066
2012/10/03 06:24:45 JUJU HOOK Setting up mysql-server (5.5.24-0ubuntu0.12.04.1) ...
2012/10/03 06:24:47 JUJU mysql/0: dataset size in bytes: 1375731712
2012/10/03 06:24:47 JUJU hook succeeded
2012/10/03 06:24:47 JUJU hook complete

On Wednesday, 3 October 2012 at 4:13 PM, David Cheney wrote:

> Hello 
> 
> After some hacking this afternoon I have got the mysql charm working.
> 
> lucky(~/src/launchpad.net/juju-core (http://launchpad.net/juju-core)) % juju ssh 1 'tail -n20 /var/log/juju/unit*'
> 2012/10/03 06:05:18 JUJU HOOK Setting up mysql-server-5.5 (5.5.24-0ubuntu0.12.04.1) ...
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 [Note] Plugin 'FEDERATED' is disabled.
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 InnoDB: The InnoDB memory heap is disabled
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 InnoDB: Compressed tables use zlib 1.2.3.4
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 InnoDB: Initializing buffer pool, size = 128.0M
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 InnoDB: Completed initialization of buffer pool
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 InnoDB: highest supported file format is Barracuda.
> 2012/10/03 06:05:23 JUJU HOOK 121003 6:05:23 InnoDB: Waiting for the background threads to start
> 2012/10/03 06:05:24 JUJU HOOK 121003 6:05:24 InnoDB: 1.1.8 started; log sequence number 1595675
> 2012/10/03 06:05:24 JUJU HOOK 121003 6:05:24 InnoDB: Starting shutdown...
> 2012/10/03 06:05:24 JUJU HOOK 121003 6:05:24 InnoDB: Shutdown completed; log sequence number 1595675
> 2012/10/03 06:05:32 JUJU HOOK mysql start/running, process 6485
> 2012/10/03 06:05:33 JUJU HOOK Setting up libhtml-template-perl (2.10-1) ...
> 2012/10/03 06:05:33 JUJU HOOK Setting up mysql-server (5.5.24-0ubuntu0.12.04.1) ...
> 2012/10/03 06:05:34 JUJU mysql/0: dataset size in bytes: 1375731712
> 2012/10/03 06:05:37 JUJU HOOK mysql stop/waiting
> 2012/10/03 06:05:39 JUJU HOOK mysql start/running, process 6580
> 2012/10/03 06:05:39 JUJU hook succeeded
> 2012/10/03 06:05:39 JUJU hook complete
> Connection to ec2-23-22-53-170.compute-1.amazonaws.com (http://ec2-23-22-53-170.compute-1.amazonaws.com) closed.
> 
> 
> 
> Gustavo: with reference to our discussion earlier, I altered jujuc config-get to merge the charm defaults with any settings present, which makes the charm happy, but is clearly just a 5 minute hack. As you said, the proper fix cannot be attempted over IRC and a 12 hour time delay.
> 
> Branches: https://code.launchpad.net/~dave-cheney/juju-core/011-crackful-juju-experiment
> Prereqs: https://code.launchpad.net/~rogpeppe/gnuflag/support-equals 
> 
> Next up: juju expose mysql, which doesn't currently expose mysql.
> 
> Dave 
> 
> 
> 
> -- 
> Juju-dev mailing list
> Juju-dev at lists.ubuntu.com (mailto:Juju-dev at lists.ubuntu.com)
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju-dev