Hi All,

I have a database which I'm keeping incrementally recovered to a host running II 9.2.1 (a64.lnx/103)NPTL +patch 13869.

I have found that the database will accept a single connection only. Is that intended? It doesn't seem right to me.

Try this....

createdb bowtest
ckpdb -v +j bowtest
rollforwarddb bowtest +c -j -incremental -norollback
infodb bowtest | grep Status
sql bowtest &
sql bowtest

The second connection will fail with error:
E_US002E An error occurred in trying to get a lock while opening a database..

Martin Bowes

I tried it and I think it's actually the first that's failing. Try
putting a "sleep 1" between the infodb and the first sql. I've seen this
before - a slight delay after a dmfjsp process (ckpdb, infodb etc) has
finished and releasing the database lock.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 28 September 2010 13:35
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Are incrementally recovered databases single
user?



Hi All,



I have a database which I'm keeping incrementally recovered to a host
running II 9.2.1 (a64.lnx/103)NPTL +patch 13869.



I have found that the database will accept a single connection only. Is
that intended? It doesn't seem right to me.



Try this....



createdb bowtest

ckpdb -v +j bowtest

rollforwarddb bowtest +c -j -incremental -norollback

infodb bowtest | grep Status

sql bowtest &

sql bowtest



The second connection will fail with error:

E_US002E An error occurred in trying to get a lock while opening a
database.



Martin Bowes

bb4.ingres> sql bowtest &
[1] 21466
bb4.ingres> INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation
Ingres Linux Version II 9.2.1 (a64.lnx/103)NPTL login
Tue Sep 28 14:41:17 2010

continue
*
[1] + Suspended (tty input) sql bowtest
bb4.ingres>
bb4.ingres>
bb4.ingres> sql bowtest
INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation
E_US002E An error occurred in trying to get a lock
while opening a database.
(Tue Sep 28 14:41:22 2010)

Here you see the problem demonstrated with a 5 second delay... I've gone to10seconds with the same result.

Marty

From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 28 September 2010 14:31
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Are incrementally recovered databases single user?

I tried it and I think it's actually the first that's failing. Try putting a "sleep 1" between the infodb and the first sql. I've seen this before - aslight delay after a dmfjsp process (ckpdb, infodb etc) has finished and releasing the database lock.

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Martin Bowes
Sent: 28 September 2010 13:35
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Are incrementally recovered databases single user?

Hi All,

I have a database which I'm keeping incrementally recovered to a host running II 9.2.1 (a64.lnx/103)NPTL +patch 13869.

I have found that the database will accept a single connection only. Is that intended? It doesn't seem right to me.

Try this....

createdb bowtest
ckpdb -v +j bowtest
rollforwarddb bowtest +c -j -incremental -norollback
infodb bowtest | grep Status
sql bowtest &
sql bowtest

The second connection will fail with error:
E_US002E An error occurred in trying to get a lock while opening a database..

Martin Bowes

Interesting. Works for me (with delay) in 10.1 - I'll try it on 9.2



From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 28 September 2010 14:47
To: Ingres and related product discussion forum
Cc: Paul Mason
Subject: RE: [Info-Ingres] Are incrementally recovered databases single
user?



bb4.ingres> sql bowtest &

[1] 21466

bb4.ingres> INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation

Ingres Linux Version II 9.2.1 (a64.lnx/103)NPTL login

Tue Sep 28 14:41:17 2010



continue

*

[1] + Suspended (tty input) sql bowtest

bb4.ingres>

bb4.ingres>

bb4.ingres> sql bowtest

INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation

E_US002E An error occurred in trying to get a lock

while opening a database.

(Tue Sep 28 14:41:22 2010)



Here you see the problem demonstrated with a 5 second delay... I've gone
to 10seconds with the same result.



Marty



From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 28 September 2010 14:31
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Are incrementally recovered databases single
user?



I tried it and I think it's actually the first that's failing. Try
putting a "sleep 1" between the infodb and the first sql. I've seen this
before - a slight delay after a dmfjsp process (ckpdb, infodb etc) has
finished and releasing the database lock.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 28 September 2010 13:35
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Are incrementally recovered databases single
user?



Hi All,



I have a database which I'm keeping incrementally recovered to a host
running II 9.2.1 (a64.lnx/103)NPTL +patch 13869.



I have found that the database will accept a single connection only. Is
that intended? It doesn't seem right to me.



Try this....



createdb bowtest

ckpdb -v +j bowtest

rollforwarddb bowtest +c -j -incremental -norollback

infodb bowtest | grep Status

sql bowtest &

sql bowtest



The second connection will fail with error:

E_US002E An error occurred in trying to get a lock while opening a
database.



Martin Bowes

I've tried it on II 10.0.0 (a64.lnx/127)NPTL (unpatched) and got the error using a 10second delay.

Marty

From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 28 September 2010 14:49
To: Martin Bowes; Ingres and related product discussion forum
Subject: RE: [Info-Ingres] Are incrementally recovered databases single user?

Interesting. Works for me (with delay) in 10.1 - I'll try it on 9.2

From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 28 September 2010 14:47
To: Ingres and related product discussion forum
Cc: Paul Mason
Subject: RE: [Info-Ingres] Are incrementally recovered databases single user?

bb4.ingres> sql bowtest &
[1] 21466
bb4.ingres> INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation
Ingres Linux Version II 9.2.1 (a64.lnx/103)NPTL login
Tue Sep 28 14:41:17 2010

continue
*
[1] + Suspended (tty input) sql bowtest
bb4.ingres>
bb4.ingres>
bb4.ingres> sql bowtest
INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation
E_US002E An error occurred in trying to get a lock
while opening a database.
(Tue Sep 28 14:41:22 2010)

Here you see the problem demonstrated with a 5 second delay... I've gone to10seconds with the same result.

Marty

From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 28 September 2010 14:31
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Are incrementally recovered databases single user?

I tried it and I think it's actually the first that's failing. Try putting a "sleep 1" between the infodb and the first sql. I've seen this before - aslight delay after a dmfjsp process (ckpdb, infodb etc) has finished and releasing the database lock.

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Martin Bowes
Sent: 28 September 2010 13:35
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Are incrementally recovered databases single user?

Hi All,

I have a database which I'm keeping incrementally recovered to a host running II 9.2.1 (a64.lnx/103)NPTL +patch 13869.

I have found that the database will accept a single connection only. Is that intended? It doesn't seem right to me.

Try this....

createdb bowtest
ckpdb -v +j bowtest
rollforwarddb bowtest +c -j -incremental -norollback
infodb bowtest | grep Status
sql bowtest &
sql bowtest

The second connection will fail with error:
E_US002E An error occurred in trying to get a lock while opening a database..

Martin Bowes

Scratch that - didn't work on 10.1 - it was the way I ran the test.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Paul
Mason
Sent: 28 September 2010 14:49
To: Martin Bowes; Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Are incrementally recovered databases single
user?



Interesting. Works for me (with delay) in 10.1 - I'll try it on 9.2



From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 28 September 2010 14:47
To: Ingres and related product discussion forum
Cc: Paul Mason
Subject: RE: [Info-Ingres] Are incrementally recovered databases single
user?



bb4.ingres> sql bowtest &

[1] 21466

bb4.ingres> INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation

Ingres Linux Version II 9.2.1 (a64.lnx/103)NPTL login

Tue Sep 28 14:41:17 2010



continue

*

[1] + Suspended (tty input) sql bowtest

bb4.ingres>

bb4.ingres>

bb4.ingres> sql bowtest

INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation

E_US002E An error occurred in trying to get a lock

while opening a database.

(Tue Sep 28 14:41:22 2010)



Here you see the problem demonstrated with a 5 second delay... I've gone
to 10seconds with the same result.



Marty



From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 28 September 2010 14:31
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Are incrementally recovered databases single
user?



I tried it and I think it's actually the first that's failing. Try
putting a "sleep 1" between the infodb and the first sql. I've seen this
before - a slight delay after a dmfjsp process (ckpdb, infodb etc) has
finished and releasing the database lock.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 28 September 2010 13:35
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Are incrementally recovered databases single
user?



Hi All,



I have a database which I'm keeping incrementally recovered to a host
running II 9.2.1 (a64.lnx/103)NPTL +patch 13869.



I have found that the database will accept a single connection only. Is
that intended? It doesn't seem right to me.



Try this....



createdb bowtest

ckpdb -v +j bowtest

rollforwarddb bowtest +c -j -incremental -norollback

infodb bowtest | grep Status

sql bowtest &

sql bowtest



The second connection will fail with error:

E_US002E An error occurred in trying to get a lock while opening a
database.



Martin Bowes