Shawn, first off thanks for the reply and links!

"As far as the error in the 5.0.8 version, does the import work, or does it
fail when the exception is thrown?"
- The import "works" for about 5-10 minutes then it fails and everything is
rolled-back one the above exception is thrown.

" You might also try doing as it says and increasing the timeout on the
server"
- How is this accomplished? I tried "maxWait" options on the datasource in
data-config.xml but that didn't seem to work.

I'm also torn on whether or not I should file a bug that may or not exist.
The whole reason I tried downgrading to 5.0.8 was due to the fact that
during certain (not all) delta-imports I keep getting the following error
which seems to be all mysql related: 

SEVERE: Delta Import Failed
java.lang.StackOverflowError
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
        at 
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
        at java.io.BufferedOutputStream.write(BufferedOutputStream.java:126)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3296)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
        at
com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1545)
        at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic.java:201)
        at com.mysql.jdbc.ResultSetImpl.realClose(ResultSetImpl.java:7624)
        at com.mysql.jdbc.ResultSetImpl.close(ResultSetImpl.java:908)
        at com.mysql.jdbc.StatementImpl.realClose(StatementImpl.java:2364)
        at
com.mysql.jdbc.ConnectionImpl.closeAllOpenStatements(ConnectionImpl.java:1583)
        at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4454)
        at com.mysql.jdbc.ConnectionImpl.cleanup(ConnectionImpl.java:1359)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2723)
        at
com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1545)
        at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic.java:201)
        at com.mysql.jdbc.ResultSetImpl.realClose(ResultSetImpl.java:7624)
        at com.mysql.jdbc.ResultSetImpl.close(ResultSetImpl.java:908)
        at com.mysql.jdbc.StatementImpl.realClose(StatementImpl.java:2364)
        at
com.mysql.jdbc.ConnectionImpl.closeAllOpenStatements(ConnectionImpl.java:1583)
        at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4454)
        at com.mysql.jdbc.ConnectionImpl.cleanup(ConnectionImpl.java:1359)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2723)
        .... and it keeps going

Once the above exception occurs I can never delta-import again against that
index. I am then forced to do a full-import. Do you have any thoughts or
suggestions on that? Should I file this as a MySQL bug?

Thanks again for your help. I'll try playing around with the latest versions
of the connector and I'll post my results.

-- 
View this message in context: 
http://lucene.472066.n3.nabble.com/Recommended-MySQL-JDBC-driver-tp817458p817790.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to