(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 servicenow.comhttps://www.servicenow.com LinkedInhttps://www.linkedin.com/company/servicenow | Twitterhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Facebookhttps://www.facebook.com/servicenow