Hide Forgot
Date of First Response: 2008-06-17 08:52:01 project_key: SOA Un-deploying and deploying the QS raises this exception - server.log attached 16:51:23,549 INFO [JBoss4ESBDeployer] create esb service, Quickstart_helloworld_TX_SQL_action.esb 16:51:23,728 ERROR [H2Database] Failed to start database org.h2.jdbc.JdbcSQLException: Exception opening port 9095 (port may be in use), cause: java.net.BindException: Address already in use [90061-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:103) at org.h2.util.NetUtils.createServerSocket(NetUtils.java:66) at org.h2.server.TcpServer.start(TcpServer.java:182) at org.h2.tools.Server.start(Server.java:412) at org.jboss.internal.soa.esb.dependencies.H2Database$1.run(H2Database.java:434) Caused by: java.net.BindException: Address already in use at java.net.PlainSocketImpl.socketBind(Native Method) at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359) at java.net.ServerSocket.bind(ServerSocket.java:319) at java.net.ServerSocket.<init>(ServerSocket.java:185) at java.net.ServerSocket.<init>(ServerSocket.java:97) at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:97) ... 4 more
Link: Added: This issue related SOA-514
To recreate the bug: ant deploy ant runtest ant undeploy ant deploy
Attachment: Added: server.log
Is this related to this change in: jboss-soa-p.4.2.0/jboss-as/samples/quickstarts/helloworld_tx_sql_action/quickstart-ds.xml <?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>HelloworldTxSqlDB</jndi-name> <connection-url>jdbc:h2:tcp://localhost:9095/;DB_CLOSE_ON_EXIT=FALSE</connection-url> <driver-class>org.h2.Driver</driver-class> <user-name>sa</user-name> <password/> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <idle-timeout-minutes>0</idle-timeout-minutes> <prepared-statement-cache-size>32</prepared-statement-cache-size> <depends>jboss:service=HelloworldTxSqlDB</depends> </local-tx-datasource> <mbean code="org.jboss.internal.soa.esb.dependencies.H2Database" name="jboss:service=HelloworldTxSqlDB"> <attribute name="Database">HelloworldTxSqlDB</attribute> <attribute name="ServerMode">true</attribute> <attribute name="Port">9095</attribute> <attribute name="InMemoryMode">false</attribute> </mbean> </datasources> ~ ~ ~
This is a new problem in CP02.
The shutdown of the H2 server in H2Database.stopRemoteDatabase() is not shutting down the tcp server. We only use this type of database for the example so we could choose to document it and fix it later.
Link: Added: This issue depends JBESB-1818
Fixed in CR3.
Still a problem in CP02 CR3 build: 16:07:15,177 INFO [JDBCDataStore] Generated token 'authToken:F954B680-415F-11DD-A575-9832292E2E8C' for user: 'jbossesb/JBoss ESB User' 16:07:15,216 INFO [DeleteBindingFunction] Publisher 'jbossesb' deleted BindingTemplate with key: EFE3B880-415F-11DD-A575-D5DD9D3530D3 16:07:15,248 INFO [ConnectionFactoryBindingService] Unbound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=HelloworldTxSqlDB' from JNDI name 'java:HelloworldTxSqlDB' 16:07:30,559 INFO [JBoss4ESBDeployer] create esb service, Quickstart_helloworld_TX_SQL_action.esb 16:07:30,619 ERROR [H2Database] Failed to start database org.h2.jdbc.JdbcSQLException: Exception opening port 9095 (port may be in use), cause: java.net.BindException: Address already in use [90061-68] at org.h2.message.Message.getSQLException(Message.java:91) at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:103) at org.h2.util.NetUtils.createServerSocket(NetUtils.java:66) at org.h2.server.TcpServer.start(TcpServer.java:182) at org.h2.tools.Server.start(Server.java:412) at org.jboss.internal.soa.esb.dependencies.H2Database$1.run(H2Database.java:434) Caused by: java.net.BindException: Address already in use at java.net.PlainSocketImpl.socketBind(Native Method) at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359) at java.net.ServerSocket.bind(ServerSocket.java:319) at java.net.ServerSocket.<init>(ServerSocket.java:185) at java.net.ServerSocket.<init>(ServerSocket.java:97) at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:97) ... 4 more 16:07:30,627 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=HelloworldTxSqlDB' to JNDI name 'java:HelloworldTxSqlDB' 16:07:30,634 INFO [DatabaseInitializer] java:/HelloworldTxSqlDB datasource is already initialized 16:07:30,763 INFO [JDBCDataStore] Generated token 'authToken:029E7D70-4160-11DD-A575-CD22C89B8CE5' for user: 'jbossesb/JBoss ESB User' 16:07:31,583 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
This change was applied http://viewvc.jboss.org/cgi-bin/viewvc.cgi/labs/labs/jbossesb/workspace/platform/JBESB_4_2_1_SOA_4_2/product/rosetta/src/org/jboss/internal/soa/esb/dependencies/H2Database.java?r1=20698&r2=20697&pathrev=20698
There was a miscommunication between Trev and myself, none of the changes associated with this merge were pulled into the build.
Verified resolved in CP02 CR4 build.