4 Replies Latest reply on Dec 11, 2007 1:01 PM by danielgallot

    JBoss refuses to start again after stopping/starting MySQL

    danielgallot
    danielgallot Dec 10, 2007 1:33 PM

      Hi,

      I have got a pb running AS 4.2.2 + portal 2.6.2 after stopping/starting MySQL 5.0.26.

      Everything was running OK.
      I have just stopped/started MySQL to change a variable value (max_allowed_packet). First I had stopped JBoss, and after MySQL being running again, I had started JBoss again. But then JBoss makes an error :

      18:02:47,654 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
18:02:47,797 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
18:02:48,103 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.)
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)
 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)


      I have tried several times to start/stop everything, putting again the first MySQL variable value, verifying it is possible to connect to MySQL (command line, MySQL admin). But I did not get again JBoss connecting to MySQL.
      I don't understand what has changed.
      It is like if stopping/starting MySQL, something changed on MySQL server but I don't see what.

      If somebody can give me some help, that would be very nice.
      Thanks a lot.


      • 2012 Views
      • Tags:
        • 1. Re: JBoss refuses to start again after stopping/starting MyS
          peterj
          peterj Dec 10, 2007 1:48 PM (in response to danielgallot)

          Based on the location of the error immediately after the establishment of DefaultDS, I assume that the error messages concern that datasource (the portal uses PortlaDS, not DefaultDS, and it is opened much later in the console output). I therefore assume that you replaced the hsqldb-ds.xml file, which uses Hypersonic to manage DefaultDS, with another *-ds.xml file to use MySQL for DefaultDS. Could you post the contents of that *-ds.xml file.

            • Actions
          • 2. Re: JBoss refuses to start again after stopping/starting MyS
            danielgallot
            danielgallot Dec 10, 2007 2:19 PM (in response to danielgallot)

            here it is :

            <!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->

<datasources>
 <local-tx-datasource>
 <jndi-name>DefaultDS</jndi-name>
 <connection-url>jdbc:mysql://localhost:3306/jboss_appserver</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>mco</user-name>
 <password>TefNout</password>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
 <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>


            It worked fine before stopping/starting MySQL.
            It was the first time I stop/start MySQL since the JBoss installation.

            Thanks for your help.


              • Actions
            • 3. Re: JBoss refuses to start again after stopping/starting MyS
              peterj
              peterj Dec 10, 2007 2:52 PM (in response to danielgallot)

              What operating system (and version) are you using? What version of mysql?

              If you run the mysql command line utility, can you log into mysql with the user-name and password in you *-ds.xml file and then access the jboss_appserver database?

                • Actions
              • 4. Re: JBoss refuses to start again after stopping/starting MyS
                danielgallot
                danielgallot Dec 11, 2007 1:01 PM (in response to danielgallot)

                I have looked for a pb around modifications of MySQL variables.
                And I have found that the "skip-networking" parameter has been added.
                How was it added ? I suspect some MySQL administrator using and saving, but first without effect since MySQL was not restarted.

                Thanks for your replies.

                  • Actions