-1 risposte anche se ho importato i messaggi correttamente

[Christian_Suntay]

Here below are from Vanilla and imported to Discourse

[justin (Justin DiRose)]

Did you use the bulk importer? If so you’ll need to run rake import:ensure_consistency to generate those stats.

[Christian_Suntay]

@justin

rake import:ensure_consistency

Yes Justin. I have used bulk importer (vanilla)

Will try that now. Thanks!

[Christian_Suntay]

Any idea when using the rake import:ensure_consistency after a few minutes it makes the ssh unresponsive?

I already make the
ServerAliveInterval 3600 just to make sure it wont die.

[Christian_Suntay]

How long should rake import:ensure_consistency take for 20million datas

[pfaffman (Jay Pfaffman)]

A very long time. If it can process 10K per minute, you’re looking at 33 hours. It could easily be 10X that long.

EDIT: Beware: This assumes that I can do arithmetic with a calculator.

[Christian_Suntay]

Thanks Jay for clarifying!

[justin (Justin DiRose)]

@pfaffman

Beware: This assumes that I can do arithmetic with a calculator.

It’s ok Jay - math is hard.

[Christian_Suntay]

it will sit like this for hours?

no indication that it is still running

[justin (Justin DiRose)]

There’s not a progress bar, no. As Jay said it will likely run for quite a long time. Give 24hrs and check back.

[pfaffman (Jay Pfaffman)]

You could in another window do something like PostTiming.all.count in a rails console. If it’s getting bigger then you’d know that it was getting bigger. Maybe. But I didn’t look at what it’s actually doing.

[Christian_Suntay]

sir one last question. when i admin/backup and restore it will it be counted to the backup?

[pfaffman (Jay Pfaffman)]

It’s on the database, so it will be included.

Also you want to look at /sidekiq and make sure that all of those jobs are done before moving to production

[Christian_Suntay]

Thanks Jay. So does it mean when I restore the back up into a new server do i need to run the rake import:ensure_consistency? because it includes an action of “updating” after insert

[pfaffman (Jay Pfaffman)]

I don’t believe so. Once those tables are updated they’ll be in the database.

[Christian_Suntay]

Great! thanks Jay and the swift response of the discourse team!

[Christian_Suntay]

Jay, I have 1 more question.

why is it the PostReply has no data? it even went thru and proceed to the next step

with this I’m already with the update user stats

[justin (Justin DiRose)]

If you’re importing I’m not 100% sure a PostReply is generated. I believe that’s for direct replies to specific posts, like mine to yours.