Hi Eliot,
That's not fun.
I see your directory has a ` upd.basex`you could try the suggestion at: https://docs.basex.org/main/Transaction_Management#update_operations
Maybe you get lucky. /Andy
On Fri, 18 Apr 2025 at 15:59, Eliot Kimber via BaseX-Talk < basex-talk@mailman.uni-konstanz.de> wrote:
I have a database that shows having the expected 2 documents in it in the DBA databases list but when I go to the database in the DBA it shows 0 items.
I think this is because the database was being written to and something happened that left it in a bad state.
Is there any possibility of recovering this database so it is usable?
The practical problem is that it takes several hours to populate this database, so recovering it rather than attempting another multi-hour load would be nice.
Here’s what I see for files in the database’s directory on the server:
-rw-r--r-- 1 eliot.kimber.adm domain users 73039559 Apr 18 14:50 atv.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 7544382 Apr 18 14:52 atvl.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 2730980 Apr 18 14:52 atvr.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 236 Apr 18 04:17 ftxx.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 218072 Apr 18 04:17 ftxy.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 1603678 Apr 18 04:17 ftxz.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 15 Apr 18 04:17 idp.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 15193 Apr 18 04:17 inf.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 67 Apr 18 04:17 pth.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 28 Apr 18 04:17 swl.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 83701760 Apr 18 14:52 tbl.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 9 Apr 18 04:17 tbli.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 112380335 Apr 18 14:52 tokl.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 2829520 Apr 18 14:52 tokr.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 1718692 Apr 18 04:17 txt.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 351326 Apr 18 04:17 txtl.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 285610 Apr 18 02:38 txtr.basex
-rw-r--r-- 1 eliot.kimber.adm domain users 0 Apr 18 04:18 upd.basex
In the Databases list I see:
_temp_lrk_yokohama_link_records http://mirabel.corp.service-now.com:8984/dba/database?name=_temp_lrk_yokohama_link_records
2
274 MB
2025-04-18, 14:52:42
But then when I go to the database itself it just say “0 entries”.
Thanks,
Eliot
*Eliot Kimber*
Sr. Staff Content Engineer
O: 512 554 9368
*servicenow*
servicenow.com https://www.servicenow.com
LinkedIn https://www.linkedin.com/company/servicenow | X https://twitter.com/servicenow | YouTube https://www.youtube.com/user/servicenowinc | Instagram https://www.instagram.com/servicenow