Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: mysqld mxj shutdown trouble


Advanced Search

mysqld mxj shutdown trouble
Posted by: bruno haleblian ()
Date: February 18, 2007 05:03PM

Hi,
This my first test w/mxj sorry to be verbose...
According to doc chapter "23.5.5.4. Deployment in a standard JMX Agent environment (JBoss)" & "23.5.2.5. Deploying Connector/MXJ within JBoss"
I tried out Done a fresh download of mxj & done the basic jboss setup.
Except :
mysql-connector-java-3.1.4-beta-bin.jar replaced by mysql-connector-java-5.0.4-bin.jar

To get it start :
1 - IHad to copy also aspectjtr.jar, required in jboss/server/default/lib

2 - I Had to commentout datadir mbean attribute in mysqld-service.xml to avoid this :
23:53:02,767 INFO [STDOUT] [MysqldResource] launching mysqld (getOptions)
23:53:03,538 WARN [ServiceController] Problem creating service mysql:type=service,name=mysqld
java.lang.IllegalArgumentException: d:\tmp\mysql_data not equal to C:\Documents
and Settings\localbh\Local Settings\Temp\mysql-c.mxj\data

It nows starts fine

First tests OK : index.jsp test OK, access thru other JDBC tool (squirell) OK

However, the shutdown doesn't work ever from jmx-console and jboss shutdown :
mysqld process is stopped but jmx handler doesnot catch info
More over, innodb starts a recover on next startup (unclean shutdown detect).

shutdown log :
...
23:24:42,852 INFO [STDOUT] [MysqldResource] stopping mysqld (process: 2276)
23:25:15,459 ERROR [STDERR] [MysqldResource]

don't have to do that (already dead) :

23:25:15,459 ERROR [STDERR] [MysqldResource] attempting to "force kill" 2276
23:25:47,645 ERROR [STDERR] [MysqldResource]
23:25:47,645 ERROR [STDERR] [MysqldResource] 2276 not killed.
23:25:47,706 ERROR [STDERR] [MysqldResource]
23:25:47,706 ERROR [STDERR] [MysqldResource] Process 2276still running; not dele
ting C:\Documents and Settings\localbh\Local Settings\Temp\mysql-c.mxj\data\Mysq
ldResource.pid
23:25:47,706 INFO [STDOUT] [MysqldResource] clearing options
23:25:47,706 INFO [STDOUT] [MysqldResource] shutdown complete
23:25:47,846 INFO [STDOUT] [MysqldResource] launching mysqld (getOptions)
...
Shutdown complete

Platform : XPPro/Jboss404ga/SunJVM1.5.09/mxj504beta/mysqlconnector504

Ideas/tips/ ?

Thanks

Options: ReplyQuote


Subject Written By Posted
mysqld mxj shutdown trouble bruno haleblian 02/18/2007 05:03PM
Re: mysqld mxj shutdown trouble Eric Herman 06/05/2007 10:18AM
Re: mysqld mxj shutdown trouble jithesh c 06/20/2007 02:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.