I forgot to mention: We are using MMBase 1.6 RC1, with tomcat 4.0.6 and jdk 1.3.1_06
J. On Thu, 2002-12-19 at 13:13, Joost Diepenmaat wrote: > 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. > > > --
