On Wednesday 27 January 2010 05:16:24 Gary R. Schmidt wrote: > On Wed, January 27, 2010 08:28, Phil Stracchino wrote: > [SNIP] > > > I can check and see if there's a newer Solaris 10 MySQL package. (I'm > > trying to stay as much as possible with original Sun packages on that > > machine.) If it's a known potential issue with a known fix, then that's > > fine. I reported it in case it was a hitherto unseen problem. > > Are you using the WebStack <http://www.sun.com/software/webstack/> MySQL, > or the one in /usr/sfw? > > The SFW one is way out of date, and runs like a slug. Use the WebStack > stuff, it is much better - but note when building from source that > "--enable-batch-insert" does not work, you need to change the configure > script to look for the "libmysqlclient_r.so" rather than > "libmysqlclient_r.a" (I submitted a patch for 3.0.3, but 5 has broken it > again, I'll submit a patch for 5 RSN). > > This is the relevant section of the 3.0.3 configure: > SQL_BINDIR=$MYSQL_BINDIR > ### Accept libmysqlclient_r.so or libmysqlclient_r.a > if test -f $MYSQL_LIBDIR/libmysqlclient_r.so; then > SQL_LIB=$MYSQL_LIBDIR/libmysqlclient_r.so > elif test -f SQL_LIB=$MYSQL_LIBDIR/libmysqlclient_r.a; then > SQL_LIB=$MYSQL_LIBDIR/libmysqlclient_r.a > else > SQL_LIB= > fi > > The 5 configure (sort of) does this, and then cheerfully overwrites it > with the .a variant. Sigh.
The purpose of SQL_LIB is to be able to determine if Batch insert will work or not. SQL_LIB should *never* be returned pointing to a .so file. If it does, batch insert will be turned off in *all* cases. So any patch that returns a .so for SQL_LIB will break Bacula for all platforms as did the orginally submitted patch that you mention above. Batch insert works very well on all versions of MySQL and PostgreSQL, except for one or two MySQL versions that are broken. Unfortunately it seems to be one of the more common versions used on Solaris. If you want to disable batch insert, the proper way to do it is by adding a .configure option. Best regards, Kern ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
