Messages

1

Running WombatDialer / Re: Starting campaign causes "Batch update returned unexpected row count" crash

« on: November 17, 2015, 21:11:40 »

Thanks for investigating this.

I did as you suggested, and then attempted to start my campaign again. However, calls are still broken, and my Tomcat logs still produce a similar error (below). I verified that the previously mentioned query now returns only 1 row (the UNSAVED row).

Do you have any other suggestions?

I have emailed a copy of my database, from prior to deleting anything, to support at loway dot ch. SUP #24271


Stack trace:
java.lang.IllegalThreadStateException: -- Inner Exception --
Exception: org.hibernate.jdbc.BatchedTooManyRowsAffectedException
Error:
Batch update returned unexpected row count from update

• ; actual row count: 2;

 expected: 1
Stack trace:
org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned un
expected row count from update

• ; actual row count: 2; expected: 1

        at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expecta
tions.java:95)
        at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expect
ations.java:70)
        at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.jav
a:90)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
268)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:109)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatc
her.java:244)
        at org.hibernate.persister.collection.BasicCollectionPersister.doUpdateR
ows(BasicCollectionPersister.java:216)
        at org.hibernate.persister.collection.AbstractCollectionPersister.update
Rows(AbstractCollectionPersister.java:1541)
        at org.hibernate.action.CollectionUpdateAction.execute(CollectionUpdateA
ction.java:85)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:170)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.commitOnTimeout(WombatDialerProcess.java:1792)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.processWombatBrain(WombatDialerProcess.java:643)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.runIteration(WombatDialerProcess.java:243)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.run(WombatDialerProcess.java:154)
        at ch.loway.oss.slicedbread.MessagingConsole$1.run(MessagingConsole.java:191)
        at java.lang.Thread.run(Thread.java:745)
-- End Inner Exception --

2

Running WombatDialer / Starting campaign causes "Batch update returned unexpected row count" crash

« on: November 12, 2015, 21:12:26 »

When I go to "View Live > Available Campaigns > Click on my campaign > Start campaign" the expected phone calls never happen. Catalina.log shows that wombat is hitting the below error. Anybody know how to solve this, or even how to make Wombat tell me which particular rows it is complaining about? If I knew which query was returning an unexpected number of rows, I could probably figure out what I did wrong.



Nov 12, 2015 3:03:10 PM ch.loway.app.wombat.dialer.WombatDialerWatchdog notifyEr
rorServer
SEVERE: -- Inner Exception --
Exception: java.lang.IllegalThreadStateException
Error:
-- Inner Exception --
Exception: org.hibernate.jdbc.BatchedTooManyRowsAffectedException
Error:
Batch update returned unexpected row count from update

• ; actual row count: 2;

 expected: 1
Stack trace:
org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned un
expected row count from update

• ; actual row count: 2; expected: 1

        at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expecta
tions.java:95)
        at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expect
ations.java:70)
        at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.jav
a:90)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
268)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:109)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatc
her.java:244)
        at org.hibernate.persister.collection.BasicCollectionPersister.doUpdateR
ows(BasicCollectionPersister.java:216)
        at org.hibernate.persister.collection.AbstractCollectionPersister.update
Rows(AbstractCollectionPersister.java:1541)
        at org.hibernate.action.CollectionUpdateAction.execute(CollectionUpdateA
ction.java:85)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:170)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:50)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.commitOnTimeout(Wombat
DialerProcess.java:1792)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.processWombatBrain(Wom
batDialerProcess.java:643)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.runIteration(WombatDialerProcess.java:243)
        at ch.loway.app.wombat.dialer.WombatDialerProcess.run(WombatDialerProcess.java:154)
        at ch.loway.oss.slicedbread.MessagingConsole$1.run(MessagingConsole.java:191)
        at java.lang.Thread.run(Thread.java:745)
-- End Inner Exception --



Edit: I think I found the query via MySQL's slow log:

SELECT c.campaignId, c.name,  c.securityKey, hopper.runMode, count(*) as NUM  FROM campaigns c    LEFT JOIN hopper ON c.campaignId = hopper.campaign   WHERE c.pace = 'RUNNABLE'  GROUP BY c.campaignId, c.name,  c.securityKey, hopper.runMode;
+------------+------------+-------------+-----------+-----+
| campaignId | name       | securityKey | runMode   | NUM |
+------------+------------+-------------+-----------+-----+
|          1 | mycampaign |             | COMPLETED |  11 |
|          1 | mycampaign |             | UNSAVED   |  10 |
+------------+------------+-------------+-----------+-----+
2 rows in set (0.00 sec)


I'm still not sure how to fix this, though. Delete one of those rows?

3

Running WombatDialer / Log IP of LoginErrors?

« on: October 12, 2015, 23:13:36 »

When I try to login to Wombat Dialer using a bad username/password, the wombat log will output:

Code: [Select]

SEVERE: -- Inner Exception --
Exception: ch.loway.tpf.gwt.shared.exceptions.LoginError

Stack trace:
ReqException:LOGIN_ERROR

Is it possible to make wombat log the IP that triggered this? I'd like to hook this up to Fail2ban, so that I can firewall any IP that makes brute force login attempts.

Thanks in advance.

4

Installing WombatDialer / MySQL creation fails with "max key length is 1000 bytes"

« on: September 27, 2015, 17:55:30 »

I'm using a FreePBX virtual appliance, and I installed wombat via "yum install wombat", which went fine. I went to myserver:8080/wombat, and attempted to do the MySQL setup, but it fails with the following error. Does anybody know how to fix this?

Scientific Linux
MySQL 5.1


Error:-- Inner Exception -- Exception: it.loway.tpf.common.exceptions.TechException Stack trace: Database issue: Database error: -- Inner Exception -- Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException Error: Specified key was too long; max key length is 1000 bytes Stack trace: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3277) at com.mysql.jdbc.Connection.execSQL(Connection.java:3206) at com.mysql.jdbc.Statement.execute(Statement.java:727) at it.loway.tpf.SQL.execSql(SQL.java:108) at ch.loway.tpf.dbcreator.dbtest.dbCreate.UploadDatabase.doUpdate(UploadDatabase.java:47) at ch.loway.tpf.dbcreator.dbtest.BaseSchemaUpdater.doUpdate(BaseSchemaUpdater.java:81) at ch.loway.tpf.dbcreator.dbtest.BaseSchemaUpdater.runSingleUpdater(BaseSchemaUpdater.java:158) at ch.loway.tpf.dbcreator.dbtest.BaseSchemaUpdater.runSingleUpdater(BaseSchemaUpdater.java:143) at org.apache.jsp.dbtest.SchemaUpdater_005fajax_jsp._jspService(SchemaUpdater_005fajax_jsp.java:138) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) -- End Inner Exception -- When running: CREATE TABLE `dbversion` ( `version_id` int(11) NOT NULL, `lic_version` varchar(255) NOT NULL, `lic_approved` varchar(255) NOT NULL, `plex_id` varchar(255) NOT NULL, PRIMARY KEY (`version_id`,`lic_version`,`lic_approved`,`plex_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 at it.loway.tpf.SQL.execSql(SQL.java:113) at ch.loway.tpf.dbcreator.dbtest.dbCreate.UploadDatabase.doUpdate(UploadDatabase.java:47) at ch.loway.tpf.dbcreator.dbtest.BaseSchemaUpdater.doUpdate(BaseSchemaUpdater.java:81) at ch.loway.tpf.dbcreator.dbtest.BaseSchemaUpdater.runSingleUpdater(BaseSchemaUpdater.java:158) at ch.loway.tpf.dbcreator.dbtest.BaseSchemaUpdater.runSingleUpdater(BaseSchemaUpdater.java:143) at org.apache.jsp.dbtest.SchemaUpdater_005fajax_jsp._jspService(SchemaUpdater_005fajax_jsp.java:138) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) -- End Inner Exception --