ovsqlite - bug?
Kamil Jońca
kjonca at op.pl
Sun Nov 20 20:31:53 UTC 2022
Julien ÉLIE <julien at trigofacile.com> writes:
> Hi Kamil,
>
>> Recently debian folks packaged innd with sqlite overview method.
>> I tried to migrate from ovdb - so I configured ovsqlite.
>> then I issued:
>> makehistory -O -x -F -l 1000000
>> during this I got some messages like:
>> "cannot write overview data: ...storage token..."
>
> Are there plenty of these messages or only a very few?
makehistory: cannot write overview data "@03FF30000000000000000000004400000008@"
makehistory: cannot write overview data "@03FF31000000000000000000004400000008@"
makehistory: cannot write overview data "@03FF32000000000000000000004400000008@"
makehistory: cannot write overview data "@03FF33000000000000000000004400000008@"
makehistory: cannot write overview data "@03FF35000000000000000000004400000007@"
makehistory: cannot write overview data "@03FF36000000000000000000004400000007@"
makehistory: cannot write overview data "@03FF37000000000000000000004400000007@"
7 ( for 4.8 million articles in spool)
> Do you happen to have the same errors if you try to convert your
> overview to tradindexed (running the same makehistory command)?
I rebuilt with ovdb - no messages.
then I rebuilt witho ovsqlite - results above .
Do you still suggest to test with tradindexed?
> Just to be sure, did you follow the steps in the Overview Rebuild
> section of
> <https://www.eyrie.org/~eagle/software/inn/docs/makehistory.html> and
> have ovsqlite-server running fine?
Yes.
>
>
>> below headers from some messages (not all, as some of them "private"
>> but I cannot see nothing obvious.
>
> I don't see anything obvious either. At first I thought you had very
> long lines to write in overview but it is not the case here
> (makehistory has a 32 KB limit because of the underlying quick I/O
> functions it uses).
When I posted as above - it can be seen some regularity in storage
token. But I am not sure if this is right approach.
KJ
--
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
More information about the inn-workers
mailing list