Here below are from Vanilla and imported to Discourse
Did you use the bulk importer? If so you’ll need to run rake import:ensure_consistency to generate those stats.
5 Likes
Yes Justin. I have used bulk importer (vanilla)
Will try that now. Thanks!
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.
How long should rake import:ensure_consistency take for 20million datas
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.
4 Likes
Thanks Jay for clarifying!
1 Like
It’s ok Jay - math is hard. 
3 Likes
There’s not a progress bar, no. As Jay said it will likely run for quite a long time. Give 24hrs and check back.
2 Likes
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.
2 Likes
sir one last question. when i admin/backup and restore it will it be counted to the backup?
1 Like
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
1 Like
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
I don’t believe so. Once those tables are updated they’ll be in the database.
1 Like
Great! thanks Jay and the swift response of the discourse team!
2 Likes
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
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.
4 Likes