Unable to use a restore from NodeChef

support
1

Running into the exact same issue with the migrating from the same provider as here, however this topic has closed, so I may as well make a new one, as I’m at my wits’ end trying to fix this.

here’s the log

[2020-08-30 02:34:59] [STARTED]
[2020-08-30 02:34:59] 'username' has started the restore!
[2020-08-30 02:34:59] Marking restore as running...
[2020-08-30 02:34:59] Making sure /var/www/discourse/tmp/restores/default/2020-08-30-023459 exists...
[2020-08-30 02:34:59] Copying archive to tmp directory...
[2020-08-30 02:35:00] Unzipping archive, this may take a while...
[2020-08-30 02:35:01] Extracting dump file...
[2020-08-30 02:35:07] Validating metadata...
[2020-08-30 02:35:07]   Current version: 20200820232017
[2020-08-30 02:35:07]   Restored version: 20191209095548
[2020-08-30 02:35:07] Enabling readonly mode...
[2020-08-30 02:35:07] Pausing sidekiq...
[2020-08-30 02:35:07] Waiting up to 60 seconds for Sidekiq to finish running jobs...
[2020-08-30 02:35:14] Creating missing functions in the discourse_functions schema...
[2020-08-30 02:35:15] Restoring dump file... (this may take a while)
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] set_config
[2020-08-30 02:35:15] ------------
[2020-08-30 02:35:15] (1 row)
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] SET
[2020-08-30 02:35:15] CREATE TABLE
[2020-08-30 02:35:15] CREATE SEQUENCE
[2020-08-30 02:35:15] ALTER SEQUENCE
[2020-08-30 02:35:15] CREATE TABLE
[2020-08-30 02:35:15] CREATE SEQUENCE
[2020-08-30 02:35:15] ALTER SEQUENCE
[2020-08-30 02:35:15] CREATE TABLE
[2020-08-30 02:35:15] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] COMMENT
[2020-08-30 02:35:16] COMMENT
[2020-08-30 02:35:16] COMMENT
[2020-08-30 02:35:16] COMMENT
[2020-08-30 02:35:16] COMMENT
[2020-08-30 02:35:16] COMMENT
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] COMMENT
[2020-08-30 02:35:16] CREATE VIEW
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:16] CREATE TABLE
[2020-08-30 02:35:16] CREATE SEQUENCE
[2020-08-30 02:35:16] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:17] CREATE SEQUENCE
[2020-08-30 02:35:17] ALTER SEQUENCE
[2020-08-30 02:35:17] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:18] CREATE SEQUENCE
[2020-08-30 02:35:18] ALTER SEQUENCE
[2020-08-30 02:35:18] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] CREATE TABLE
[2020-08-30 02:35:19] CREATE SEQUENCE
[2020-08-30 02:35:19] ALTER SEQUENCE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:19] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] ALTER TABLE
[2020-08-30 02:35:20] COPY 0
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:20] --------
[2020-08-30 02:35:20] 1
[2020-08-30 02:35:20] (1 row)
[2020-08-30 02:35:20] COPY 1
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:20] --------
[2020-08-30 02:35:20] 1
[2020-08-30 02:35:20] (1 row)
[2020-08-30 02:35:20] COPY 2265
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:20] --------
[2020-08-30 02:35:20] 2265
[2020-08-30 02:35:20] (1 row)
[2020-08-30 02:35:20] COPY 1
[2020-08-30 02:35:20] COPY 5
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:20] --------
[2020-08-30 02:35:20] 6
[2020-08-30 02:35:20] (1 row)
[2020-08-30 02:35:20] COPY 3
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:20] --------
[2020-08-30 02:35:20] 4
[2020-08-30 02:35:20] (1 row)
[2020-08-30 02:35:20] COPY 50
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:20] --------
[2020-08-30 02:35:20] 102
[2020-08-30 02:35:20] (1 row)
[2020-08-30 02:35:20] COPY 12
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:20] --------
[2020-08-30 02:35:20] 18
[2020-08-30 02:35:20] (1 row)
[2020-08-30 02:35:20] COPY 0
[2020-08-30 02:35:20] COPY 0
[2020-08-30 02:35:20] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 66
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 42639
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 1
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 2
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 11
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 2
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 17
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 125
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 60
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 110
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 6
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 11
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 618
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 649
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 7618
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 7650
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 144
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 31927
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 4865
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 14890
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 158
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 173
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 4405
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 7
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 7
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 277
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 321
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 9
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 40
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 0
[2020-08-30 02:35:21] COPY 1
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 1
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:21] COPY 29
[2020-08-30 02:35:21] setval
[2020-08-30 02:35:21] --------
[2020-08-30 02:35:21] 29
[2020-08-30 02:35:21] (1 row)
[2020-08-30 02:35:22] COPY 0
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 1047
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1047
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 40
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 40
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 0
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 0
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 1
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 25
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 130
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 0
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 0
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 28716
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 61999
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 0
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 1
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 37
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 37
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 8862
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 9103
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 2
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 2
[2020-08-30 02:35:22] (1 row)
[2020-08-30 02:35:22] COPY 103
[2020-08-30 02:35:22] setval
[2020-08-30 02:35:22] --------
[2020-08-30 02:35:22] 115
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:23] COPY 123
[2020-08-30 02:35:23] setval
[2020-08-30 02:35:23] --------
[2020-08-30 02:35:23] 125
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:23] COPY 353
[2020-08-30 02:35:23] COPY 30
[2020-08-30 02:35:23] setval
[2020-08-30 02:35:23] --------
[2020-08-30 02:35:23] 30
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:23] COPY 7
[2020-08-30 02:35:23] setval
[2020-08-30 02:35:23] --------
[2020-08-30 02:35:23] 9
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:23] COPY 49237
[2020-08-30 02:35:23] setval
[2020-08-30 02:35:23] --------
[2020-08-30 02:35:23] 49417
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:23] COPY 1565
[2020-08-30 02:35:23] setval
[2020-08-30 02:35:23] --------
[2020-08-30 02:35:23] 1603
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:23] COPY 0
[2020-08-30 02:35:23] setval
[2020-08-30 02:35:23] --------
[2020-08-30 02:35:23] 1
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:23] COPY 13071
[2020-08-30 02:35:23] COPY 0
[2020-08-30 02:35:23] setval
[2020-08-30 02:35:23] --------
[2020-08-30 02:35:23] 1
[2020-08-30 02:35:23] (1 row)
[2020-08-30 02:35:24] COPY 4480
[2020-08-30 02:35:24] setval
[2020-08-30 02:35:24] --------
[2020-08-30 02:35:24] 4513
[2020-08-30 02:35:24] (1 row)
[2020-08-30 02:35:25] COPY 29186
[2020-08-30 02:35:25] COPY 29563
[2020-08-30 02:35:25] setval
[2020-08-30 02:35:25] --------
[2020-08-30 02:35:25] 29625
[2020-08-30 02:35:25] (1 row)
[2020-08-30 02:35:27] COPY 604395
[2020-08-30 02:35:27] COPY 3980
[2020-08-30 02:35:27] setval
[2020-08-30 02:35:27] --------
[2020-08-30 02:35:27] 7152
[2020-08-30 02:35:27] (1 row)
[2020-08-30 02:35:29] COPY 29578
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 29657
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 0
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 2
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 742
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 775
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 72
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 72
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 0
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 1
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 16
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 16
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 8
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 8
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 8
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 8
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 0
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 1
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 951
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 951
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 951
[2020-08-30 02:35:29] COPY 0
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 1
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 7
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 7
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 0
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 1
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 1124
[2020-08-30 02:35:29] setval
[2020-08-30 02:35:29] --------
[2020-08-30 02:35:29] 1124
[2020-08-30 02:35:29] (1 row)
[2020-08-30 02:35:29] COPY 0
[2020-08-30 02:35:30] setval
[2020-08-30 02:35:30] --------
[2020-08-30 02:35:30] 1
[2020-08-30 02:35:30] (1 row)
[2020-08-30 02:35:30] COPY 0
[2020-08-30 02:35:30] setval
[2020-08-30 02:35:30] --------
[2020-08-30 02:35:30] 1
[2020-08-30 02:35:30] (1 row)
[2020-08-30 02:35:30] COPY 208
[2020-08-30 02:35:30] setval
[2020-08-30 02:35:30] --------
[2020-08-30 02:35:30] 1601
[2020-08-30 02:35:30] (1 row)
[2020-08-30 02:35:30] COPY 2398
[2020-08-30 02:35:30] setval
[2020-08-30 02:35:30] --------
[2020-08-30 02:35:30] 7298
[2020-08-30 02:35:30] (1 row)
[2020-08-30 02:35:30] ERROR:  relation "public.spatial_ref_sys" does not exist
[2020-08-30 02:35:30] EXCEPTION: psql failed: ERROR:  relation "public.spatial_ref_sys" does not exist

[2020-08-30 02:35:30] /var/www/discourse/lib/backup_restore/database_restorer.rb:95:in `restore_dump'
/var/www/discourse/lib/backup_restore/database_restorer.rb:26:in `restore'
/var/www/discourse/lib/backup_restore/restorer.rb:49:in `run'
/var/www/discourse/lib/backup_restore.rb:188:in `block in start!'
/var/www/discourse/lib/backup_restore.rb:185:in `fork'
/var/www/discourse/lib/backup_restore.rb:185:in `start!'
/var/www/discourse/lib/backup_restore.rb:30:in `restore!'
/var/www/discourse/app/controllers/admin/backups_controller.rb:119:in `restore'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/base.rb:195:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/rendering.rb:30:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/callbacks.rb:42:in `block in process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:112:in `block in run_callbacks'
/var/www/discourse/app/controllers/application_controller.rb:340:in `block in with_resolved_locale'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/i18n-1.8.5/lib/i18n.rb:313:in `with_locale'
/var/www/discourse/app/controllers/application_controller.rb:340:in `with_resolved_locale'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:139:in `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/callbacks.rb:41:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/rescue.rb:22:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/instrumentation.rb:33:in `block in process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/notifications.rb:180:in `block in instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/notifications.rb:180:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/instrumentation.rb:32:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal/params_wrapper.rb:245:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.2/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/abstract_controller/base.rb:136:in `process'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionview-6.0.3.2/lib/action_view/rendering.rb:39:in `process'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.4/lib/mini_profiler/profiling_methods.rb:104:in `block in profile_method'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal.rb:190:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_controller/metal.rb:254:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/route_set.rb:50:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/route_set.rb:33:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/mapper.rb:18:in `block in <class:Constraints>'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/mapper.rb:48:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/journey/router.rb:49:in `block in serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/journey/router.rb:32:in `each'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/journey/router.rb:32:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/routing/route_set.rb:834:in `call'
/var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:68:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/tempfile_reaper.rb:15:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/conditional_get.rb:40:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/head.rb:12:in `call'
/var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call'
/var/www/discourse/lib/middleware/anonymous_cache.rb:336:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:266:in `context'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:260:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/cookies.rb:648:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.2/lib/active_support/callbacks.rb:101:in `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/callbacks.rb:26:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/actionable_exceptions.rb:17:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/debug_exceptions.rb:32:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/show_exceptions.rb:33:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/logster-2.9.3/lib/logster/middleware/reporter.rb:43:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/rack/logger.rb:37:in `call_app'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/rack/logger.rb:28:in `call'
/var/www/discourse/config/initializers/100-quiet_logger.rb:19:in `call'
/var/www/discourse/config/initializers/100-silence_logger.rb:31:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/remote_ip.rb:81:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/request_id.rb:27:in `call'
/var/www/discourse/lib/middleware/enforce_hostname.rb:22:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/method_override.rb:24:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/executor.rb:14:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/sendfile.rb:110:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3.2/lib/action_dispatch/middleware/host_authorization.rb:76:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.4/lib/mini_profiler/profiler.rb:321:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/message_bus-3.3.1/lib/message_bus/rack/middleware.rb:61:in `call'
/var/www/discourse/lib/middleware/request_tracker.rb:176:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/engine.rb:527:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/railtie.rb:190:in `public_send'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3.2/lib/rails/railtie.rb:190:in `method_missing'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/urlmap.rb:74:in `block in call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `each'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:632:in `process_client'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:728:in `worker_loop'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:548:in `spawn_missing_workers'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/lib/unicorn/http_server.rb:144:in `start'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.6.0/bin/unicorn:128:in `<top (required)>'
/var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in `load'
/var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in `<main>'
[2020-08-30 02:35:30] Trying to rollback...
[2020-08-30 02:35:30] Rolling back...
[2020-08-30 02:35:30] Cleaning stuff up...
[2020-08-30 02:35:30] Dropping functions from the discourse_functions schema...
[2020-08-30 02:35:30] Removing tmp '/var/www/discourse/tmp/restores/default/2020-08-30-023459' directory...
[2020-08-30 02:35:31] Unpausing sidekiq...
[2020-08-30 02:35:31] Disabling readonly mode...
[2020-08-30 02:35:31] Marking restore as finished...
[2020-08-30 02:35:31] Notifying 'username' of the end of the restore...
1 Like
2

That table isn’t part of Discourse, so I guess it is a NodeChef thing?

Anyway, you will want to edit your backup file and remove data and references from that table.

3 Likes
3

Also, just curious, they had quite a few plugins pre-installed, will I have to install them on my new build for the backup to work or can I install them afterwards?

4

A restore won’t fail without them, but it’s usually better to have everything in-place in your app.yml prior to running the restore.

1 Like
5

My backup is also from a prior version, will this cause any issues?

6

What do you mean by prior version? How old is it?

7

No, that will be ok, the restore will update it automatically to the current version.
In this case, it is strongly recommended to install the plugins prior to restoring the backup though.

8

I was only able to find one instance of this in the .sql file. Hopefully deleting the highlighted parts should do the trick. (I presume the top one refers to public.spatial_ref_sys)

ye
ye1283×617 27.7 KB

Also, how does one replace the dump.sql inside the tar.gz file with the modified one?

9 
# gzip dump and put it in the same directory as the backup 
gzip dump.sql

# copy backup file to fixed-* , replace this with your own backup file name
cp backupfilename-2020-08-30-123456-v20200830123456.tar.gz fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz

# decompress
gzip -d fixed-backupfilename-2020-08-30-123456-v20200830123456.tar.gz

# remove original dump.sql.gz from the archive. 
# Note that the backup filename does not contain .gz in this step.
tar f fixed-backupfilename-2020-08-30-123456-v20200830123456.tar --delete dump.sql.gz

# add new dump.sql.gz. Note that the backup filename does not contain .gz in this step.
tar fr fixed-backupfilename-2020-08-30-123456-v20200830123456.tar dump.sql.gz

# compress it again. Note that the backup filename does not contain .gz in this step.
gzip fixed-backupfilename-2020-08-30-123456-v20200830123456.tar
4 Likes
10

thanks @RGJ, my site is now back up and running perfectly. just gotta reinstall some plugins.

also thanks a million @Falco for helping me ID the problem in the first place.

3 Likes