Re: [Exist-open] =?utf-8?q?Old_files_get_dumped_back_into_my_database?= =?utf-8?q?_in_a=09randomly_manner_to_a_random_location?=

[Toar <toa...@gm...>]

Wolfgang Meier <wolfgangmm <at> gmail.com> wrote:

> Those are temporary fragments, generated and cached by the query
> engine if you process a path expression on an in-memory DOM
> constructed during an XQuery. Normally, these fragments should go into
> /db/system/temp and should be cleaned up after some time or after a db
> restart.
> 

I do not find /temp subcollection under my /db/system collection.
I will try creating that collection and see if any files get dumped there.
I don't know if this will solve the problem
but I know you cannot store a file to a non-existing location
(exist won't create the subcollection for you)
so I'm just going to create "/db/system/temp" and see if this helps
hopefully by the end of today or tomorrow I can post a message that
all the files go there now.

G wrote:
>Because I could not fix the problem I had to work around it, 
>and currently have a scheduled job that looks for those files and deletes them.

I found the files in one of my subcollection again.
but I tried querying for the file and had no success, 
may i just ask how did you find those files?
This is the query I tried:

  for $x in xcollection("/db/data")/exist:temp
  return $x

The file does exist in "/db/data" but somehow querying for /exist:temp
doesn't work. If I do the following query though, it returns the file:

  for $x in xcollection("/db/data")
  return $x