Hi,
Can anyone point me in the right direction to find out why I keep getting the following
error? The table is newly created and then 14 LOAD DATA calls are made to load
approximately 24-30 million rows. Its a simple MyISAM table, no triggers, proceedures
etc with a couple of simple indexes. Any help would be appreciated.
Regards,
MC
----- snip begins -----
2006-01-30 04:18:50,251 [main] DEBUG - enable keys query: ALTER TABLE transaction_new
ENABLE KEYS
2006-01-30 07:50:09,172 [main] ERROR - FATAL ERROR: Number of rows changed from 28748449
to 33799512
2006-01-30 07:50:09,185 [main] DEBUG - java.sql.SQLException: Number of rows changed from
28748449 to 33799512
2006-01-30 07:50:09,238 [main] DEBUG - content:
java.sql.SQLException: Number of rows changed from 28748449 to 33799512
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1298)
at
nz.co.etsl.assist.applications.reporter.injector.ArchiveInjector.update(ArchiveInjector.java:160)
at nz.co.etsl.assist.applications.reporter.injector.Main.main(Main.java:56)
----- snip ends -----
This electronic message together with any attachments is confidential,
and may be privileged. It is intended solely for the addressee. If you are
not the intended recipient do not copy, disclose, or use the contents in
any way and please notify us by return e-mail immediately, then
destroy the message. ETSL is not responsible for any changes made to
this message and/or any attachments after sending by ETSL.
| Thread |
|---|
| • row number discrepancy while enabling keys | Michael Chester | 30 Jan |