Advertisement
Guest User

Untitled

a guest
May 22nd, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 210: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: select t.oid,
  2.   235: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: select t.oid, t.typname
  3.   244: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: select t.oid, t.typname, t.typbasetype
  4.   251: APP:[unknown] PID:43 TR:0 LOG:  statement: begin
  5.   258: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
  6.   259: APP:[unknown] PID:43 TR:0 DETAIL:  parameters: $1 = 'НОВОСИБИРСКАЯ', $2 = 'ОБЛАСТЬ'
  7.   264: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: insert into region_type (type_region, label_region, label_region_translate) values (UPPER($1), UPPER($2), $3) on conflict do nothing
  8.   265: APP:[unknown] PID:43 TR:0 DETAIL:  parameters: $1 = 'ОБЛАСТЬ', $2 = 'НОВОСИБИРСКАЯ', $3 = 'novosibirskaya'
  9.  1685: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
  10.  1686: APP:[unknown] PID:43 TR:0 DETAIL:  parameters: $1 = 'НОВОСИБИРСКАЯ', $2 = 'ОБЛАСТЬ'
  11.  1735: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  12.  1736: APP:[unknown] PID:43 TR:0 DETAIL:  parameters: $1 = '1115476088034'
  13.  1739: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  14.  1740: APP:[unknown] PID:43 TR:0 DETAIL:  parameters: $1 = '1115476088034', $2 = '2011-07-29'
  15.  1749: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  16.  1750: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  17.  1755: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from city_type where labe_city = UPPER($1) and type_city = UPPER($2)
  18.  1756: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'НОВОСИБИРСК', $2 = 'ГОРОД'
  19.  1771: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
  20.  1772: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'УЛИЦА', $2 = 'ГЕОДЕЗИЧЕСКАЯ'
  21.  1789: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into street_type (type_street, label_street) VALUES (UPPER($1), UPPER($2)) on conflict do nothing
  22.  1790: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'УЛИЦА', $2 = 'ГЕОДЕЗИЧЕСКАЯ'
  23.  1816: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
  24.  1817: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'УЛИЦА', $2 = 'ГЕОДЕЗИЧЕСКАЯ'
  25.  1850: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "addr_RF" (region_type_id, area_type_id, city_type_id, locality_type_id, street_type_id, "code_region") values ($1, $2, $3, $4, $5, $6) returning id
  26.  1851: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1', $2 = NULL, $3 = '1', $4 = NULL, $5 = '4', $6 = '54'
  27.  1950: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "addr_RF_USR_LE_type" ("Index", code_region, code_addr_cldr, house, housing, apartment, "addr_RF", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  28.  1951: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '630087', $2 = '54', $3 = '540000010000276', $4 = '23', $5 = NULL, $6 = '1', $7 = '3', $8 = '51', $9 = NULL
  29.  2030: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_addr_LE" ("addr_RF", "inf_des_chng_place") VALUES ($1, $2) returning id
  30.  2031: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '3', $2 = NULL
  31.  2102: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_TA" where "code_NO" = $1
  32.  2103: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5404'
  33.  2133: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  34.  2134: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '6185476515581'
  35.  2143: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  36.  2144: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '6185476515581', $2 = '2018-09-12'
  37.  2165: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  38.  2166: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '6185476515581'
  39.  2195: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_recording_TA" ("INTP_INTP_P", "CRS", date_reg, "inf_TA", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5, $6) returning id
  40.  2196: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5404442236', $2 = '540401001', $3 = '2011-07-29', $4 = '1', $5 = '62', $6 = NULL
  41.  2268: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_org_PF" where "code_PF" = $1
  42.  2269: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '64006'
  43.  2284: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  44.  2285: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '2115476949069'
  45.  2304: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  46.  2305: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '2115476949069', $2 = '2011-08-10'
  47.  2338: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  48.  2339: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '2115476949069'
  49.  2356: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_reg_PF" ("reg_num_PF", date_reg, "inf_org_PF", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5) returning id
  50.  2357: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '064006099542', $2 = '2011-08-02', $3 = '1', $4 = '72', $5 = NULL
  51.  2404: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  52.  2405: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  53.  2420: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_share_cap (label_kind_cap, sum_cap, share_ruble, inf_less_share_cap, "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5, $6) returning id
  54.  2421: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'УСТАВНЫЙ КАПИТАЛ', $2 = '10000', $3 = NULL, $4 = NULL, $5 = '51', $6 = NULL
  55.  2464: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  56.  2465: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  57.  2476: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_label_LE" ("label_LE_full", "label_LE_short", "SRN_date_corr", "SRN_date") VALUES ($1, $2, $3,$4) returning id
  58.  2477: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ ЮРИДИЧЕСКАЯ КОМПАНИЯ "АРАНТА"', $2 = 'ООО ЮК "АРАНТА"', $3 = NULL, $4 = '51'
  59.  2530: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "way_create_LE" where "code_way_create_LE" = $1
  60.  2531: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '11'
  61.  2542: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  62.  2543: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  63.  2569: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_create_LE" ("main_SRN", "date_main_SRN", "reg_num", "date_reg", "label_reg_auth", "way_create_LE", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) returning id
  64.  2570: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034', $2 = '2011-07-29', $3 = NULL, $4 = NULL, $5 = NULL, $6 = '1', $7 = '51', $8 = NULL
  65.  2599: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_org_SIF" where "code_SIF" = $1
  66.  2600: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5409'
  67.  2613: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  68.  2614: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '2115476938620'
  69.  2619: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  70.  2620: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '2115476938620', $2 = '2011-08-08'
  71.  2631: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  72.  2632: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '2115476938620'
  73.  2639: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_reg_SIF" ("reg_num_SIF", date_reg, "inf_org_SIF", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5) returning id
  74.  2640: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '540904061754091', $2 = '2011-08-02', $3 = '1', $4 = '92', $5 = NULL
  75.  2682: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  76.  2683: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  77.  2700: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_reg_org ("SRN_date", "code_NO", "label_NO", addr_reg_org) VALUES ($1, $2, $3, $4) returning id
  78.  2701: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '51', $2 = '5476', $3 = 'Межрайонная инспекция Федеральной налоговой службы № 16 по Новосибирской области', $4 = 'площадь Труда, 1, г. Новосибирск, 630108'
  79.  2730: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "way_stop_LE" where "code_way_stop_LE" = $1
  80.  2731: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '407'
  81.  2738: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  82.  2739: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  83.  2750: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  84.  2751: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '6185476514360'
  85.  2768: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  86.  2769: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '6185476514360', $2 = '2018-09-12'
  87.  2778: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  88.  2779: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '6185476514360'
  89.  2796: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_stop_LE" ("date_term_UL", inf_reg_org, "way_stop_LE", "SRN_date") values ($1, $2, $3, $4) returning id
  90.  2797: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '2018-09-12', $2 = '2', $3 = '1', $4 = '99'
  91.  2896: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_LE" ("time", date_stat, "main_SRN", "date_main_SRN", "INTP", "CRS", "inf_OLF", "code_OLF", "full_label_OLF", "inf_label_LE", "inf_addr_LE", "inf_create_LE", inf_reg_org, inf_email, "inf_stop_LE", "inf_recording_TA", "inf_reg_SIF", "inf_reg_PF", inf_share_cap, inf_type_order,"share_cap_USR_LE", "inf_register_holder_JSC")
  92.  2899: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1558531068', $2 = '2018-09-12', $3 = '1115476088034', $4 = '2011-07-29', $5 = '5404442236', $6 = '540401001', $7 = 'ОКОПФ', $8 = '12300', $9 = 'Общества с ограниченной ответственностью', $10 = '16', $11 = '3', $12 = '18', $13 = '14', $14 = NULL, $15 = '4', $16 = '5', $17 = '11', $18 = '12', $19 = '14', $20 = NULL, $21 = NULL, $22 = NULL
  93.  3034: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from filenames where name = $1
  94.  3035: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'test.XML'
  95.  3062: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into infle_filenames (filename_id, "inf_LE_id") values ($1, $2) on conflict do nothing
  96.  3063: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1', $2 = '13'
  97.  3152: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_pos_P" set active = $1 where "inf_LE" = $2
  98.  3153: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = '13'
  99.  3176: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  100.  3177: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  101.  3212: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_P_USR_LE_type" where last_name = UPPER($1) and fisrt_name = UPPER($2) and patronymic = UPPER($3) and "INTP_P" = $4
  102.  3213: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'ВИШНЕВСКАЯ', $2 = 'ВИКТОРИЯ', $3 = 'ВАЛЕРЬЕВНА', $4 = '753005539096'
  103.  3220: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_P_USR_LE_type" ("SRN_date", "SRN_date_corr", last_name, fisrt_name, patronymic, "INTP_P") values ($1, $2, UPPER($3), UPPER($4), UPPER($5), $6) on conflict do nothing
  104.  3221: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '51', $2 = NULL, $3 = 'ВИШНЕВСКАЯ', $4 = 'ВИКТОРИЯ', $5 = 'ВАЛЕРЬЕВНА', $6 = '753005539096'
  105.  3242: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_P_USR_LE_type" where last_name = UPPER($1) and fisrt_name = UPPER($2) and patronymic = UPPER($3) and "INTP_P" = $4
  106.  3243: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'ВИШНЕВСКАЯ', $2 = 'ВИКТОРИЯ', $3 = 'ВАЛЕРЬЕВНА', $4 = '753005539096'
  107.  3254: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  108.  3255: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  109.  3278: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_pos ("SRN_date", "SRN_date_corr", "main_SRN_IndE", kind_pos, label_kind_pos, label_pos) values ($1, $2, $3, $4, $5, $6) returning id
  110.  3279: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '51', $2 = NULL, $3 = NULL, $4 = '02', $5 = 'Руководитель юридического лица', $6 = 'Директор'
  111.  3298: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  112.  3299: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  113.  3308: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: delete from "inf_pos_P" where "inf_LE" = $1 and "inf_P" = $2
  114.  3309: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13', $2 = '11'
  115.  3322: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_pos_P" ("SRN_date_first", "inf_P", "inf_LE", inf_pos, inf_phone_num, upload_date,  active) values ($1, $2, $3, $4, $5, $6, $7) returning id
  116.  3323: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '51', $2 = '11', $3 = '13', $4 = '12', $5 = NULL, $6 = '2018-09-12', $7 = 't'
  117.  3328: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_pos_P" set "ext_inf_inval_pos_P" = $1, ext_inf_disq = $2 where id = $3
  118.  3329: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = 'f', $3 = '11'
  119.  3344: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update inf_founder set active = $1 where "inf_LE" = $2
  120.  3345: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = '13'
  121.  3372: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_founder ("inf_LE", upload_date, active) values ($1, $2, $3) returning id
  122.  3373: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13', $2 = '2018-09-12', $3 = 't'
  123.  3406: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  124.  3407: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  125.  3428: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into share_size (percent, fractional_decimal, fractional_simple) values ($1, $2, $3) returning id
  126.  3429: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '100', $2 = NULL, $3 = NULL
  127.  3456: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "share_cap_USR_LE_type" (share_size, "SRN_date", "SRN_date_corr", nomin_value) values ($1, $2, $3, $4) returning id
  128.  3457: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '11', $2 = '51', $3 = NULL, $4 = '10000'
  129.  3488: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  130.  3489: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  131.  3496: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  132.  3497: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  133.  3506: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_P_USR_LE_type" where last_name = UPPER($1) and fisrt_name = UPPER($2) and patronymic = UPPER($3) and "INTP_P" = $4
  134.  3507: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'ВИШНЕВСКАЯ', $2 = 'ВИКТОРИЯ', $3 = 'ВАЛЕРЬЕВНА', $4 = '753005539096'
  135.  3566: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_founder iff where "inf_LE" = $1 and exists(select 1 from "founder_P" where iff.id = "founder_P".inf_founder and "inf_P" = $2)
  136.  3567: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13', $2 = '11'
  137.  3580: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: delete from "founder_P" where inf_founder = $1
  138.  3581: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = NULL
  139.  3586: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: delete from inf_founder where id = $1
  140.  3587: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = NULL
  141.  3596: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "founder_P" (inf_founder, "inf_P", "inf_trust_mng_LE", "inf_trust_mng_P", pers_charge_inherit) values ($1, $2, $3, $4, $5)
  142.  3597: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '11', $2 = '11', $3 = NULL, $4 = NULL, $5 = NULL
  143.  3604: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update inf_founder set "ext_inf_founder_P" = $1, "SRN_date_first" = $2, share_cap = $3, ext_inf_insf_data_found = $4, ext_inf_burd = $5 where id = $6
  144.  3605: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 't', $2 = '51', $3 = '11', $4 = 'f', $5 = 'f', $6 = '11'
  145.  3624: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select "inf_GCEA" from "inf_LE" where id = $1
  146.  3625: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13'
  147.  3634: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_GCEA" (active) values ($1) returning id
  148.  3635: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 't'
  149.  3644: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
  150.  3645: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '69', $2 = '2014'
  151.  3654: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  152.  3655: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  153.  3662: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_GCEA_type" ("code_GCEA", "label_GCEA", "char_ver_GCEA") values ($1, $2, $3) on conflict do nothing
  154.  3663: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '69', $2 = 'Деятельность в области права и бухгалтерского учета', $3 = '2014'
  155.  3670: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
  156.  3671: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '69', $2 = '2014'
  157.  3680: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_GCEA" set "inf_GCEA_main" = $1, "SRN_date" = $2, "SRN_date_corr" = $3 where id = $4
  158.  3681: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '45', $2 = '51', $3 = NULL, $4 = '9'
  159.  3686: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
  160.  3687: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '70.22', $2 = '2014'
  161.  3698: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  162.  3699: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '1115476088034'
  163.  3704: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_GCEA_type" ("code_GCEA", "label_GCEA", "char_ver_GCEA") values ($1, $2, $3) on conflict do nothing
  164.  3705: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '70.22', $2 = 'Консультирование по вопросам коммерческой деятельности и управления', $3 = '2014'
  165.  3708: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
  166.  3709: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '70.22', $2 = '2014'
  167.  3712: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_GCEA_add" ("inf_GCEA", "inf_GCEA_add", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4)
  168.  3713: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '9', $2 = '48', $3 = '51', $4 = NULL
  169.  3726: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_GCEA" set "ext_inf_GCEA_add" = true where id = $1
  170.  3727: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '9'
  171.  3744: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  172.  3745: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '11201'
  173.  3756: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  174.  3757: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  175.  3766: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  176.  3767: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '115476703000977', $2 = '1115476088034', $3 = '2011-07-29', $4 = '3', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
  177.  3792: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_certs ("SRN_date_cert_no_active", series_cert, number_cert, date_cert, "inf_record_USR") values ($1, $2, $3, $4, $5)
  178.  3793: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = NULL, $2 = '54', $3 = '004334200', $4 = '2011-07-29', $5 = '15'
  179.  3812: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  180.  3813: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Р11001 Заявление о создании ЮЛ', $2 = NULL, $3 = '2011-07-22', $4 = '15'
  181.  3832: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  182.  3833: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Устав ЮЛ (два)', $2 = NULL, $3 = '2011-07-18', $4 = '15'
  183.  3846: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  184.  3847: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Решение о создании ЮЛ', $2 = '1', $3 = '2011-07-18', $4 = '15'
  185.  3868: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  186.  3869: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Акт', $2 = NULL, $3 = NULL, $4 = '15'
  187.  3880: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  188.  3881: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Заявление', $2 = NULL, $3 = NULL, $4 = '15'
  189.  3900: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  190.  3901: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Документ об оплате государственной пошлины', $2 = '0087', $3 = '2011-07-22', $4 = '15'
  191.  3924: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  192.  3925: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Платежный документ за предоставление содержащихся в государственном реестре сведений', $2 = '0089', $3 = '2011-07-22', $4 = '15'
  193.  3940: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
  194.  3941: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 't', $2 = 't', $3 = '15'
  195.  3976: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  196.  3977: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  197.  3996: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  198.  3997: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13200'
  199.  4010: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  200.  4011: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '115476710000571', $2 = '2115476897270', $3 = '2011-07-29', $4 = '5', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
  201.  4050: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
  202.  4051: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = 'f', $3 = '20'
  203.  4084: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  204.  4085: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13400'
  205.  4102: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  206.  4103: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  207.  4110: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  208.  4111: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '115476720001358', $2 = '2115476938620', $3 = '2011-08-08', $4 = '8', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
  209.  4142: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
  210.  4143: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = 'f', $3 = '23'
  211.  4172: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  212.  4173: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13300'
  213.  4186: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  214.  4187: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  215.  4204: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  216.  4205: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '115476722001607', $2 = '2115476949069', $3 = '2011-08-10', $4 = '6', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
  217.  4236: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
  218.  4237: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = 'f', $3 = '27'
  219.  4276: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  220.  4277: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '14109'
  221.  4292: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into kind_record_type (code_kind_record, label_kind_record) VALUES ($1, $2) on conflict do nothing
  222.  4293: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '14109', $2 = 'Принятие регистрирующим органом решения о предстоящем исключении юридического лица из ЕГРЮЛ (недействующее юридическое лицо)'
  223.  4314: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  224.  4315: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '14109'
  225.  4332: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  226.  4333: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  227.  4342: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  228.  4343: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '150000155951973', $2 = '2185476922596', $3 = '2018-05-23', $4 = '14', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
  229.  4352: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  230.  4353: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Решение о предстоящем исключении недействуюшего ЮЛ из ЕГРЮЛ', $2 = '3912', $3 = '2018-05-21', $4 = '30'
  231.  4368: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
  232.  4369: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 't', $2 = 'f', $3 = '30'
  233.  4392: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  234.  4393: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  235.  4400: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  236.  4401: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '14404'
  237.  4416: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  238.  4417: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '150000162174604', $2 = '6185476514360', $3 = '2018-09-12', $4 = '2', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
  239.  4432: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  240.  4433: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Решение о предстоящем исключении недействуюшего ЮЛ из ЕГРЮЛ', $2 = '3912', $3 = '2018-05-21', $4 = '32'
  241.  4436: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  242.  4437: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Справка об отсутствии движения средств по счетам или отсутствии открытых счетов', $2 = '39038-С', $3 = '2018-05-15', $4 = '32'
  243.  4444: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
  244.  4445: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'Справка о непредставлении ЮЛ в течение последних 12 месяцев документов отчетности', $2 = '39038-О', $3 = '2018-05-15', $4 = '32'
  245.  4454: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
  246.  4455: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 't', $2 = 'f', $3 = '32'
  247.  4464: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from kind_record_type where code_kind_record = $1
  248.  4465: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '13200'
  249.  4474: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
  250.  4475: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '5476'
  251.  4478: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  252.  4479: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = '150000162175790', $2 = '6185476515581', $3 = '2018-09-12', $4 = '5', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
  253.  4494: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
  254.  4495: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = 'f', $3 = '36'
  255.  4504: APP:[unknown] PID:43 TR:408852 LOG:  execute <unnamed>: update "inf_LE" set inf_peasant_farm_next = $1, ext_inf_mng_org = $2, ext_inf_status = $3, "ext_inf_pos_P" = $5, ext_inf_founder = $6, ext_inf_license = $7, "inf_GCEA" = $8, ext_inf_subdivision = $9, ext_inf_reorg = $10, ext_inf_prev = $11, inf_peasant_farm_prev = $12, ext_inf_next = $13 where id = $4
  256.  4505: APP:[unknown] PID:43 TR:408852 DETAIL:  parameters: $1 = 'f', $2 = 'f', $3 = 'f', $4 = '13', $5 = 't', $6 = 't', $7 = 'f', $8 = '9', $9 = 'f', $10 = 'f', $11 = 'f', $12 = 'f', $13 = 'f'
  257.  4540: APP:[unknown] PID:43 TR:408852 LOG:  statement: commit
  258.  4565: APP:[unknown] PID:43 TR:0 LOG:  statement: begin
  259.  4584: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: select id from "inf_org_PF" where "code_PF" = $1
  260.  4585: APP:[unknown] PID:43 TR:0 DETAIL:  parameters: $1 = '75030'
  261.  4594: APP:[unknown] PID:43 TR:0 LOG:  execute <unnamed>: insert into "inf_org_PF" ("code_PF", "label_PF") values ($1, $2) on conflict do nothing
  262.  4595: APP:[unknown] PID:43 TR:0 DETAIL:  parameters: $1 = '75030', $2 = 'Управление Пенсионного фонда Российской Федерации по Кировскому району г.Екатеринбурга'
  263.  4611: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "inf_org_PF" where "code_PF" = $1
  264.  4612: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '75030'
  265.  4674: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  266.  4675: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '2116670249991'
  267.  4694: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  268.  4695: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '2116670249991', $2 = '2011-08-01'
  269.  4714: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  270.  4715: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '2116670249991'
  271.  4722: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "inf_reg_PF" ("reg_num_PF", date_reg, "inf_org_PF", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5) returning id
  272.  4723: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '075030114960', $2 = '2011-07-27', $3 = '16', $4 = '119', $5 = NULL
  273.  4742: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  274.  4743: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '1116670019465'
  275.  4756: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  276.  4757: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '1116670019465', $2 = '2011-07-25'
  277.  4774: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  278.  4775: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '1116670019465'
  279.  4782: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into inf_share_cap (label_kind_cap, sum_cap, share_ruble, inf_less_share_cap, "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5, $6) returning id
  280.  4783: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'УСТАВНЫЙ КАПИТАЛ', $2 = '10000', $3 = NULL, $4 = NULL, $5 = '120', $6 = NULL
  281.  4802: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  282.  4803: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '1116670019465'
  283.  4820: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "inf_label_LE" ("label_LE_full", "label_LE_short", "SRN_date_corr", "SRN_date") VALUES ($1, $2, $3,$4) returning id
  284.  4821: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ "ТЕХНОЛОГИИ СТЕКЛА"', $2 = 'ООО "ТЕХНОЛОГИИ СТЕКЛА"', $3 = NULL, $4 = '120'
  285.  4842: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "way_create_LE" where "code_way_create_LE" = $1
  286.  4843: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '11'
  287.  4852: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  288.  4853: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '1116670019465'
  289.  4864: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "inf_create_LE" ("main_SRN", "date_main_SRN", "reg_num", "date_reg", "label_reg_auth", "way_create_LE", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) returning id
  290.  4865: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '1116670019465', $2 = '2011-07-25', $3 = NULL, $4 = NULL, $5 = NULL, $6 = '1', $7 = '120', $8 = NULL
  291.  4886: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
  292.  4887: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'УЛИЦА', $2 = '40-ЛЕТИЯ КОМСОМОЛА'
  293.  4906: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into street_type (type_street, label_street) VALUES (UPPER($1), UPPER($2)) on conflict do nothing
  294.  4907: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'УЛИЦА', $2 = '40-ЛЕТИЯ КОМСОМОЛА'
  295.  4916: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
  296.  4917: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'УЛИЦА', $2 = '40-ЛЕТИЯ КОМСОМОЛА'
  297.  4930: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
  298.  4931: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'СВЕРДЛОВСКАЯ', $2 = 'ОБЛАСТЬ'
  299.  4960: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into region_type (type_region, label_region, label_region_translate) values (UPPER($1), UPPER($2), $3) on conflict do nothing
  300.  4961: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'ОБЛАСТЬ', $2 = 'СВЕРДЛОВСКАЯ', $3 = 'sverdlovskaya'
  301.  9792: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
  302.  9793: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'СВЕРДЛОВСКАЯ', $2 = 'ОБЛАСТЬ'
  303.  9824: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  304.  9825: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '1116670019465'
  305.  9854: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from city_type where labe_city = UPPER($1) and type_city = UPPER($2)
  306.  9855: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = 'ЕКАТЕРИНБУРГ', $2 = 'ГОРОД'
  307.  9870: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "addr_RF" (region_type_id, area_type_id, city_type_id, locality_type_id, street_type_id, "code_region") values ($1, $2, $3, $4, $5, $6) returning id
  308.  9871: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '11', $2 = NULL, $3 = '4', $4 = NULL, $5 = '19', $6 = '66'
  309.  9914: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "addr_RF_USR_LE_type" ("Index", code_region, code_addr_cldr, house, housing, apartment, "addr_RF", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
  310.  9915: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '620072', $2 = '66', $3 = '660000010000010', $4 = '38', $5 = 'ЛИТЕР Д', $6 = NULL, $7 = '28', $8 = '120', $9 = NULL
  311.  9949: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "inf_addr_LE" ("addr_RF", "inf_des_chng_place") VALUES ($1, $2) returning id
  312.  9950: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '28', $2 = NULL
  313.  9997: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  314.  9998: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '2156670570440'
  315.  10033: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
  316.  10034: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '2156670570440', $2 = '2015-03-29'
  317.  10073: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
  318.  10074: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '2156670570440'
  319.  10101: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into inf_reg_org ("SRN_date", "code_NO", "label_NO", addr_reg_org) VALUES ($1, $2, $3, $4) returning id
  320.  10102: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '210', $2 = '6658', $3 = 'Инспекция Федеральной налоговой службы по Верх-Исетскому району г.Екатеринбурга', $4 = ',620014,,,Екатеринбург г,,Хомякова ул,4,,'
  321.  10138: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: select id from "inf_TA" where "code_NO" = $1
  322.  10139: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '6670'
  323.  10156: APP:[unknown] PID:43 TR:408855 LOG:  execute <unnamed>: insert into "inf_TA" ("code_NO", "label_NO") values ($1, $2) on conflict do nothing
  324.  10157: APP:[unknown] PID:43 TR:408855 DETAIL:  parameters: $1 = '6670', $2 = 'Инспекция Федеральной налоговой службы по Кировскому району г.Екатеринбурга'
  325.  13319: APP:[unknown] PID:43 TR:408855 ERROR:  deadlock detected
  326.  13320: APP:[unknown] PID:43 TR:408855 DETAIL:  Process 43 waits for ShareLock on transaction 408854; blocked by process 58.
  327.  13324: APP:[unknown] PID:43 TR:408855 HINT:  See server log for query details.
  328.  13325: APP:[unknown] PID:43 TR:408855 CONTEXT:  while inserting index tuple (0,32) in relation "inf_TA"
  329.  13326: APP:[unknown] PID:43 TR:408855 STATEMENT:  insert into "inf_TA" ("code_NO", "label_NO") values ($1, $2) on conflict do nothing
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement