You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@nutch.apache.org by Ramsel Ruiz <si...@gmail.com> on 2012/05/12 01:25:34 UTC
Nutchgora - SQLTransientConnectionException?
I just checked out nutchgora on Wednesday, and I'm getting exceptions
trying to run an initial crawl. I found some threads regarding this issue
but not sure if it was ever solved:
http://old.nabble.com/java.net.ConnectException%3A-Connection-refused-with-Hsqldb-2.2.8-during-mock-tests-tt33648175.html#a33691612
Anyone have any suggestions?
Exception in thread "main" org.apache.gora.util.GoraException:
java.io.IOException: java.sql.SQLTransientConnectionException:
java.net.ConnectException: Connection refused
at
org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:167)
at
org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:135)
at
org.apache.nutch.storage.StorageUtils.createWebStore(StorageUtils.java:69)
at org.apache.nutch.crawl.InjectorJob.run(InjectorJob.java:243)
at org.apache.nutch.crawl.Crawler.runTool(Crawler.java:68)
at org.apache.nutch.crawl.Crawler.run(Crawler.java:136)
at org.apache.nutch.crawl.Crawler.run(Crawler.java:250)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.nutch.crawl.Crawler.main(Crawler.java:257)
Caused by: java.io.IOException: java.sql.SQLTransientConnectionException:
java.net.ConnectException: Connection refused
at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:747)
at org.apache.gora.sql.store.SqlStore.initialize(SqlStore.java:160)
at
org.apache.gora.store.DataStoreFactory.initializeDataStore(DataStoreFactory.java:102)
at
org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:161)
... 8 more
Caused by: java.sql.SQLTransientConnectionException:
java.net.ConnectException: Connection refused
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:739)
... 11 more
Caused by: org.hsqldb.HsqlException: java.net.ConnectException: Connection
refused
at org.hsqldb.ClientConnection.openConnection(Unknown Source)
at org.hsqldb.ClientConnection.initConnection(Unknown Source)
at org.hsqldb.ClientConnection.<init>(Unknown Source)
... 17 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
at java.net.Socket.connect(Socket.java:525)
at java.net.Socket.connect(Socket.java:475)
at java.net.Socket.<init>(Socket.java:372)
at java.net.Socket.<init>(Socket.java:186)
at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
... 20 more
Re: Nutchgora - SQLTransientConnectionException?
Posted by Lewis John Mcgibbney <le...@gmail.com>.
Another thing here. Although you will see gora-sql 0.2 dependency on
Maven central don't pull it as we need to rewrite the entire module
with another license firendly API... we're focusing on JOOQ but
unfortunately the work hasn't really kicked off yet.
Please stick to gora-sql 0.1.1-incubating for the time being.
Thanks
On Wed, May 16, 2012 at 8:19 PM, Ramsel Ruiz <si...@gmail.com> wrote:
> Lewis,
>
> It was a simple HSQLDB config error.
>
> Thanks!
>
>
> On Fri, May 11, 2012 at 4:33 PM, Lewis John Mcgibbney <
> lewis.mcgibbney@gmail.com> wrote:
>
>> Hi Ramsel,
>>
>> It would be great if you could provide what configuration you have
>> included, also whether or not you are keeping up to date with HEAD?
>>
>> This is most likely something to do with your HSQLDB configuration not
>> matching between server and gora.properties configuration
>>
>> Lewis
>>
>> On Sat, May 12, 2012 at 12:25 AM, Ramsel Ruiz
>> <si...@gmail.com> wrote:
>> > I just checked out nutchgora on Wednesday, and I'm getting exceptions
>> > trying to run an initial crawl. I found some threads regarding this issue
>> > but not sure if it was ever solved:
>> >
>> http://old.nabble.com/java.net.ConnectException%3A-Connection-refused-with-Hsqldb-2.2.8-during-mock-tests-tt33648175.html#a33691612
>> >
>> > Anyone have any suggestions?
>> >
>> > Exception in thread "main" org.apache.gora.util.GoraException:
>> > java.io.IOException: java.sql.SQLTransientConnectionException:
>> > java.net.ConnectException: Connection refused
>> > at
>> >
>> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:167)
>> > at
>> >
>> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:135)
>> > at
>> >
>> org.apache.nutch.storage.StorageUtils.createWebStore(StorageUtils.java:69)
>> > at org.apache.nutch.crawl.InjectorJob.run(InjectorJob.java:243)
>> > at org.apache.nutch.crawl.Crawler.runTool(Crawler.java:68)
>> > at org.apache.nutch.crawl.Crawler.run(Crawler.java:136)
>> > at org.apache.nutch.crawl.Crawler.run(Crawler.java:250)
>> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>> > at org.apache.nutch.crawl.Crawler.main(Crawler.java:257)
>> > Caused by: java.io.IOException: java.sql.SQLTransientConnectionException:
>> > java.net.ConnectException: Connection refused
>> > at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:747)
>> > at org.apache.gora.sql.store.SqlStore.initialize(SqlStore.java:160)
>> > at
>> >
>> org.apache.gora.store.DataStoreFactory.initializeDataStore(DataStoreFactory.java:102)
>> > at
>> >
>> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:161)
>> > ... 8 more
>> > Caused by: java.sql.SQLTransientConnectionException:
>> > java.net.ConnectException: Connection refused
>> > at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
>> > at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
>> > at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
>> > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
>> > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
>> > at java.sql.DriverManager.getConnection(DriverManager.java:582)
>> > at java.sql.DriverManager.getConnection(DriverManager.java:185)
>> > at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:739)
>> > ... 11 more
>> > Caused by: org.hsqldb.HsqlException: java.net.ConnectException:
>> Connection
>> > refused
>> > at org.hsqldb.ClientConnection.openConnection(Unknown Source)
>> > at org.hsqldb.ClientConnection.initConnection(Unknown Source)
>> > at org.hsqldb.ClientConnection.<init>(Unknown Source)
>> > ... 17 more
>> > Caused by: java.net.ConnectException: Connection refused
>> > at java.net.PlainSocketImpl.socketConnect(Native Method)
>> > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
>> > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
>> > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
>> > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
>> > at java.net.Socket.connect(Socket.java:525)
>> > at java.net.Socket.connect(Socket.java:475)
>> > at java.net.Socket.<init>(Socket.java:372)
>> > at java.net.Socket.<init>(Socket.java:186)
>> > at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
>> > ... 20 more
>>
>>
>>
>> --
>> Lewis
>>
--
Lewis
Re: Nutchgora - SQLTransientConnectionException?
Posted by Ramsel Ruiz <si...@gmail.com>.
Lewis,
It was a simple HSQLDB config error.
Thanks!
On Fri, May 11, 2012 at 4:33 PM, Lewis John Mcgibbney <
lewis.mcgibbney@gmail.com> wrote:
> Hi Ramsel,
>
> It would be great if you could provide what configuration you have
> included, also whether or not you are keeping up to date with HEAD?
>
> This is most likely something to do with your HSQLDB configuration not
> matching between server and gora.properties configuration
>
> Lewis
>
> On Sat, May 12, 2012 at 12:25 AM, Ramsel Ruiz
> <si...@gmail.com> wrote:
> > I just checked out nutchgora on Wednesday, and I'm getting exceptions
> > trying to run an initial crawl. I found some threads regarding this issue
> > but not sure if it was ever solved:
> >
> http://old.nabble.com/java.net.ConnectException%3A-Connection-refused-with-Hsqldb-2.2.8-during-mock-tests-tt33648175.html#a33691612
> >
> > Anyone have any suggestions?
> >
> > Exception in thread "main" org.apache.gora.util.GoraException:
> > java.io.IOException: java.sql.SQLTransientConnectionException:
> > java.net.ConnectException: Connection refused
> > at
> >
> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:167)
> > at
> >
> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:135)
> > at
> >
> org.apache.nutch.storage.StorageUtils.createWebStore(StorageUtils.java:69)
> > at org.apache.nutch.crawl.InjectorJob.run(InjectorJob.java:243)
> > at org.apache.nutch.crawl.Crawler.runTool(Crawler.java:68)
> > at org.apache.nutch.crawl.Crawler.run(Crawler.java:136)
> > at org.apache.nutch.crawl.Crawler.run(Crawler.java:250)
> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> > at org.apache.nutch.crawl.Crawler.main(Crawler.java:257)
> > Caused by: java.io.IOException: java.sql.SQLTransientConnectionException:
> > java.net.ConnectException: Connection refused
> > at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:747)
> > at org.apache.gora.sql.store.SqlStore.initialize(SqlStore.java:160)
> > at
> >
> org.apache.gora.store.DataStoreFactory.initializeDataStore(DataStoreFactory.java:102)
> > at
> >
> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:161)
> > ... 8 more
> > Caused by: java.sql.SQLTransientConnectionException:
> > java.net.ConnectException: Connection refused
> > at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> > at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> > at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
> > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
> > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
> > at java.sql.DriverManager.getConnection(DriverManager.java:582)
> > at java.sql.DriverManager.getConnection(DriverManager.java:185)
> > at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:739)
> > ... 11 more
> > Caused by: org.hsqldb.HsqlException: java.net.ConnectException:
> Connection
> > refused
> > at org.hsqldb.ClientConnection.openConnection(Unknown Source)
> > at org.hsqldb.ClientConnection.initConnection(Unknown Source)
> > at org.hsqldb.ClientConnection.<init>(Unknown Source)
> > ... 17 more
> > Caused by: java.net.ConnectException: Connection refused
> > at java.net.PlainSocketImpl.socketConnect(Native Method)
> > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
> > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
> > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
> > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
> > at java.net.Socket.connect(Socket.java:525)
> > at java.net.Socket.connect(Socket.java:475)
> > at java.net.Socket.<init>(Socket.java:372)
> > at java.net.Socket.<init>(Socket.java:186)
> > at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
> > ... 20 more
>
>
>
> --
> Lewis
>
Re: Nutchgora - SQLTransientConnectionException?
Posted by Lewis John Mcgibbney <le...@gmail.com>.
Hi Ramsel,
It would be great if you could provide what configuration you have
included, also whether or not you are keeping up to date with HEAD?
This is most likely something to do with your HSQLDB configuration not
matching between server and gora.properties configuration
Lewis
On Sat, May 12, 2012 at 12:25 AM, Ramsel Ruiz
<si...@gmail.com> wrote:
> I just checked out nutchgora on Wednesday, and I'm getting exceptions
> trying to run an initial crawl. I found some threads regarding this issue
> but not sure if it was ever solved:
> http://old.nabble.com/java.net.ConnectException%3A-Connection-refused-with-Hsqldb-2.2.8-during-mock-tests-tt33648175.html#a33691612
>
> Anyone have any suggestions?
>
> Exception in thread "main" org.apache.gora.util.GoraException:
> java.io.IOException: java.sql.SQLTransientConnectionException:
> java.net.ConnectException: Connection refused
> at
> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:167)
> at
> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:135)
> at
> org.apache.nutch.storage.StorageUtils.createWebStore(StorageUtils.java:69)
> at org.apache.nutch.crawl.InjectorJob.run(InjectorJob.java:243)
> at org.apache.nutch.crawl.Crawler.runTool(Crawler.java:68)
> at org.apache.nutch.crawl.Crawler.run(Crawler.java:136)
> at org.apache.nutch.crawl.Crawler.run(Crawler.java:250)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.nutch.crawl.Crawler.main(Crawler.java:257)
> Caused by: java.io.IOException: java.sql.SQLTransientConnectionException:
> java.net.ConnectException: Connection refused
> at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:747)
> at org.apache.gora.sql.store.SqlStore.initialize(SqlStore.java:160)
> at
> org.apache.gora.store.DataStoreFactory.initializeDataStore(DataStoreFactory.java:102)
> at
> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:161)
> ... 8 more
> Caused by: java.sql.SQLTransientConnectionException:
> java.net.ConnectException: Connection refused
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
> at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
> at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager.java:582)
> at java.sql.DriverManager.getConnection(DriverManager.java:185)
> at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:739)
> ... 11 more
> Caused by: org.hsqldb.HsqlException: java.net.ConnectException: Connection
> refused
> at org.hsqldb.ClientConnection.openConnection(Unknown Source)
> at org.hsqldb.ClientConnection.initConnection(Unknown Source)
> at org.hsqldb.ClientConnection.<init>(Unknown Source)
> ... 17 more
> Caused by: java.net.ConnectException: Connection refused
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
> at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
> at java.net.Socket.connect(Socket.java:525)
> at java.net.Socket.connect(Socket.java:475)
> at java.net.Socket.<init>(Socket.java:372)
> at java.net.Socket.<init>(Socket.java:186)
> at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
> ... 20 more
--
Lewis