I confirm the problem is detected only on java 1.4 :
If the sequoia-driver (client application) see a controller down once, it never
can reconnect to this controller even when it is up.
To know more about this bug, I had in Driver.connectToNextController > catch
(IOException ioe) (line 550), this trace :
System.out.println("EXCEPTION : "+newController); ioe.printStackTrace();
With this scenario :
1 controller in raidb1 enabled (think raid level is not important)
1 client connect to controller and start to use vdb
stop the controller --> client continue to request vdb throws exception (normal
behaviour)
restart controller and activate backend
--> on a JVM 1.5 client can use the vdb
on a JVM 1.4 impossible to use vdb: we see in log (with my extra traces)
EXCEPTION : /172.19.1.61:9201
java.net.SocketException: Protocol family not supported
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:461)
at java.net.Socket.connect(Socket.java:411)
at
org.continuent.sequoia.driver.Driver.connectToNextController(Driver.java:522)
at
org.continuent.sequoia.driver.Driver.getConnectionToNewController(Driver.java:414)
at
org.continuent.sequoia.driver.Connection.reconnect(Connection.java:2599)
at
org.continuent.sequoia.driver.Connection.statementExecuteUpdate(Connection.java:2913)
at
org.continuent.sequoia.driver.Statement.executeUpdateWithSkeleton(Statement.java:585)
at
org.continuent.sequoia.driver.PreparedStatement.executeUpdate(PreparedStatement.java:184)
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de
BESSON-DEBLON, Pierre (SOGETI HIGH TECH)
Envoyé : 28 February 2008 16:49
À : Sequoia general mailing list
Objet : RE: [Sequoia] Controller down then up
-->java.net.SocketException:Protocol family not supported
Hi Emmanuel,
Client application do receive the error, the problem is that I think no
exception should be thrown (and the sql request be executed)!
We tried to force my client ipV4 (like in sequoia :
-Djava.net.preferIPv4Stack=true) --> no change
We tried to use a Jdk 1.6 for client and for controller --> it worked!! (sql
queries succeed after controller restart) The problem is that final plateform
is 1.4 (and can not be changed)
Any solution ?
Pierre
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de
Emmanuel Cecchet
Envoyé : 28 February 2008 16:37
À : Sequoia general mailing list
Objet : Re: [Sequoia] Controller down then up -->
java.net.SocketException:Protocol family not supported
Hi Pierre,
To answer your original question, the default behavior depends on what
you put in your JDBC URL (see Javadoc at
http://sequoia.continuent.org/doc/2.10/api/org/continuent/sequoia/driver/Driver.html
for details).
The Protocol family issue might be related to the use of IPv6 which is
not supported by Sequoia. But when no controllers are reachable anymore,
the driver is supposed to return an error to the application. If it does
not, then you should file a JIRA entry for that.
Thanks for your feedback,
Emmanuel
> I join a log from a client application with debugLevel=debug and additional
> log stuff
>
> It appears that client see controller is back (log Controller
> /172.19.1.61:9201 is up again).
> But when driver try to connect to, it can not :
>
> --> exception java.net.SocketException: Protocol family not supported
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
> at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
> at java.net.Socket.connect(Socket.java:461)
> at java.net.Socket.connect(Socket.java:411)
> at
> org.continuent.sequoia.driver.Driver.connectToNextController(Driver.java:522)
> ...
>
>
> then request fail and controller is mark as dead again (log Controller
> /172.19.1.61:9201 down - shutting down connected sockets).
>
> It loop like that for ever ...
>
> Some body has an idea ?
>
> Thanks in advance
>
>
> Pierre
>
> -----Message d'origine-----
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] la part de
> BESSON-DEBLON, Pierre (SOGETI HIGH TECH)
> Envoyé : 28 February 2008 11:39
> À : Sequoia general mailing list
> Objet : [Sequoia] Controller down then up
>
>
> Hi,
>
> How works sequoia driver with controller down ?
>
> We have 2 controllers (A & B) alive.
> client start a connection.
> A is shutdown.
> A is up and reactivated
> B is shutdown
>
> our client can not execute queries
> --> DriverSQLException : Connection lost ... and automatic reconnect failed
>
> Is this default behaviour ?
>
>
> Thanks in advance
>
>
>
> Pierre
>
> The information in this e-mail is confidential. The contents may not be
> disclosed or used by anyone other then the addressee. Access to this e-mail
> by anyone else is unauthorised.
> If you are not the intended recipient, please notify Airbus immediately and
> delete this e-mail.
> Airbus cannot accept any responsibility for the accuracy or completeness of
> this e-mail as it has been sent over public networks. If you have any
> concerns over the content of this message or its Accuracy or Integrity,
> please contact Airbus immediately.
> All outgoing e-mails from Airbus are checked using regularly updated virus
> scanning software but you should take whatever measures you deem to be
> appropriate to ensure that this message and any attachments are virus free.
>
>
> _______________________________________________
> Sequoia mailing list
> [email protected]
> https://forge.continuent.org/mailman/listinfo/sequoia
>
> This mail has originated outside your organization, either from an external
> partner or the Global Internet.
> Keep this in mind if you answer this message.
>
>
>
> The information in this e-mail is confidential. The contents may not be
> disclosed or used by anyone other then the addressee. Access to this e-mail
> by anyone else is unauthorised.
> If you are not the intended recipient, please notify Airbus immediately and
> delete this e-mail.
> Airbus cannot accept any responsibility for the accuracy or completeness of
> this e-mail as it has been sent over public networks. If you have any
> concerns over the content of this message or its Accuracy or Integrity,
> please contact Airbus immediately.
> All outgoing e-mails from Airbus are checked using regularly updated virus
> scanning software but you should take whatever measures you deem to be
> appropriate to ensure that this message and any attachments are virus free.
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Sequoia mailing list
> [email protected]
> https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
This mail has originated outside your organization, either from an external
partner or the Global Internet.
Keep this in mind if you answer this message.
The information in this e-mail is confidential. The contents may not be
disclosed or used by anyone other then the addressee. Access to this e-mail by
anyone else is unauthorised.
If you are not the intended recipient, please notify Airbus immediately and
delete this e-mail.
Airbus cannot accept any responsibility for the accuracy or completeness of
this e-mail as it has been sent over public networks. If you have any concerns
over the content of this message or its Accuracy or Integrity, please contact
Airbus immediately.
All outgoing e-mails from Airbus are checked using regularly updated virus
scanning software but you should take whatever measures you deem to be
appropriate to ensure that this message and any attachments are virus free.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
This mail has originated outside your organization, either from an external
partner or the Global Internet.
Keep this in mind if you answer this message.
The information in this e-mail is confidential. The contents may not be
disclosed or used by anyone other then the addressee. Access to this e-mail by
anyone else is unauthorised.
If you are not the intended recipient, please notify Airbus immediately and
delete this e-mail.
Airbus cannot accept any responsibility for the accuracy or completeness of
this e-mail as it has been sent over public networks. If you have any concerns
over the content of this message or its Accuracy or Integrity, please contact
Airbus immediately.
All outgoing e-mails from Airbus are checked using regularly updated virus
scanning software but you should take whatever measures you deem to be
appropriate to ensure that this message and any attachments are virus free.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
