Utopian Comments without Upvotes

Earlier today the Utopian Bot commented on one of my posts saying, "I have just upvoted you!"

However, when I looked at my votes there was nothing from Utopian.

I jumped into Discord and reported this in #post-bug and saw several other reports noting, "commented by utopian but not upvoted" so it seems this isn't isolated.

A public MySQL database of SBDS is available so I decided to write a quick query:

SELECT CONCAT('https://steemit.com/@', comments.parent_author, '/', comments.parent_permlink) AS url, comments.*
FROM (
    SELECT parent_author, parent_permlink, body
    FROM sbds_tx_comments
    WHERE author = 'utopian-io'
    AND timestamp > DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -1 DAY)
    AND body LIKE '%voted you%'
    ORDER BY timestamp DESC
) AS comments
LEFT JOIN (
    SELECT voter, author, permlink
    FROM sbds_tx_votes
    WHERE voter = 'utopian-io'
    AND timestamp > DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -1 DAY)
    ORDER BY timestamp DESC
) AS votes
ON comments.parent_author = votes.author
AND comments.parent_permlink = votes.permlink
WHERE votes.author IS NULL

I limited this to just the last day and got these 8 results:

url	author	permlink
Post	pars11	turkish-tutorial-of-codeigniter-or-php-or-part-11-or-blog-sitesi-yapimi-7-or
Post	villaincandle	the-curious-expedition-polish-translation-part-20-1088-words
Post	khaled-dz	translation-yapbam-into-arabic-part-6-1177-words-100-translated
Post	suparmanyunus2	suggestion-for-steepshot-add-online-features-in-account
Post	value2	turkish-translation-for-ancap-ch-1055-words-translated
Post	blervin	expired-content-and-alternative-posts
Post	adetola	the-menu-bar-on-steemgigs-cover-avatar-or-display-picture
Post	guinsoo	translation-of-dollar-street-3-en-to-tr

I spot checked all 8 and confirm none of them have an upvote. I hope this helps narrow down the issues for the missed votes.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---