On 07/30/17 05:19, Kern Sibbald wrote: > Hello Phil, > > See below ... > > > On 07/29/2017 10:35 PM, Phil Stracchino wrote: >> I've now got everything updated to 9.0.2 using a work-in-progress >> development version of the app-backup/bacula-9.0.2 ebuild. I'm running >> against MariaDB 10.2.7 (which more or less approximates MySQL 5.7) with >> Galera enabled. > Warning MariaDB 10.2.7 has a serious bug that causes batch inserts to > occasionally fail. I submitted a bug report, and they duplicated the > problem with a script and are working on fixing it.
Useful to know. >> I maintain that even without Galera, 500000 is an unreasonably large >> batch size. Just because a modern database *can* handle it doesn't make >> it a good idea. 50000 would be more reasonable, and 10000 would be better. > I had always thought the limit was 25,000, so was surprised > when I saw 500,000 I was a bit surprised. I suppose it is a sort of > insane limit I added. Whether it works or not, I don't know. A bit > I found out why I remembered 25,000. That is because it is the > maximum set for PostgreSQL. 25000 would be a much more reasonable size. > You have specified too many problems for me to deal with -- sorry. Not trying to make a bug list here, just reporting my test results, what I tried, what worked, what didn't, what broke. > I will say that the driver code for 9.0.x is totally rewritten from 7.4.x. > However the general high level code that mounts, unmounts, and > all that has not changed much. Since it was such a massive rewrite, > there is a possibility of problems, but none of the rather extensive > regression tests shows problems, and the new code has been working > here on my (very simple) autochanger setup for at least a year. > I am not planning on working on Bat any more, but I do use it myself, > and I have noticed the annoying number of prompts to do something, but > it is not sufficiently annoying enough to make me dig into the code. > If it will not do the few things I need, I will fix it. Otherwise, I am > trying > to switch over to Baculum, but I have not quite succeeded in making the > change. I've been meaning to try out Baculum myself, but haven't gotten around to it yet. I really should do that, since I get the strong impression BAT is more or less end-of-life. I do like BAT though — I much prefer a standalone application and have never been convinced of the merit of the "EVERYTHING is a web app" model. HTML was designed as a stateless protocol and there are *many* things it's now being made to do that, honestly, it just doesn't do well even with the aid of multiple underlying glue layers. Years ago there was a humorous list circulated of communication protocols compared in terms of chickens crossing the road. According to that list, the web chicken reached the middle of the road, turned left and just started running, and flattened everything else it ran across. > Most of the things you mention will probably ultimately end up being fixed > except perhaps bat, because Bacula Systems has a team of programmers > working on the problems that are reported to them, and obviously at some > point (or immediately if I notice it) I backport the fixes they make from > the Enterprise version to the Community version. Obviously if the > problem strikes me, or it is clearly documented in a bug report, it has > a much higher probability of being fixed. When I've got things narrowed down to specific reportable items and separated out from the configuration-change issues, I'll file some bug reports. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
