Hi!
Probably this post should be sent on "bugs" list but I'm subscribed
only here and on preformance@
Any way:
Last week we upgraded our database server from 8.3 to 8.4.1 (nothing
more changed).
Postgresql-8.4 was build in exactly the same environment like 8.3 was.
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.
In addition, some data is transferred to another schema ("b").
This transaction is quite long... but worked perfectly on 8.3 now
transformation ended like below :-(
32096][azawadzki][2009-10-04 16:59:27 CEST][0] LOG: execute S_1: BEGIN
[32096][azawadzki][2009-10-04 16:59:27 CEST][0] LOG: execute
<unnamed>: SELECT * FROM scan_document_image WHERE
scan_session_id = $1 AND received_document_id IS NULL AND status_id
<> 2 ORDER BY id
[32096][azawadzki][2009-10-04 16:59:27 CEST][0] DETAIL: parameters: $1
= '2063'
[32100][[unknown]][2009-10-04 16:59:30 CEST][0] LOG: connection
received: host=192.168.134.11 port=46240
[32101][[unknown]][2009-10-04 16:59:30 CEST][0] LOG: connection
received: host=192.168.134.11 port=46241
[32100][region][2009-10-04 16:59:30 CEST][0] LOG: connection
authorized: user=region database=qs
[32101][region][2009-10-04 16:59:30 CEST][0] LOG: connection
authorized: user=region database=qs
[32102][[unknown]][2009-10-04 16:59:30 CEST][0] LOG: connection
received: host=192.168.134.11 port=46242
[32102][region][2009-10-04 16:59:30 CEST][0] LOG: connection
authorized: user=region database=qs
[32096][azawadzki][2009-10-04 16:59:33 CEST][0] LOG: execute
<unnamed>: SELECT * FROM printout_copy WHERE id = $1
[32096][azawadzki][2009-10-04 16:59:33 CEST][0] DETAIL: parameters: $1
= '581832'
[32096][azawadzki][2009-10-04 16:59:33 CEST][0] LOG: execute
<unnamed>: INSERT INTO received_document (id ,
scan_session_id,printout_copy_id,printout_id,receive_user,receive_tmstp,received_document_type_id
) VALUES (
DEFAULT , $1, $2, $3, $4, $5, $6 ) RETURNING id AS id
[...]
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: UPDATE b.person SET last_person_hist_id = $1,
history_generate_id = 0 WHERE id = $2
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '1374223', $2 = '658040'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SET CONSTRAINTS b.last_person_hist_id_fkey IMMEDIATE
Last well done command (before was ~50 sets like this one)
And here is last set of commands in transaction
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM uzytk WHERE login = $1 ORDER BY id LIMIT
1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = 'agencja'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM b.person_identity_document WHERE
person_id = $1 AND series = $2 AND number = $3 AND updating_tmstp <
$4 ORDER BY updating_tmstp DESC LIMIT 1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '658040', $2 = 'AHZ', $3 = '056074', $4 = '2009-09-22
15:59:22.9133+02'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO b.person_identity_document (id ,
person_id,person_hist_id,hq_user_id,kind_id,series,number,issued_by,issue_place,issue_date,validity_date,registration_tmstp,updating_tmstp
) VALUES ( DEFAULT , $1, $2, $3, $4, $5, $6, $7, $8, $9,
$10, $11, $12 ) RETURNING id AS id
HIDDEN VALUES
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM zobow WHERE kredytob=$1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '3139017'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM uzytk WHERE login = $1 ORDER BY id LIMIT
1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = 'agencja'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM b.person_obligation WHERE person_id =
$1 AND obligation_type_id = $2 AND total_amount = $3 AND
monthly_amount = $4 AND start_date = $5 AND end_date = $6 AND
bank_name_id = $7 AND bank_name_other = $8 AND currency_id =
$9 AND updating_tmstp < $10 ORDER BY updating_tmstp DESC LIMIT 1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '658040', $2 = '1', $3 = '0', $4 = '150', $5 = NULL,
$6 = NULL, $7 = '-1', $8 = '', $9 = '1', $10 = '2009-09-22
15:59:22.9133+02'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO b.person_obligation (id ,
person_id,person_hist_id,registration_tmstp,updating_tmstp,hq_user_id,obligation_type_id,total_amount,monthly_amount,start_date,end_date,bank_name_id,bank_name_other,currency_id
) VALUES ( DEFAULT , $1, $2, $3, $4, $5, $6, $7, $8, $9,
$10, $11, $12, $13 ) RETURNING id AS id
HIDDEN VALUES
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO b.person_credit (id ,
person_id,person_hist_id,role_id,spouse_role_id,credit_data_id
) VALUES ( DEFAULT , $1, $2, $3, $4, $5 RETURNING
id AS id
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '658040', $2 = '1374223', $3 = '1', $4 = '-1', $5 =
'1102245'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM preselling p WHERE true AND p.id = -1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: UPDATE kredytstatus SET b_credit_data_id = 1102245
WHERE kredytid = 2787619
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT p.id as id, k.id as borrower_id,
k.kredytid AS credit_id, $1 AS printout_type_id FROM kredytob k LEFT
JOIN printout p ON (p.borrower_id = k.id AND p.printout_type_id = $2)
, kredytob k2, kredyty c WHERE true AND k2.id = $3 AND k.pesel =
k2.pesel AND k.kredytid = c.id AND c.datazaw >= '2008-3-4'
AND k.id <> k2.id AND NOT EXISTS (SELECT 1 FROM
received_document rd WHERE rd.printout_id = p.id) AND NOT EXISTS
(SELECT 1 FROM received_document_link rdl WHERE rdl.printout_id = p.id)
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '1', $2 = '1', $3 = '3139017'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO received_document (id ,
scan_session_id,printout_copy_id,printout_id,receive_user,receive_tmstp,received_document_type_id
) VALUES (
DEFAULT , $1, $2, $3, $4, $5, $6 ) RETURNING id AS id
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '2063', $2 = '610563', $3 = '-1', $4 = NULL, $5 =
'2009-10-04 17:00:45.701000 +02:00:00', $6 = '2'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: UPDATE scan_document_image SET received_document_id =
$1, page_number = $2 WHERE id = $3
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '221532', $2 = '1', $3 = '242373'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM printout_copy WHERE id = $1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '599066'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM printout_copy WHERE id = $1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '610563'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM printout WHERE id = $1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '505437'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM scan_document_image WHERE
received_document_id = $1 AND status_id <> 2 ORDER BY
page_number, id
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '221532'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM kredytob WHERE id = $1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '3136912'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO historia (kredytid, statusrodz, statusid,
fraud_status_id, visibility_id, hq_visibility_id ) VALUES ($1, $2, $3,
$4, $5, $6)
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '2785554', $2 = '155', $3 = '-1', $4 = '-1', $5 =
NULL, $6 = NULL
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM kredyty WHERE id=$1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '2785554'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: select * from region where id = $1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '40'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM linie WHERE id = $1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '599'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT tmstp_from FROM borrower_hist WHERE
borrower_id = $1 UNION SELECT tmstp_from FROM sygma_borrower_hist
WHERE borrower_id = $2 ORDER BY tmstp_from
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '3136912', $2 = '3136912'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM borrower_hist bh LEFT JOIN
sygma_borrower_hist bbh ON (bh.borrower_id = bbh.borrower_id AND
bbh.tmstp_from <= $1 AND bbh.tmstp_to > $2) WHERE bh.borrower_id
= $3 AND bh.tmstp_from <= $4 AND bh.tmstp_to > $5
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '2009-09-21 16:09:44.0363+02', $2 = '2009-09-21
16:09:44.0363+02', $3 = '3136912', $4 = '2009-09-21 16:09:44.0363+02',
$5 = '2009-09-21 16:09:44.0363+02'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM borrower_hist bh WHERE bh.borrower_id
= $1 AND bh.tmstp_from <= $2 AND bh.tmstp_to > $3
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '3136912', $2 = '2009-09-21 16:09:44.0363+02', $3 =
'2009-09-21 16:09:44.0363+02'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT exists ( SELECT 1 FROM kredytstatus ks,
b.person p, b.person_credit pc WHERE ks.kredytid = $1 AND
ks.b_credit_data_id = pc.credit_data_id AND pc.person_id =
p.id AND p.pesel = $2 )
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '2785554', $2 = '46062203047'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT c.* FROM kredytstatus ks, b.credit_data c
WHERE ks.kredytid = $1 AND ks.b_credit_data_id = c.id
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '2785554'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM uzytk WHERE login = $1 ORDER BY id LIMIT
1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = 'postdb'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO b.credit_data (id ,
hq_user_id,product_id,instalment_number,apply_bureau_id,bureau_id,agency_id,region_id,apply_region_id,multika_id,bureau_category_id,apply_date,export_from_agency_tmstp,preparatory_gross_credit_amount,preparatory_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_operator_id,preselling_id,cc_salary_preselling_id,credit_commission_id,marketing_source_id,cc_user_id,agency_user_id
) VALUES ( DEFAULT , $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 ) RETURNING id AS id
HIDDEN VALUES
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM b.person WHERE pesel = $1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '46062203047'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM uzytk WHERE login = $1 ORDER BY id LIMIT
1
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = 'agencja'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SELECT * FROM d_citizenship WHERE true ORDER BY
(CASE WHEN id=-1 THEN 0 ELSE 1 END), nazwa
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SET CONSTRAINTS b.last_person_hist_id_fkey DEFERRED
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO b.person (id ,
personal_data_registration_tmstp,extended_data_registration_tmstp,hq_user_id,objection_kind_id,objection_date,objection_tmstp,objection_user,objection_note,pesel,first_name,second_name,surname,birth_date,birthplace,language_id,nip,military_status_id,sex,maiden_name,mothers_maiden_name,marital_status_id,number_of_persons_in_family,number_of_dependants_in_family,education_id,education_kind_id,bank_relation_id,citizenship_id,legal_address_street_type_id,legal_address_street,legal_address_building_no,legal_address_flat_no,legal_address_postal_code,legal_address_post,legal_address_city,legal_address_province_id,legal_address_country_id,origin_country_id,property_ownership_form_id,property_type_id,residence_date,corresp_address_street_type_id,corresp_address_street,corresp_address_building_no,corresp_address_flat_no,corresp_address_postal_code,corresp_address_post,corresp_address_city,corresp_address_province_id,corresp_address_country_id,corresp_address_add_phone_no,phone_operator
_id,phone_area,phone_no,add_phone_no,phone_kind_id,phone_verification_result_id,mobile_phone_operator_id,mobile_area,mobile_no,add_mobile_phone_no,mobile_kind_id,mobile_active_id,office_phone_number,email,fax,net_basic_salary_amount,net_premium_salary_amount,income_document_id,attached_income_document_id,attached_income_document_other,primary_income_source_type_id,employment_sector_id,annuity_closing_date,annuity_symbol,annuity_no,annuity_start_date,annuity_amount,job_position_id,profession_id,profession_other,job_position_name,receiving_income_start_date,receiving_income_type_id,income_source_verification_result_id,pension_no,pension_symbol,pension_amount,pension_start_date,previous_employment_start_date,previous_employment_end_date,seniority_years,seniority_months,firm_department,firm_legal_status_id,firm_name,firm_nip,firm_registriation_no,firm_regon,firm_street_type_id,firm_street,firm_building_no,firm_flat_no,firm_postal_code,firm_post,firm_city,firm_province_id,firm_cou
ntry_id,firm_phone_area,firm_phone_no,firm_phone_ext,add_firm_phone_no,firm_phone_verification_result_id,firm_mobile_area,firm_mobile_no,firm_mobile_kind_id,firm_second_mobile_area,firm_second_mobile_number,firm_second_mobile_kind_id,firm_fax_area,firm_fax_no,work_start_date,work_end_date,salary_currency_id,employment_certificate_signer_name,employment_certificate_signer_job_position_id,employment_certificate_signer_job_position_other,employment_certificate_date,business_activity_name,business_activity_shortname,business_activity_taxation_accounting_form_id,business_activity_nip,business_activity_regon,business_activity_street,business_activity_building_no,business_activity_flat_no,business_activity_postal_code,business_activity_post,business_activity_city,business_activity_province_id,business_activity_phone_area,business_activity_phone_no,business_activity_phone_ext,business_activity_mobile_area,business_activity_mobile_no,business_activity_mobile_kind_id,business_activity_
net_income,business_activity_gross_income,business_activity_start_date,farmer_income_amount,income_judicial_proceeding_status_id,firm_termination_status_id,firm_insolvency_status_id,tax_arrear_status_id,zus_arrear_status_id,work_agreement_probation_status_id,employment_termination_status_id,ais_income_amount,ais_type_id,ais_employment_sector_id,ais_currency_id,ais_work_start_date,ais_work_end_date,ais_profession_id,ais_profession_other,ais_verification_result_id,ais_firm_name,ais_firm_street_type_id,ais_firm_street,ais_firm_building_no,ais_firm_flat_no,ais_firm_postal_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_result_id,ais_firm_mobile_area,ais_firm_mobile_no,ais_firm_mobile_kind_id,ais_firm_legal_status_id,ais_firm_taxation_accounting_form_id,ais_firm_nip,ais_firm_regon,ais_firm_registriation_no,personal_account_status_id,personal_account_period_id,personal_account_creation_date,p
ersonal_account_number,personal_account_bank_name,has_credit_card_id,property_total_value,burdened_mortgage_id,burdened_mortgage_amount,financial_assets_total_value,life_insurance_count,life_insurance_total_value,qs_processing_allowed_date,qs_marketing_processing_allowed_date,qs_cooperate_processing_allowed_id,qs_cooperate_processing_allowed_date,insurance_processing_allowed_id,insurance_processing_allowed_date,external_verification_processing_allowed_id,external_verification_processing_allowed_date,statistic_processing_allowed_id,statistic_processing_allowed_date,non_personal_details_processing_allowed_id,non_personal_details_processing_allowed_date,electronic_advertising_allowed_id,electronic_advertising_allowed_date,field_of_knowledge,resolution_property_id,current_overtime_gross_income_amount,current_bonus_gross_income_amount,current_extras_gross_income_amount,current_commission_gross_income_amount,current_other_gross_income_amount
) VALUES ( DEFAULT , $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 ) RETURNING id AS id
HIDDEN VALUES
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: INSERT INTO b.person_hist ( id ,
personal_data_registration_tmstp,extended_data_registration_tmstp,hq_user_id,objection_kind_id,objection_date,objection_tmstp,objection_user,objection_note,pesel,first_name,second_name,surname,birth_date,birthplace,language_id,nip,military_status_id,sex,maiden_name,mothers_maiden_name,marital_status_id,number_of_persons_in_family,number_of_dependants_in_family,education_id,education_kind_id,bank_relation_id,citizenship_id,legal_address_street_type_id,legal_address_street,legal_address_building_no,legal_address_flat_no,legal_address_postal_code,legal_address_post,legal_address_city,legal_address_province_id,legal_address_country_id,origin_country_id,property_ownership_form_id,property_type_id,residence_date,corresp_address_street_type_id,corresp_address_street,corresp_address_building_no,corresp_address_flat_no,corresp_address_postal_code,corresp_address_post,corresp_address_city,corresp_address_province_id,corresp_address_country_id,corresp_address_add_phone_no,phone_operator
_id,phone_area,phone_no,add_phone_no,phone_kind_id,phone_verification_result_id,mobile_phone_operator_id,mobile_area,mobile_no,add_mobile_phone_no,mobile_kind_id,mobile_active_id,office_phone_number,email,fax,net_basic_salary_amount,net_premium_salary_amount,income_document_id,attached_income_document_id,attached_income_document_other,primary_income_source_type_id,employment_sector_id,annuity_closing_date,annuity_symbol,annuity_no,annuity_start_date,annuity_amount,job_position_id,profession_id,profession_other,job_position_name,receiving_income_start_date,receiving_income_type_id,income_source_verification_result_id,pension_no,pension_symbol,pension_amount,pension_start_date,previous_employment_start_date,previous_employment_end_date,seniority_years,seniority_months,firm_department,firm_legal_status_id,firm_name,firm_nip,firm_registriation_no,firm_regon,firm_street_type_id,firm_street,firm_building_no,firm_flat_no,firm_postal_code,firm_post,firm_city,firm_province_id,firm_cou
ntry_id,firm_phone_area,firm_phone_no,firm_phone_ext,add_firm_phone_no,firm_phone_verification_result_id,firm_mobile_area,firm_mobile_no,firm_mobile_kind_id,firm_second_mobile_area,firm_second_mobile_number,firm_second_mobile_kind_id,firm_fax_area,firm_fax_no,work_start_date,work_end_date,salary_currency_id,employment_certificate_signer_name,employment_certificate_signer_job_position_id,employment_certificate_signer_job_position_other,employment_certificate_date,business_activity_name,business_activity_shortname,business_activity_taxation_accounting_form_id,business_activity_nip,business_activity_regon,business_activity_street,business_activity_building_no,business_activity_flat_no,business_activity_postal_code,business_activity_post,business_activity_city,business_activity_province_id,business_activity_phone_area,business_activity_phone_no,business_activity_phone_ext,business_activity_mobile_area,business_activity_mobile_no,business_activity_mobile_kind_id,business_activity_
net_income,business_activity_gross_income,business_activity_start_date,farmer_income_amount,income_judicial_proceeding_status_id,firm_termination_status_id,firm_insolvency_status_id,tax_arrear_status_id,zus_arrear_status_id,work_agreement
_probation_status_id,employment_termination_status_id,ais_income_amount,ais_type_id,ais_employment_sector_id,ais_currency_id,ais_work_start_date,ais_work_end_date,ais_profession_id,ais_profession_other,ais_verification_result_id,ais_firm
ais_firm_name,ais_firm_street_type_id,ais_firm_street,ais_firm_building_no,ais_firm_flat_no,ais_firm_postal_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_result_id,ais_firm_mobile_area,ais_firm_mobile_no,ais_firm_mobile_kind_id,ais_firm_legal_status_id,ais_firm_taxation_accounting_form_id,ais_firm_nip,ais_firm_regon,ais_firm_registriation_no,personal_account_status_id,personal_account_period_id,personal_account_creation_date,personal_account_number,personal_account_bank_name,has_credit_card_id,property_total_value,burdened_mortgage_id,burdened_mortgage_amount,financial_assets_total_value,life_insurance_count,life_insurance_total_value,qs_processing_allowed_date,qs_marketing_processing_allowed_date,qs_cooperate_processing_allowed_id,qs_cooperate_processing_allowed_date,insurance_processing_allowed_id,insurance_processing_allowed_date,external_verification_processing_allowed_id,external
_verification_processing_allowed_date,statistic_processing_allowed_id,statistic_processing_allowed_date,non_personal_details_processing_allowed_id,non_personal_details_processing_allowed_date,electronic_advertising_allowed_id,electronic_advertising_allowed_date,field_of_knowledge,resolution_property_id,current_overtime_gross_income_amount,current_bonus_gross_income_amount,current_extras_gross_income_amount,current_commission_gross_income_amount,current_other_gross_income_amount,
person_id , tmstp_from,tmstp_to ) VALUES ( DEFAULT , $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 ,
$221, $222 ) RETURNING id AS id
HIDDEN VALUES
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: UPDATE b.person SET last_person_hist_id = $1,
history_generate_id = 0 WHERE id = $2
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:
parameters: $1 = '1374224', $2 = '658041'
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute
<unnamed>: SET CONSTRAINTS b.last_person_hist_id_fkey IMMEDIATE
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] ERROR: could not
open relation with OID 10027008
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] STATEMENT: SET
CONSTRAINTS b.last_person_hist_id_fkey IMMEDIATE
[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: execute S_2:
ROLLBACK
I can repeat this behavior on all my test and production servers. If I
run this last transaction block separately everything works fine.
What could be wrong? Some bad adjustments? On the 8.3 works well...
ps. sorry for html but IMHO looks better.
--
Andrzej Zawadzki