Skip to content

Instantly share code, notes, and snippets.

View cp16net's full-sized avatar

Craig Vyvial cp16net

12 followers · 15 following
View GitHub Profile
@cp16net
cp16net / gist:f49b85f3221a977f5046
Created September 30, 2015 21:45
2015-09-30 21:29:03.593 DEBUG trove.db.models [-] Saving DBInstance: {u'cluster_id': None, u'shard_id': None, u'deleted_at': None, u'id': u'cc4db3a8-724c-4dc9-ac48-dd715e43e4ad', u'datastore_version_id': u'b9553196-acdf-4cc3-8aaf-cc044ed13ddb', 'errors': {}, u'hostname': None, u'server_status': None, u'task_description': 'No tasks for the instance.', u'volume_size': 1, u'type': None, u'updated': datetime.datetime(2015, 9, 30, 21, 29, 3, 593510), '_sa_instance_state': <sqlalchemy.orm.state.InstanceState object at 0x7fcf2aa07b50>, u'deleted': 0, u'configuration_id': None, u'volume_id': u'4cad472f-705f-4d1c-824e-3f6efe237bde', u'slave_of_id': None, u'task_start_time': None, u'name': u'test', u'task_id': 1, u'created': datetime.datetime(2015, 9, 30, 21, 28, 55), u'tenant_id': u'1f20a39ef42a4a80918ebfab9f6ceeab', u'compute_instance_id': u'5378fa52-3b0b-45d9-b615-ebad2dd728ff', u'flavor_id': u'7'} from (pid=25233) save /opt/stack/trove/trove/db/models.py:62
2015-09-30 21:29:03.600 DEBUG trove.taskmanager.models [-]
@cp16net
cp16net / gist:1b047f5e366390f5a972
Created September 1, 2015 01:09
#!/bin/bash
while true; do
wget https://cloud-images.ubuntu.com/trusty/current/SHA256SUMS
RETVAL=$?
if [ $RETVAL -eq 0 ]; then
echo "good"
notify-send "image is working again!"
break
else
@cp16net
cp16net / gist:4262ace6c096b6991ebd
Created August 6, 2015 15:37
ubuntu@devstack2:/opt/stack/trove$ redstack int-tests --group=pxc
/opt/stack/trove-integration/scripts /opt/stack/trove
*******************************************************************************
Running Trove Integration Tests...
*******************************************************************************
python -B /opt/stack/trove-integration/scripts/../tests//integration/int_tests.py --verbose --logging-clear-handlers --group=pxc
RUNNING TEST ARGS : ['/opt/stack/trove-integration/scripts/../tests//integration/int_tests.py', '--verbose', '--logging-clear-handlers', '--group=pxc']
nose.config: INFO: Ignoring files matching ['^\\.', '^_', '^setup\\.py$']
nose.plugins.manager: DEBUG: Configuring plugins
nose.plugins.manager: DEBUG: Plugins enabled: [<nose.plugins.capture.Capture object at 0x7f5be2613dd0>, <nose.plugins.logcapture.LogCapture object at 0x7f5be2642910>, <nose.plugins.deprecated.Deprecated object at 0x7f5be2642d90>, <nose.plugins.skip.Skip object at 0x7f5be23863d0>]
@cp16net
cp16net / cluster-operations.sh
Last active August 29, 2015 14:26
ubuntu@devstack1:~$ trove cluster-create pxc55-working percona 5.5 --instance flavor_id=7,volume=1 --instance flavor_id=7,volume=1
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------
@cp16net
cp16net / gist:f9a05bfe4926f4603042
Last active August 29, 2015 14:25
snapshot of processes running on instance
ubuntu@pxc55-fucking-work-member-1:~$ top -b -n1
top - 17:44:18 up 8:57, 1 user, load average: 0.22, 0.19, 0.11
Tasks: 79 total, 1 running, 78 sleeping, 0 stopped, 0 zombie
%Cpu(s): 4.4 us, 1.4 sy, 0.0 ni, 94.2 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem: 501796 total, 488136 used, 13660 free, 34468 buffers
KiB Swap: 0 total, 0 used, 0 free. 303776 cached Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5882 ubuntu 20 0 24812 1376 1036 R 14.9 0.3 0:00.16 top
8 root 20 0 0 0 0 S 5.0 0.0 0:20.62 rcuos/0
@cp16net
cp16net / gist:9031db0e41629575213e
Created July 24, 2015 08:23
it worked!
15-07-24 08:18:30.096 INFO trove.guestagent.datastore.mysql.service [req-4fa4bb42-be47-4a72-9691-8fc4db4167a1 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Preparing Guest as MySQL Server.
2015-07-24 08:18:32.584 DEBUG trove.guestagent.pkg [req-4fa4bb42-be47-4a72-9691-8fc4db4167a1 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Package percona-xtradb-cluster-server already installed. from (pid=929) pkg_is_installed /home/ubuntu/trove/trove/guestagent/pkg.py:395
2015-07-24 08:18:32.688 INFO trove.guestagent.datastore.mysql.service [req-4fa4bb42-be47-4a72-9691-8fc4db4167a1 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Starting MySQL.
2015-07-24 08:18:32.718 DEBUG trove.guestagent.datastore.mysql.service [req-4fa4bb42-be47-4a72-9691-8fc4db4167a1 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Enabling MySQL on boot. from (pid=929) _enable_mysql_on_boot /home/ubuntu/trove/trove/guestagent/datastore/mysql/service.py:780
2015-07-24 08:1
@cp16net
cp16net / trove-guestagent.log
Created July 24, 2015 07:39
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
@cp16net
cp16net / trove-guestagent.log
Created July 24, 2015 04:13
trove-guestagent still fails to keep the grant statement when the configs are moved into place
2015-07-23 20:40:32.018 DEBUG trove.openstack.common.service [-] ******************************************************************************** from (pid=921) log_opt_values /usr/local/lib/python2.7/dist-packages/oslo_config/cfg.py:2229
2015-07-23 20:40:32.044 DEBUG trove.common.rpc.service [-] Creating RPC server for service guestagent from (pid=921) start /home/ubuntu/trove/trove/common/rpc/service.py:54
2015-07-23 20:40:32.889 DEBUG oslo_messaging._drivers.amqp [-] Pool creating new connection from (pid=921) create /usr/local/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqp.py:103
2015-07-23 20:40:33.138 INFO oslo_messaging._drivers.impl_rabbit [-] Connecting to AMQP server on 10.0.0.1:5672
2015-07-23 20:40:34.591 INFO oslo_messaging._drivers.impl_rabbit [-] Connected to AMQP server on 10.0.0.1:5672
2015-07-23 20:40:35.127 DEBUG trove.guestagent.datastore.service [req-c1f9ea81-5438-413d-b73d-f57b5c5e2758 b3e64229a159444cb567fc97b0e514bc f52eda5160fa4751ae8eb85928d13445] Casting set_status message
@cp16net
cp16net / gist:9dba437e7b357f62a4ba
Created July 23, 2015 16:44
150723 06:53:17 mysqld_safe wsrep-recovery has failed to recover, continuing with startup
2015-07-23 06:53:22 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-07-23 06:53:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-07-23 06:53:22 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24-72.2-56) starting as process 4898 ...
2015-07-23 06:53:22 4898 [ERROR] Failed to initialize timer component (errno 12).
2015-07-23 06:53:23 4898 [Note] WSREP: Read nil XID from storage engines, skipping position init
2015-07-23 06:53:23 4898 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
2015-07-23 06:53:23 4898 [Note] WSREP: wsrep_load(): Galera 3.11(r93aca2d) by Codership Oy <info@codership.com> loaded successfully.
2015-07-23 06:53:23 4898 [Note] WSREP: CRC-32C: u
@cp16net
cp16net / Preferences.sublime-settings
Created July 9, 2015 17:14
~/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings
{
"translate_tabs_to_spaces": true,
"trim_trailing_white_space_on_save": true,
"ensure_newline_at_eof_on_save": true,
"rulers": [80],
"save_on_focus_lost": true
}