Hi,
While implementing AS3AP suite on Java I encountered following problem when
trying to restore data in master table.
There are two tables "hundred" and "updates", "hundred" references "updates"
with foreign key on "updates" primary key. In one of the tests it is
required to restore "updates" table. I managed to get reliably "internal gds
software consistency check (partner index description not found (175))" by
doing following using JayBird:
Connection con = getConnection();
try {
con.setAutoCommit(false);
Statement stmt = con.createStatement();
stmt.executeUpdate(DROP_HUNDRED_FOREIGN_KEY);
stmt.executeUpdate(DROP_UPDATES_TABLE);
stmt.executeUpdate(CREATE_UPDATES_TABLE);
// commit, otherwise next inserts will not see the table
con.commit();
// fill table with new data
fixture.loadFile(new File(fixture.getDataPath(), UPDATES_FILE),
con, BenchmarkInsertSQL.INSERT_UPDATES);
stmt.executeUpdate(CREATE_HUNDRED_FOREIGN_KEY);
con.commit(); // <--- exception #335544333 happens here
} catch(SQLException ex) {
con.rollback();
throw ex;
}
Is it bug in the engine or just a wrong code?
Best regards,
Roman Rokytskyy
|
