Quassel IRC

While working on fixing #1249, I discovered that buffer.lastseenmsgid will often be set to a value higher than the most recent actual message.

This causes the unread messages backlog fetcher to be much slower than it would otherwise be.

This issue has been confirmed by me to exist in both my current PostgreSQL database, as well as in an SQLite3 database dump of my core from 2016-02-28.

Others in #quassel have reported the same thing.

You can check if this is the case in your database with the following query (works in both SQLite and PostgreSQL):

SELECT * FROM buffer WHERE lastseenmsgid > (SELECT messageid FROM backlog WHERE backlog.bufferid = buffer.bufferid ORDER BY messageid DESC LIMIT 1);

If that query returns any rows, your database suffers from this issue.