Created
May 29, 2012 19:21
-
-
Save rockyburt/2830145 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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