You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Aleksey Vorona <av...@ea.com> on 2012/08/28 01:22:02 UTC

Null Pointer Exception on DIH with MySQL

We have Solr 3.6.1 running on Jetty (7.x) and using DIH to get data from 
the MySQL database. On one of the environment the import always fails 
with an exception: http://pastebin.com/tG28cHPe

It is a null pointer exception on connection being null. I've tested 
that I can connect from the Solr server to Mysql server via command line 
mysql client.

Does anybody knows anything about this exception and how to fix it?

I am not able to reproduce it on any other environment.

-- Aleksey

Re: Null Pointer Exception on DIH with MySQL

Posted by Erick Erickson <er...@gmail.com>.
I really, really, really _hate_ it when I have to blame mysterious
corruptions and the problem magically goes away, it leaves
me worried that the problem is just lurking out there
somewhere waiting...waiting....waiting with my name on it
<G>...

Anyway, thanks for bringing closure to this.

Erick

On Thu, Aug 30, 2012 at 2:01 AM, Aleksey Vorona <av...@ea.com> wrote:
> Thank you for the reply. We rebuilt solr from sources, reinstalled it and
> the problem went away. As it was never reproducible on any other server, I
> blame some mysterious java byte code corruption on that server. The
> assumption I would never be able to verify, because we did not make a copy
> of the previous binaries.
>
> -- Aleksey
>
>
> On 12-08-29 06:17 PM, Erick Erickson wrote:
>>
>> Not much information to go on here, have you tried the DIH
>> debugging console? See:
>> http://wiki.apache.org/solr/DataImportHandler#interactive
>>
>> Best
>> Erick
>>
>> On Mon, Aug 27, 2012 at 7:22 PM, Aleksey Vorona <av...@ea.com> wrote:
>>>
>>> We have Solr 3.6.1 running on Jetty (7.x) and using DIH to get data from
>>> the
>>> MySQL database. On one of the environment the import always fails with an
>>> exception: http://pastebin.com/tG28cHPe
>>>
>>> It is a null pointer exception on connection being null. I've tested that
>>> I
>>> can connect from the Solr server to Mysql server via command line mysql
>>> client.
>>>
>>> Does anybody knows anything about this exception and how to fix it?
>>>
>>> I am not able to reproduce it on any other environment.
>>>
>>> -- Aleksey
>
>

Re: Null Pointer Exception on DIH with MySQL

Posted by Aleksey Vorona <av...@ea.com>.
Thank you for the reply. We rebuilt solr from sources, reinstalled it 
and the problem went away. As it was never reproducible on any other 
server, I blame some mysterious java byte code corruption on that 
server. The assumption I would never be able to verify, because we did 
not make a copy of the previous binaries.

-- Aleksey

On 12-08-29 06:17 PM, Erick Erickson wrote:
> Not much information to go on here, have you tried the DIH
> debugging console? See:
> http://wiki.apache.org/solr/DataImportHandler#interactive
>
> Best
> Erick
>
> On Mon, Aug 27, 2012 at 7:22 PM, Aleksey Vorona <av...@ea.com> wrote:
>> We have Solr 3.6.1 running on Jetty (7.x) and using DIH to get data from the
>> MySQL database. On one of the environment the import always fails with an
>> exception: http://pastebin.com/tG28cHPe
>>
>> It is a null pointer exception on connection being null. I've tested that I
>> can connect from the Solr server to Mysql server via command line mysql
>> client.
>>
>> Does anybody knows anything about this exception and how to fix it?
>>
>> I am not able to reproduce it on any other environment.
>>
>> -- Aleksey


Re: Null Pointer Exception on DIH with MySQL

Posted by Erick Erickson <er...@gmail.com>.
Not much information to go on here, have you tried the DIH
debugging console? See:
http://wiki.apache.org/solr/DataImportHandler#interactive

Best
Erick

On Mon, Aug 27, 2012 at 7:22 PM, Aleksey Vorona <av...@ea.com> wrote:
> We have Solr 3.6.1 running on Jetty (7.x) and using DIH to get data from the
> MySQL database. On one of the environment the import always fails with an
> exception: http://pastebin.com/tG28cHPe
>
> It is a null pointer exception on connection being null. I've tested that I
> can connect from the Solr server to Mysql server via command line mysql
> client.
>
> Does anybody knows anything about this exception and how to fix it?
>
> I am not able to reproduce it on any other environment.
>
> -- Aleksey