Hello,
I’ve been debugging a strange issue on a system and I can’t quite understand what’s causing it.
I create some databases on my local laptop (macOS). They provide master data for a larger system so I then copy them to a cloud server (Linode/Amazon).
I recently switched updated some queries to use db:open with a path restriction to make them run faster.
Everything worked on the laptop but nothing was returned on the server for the same paths.
If I optimise(all) the database on the server it then works.
After the optimisation, on the server there is a file called pth.basex and a file called idp.basex.
On the Mac there is NO file in the database folder called pth.basex or idp.basex.
I’m not sure what pth.basex or idp.basex are as they’re not referenced on Storage Layout[1]
This is copying the database files directly. I have had mixed results using backup zip files - sometimes it works and sometimes it fails.
Has anyone else observed this behaviour? What are the steps I should take to ensure reliable movement of databases? What are these mysterious files?
I’m happy to update the Wiki with any new information .
Many thanks, James
[1] https://docs.basex.org/wiki/Storage_Layout https://docs.basex.org/wiki/Storage_Layout