ER replicate creation err
On IDS 10.00.UC5 (AIX), 'cdr define replicate' with --conflict=timestamp failed with "Error creating delete table (57)", while --conflict=ignore worked. Madison Pruet said this typically happens when the syscdr database was dropped without first removing the old delete tables, leaving stale remnants; Frank confirmed he had dbexported/dbimported a copy of an already ER-replicated database, which Pruet agreed was the cause. The advice was to contact tech support to clean up the system properly; no self-service fix steps are given in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello,
Program Name: onstat
Build Version: 10.00.UC5
Build Number: N202
Build Host: ibm6c1b
Build OS: AIX 5.2
Build Date: Thu May 18 00:09:08 CDT 2006
GLS Version: glslib-4.00.UC8
I am creating replciaes,
cdr define replicate --conflict=timestamp --ats --ris ds_chksum_repl \\\\
"noaa@osd_int1:informix.ds_chksum" "select * from ds_chksum" \\\\
"noaa@osd_int2:informix.ds_chksum" "select * from ds_chksum"
it seems always reports,
command failed -- Error creating delete table (57)
whenever, conflict=timestamp.
But, It will be OK if I change "timestamp" to "ignore".
Any idea?
Thanks,
Frank
This is probably the result of having dropped the syscdr database witho=
ut
having removed all of the delete tables at some time in the past. You =
will
need to contact tech support to help you get the system cleaned up
correctly.
M.P.
=
"FRANK" =
<yunyaoqu@gmail.c =
om> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
ER replicate creation err [7603]=
10/11/2006 02:53 =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hello,
Program Name: onstat
Build Version: 10.00.UC5
Build Number: N202
Build Host: ibm6c1b
Build OS: AIX 5.2
Build Date: Thu May 18 00:09:08 CDT 2006
GLS Version: glslib-4.00.UC8
I am creating replciaes,
cdr define replicate --conflict=3Dtimestamp --ats --ris ds_chksum_repl =
\\\\
"noaa@osd_int1:informix.ds_chksum" "select * from ds_chksum" \\\\
"noaa@osd_int2:informix.ds_chksum" "select * from ds_chksum"
it seems always reports,
command failed -- Error creating delete table (57)
whenever, conflict=3Dtimestamp.
But, It will be OK if I change "timestamp" to "ignore".
Any idea?
Thanks,
Frank
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
If you don't mind telling, what kind of columns you have in the ds_chks=
um
table? I suspect you might have encountered a known problem.
__________________________________
=
"FRANK" =
<yunyaoqu@gmail.c =
om> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
ER replicate creation err [7603]=
10/11/2006 02:53 =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hello,
Program Name: onstat
Build Version: 10.00.UC5
Build Number: N202
Build Host: ibm6c1b
Build OS: AIX 5.2
Build Date: Thu May 18 00:09:08 CDT 2006
GLS Version: glslib-4.00.UC8
I am creating replciaes,
cdr define replicate --conflict=3Dtimestamp --ats --ris ds_chksum_repl =
\\\\
"noaa@osd_int1:informix.ds_chksum" "select * from ds_chksum" \\\\
"noaa@osd_int2:informix.ds_chksum" "select * from ds_chksum"
it seems always reports,
command failed -- Error creating delete table (57)
whenever, conflict=3Dtimestamp.
But, It will be OK if I change "timestamp" to "ignore".
Any idea?
Thanks,
Frank
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
HI,
Absolutely! The following is the dbschema.
By the way, Some how, the (UC5?) dbschema's ouput also includes a extra
unknow table se_dissolve with, sorry.
Thanks,
Frank
informix@dora $ dbschema -d noaa -t ds_chksum -ss
DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.UC5
Copyright IBM Corporation 1996, 2004 All rights reserved
Software Serial Number AAA#B000000
create aggregate "informix".se_dissolve with
(
INIT = se_dissolve_init,
ITER = se_dissolve_iter,
COMBINE = se_dissolve_combine,
FINAL = se_dissolve_final
);
{ TABLE "informix".ds_chksum row size = 54 number of columns = 4 index size
= 28
}
create table "informix".ds_chksum
(
inventory_id integer not null ,
file_type char(5),
file_sub_type char(5),
check_sum char(32)
) with crcols in dbdata02 extent size 160000 next size 10000 lock mode
row;
revoke all on "informix".ds_chksum from "public";
create index "informix".ds_chksum_idx1 on "informix".ds_chksum
(inventory_id) using btree in dbdata02 ;
create unique index "informix".ds_chksum_ipk on "informix".ds_chksum
(inventory_id,file_type,file_sub_type) using btree in dbdata02
;
alter table "informix".ds_chksum add constraint primary key (inventory_id,
file_type,file_sub_type) constraint "informix".ds_chksum_pk
;
alter table "informix".ds_chksum add constraint (foreign key
(inventory_id) references "informix".ds_head constraint "informix"
.ds_chksum_fk);
On 10/11/06, Wee Tung <wtung@us.ibm.com> wrote:
>
>
> If you don't mind telling, what kind of columns you have in the ds_chks=
> um
> table? I suspect you might have encountered a known problem.
>
> __________________________________
>
> =
>
> "FRANK" =
>
> <yunyaoqu@gmail.c =
>
> om> =
> To
>
> Sent by: ids@iiug.org =
>
> ids-bounces@iiug. =
> cc
>
> org =
>
> Subj=
> ect
>
> ER replicate creation err [7603]=
>
> 10/11/2006 02:53 =
>
> PM =
>
> =
>
> =
>
> Please respond to =
>
> ids@iiug.org =
>
> =
>
> =
>
> Hello,
>
> Program Name: onstat
> Build Version: 10.00.UC5
> Build Number: N202
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Thu May 18 00:09:08 CDT 2006
> GLS Version: glslib-4.00.UC8
>
> I am creating replciaes,
>
> cdr define replicate --conflict=3Dtimestamp --ats --ris ds_chksum_repl =
> \\\\
>
> "noaa@osd_int1:informix.ds_chksum" "select * from ds_chksum" \\\\
>
> "noaa@osd_int2:informix.ds_chksum" "select * from ds_chksum"
>
> it seems always reports,
>
> command failed -- Error creating delete table (57)
>
> whenever, conflict=3Dtimestamp.
>
> But, It will be OK if I change "timestamp" to "ignore".
>
> Any idea?
>
> Thanks,
> Frank
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*Madison,*
**
Probably, because I dbimported a dbexported copy of the current ER
replicated database.
Thanks,
Frank
On 10/11/06, Madison Pruet <mpruet@us.ibm.com> wrote:
>
>
> This is probably the result of having dropped the syscdr database witho=
> ut
> having removed all of the delete tables at some time in the past. You =
> will
> need to contact tech support to help you get the system cleaned up
> correctly.
>
> M.P.
>
> =
>
> "FRANK" =
>
> <yunyaoqu@gmail.c =
>
> om> =
> To
>
> Sent by: ids@iiug.org =
>
> ids-bounces@iiug. =
> cc
>
> org =
>
> Subj=
> ect
>
> ER replicate creation err [7603]=
>
> 10/11/2006 02:53 =
>
> PM =
>
> =
>
> =
>
> Please respond to =
>
> ids@iiug.org =
>
> =
>
> =
>
> Hello,
>
> Program Name: onstat
> Build Version: 10.00.UC5
> Build Number: N202
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Thu May 18 00:09:08 CDT 2006
> GLS Version: glslib-4.00.UC8
>
> I am creating replciaes,
>
> cdr define replicate --conflict=3Dtimestamp --ats --ris ds_chksum_repl =
> \\\\
>
> "noaa@osd_int1:informix.ds_chksum" "select * from ds_chksum" \\\\
>
> "noaa@osd_int2:informix.ds_chksum" "select * from ds_chksum"
>
> it seems always reports,
>
> command failed -- Error creating delete table (57)
>
> whenever, conflict=3Dtimestamp.
>
> But, It will be OK if I change "timestamp" to "ignore".
>
> Any idea?
>
> Thanks,
> Frank
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Yep- that's the problem.
=
"FRANK" =
<yunyaoqu@gmail.c =
om> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: ER replicate creation err =
10/11/2006 03:38 [7607] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
*Madison,*
**
Probably, because I dbimported a dbexported copy of the current ER
replicated database.
Thanks,
Frank
On 10/11/06, Madison Pruet <mpruet@us.ibm.com> wrote:
>
>
> This is probably the result of having dropped the syscdr database wit=
ho=3D
> ut
> having removed all of the delete tables at some time in the past. You=
=3D
> will
> need to contact tech support to help you get the system cleaned up
> correctly.
>
> M.P.
>
> =3D
>
> "FRANK" =3D
>
> <yunyaoqu@gmail.c =3D
>
> om> =3D
> To
>
> Sent by: ids@iiug.org =3D
>
> ids-bounces@iiug. =3D
> cc
>
> org =3D
>
> Subj=3D
> ect
>
> ER replicate creation err [7603]=3D
>
> 10/11/2006 02:53 =3D
>
> PM =3D
>
> =3D
>
> =3D
>
> Please respond to =3D
>
> ids@iiug.org =3D
>
> =3D
>
> =3D
>
> Hello,
>
> Program Name: onstat
> Build Version: 10.00.UC5
> Build Number: N202
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Thu May 18 00:09:08 CDT 2006
> GLS Version: glslib-4.00.UC8
>
> I am creating replciaes,
>
> cdr define replicate --conflict=3D3Dtimestamp --ats --ris ds_chksum_r=
epl =3D
> \\\\
>
> "noaa@osd_int1:informix.ds_chksum" "select * from ds_chksum" \\\\
>
> "noaa@osd_int2:informix.ds_chksum" "select * from ds_chksum"
>
> it seems always reports,
>
> command failed -- Error creating delete table (57)
>
> whenever, conflict=3D3Dtimestamp.
>
> But, It will be OK if I change "timestamp" to "ignore".
>
> Any idea?
>
> Thanks,
> Frank
>
> *********************************************************************=
**=3D
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =3D
>
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=