How to solve this problem

Anonymous — Sat, 16 Nov 2024 13:28:38 GMT

Hi
i am using Talend 3.0 version some time this error occur please tell how to solve this error..

Starting job Repeat_trouble_ticket_hsi_19_03_2010 at 11:41 05/04/2010.
connecting to socket on port 3474
connected
Exception in component tMysqlInput_5
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The driver was unable to create a connection due to an inability to establish the client portion of a socket.
This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable.
For Unix-based platforms, see the manual page for the 'ulimit' command. Kernel or system reconfiguration may also be required.
For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2001)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.tMysqlInput_5Process(Repeat_trouble_ticket_hsi_19_03_2010.java:8933)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.tMysqlInput_4Process(Repeat_trouble_ticket_hsi_19_03_2010.java:2483)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.tMysqlInput_1Process(Repeat_trouble_ticket_hsi_19_03_2010.java:1267)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.runJobInTOS(Repeat_trouble_ticket_hsi_19_03_2010.java:10027)
at hsbb_assurance.repeat_trouble_ticket_hsi_19_03_2010_0_1.Repeat_trouble_ticket_hsi_19_03_2010.main(Repeat_trouble_ticket_hsi_19_03_2010.java:9918)
Caused by: java.net.BindException: Address already in use: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:168)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:262)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1926)
... 15 more
disconnected
Job Repeat_trouble_ticket_hsi_19_03_2010 ended at 11:41 05/04/2010.

Re: How to solve this problem

Anonymous — Mon, 05 Apr 2010 09:14:14 GMT

Hello
It seems you are creating so many connections in the job, try to use tMysqlConnection to create the conneciton and use the same connection on tMysqlnput. See a related 2772
Best regards
Shong

topic Re: How to solve this problem in Talend Studio

How to solve this problem

Re: How to solve this problem