MySQL Bugs: #24031: Unsupported MySQL 4.1 Vars Cause Data Collection Exceptions

Bug #24031	Unsupported MySQL 4.1 Vars Cause Data Collection Exceptions
Submitted:	7 Nov 2006 4:30	Modified:	8 Nov 2006 20:31
Reporter:	Punita Srivastava	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Enterprise Monitor: Server	Severity:	S1 (Critical)
Version:	0.7.25	OS:	Linux (rhel4)
Assigned to:	Darren Oldag	CPU Architecture:	Any

Description:
I have tested this before and it used to work(meaning there were no exceptions),  but not for this build. Here is the jdbc.html log. The log is uploaded to my users dir.
-----------------------jdbc.html---------------------
<html>^M
<span style="font-family: courier new,courier,monospace;"><font size="-1">2006-1
1-06T20:44:02.893Z&nbsp;<span style="color: rgb(0,   255,   0); font-weight: bol
d;">Information&nbsp;&nbsp;&nbsp;&nbsp;</span>Starting JDBC connection pool.</sp
an></font><br>^M
<br><pre>
<span style="font-family: courier new,courier,monospace;"><font size="-1">2006-1
1-06T21:05:43.224Z&nbsp;<span style="color: rgb(255,  0,    0); font-weight: bol
d;">Error&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>com.
mysql.merlin.server.monitors.MonitorException: E1088:  The server "TheQueens41Bo
x-AustinTX-WinXp:3307" does not support "innodb_support_xa".
        at com.mysql.merlin.server.monitors.MonitorService.scheduleMonitor(Monit
orService.java:306)
        at com.mysql.merlin.server.monitors.MonitorService.access$100(MonitorSer
vice.java:72)
        at com.mysql.merlin.server.monitors.MonitorService$2.execute(MonitorServ
ice.java:277)
        at com.mysql.util.jdbctemplate.ActionExecutor.execute(ActionExecutor.jav
a:56)
        at com.mysql.merlin.server.db.GeneralOperations.execute(GeneralOperation
s.java:92)
        at com.mysql.merlin.server.monitors.MonitorService.scheduleMonitor(Monit
orService.java:281)
        at com.mysql.merlin.server.monitors.MonitorService.scheduleMonitorTransa
ction(MonitorService.java:270)
        at com.mysql.merlin.server.monitors.MonitorCommandProcessor.createMonito
rSchedule(MonitorCommandProcessor.java:178)
        at com.mysql.merlin.server.monitors.MonitorCommandProcessor.processReque
st(MonitorCommandProcessor.java:70)
        at com.mysql.merlin.server.MerlinServlet.processRequest(MerlinServlet.ja
va:120)
        at com.mysql.merlin.server.MerlinServlet.doCommon(MerlinServlet.java:92)
        at com.mysql.merlin.server.MerlinServlet.doPost(MerlinServlet.java:68)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
                                                              1,1           Top
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
        at java.lang.Thread.run(Thread.java:595)
</span></font><br>^M
</pre>
<br><br><pre>
<span style="font-family: courier new,courier,monospace;"><font size="-1">2006-1
1-06T23:02:14.499Z&nbsp;<span style="color: rgb(255,  0,    0); font-weight: bol
d;">Error&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>SQL:
 INSERT INTO dc_integer   VALUES(NULL,?,?,?,?)
PARAMS:  (Integer): '7'  (Long): '27301'  (Timestamp): '2006-11-07 00:02:00.011'
  (Timestamp): '2006-11-07 00:02:00.011'
ErrorCode: 1062
com.mysql.util.jdbctemplate.SQLRuntimeException: com.mysql.jdbc.exceptions.MySQL
IntegrityConstraintViolationException: Duplicate entry '7-2006-11-07 00:02:00-20
06-11-07 00:02:00' for key 3
        at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdateReturningKeys(J
DBCTemplate.java:139)
        at com.mysql.merlin.server.db.GeneralOperations.executeUpdateAutoIncreme
nt(GeneralOperations.java:190)
        at com.mysql.merlin.server.collect.dao.ItemsOperations.insertDC_TYPE(Ite
msOperations.java:915)
@        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
 ---------------------end of paste---------

How to repeat:
- Schedule all Performance Rules for a 4.1 mysql server
- You will get errors(for vars not supported) which is expected- but you get exceptions in the log

This is a duplicate of Bug #23954: Stack trace in JDBC.html when scheduling non-supported DC.  Note that this stack trace is only generated when you schedule the rule -- it doesn't keep filling the log.