yes, it actually is using the correct library. This worked with bacula 3.0.1 so I presume something changed in the way the PQisthreadsafe function is called from bacula?

siv...@mnemosyne:/usr/local/bacula/bin $ ldd bacula-dir |grep libpq
        libpq.so.5 => /usr/local/pgsql/lib/libpq.so.5 (0x00002b593b82d000)

siv...@mnemosyne:/usr/local/bacula/bin $ nm /usr/local/pgsql/lib/libpq.so.5|grep -i thread
0000000000008ed0 T PQisthreadsafe
0000000000006310 T PQregisterThreadLock
0000000000006330 t default_threadlock
000000000021b9c0 d pg_g_threadlock
                 U pthread_mutex_lock@@GLIBC_2.2.5
                 U pthread_mutex_unlock@@GLIBC_2.2.5
000000000021c840 b singlethread_lock.9505




On 29/9/2010 15:50, Martin Simmons wrote:
On Wed, 29 Sep 2010 13:34:53 +0300, Spiros Ioannou said:
   I tried to upgrade from 3.0.1  to 5.0.3 , and it's been a nightmare for
2 days.
after giving up on bat (it's is a impossible to compile due to a variety
of errors, reminding me of compiling software in the early 90's),

I'm now stuck with bacula-dir not starting, with the following error in
the log:
29-Sep 13:22 bacula-dir: ABORTING due to ERROR in postgresql.c:303
Pg client library must be thread-safe when using BatchMode.

but, postgres is 8.3.3 configured with  --enable-thread-safety, and in
bacula's config.log I could find:
configure:29051: checking for PQisthreadsafe in -lpq
configure:29086: gcc -o conftest -g -O2   conftest.c -lpq  -ldl
-L/usr/local/pgsql/lib -lpq -lcrypt>&5
configure:29092: $? = 0
configure:29110: result: yes
....
ac_cv_lib_pq_PQisthreadsafe=yes

doing an ltrace bacula-dir though, outputs this:
PQisthreadsafe(0x6c1920, 0, 0x6c1920, 0, 0x134ed28) = 0

please help as I'm now left without backup since I've updated the DB to
the new version.
Thanks.
system is CentOs 5.3
postgres 8.3.3
bacula 5.0.3
The configure check doesn't actually call PQisthreadsafe, so it might say yes
even if PQisthreadsafe returns 0.

Is bacula-dir definitely using your thread-safe libpq.so?  E.g. check with
ldd.

__Martin

------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel

<<attachment: sivann.vcf>>

------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
Spend less time writing and  rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to