archecker error with PSM
SangGyu Jeong got an archecker error on AIX 6.1 with Informix 12.10.FC12WE using PSM backups: libbsapsm.so failed to load because pthread_mutex symbols were not found, though onbar worked. Andreas Legner asked for ldd output and whether libpthreads was found; SangGyu's ldd lacked it. Michal Lukaszewicz later reported the same problem on 12.10.FC15. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
Level 0 and log backups are being made using psm on an AIX system for testing.
I tried to recover the table with archecker using psm's backup, but I get an error as below.
command)
archecker -bdvs -f schemafile
onbar backups or restores are performing fine.
I also tried slibclean , but it's the same. Any other solutions?
STATUS: Extracting table demo:restore_test into demo:restore_test_target
ERROR: Unable to open dynamic library (/informix/lib/libbsapsm.so)
ERROR: OS Error (rtld: 0712-001 Symbol pthread_mutex_lock was referenced
from module /informix/lib/libbsapsm.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol pthread_mutex_unlock was referenced
from module /informix/lib/libbsapsm.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol pthread_mutex_init was referenced
from module /informix/lib/libbsapsm.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol pthread_mutex_destroy was referenced
from module /informix/lib/libbsapsm.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol pthread_join was referenced
from module /informix/lib/libbsapsm.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol pthread_create was referenced
from module /informix/lib/libbsapsm.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol pthread_detach was referenced
from module /informix/lib/libbsapsm.so(), but a runtime definition
of the symbol was not found.)
ERROR: Unable to open dynamic library (/informix/lib/ibsad001_64.o)
ERROR: Unable to load dynamic library
STATUS: Scan PASSED
STATUS: Control page checks PASSED
STATUS: Table checks PASSED
STATUS: Table extraction commands 1
STATUS: Tables found on archive 0
STATUS: Tables not located on archive 1
STATUS: LOADED: demo:restore_test_target produced 0 rows
TIME: [2022-04-26 21:31:06] Physical Extraction Completed
TIME: [2022-04-26 21:31:06] Unload Completed
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix
Is archecker being tried on same system where also the backup had been created? In which case I'd wonder how libbsapsm.so can be good enough for the backup, yet not for archecker - maybe an environment problem?
If on different system, then that seems to be missing some library.
What's ldd's perspective on this?
Here it would show:
$ ldd libbsapsm.so
libbsapsm.so needs:
/usr/lib/libc.a(shr_64.o)
/usr/lib/libpthreads.a(shr_xpg5_64.o) <<< this is the relevant one and had been found on my system
/unix
/usr/lib/libcrypt.a(shr_64.o)
BR,Andreas
------------------------------
Andreas Legner
------------------------------
Hi Andrea, Thanks for your reply.
Backup and restore were performed on the same instance on the same server.
The ldd output for the libbsapsm.so file is shown below.
Informix version is 12.10.FC12WE, OS is AIX 6.1.
$ ldd libbsapsm.so
libbsapsm.so needs:
/usr/lib/libdl.a(shr_64.o)
/usr/lib/libc.a(shr_64.o)
/unix
/usr/lib/libcrypt.a(shr_64.o)
Thanks,SangGyu Jeong
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Hi, have you managed to solve the issue by any chance? I've found this discussion thread looking for a solution to the same problem. I'm on AIX, with 12.10.FC15. ------------------------------ Michał Łukaszewicz ------------------------------