Author Topic: agaw-runner SQL problem?  (Read 4320 times)

Wessel

  • Newbie
  • *
  • Posts: 18
  • Karma: 2
    • View Profile
agaw-runner SQL problem?
« on: December 18, 2008, 19:28:32 »
Hi running the agaw-runner under a normal linux user with the admin user a login account some how blows up with a strange error. Here are the details:

First thing I needed to to fix is that the line

VMOPTS=-server -Xmx256M -Xms256M

gives an error:
./agaw-runner.sh: line 14: -Xmx256M: command not found

Fixing this (I'm not a bash guru but i think it can be fixed like this)
VMOPTS='-server -Xmx256M -Xms256M'

After this the scripts starts up, but still gives some weired errors:

QM: 1.5.0
Java: 1.5.0_14
MySQL: Ver 14.12 Distrib 5.0.32
AppSer: TomCat 5.5

agaw-runner.sh
JAVA=/usr/bin/java
VMOPTS=-server -Xmx256M -Xms256M

USER=admin
PASS=admin
JDBC="jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude"
QMPATH=/var/lib/tomcat5.5/webapps/queuemetrics
ITER=10
IDLE=15000
RUNLOG=false
RUNLOGDIR=/root/runlog

MYSQLJAR=/usr/share/java/mysql-connector-java.jar  (5.0.4)
SERVLET=/usr/share/java/servlet-api.jar (2.4)
==============================

============
QM User name: admin
QM password:  admin
QM path:      /var/lib/tomcat5.5/webapps/queuemetrics
JDBC URI:     jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Number of loops:         10
Idle time between loops: 15000 ms
Keep run log: false
Run log dir: /root/runlog
Path: '/var/lib/tomcat5.5/webapps/queuemetrics/WEB-INF/agaw.properties'
Chiave: '5231317C-4E324465-6D6F2D31-2E352E30-2D52232D-23516D52-756E6E65-727C5333-31323539-38383132-30303030-307C'
 *** LOWAY TPF licence: to 'Demo-1.5.0-R' up to 'Fri Dec 04 00:00:00 CET 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 CET 2009
Data scad:Fri Dec 04 00:00:00 CET 2009 - Scaduto: 0
Servlet A01 - Step X3
Servlet A01 - Step X4 - 103
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Problema DB: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
   at it.loway.tpf.SQL.selectScalare(Unknown Source)
   at it.loway.app.queuemetrics.agaw.BO.AgentReader.closeRunsCreatedByAPreviousExecution(AgentReader.java:436)
   at it.loway.app.queuemetrics.agaw.QueueRunner.run(QueueRunner.java:157)
   at it.loway.app.queuemetrics.agaw.QueueRunner.main(QueueRunner.java:728)
-- End Inner Exception --

============
QM User name: admin
QM password:  admin
QM path:      /var/lib/tomcat5.5/webapps/queuemetrics
JDBC URI:     jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Number of loops:         10
Idle time between loops: 15000 ms
Keep run log: false
Run log dir: /root/runlog
Path: '/var/lib/tomcat5.5/webapps/queuemetrics/WEB-INF/agaw.properties'
Chiave: '5231317C-4E324465-6D6F2D31-2E352E30-2D52232D-23516D52-756E6E65-727C5333-31323539-38383132-30303030-307C'
 *** LOWAY TPF licence: to 'Demo-1.5.0-R' up to 'Fri Dec 04 00:00:00 CET 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 CET 2009
Data scad:Fri Dec 04 00:00:00 CET 2009 - Scaduto: 0
Servlet A01 - Step X3
============
QM User name: admin
QM password:  admin
QM path:      /var/lib/tomcat5.5/webapps/queuemetrics
JDBC URI:     jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Number of loops:         10
Idle time between loops: 15000 ms
Keep run log: false
Run log dir: /root/runlog
Path: '/var/lib/tomcat5.5/webapps/queuemetrics/WEB-INF/agaw.properties'
Chiave: '5231317C-4E324465-6D6F2D31-2E352E30-2D52232D-23516D52-756E6E65-727C5333-31323539-38383132-30303030-307C'
 *** LOWAY TPF licence: to 'Demo-1.5.0-R' up to 'Fri Dec 04 00:00:00 CET 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 CET 2009
Data scad:Fri Dec 04 00:00:00 CET 2009 - Scaduto: 0
Servlet A01 - Step X3
Servlet A01 - Step X4 - 103
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Problema DB: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
   at it.loway.tpf.SQL.selectScalare(Unknown Source)
   at it.loway.app.queuemetrics.agaw.BO.AgentReader.closeRunsCreatedByAPreviousExecution(AgentReader.java:436)
   at it.loway.app.queuemetrics.agaw.QueueRunner.run(QueueRunner.java:157)
   at it.loway.app.queuemetrics.agaw.QueueRunner.main(QueueRunner.java:728)
-- End Inner Exception --


Any hints ?  ???

Wessel

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: agaw-runner SQL problem?
« Reply #1 on: December 19, 2008, 09:23:40 »
Looks like it's a known bug, as of here: http://forum.queuemetrics.com/index.php?topic=402.0 - easy to fix though :)