Hi Jörn , If all datasets are indicate to have loaded with ll_state = 2 and not errors reported in ll_error then the datasets have been loaded successfully.
What does the “status();” command run from isql as that will show the status of the machine and what might be consuming resources. Did you run the checkpoint command when the bulk load completed as that should always be done ? Also after restart is the high CPU consumption still occurring ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 13 Nov 2015, at 11:46, Jörn Hees <j_h...@cs.uni-kl.de> wrote: > > Hi Hugh, > >> On 13 Nov 2015, at 04:11, Hugh Williams <hwilli...@openlinksw.com> wrote: >> >> If you check the load_list table does it log in the ll_error column which >> dataset is causing the error and you can check the file to see it is valid ? > > thanks for the answer... the following returns 0 rows > SELECT * FROM DB.DBA.LOAD_LIST WHERE ll_error IS NOT NULL ; > > Does that mean that all files were loaded successfully despite the log > messages? (all states are 2) > > > > Also when importing additional datasets i got a message like this: > 18:43:19 deleted rl kept around for page apply > > Any clue what that means? > > > >>> I also noticed that after all loaders finish, virtuoso continues to have >>> very high CPU loads (2 cores maxed out on average) with very little IO >>> activity. >>> Does anyone know what is happening in that time? Is it save to shut down >>> the DB? > > > And last but not least, any idea why the machine keeps busy for hours after > the loader is done? > How can i find out what it's doing? > > > > Cheers, > Jörn > > > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
