(Using 10.7 on Centos):
I have some databases with many large documents (1000s of docs ranging from 6KB to 2MB).
I need to clean out older files, so I wrote this simple query, which looks at the time stamps in the doc filenames:
let $db := '_valrep_validation_reports_internal'
let $paths := (db:open($db)/* ! db:path(.)[matches(., '2024-0[123456]')] => sort())
return
for $path in $paths
return db:delete($db, $path)
With only the dba app deployed, I ran this query on the four databases and it ran in a few seconds and removed the files as expected, but then I ran it on one more database and the query never returned and the dba app became unresponsive (Databases view doesn’t
refresh).
On the server I can see that a Java process, which can only be BaseX on this server, is at 100%:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8376 eliot.k+ 20 0 9251688 1.1g 16124 S 101.0 3.5 14:02.42 java
What would cause this kind of behavior?
Cheers,
E.
_____________________________________________
Eliot Kimber
Sr Staff Content Engineer
Digital Content & Design
O: 512 554 9368
M: 512 554 9368