I recently upgraded a database to V8.1 from V7. I am now encountering problems with loads. Every now and then I connect to the database, start the load, the load says a connection does not exist and errors out. When I do a load query table on the table I was loading data to says that it is in check pending/load pending and that an error occurred while processing. Now, my big problem is when this occurs. Is there a way to get the load started again that will not cause the indexes to be rebuilt completely? The table is huge and the index rebuilding takes over a day to do. The only way I know to fix this problem is to do a load terminate or load restart, both of which cause the indexes to be rebuilt.

Any ideas? Is this a problem with V8.1?