Bug #9825 Library not found, is in '/usr/local/lib'
Submitted: 11 Apr 2005 18:38 Modified: 6 May 2005 12:35
Reporter: Joerg Bruehe Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Compiling Severity:S1 (Critical)
Version:5.0.4 OS:Solaris (Solaris 8 / i386)
Assigned to: Joerg Bruehe CPU Architecture:Any

[11 Apr 2005 18:38] Joerg Bruehe
Description:
Build of 5.0.4-beta, based on ChangeSet
  1.1889 05/04/08 16:49:14 mskold@mysql.com +4 -0
  Merge from fix of Bug #9675  Auto-increment not working with INSERT..SELECT and NDB storage

On "intelxeon3", build fails with messages like
gcc -O3 -DDBUG_OFF -D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H -I/export/home/mysqldev/intelxeon3/mysql-5.0.4-beta/include -DHAVE_RWLOCK_T -o comp_err comp_err.o  ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lthread -lposix4 -lcrypt -lgen -lsocket -lnsl /usr/local/lib/libsupc++.a -L/usr2/SOURCES/I8/gcc-3.4.1/objdir/i386-pc-solaris2.8/libstdc++-v3/src -L/usr2/SOURCES/I8/gcc-3.4.1/objdir/i386-pc-solaris2.8/libstdc++-v3/src/.libs -lm -L/usr2/SOURCES/I8/gcc-3.4.1/objdir/gcc -L/usr/ccs/bin -L/usr/ccs/lib -L/usr/local/lib -lgcc_s -lgcc_s -lpthread -lthread
../extra/comp_err \
--charset=../sql/share/charsets \
--out-dir=../sql/share/ \
--header_file=../include/mysqld_error.h \
--name_file=../include/mysqld_ername.h \
--state_file=../include/sql_state.h \
--in_file=../sql/share/errmsg.txt
ld.so.1: ../extra/comp_err: fatal: libgcc_s.so.1: open failed: No such file or directory
make[2]: *** [../include/mysqld_error.h] Killed

So a program (here: 'comp_err', but similar for 'factorial') could be linked successfully, but could not be executed due to a missing library.
The library is present, but obviously in a location which was not searched:
mysqldev@intelxeon3:~> find /usr /lib -name 'libgcc_s*'
/usr/local/lib/libgcc_s.so
/usr/local/lib/libgcc_s.so.1

How to repeat:
Try a build there.

Suggested fix:
Not sure - 
either add '/usr/local/lib' to the directories to be searched,
or install the library in some system default directory.
[6 May 2005 12:35] Joerg Bruehe
Compiler on this machine has been switched from "gcc" to "Sun Studio" in the meantime anyway
(Changeset build/bin/Do-compile-all@1.326, 2005-04-13 21:02:12+02:00, joerg@mysql.com),
and there is no intention to switch back.