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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
