Hello Daniel, It's practical to keep temp db file not erased after the server shutdown, as a disk space reserve. In this case the file will be used again at the next server run anyway, but the disk space will not be occasionally occupied by other programs. It's impractical, however, to keep surprisingly big reserve, esp. if the space allocated as a result of an error that will never happen again. Say, a hash join of "everything with everything" is not supposed to happen when the application logic is correct, but it can create a terabyte-scale temp.db if the computer is fast and the error is noticed only after hours of run.
TempDBSize lets you chose the size of the file you permit to keep, that's all. You can safely ignore this message if you have enough space on the disk; otherwise adjust the TempDBSize to the size measured after a usual correct run of the application server (multiplied by factor 1.5--2--3 for extra safety). Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2016-03-30 at 16:08 +0000, Davis, Daniel (NIH/NLM) [C] wrote: > I have a strange failure condition somewhere in my deployment. > Virtuoso goes down, and whenever I restart it, I see something like > this in the log: > > > > Unlinked the temp db file /usr/nlm/virtuoso/db/virtuoso-temp.db as its > size (8180MB) was greater than TempDBSize INI (10MB) > > > > Now, that is a big difference. Why would the virtuoso-temp DB size > get to be so much bigger than the limit? What removes it? > > > > Dan Davis, Systems/Applications Architect (Contractor), > > Office of Computer and Communications Systems, > > National Library of Medicine, NIH ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
