[pkg-bacula-devel] Bug#909460: Trouble with the sqlite3 upgrade path

[Carsten Leonhardt]

Hi,

I found the source. Upstream commit
ac391519c8e4125db0662dea92e7550d95bd9a16 "Permit catalog to contain
negative FileIndexes", added shortly before the 9.2.1 release.

This makes me wonder about how these schema updates would reach people
that are already on db version 16. For us, we can fix that by adding yet
more manual snippets for dbconfig...


Sven Hartge wrote:

> Looking at the code, it seems we have to create a temp table with the
> new schema and then select everything from the old table into it, then
> removing the old table and finally renaming the temp table.
>
> Just like it was done with basefiles_temp.

Yes, when I read your mail I remembered having done that before...

I'll take care of this, but probably after fixing latex2html and
bacula-docs.

 - Carsten