mysql charm fails on local

[Adam Israel]

It may be easier to tear down and re-deploy. In that case:

$ juju destroy-service mysql
(monitor juju status for the service to be removed)
$ juju deploy mysql
$ juju set mysql dataset-size='256M'

At that point, mysql should install successfully.

-- 
Adam Israel
On January 29, 2015 at 12:01:09 PM, saurabh (saurabh.kumar at techblue.co.uk) wrote:

Hi Adam,

Thanks for your reply, I treid the commands you sent me now I am getting this:

unit-mysql-0: 2015-01-29 16:58:13 INFO start stop: Unknown instance:
unit-mysql-0: 2015-01-29 16:58:15 INFO start start: Job failed to start
unit-mysql-0: 2015-01-29 16:58:15 ERROR juju.worker.uniter uniter.go:486 hook failed: exit status 1


Thanks,
Saurabh
On Thursday 29 January 2015 10:24 PM, Adam Israel wrote:
Hi Saurabh,

That’s a known issue with the Mysql charm, under the local provider (documented under Caveats in the README).

To fix the issue once the mysql charm is in an error state:

$ juju set mysql dataset-size='256M'
$ juju resolved mysql/0 —retry

-- 
Adam Israel
On January 29, 2015 at 11:35:00 AM, saurabh (saurabh.kumar at techblue.co.uk) wrote:

Hi,

I was deploying mysql on my local juju environment but it is failing at
config changed hook.
At first I thought it might be some error so I deployed it 3 times and
it failed to start all the three times.
Any pointer on this will be helpful.

here is the log snippet:

===================================================================================

unit-mysql-0: 2015-01-29 16:21:59 INFO config-changed Unpacking
mysql-server (5.5.41-0ubuntu0.14.04.1) ...
unit-mysql-0: 2015-01-29 16:21:59 INFO config-changed Processing
triggers for man-db (2.6.7.1-1ubuntu1) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Processing
triggers for ureadahead (0.100.0-16) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
libaio1:amd64 (0.3.109-4) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
libdbi-perl (1.630-1) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
libdbd-mysql-perl (4.025-1) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
libterm-readkey-perl (2.31-1) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
mysql-client-core-5.5 (5.5.41-0ubuntu0.14.04.1) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
mysql-client-5.5 (5.5.41-0ubuntu0.14.04.1) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
mysql-server-core-5.5 (5.5.41-0ubuntu0.14.04.1) ...
unit-mysql-0: 2015-01-29 16:22:00 INFO config-changed Setting up
mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) ...
unit-mysql-0: 2015-01-29 16:22:04 INFO config-changed 150129 21:52:04
[Warning] Using unique option prefix key_buffer instead of
key_buffer_size is deprecated and will be removed in a future release.
Please use the full name instead.
unit-mysql-0: 2015-01-29 16:22:14 INFO config-changed mysql
start/running, process 2655
unit-mysql-0: 2015-01-29 16:22:14 INFO config-changed Setting up
libhtml-template-perl (2.95-1) ...
unit-mysql-0: 2015-01-29 16:22:14 INFO config-changed Processing
triggers for ureadahead (0.100.0-16) ...
unit-mysql-0: 2015-01-29 16:22:15 INFO config-changed Setting up
mysql-server (5.5.41-0ubuntu0.14.04.1) ...
unit-mysql-0: 2015-01-29 16:22:15 INFO config-changed Processing
triggers for libc-bin (2.19-0ubuntu6.3) ...
unit-mysql-0: 2015-01-29 16:22:16 INFO juju-log dataset size in bytes:
6677331968
unit-mysql-0: 2015-01-29 16:22:19 INFO config-changed mysql stop/waiting
unit-mysql-0: 2015-01-29 16:22:21 INFO config-changed start: Job failed
to start
unit-mysql-0: 2015-01-29 16:22:21 INFO juju-log Restart failed, trying again
unit-mysql-0: 2015-01-29 16:22:21 INFO config-changed stop: Job has
already been stopped: mysql
unit-mysql-0: 2015-01-29 16:22:51 INFO config-changed mysql start/running
unit-mysql-0: 2015-01-29 16:22:52 INFO start mysql stop/waiting
unit-mysql-0: 2015-01-29 16:22:54 INFO start start: Job failed to start
unit-mysql-0: 2015-01-29 16:22:54 ERROR juju.worker.uniter uniter.go:486
hook failed: exit status 1



===================================================================================

Thanks

--
Saurabh Kumar
System Admin



--
Juju mailing list
Juju at lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju

--  
Saurabh Kumar
System Admin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/juju/attachments/20150129/83f8453f/attachment.html>