[Resolved?] Re: ovsqlite - bug?

Julien ÉLIE julien at trigofacile.com
Sun Nov 20 22:30:37 UTC 2022


Hi Kamil,

> Well, it seems that problem is with spool not with sqlite.

Oh, great, thanks for your investigation!

ovsqlite appears to be more robust than ovdb as it did an integrity 
check before accepting new overview data (maybe by primary key in 
database, I have not checked).


> It is worth noting, that greping /var/lib/news/history for these storage
> tokens returns nothing.
> 
> So the first thigs I should do is to make history consistent with spool
> and then test further.

I don't think you should bother.
You won't be able to make your history file consistent with your 
self-expiring CNFS buffers.  I bet the articles have already expired 
from your current overview.  They are just still here in the buffer, 
just waiting for being overwritten by the next cycle.

What happens is that makehistory parses your spool and finds these old 
articles.  It generates overview entries for them.
Tomorrow, after the run of expireover (by news.daily), your overview 
date will be purged of these entries.


> But for now I am pretty sure, that sqlite worked properly as, it forces
> uniqueness of  (group,artnum )  in overview (and other methods not)

Glad to know!

-- 
Julien ÉLIE

« J'ai six loyaux serviteurs, ils m'ont appris tout ce que je sais : ils
   s'appellent quoi, pourquoi, quand, comment, où et qui. » (Rudyard
   Kipling)


More information about the inn-workers mailing list