Skip to content

Instantly share code, notes, and snippets.

@rockyburt
Created May 29, 2012 19:21
Show Gist options
  • Save rockyburt/2830145 to your computer and use it in GitHub Desktop.
Save rockyburt/2830145 to your computer and use it in GitHub Desktop.
stackato@staging:~$ stackato-admin import -i --db-ip 10.83.1.193 -a stackato-20120529-191304-dump.zip
WARNING: THIS WILL WIPE ANY EXISTING DATA YOU CURRENTLY HAVE IN STACKATO!!
This means any existing apps, users, app pushes, services, will be replaced
with the ones in the dump file (according to the options you provided).
The original data will not be recoverable.
ALSO NOTE: If you specified --mysql or --postgres on the command line, this is
a potentially dangerous operation! If you have important data in a local postgresql
install or a local MySQL install, press Ctrl-C and back it up now!!
The following will be restored:
- internal Stackato data
- MySQL DBs
- Postgres DBs
- filesystem service
- all other Stackato DBs
Stackato will be configured to use '10.83.1.193' as the database server's IP.
If you're sure you want to continue, type "Proceed" and press ENTER: Proceed
Stopping Stackato...
cloud_controller : STOPPED
health_manager : STOPPED
router : STOPPED
prealloc : STOPPED
stager : STOPPED
dea : STOPPED
mysql_gateway : STOPPED
mysql_node : STOPPED
postgresql_gateway : STOPPED
postgresql_node : STOPPED
rabbit_gateway : STOPPED
rabbit_node : STOPPED
redis_gateway : STOPPED
redis_node : STOPPED
mongodb_gateway : STOPPED
mongodb_node : STOPPED
filesystem_gateway : STOPPED
Restoring Stackato data...
Extracting dump file...
Restoring main DB...
Couldn't drop cloudcontroller : #<ActiveRecord::StatementInvalid: PG::Error: ERROR: database "cloudcontroller" is being accessed by other users
DETAIL: There are 2 other session(s) using the database.
: DROP DATABASE IF EXISTS "cloudcontroller">
cloudcontroller already exists
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "en_CA.UTF-8",
LC_COLLATE = "en_CA.UTF-8",
LC_MESSAGES = "en_CA.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
BEGIN
ERROR: relation "schema_migrations" already exists
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
Restoring admin users...
The cloud controller must be restarted before admin changes will take effect.
The cloud controller must be restarted before admin changes will take effect.
The cloud controller must be restarted before admin changes will take effect.
Restoring license...
Restoring droplets...
Restoring databases...
[sudo] password for stackato:
Restoring MySQL database... (it's normal to see errors here!!)
ERROR 1050 (42S01) at line 40: Table 'columns_priv' already exists
ERROR 1050 (42S01) at line 67: Table 'db' already exists
ERROR 1050 (42S01) at line 111: Table 'event' already exists
ERROR 1050 (42S01) at line 144: Table 'func' already exists
ERROR 1050 (42S01) at line 168: Table 'help_category' already exists
ERROR 1062 (23000) at line 184: Duplicate entry '1' for key 'PRIMARY'
ERROR 1050 (42S01) at line 194: Table 'help_keyword' already exists
ERROR 1062 (23000) at line 208: Duplicate entry '0' for key 'PRIMARY'
ERROR 1050 (42S01) at line 218: Table 'help_relation' already exists
ERROR 1062 (23000) at line 231: Duplicate entry '0-1' for key 'PRIMARY'
ERROR 1050 (42S01) at line 241: Table 'help_topic' already exists
ERROR 1062 (23000) at line 259: Duplicate entry '0' for key 'PRIMARY'
ERROR 1050 (42S01) at line 269: Table 'host' already exists
ERROR 1050 (42S01) at line 309: Table 'ndb_binlog_index' already exists
ERROR 1050 (42S01) at line 336: Table 'plugin' already exists
ERROR 1050 (42S01) at line 358: Table 'proc' already exists
ERROR 1050 (42S01) at line 398: Table 'procs_priv' already exists
ERROR 1050 (42S01) at line 427: Table 'servers' already exists
ERROR 1050 (42S01) at line 456: Table 'tables_priv' already exists
ERROR 1050 (42S01) at line 485: Table 'time_zone' already exists
ERROR 1050 (42S01) at line 507: Table 'time_zone_leap_second' already exists
ERROR 1050 (42S01) at line 529: Table 'time_zone_name' already exists
ERROR 1050 (42S01) at line 551: Table 'time_zone_transition' already exists
ERROR 1050 (42S01) at line 574: Table 'time_zone_transition_type' already exists
ERROR 1050 (42S01) at line 599: Table 'user' already exists
ERROR 1062 (23000) at line 649: Duplicate entry 'localhost-root' for key 'PRIMARY'
Regenerating the admin database password will require a restart of Stackato MySQL services, proceed? (y/N)
y
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_MESSAGES = "en_CA.UTF-8",
LC_COLLATE = "en_CA.UTF-8",
LC_CTYPE = "en_CA.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_MESSAGES = "en_CA.UTF-8",
LC_COLLATE = "en_CA.UTF-8",
LC_CTYPE = "en_CA.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "en_CA.UTF-8",
LC_COLLATE = "en_CA.UTF-8",
LC_MESSAGES = "en_CA.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
mysql stop/waiting
mysql start/running, process 22732
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_MESSAGES = "en_CA.UTF-8",
LC_COLLATE = "en_CA.UTF-8",
LC_CTYPE = "en_CA.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
mysql_gateway : STOPPED
mysql_node : STOPPED
mysql_gateway : RUNNING
mysql_node : RUNNING
MySQL password reset. Run 'stackato-admin tail mysql' to verify
cloud_controller : STOPPED
health_manager : STOPPED
router : STOPPED
prealloc : STOPPED
stager : STOPPED
dea : STOPPED
mysql_gateway : STOPPED
mysql_node : STOPPED
postgresql_gateway : STOPPED
postgresql_node : STOPPED
rabbit_gateway : STOPPED
rabbit_node : STOPPED
redis_gateway : STOPPED
redis_node : STOPPED
mongodb_gateway : STOPPED
mongodb_node : STOPPED
filesystem_gateway : STOPPED
Restoring Postgres service... (it's normal to see errors here!!)
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "en_CA.UTF-8",
LC_COLLATE = "en_CA.UTF-8",
LC_MESSAGES = "en_CA.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
ERROR: relation "dblink_pkey_results" already exists
ERROR: function "dblink" already exists with same argument types
ERROR: function "dblink" already exists with same argument types
ERROR: function "dblink" already exists with same argument types
ERROR: function "dblink" already exists with same argument types
ERROR: function "dblink_build_sql_delete" already exists with same argument types
ERROR: function "dblink_build_sql_insert" already exists with same argument types
ERROR: function "dblink_build_sql_update" already exists with same argument types
ERROR: function "dblink_cancel_query" already exists with same argument types
ERROR: function "dblink_close" already exists with same argument types
ERROR: function "dblink_close" already exists with same argument types
ERROR: function "dblink_close" already exists with same argument types
ERROR: function "dblink_close" already exists with same argument types
ERROR: function "dblink_connect" already exists with same argument types
ERROR: function "dblink_connect" already exists with same argument types
ERROR: function "dblink_connect_u" already exists with same argument types
ERROR: function "dblink_connect_u" already exists with same argument types
ERROR: function "dblink_current_query" already exists with same argument types
ERROR: function "dblink_disconnect" already exists with same argument types
ERROR: function "dblink_disconnect" already exists with same argument types
ERROR: function "dblink_error_message" already exists with same argument types
ERROR: function "dblink_exec" already exists with same argument types
ERROR: function "dblink_exec" already exists with same argument types
ERROR: function "dblink_exec" already exists with same argument types
ERROR: function "dblink_exec" already exists with same argument types
ERROR: function "dblink_fetch" already exists with same argument types
ERROR: function "dblink_fetch" already exists with same argument types
ERROR: function "dblink_fetch" already exists with same argument types
ERROR: function "dblink_fetch" already exists with same argument types
ERROR: function "dblink_get_connections" already exists with same argument types
ERROR: function "dblink_get_pkey" already exists with same argument types
ERROR: function "dblink_get_result" already exists with same argument types
ERROR: function "dblink_get_result" already exists with same argument types
ERROR: function "dblink_is_busy" already exists with same argument types
ERROR: function "dblink_open" already exists with same argument types
ERROR: function "dblink_open" already exists with same argument types
ERROR: function "dblink_open" already exists with same argument types
ERROR: function "dblink_open" already exists with same argument types
ERROR: function "dblink_send_query" already exists with same argument types
Regenerating the admin database password will require a restart of the Stackato Cloud Controller, Health Manager, and PostgreSQL services, proceed? (y/N)
y
* Starting PostgreSQL 8.4 database server [ OK ]
ALTER ROLE
cloud_controller : STOPPED
health_manager : STOPPED
postgresql_gateway : STOPPED
postgresql_node : STOPPED
cloud_controller : RUNNING
health_manager : RUNNING
postgresql_gateway : RUNNING
postgresql_node : RUNNING
PostgreSQL password reset. Run 'stackato-admin tail postgresql' to verify
cloud_controller : STOPPED
health_manager : STOPPED
router : STOPPED
prealloc : STOPPED
stager : STOPPED
dea : STOPPED
mysql_gateway : STOPPED
mysql_node : STOPPED
postgresql_gateway : STOPPED
postgresql_node : STOPPED
rabbit_gateway : STOPPED
rabbit_node : STOPPED
redis_gateway : STOPPED
redis_node : STOPPED
mongodb_gateway : STOPPED
mongodb_node : STOPPED
filesystem_gateway : STOPPED
Restoring filesystem service...
If your hostname has changed between export and import, you may need to run
stackato-admin remap-hosts <old host> <new host> to remap your applications.
Cleaning up...
stackato@staging:~$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment