Hi all, I've been working on an application that need to import about 47000 nodes (including relations) and apart from taking quite a long time to import all of them (about 1 hour on a dual 1Gz PIII machine) I sometimes see the following or similar errors in the mmbase log:
mmbase.module.database.MultiPool - KILLED SQL SELECT * FROM install_link WHERE number=1241 time 1040233606 because it took too long mmbase.module.database.MultiPool - KILLED SQL INSERT INTO install_categorylink (number, otype, owner, snumber, dnumber, rnumber, dir, longname) VALUES (?, ?, ?, ?, ?, ?, ?, ?) time 1040058537 because it took too long We are using a Postgresql 7.2.1 database. After some tuning of the database the amount of errors went down to about 1 to 2 errors per import when the machine is not doing anything else (and we gained about 5 minutes import time :-) I've got 2 questions: 1. Will this make the imported data inconsistent? 2. Is there a way of changing this behaviour i.e. by upping the timeout interval or switching timouts off? Thanks for your time, Joost Diepenmaat Framfab Nederland.
