DIH MySQLNonTransientConnectionException
I have recently been receiving the following errors during my DIH importing. Has anyone ran into this issue before? Know how to resolve it? Thanks! Jan 1, 2011 4:51:06 PM org.apache.solr.handler.dataimport.JdbcDataSource closeConnection SEVERE: Ignoring Error when closing connection com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown. at sun.reflect.GeneratedConstructorAccessor29.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4751) at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4345) at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1564) at org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:399) at org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:390) at org.apache.solr.handler.dataimport.DataConfig$Entity.clearCache(DataConfig.java:174) at org.apache.solr.handler.dataimport.DataConfig$Entity.clearCache(DataConfig.java:165) at org.apache.solr.handler.dataimport.DataConfig.clearCaches(DataConfig.java:332) at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:360) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:391) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370) Jan 1, 2011 4:51:06 PM org.apache.solr.handler.dataimport.JdbcDataSource closeConnection SEVERE: Ignoring Error when closing connection java.sql.SQLException: Streaming result set com.mysql.jdbc.rowdatadyna...@71f18c82 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2724) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1895) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) at com.mysql.jdbc.ConnectionImpl.rollbackNoChecks(ConnectionImpl.java:4854) at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4737) at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4345) at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1564) at org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:399) at org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:390) at org.apache.solr.handler.dataimport.DataConfig$Entity.clearCache(DataConfig.java:174) at org.apache.solr.handler.dataimport.DataConfig.clearCaches(DataConfig.java:332) at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:360) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:391) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
Re: Spelling Suggestions vs Correction
Ah, didn't tumble to that
Not that I know of. I suspect that the way to handle this would be
to catch the response and inspect it and then fire off a second
query yourself in the middleware layer. That gives you the chance
to form the response page that the user sees and clearly show
that that you did something other than what they requested, even
though what they requested was nonsense.
Best
Erick
On Sat, Jan 1, 2011 at 9:23 AM, TxCSguy wrote:
>
>
>
> Thanks for the Reply Erick. I read through the link you provided as well
> as
> http://wiki.apache.org/solr/TermsComponent
> http://wiki.apache.org/solr/TermsComponent but that doesn't seem to be
> what
> I'm looking for. If a user searches for "pell", is there a way to have
> SOLR
> modify the query such that the highest-ranked spell correction ("dell" in
> this example) is search for by the query component rather than "pell".
> Right
> now, it seems that all that is happening is that "dell" is being returned
> as
> a suggestion, but the query component is still searching with "pell".
>
> Thanks in advance!
>
> -Mark
>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Spelling-Suggestions-vs-Correction-tp2172572p2176048.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
Re: Spelling Suggestions vs Correction
I have just been playing around with spell check and from what I can tell it
does not do that automatically, you would need to program that in your
application yourself, basically run a search, check the spellcheck, run the
search again if needed, and present the results to the user, not all that
complicated and you could do that recursively since you would not get a
spellcheck back on the second pass.
Cheers
François
On Jan 1, 2011, at 9:23 AM, TxCSguy wrote:
>
>
>
> Thanks for the Reply Erick. I read through the link you provided as well as
> http://wiki.apache.org/solr/TermsComponent
> http://wiki.apache.org/solr/TermsComponent but that doesn't seem to be what
> I'm looking for. If a user searches for "pell", is there a way to have SOLR
> modify the query such that the highest-ranked spell correction ("dell" in
> this example) is search for by the query component rather than "pell". Right
> now, it seems that all that is happening is that "dell" is being returned as
> a suggestion, but the query component is still searching with "pell".
>
> Thanks in advance!
>
> -Mark
>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Spelling-Suggestions-vs-Correction-tp2172572p2176048.html
> Sent from the Solr - User mailing list archive at Nabble.com.
Re: Spelling Suggestions vs Correction
Thanks for the Reply Erick. I read through the link you provided as well as
http://wiki.apache.org/solr/TermsComponent
http://wiki.apache.org/solr/TermsComponent but that doesn't seem to be what
I'm looking for. If a user searches for "pell", is there a way to have SOLR
modify the query such that the highest-ranked spell correction ("dell" in
this example) is search for by the query component rather than "pell". Right
now, it seems that all that is happening is that "dell" is being returned as
a suggestion, but the query component is still searching with "pell".
Thanks in advance!
-Mark
--
View this message in context:
http://lucene.472066.n3.nabble.com/Spelling-Suggestions-vs-Correction-tp2172572p2176048.html
Sent from the Solr - User mailing list archive at Nabble.com.
