Problem with libmysqlclient and Sphinx on Snow Leopard

// March 11th, 2011 // No Comments » // Databases, Development

After installing Sphinx 1.10 on OSX Snow Leopard, I attempted to run the initial indexer and got the following error:

dyld: Library not loaded: libmysqlclient.16.dylib
Referenced from: /usr/local/bin/indexer
Reason: image not found
Trace/BPT trap

The fix was found after a little googling; just run this command:

sudo install_name_tool -change libmysqlclient.16.dylib /usr/local/mysql/lib/libmysqlclient.16.dylib /usr/local/bin/indexer

Take into account the location of your Sphinx install, but after this runs you should be all set.

Update
I also just discovered that you’ll probably have to run the same command to get search working as well.

MySQL JDBC and Streaming Results

// January 14th, 2011 // No Comments » // Databases, Development

So after almost a whole day of banging my head on my desk, I’ve come to realize the error I was getting:


org.apache.solr.handler.dataimport.DataImportHandlerException: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

java.io.EOFException


was related to the old version of the MySQL JDBC connector I was using, 5.0.8. It turns out it doesn’t recognize the netTimeoutForStreamingResults parameter, causing my executions to die a horrible death after 600 seconds, the default setting. Upgrading to the latest connector, 5.1.14, solved the problem and I’m happily importing my million records of data into Solr. Yay.