Hello Carsten,
Please see below ...
On 08/29/2017 02:19 AM, Carsten Leonhardt wrote:
Hi Kern,
Kern Sibbald <k...@sibbald.com> writes:
It has been a long time since the Bacula Community version supports
SQLite3. The code is still there, but it simply does not perform
well, and so it is not at all suitable for a Bacula production
environment. The only two officially supported databases are MySQL
and PostgreSQL, and providing that MariaDB remains reasonably
compatible with MySQL, it will also work.
It does not make any sense to hold up a Bacula release because of some
problem with SQLite3. If you do decide to hold up the release,
please let me know so that I can completely remove the code in 9.0.4.
I would greatly prefer to be able to give users of Debian and it's
derivatives a warning before sqlite3 support is removed, especially
because sqlite/sqlite3 had been the default database in Debian
installations since the first Debian release that included Bacula
(Debian 3.1 in 2005).
Although I didn't shout it from the roof tops, SQLite3 has not been
supported in Bacula for several years. This was noted in the documentation,
but until yesterday, there were a number of places in the documentation
where SQLite3 was mentioned. This is now completely removed, and
will first appear in 9.0.4. In addition, today, I disabled the ability
to configure
SQLite3. Unless you undo what I disabled (quite trivial) no SQLite of
any kind
will be supported in version 9.0.4.
I was not aware that the default database for Debian is SQLite3. This is
a bit
unfortunate. However, you can still warn the users that this change is
now after
a delay of several years happening.
One thing that has precipitated this is that I am currently maintaining
3 different
databases: MySQL, MariaDB, and PostgreSQL, so it is very unlikely I
will want to
continue leaving the SQLite3 code in Bacula. This is particularly true,
because
MariaDB is becoming less compatible with MySQL, which has caused extra work
on our part, and I foresee that this trend will continue. Ultimately in
2-5 years, I
expect that MySQL support will probably be discontinued, but we are
certainly not
at that point today.
I have not seen the attachments you refer to. If you either send them to me
or supply me with a link to them, I will look at them, but I promise
nothing since
the goal for the last few years has been to stop spending time on SQLite.
With today's distros, installing and running MySQL is as easy or easier
than it every
was for SQLite. Just install it, and it works out of the box.
Of course there is a problem for your existing SQLite users. I see the
following
choices:
1. They remain on 9.0.3
2. They convert to using either MySQL or PostgreSQL -- I believe that
it may be possible to simply take a SQLite3 sql dump and feed it
directly into PostgreSQL. (or at least the changes would be
minor). For
MySQL, the changes to the SQLite3 dump will probably be more
important.
3. Debian continues to patch newer versions of Bacula to include support
for SQLite3. If you want to do this, you just need to reverse or
back out
the SHA1 3f376bbd58d44a16032cb45373b11f6fd06d9589 commit that
I just made then "recompile" configure.in by using "make configure".
I will at some point completely remove even the possibility of building
the SQLite3. However, if you choose item #3 above, please inform me
and I will keep the old code around for another couple of years.
I hope the above helps you determine the least disruptive path to take.
Best regards,
Kern
My predecessors in Bacula package maintenance
never changed that default. While I might be able to warn Debian users
by updating the current Bacula version in Debian stable to include such
a warning, that would not reach users of Debian derivatives (like
Ubuntu).
Anyway, attached to the bug reports (2305 + 2306) are now the patches
that I intend to use for the Debian packages.
- Carsten
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
