Generally, I stay within about 20 blocks, but sometimes I'll see exactly what you're describing.
I just stop SBDS, restart, and watch the logs:
# docker stop steem_sbds
# docker start steem_sbds
# docker logs --tail=2 -f steem_sbds
[4/6] Finding blocks missing from db...
Finding missing block_nums
It'll sit on 'finding' for quite awhile, but soon enough you'll see it writing new blocks.
I'm trying to write a monitoring script that can be called by cron to do all of this automatically.
A monitoring script sounds like a great idea. I'd be happy to help test it out. Various issue's I've experienced are where block height stops going up or one or both of steem_mysql or steem_sbds stops.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That's exactly what I'm seeing, and every time I fix it, the solution is something that could have been scripted. I'll definitely ping you when I have something together for testing.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit