From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | problem with DBMirror.pl ... |
Date: | 2002-11-08 12:21:00 |
Message-ID: | 200211081751.00879.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Folks,
DBMirror had been working very fine till recently. but is facing a problem
currently.
certain "Data" column in the "PendingData" Table which DBMirror.pl script uses
has the stuff below:
"company_id"='78111' "comp_name"='SUBAIDA JEWELLERY' "office_addr"='NEW.43, NSC BOSE ROAD, ' "phone_no"=
'91-44-53508055/8056' "fax_no"= "email"='subaidajewellery(at)hotmail(dot)com' "website"='http://www.subaidajewellery.c
om' "key_exec"='MR. JAFAR|,|' "bran"= "estd"='0' "staff"='10' "prod_exp"= "prod_manu"='JEWELLERIES' "prod_imp"=
"serv_prov"= "banker_name"='DENA BANK' "email_valid"= "currency_ann"= "old_company_id"='0' "currency_exp"= "ol
d_formno"= "currency_imp"= "imp_exp_code"= "memb_affl"= "std_cert"= "trade_india_branch"='CHENNAI' "areacode"='
0' "datasource"='1' "status"='p' "formno"='4714' "edition"='12' "area"= "sno"= "city"='CHENNAI' "pincode"='6000
79' "old_edition"= "has_new_form"= "annual_turn"='0.00' "exp_turn"='0.00' "imp_turn"='0.00' "generated"='2002-0
9-03 03:17:29.694147+05:30' "operator_code"='SURESH' "fts_index"= "eyp_group_id"= "old_branch"= "imported"='f'
"collector"='G. BIJESJH' "______delete1"='f' "______delete2"='f' "eyp_exported"= "last_updated"='2002-11-08 17:
21:15.836594+05:30' "eyp_paid"= name
DBMirror.pl dies in the else clause becoz data does not match
if($dataField =~ m/(^= )/s) {
Stuff here ...
}
elsif ($dataField =~ m/(^=\')/s) {
Stuff here...
}
else {
# for above case control reaches here :((
logErrorMessage "Error in PendingData Sequence Id " .
$pendingResult->getvalue($currentTuple,0);
die;
}
What shud i do ?
where does "eyp_paid"= name come from?
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
From | Date | Subject | |
---|---|---|---|
Next Message | dropkick | 2002-11-08 14:11:17 | Recoverying DB from file(s) |
Previous Message | Tom Lane | 2002-11-08 07:44:22 | Re: Uninitialized pages notices |