Skip to content

Instantly share code, notes, and snippets.

@cp16net
Created July 24, 2015 07:39
Show Gist options
  • Select an option

  • Save cp16net/12db3f8544c8b604903a to your computer and use it in GitHub Desktop.

Select an option

Save cp16net/12db3f8544c8b604903a to your computer and use it in GitHub Desktop.
the mysql/mysql.* files are NEVER updated...
2015-07-24 07:28:58.054 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Preparing Guest as MySQL Server.
2015-07-24 07:29:00.086 DEBUG trove.guestagent.pkg [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Package percona-xtradb-cluster-server already installed. from (pid=922) pkg_is_installed /home/ubuntu/trove/trove/guestagent/pkg.py:395
2015-07-24 07:29:00.145 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Starting MySQL.
2015-07-24 07:29:00.176 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Enabling MySQL on boot. from (pid=922) _enable_mysql_on_boot /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:754
2015-07-24 07:29:00.210 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo update-rc.d mysql defaults; sudo update-rc.d mysql enable from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:29:06.321 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo update-rc.d mysql defaults; sudo update-rc.d mysql enable" returned: 0 in 6.110s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:29:06.393 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo service mysql start from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:29:07.881 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:29:17.884 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:29:27.228 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo service mysql start" returned: 0 in 20.830s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:29:27.853 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:29:30.465 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Waiting for DB status to change to running. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:144
2015-07-24 07:29:30.534 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo /usr/bin/mysqladmin ping from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:29:34.152 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo /usr/bin/mysqladmin ping" returned: 0 in 3.596s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:29:34.391 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] MySQL Service Status is RUNNING.
2015-07-24 07:29:34.509 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB status was running after 3 seconds. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:147
2015-07-24 07:29:34.565 DEBUG trove.guestagent.datastore.mysql.manager [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] start handling the device volume from (pid=922) prepare /home/ubuntu/trove/trove/guestagent/datastore/mysql/manager.py:126
2015-07-24 07:29:34.588 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Stopping MySQL.
2015-07-24 07:29:34.652 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo service mysql stop from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:29:38.061 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:29:38.501 INFO trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:29:47.959 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:29:57.872 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:30:02.837 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo service mysql stop" returned: 0 in 28.183s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:05.988 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Waiting for DB status to change to shutdown. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:144
2015-07-24 07:30:06.064 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo /usr/bin/mysqladmin ping from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:07.906 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:30:08.485 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo /usr/bin/mysqladmin ping" returned: 1 in 2.421s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:08.534 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] u'sudo /usr/bin/mysqladmin ping' failed. Not Retrying. from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:308
2015-07-24 07:30:08.598 ERROR trove.common.utils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Command 'sudo /usr/bin/mysqladmin ping' failed. Exit code: 1
stderr: /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
stdout:
2015-07-24 07:30:08.642 ERROR trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Failed to get database status.
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service Traceback (most recent call last):
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 173, in _get_actual_db_status
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service log_output_on_error=True)
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/common/utils.py", line 223, in execute_with_timeout
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service return execute(*args, **kwargs)
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py", line 275, in execute
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service cmd=sanitized_cmd)
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service ProcessExecutionError: Unexpected error while running command.
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service Command: sudo /usr/bin/mysqladmin ping
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service Exit code: 1
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service Stdout: u''
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service Stderr: u"\x07/usr/bin/mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!\n"
2015-07-24 07:30:08.642 TRACE trove.guestagent.datastore.mysql.service
2015-07-24 07:30:08.889 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): /bin/ps -C mysqld h from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:10.035 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "/bin/ps -C mysqld h" returned: 1 in 1.141s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:10.096 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] u'/bin/ps -C mysqld h' failed. Not Retrying. from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:308
2015-07-24 07:30:10.171 ERROR trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Process execution failed.
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service Traceback (most recent call last):
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 180, in _get_actual_db_status
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service "mysqld", "h")
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/common/utils.py", line 223, in execute_with_timeout
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service return execute(*args, **kwargs)
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py", line 275, in execute
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service cmd=sanitized_cmd)
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service ProcessExecutionError: Unexpected error while running command.
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service Command: /bin/ps -C mysqld h
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service Exit code: 1
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service Stdout: u''
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service Stderr: u''
2015-07-24 07:30:10.171 TRACE trove.guestagent.datastore.mysql.service
2015-07-24 07:30:10.392 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo /usr/sbin/mysqld --print-defaults from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:13.289 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo /usr/sbin/mysqld --print-defaults" returned: 0 in 2.896s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:13.352 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] MySQL Service Status is SHUTDOWN.
2015-07-24 07:30:13.371 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB status was shutdown after 3 seconds. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:147
2015-07-24 07:30:13.399 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): grep /dev/vdb /etc/mtab | awk '{print $2}' from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:14.265 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "grep /dev/vdb /etc/mtab | awk '{print $2}'" returned: 0 in 0.844s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:14.400 INFO trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Device /dev/vdb is already mounted in . Unmounting now.
2015-07-24 07:30:14.486 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Checking if /dev/vdb exists. from (pid=922) _check_device_exists /home/ubuntu/trove/trove/guestagent/volume.py:61
2015-07-24 07:30:14.553 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo blockdev --getsize64 /dev/vdb from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:15.511 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo blockdev --getsize64 /dev/vdb" returned: 0 in 0.957s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:15.559 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Formatting /dev/vdb. Executing: sudo mkfs -t ext3 -m 5 /dev/vdb. from (pid=922) _format /home/ubuntu/trove/trove/guestagent/volume.py:98
2015-07-24 07:30:17.997 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:30:18.124 INFO trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:30:19.358 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Checking whether /dev/vdb is formated: sudo dumpe2fs /dev/vdb. from (pid=922) _check_format /home/ubuntu/trove/trove/guestagent/volume.py:74
2015-07-24 07:30:20.105 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Will mount /dev/vdb at /mnt/volume. from (pid=922) mount /home/ubuntu/trove/trove/guestagent/volume.py:112
2015-07-24 07:30:20.152 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo mkdir -p /mnt/volume from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:20.586 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo mkdir -p /mnt/volume" returned: 0 in 0.435s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:20.612 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Mounting volume. Device path:/dev/vdb, mount_point:/mnt/volume, volume_type:ext3, mount options:defaults,noatime from (pid=922) mount /home/ubuntu/trove/trove/guestagent/volume.py:190
2015-07-24 07:30:21.348 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo rsync --safe-links --perms --recursive --owner --group --xattrs --sparse /var/lib/mysql/ /mnt/volume from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:24.858 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo rsync --safe-links --perms --recursive --owner --group --xattrs --sparse /var/lib/mysql/ /mnt/volume" returned: 0 in 3.512s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:25.794 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Will mount /dev/vdb at /var/lib/mysql. from (pid=922) mount /home/ubuntu/trove/trove/guestagent/volume.py:112
2015-07-24 07:30:25.812 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Mounting volume. Device path:/dev/vdb, mount_point:/var/lib/mysql, volume_type:ext3, mount options:defaults,noatime from (pid=922) mount /home/ubuntu/trove/trove/guestagent/volume.py:190
2015-07-24 07:30:26.584 DEBUG trove.guestagent.volume [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Writing new line to fstab:/dev/vdb /var/lib/mysql ext3 defaults,noatime 0 0 from (pid=922) write_to_fstab /home/ubuntu/trove/trove/guestagent/volume.py:201
2015-07-24 07:30:27.788 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo install -o root -g root -m 644 /tmp/tmpagXgtR /etc/fstab from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:27.884 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:30:28.282 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo install -o root -g root -m 644 /tmp/tmpagXgtR /etc/fstab" returned: 0 in 0.494s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:28.298 DEBUG trove.guestagent.datastore.mysql.manager [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Mounted the volume. from (pid=922) prepare /home/ubuntu/trove/trove/guestagent/datastore/mysql/manager.py:138
2015-07-24 07:30:28.312 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Starting MySQL.
2015-07-24 07:30:28.324 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Enabling MySQL on boot. from (pid=922) _enable_mysql_on_boot /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:754
2015-07-24 07:30:28.338 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo update-rc.d mysql defaults; sudo update-rc.d mysql enable from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:30.117 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo update-rc.d mysql defaults; sudo update-rc.d mysql enable" returned: 0 in 1.779s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:30.146 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo service mysql start from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:34.577 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo service mysql start" returned: 0 in 4.428s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:37.731 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Waiting for DB status to change to running. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:144
2015-07-24 07:30:37.761 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo /usr/bin/mysqladmin ping from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:37.927 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:30:38.443 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo /usr/bin/mysqladmin ping" returned: 0 in 0.682s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:38.467 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] MySQL Service Status is RUNNING.
2015-07-24 07:30:38.477 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB status was running after 3 seconds. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:147
2015-07-24 07:30:38.491 DEBUG trove.guestagent.datastore.mysql.manager [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] cluster_config exists with: {u'instance_type': u'member', u'id': u'45126ea1-7cce-436c-9597-33f67ce09b1d'} from (pid=922) prepare /home/ubuntu/trove/trove/guestagent/datastore/mysql/manager.py:144
2015-07-24 07:30:38.501 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Casting set_status message to conductor. from (pid=922) set_status /home/ubuntu/trove/trove/guestagent/datastore/service.py:107
2015-07-24 07:30:38.564 DEBUG trove.conductor.api [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Making async call to cast heartbeat for instance: e370a2db-4dd3-4730-90c9-294739cae71b from (pid=922) heartbeat /home/ubuntu/trove/trove/conductor/api.py:48
2015-07-24 07:30:38.630 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Successfully cast set_status. from (pid=922) set_status /home/ubuntu/trove/trove/guestagent/datastore/service.py:116
2015-07-24 07:30:38.641 DEBUG trove.guestagent.datastore.mysql.manager [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Securing MySQL now. from (pid=922) prepare /home/ubuntu/trove/trove/guestagent/datastore/mysql/manager.py:146
2015-07-24 07:30:38.653 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Generating admin password.
2015-07-24 07:30:38.677 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:39.231 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.552s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:39.255 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:639
2015-07-24 07:30:39.266 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:641
2015-07-24 07:30:39.298 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:641
2015-07-24 07:30:39.322 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Removing expired password. from (pid=922) clear_expired_password /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:86
2015-07-24 07:30:39.334 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo cat /root/.mysql_secret from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:39.777 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo cat /root/.mysql_secret" returned: 1 in 0.443s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:39.799 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] u'sudo cat /root/.mysql_secret' failed. Not Retrying. from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:308
2015-07-24 07:30:39.813 ERROR trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] /root/.mysql_secret does not exist.
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service Traceback (most recent call last):
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 90, in clear_expired_password
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service run_as_root=True, root_helper="sudo")
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py", line 275, in execute
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service cmd=sanitized_cmd)
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service ProcessExecutionError: Unexpected error while running command.
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service Command: sudo cat /root/.mysql_secret
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service Exit code: 1
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service Stdout: u''
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service Stderr: u'cat: /root/.mysql_secret: No such file or directory\n'
2015-07-24 07:30:39.813 TRACE trove.guestagent.datastore.mysql.service
2015-07-24 07:30:40.453 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] SELECT DATABASE()
2015-07-24 07:30:40.467 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:40.553 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] SHOW VARIABLES LIKE 'character_set%%'
2015-07-24 07:30:40.565 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:40.624 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] SHOW VARIABLES LIKE 'sql_mode'
2015-07-24 07:30:40.642 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:40.673 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] BEGIN (implicit)
2015-07-24 07:30:40.691 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DELETE FROM mysql.user WHERE User = '';
2015-07-24 07:30:40.707 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:40.746 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] removed anon user from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:649
2015-07-24 07:30:40.763 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] wtf is this _create_admin_user? GRANT ALL PRIVILEGES ON *.* TO `os_admin`@`localhost` IDENTIFIED BY 'm8XytdszxPFqps7JHkTAYkC9VqURexKHCsfF' WITH GRANT OPTION; from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:596
2015-07-24 07:30:40.776 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] GRANT ALL PRIVILEGES ON *.* TO `os_admin`@`localhost` IDENTIFIED BY 'm8XytdszxPFqps7JHkTAYkC9VqURexKHCsfF' WITH GRANT OPTION;
2015-07-24 07:30:40.787 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:40.826 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] select * from mysql.user;
2015-07-24 07:30:40.837 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:40.869 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] admin exist? <sqlalchemy.engine.result.ResultProxy object at 0x7f5f723ea050> from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:599
2015-07-24 07:30:40.883 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:601
2015-07-24 07:30:40.893 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('devstack1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:601
2015-07-24 07:30:40.907 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('127.0.0.1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:601
2015-07-24 07:30:40.918 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('::1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:601
2015-07-24 07:30:40.931 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'debian-sys-maint', '*F26C6877ABEA9AB116FBA446A5A78CDF92D7F2EB', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', '', '', '', '', 0L, 0L, 0L, 0L, '', None) from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:601
2015-07-24 07:30:40.940 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'os_admin', '*3F9CFC7E394E9ABDED409D720DBB3B9919E171FB', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', None) from (pid=922) _create_admin_user /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:601
2015-07-24 07:30:40.950 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] created admin user/pass from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:651
2015-07-24 07:30:40.960 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] have a transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:214
2015-07-24 07:30:40.968 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] flushing transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:220
2015-07-24 07:30:40.979 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] FLUSH PRIVILEGES;
2015-07-24 07:30:40.992 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:41.020 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] commiting transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:222
2015-07-24 07:30:41.035 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] COMMIT
2015-07-24 07:30:41.050 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] closing transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:224
2015-07-24 07:30:41.063 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] done with transaction exiting from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:226
2015-07-24 07:30:41.076 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] BEGIN (implicit)
2015-07-24 07:30:41.091 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] checking admin user/pass set from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:653
2015-07-24 07:30:41.106 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] select * from mysql.user;
2015-07-24 07:30:41.121 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:41.149 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] admin exist? <sqlalchemy.engine.result.ResultProxy object at 0x7f5f723ea0d0> from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:655
2015-07-24 07:30:41.160 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:657
2015-07-24 07:30:41.178 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('devstack1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:657
2015-07-24 07:30:41.187 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('127.0.0.1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:657
2015-07-24 07:30:41.202 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('::1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:657
2015-07-24 07:30:41.220 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'debian-sys-maint', '*F26C6877ABEA9AB116FBA446A5A78CDF92D7F2EB', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', '', '', '', '', 0L, 0L, 0L, 0L, '', None) from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:657
2015-07-24 07:30:41.237 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'os_admin', '*3F9CFC7E394E9ABDED409D720DBB3B9919E171FB', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', None) from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:657
2015-07-24 07:30:41.249 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] have a transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:214
2015-07-24 07:30:41.260 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] flushing transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:220
2015-07-24 07:30:41.272 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] FLUSH PRIVILEGES;
2015-07-24 07:30:41.282 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:30:41.309 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] commiting transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:222
2015-07-24 07:30:41.325 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] COMMIT
2015-07-24 07:30:41.368 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] closing transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:224
2015-07-24 07:30:41.382 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] done with transaction exiting from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:226
2015-07-24 07:30:41.393 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:41.979 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.585s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:42.004 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:663
2015-07-24 07:30:42.018 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:665
2015-07-24 07:30:42.067 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:665
2015-07-24 07:30:42.079 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Stopping MySQL.
2015-07-24 07:30:42.090 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo service mysql stop from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:47.914 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:30:49.784 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo service mysql stop" returned: 0 in 7.694s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:52.806 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Waiting for DB status to change to shutdown. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:144
2015-07-24 07:30:52.822 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo /usr/bin/mysqladmin ping from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:53.443 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo /usr/bin/mysqladmin ping" returned: 1 in 0.620s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:53.470 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] u'sudo /usr/bin/mysqladmin ping' failed. Not Retrying. from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:308
2015-07-24 07:30:53.488 ERROR trove.common.utils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Command 'sudo /usr/bin/mysqladmin ping' failed. Exit code: 1
stderr: /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
stdout:
2015-07-24 07:30:53.504 ERROR trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Failed to get database status.
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service Traceback (most recent call last):
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 173, in _get_actual_db_status
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service log_output_on_error=True)
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/common/utils.py", line 223, in execute_with_timeout
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service return execute(*args, **kwargs)
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py", line 275, in execute
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service cmd=sanitized_cmd)
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service ProcessExecutionError: Unexpected error while running command.
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service Command: sudo /usr/bin/mysqladmin ping
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service Exit code: 1
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service Stdout: u''
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service Stderr: u"\x07/usr/bin/mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!\n"
2015-07-24 07:30:53.504 TRACE trove.guestagent.datastore.mysql.service
2015-07-24 07:30:53.539 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): /bin/ps -C mysqld h from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:53.806 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "/bin/ps -C mysqld h" returned: 1 in 0.266s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:53.849 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] u'/bin/ps -C mysqld h' failed. Not Retrying. from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:308
2015-07-24 07:30:53.864 ERROR trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Process execution failed.
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service Traceback (most recent call last):
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 180, in _get_actual_db_status
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service "mysqld", "h")
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/common/utils.py", line 223, in execute_with_timeout
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service return execute(*args, **kwargs)
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py", line 275, in execute
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service cmd=sanitized_cmd)
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service ProcessExecutionError: Unexpected error while running command.
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service Command: /bin/ps -C mysqld h
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service Exit code: 1
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service Stdout: u''
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service Stderr: u''
2015-07-24 07:30:53.864 TRACE trove.guestagent.datastore.mysql.service
2015-07-24 07:30:53.893 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo /usr/sbin/mysqld --print-defaults from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:54.862 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo /usr/sbin/mysqld --print-defaults" returned: 0 in 0.964s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:54.972 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] MySQL Service Status is SHUTDOWN.
2015-07-24 07:30:54.993 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB status was shutdown after 3 seconds. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:147
2015-07-24 07:30:55.013 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] stopped db from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:668
2015-07-24 07:30:55.027 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:55.663 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.636s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:55.687 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:674
2015-07-24 07:30:55.702 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:676
2015-07-24 07:30:55.735 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:676
2015-07-24 07:30:55.754 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Writing my.cnf templates.
2015-07-24 07:30:55.765 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:56.226 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.459s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:56.249 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:884
2015-07-24 07:30:56.260 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:886
2015-07-24 07:30:56.297 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:886
2015-07-24 07:30:56.312 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:56.803 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.490s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:56.825 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:895
2015-07-24 07:30:56.840 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:897
2015-07-24 07:30:56.886 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:897
2015-07-24 07:30:56.915 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo mv /tmp/my.cnf.tmp /etc/mysql/my.cnf from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:57.366 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo mv /tmp/my.cnf.tmp /etc/mysql/my.cnf" returned: 0 in 0.451s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:57.391 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:57.935 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:30:57.966 INFO trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:30:57.988 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.597s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:58.006 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:909
2015-07-24 07:30:58.020 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:911
2015-07-24 07:30:58.057 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:911
2015-07-24 07:30:58.074 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:58.663 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.588s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:58.697 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:921
2015-07-24 07:30:58.709 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:923
2015-07-24 07:30:58.748 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:923
2015-07-24 07:30:58.763 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo mv /tmp/my.cnf.tmp /etc/mysql/my.cnf from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:59.269 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo mv /tmp/my.cnf.tmp /etc/mysql/my.cnf" returned: 0 in 0.505s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:59.289 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:30:59.811 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.522s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:30:59.857 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:931
2015-07-24 07:30:59.868 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:933
2015-07-24 07:30:59.907 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:933
2015-07-24 07:30:59.919 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:00.463 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.543s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:00.484 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:943
2015-07-24 07:31:00.495 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:945
2015-07-24 07:31:00.544 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:945
2015-07-24 07:31:00.562 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Wiping ib_logfiles.
2015-07-24 07:31:00.576 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo rm -f -R /var/lib/mysql/ib_logfile0 from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:01.043 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo rm -f -R /var/lib/mysql/ib_logfile0" returned: 0 in 0.466s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:01.071 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo rm -f -R /var/lib/mysql/ib_logfile1 from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:01.543 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo rm -f -R /var/lib/mysql/ib_logfile1" returned: 0 in 0.446s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:01.562 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:02.105 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.542s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:02.147 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:953
2015-07-24 07:31:02.159 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:955
2015-07-24 07:31:02.189 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:955
2015-07-24 07:31:02.204 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Writing new temp overrides.cnf file.
2015-07-24 07:31:02.217 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Moving overrides.cnf into correct location.
2015-07-24 07:31:02.231 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo mv /tmp/overrides.cnf.tmp /etc/mysql/conf.d/overrides.cnf from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:02.684 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo mv /tmp/overrides.cnf.tmp /etc/mysql/conf.d/overrides.cnf" returned: 0 in 0.451s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:02.702 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Setting permissions on overrides.cnf.
2015-07-24 07:31:02.743 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo chmod -R =064 /etc/mysql/conf.d/overrides.cnf from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:03.220 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo chmod -R =064 /etc/mysql/conf.d/overrides.cnf" returned: 0 in 0.476s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:03.245 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:03.829 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.584s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:03.853 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:965
2015-07-24 07:31:03.864 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:967
2015-07-24 07:31:03.902 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) _write_mycnf /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:967
2015-07-24 07:31:03.916 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] write the mysql config and overrides and all that stuff from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:679
2015-07-24 07:31:03.928 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:04.527 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo ls --time-style=+%d-%m-%Y %H:%M:%S -l /var/lib/mysql/mysql" returned: 0 in 0.599s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:04.547 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] list the details of the mysql/user.* files from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:685
2015-07-24 07:31:04.556 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] total 1008
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8820 24-07-2015 07:30:24 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 db.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 db.MYI
-rw-rw---- 1 mysql mysql 9582 24-07-2015 07:30:24 db.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 event.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 event.MYI
-rw-rw---- 1 mysql mysql 10223 24-07-2015 07:30:24 event.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 func.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 func.MYI
-rw-rw---- 1 mysql mysql 8665 24-07-2015 07:30:24 func.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 24-07-2015 07:30:24 general_log.frm
-rw-rw---- 1 mysql mysql 1120 24-07-2015 07:30:24 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 24-07-2015 07:30:24 help_category.MYI
-rw-rw---- 1 mysql mysql 8700 24-07-2015 07:30:24 help_category.frm
-rw-rw---- 1 mysql mysql 91999 24-07-2015 07:30:24 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 24-07-2015 07:30:24 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8612 24-07-2015 07:30:24 help_keyword.frm
-rw-rw---- 1 mysql mysql 9432 24-07-2015 07:30:24 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 24-07-2015 07:30:24 help_relation.MYI
-rw-rw---- 1 mysql mysql 8630 24-07-2015 07:30:24 help_relation.frm
-rw-rw---- 1 mysql mysql 458728 24-07-2015 07:30:24 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 24-07-2015 07:30:24 help_topic.MYI
-rw-rw---- 1 mysql mysql 8770 24-07-2015 07:30:24 help_topic.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 host.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 host.MYI
-rw-rw---- 1 mysql mysql 9510 24-07-2015 07:30:24 host.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8778 24-07-2015 07:30:24 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 plugin.MYI
-rw-rw---- 1 mysql mysql 8586 24-07-2015 07:30:24 plugin.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 proc.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 proc.MYI
-rw-rw---- 1 mysql mysql 9996 24-07-2015 07:30:24 proc.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8875 24-07-2015 07:30:24 procs_priv.frm
-rw-rw---- 1 mysql mysql 1386 24-07-2015 07:30:24 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 24-07-2015 07:30:24 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8800 24-07-2015 07:30:24 proxies_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 servers.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 servers.MYI
-rw-rw---- 1 mysql mysql 8838 24-07-2015 07:30:24 servers.frm
-rw-rw---- 1 mysql mysql 35 24-07-2015 07:30:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 24-07-2015 07:30:24 slow_log.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 24-07-2015 07:30:24 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8955 24-07-2015 07:30:24 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone.MYI
-rw-rw---- 1 mysql mysql 8636 24-07-2015 07:30:24 time_zone.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 8624 24-07-2015 07:30:24 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8606 24-07-2015 07:30:24 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8686 24-07-2015 07:30:24 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 24-07-2015 07:30:24 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 24-07-2015 07:30:24 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 8748 24-07-2015 07:30:24 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 324 24-07-2015 07:30:24 user.MYD
-rw-rw---- 1 mysql mysql 2048 24-07-2015 07:30:24 user.MYI
-rw-rw---- 1 mysql mysql 10630 24-07-2015 07:30:24 user.frm
from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:687
2015-07-24 07:31:04.586 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:687
2015-07-24 07:31:04.596 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Starting MySQL.
2015-07-24 07:31:04.604 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Enabling MySQL on boot. from (pid=922) _enable_mysql_on_boot /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:754
2015-07-24 07:31:04.614 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo update-rc.d mysql defaults; sudo update-rc.d mysql enable from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:06.559 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo update-rc.d mysql defaults; sudo update-rc.d mysql enable" returned: 0 in 1.944s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:06.579 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo service mysql start from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:07.981 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:31:17.916 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:31:27.968 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:31:38.067 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:31:38.431 INFO trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:31:45.761 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo service mysql start" returned: 0 in 39.181s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:47.944 DEBUG trove.openstack.common.periodic_task [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:31:48.785 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Waiting for DB status to change to running. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:144
2015-07-24 07:31:48.806 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo /usr/bin/mysqladmin ping from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:49.555 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo /usr/bin/mysqladmin ping" returned: 0 in 0.748s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:49.578 INFO trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] MySQL Service Status is RUNNING.
2015-07-24 07:31:49.598 DEBUG trove.guestagent.datastore.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] DB status was running after 3 seconds. from (pid=922) wait_for_real_status_to_change_to /home/ubuntu/trove/trove/guestagent/datastore/service.py:147
2015-07-24 07:31:49.609 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] started mysql up again from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:690
2015-07-24 07:31:49.621 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] BEGIN (implicit)
2015-07-24 07:31:49.636 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] checking admin user/pass set yet again from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:694
2015-07-24 07:31:49.657 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] select * from mysql.user;
2015-07-24 07:31:49.677 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:31:49.713 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] have a transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:214
2015-07-24 07:31:49.733 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] rolling back the transaction : <class 'sqlalchemy.exc.OperationalError'> from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:216
2015-07-24 07:31:49.744 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] closing transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:224
2015-07-24 07:31:49.757 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] done with transaction exiting from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:226
2015-07-24 07:31:49.766 ERROR trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] failed to query mysql
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service Traceback (most recent call last):
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 695, in secure
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service out = client.execute(text("select * from mysql.user;"))
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service params)
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service compiled_sql, distilled_params
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service context)
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service exc_info
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service reraise(type(exception), exception, tb=exc_tb)
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service context)
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in do_execute
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service cursor.execute(statement, parameters)
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service self.errorhandler(self, exc, value)
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service raise errorclass, errorvalue
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service OperationalError: (OperationalError) (2006, 'MySQL server has gone away') 'select * from mysql.user;' ()
2015-07-24 07:31:49.766 TRACE trove.guestagent.datastore.mysql.service
2015-07-24 07:31:49.870 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Running cmd (subprocess): sudo awk /password\t=/{print $3; exit} /etc/mysql/my.cnf from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:230
2015-07-24 07:31:50.428 DEBUG oslo_concurrency.processutils [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] CMD "sudo awk /password\t=/{print $3; exit} /etc/mysql/my.cnf" returned: 0 in 0.557s from (pid=922) execute /usr/local/lib/python2.7/dist-packages/oslo_concurrency/processutils.py:260
2015-07-24 07:31:50.507 ERROR trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] failed to query mysql
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service Traceback (most recent call last):
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 703, in secure
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service with LocalSqlClient(get_engine()) as client:
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 208, in __enter__
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service self.conn = self.engine.connect()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1641, in connect
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return self._connection_cls(self, **kwargs)
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 59, in __init__
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service self.__connection = connection or engine.raw_connection()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1699, in raw_connection
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return self.pool.unique_connection()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 220, in unique_connection
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return _ConnectionFairy(self).checkout()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 431, in __init__
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service rec = self._connection_record = pool._do_get()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 772, in _do_get
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return self._create_connection()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 225, in _create_connection
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return _ConnectionRecord(self)
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in __init__
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service self.connection = self.__connect()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 379, in __connect
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service connection = self.__pool._creator()
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return dialect.connect(*cargs, **cparams)
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 283, in connect
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return self.dbapi.connect(*cargs, **cparams)
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service return Connection(*args, **kwargs)
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service super(Connection, self).__init__(*args, **kwargs2)
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service OperationalError: (OperationalError) (1045, "Access denied for user 'os_admin'@'localhost' (using password: YES)") None None
2015-07-24 07:31:50.507 TRACE trove.guestagent.datastore.mysql.service
2015-07-24 07:31:50.627 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] BEGIN (implicit)
2015-07-24 07:31:50.643 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] checking admin user/pass set yet again from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:714
2015-07-24 07:31:50.657 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] select * from mysql.user;
2015-07-24 07:31:50.669 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:31:50.732 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] admin exist? <sqlalchemy.engine.result.ResultProxy object at 0x7f5f71935990> from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:716
2015-07-24 07:31:50.753 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:718
2015-07-24 07:31:50.764 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('devstack1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:718
2015-07-24 07:31:50.776 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('127.0.0.1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:718
2015-07-24 07:31:50.787 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('::1', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0L, 0L, 0L, 0L, '', '') from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:718
2015-07-24 07:31:50.797 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] row: ('localhost', 'debian-sys-maint', '*F26C6877ABEA9AB116FBA446A5A78CDF92D7F2EB', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', '', '', '', '', 0L, 0L, 0L, 0L, '', None) from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:718
2015-07-24 07:31:50.807 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] have a transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:214
2015-07-24 07:31:50.818 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] flushing transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:220
2015-07-24 07:31:50.848 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] FLUSH PRIVILEGES;
2015-07-24 07:31:50.864 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] ()
2015-07-24 07:31:50.883 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] commiting transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:222
2015-07-24 07:31:50.893 INFO sqlalchemy.engine.base.Engine [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] COMMIT
2015-07-24 07:31:50.907 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] closing transaction from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:224
2015-07-24 07:31:50.922 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] done with transaction exiting from (pid=922) __exit__ /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:226
2015-07-24 07:31:50.934 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] MySQL secure complete. from (pid=922) secure /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:722
2015-07-24 07:31:50.949 DEBUG trove.guestagent.datastore.mysql.manager [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] secure with config_contents and overrides done from (pid=922) prepare /home/ubuntu/trove/trove/guestagent/datastore/mysql/manager.py:148
2015-07-24 07:31:50.959 DEBUG trove.guestagent.datastore.mysql.manager [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] secure remote 3 from (pid=922) prepare /home/ubuntu/trove/trove/guestagent/datastore/mysql/manager.py:162
2015-07-24 07:31:50.969 DEBUG trove.guestagent.datastore.mysql.service [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] securing root from (pid=922) secure_root /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:725
2015-07-24 07:31:50.994 ERROR oslo_messaging.rpc.dispatcher [req-f834790b-8496-4154-81bc-d74dc23dcef0 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Exception during message handling: (OperationalError) (1045, "Access denied for user 'os_admin'@'localhost' (using password: YES)") None None
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher Traceback (most recent call last):
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 142, in _dispatch_and_reply
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher executor_callback))
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 186, in _dispatch
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher executor_callback)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 129, in _do_dispatch
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher result = func(ctxt, **new_args)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/osprofiler/profiler.py", line 105, in wrapper
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return f(*args, **kwargs)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/manager.py", line 163, in prepare
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher app.secure_root(secure_remote_root=True)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 726, in secure_root
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher with LocalSqlClient(get_engine()) as client:
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py", line 208, in __enter__
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher self.conn = self.engine.connect()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1641, in connect
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return self._connection_cls(self, **kwargs)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 59, in __init__
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher self.__connection = connection or engine.raw_connection()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1699, in raw_connection
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return self.pool.unique_connection()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 220, in unique_connection
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return _ConnectionFairy(self).checkout()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 431, in __init__
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher rec = self._connection_record = pool._do_get()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 772, in _do_get
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return self._create_connection()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 225, in _create_connection
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return _ConnectionRecord(self)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in __init__
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher self.connection = self.__connect()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 379, in __connect
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher connection = self.__pool._creator()
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return dialect.connect(*cargs, **cparams)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 283, in connect
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return self.dbapi.connect(*cargs, **cparams)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher return Connection(*args, **kwargs)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher super(Connection, self).__init__(*args, **kwargs2)
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher OperationalError: (OperationalError) (1045, "Access denied for user 'os_admin'@'localhost' (using password: YES)") None None
2015-07-24 07:31:50.994 TRACE oslo_messaging.rpc.dispatcher
2015-07-24 07:31:57.945 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:32:07.945 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:32:17.945 DEBUG trove.openstack.common.periodic_task [-] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:32:17.957 INFO trove.guestagent.datastore.service [-] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:32:27.945 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:32:37.947 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:32:47.947 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:32:57.947 DEBUG trove.openstack.common.periodic_task [-] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:32:57.961 INFO trove.guestagent.datastore.service [-] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:33:07.949 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:33:17.949 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:33:27.950 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:33:37.950 DEBUG trove.openstack.common.periodic_task [-] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:33:37.957 INFO trove.guestagent.datastore.service [-] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:33:47.951 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:33:57.951 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:34:07.969 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:34:17.952 DEBUG trove.openstack.common.periodic_task [-] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:34:17.960 INFO trove.guestagent.datastore.service [-] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:34:27.954 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:34:37.954 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:34:47.956 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:34:57.955 DEBUG trove.openstack.common.periodic_task [-] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:34:57.964 INFO trove.guestagent.datastore.service [-] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:35:07.956 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:35:17.956 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:35:27.957 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:35:37.957 DEBUG trove.openstack.common.periodic_task [-] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:35:37.964 INFO trove.guestagent.datastore.service [-] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
2015-07-24 07:35:47.958 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 3 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:35:57.959 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 2 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:36:07.959 DEBUG trove.openstack.common.periodic_task [-] Skipping Manager.update_status, 1 ticks left until next run from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:100
2015-07-24 07:36:17.960 DEBUG trove.openstack.common.periodic_task [-] Running periodic task Manager.update_status from (pid=922) run_periodic_tasks /home/ubuntu/trove/trove/openstack/common/periodic_task.py:106
2015-07-24 07:36:17.969 INFO trove.guestagent.datastore.service [-] DB server is not installed or is in restart mode, so for now we'll skip determining the status of DB on this instance.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment