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 Ветошкин Владимир, en-trance@yandex.ru wrote:

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" dharam.mahi@gmail.com:

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 Ветошкин Владимир, en-trance@yandex.ru 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' 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 for your help!

-- С уважением, Ветошкин Владимир Владимирович

-- С уважением, Ветошкин Владимир Владимирович

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','db')"?

Which client/interface did you use to send db:alter? See [1] for more information on concurrent operations on databases.

Best, Christian

[1] https://docs.basex.org/wiki/Startup#Concurrent_Operations