[basex-talk] Corrupt database after update

2020-07-16 Thread Johannes Bauer
Hi, we have a rather strange and hard to track problem with corrupted databases. Our setup is: * Docker container with a Tomcat that hosts BaseX with some custom RESTXQ services * BaseX 9.2.4 * Java 14 * Docker runs on a Linux VM Workflow * Create database with RESTXQ service call *

Re: [basex-talk] Database file path

2020-07-16 Thread Christian Grün
Hi Vladimir, The DBPATH option is the one you’ll need to assign. As it’s a global option, it should be assigned at startup time [1]. Best, Christian [1] https://docs.basex.org/wiki/Options On Thu, Jul 16, 2020 at 6:11 AM Vladimir Churyukin wrote: > > Hello, > > We have a data transformation

[basex-talk] Transaction Support

2020-07-16 Thread Reto Peter
I am evaluating BaseX for my XML project. I need transaction support like -Start transaction -Run queries (read, write, update) -Commit or rollback transaction When I see the documentation, it lists Transaction Manager. But when I look at the details, I cannot find

Re: [basex-talk] Database file path

2020-07-16 Thread Christian Grün
Right, the option is global. As BaseX has been designed to serve concurrent requests, it would introduce unexpected side effects of the path was changed at runtime. If you are careful, you can try to change the path by assigning a new value to Context.soptions. Vladimir Churyukin schrieb am

Re: [basex-talk] Transaction Support

2020-07-16 Thread Marco Lettere
Hi Reto, AFAIK Basex is transactional in the sense that whenever you start a sequence of commands or an XQuery script, all the "updating operations" that modify the database are always stored in a PUL (a list of potential updates). Only when the script terminates all the operations on the DB

Re: [basex-talk] Database file path

2020-07-16 Thread Vladimir Churyukin
Ah no, I'm not talking about changing it in runtime, I'm talking about specifying the path on database creation, for example when CreateDB command is executed. There shouldn't be concurrency problems at the moment of database creation, correct? -Vladimir On Thu, Jul 16, 2020 at 8:41 AM Christian

Re: [basex-talk] Transaction Support

2020-07-16 Thread Reto Peter
Hi Marco Thanks for answering But that means Basex is NOT supporting database transactions Or is it possible to implement real transactions (START TRANS, do something, COMMIT trans) with that PUL or something? Reto From: BaseX-Talk [mailto:basex-talk-boun...@mailman.uni-konstanz.de] On Behalf

Re: [basex-talk] Database file path

2020-07-16 Thread Vladimir Churyukin
Yes, I've seen that option. But there is no way to set it per database, correct? I'm asking because by nature our operations are ad-hoc, we don't really "startup" the instances, we create a database, process the data, then destroy the database. Is there some internal limitation why this option

[basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Geoff Alexander
I've found that when I perform a database optimize on an unoptimized database that while the record count decreases as expected, the database size (bytes column) stay the same. Is this a bug in reporting the database size (less severe problem) or a bug in the database not reducing on optimize

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Geoff Alexander
Here are steps to recreate the problem: (1) Add one or more entries to an new (empty) database. One the BaseX Database Administration's Database page, you'll find that the database's COUNT column shows the number of entries added and that the database's BYTES column shows the database size. (2)

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Christian Grün
Hi Geoff, Did you run OPTIMIZE ALL or db:optimize(..., true()) ? What do you mean by "record count"? Best, Christian Geoff Alexander schrieb am Do., 16. Juli 2020, 18:06: > I've found that when I perform a database optimize on an unoptimized > database that while the record count decreases

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Geoff Alexander
On the BaseX Database Administration's Database page at https://localhost:10443/BaseX/dba/databases, I selected a database I knew was unoptimized and pressed the Optimize button. The database's COUNT column decreased to the number entries in the database as expected. However, the database's

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Christian Grün
It's surprising that the count value changed, as it should represent the number of resources (documents, binary files) in your database – and this value shouldn't change if your data is optimized. Feel free to provide us with a little reproducible example. The size of the database may stay the

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Christian Grün
> > We use the BaseX REST API from a Java problem to add and update documents > in BaseX. > Do you think it’s reproducible for us? >

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Geoff Alexander
I would think so. Let me see if I can create a small example using the BaseX WEB API that recreates the problem. Geoff Alexander, Ph.D. Software Engineer, Corporate Tools Development IBM Corporation Charlotte, NC From: "Christian Grün" To: Geoff Alexander Cc: BaseX Date:

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Geoff Alexander
We use the BaseX REST API from a Java problem to add and update documents in BaseX. Geoff Alexander, Ph.D. Software Engineer, Corporate Tools Development IBM Corporation Charlotte, NC From: "Christian Grün" To: Geoff Alexander Cc: BaseX Date: 07/16/2020 03:07 PM Subject:

Re: [basex-talk] Possible bug in database size (bytes) after database optimize from BaseX Database Administration

2020-07-16 Thread Christian Grün
> > (2) Update one or of the database's entries. > If I replace the document via the DBA, or if I run an update expression via the Queries Panel, the count always reflects the number of resources, it doesn’t change. How did you update the document? Is it an XML document or a binary file you