db:lock

On Fri, 30 Dec, 2022, 12:50 pm Ветошкин Владимир, <en-trance at 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! > > -- > С уважением, > Ветошкин Владимир Владимирович > >

30.12.2022, 10:28, "DK Singh" <dharam.mahi at 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 at 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! > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > >

On Fri, 30 Dec, 2022, 1:03 pm Ветошкин Владимир, <en-trance at 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 at 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 at 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! > > -- > С уважением, > Ветошкин Владимир Владимирович > > > > > -- > С уважением, > Ветошкин Владимир Владимирович > >

30.12.2022, 10:58, "DK Singh" <dharam.mahi at gmail.com>: > 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 at 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 at 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 at 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! > > > > > > > > > > > > -- > > > > С уважением, > > > > Ветошкин Владимир Владимирович > > > > > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > >

30.12.2022, 11:08, "Ветошкин Владимир" <en-trance at yandex.ru>: > 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" <dharam.mahi at gmail.com>: > > > 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 at 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 at 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 at 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! > > > > > > > > > > > > > > > -- > > > > > С уважением, > > > > > Ветошкин Владимир Владимирович > > > > > > > > > > > > > > -- > > > С уважением, > > > Ветошкин Владимир Владимирович > > > > > > -- > С уважением, > Ветошкин Владимир Владимирович >

30.12.2022, 11:30, "Ветошкин Владимир" <en-trance at yandex.ru>: > 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, "Ветошкин Владимир" <en-trance at yandex.ru>: > > > 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" <dharam.mahi at gmail.com>: > > > > > 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 at 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 at 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 at 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! > > > > > > > > > > > > > > > > > > -- > > > > > > С уважением, > > > > > > Ветошкин Владимир Владимирович > > > > > > > > > > > > > > > > > > -- > > > > С уважением, > > > > Ветошкин Владимир Владимирович > > > > > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > > > > > -- > С уважением, > Ветошкин Владимир Владимирович >

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