| Michael Chester 2006-01-30, 8:24 pm |
| 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:=20
java.sql.SQLException: Number of rows changed from 28748449 to 33799512
at com.mysql.jdbc.MysqlIO. checkErrorPacket(Mys
qlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO. sqlQueryDirect(Mysql
IO.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(Statem
ent.java:1298)
at =
nz.co.etsl.assist.applications.reporter.injector.ArchiveInjector.update(A=
rchiveInjector.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,=20
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=20
any way and please notify us by return e-mail immediately, then=20
destroy the message. ETSL is not responsible for any changes made to=20
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/mysql? unsub...sie.nctu.edu.tw
|