List:General Discussion« Previous MessageNext Message »
From:Michael Chester Date:January 30 2006 10:51pm
Subject:row number discrepancy while enabling keys
View as plain text  
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 keysMichael Chester30 Jan