Recurrent automatic SQL backup causes slowness

Hi guys,

Recently, my staging instance of Discourse started to make automatic SQL dumps every half an hour. This is independent of the main backup features, which happens every 7 days.

This is causing massive slowness and timeouts with the forum as it’s a huge database. Any idea why it might do that? Is this a feature of Discourse?

Currently running Installed

[v2.3.0.beta1 +37]

29030 ?        SN     0:00          |   |   \_ sh -c  pg_dump --schema=public --file='/var/www/discourse/tmp/backups/default/2019-02-15-074301/dump.sql.gz' --no-owner --no-privileges --verbose --compress=4  --port=5432 --username=discourse discourse 2>&1

drwxr-xr-x  2 xxxadmin www-data 4096 Feb 12 22:33 2019-02-13-033332
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 12 23:31 2019-02-13-043014
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 12 23:58 2019-02-13-045853
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 01:01 2019-02-13-060037
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 01:29 2019-02-13-062923
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 02:00 2019-02-13-070034
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 02:33 2019-02-13-073157
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 02:59 2019-02-13-075948
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 03:29 2019-02-13-082956
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 04:00 2019-02-13-090007
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 22:36 2019-02-14-033612
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 23:08 2019-02-14-040725
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 13 23:36 2019-02-14-043625
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 14 00:08 2019-02-14-050737
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 14 22:37 2019-02-15-033741
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 14 23:12 2019-02-15-041202
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 14 23:42 2019-02-15-044214
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 15 00:18 2019-02-15-051506
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 15 01:13 2019-02-15-061305
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 15 01:51 2019-02-15-064433
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 15 02:12 2019-02-15-071256
drwxr-xr-x  2 xxxadmin www-data 4096 Feb 15 02:43 2019-02-15-074301

Thank you so much.

1 Like

No, this isn’t how it’s supposed to work. There’s definitely something wrong with your setup.

Are you seeing errors in the logs? Are you getting PMs about failed backups? What timezone is your server using? We recently saw problems when it wasn’t set to UTC.

3 Likes

We are experiencing the same kind of issue using v2.3.0.beta2 +31
Server time is set to UTC.
The backup is using S3 backend, and works in manual mode, but not in scheduled mode.
It looks like it starts over and over, slowing everything, and failing silently.
I don’t see anything useful in logs, but perhaps i don’t look at the right place (help welcome).

Basically autobackup is broken since 2 weeks for us.

We are using a 3 containers setup web/data/redis, here what i can see in the temporary folder used by backup process (i removed older directories to reclaim disk space):

root@community-web:/shared/tmp/backups/default# ls -l
total 252
drwxr-xr-x 2 discourse www-data 4096 Feb 14 01:38 2019-02-14-013809
drwxr-xr-x 2 discourse www-data 4096 Feb 14 02:09 2019-02-14-020945
drwxr-xr-x 2 discourse www-data 4096 Feb 14 02:40 2019-02-14-024004
drwxr-xr-x 2 discourse www-data 4096 Feb 14 03:10 2019-02-14-031027
drwxr-xr-x 2 discourse www-data 4096 Feb 14 03:40 2019-02-14-034039
drwxr-xr-x 2 discourse www-data 4096 Feb 14 04:10 2019-02-14-041043
drwxr-xr-x 2 discourse www-data 4096 Feb 14 04:40 2019-02-14-044050
drwxr-xr-x 2 discourse www-data 4096 Feb 14 05:11 2019-02-14-051104
drwxr-xr-x 2 discourse www-data 4096 Feb 14 05:41 2019-02-14-054111
drwxr-xr-x 2 discourse www-data 4096 Feb 14 06:11 2019-02-14-061138
drwxr-xr-x 2 discourse www-data 4096 Feb 14 06:41 2019-02-14-064146
drwxr-xr-x 2 discourse www-data 4096 Feb 14 07:12 2019-02-14-071220
drwxr-xr-x 2 discourse www-data 4096 Feb 14 07:42 2019-02-14-074245
drwxr-xr-x 2 discourse www-data 4096 Feb 14 08:12 2019-02-14-081250
drwxr-xr-x 2 discourse www-data 4096 Feb 14 08:43 2019-02-14-084310
drwxr-xr-x 2 discourse www-data 4096 Feb 14 09:13 2019-02-14-091327
drwxr-xr-x 2 discourse www-data 4096 Feb 14 09:43 2019-02-14-094349
drwxr-xr-x 2 discourse www-data 4096 Feb 14 10:14 2019-02-14-101358
drwxr-xr-x 2 discourse www-data 4096 Feb 14 10:44 2019-02-14-104409
drwxr-xr-x 2 discourse www-data 4096 Feb 14 11:14 2019-02-14-111419
drwxr-xr-x 2 discourse www-data 4096 Feb 14 11:44 2019-02-14-114428
drwxr-xr-x 2 discourse www-data 4096 Feb 14 12:14 2019-02-14-121438
drwxr-xr-x 2 discourse www-data 4096 Feb 14 12:45 2019-02-14-124501
drwxr-xr-x 2 discourse www-data 4096 Feb 14 13:15 2019-02-14-131520
drwxr-xr-x 2 discourse www-data 4096 Feb 14 13:46 2019-02-14-134554
drwxr-xr-x 2 discourse www-data 4096 Feb 14 14:16 2019-02-14-141604
drwxr-xr-x 2 discourse www-data 4096 Feb 14 14:46 2019-02-14-144635
drwxr-xr-x 2 discourse www-data 4096 Feb 14 15:16 2019-02-14-151645
drwxr-xr-x 2 discourse www-data 4096 Feb 14 15:47 2019-02-14-154716
drwxr-xr-x 2 discourse www-data 4096 Feb 14 16:17 2019-02-14-161731
drwxr-xr-x 2 discourse www-data 4096 Feb 14 16:47 2019-02-14-164747
drwxr-xr-x 2 discourse www-data 4096 Feb 14 17:18 2019-02-14-171802
drwxr-xr-x 2 discourse www-data 4096 Feb 14 17:48 2019-02-14-174806
drwxr-xr-x 2 discourse www-data 4096 Feb 14 18:20 2019-02-14-182018
drwxr-xr-x 2 discourse www-data 4096 Feb 14 19:18 2019-02-14-191836
drwxr-xr-x 2 discourse www-data 4096 Feb 14 19:49 2019-02-14-194902
drwxr-xr-x 2 discourse www-data 4096 Feb 14 20:49 2019-02-14-204922
drwxr-xr-x 2 discourse www-data 4096 Feb 14 21:19 2019-02-14-211935
drwxr-xr-x 2 discourse www-data 4096 Feb 14 21:49 2019-02-14-214943
drwxr-xr-x 2 discourse www-data 4096 Feb 14 22:19 2019-02-14-221952
drwxr-xr-x 2 discourse www-data 4096 Feb 14 22:49 2019-02-14-224953
drwxr-xr-x 2 discourse www-data 4096 Feb 14 23:20 2019-02-14-232004
drwxr-xr-x 2 discourse www-data 4096 Feb 14 23:50 2019-02-14-235016
drwxr-xr-x 2 discourse www-data 4096 Feb 15 00:20 2019-02-15-002038
drwxr-xr-x 2 discourse www-data 4096 Feb 15 00:50 2019-02-15-005053
drwxr-xr-x 2 discourse www-data 4096 Feb 15 01:21 2019-02-15-012128
drwxr-xr-x 2 discourse www-data 4096 Feb 15 01:51 2019-02-15-015132
drwxr-xr-x 2 discourse www-data 4096 Feb 15 02:21 2019-02-15-022139
drwxr-xr-x 2 discourse www-data 4096 Feb 15 02:51 2019-02-15-025146
drwxr-xr-x 2 discourse www-data 4096 Feb 15 03:22 2019-02-15-032205
drwxr-xr-x 2 discourse www-data 4096 Feb 15 03:52 2019-02-15-035211
drwxr-xr-x 2 discourse www-data 4096 Feb 15 04:22 2019-02-15-042217
drwxr-xr-x 2 discourse www-data 4096 Feb 15 04:52 2019-02-15-045241
drwxr-xr-x 2 discourse www-data 4096 Feb 15 05:22 2019-02-15-052237
drwxr-xr-x 2 discourse www-data 4096 Feb 15 05:52 2019-02-15-055245
drwxr-xr-x 2 discourse www-data 4096 Feb 15 06:22 2019-02-15-062254
drwxr-xr-x 2 discourse www-data 4096 Feb 15 06:53 2019-02-15-065327
drwxr-xr-x 2 discourse www-data 4096 Feb 15 07:23 2019-02-15-072337
drwxr-xr-x 2 discourse www-data 4096 Feb 15 07:54 2019-02-15-075358
drwxr-xr-x 2 discourse www-data 4096 Feb 15 08:24 2019-02-15-082414
drwxr-xr-x 2 discourse www-data 4096 Feb 15 08:54 2019-02-15-085431
drwxr-xr-x 2 discourse www-data 4096 Feb 15 09:24 2019-02-15-092429
drwxr-xr-x 2 discourse www-data 4096 Feb 15 10:43 2019-02-15-104326
1 Like

Thanks @gerhard for the fast response.

Same thing about the logs. Not noticing anything unusual or errors but then maybe I’m not looking where I should.

Our server had EST but changed to UTC and it’s behaving the same.

One thing I’ve noticed is that once I stopped the process doing the SQL dumps, I’ve got a message from System with Backup failed. So Discourse is doing the SQL dumps, even tho they don’t show in the backup list and it’ configured to do it every 7 days.

This is the log with Backup failed after I stopped the process. Not sure if it helps

The backup has failed.

Here’s the log:

[2019-02-15 10:14:00] [STARTED]
[2019-02-15 10:14:00] 'system' has started the backup!
[2019-02-15 10:14:00] Marking backup as running...
[2019-02-15 10:14:00] Making sure '/var/www/discourse/tmp/backups/default/2019-02-15-101400' exists...
[2019-02-15 10:14:01] Making sure '/var/www/discourse/public/backups/default' exists...
[2019-02-15 10:14:01] Pausing sidekiq...
[2019-02-15 10:14:01] Waiting for sidekiq to finish running jobs...
[2019-02-15 10:14:01] Dumping the public schema of the database...
[2019-02-15 10:14:26] pg_dump: last built-in OID is 16383
[2019-02-15 10:14:26] pg_dump: reading extensions
[2019-02-15 10:14:26] pg_dump: identifying extension members
[2019-02-15 10:14:26] pg_dump: reading schemas
[2019-02-15 10:14:26] pg_dump: reading user-defined tables
[2019-02-15 10:14:26] pg_dump: reading user-defined functions
[2019-02-15 10:14:26] pg_dump: reading user-defined types
[2019-02-15 10:14:26] pg_dump: reading procedural languages
[2019-02-15 10:14:26] pg_dump: reading user-defined aggregate functions
[2019-02-15 10:14:26] pg_dump: reading user-defined operators
[2019-02-15 10:14:26] pg_dump: reading user-defined access methods
[2019-02-15 10:14:26] pg_dump: reading user-defined operator classes
[2019-02-15 10:14:26] pg_dump: reading user-defined operator families
[2019-02-15 10:14:26] pg_dump: reading user-defined text search parsers
[2019-02-15 10:14:33] pg_dump: reading user-defined text search templates
[2019-02-15 10:14:33] pg_dump: reading user-defined text search dictionaries
[2019-02-15 10:14:33] pg_dump: reading user-defined text search configurations
[2019-02-15 10:14:33] pg_dump: reading user-defined foreign-data wrappers
[2019-02-15 10:14:33] pg_dump: reading user-defined foreign servers
[2019-02-15 10:14:33] pg_dump: reading default privileges
[2019-02-15 10:14:33] pg_dump: reading user-defined collations
[2019-02-15 10:14:33] pg_dump: reading user-defined conversions
[2019-02-15 10:14:33] pg_dump: reading type casts
[2019-02-15 10:14:33] pg_dump: reading transforms
[2019-02-15 10:14:33] pg_dump: reading table inheritance information
[2019-02-15 10:14:33] pg_dump: reading event triggers
[2019-02-15 10:14:33] pg_dump: finding extension tables
[2019-02-15 10:14:33] pg_dump: finding inheritance relationships
[2019-02-15 10:14:33] pg_dump: reading column info for interesting tables
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.api_keys"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.api_keys"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.application_requests"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.application_requests"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.ar_internal_metadata"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.badge_groupings"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.badge_groupings"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.categories"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.categories"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.posts"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.posts"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.topics"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.topics"
[2019-02-15 10:14:33] pg_dump: finding check constraints for table "public.topics"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.badge_posts"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.badge_types"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.badge_types"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.badges"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.badges"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.categories_web_hooks"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_custom_fields"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_custom_fields"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_featured_topics"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_featured_topics"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_groups"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_groups"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_search_data"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_search_data"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_tag_groups"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_tag_groups"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_tag_stats"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_tag_stats"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_tags"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_tags"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.category_users"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.category_users"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.child_themes"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.child_themes"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.color_scheme_colors"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.color_scheme_colors"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.color_schemes"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.color_schemes"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.custom_emojis"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.custom_emojis"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.developers"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.developers"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.directory_items"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.directory_items"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.draft_sequences"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.draft_sequences"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.drafts"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.drafts"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.email_change_requests"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.email_change_requests"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.email_logs"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.email_logs"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.email_tokens"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.email_tokens"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.embeddable_hosts"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.embeddable_hosts"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.facebook_user_infos"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.facebook_user_infos"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.github_user_infos"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.github_user_infos"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.given_daily_likes"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.given_daily_likes"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.google_user_infos"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.google_user_infos"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.group_archived_messages"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.group_archived_messages"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.group_custom_fields"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.group_custom_fields"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.group_histories"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.group_histories"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.group_mentions"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.group_mentions"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.group_users"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.group_users"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.groups"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.groups"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.groups_web_hooks"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.incoming_domains"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.incoming_domains"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.incoming_emails"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.incoming_emails"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.incoming_links"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.incoming_links"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.incoming_referers"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.incoming_referers"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.instagram_user_infos"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.instagram_user_infos"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.invited_groups"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.invited_groups"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.invites"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.invites"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.javascript_caches"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.javascript_caches"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.message_bus"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.message_bus"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.muted_users"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.muted_users"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.notifications"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.notifications"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.oauth2_user_infos"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.oauth2_user_infos"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.onceoff_logs"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.onceoff_logs"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.optimized_images"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.optimized_images"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.permalinks"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.permalinks"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.plugin_store_rows"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.plugin_store_rows"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_action_types"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.post_action_types"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_actions"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.post_actions"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_custom_fields"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.post_custom_fields"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_details"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.post_details"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_replies"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_reply_keys"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.post_reply_keys"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_revisions"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.post_revisions"
[2019-02-15 10:14:33] pg_dump: finding the columns and types of table "public.post_search_data"
[2019-02-15 10:14:33] pg_dump: finding default expressions of table "public.post_search_data"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.post_stats"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.post_stats"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.post_timings"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.post_uploads"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.post_uploads"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.push_subscriptions"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.push_subscriptions"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.queued_posts"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.queued_posts"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.quoted_posts"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.quoted_posts"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.remote_themes"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.remote_themes"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.scheduler_stats"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.scheduler_stats"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.schema_migration_details"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.schema_migration_details"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.schema_migrations"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.screened_emails"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.screened_emails"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.screened_ip_addresses"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.screened_ip_addresses"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.screened_urls"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.screened_urls"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.search_logs"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.search_logs"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.shared_drafts"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.shared_drafts"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.single_sign_on_records"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.single_sign_on_records"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.site_settings"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.site_settings"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.skipped_email_logs"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.skipped_email_logs"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.stylesheet_cache"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.stylesheet_cache"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.tag_group_memberships"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.tag_group_memberships"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.tag_group_permissions"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.tag_group_permissions"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.tag_groups"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.tag_groups"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.tag_search_data"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.tag_search_data"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.tag_users"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.tag_users"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.tags"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.tags"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.theme_fields"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.theme_fields"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.theme_settings"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.theme_settings"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.themes"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.themes"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.top_topics"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.top_topics"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_allowed_groups"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_allowed_groups"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_allowed_users"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_allowed_users"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_custom_fields"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_custom_fields"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_embeds"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_embeds"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_invites"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_invites"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_link_clicks"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_link_clicks"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_links"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_links"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_search_data"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_search_data"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_tags"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_tags"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_timers"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_timers"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_users"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.topic_users"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.topic_views"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.translation_overrides"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.translation_overrides"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.twitter_user_infos"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.twitter_user_infos"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.unsubscribe_keys"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.uploads"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.uploads"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_actions"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_actions"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_api_keys"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_api_keys"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_archived_messages"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_archived_messages"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_auth_token_logs"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_auth_token_logs"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_auth_tokens"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_auth_tokens"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_avatars"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_avatars"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_badges"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_badges"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_custom_fields"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_custom_fields"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_emails"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_emails"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_exports"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_exports"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_field_options"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_field_options"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_fields"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_fields"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_histories"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_histories"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_open_ids"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_open_ids"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_options"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_options"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_profile_views"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_profile_views"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_profiles"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_profiles"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_search_data"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_search_data"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_second_factors"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_second_factors"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_stats"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_stats"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_uploads"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_uploads"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_visits"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_visits"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_warnings"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_warnings"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.users"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.users"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.watched_words"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.watched_words"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.web_crawler_requests"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.web_crawler_requests"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.web_hook_event_types"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.web_hook_event_types"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.web_hook_event_types_hooks"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.web_hook_events"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.web_hook_events"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.web_hooks"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.web_hooks"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.polls"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.polls"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.poll_options"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.poll_options"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.poll_votes"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.user_associated_accounts"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.user_associated_accounts"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.tags_web_hooks"
[2019-02-15 10:14:34] pg_dump: finding the columns and types of table "public.theme_translation_overrides"
[2019-02-15 10:14:34] pg_dump: finding default expressions of table "public.theme_translation_overrides"
[2019-02-15 10:14:34] pg_dump: flagging inherited columns in subtables
[2019-02-15 10:14:34] pg_dump: reading indexes
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.api_keys"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.application_requests"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.ar_internal_metadata"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.badge_groupings"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.categories"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.posts"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topics"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.badge_types"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.badges"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.categories_web_hooks"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_featured_topics"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_groups"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_search_data"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_tag_groups"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_tag_stats"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_tags"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.category_users"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.child_themes"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.color_scheme_colors"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.color_schemes"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.custom_emojis"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.developers"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.directory_items"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.draft_sequences"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.drafts"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.email_change_requests"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.email_logs"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.email_tokens"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.embeddable_hosts"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.facebook_user_infos"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.github_user_infos"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.given_daily_likes"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.google_user_infos"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.group_archived_messages"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.group_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.group_histories"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.group_mentions"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.group_users"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.groups"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.groups_web_hooks"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.incoming_domains"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.incoming_emails"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.incoming_links"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.incoming_referers"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.instagram_user_infos"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.invited_groups"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.invites"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.javascript_caches"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.message_bus"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.muted_users"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.notifications"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.oauth2_user_infos"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.onceoff_logs"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.optimized_images"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.permalinks"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.plugin_store_rows"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_action_types"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_actions"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_details"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_replies"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_reply_keys"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_revisions"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_search_data"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_stats"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_timings"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.post_uploads"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.push_subscriptions"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.queued_posts"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.quoted_posts"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.remote_themes"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.scheduler_stats"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.schema_migration_details"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.schema_migrations"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.screened_emails"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.screened_ip_addresses"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.screened_urls"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.search_logs"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.shared_drafts"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.single_sign_on_records"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.site_settings"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.skipped_email_logs"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.stylesheet_cache"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.tag_group_memberships"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.tag_group_permissions"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.tag_groups"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.tag_search_data"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.tag_users"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.tags"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.theme_fields"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.theme_settings"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.themes"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.top_topics"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_allowed_groups"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_allowed_users"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_embeds"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_invites"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_link_clicks"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_links"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_search_data"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_tags"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_timers"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_users"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.topic_views"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.translation_overrides"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.twitter_user_infos"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.unsubscribe_keys"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.uploads"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_actions"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_api_keys"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_archived_messages"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_auth_token_logs"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_auth_tokens"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_avatars"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_badges"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_emails"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_exports"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_field_options"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_fields"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_histories"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_open_ids"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_options"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_profile_views"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_profiles"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_search_data"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_second_factors"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_stats"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_uploads"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_visits"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_warnings"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.users"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.watched_words"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.web_crawler_requests"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.web_hook_event_types"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.web_hook_event_types_hooks"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.web_hook_events"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.web_hooks"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.polls"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.poll_options"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.poll_votes"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.user_associated_accounts"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.tags_web_hooks"
[2019-02-15 10:14:34] pg_dump: reading indexes for table "public.theme_translation_overrides"
[2019-02-15 10:14:34] pg_dump: reading extended statistics
[2019-02-15 10:14:34] pg_dump: reading constraints
[2019-02-15 10:14:34] pg_dump: reading foreign key constraints for table "public.posts"
[2019-02-15 10:14:34] pg_dump: reading foreign key constraints for table "public.users"
[2019-02-15 10:14:34] pg_dump: reading foreign key constraints for table "public.polls"
[2019-02-15 10:14:34] pg_dump: reading foreign key constraints for table "public.poll_options"
[2019-02-15 10:14:34] pg_dump: reading foreign key constraints for table "public.poll_votes"
[2019-02-15 10:14:34] pg_dump: reading triggers
[2019-02-15 10:14:34] pg_dump: reading triggers for table "public.posts"
[2019-02-15 10:14:34] pg_dump: reading triggers for table "public.users"
[2019-02-15 10:14:34] pg_dump: reading triggers for table "public.polls"
[2019-02-15 10:14:34] pg_dump: reading triggers for table "public.poll_options"
[2019-02-15 10:14:34] pg_dump: reading triggers for table "public.poll_votes"
[2019-02-15 10:14:34] pg_dump: reading rewrite rules
[2019-02-15 10:14:34] pg_dump: reading policies
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.api_keys"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.api_keys"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.api_keys_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.api_keys_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.application_requests"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.application_requests"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.application_requests_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.application_requests_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.ar_internal_metadata"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.ar_internal_metadata"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.badge_groupings"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.badge_groupings"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.badge_groupings_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.badge_groupings_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.categories"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.categories"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.posts"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.posts"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.topics"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.topics"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.badge_posts"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.badge_posts"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.badge_types"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.badge_types"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.badge_types_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.badge_types_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.badges"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.badges"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.badges_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.badges_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.categories_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.categories_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.categories_web_hooks"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.categories_web_hooks"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_featured_topics"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_featured_topics"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_featured_topics_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_featured_topics_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_groups"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_groups"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_groups_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_groups_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_search_data"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_search_data"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.category_tag_groups"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.category_tag_groups"
[2019-table "public.child_themes_id_seq"
-15 10:14:34] pg_dump: reading row security enabled for table "public.javascript_caches"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.javascript_caches"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.javascript_caches_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.javascript_caches_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.message_bus"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.message_bus"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.message_bus_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.message_bus_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.muted_users"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.muted_users"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.muted_users_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.muted_users_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.notifications"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.notifications"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.notifications_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.notifications_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.oauth2_user_infos"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.oauth2_user_infos"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.oauth2_user_infos_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.oauth2_user_infos_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.onceoff_logs"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.onceoff_logs"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.onceoff_logs_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.onceoff_logs_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.optimized_images"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.optimized_images"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.optimized_images_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.optimized_images_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.permalinks"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.permalinks"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.permalinks_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.permalinks_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.plugin_store_rows"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.plugin_store_rows"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.plugin_store_rows_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.plugin_store_rows_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_action_types"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_action_types"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_action_types_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_action_types_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_actions"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_actions"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_actions_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_actions_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_custom_fields"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_details"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_details"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_details_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_details_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_replies"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_replies"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_reply_keys"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_reply_keys"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_reply_keys_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_reply_keys_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_revisions"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_revisions"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_revisions_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_revisions_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_search_data"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_search_data"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_stats"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_stats"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_stats_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_stats_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_timings"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_timings"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_uploads"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_uploads"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.post_uploads_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.post_uploads_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.posts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.posts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.push_subscriptions"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.push_subscriptions"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.push_subscriptions_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.push_subscriptions_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.queued_posts"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.queued_posts"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.queued_posts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.queued_posts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.quoted_posts"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.quoted_posts"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.quoted_posts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.quoted_posts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.remote_themes"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.remote_themes"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.remote_themes_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.remote_themes_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.scheduler_stats"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.scheduler_stats"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.scheduler_stats_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.scheduler_stats_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.schema_migration_details"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.schema_migration_details"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.schema_migration_details_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.schema_migration_details_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.schema_migrations"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.schema_migrations"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.screened_emails"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.screened_emails"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.screened_emails_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.screened_emails_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.screened_ip_addresses"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.screened_ip_addresses"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.screened_ip_addresses_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.screened_ip_addresses_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.screened_urls"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.screened_urls"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.screened_urls_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.screened_urls_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.search_logs"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.search_logs"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.search_logs_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.search_logs_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.shared_drafts"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.shared_drafts"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.shared_drafts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.shared_drafts_id_seq"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.single_sign_on_records"
[2019-02-15 10:14:34] pg_dump: reading policies for table "public.single_sign_on_records"
[2019-02-15 10:14:34] pg_dump: reading row security enabled for table "public.single_sign_on_records_id_seq"
users"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_allowed_users_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_allowed_users_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_custom_fields"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_embeds"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_embeds_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_embeds_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_invites"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_invites_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_invites_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_link_clicks"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_link_clicks_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_link_clicks_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_links"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_links_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_links_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_search_data"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_search_data_topic_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_search_data_topic_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_tags"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_tags_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_tags_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_timers"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_timers_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_timers_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_users"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topic_users_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topic_users_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.topic_views"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.topics_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.topics_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.translation_overrides"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.translation_overrides_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.translation_overrides_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.twitter_user_infos"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.twitter_user_infos_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.twitter_user_infos_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.unsubscribe_keys"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.uploads"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.uploads_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.uploads_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_actions"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_actions_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_actions_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_api_keys"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_api_keys_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_api_keys_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_archived_messages"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_archived_messages_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_archived_messages_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_associated_accounts"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_associated_accounts_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_associated_accounts_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_auth_token_logs"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_auth_token_logs_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_auth_token_logs_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_auth_tokens"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_auth_tokens_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_auth_tokens_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_avatars"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_avatars_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_avatars_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_badges"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_badges_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_badges_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_custom_fields"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_custom_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_emails"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_emails_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_emails_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_exports"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_exports_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_exports_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_field_options"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_field_options_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_field_options_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_fields"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_fields_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_histories"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_histories_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_histories_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_open_ids"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_open_ids_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_open_ids_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_options"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_profile_views"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_profile_views_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_profile_views_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_profiles"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_search_data"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_second_factors"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_second_factors_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_second_factors_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_stats"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_uploads"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_uploads_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_uploads_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_visits"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_visits_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_visits_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.user_warnings"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.user_warnings_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.user_warnings_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.users"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.users_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.users_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.watched_words"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.watched_words_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.watched_words_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.web_crawler_requests"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.web_crawler_requests_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.web_crawler_requests_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.web_hook_event_types"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.web_hook_event_types_hooks"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.web_hook_event_types_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.web_hook_event_types_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.web_hook_events"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.web_hook_events_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.web_hook_events_id_seq"
[2019-02-15 10:14:34] pg_dump: creating TABLE "public.web_hooks"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE "public.web_hooks_id_seq"
[2019-02-15 10:14:34] pg_dump: creating SEQUENCE OWNED BY "public.web_hooks_id_seq"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.api_keys id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.application_requests id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.badge_groupings id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.badge_types id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.badges id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.categories id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.category_custom_fields id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.category_featured_topics id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.category_groups id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.category_tag_groups id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.category_tag_stats id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.category_tags id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.category_users id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.child_themes id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.color_scheme_colors id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.color_schemes id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.custom_emojis id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.developers id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.directory_items id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.draft_sequences id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.drafts id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_allowed_users id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_custom_fields id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_embeds id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_invites id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_link_clicks id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_links id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_search_data topic_id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_tags id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_timers id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topic_users id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.topics id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.translation_overrides id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.twitter_user_infos id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.uploads id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_actions id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_api_keys id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_archived_messages id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_associated_accounts id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_auth_token_logs id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_auth_tokens id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_avatars id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_badges id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_custom_fields id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_emails id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_exports id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_field_options id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_fields id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_histories id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_open_ids id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_profile_views id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_second_factors id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_uploads id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_visits id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.user_warnings id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.users id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.watched_words id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.web_crawler_requests id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.web_hook_event_types id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.web_hook_events id"
[2019-02-15 10:14:34] pg_dump: creating DEFAULT "public.web_hooks id"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.api_keys"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.api_keys"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.application_requests"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.application_requests"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.ar_internal_metadata"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.ar_internal_metadata"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.badge_groupings"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.badge_groupings"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.badge_types"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.badge_types"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.badges"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.badges"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.categories"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.categories"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.categories_web_hooks"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.categories_web_hooks"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_custom_fields"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_custom_fields"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_featured_topics"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_featured_topics"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_groups"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_groups"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_search_data"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_search_data"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_tag_groups"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_tag_groups"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_tag_stats"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_tag_stats"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_tags"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_tags"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.category_users"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.category_users"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.child_themes"
[2019-02-15 10:14:34] pg_dump: dumping contents of table "public.child_themes"
[2019-02-15 10:14:34] pg_dump: processing data for table "public.color_scheme_colors"

[2019-02-15 10:14:37] pg_dump: dumping contents of table "public.post_search_data"
[2019-02-15 10:33:27] EXCEPTION: pg_dump failed
[2019-02-15 10:33:27] /var/www/discourse/lib/backup_restore/backuper.rb:173:in `dump_public_schema'
/var/www/discourse/lib/backup_restore/backuper.rb:38:in `run'
/var/www/discourse/lib/backup_restore/backup_restore.rb:16:in `backup!'
/var/www/discourse/app/jobs/regular/create_backup.rb:8:in `execute'
/var/www/discourse/app/jobs/base.rb:137:in `block (2 levels) in perform'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rails_multisite-2.0.6/lib/rails_multisite/connection_management.rb:63:in `with_connection'
/var/www/discourse/app/jobs/base.rb:127:in `block in perform'
/var/www/discourse/app/jobs/base.rb:123:in `each'
/var/www/discourse/app/jobs/base.rb:123:in `perform'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:185:in `execute_job'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:167:in `block (2 levels) in process'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/middleware/chain.rb:128:in `block in invoke'
/var/www/discourse/lib/sidekiq/pausable.rb:81:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/middleware/chain.rb:130:in `block in invoke'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/middleware/chain.rb:133:in `invoke'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:166:in `block in process'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:137:in `block (6 levels) in dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/job_retry.rb:108:in `local'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:136:in `block (5 levels) in dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq.rb:37:in `block in <module:Sidekiq>'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:132:in `block (4 levels) in dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:243:in `stats'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:127:in `block (3 levels) in dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/job_logger.rb:8:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:126:in `block (2 levels) in dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/job_retry.rb:73:in `global'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:125:in `block in dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/logging.rb:48:in `with_context'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/logging.rb:42:in `with_job_hash_context'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:124:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:165:in `process'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:83:in `process_one'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/processor.rb:71:in `run'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/util.rb:16:in `watchdog'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/sidekiq-5.2.5/lib/sidekiq/util.rb:25:in `block in safe_thread'
[2019-02-15 10:33:27] Deleting old backups...
[2019-02-15 10:33:27] Cleaning stuff up...
[2019-02-15 10:33:27] Removing '.tar' leftovers...
[2019-02-15 10:33:27] Unpausing sidekiq...
[2019-02-15 10:33:27] Marking backup as finished...
[2019-02-15 10:33:27] Refreshing disk stats...
[2019-02-15 10:33:27] Notifying 'system' of the end of the backup...

In the Discourse error logs I see Sideqik failing and Error Bad Gateway, but I guess it;s because of the slowness


Sidekiq heartbeat test failed, restarting
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/logster-2.0.0.pre/lib/logster/logger.rb:101:in `add_with_opts'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/logster-2.0.0.pre/lib/logster/logger.rb:52:in `add'
/usr/local/lib/ruby/2.5.0/logger.rb:536:in `warn'
config/unicorn.conf.rb:188:in `check_sidekiq_heartbeat'
config/unicorn.conf.rb:205:in `master_sleep'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/unicorn-5.4.1/lib/unicorn/http_server.rb:294:in `join'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/unicorn-5.4.1/bin/unicorn:126:in `<top (required)>'
/var/www/discourse/vendor/bundle/ruby/2.5.0/bin/unicorn:23:in `load'
/var/www/discourse/vendor/bundle/ruby/2.5.0/bin/unicorn:23:in `<main>'

Error: Bad Gateway

Uncaught Error: Bad Gateway
Url: http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js
Line: 15
Column: 5191
Window Location: http://discourse.xx.com/admin/plugins

    at a (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:15:5392)
    at s (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:15:5249)
    at o (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:15:5144)
    at Object.trigger (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:18:7371)
    at http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:18:9368
    at e.invoke (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:9:11624)
    at e.flush (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:9:10577)
    at e.flush (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:9:12677)
    at e._end (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:9:17457)
    at e.end (http://discourse.xx.com/assets/ember_jquery-cf9339810550f9c92505dfbb37362c58a4a8a83bcee2d99174547b01c06ed7d3.js:9:14012)

Installed plugins: Up to date versions of:

discourse-assign 0.1
discourse-canned-replies 1.2
discourse-push-notifications 0.3.0
discourse-solved 0.1
discourse-staff-notes 0.0.2
docker_manager 0.1

1 Like

There’s a huge gap between those log messages. Either it’s taking a very long time to dump this table or something else is going on here.

Do manual backups work for you or do you run into the same issue?

Do you have a timestamp for this error? nginx restarting sidekiq during the database dump certainly may cause all sorts of problems. I’ll see how we can stop this from happening. This shouldn’t happen. The heartbeat should work even when sidekiq is paused. There might be a bug somewhere. I’ll see what I can find.

@Zas666 Do you see a similar error in /logs?

1 Like

The gap is the repetitive same line for different file and location patterns, as I had to short down the message due to word limitation. I hope I didn’t remove anything of importance.

I’ll try to look up and come back. Thank you

I see. What’s the usual size of your database backup? Are you using a hard disk or SSD? I’m trying to understand why dumping the database takes so long.

1 Like

1.7 to 1.8GB the full site backup. on a SSD

I’ve started now the backup process to see if it works. It should, as the last scheduled 7 days backup ran correctly.

Yes.

Database only is 600Mb but with uploads (we usually save them along) we reach 6.6Gb (archive/compressed). On SSD.

It should be noted we had no issue before.

I recommend you both upgrade to the latest version. There were a bunch of fixes related to backups and sidekiq in the last couple of days.

4 Likes

Thank you. As soon as it finished the previously started back up, I’ll start the upgrade.

But it says the Latest available is 2.3.0.beta2, which is the same @Zas666 already has.

1 Like

You can always go to /admin/upgrade if the Upgrade link doesn’t show up on your dashboard.
Unless you see “v2.3.0.beta2 +93” as installed version, you aren’t really on the latest version.

I upgraded to v2.3.0.beta2 +93, i re-enabled auto backups, and will report if it works or not when it will be done.
Thanks for your help.

3 Likes

Auto backups seem to work with v2.3.0.beta2 +93, the archive was generated and uploaded to S3.
I’m not sure what exactly broke/fixed it though.

Also you might want to ensure temporary files and directories are removed when a backup has failed.

3 Likes

Thank you @gerhard and @Zas666.
Yes, the update seems that has fixed it until now. I will keep an eye on it.

3 Likes