dbTalk Databases Forums  

[Info-Ingres] extenddb and iidbdb

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] extenddb and iidbdb in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default [Info-Ingres] extenddb and iidbdb - 05-14-2010 , 09:21 AM






Hi All,



On II 9.2.0 (a64.lnx/143)NPTL + 13767



When I try: extenddb iidbdb -Uwork -lii_work_2



I get errors:

INGRES EXTENDDB Copyright 2008 Ingres Corporation

E_US0089 Another database has already been extended to the indicated

location.

(Fri May 14 14:04:41 2010)

E_IC0046 Error(s) occurred extending database 'iidbdb' to location

'ii_work_2'.



I can do the extend on any other database. Why would it care if the
location was already being used anyway?



Ideas?



Martin Bowes

Reply With Quote
  #2  
Old   
Paul Mason
 
Posts: n/a

Default Re: [Info-Ingres] extenddb and iidbdb - 05-14-2010 , 09:36 AM






E_US0089 refers to a raw location - which can only be used by one DB at
a time. If ii_work_2 is not raw then it may be confused by the fact that
it's iidbdb.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 14 May 2010 14:21
To: Ingres and related product discussion forum
Subject: [Info-Ingres] extenddb and iidbdb



Hi All,



On II 9.2.0 (a64.lnx/143)NPTL + 13767



When I try: extenddb iidbdb -Uwork -lii_work_2



I get errors:

INGRES EXTENDDB Copyright 2008 Ingres Corporation

E_US0089 Another database has already been extended to the indicated

location.

(Fri May 14 14:04:41 2010)

E_IC0046 Error(s) occurred extending database 'iidbdb' to location

'ii_work_2'.



I can do the extend on any other database. Why would it care if the
location was already being used anyway?



Ideas?



Martin Bowes

Reply With Quote
  #3  
Old   
Martin Bowes
 
Posts: n/a

Default Re: [Info-Ingres] extenddb and iidbdb - 05-14-2010 , 09:51 AM



Hi Paul,



It must be an iidbdb thing.



This is a cooked location. Simple test is that multiple databases have
been extended to use the location.



Furthermore on a test box, I made a new work location and then tried to
extend iidbdb (only) to use the new location...and got the same error
messages.



Should I raise a bug?



Marty



From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 14 May 2010 14:37
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] extenddb and iidbdb



E_US0089 refers to a raw location - which can only be used by one DB at
a time. If ii_work_2 is not raw then it may be confused by the fact that
it's iidbdb.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 14 May 2010 14:21
To: Ingres and related product discussion forum
Subject: [Info-Ingres] extenddb and iidbdb



Hi All,



On II 9.2.0 (a64.lnx/143)NPTL + 13767



When I try: extenddb iidbdb -Uwork -lii_work_2



I get errors:

INGRES EXTENDDB Copyright 2008 Ingres Corporation

E_US0089 Another database has already been extended to the indicated

location.

(Fri May 14 14:04:41 2010)

E_IC0046 Error(s) occurred extending database 'iidbdb' to location

'ii_work_2'.



I can do the extend on any other database. Why would it care if the
location was already being used anyway?



Ideas?



Martin Bowes

Reply With Quote
  #4  
Old   
Paul Mason
 
Posts: n/a

Default Re: [Info-Ingres] extenddb and iidbdb - 05-14-2010 , 10:02 AM



I can extend iidbdb to an extra work location using extenddb on my close
to head revs 9.2. Either it's a bug that's fixed since your patch or I'm
not replicating your testcase closely enough.



Either way raise an issue.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 14 May 2010 14:51
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] extenddb and iidbdb



Hi Paul,



It must be an iidbdb thing.



This is a cooked location. Simple test is that multiple databases have
been extended to use the location.



Furthermore on a test box, I made a new work location and then tried to
extend iidbdb (only) to use the new location...and got the same error
messages.



Should I raise a bug?



Marty



From: Paul Mason [mailto:Paul.Mason (AT) ingres (DOT) com]
Sent: 14 May 2010 14:37
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] extenddb and iidbdb



E_US0089 refers to a raw location - which can only be used by one DB at
a time. If ii_work_2 is not raw then it may be confused by the fact that
it's iidbdb.



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 14 May 2010 14:21
To: Ingres and related product discussion forum
Subject: [Info-Ingres] extenddb and iidbdb



Hi All,



On II 9.2.0 (a64.lnx/143)NPTL + 13767



When I try: extenddb iidbdb -Uwork -lii_work_2



I get errors:

INGRES EXTENDDB Copyright 2008 Ingres Corporation

E_US0089 Another database has already been extended to the indicated

location.

(Fri May 14 14:04:41 2010)

E_IC0046 Error(s) occurred extending database 'iidbdb' to location

'ii_work_2'.



I can do the extend on any other database. Why would it care if the
location was already being used anyway?



Ideas?



Martin Bowes

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.