On 11/9/05, martin.bowes@ctsu.ox.ac.uk <martin.bowes@ctsu.ox.ac.uk> wrote:
>
> Hi Dudes,
>

Hi Marty

>
> I'm still playing around with Replicator...No sign of beautiful space babes,
> maybe their playing hard to get, bless there little cotton socks.
>

Maybe you're wearing the wrong kind of jeans

>
> I've managed to set up replication between two databases owned by ingres.
>
>
> But when I try the same for two databases owned by a non ingres user (ie me)
> the stage at which I 'move the configuration to the other databases involved
> in the replication', fails with:
> Error dropping database object 'change_rea00001sha'. E_US0AC1 DROP:
> 'change_rea00001sha' does not exist or is not owned by you.
>
>
> The shadow table in question does not exist on the target database. Nor
> should it. Its a brand new database. At the equivalent stage of the
> successful ingres<-->ingres replication the shadow tables did not exist on
> the target database.
>
>
> The non ingres DBA is in role ingrep and has trace privilege as well as
> owning the tables assigned for replication in this CDDS. This is so on both
> source and target.
>
>
> If I create all the support tables and procedures on the target database
> before moving the configuration, I still get the same error.
>
>
> I've tried creating the support objects as both ingres and as the non-
> ingres DBA.
>
>
> Anyone got any ideas?
>

After a bit of a hunt around the source code, yes.

I tried this and sure enough it does a drop of the tables that need to
be created (run repmgr with II_EMBED_SET=printqry to see what's
happening). From the code what's supposed to happen is that "table
does not exist" errors are supposed to be ignored. However the error
codes can be affected if you have II_EMBED_SET=dbmserror.

If this is what it is then it's a bug as we should set the error type
locally before retrieving it (I've worked on an ipm bug with this
cause).


--
Paul Mason

Paul Mason wrote:

>>I'm still playing around with Replicator...No sign of beautiful space babes,
>>maybe their playing hard to get, bless there little cotton socks.
>
> Maybe you're wearing the wrong kind of jeans

You missed an opportunity to fix that:
http://cgi.ebay.com/ws/eBayISAPI.dll...41#description

Emile