problem with DBMirror.pl ...

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.

Browse pgsql-admin by date

  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