Re: [basex-talk] db:lock

2023-01-01 Thread Christian Grün
Hi Vladimir, > I have an error "[db:lock] Database 'db' cannot be updated, it is opened by > another process". While client's "reading" query from 'db' in progress, I > query "db:alter('newdb','db')" for the same database. How can I wait for > ending client's query and then "db:alter('newdb','d

Re: [basex-talk] db:lock

2022-12-30 Thread Ветошкин Владимир
Perhaps, there was a one-time failure. 30.12.2022, 11:30, "Ветошкин Владимир" :I don't know why, but can't repeat it locally.First I query heavy reading operation on 'db', then I alter('dbcopy', 'db') and the second query waits ending the first. Why on the server the similar queries executed with e

Re: [basex-talk] db:lock

2022-12-30 Thread Ветошкин Владимир
I don't know why, but can't repeat it locally.First I query heavy reading operation on 'db', then I alter('dbcopy', 'db') and the second query waits ending the first. Why on the server the similar queries executed with errors, hmm. 30.12.2022, 11:08, "Ветошкин Владимир" :Hi, Yes, I know. But readin

Re: [basex-talk] db:lock

2022-12-30 Thread Ветошкин Владимир
Hi, Yes, I know. But reading operation began executing first and not ended when the second query (db:alter) begins. 30.12.2022, 10:58, "DK Singh" :Hi If any update operation is going on by others query then you won't be able to read the DB Please see Basex transaction Management Thanks  On Fri, 30

Re: [basex-talk] db:lock

2022-12-29 Thread DK Singh
Hi If any update operation is going on by others query then you won't be able to read the DB Please see Basex transaction Management Thanks On Fri, 30 Dec, 2022, 1:03 pm Ветошкин Владимир, wrote: > Hi, > > Yes, it's opened by client's query first. While that query is in progress, > I query "d

Re: [basex-talk] db:lock

2022-12-29 Thread Ветошкин Владимир
Hi, Yes, it's opened by client's query first. While that query is in progress, I query "db:alter" for the same database.How can I query "db:alter" after first query ends? Thank you 30.12.2022, 10:28, "DK Singh" :Hi,It seems that might be your DB is opened or your DB has Benn crashed Thanks  On Fri,

Re: [basex-talk] db:lock

2022-12-29 Thread DK Singh
Hi, It seems that might be your DB is opened or your DB has Benn crashed Thanks On Fri, 30 Dec, 2022, 12:50 pm Ветошкин Владимир, wrote: > Hello everyone > > I have an error "[db:lock] Database 'db' cannot be updated, it is opened > by another process". > While client's "reading" query from 'db

[basex-talk] db:lock

2022-12-29 Thread Ветошкин Владимир
Hello everyone I have an error "[db:lock] Database 'db' cannot be updated, it is opened by another process".While client's "reading" query from 'db' in progress, I query "db:alter('newdb','db')" for the same database.How can I wait for ending client's query and then "db:alter('newdb','db')"? Thanks