恢复备份失败


(XMAN) #1

报错日志

[2018-03-27 03:38:06] 'XMAN' has started the restore!
[2018-03-27 03:38:06] Marking restore as running...
[2018-03-27 03:38:06] Making sure /var/www/discourse/tmp/restores/default/2018-03-27-033806 exists...
[2018-03-27 03:38:06] Copying archive to tmp directory...
[2018-03-27 03:38:06] Unzipping archive, this may take a while...
[2018-03-27 03:38:07] Extracting metadata file...
[2018-03-27 03:38:07] Validating metadata...
[2018-03-27 03:38:07]   Current version: 20171228122834
[2018-03-27 03:38:07]   Restored version: 20171228122834
[2018-03-27 03:38:07] Extracting dump file...
[2018-03-27 03:38:07] Restoring dump file... (can be quite long)
[2018-03-27 03:38:08] SET
[2018-03-27 03:38:08] SET
[2018-03-27 03:38:08] SET
[2018-03-27 03:38:08] SET
[2018-03-27 03:38:08] set_config
[2018-03-27 03:38:08] ------------
[2018-03-27 03:38:08] (1 row)
[2018-03-27 03:38:08] SET
[2018-03-27 03:38:08] SET
[2018-03-27 03:38:08] SET
[2018-03-27 03:38:08] ERROR:  function "raise_read_only" already exists with same argument types
[2018-03-27 03:38:08] ERROR:  current transaction is aborted, commands ignored until end of transaction block

repeat

[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "4"
[2018-03-27 03:38:10] LINE 1: 4 2018-03-01 3 8
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "environment"
[2018-03-27 03:38:10] LINE 1: environment production 2018-03-01 12:37:07.83973 2018-03-01 ...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 Getting Started
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 Gold 2018-03-01 12:37:08.356932 2018-03-01 12:37:08.356932
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
repeat

[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "13"
[2018-03-27 03:38:10] LINE 1: 13 First Flag
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
repeat

[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "3"
[2018-03-27 03:38:10] LINE 1: 3 站点反馈 808281 2 0 2018-03-01 12:36:57.810153 2018-03-01 ...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "2"
[2018-03-27 03:38:10] LINE 1: 2 9 2018-03-01 12:37:23.001285 2018-03-01 12:37:23.001285 0 ...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 2 13 2018-03-01 12:37:11.270356 2018-03-01 12:37:11.270356...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "5"
[2018-03-27 03:38:10] LINE 1: 5 'offers':1 Offers zh_CN 1
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 5 1 2018-03-01 14:59:30.821141 2018-03-01 14:59:30.821141
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 primary dddddd 1 2018-03-01 12:37:18.459853 2018-03-01 12:...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 简洁黑 1 2018-03-01 12:37:18.45652 2018-03-01 12:37:18.456...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
repeat

[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "2"
[2018-03-27 03:38:10] LINE 1: 2 5 3 0 0 0 0 0
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 1 topic_4 1
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
repeat

[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 email@domain.com signup 1 2018-03-01 13:58:50.820869 2018-03-...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "2"
[2018-03-27 03:38:10] LINE 1: 2 -2 discobot_email 8aae19ca27bcf5ac0570dede46341183 f f 201...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "2"
[2018-03-27 03:38:10] LINE 1: 2 0 2018-03-23 f
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 10 -1 2018-03-01 12:37:09.317046 2018-03-01 12:37:09.31704...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
repeat

[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "0"
[2018-03-27 03:38:10] LINE 1: 0 everyone 2018-03-01 12:37:07.995876 2018-03-01 12:37:08.02...
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 domain.com t 443
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \N
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 2018-03-25 09:04:03.771915
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:10] LINE 1: 1 / 1
[2018-03-27 03:38:10] ^
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \.
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:10] invalid command \N
repeat

[2018-03-27 03:38:11] invalid command \N
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 12 -1 {"badge_id":41,"badge_name":"首个表情","badge_slug":...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 DiscourseNarrativeBot::RemapOldBotImages 2018-03-01 12:51:...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 83373730757312d49d0ab461e820ffadd16a7508 .png 20 20 1 /upl...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 discourse-narrative-bot 1 JSON {"topic_id":11,"track":"Dis...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \N
repeat

[2018-03-27 03:38:11] invalid command \N
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "bookmark"
[2018-03-27 03:38:11] LINE 1: bookmark f
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \N
[2018-03-27 03:38:11] invalid command \N
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 24 2 1 2018-03-23 05:37:36.678326 2018-03-23 05:37:35.7841...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 1 4
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \n
repeat

[2018-03-27 03:38:11] invalid command \n
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 '信任':1 '分类':6,8 '参与':4 '用户':3 '等级':2 '讨论':5 '...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 1 0 0 0 2018-03-01 12:37:17.385719 2018-03-01 12:37:17.385...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 1 -1 5000
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "19"
[2018-03-27 03:38:11] LINE 1: 19 31 8
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \N
[2018-03-27 03:38:11] invalid command \n
[2018-03-27 03:38:11] invalid command \n恭喜!
[2018-03-27 03:38:11] invalid command \n
[2018-03-27 03:38:11] invalid command \N
[2018-03-27 03:38:11] invalid command \n置顶主题的第一段是访客在主页看到的欢迎私信。这很重要!
[2018-03-27 03:38:11] invalid command \n
[2018-03-27 03:38:11] invalid command \N
repeat

[2018-03-27 03:38:11] invalid command \n
[2018-03-27 03:38:11] invalid command \n促销正在进行中,一次性7折,有效期到2018-03.31
[2018-03-27 03:38:11] invalid command \n
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  syntax error at or near "1"
[2018-03-27 03:38:11] LINE 1: 1 -1 1 1 信任等级3的用户参与讨论的分类。 <p>信任等级3的用户...
[2018-03-27 03:38:11] ^
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \.
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] ERROR:  current transaction is aborted, commands ignored until end of transaction block
[2018-03-27 03:38:11] invalid command \n
repeat

[2018-03-27 03:38:19] invalid command \n
[2018-03-27 03:38:19] EXCEPTION: psql failed
[2018-03-27 03:38:19] /var/www/discourse/lib/backup_restore/restorer.rb:279:in `restore_dump'
/var/www/discourse/lib/backup_restore/restorer.rb:42:in `run'
/var/www/discourse/lib/backup_restore/backup_restore.rb:167:in `block in start!'
/var/www/discourse/lib/backup_restore/backup_restore.rb:164:in `fork'
/var/www/discourse/lib/backup_restore/backup_restore.rb:164:in `start!'
/var/www/discourse/lib/backup_restore/backup_restore.rb:23:in `restore!'
/var/www/discourse/app/controllers/admin/backups_controller.rb:103:in `restore'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/basic_implicit_render.rb:4:in `send_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/base.rb:186:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/rendering.rb:30:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/callbacks.rb:20:in `block in process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/callbacks.rb:131:in `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/callbacks.rb:19:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/rescue.rb:20:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/notifications.rb:166:in `block in instrument'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/notifications.rb:166:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/params_wrapper.rb:252:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/railties/controller_runtime.rb:22:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/base.rb:124:in `process'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionview-5.1.4/lib/action_view/rendering.rb:30:in `process'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-mini-profiler-0.10.7/lib/mini_profiler/profiling_methods.rb:102:in `block in profile_method'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal.rb:189:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal.rb:253:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:31:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:16:in `block in <class:Constraints>'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:46:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/journey/router.rb:50:in `block in serve'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/journey/router.rb:33:in `each'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/journey/router.rb:33:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:834:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/frame_options.rb:31:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/builder.rb:63:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/conditional_get.rb:38:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/head.rb:12:in `call'
/var/www/discourse/lib/middleware/anonymous_cache.rb:149:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:232:in `context'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:226:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/cookies.rb:613:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/callbacks.rb:26:in `block in call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/callbacks.rb:97:in `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/callbacks.rb:24:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/debug_exceptions.rb:59:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/show_exceptions.rb:31:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/logster-1.2.9/lib/logster/middleware/reporter.rb:31:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/rack/logger.rb:36:in `call_app'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/rack/logger.rb:26:in `call'
/var/www/discourse/config/initializers/100-quiet_logger.rb:16:in `call'
/var/www/discourse/config/initializers/100-silence_logger.rb:29:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/remote_ip.rb:79:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/request_id.rb:25:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/method_override.rb:22:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/runtime.rb:22:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/executor.rb:12:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/sendfile.rb:111:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-mini-profiler-0.10.7/lib/mini_profiler/profiler.rb:282:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/message_bus-2.1.1/lib/message_bus/rack/middleware.rb:63:in `call'
/var/www/discourse/lib/middleware/request_tracker.rb:138:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/engine.rb:522:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/railtie.rb:185:in `public_send'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/railtie.rb:185:in `method_missing'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/urlmap.rb:68:in `block in call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/urlmap.rb:53:in `each'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/urlmap.rb:53:in `call'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:606:in `process_client'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:702:in `worker_loop'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:549:in `spawn_missing_workers'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:142:in `start'
/var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/bin/unicorn:126:in `<top (required)>'
/var/www/discourse/vendor/bundle/ruby/2.4.0/bin/unicorn:23:in `load'
/var/www/discourse/vendor/bundle/ruby/2.4.0/bin/unicorn:23:in `<main>'
[2018-03-27 03:38:19] invalid command \n
[2018-03-27 03:38:19] Trying to rollback...
[2018-03-27 03:38:19] There was no need to rollback
[2018-03-27 03:38:22] Notifying 'XMAN' of the end of the restore...
[2018-03-27 03:38:38] Cleaning stuff up...
[2018-03-27 03:38:38] Removing tmp '/var/www/discourse/tmp/restores/default/2018-03-27-033806' directory...
[2018-03-27 03:38:38] Unpausing sidekiq...
[2018-03-27 03:38:38] Marking restore as finished...
[2018-03-27 03:38:38] Finished!

相关说明

1)备份的文件名不显示域名

第一次备份文件名是有显示域名的
domain.com-2018-03-01-182909-v20171228122834.tar.gz

搬家后再次备份就不显示域名了
-2018-03-27-033020-v20171228122834.tar.gz (不知道为什么"-2018"前面没有域名了)

2)奇怪的恢复方法
A服务器./launcher rebuild app再备份就可以在B服务器导入,A服务器如果不rebuild直接备份导入B服务器就会报错,日志就是上面那些。

每次搬家都得rebuild,请问有解决方法吗?


(Schrödinger's Corgi) #2

两个服务器的Discourse 版本需要一样才可以恢复,而最简单的方法就是通过rebuild。
在日志中显示

这说明只读模式已开启(恢复时会自动开启,无需手动)


(XMAN) #3

AB服务器的Discourse 版本和OS版本都是一样的,第一次搬家的时候直接就可以导入备份进行数据恢复。现在每次搬家都得在A服务器rebuild一次再备份才能在B服务器导入,这样的真很麻烦。没有解决方法吗?


(Schrödinger's Corgi) #4

为了保持,版本号一致,我曾经AB服务器都重建了一次,然后进行了备份恢复。整个过程确实略微麻烦了一些。不过官方貌似就提供这一种备份恢复的方法。记得总耗时大约要30分钟,因为很少进行转移,对于我这个时间可以接受。

在设置中重新定义一下站点名称就可以了,如果是中文就不会显示,所以若想在备份中显示名称只能用英文。