Author Topic: agaw-runner.sh problem  (Read 4807 times)

tonils

  • Jr. Member
  • **
  • Posts: 54
  • Karma: 0
    • View Profile
    • Email
agaw-runner.sh problem
« on: December 09, 2008, 14:22:11 »
I am trying to get agaw-runner working on our internal QM box I get the following

asterisk:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/mysql-utils/agaw-runner # ./agaw-runner.sh
+ JAVA=/usr/bin/java
+ VMOPTS=-server
+ -Xmx256M -Xms256M
./agaw-runner.sh: line 15: -Xmx256M: command not found
+ USER=demoadmin
+ PASS=demo
+ JDBC='jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude'
+ QMPATH=/srv/www/tomcat5/base/webapps/QueueMetrics
+ ITER=10
+ IDLE=15000
+ RUNLOG=true
+ RUNLOGDIR=/tmp/agaw
+ MYSQLJAR=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar
+ SERVLET=/usr/share/tomcat5/common/lib/servletapi5.jar
+ ALLCFG='-Dagaw.user=demoadmin -Dagaw.password=demo -Dagaw.jdbc=jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude -Dagaw.qmInstance=/srv/www/tomcat5/base/webapps/QueueMetrics -Dagaw.nLoops=10 -Dagaw.idle=15000 -Dagaw.runlog=true -Dagaw.runlogdir=/tmp/agaw'
+ QMCLASS=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes
+ JARLIB=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib
+ QMARCH=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-155p.jar
+ QMJAR=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-1.5.0.jar
+ REDRPC=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.0.jar
+ CP=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-1.5.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-155p.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar:/usr/share/tomcat5/common/lib/servletapi5.jar
+ /usr/bin/java -Dagaw.user=demoadmin -Dagaw.password=demo '-Dagaw.jdbc=jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude' -Dagaw.qmInstance=/srv/www/tomcat5/base/webapps/QueueMetrics -Dagaw.nLoops=10 -Dagaw.idle=15000 -Dagaw.runlog=true -Dagaw.runlogdir=/tmp/agaw -cp /srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-1.5.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-155p.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.0.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar:/usr/share/tomcat5/common/lib/servletapi5.jar it.loway.app.queuemetrics.agaw.QueueRunner
============
QM User name: demoadmin
QM password:  demo
QM path:      /srv/www/tomcat5/base/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: true
Run log dir: /tmp/agaw
Path: '/srv/www/tomcat5/base/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 01:00:00 SAST 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 SAST 2009
Data scad:Fri Dec 04 00:00:00 SAST 2009 - Scaduto: 0
Servlet A01 - Step X3
Servlet A01 - Step X4 - 3577
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Problema DB: java.sql.SQLException: 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 --

Can you shed any light on what may be wrong

Tony

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: agaw-runner.sh problem
« Reply #1 on: December 09, 2008, 15:35:27 »
You have likely no queues that are "runnable" by the AGAW system, spo no data gets inserted. of course the error message should not be there and we'll fix that.
Try making one of your atomic queues "ruunnable" and see if the problem persists.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: agaw-runner.sh problem
« Reply #2 on: December 09, 2008, 15:36:34 »
We track this as bug #569.

tonils

  • Jr. Member
  • **
  • Posts: 54
  • Karma: 0
    • View Profile
    • Email
Re: agaw-runner.sh problem
« Reply #3 on: December 12, 2008, 12:40:03 »
Thanks, it is now working.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: agaw-runner.sh problem
« Reply #4 on: December 15, 2008, 10:04:46 »
Good - do you like the new AGAW module?