Mckoi "partially" blocked

 
 
We have a db (you find it attached) containing about 2000 records. It starts
normally, but  blocks when it reaches a certain record. At that point the
CPU occupation suddenly raises.
Same results using the graphic interface tool.

We have tried to repair the db but when the repair tool gets to the main
table, it blocks (forever) again on the checking record integrity activity
(see the message below). The log file of the db are inside the data folder.

+ Repairing V2MasterTableDataSource 022APP_T01_MSG_FORWARDING
- Store: [ JournalledFileStore: 022APP_T01_MSG_FORWARDING ]
- Store areas are intact.
+ Rebuilding free bins.
- Store repair complete.
- Checking record integrity.

The main table (T01_MSG_FORWARDING) has the following fields:

          "       ID        INTEGER DEFAULT NEXTVAL('" + sequence + "') NOT
NULL, " +
          "       T_KEY1    VARCHAR(200) NOT NULL, " +
          "       T_KEY2    VARCHAR(200) NOT NULL, " +
          "       DATA      TIMESTAMP, " +
          "       SENDDATA  TIMESTAMP, " +
          "       MSG       BLOB, " +
          "       CONSTRAINT " + table + " PRIMARY KEY (ID) )");

Please, can you help us ? I can send the db if necessary (can you specifiy
at which address?)

Thank you

Alessandro Cavazzoni

WebRED

Ph.         051-6365.735

Fax        051-303586

e-mail   

 [email protected]

 



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]