nmadhire / jwpl

Automatically exported from code.google.com/p/jwpl
0 stars 0 forks source link

[RevisionMachine] DatabaseWriter does not work #46

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Writing the revision dump directly to the databse does not work at the moment 
(see report below)

Either fix the issue or remove the option to write directly to db.

EXCEPTION:

de.tudarmstadt.ukp.wikipedia.revisionmachine.common.exceptions.SQLConsumerExcept
ion: DIFFTOOL_SQLCONSUMER_DATABASEWRITER_EXCEPTION:
INSERT INTO revisions VALUES(null, 
233192,1,233192,10,980061141000,?,'*',0,'99',1),(null, 
233192,2,862220,10,1014669791000,?,'Automated conversion',1,'0',0),(null, 
233192,3,15898945,10,1051323518000,?,'Fixing redirect',1,'7543',1),(null, 
233192,4,56681914,10,1149368141000,?,'fix double redirect',1,'516514',1),(null, 
233192,5,74466685,10,1157703364000,?,'cat rd',0,'750223',1),(null, 
233192,6,133180268,10,1180032118000,?,'Robot: Automated text replacement  
(-\\[\\[(.*?[\\:|\\|])*?(.+?)\\]\\] +\\g<2>)',1,'4477979',1),(null, 
233192,7,133452289,10,1180127532000,?,'Revert edit(s) by 
[[Special:Contributions/Ngaiklin|Ngaiklin]] to last version by 
[[Special:Contributions/Rory096|Rory096]]',1,'241822',1),(null, 
233192,8,381200179,10,1282875831000,?,null,0,'0',0),(null, 
233192,9,381202555,10,1282876716000,?,'[[Help:Reverting|Reverted]] edits by 
[[Special:Contributions/76.28.186.133|76.28.186.133]] ([[User 
talk:76.28.186.133|talk]]) to last version by Gurch',1,'7181920',1);

0       106
1       40
2       17
3       28
4       26
5       7
6       11
7       479
8       63

        at de.tudarmstadt.ukp.wikipedia.revisionmachine.common.exceptions.ErrorFactory.createSQLConsumerException(ErrorFactory.java:353)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.consumer.sql.writer.SQLDatabaseWriter.process(SQLDatabaseWriter.java:244)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.consumer.sql.writer.TimedSQLDatabaseWriter.process(TimedSQLDatabaseWriter.java:131)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.DiffToolThread$TaskTransmitter.writeOutput(DiffToolThread.java:223)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.DiffToolThread$TaskTransmitter.transmitDiff(DiffToolThread.java:195)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.consumer.diff.calculation.DiffCalculator.transmitAtEndOfTask(DiffCalculator.java:326)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.consumer.diff.calculation.TimedDiffCalculator.transmitAtEndOfTask(TimedDiffCalculator.java:149)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.consumer.diff.calculation.DiffCalculator.process(DiffCalculator.java:523)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.consumer.diff.calculation.TimedDiffCalculator.process(TimedDiffCalculator.java:192)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.DiffToolThread.run(DiffToolThread.java:319)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.DiffTool.main(DiffTool.java:56)
Caused by: java.sql.SQLException: Column count doesn't match value count at row 
1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1162)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1079)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1064)
        at de.tudarmstadt.ukp.wikipedia.revisionmachine.difftool.consumer.sql.writer.SQLDatabaseWriter.process(SQLDatabaseWriter.java:206)
        ... 9 more

Original issue reported on code.google.com by oliver.ferschke on 11 Aug 2011 at 5:18

GoogleCodeExporter commented 9 years ago
Remove problematic BINARY OUTPUT MODE in the SQLDatabaseWriter

Original comment by oliver.ferschke on 11 Aug 2011 at 7:43

GoogleCodeExporter commented 9 years ago

Original comment by oliver.ferschke on 16 Feb 2012 at 1:24