<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor=3D"#ffffff" text=3D"#000000">
Hi<b>!</b><br>
Probably this post should be sent on "bugs" list but I'm subscribed
only here and on preformance [at] <br>
Any way:<br>
<br>
Last week we upgraded our database server from 8.3 to 8.4.1 (nothing
more changed).<br>
Postgresql-8.4 was build in exactly the same environment like 8.3 was.<br=
>
<br>
Problem: we have an application that retrieves scans (100 files in
pack), looks for barcodes inside them and tries to assign them to the
records.<br>
In addition, some data is transferred to another schema ("b").<br>
This transaction is quite long... but worked perfectly on 8.3 now
transformation ended like below :-(<br>
<br>
32096][azawadzki][2009-10-04 16:59:27 CEST][0] LOG:=C2=A0 execute S_1: BE=
GIN<br>
[32096][azawadzki][2009-10-04 16:59:27 CEST][0] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM scan_document_image WHERE
scan_session_id =3D $1 AND received_document_id IS NULL AND status_id
<> 2 ORDER BY id<br>
[32096][azawadzki][2009-10-04 16:59:27 CEST][0] DETAIL:=C2=A0 parameters:=
$1
=3D '2063'<br>
[32100][[unknown]][2009-10-04 16:59:30 CEST][0] LOG:=C2=A0 connection
received: host=3D192.168.134.11 port=3D46240<br>
[32101][[unknown]][2009-10-04 16:59:30 CEST][0] LOG:=C2=A0 connection
received: host=3D192.168.134.11 port=3D46241<br>
[32100][region][2009-10-04 16:59:30 CEST][0] LOG:=C2=A0 connection
authorized: user=3Dregion database=3Dqs<br>
[32101][region][2009-10-04 16:59:30 CEST][0] LOG:=C2=A0 connection
authorized: user=3Dregion database=3Dqs<br>
[32102][[unknown]][2009-10-04 16:59:30 CEST][0] LOG:=C2=A0 connection
received: host=3D192.168.134.11 port=3D46242<br>
[32102][region][2009-10-04 16:59:30 CEST][0] LOG:=C2=A0 connection
authorized: user=3Dregion database=3Dqs<br>
[32096][azawadzki][2009-10-04 16:59:33 CEST][0] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM printout_copy WHERE id =3D $1<br>
[32096][azawadzki][2009-10-04 16:59:33 CEST][0] DETAIL:=C2=A0 parameters:=
$1
=3D '581832'<br>
[32096][azawadzki][2009-10-04 16:59:33 CEST][0] LOG:=C2=A0 execute
<unnamed>: INSERT INTO received_document=C2=A0=C2=A0=C2=A0=C2=A0 (i=
d ,
scan_session_id,printout_copy_id,printout_id,receive_user,re ceive_tmstp,r=
eceived_document_type_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
)=C2=A0=C2=A0=C2=A0=C2=A0 VALUES (<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 DEFAULT=C2=A0 , $1, $2, $3, $4=
, $5, $6=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 )=C2=A0=C2=A0=C2=A0=C2=A0 RE=
TURNING id AS id<br>
<br>
[...]<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 UPDATE b.person SET last_person_hist_id =3D $1,
history_generate_id =3D 0 WHERE id =3D $2<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '1374223', $2 =3D '658040'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SET CONSTRAINTS b.last_person_hist_id_fkey IMMEDIA=
TE<br>
<br>
Last well done command (before was ~50 sets like this one)<br>
And here is last set of commands in transaction<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM uzytk WHERE login =3D $1 ORDER BY id LIMIT
1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D 'agencja'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM b.person_identity_document WHERE=C2=A0
person_id =3D $1 AND series =3D $2 AND number =3D $3=C2=A0 AND updating_t=
mstp <
$4=C2=A0 ORDER BY updating_tmstp DESC LIMIT 1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '658040', $2 =3D 'AHZ', $3 =3D '056074', $4 =3D '2009-=
09-22
15:59:22.9133+02'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: INSERT INTO b.person_identity_document=C2=A0=C2=A0=C2=A0=
=C2=A0 (id ,
person_id,person_hist_id,hq_user_id,kind_id,series,number,is sued_by,issue=
_place,issue_date,validity_date,registration_tmstp,updating_ tmstp=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0
)=C2=A0=C2=A0=C2=A0=C2=A0 VALUES (=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 DEFAULT=C2=A0 , $1, $2, $3, $4, $5, $6, $7, $8, $9,
$10, $11, $12=C2=A0=C2=A0=C2=A0 )=C2=A0=C2=A0=C2=A0=C2=A0 RETURNING id AS=
id<br>
<br>
HIDDEN VALUES<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM zobow WHERE kredytob=3D$1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '3139017'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM uzytk WHERE login =3D $1 ORDER BY id LIMIT
1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D 'agencja'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM b.person_obligation WHERE=C2=A0 person_id =
=3D
$1=C2=A0=C2=A0=C2=A0 AND obligation_type_id =3D $2=C2=A0=C2=A0=C2=A0 AND =
total_amount =3D $3=C2=A0=C2=A0=C2=A0 AND
monthly_amount =3D $4=C2=A0=C2=A0=C2=A0 AND start_date =3D $5=C2=A0=C2=A0=
=C2=A0 AND end_date =3D $6=C2=A0=C2=A0=C2=A0 AND
bank_name_id =3D $7=C2=A0=C2=A0=C2=A0 AND bank_name_other =3D $8=C2=A0=C2=
=A0=C2=A0 AND currency_id=C2=A0 =3D
$9=C2=A0=C2=A0=C2=A0 AND updating_tmstp < $10=C2=A0 ORDER BY updating_=
tmstp DESC LIMIT 1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '658040', $2 =3D '1', $3 =3D '0', $4 =3D '150', $5 =3D=
NULL,
$6 =3D NULL, $7 =3D '-1', $8 =3D '', $9 =3D '1', $10 =3D '2009-09-22
15:59:22.9133+02'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: INSERT INTO b.person_obligation=C2=A0=C2=A0=C2=A0=C2=A0 =
(id ,
person_id,person_hist_id,registration_tmstp,updating_tmstp,h q_user_id,obl=
igation_type_id,total_amount,monthly_amount,start_date,end_d ate,bank_name=
_id,bank_name_other,currency_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A 0=C2=A0
)=C2=A0=C2=A0=C2=A0=C2=A0 VALUES (=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 DEFAULT=C2=A0 , $1, $2, $3, $4, $5, $6, $7, $8, $9,
$10, $11, $12, $13=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 )=C2=A0=C2=A0=C2=A0=
=C2=A0 RETURNING id AS id<br>
<br>
HIDDEN VALUES<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: INSERT INTO b.person_credit=C2=A0=C2=A0=C2=A0=C2=A0 (id =
,
person_id,person_hist_id,role_id,spouse_role_id,credit_data_ id=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0
)=C2=A0=C2=A0=C2=A0=C2=A0 VALUES (=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 DEFAULT=C2=A0 , $1, $2, $3, $4, $5=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0 RETURNING
id AS id<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '658040', $2 =3D '1374223', $3 =3D '1', $4 =3D '-1', $=
5 =3D
'1102245'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SELECT *=C2=A0 FROM preselling p=C2=A0 WHERE true=C2=
=A0 AND p.id =3D -1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 UPDATE kredytstatus SET b_credit_data_id =3D 11022=
45
WHERE kredytid =3D 2787619<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT=C2=A0=C2=A0=C2=A0 p.id as id,=C2=A0=C2=A0 k.id as=
borrower_id,=C2=A0=C2=A0
k.kredytid AS credit_id,=C2=A0=C2=A0 $1 AS printout_type_id FROM kredytob=
k LEFT
JOIN printout p ON (p.borrower_id =3D k.id AND p.printout_type_id =3D $2)=
=C2=A0
, kredytob k2, kredyty c WHERE true=C2=A0 AND k2.id =3D $3=C2=A0 AND k.pe=
sel =3D
k2.pesel=C2=A0 AND k.kredytid =3D c.id=C2=A0=C2=A0 AND c.datazaw >=3D =
'2008-3-4'=C2=A0=C2=A0=C2=A0=C2=A0
AND k.id <> k2.id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 AND NOT EXIST=
S (SELECT 1 FROM
received_document rd WHERE rd.printout_id =3D p.id) AND NOT EXISTS
(SELECT 1 FROM received_document_link rdl WHERE rdl.printout_id =3D p.id)=
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '1', $2 =3D '1', $3 =3D '3139017'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: INSERT INTO received_document=C2=A0=C2=A0=C2=A0=C2=A0 (i=
d ,
scan_session_id,printout_copy_id,printout_id,receive_user,re ceive_tmstp,r=
eceived_document_type_id
)=C2=A0=C2=A0=C2=A0=C2=A0 VALUES (<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 DEFAULT=C2=A0 , $1, $2, $3, $4=
, $5, $6=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 )=C2=A0=C2=A0=C2=A0=C2=A0 RE=
TURNING id AS id<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '2063', $2 =3D '610563', $3 =3D '-1', $4 =3D NULL, $5 =
=3D
'2009-10-04 17:00:45.701000 +02:00:00', $6 =3D '2'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: UPDATE scan_document_image SET received_document_id =3D
$1, page_number =3D $2 WHERE id =3D $3<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '221532', $2 =3D '1', $3 =3D '242373'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM printout_copy WHERE id =3D $1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '599066'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM printout_copy WHERE id =3D $1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '610563'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM printout WHERE id =3D $1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '505437'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM scan_document_image WHERE
received_document_id =3D $1 AND status_id <> 2 ORDER BY
page_number, id<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '221532'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM kredytob WHERE id =3D $1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '3136912'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: INSERT INTO historia (kredytid, statusrodz, statusid,
fraud_status_id, visibility_id, hq_visibility_id ) VALUES ($1, $2, $3,
$4, $5, $6)<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '2785554', $2 =3D '155', $3 =3D '-1', $4 =3D '-1', $5 =
=3D
NULL, $6 =3D NULL<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM kredyty WHERE id=3D$1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '2785554'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 select * from region where id =3D $1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '40'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM linie WHERE id =3D $1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '599'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SELECT tmstp_from FROM borrower_hist WHERE
borrower_id =3D $1=C2=A0 UNION=C2=A0 SELECT tmstp_from FROM sygma_borrowe=
r_hist
WHERE borrower_id =3D $2=C2=A0 ORDER BY tmstp_from<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '3136912', $2 =3D '3136912'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SELECT *=C2=A0 FROM borrower_hist bh=C2=A0=C2=A0=C2=
=A0 LEFT JOIN
sygma_borrower_hist bbh=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ON (bh.borrower_id =
=3D bbh.borrower_id AND
bbh.tmstp_from <=3D $1 AND bbh.tmstp_to > $2)=C2=A0 WHERE bh.borrow=
er_id
=3D $3=C2=A0=C2=A0=C2=A0 AND bh.tmstp_from <=3D $4=C2=A0=C2=A0=C2=A0 A=
ND bh.tmstp_to > $5<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '2009-09-21 16:09:44.0363+02', $2 =3D '2009-09-21
16:09:44.0363+02', $3 =3D '3136912', $4 =3D '2009-09-21 16:09:44.0363+02'=
,
$5 =3D '2009-09-21 16:09:44.0363+02'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SELECT *=C2=A0 FROM borrower_hist bh=C2=A0 WHERE b=
h.borrower_id
=3D $1=C2=A0=C2=A0=C2=A0 AND bh.tmstp_from <=3D $2=C2=A0=C2=A0=C2=A0 A=
ND bh.tmstp_to > $3<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '3136912', $2 =3D '2009-09-21 16:09:44.0363+02', $3 =3D
'2009-09-21 16:09:44.0363+02'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SELECT exists (=C2=A0=C2=A0=C2=A0 SELECT 1=C2=A0=C2=
=A0=C2=A0 FROM kredytstatus ks,
b.person p, b.person_credit pc=C2=A0=C2=A0=C2=A0 WHERE ks.kredytid =3D $1=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 AND
ks.b_credit_data_id =3D pc.credit_data_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 A=
ND pc.person_id =3D
p.id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 AND p.pesel =3D $2=C2=A0 )<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '2785554', $2 =3D '46062203047'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SELECT c.*=C2=A0 FROM kredytstatus ks, b.credit_da=
ta c=C2=A0
WHERE ks.kredytid =3D $1=C2=A0=C2=A0=C2=A0 AND ks.b_credit_data_id =3D c.=
id<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '2785554'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM uzytk WHERE login =3D $1 ORDER BY id LIMIT
1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D 'postdb'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: INSERT INTO b.credit_data=C2=A0=C2=A0=C2=A0=C2=A0 (id ,
hq_user_id,product_id,instalment_number,apply_bureau_id,bure au_id,agency_=
id,region_id,apply_region_id,multika_id,bureau_category_id,a pply_date,exp=
ort_from_agency_tmstp,preparatory_gross_credit_amount,prepar atory_applied=
_net_credit_amount,preparatory_consolidation_amount,payment_ form_id,payee=
_account_name,payee_account_no,payee_account_bank_name,giro_ authorization=
_id,preparatory_insurance_id,telecredit_id,head_office_opera tor_id,presel=
ling_id,cc_salary_preselling_id,credit_commission_id,marketi ng_source_id,=
cc_user_id,agency_user_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
)=C2=A0=C2=A0=C2=A0=C2=A0 VALUES (=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 DEFAULT=C2=A0 , $1, $2, $3, $4, $5, $6, $7, $8, $9,
$10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23,
$24, $25, $26, $27, $28, $29=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 )=C2=A0=C2=
=A0=C2=A0=C2=A0 RETURNING id AS id<br>
<br>
HIDDEN VALUES<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM b.person WHERE pesel =3D $1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '46062203047'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM uzytk WHERE login =3D $1 ORDER BY id LIMIT
1<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D 'agencja'<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: SELECT * FROM d_citizenship WHERE true=C2=A0=C2=A0=C2=A0=
ORDER BY
(CASE WHEN id=3D-1 THEN 0 ELSE 1 END),=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0 nazwa<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SET CONSTRAINTS b.last_person_hist_id_fkey DEFERRE=
D<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>: INSERT INTO b.person=C2=A0=C2=A0=C2=A0=C2=A0 (id ,
personal_data_registration_tmstp,extended_data_registration_ tmstp,hq_user=
_id,objection_kind_id,objection_date,objection_tmstp,objecti on_user,objec=
tion_note,pesel,first_name,second_name,surname,birth_date,bi rthplace,lang=
uage_id,nip,military_status_id,sex,maiden_name,mothers_maide n_name,marita=
l_status_id,number_of_persons_in_family,number_of_dependants _in_family,ed=
ucation_id,education_kind_id,bank_relation_id,citizenship_id ,legal_addres=
s_street_type_id,legal_address_street,legal_address_building _no,legal_add=
ress_flat_no,legal_address_postal_code,legal_address_post,le gal_address_c=
ity,legal_address_province_id,legal_address_country_id,origi n_country_id,=
property_ownership_form_id,property_type_id,residence_date,c orresp_addres=
s_street_type_id,corresp_address_street,corresp_address_buil ding_no,corre=
sp_address_flat_no,corresp_address_postal_code,corresp_addre ss_post,corre=
sp_address_city,corresp_address_province_id,corresp_address_ country_id,co=
rresp_address_add_phone_no,phone_operator
_id,phone_area,phone_no,add_phone_no,phone_kind_id,phone_ver ification_res=
ult_id,mobile_phone_operator_id,mobile_area,mobile_no,add_mo bile_phone_no=
,mobile_kind_id,mobile_active_id,office_phone_number,email,f ax,net_basic_=
salary_amount,net_premium_salary_amount,income_document_id,a ttached_incom=
e_document_id,attached_income_document_other,primary_income_ source_type_i=
d,employment_sector_id,annuity_closing_date,annuity_symbol,a nnuity_no,ann=
uity_start_date,annuity_amount,job_position_id,profession_id ,profession_o=
ther,job_position_name,receiving_income_start_date,receiving _income_type_=
id,income_source_verification_result_id,pension_no,pension_s ymbol,pension=
_amount,pension_start_date,previous_employment_start_date,pr evious_employ=
ment_end_date,seniority_years,seniority_months,firm_departme nt,firm_legal=
_status_id,firm_name,firm_nip,firm_registriation_no,firm_reg on,firm_stree=
t_type_id,firm_street,firm_building_no,firm_flat_no,firm_pos tal_code,firm=
_post,firm_city,firm_province_id,firm_cou
ntry_id,firm_phone_area,firm_phone_no,firm_phone_ext,add_fir m_phone_no,fi=
rm_phone_verification_result_id,firm_mobile_area,firm_mobile _no,firm_mobi=
le_kind_id,firm_second_mobile_area,firm_second_mobile_number ,firm_second_=
mobile_kind_id,firm_fax_area,firm_fax_no,work_start_date,wor k_end_date,sa=
lary_currency_id,employment_certificate_signer_name,employme nt_certificat=
e_signer_job_position_id,employment_certificate_signer_job_p osition_other=
,employment_certificate_date,business_activity_name,business _activity_sho=
rtname,business_activity_taxation_accounting_form_id,busines s_activity_ni=
p,business_activity_regon,business_activity_street,business_ activity_buil=
ding_no,business_activity_flat_no,business_activity_postal_c ode,business_=
activity_post,business_activity_city,business_activity_provi nce_id,busine=
ss_activity_phone_area,business_activity_phone_no,business_a ctivity_phone=
_ext,business_activity_mobile_area,business_activity_mobile_ no,business_a=
ctivity_mobile_kind_id,business_activity_
net_income,business_activity_gross_income,business_activity_ start_date,fa=
rmer_income_amount,income_judicial_proceeding_status_id,firm _termination_=
status_id,firm_insolvency_status_id,tax_arrear_status_id,zus _arrear_statu=
s_id,work_agreement_probation_status_id,employment_terminati on_status_id,=
ais_income_amount,ais_type_id,ais_employment_sector_id,ais_c urrency_id,ai=
s_work_start_date,ais_work_end_date,ais_profession_id,ais_pr ofession_othe=
r,ais_verification_result_id,ais_firm_name,ais_firm_street_t ype_id,ais_fi=
rm_street,ais_firm_building_no,ais_firm_flat_no,ais_firm_pos tal_code,ais_=
firm_post,ais_firm_city,ais_firm_province_id,ais_firm_phone_ area,ais_firm=
_phone_no,ais_firm_phone_ext,ais_firm_phone_verification_res ult_id,ais_fi=
rm_mobile_area,ais_firm_mobile_no,ais_firm_mobile_kind_id,ai s_firm_legal_=
status_id,ais_firm_taxation_accounting_form_id,ais_firm_nip, ais_firm_rego=
n,ais_firm_registriation_no,personal_account_status_id,perso nal_account_p=
eriod_id,personal_account_creation_date,p
ersonal_account_number,personal_account_bank_name,has_credit _card_id,prop=
erty_total_value,burdened_mortgage_id,burdened_mortgage_amou nt,financial_=
assets_total_value,life_insurance_count,life_insurance_total _value,qs_pro=
cessing_allowed_date,qs_marketing_processing_allowed_date,qs _cooperate_pr=
ocessing_allowed_id,qs_cooperate_processing_allowed_date,ins urance_proces=
sing_allowed_id,insurance_processing_allowed_date,external_v erification_p=
rocessing_allowed_id,external_verification_processing_allowe d_date,statis=
tic_processing_allowed_id,statistic_processing_allowed_date, non_personal_=
details_processing_allowed_id,non_personal_details_processin g_allowed_dat=
e,electronic_advertising_allowed_id,electronic_advertising_a llowed_date,f=
ield_of_knowledge,resolution_property_id,current_overtime_gr oss_income_am=
ount,current_bonus_gross_income_amount,current_extras_gross_ income_amount=
,current_commission_gross_income_amount,current_other_gross_ income_amount=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
)=C2=A0=C2=A0=C2=A0=C2=A0 VALUES (=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 DEFAULT=C2=A0 , $1, $2, $3, $4, $5, $6, $7, $8, $9,
$10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23,
$24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37,
$38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51,
$52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65,
$66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79,
$80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93,
$94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106,
$107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118,
$119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130,
$131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142,
$143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154,
$155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166,
$167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178,
$179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190,
$191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202,
$203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214,
$215, $216, $217, $218, $219 )=C2=A0=C2=A0=C2=A0=C2=A0 RETURNING id AS id=
<br>
<br>
HIDDEN VALUES<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 INSERT INTO b.person_hist ( id ,
personal_data_registration_tmstp,extended_data_registration_ tmstp,hq_user=
_id,objection_kind_id,objection_date,objection_tmstp,objecti on_user,objec=
tion_note,pesel,first_name,second_name,surname,birth_date,bi rthplace,lang=
uage_id,nip,military_status_id,sex,maiden_name,mothers_maide n_name,marita=
l_status_id,number_of_persons_in_family,number_of_dependants _in_family,ed=
ucation_id,education_kind_id,bank_relation_id,citizenship_id ,legal_addres=
s_street_type_id,legal_address_street,legal_address_building _no,legal_add=
ress_flat_no,legal_address_postal_code,legal_address_post,le gal_address_c=
ity,legal_address_province_id,legal_address_country_id,origi n_country_id,=
property_ownership_form_id,property_type_id,residence_date,c orresp_addres=
s_street_type_id,corresp_address_street,corresp_address_buil ding_no,corre=
sp_address_flat_no,corresp_address_postal_code,corresp_addre ss_post,corre=
sp_address_city,corresp_address_province_id,corresp_address_ country_id,co=
rresp_address_add_phone_no,phone_operator
_id,phone_area,phone_no,add_phone_no,phone_kind_id,phone_ver ification_res=
ult_id,mobile_phone_operator_id,mobile_area,mobile_no,add_mo bile_phone_no=
,mobile_kind_id,mobile_active_id,office_phone_number,email,f ax,net_basic_=
salary_amount,net_premium_salary_amount,income_document_id,a ttached_incom=
e_document_id,attached_income_document_other,primary_income_ source_type_i=
d,employment_sector_id,annuity_closing_date,annuity_symbol,a nnuity_no,ann=
uity_start_date,annuity_amount,job_position_id,profession_id ,profession_o=
ther,job_position_name,receiving_income_start_date,receiving _income_type_=
id,income_source_verification_result_id,pension_no,pension_s ymbol,pension=
_amount,pension_start_date,previous_employment_start_date,pr evious_employ=
ment_end_date,seniority_years,seniority_months,firm_departme nt,firm_legal=
_status_id,firm_name,firm_nip,firm_registriation_no,firm_reg on,firm_stree=
t_type_id,firm_street,firm_building_no,firm_flat_no,firm_pos tal_code,firm=
_post,firm_city,firm_province_id,firm_cou
ntry_id,firm_phone_area,firm_phone_no,firm_phone_ext,add_fir m_phone_no,fi=
rm_phone_verification_result_id,firm_mobile_area,firm_mobile _no,firm_mobi=
le_kind_id,firm_second_mobile_area,firm_second_mobile_number ,firm_second_=
mobile_kind_id,firm_fax_area,firm_fax_no,work_start_date,wor k_end_date,sa=
lary_currency_id,employment_certificate_signer_name,employme nt_certificat=
e_signer_job_position_id,employment_certificate_signer_job_p osition_other=
,employment_certificate_date,business_activity_name,business _activity_sho=
rtname,business_activity_taxation_accounting_form_id,busines s_activity_ni=
p,business_activity_regon,business_activity_street,business_ activity_buil=
ding_no,business_activity_flat_no,business_activity_postal_c ode,business_=
activity_post,business_activity_city,business_activity_provi nce_id,busine=
ss_activity_phone_area,business_activity_phone_no,business_a ctivity_phone=
_ext,business_activity_mobile_area,business_activity_mobile_ no,business_a=
ctivity_mobile_kind_id,business_activity_
net_income,business_activity_gross_income,business_activity_ start_date,fa=
rmer_income_amount,income_judicial_proceeding_status_id,firm _termination_=
status_id,firm_insolvency_status_id,tax_arrear_status_id,zus _arrear_statu=
s_id,work_agreement<br>
_probation_status_id,employment_termination_status_id,ais_in come_amount,a=
is_type_id,ais_employment_sector_id,ais_currency_id,ais_work _start_date,a=
is_work_end_date,ais_profession_id,ais_profession_other,ais_ verification_=
result_id,ais_firm<br>
ais_firm_name,ais_firm_street_type_id,ais_firm_street,ais_fi rm_building_n=
o,ais_firm_flat_no,ais_firm_postal_code,ais_firm_post,ais_fi rm_city,ais_f=
irm_province_id,ais_firm_phone_area,ais_firm_phone_no,ais_fi rm_phone_ext,=
ais_firm_phone_verification_result_id,ais_firm_mobile_area,a is_firm_mobil=
e_no,ais_firm_mobile_kind_id,ais_firm_legal_status_id,ais_fi rm_taxation_a=
ccounting_form_id,ais_firm_nip,ais_firm_regon,ais_firm_regis triation_no,p=
ersonal_account_status_id,personal_account_period_id,persona l_account_cre=
ation_date,personal_account_number,personal_account_bank_nam e,has_credit_=
card_id,property_total_value,burdened_mortgage_id,burdened_m ortgage_amoun=
t,financial_assets_total_value,life_insurance_count,life_ins urance_total_=
value,qs_processing_allowed_date,qs_marketing_processing_all owed_date,qs_=
cooperate_processing_allowed_id,qs_cooperate_processing_allo wed_date,insu=
rance_processing_allowed_id,insurance_processing_allowed_dat e,external_ve=
rification_processing_allowed_id,external
_verification_processing_allowed_date,statistic_processing_a llowed_id,sta=
tistic_processing_allowed_date,non_personal_details_processi ng_allowed_id=
,non_personal_details_processing_allowed_date,electronic_adv ertising_allo=
wed_id,electronic_advertising_allowed_date,field_of_knowledg e,resolution_=
property_id,current_overtime_gross_income_amount,current_bon us_gross_inco=
me_amount,current_extras_gross_income_amount,current_commiss ion_gross_inc=
ome_amount,current_other_gross_income_amount,
person_id , tmstp_from,tmstp_to ) VALUES (=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0 DEFAULT=C2=A0 , $1, $2, $3,
$4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18,
$19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32,
$33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46,
$47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60,
$61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74,
$75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88,
$89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101,
$102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113,
$114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125,
$126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137,
$138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149,
$150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161,
$162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173,
$174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185,
$186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197,
$198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209,
$210, $211, $212, $213, $214, $215, $216, $217, $218, $219 , $220=C2=A0 ,
$221, $222 ) RETURNING id AS id<br>
<br>
HIDDEN VALUES<br>
<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 UPDATE b.person SET last_person_hist_id =3D $1,
history_generate_id =3D 0 WHERE id =3D $2<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:=C2=A0
parameters: $1 =3D '1374224', $2 =3D '658041'<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute
<unnamed>:=C2=A0 SET CONSTRAINTS b.last_person_hist_id_fkey IMMEDIA=
TE<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] ERROR:=C2=A0 could n=
ot
open relation with OID 10027008<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] STATEMENT:=C2=A0=C2=A0=
SET
CONSTRAINTS b.last_person_hist_id_fkey IMMEDIATE<br>
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:=C2=A0 execute S=
_2:
ROLLBACK<br>
<br>
I can repeat this behavior on all my test and production servers. If I
run this last transaction block separately everything works fine.<br>
What could be wrong? Some bad adjustments? On the 8.3 works well...<br>
<br>
ps. sorry for html but IMHO looks better.<br>
<br>
-- <br>
Andrzej Zawadzki<br>
</body>
</html>
