RE: Steps to restore a Hivemind database snapshot by tosch

View this thread on: hive.blog | peakd.com | ecency.com

Viewing a response to: @emrebeyler/re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t134542215z

hivemind · @tosch · Jan 23 '19

I have confirmed running 10.6

I have the database crashing at 120GB with the following message:
```
psql:hive_latest.sql:345205000: ERROR:  missing data for column "img_url"
CONTEXT:  COPY hive_posts_cache, line 56927356: "57289501       breili  magicalliteraturenaturespirits-kcl8bly83b       steempress      0       1       60.4199982      0       19      19      Magical ..."
```

properties (22)

`author`	tosch
`permlink`	re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t164406093z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2019-01-23 16:44:06
`last_update`	2019-01-23 16:44:06
`depth`	5
`children`	2
`last_payout`	2019-01-30 16:44:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	383
`author_reputation`	3,148,075,991,236
`root_title`	"Steps to restore a Hivemind database snapshot"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,822,921
`net_rshares`	0

@emrebeyler · Jan 23 '19

You’re importing with -f hive_latest.sql instead of console stream, right?

properties (22)

`author`	emrebeyler
`permlink`	re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t164914671z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2019-01-23 16:49:15
`last_update`	2019-01-23 16:49:15
`depth`	6
`children`	1
`last_payout`	2019-01-30 16:49:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	74
`author_reputation`	448,535,049,068,622
`root_title`	"Steps to restore a Hivemind database snapshot"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,823,104
`net_rshares`	0

@emrebeyler · Jan 23 '19

btw, my id is emrebeyler#9263 on discord. Shoot a dm :)

properties (22)