2009-04-14 11 35 48 712 INFO dbconnect connecting to postgres dba XXXX

 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
2009-04-14 11:35:48,712:INFO:dbconnect:connecting to postgres://dba:XXXXXX@db.local.asko-zabota.ru/oms_sk
2009-04-14 11:35:48,714:INFO:dbconnect:connecting to postgres://dba:XXXXXX@db.local.asko-zabota.ru/oms_sk
2009-04-14 11:35:48,721:INFO:polis_query:Make full unload (for polises newer than 2007-03-14)
2009-04-14 11:37:17,894:INFO:kladr:Code 0000000000000 missed in cache (1939 length)
2009-04-14 11:37:17,925:WARNING:root:Running callbacks for record 41 failed ({u'beg_date': datetime.date(2007, 9, 21), u'status_cod': 193, u'agr_num': u'\u041e\u041a0177', u'house': u'9', u'p_ser': 3003, u'rg_cod': 79, u'sex': u'\u041c', u'ds_name': u'\u0410\u041e \u0413. \u041e\u041c\u0421\u041a\u0410', u'st_kladr_code': None, u'street': u'\u0427\u0415\u041b\u042f\u0411\u0418\u041d\u0421\u041a\u0410\u042f', u'u_date': datetime.date(2009, 4, 3), u'lname': u'\u0412\u041b\u0410\u0414\u0418\u041c\u0418\u0420\u041e\u0412\u0418\u0427 ', u'str_name': u"\u041e\u041a \u041e\u041e\u041e \u041d\u041f\u041e '\u041c\u041e\u0421\u0422\u041e\u0412\u0418\u041a'", u'rp_cod': 35, u'street_code': 4286, u'rg_kladr_code': '5500000000000', u'flat': u'3', u'agr_id': 1546, u'pasp_num': 405932, u'pop_area': u'\u041c\u041a\u0420.\u0412\u0425\u041e\u0414\u041d\u041e\u0419', u'fname': u'\u0410\u041b\u0415\u041a\u0421\u0415\u0419 ', u'real_beg_date': None, u'rmv_i_date': datetime.date(2009, 4, 3), u'pasp_nser': 52, u'social_cod': 158, u'pens_num': u'10485003318', u'ds_kladr_code': None, u'sname': u'\u0422\u0418\u041c\u041e\u0424\u0415\u0415\u0412 ', u'building': None, u'end_date': datetime.date(2009, 4, 3), u'bday': datetime.date(1981, 5, 14), u'pp_kladr_code': None, u'pasp_doc': 197, u'p_num': 698670, u'pop_area_code': 8226, u'ds_cod': 115, u'pol_id': 4117207, u'pasp_ser': u'03', u'tmp_date': datetime.date(2009, 11, 27), u'status_name': u'=\u0418\u0421\u041a\u041b\u042e\u0427\u0415\u041d \u041e\u041f\u0415\u0420\u0410\u0422\u041e\u0420\u041e\u041c', u'fio_id': 28619, u'addr_id': 823515, u'agr_end_date': datetime.date(2200, 1, 1), u'agr_beg_date': datetime.date(1995, 11, 27)}): "Missing key '0000000000000'"
2009-04-14 11:37:18,368:INFO:kladr:Reverse kladr - cache filled (1130 records)
2009-04-14 11:37:33,739:INFO:kladr:Code 5400000000000 missed in cache (1940 length)
2009-04-14 11:37:45,620:INFO:kladr:Code 7200000000000 missed in cache (1941 length)
2009-04-14 11:37:45,982:INFO:kladr:Code 4200000000000 missed in cache (1942 length)
2009-04-14 11:37:56,377:INFO:kladr:Code 5000000000000 missed in cache (1943 length)
2009-04-14 11:37:58,278:INFO:kladr:Code 4700000000000 missed in cache (1944 length)
2009-04-14 11:38:19,277:INFO:kladr:Code 7700000000000 missed in cache (1945 length)
2009-04-14 11:38:19,550:INFO:kladr:Code 2400000000000 missed in cache (1946 length)
2009-04-14 11:39:32,703:INFO:kladr:Code 8900000000000 missed in cache (1947 length)
2009-04-14 11:39:32,809:INFO:kladr:Code 1600000000000 missed in cache (1948 length)
2009-04-14 11:39:40,294:INFO:kladr:Code 3800000000000 missed in cache (1949 length)
2009-04-14 11:39:50,950:INFO:kladr:Code 5502100001200 missed in cache (1950 length)
2009-04-14 11:39:50,959:WARNING:root:Running callbacks for record 4260 failed ({u'beg_date': datetime.date(2009, 4, 10), u'status_cod': 512, u'agr_num': u'\u0426\u041d11424', u'house': u'37', u'p_ser': 3006, u'rg_cod': 79, u'sex': u'\u0416', u'ds_name': u'\u0410\u041e \u0413. \u041e\u041c\u0421\u041a\u0410', u'st_kladr_code': None, u'street': u'\u041d\u0415\u0422', u'u_date': datetime.date(2009, 4, 10), u'lname': u'\u0421\u0415\u0420\u0413\u0415\u0415\u0412\u041d\u0410 ', u'str_name': u"\u0426\u041d \u0423\u0424\u041f\u0421 \u041e\u041c\u0421\u041a\u041e\u0419 \u041e\u0411\u041b\u0410\u0421\u0422\u0418 \u0424\u0418\u041b\u0418\u0410\u041b \u0424\u0413\u0423\u041f '\u041f\u041e\u0427\u0422\u0410 \u0420\u041e\u0421\u0421\u0418\u0418'", u'rp_cod': 35, u'street_code': 1, u'rg_kladr_code': '5500000000000', u'flat': u'3', u'agr_id': 25617, u'pasp_num': 125338, u'pop_area': u'\u0411\u0423\u041b\u0410\u0422\u041e\u0412\u041e', u'fname': u'\u0412\u0415\u0420\u041e\u041d\u0418\u041a\u0410 ', u'real_beg_date': None, u'rmv_i_date': None, u'pasp_nser': 52, u'social_cod': 158, u'pens_num': u'13718618676', u'ds_kladr_code': None, u'sname': u'\u0422\u0415\u041b\u0418\u0427\u041a\u041e ', u'building': None, u'end_date': datetime.date(2011, 3, 23), u'bday': datetime.date(1990, 9, 14), u'pp_kladr_code': '5502100001251', u'pasp_doc': 197, u'p_num': 609192, u'pop_area_code': 4346, u'ds_cod': 115, u'pol_id': 5097489, u'pasp_ser': u'05', u'tmp_date': datetime.date(2011, 3, 23), u'status_name': u'\u0412\u0420\u0415\u041c\u0415\u041d\u041d\u042b\u0419', u'fio_id': 758898, u'addr_id': 1627166, u'agr_end_date': datetime.date(2011, 3, 23), u'agr_beg_date': datetime.date(2006, 3, 23)}): "Missing key '5502100001200'"
2009-04-14 11:39:59,767:INFO:kladr:Code 6600000000000 missed in cache (1951 length)
2009-04-14 11:40:27,808:INFO:kladr:Code 5502100005700 missed in cache (1952 length)
2009-04-14 11:40:27,819:WARNING:root:Running callbacks for record 6404 failed ({u'beg_date': datetime.date(2000, 3, 1), u'status_cod': 1794, u'agr_num': u'\u041e\u041a0080', u'house': u'14', u'p_ser': 2000, u'rg_cod': 79, u'sex': u'\u041c', u'ds_name': u'\u041e\u041c\u0421\u041a\u0418\u0419', u'st_kladr_code': None, u'street': u'\u041e\u041a\u0422\u042f\u0411\u0420\u042c\u0421\u041a\u0410\u042f', u'u_date': datetime.date(2007, 4, 20), u'lname': u'\u041c\u0418\u0425\u0410\u0419\u041b\u041e\u0412\u0418\u0427 ', u'str_name': u'\u041e\u041a \u041c\u041f \u0416\u041a\u0425 \u041e\u041c\u0421\u041a\u041e\u0413\u041e \u0420-\u041d\u0410', u'rp_cod': 35, u'street_code': 94, u'rg_kladr_code': '5500000000000', u'flat': u'4', u'agr_id': 1151, u'pasp_num': 596969, u'pop_area': u'\u041e\u0421\u0422\u0410\u0428\u041a\u041e\u0412\u041e', u'fname': u'\u0412\u041b\u0410\u0414\u0418\u041c\u0418\u0420 ', u'real_beg_date': None, u'rmv_i_date': datetime.date(2007, 4, 20), u'pasp_nser': 3, u'social_cod': 158, u'pens_num': u'10771577160', u'ds_kladr_code': '5502100000000', u'sname': u'\u0411\u041e\u0420\u0418\u0421\u041e\u0412 ', u'building': None, u'end_date': datetime.date(2007, 4, 20), u'bday': datetime.date(1958, 1, 23), u'pp_kladr_code': '5502100005751', u'pasp_doc': 425, u'p_num': 211212, u'pop_area_code': 5353, u'ds_cod': 135, u'pol_id': 1598979, u'pasp_ser': u'\u041a\u041d', u'tmp_date': datetime.date(2009, 12, 26), u'status_name': u'=\u041f\u0420\u0415\u041a\u0420.\u0421\u0422\u0420.\u041b\u0418\u041a\u0412\u0418\u0414\u0410\u0426\u0418\u042f', u'fio_id': 1320642, u'addr_id': 337891, u'agr_end_date': datetime.date(2007, 4, 20), u'agr_beg_date': datetime.date(1995, 12, 26)}): "Missing key '5502100005700'"
2009-04-14 11:40:33,553:WARNING:root:Wrong snils 06571089966 for polis 3001 962978
2009-04-14 11:40:46,539:INFO:kladr:Code 5502100004900 missed in cache (1953 length)
2009-04-14 11:40:46,543:WARNING:root:Running callbacks for record 7551 failed ({u'beg_date': datetime.date(2008, 4, 8), u'status_cod': 512, u'agr_num': u'\u0421\u04120169-44', u'house': u'243', u'p_ser': 3006, u'rg_cod': 79, u'sex': u'\u041c', u'ds_name': u'\u041e\u041c\u0421\u041a\u0418\u0419', u'st_kladr_code': None, u'street': u'\u041d\u0415\u0422', u'u_date': datetime.date(2008, 4, 8), u'lname': u'\u042e\u0420\u042c\u0415\u0412\u0418\u0427 ', u'str_name': u"\u0421\u0412 \u041e\u0410\u041e '\u041e\u041c\u0421\u041a\u0418\u0419 \u0417\u0410\u0412\u041e\u0414 \u041c\u0415\u0422\u0410\u041b\u041b\u041e\u041a\u041e\u041d\u0421\u0422\u0420\u0423\u041a\u0426\u0418\u0419'", u'rp_cod': 35, u'street_code': 1, u'rg_kladr_code': '5500000000000', u'flat': None, u'agr_id': 2908, u'pasp_num': 361348, u'pop_area': u'\u041d\u041e\u0412\u041e\u0410\u041b\u0415\u041a\u0421\u0410\u041d\u0414\u0420\u041e\u0412\u041a\u0410', u'fname': u'\u0421\u0415\u0420\u0413\u0415\u0419 ', u'real_beg_date': None, u'rmv_i_date': None, u'pasp_nser': 52, u'social_cod': 158, u'pens_num': u'06557290688', u'ds_kladr_code': '5502100000000', u'sname': u'\u0425\u0410\u041c\u0417\u0418\u041d ', u'building': None, u'end_date': datetime.date(2009, 10, 26), u'bday': datetime.date(1961, 8, 13), u'pp_kladr_code': '5502100004951', u'pasp_doc': 197, u'p_num': 16196, u'pop_area_code': 6486, u'ds_cod': 135, u'pol_id': 4430542, u'pasp_ser': u'06', u'tmp_date': datetime.date(2009, 10, 26), u'status_name': u'\u0412\u0420\u0415\u041c\u0415\u041d\u041d\u042b\u0419', u'fio_id': 1503191, u'addr_id': 999249, u'agr_end_date': datetime.date(2009, 10, 26), u'agr_beg_date': datetime.date(1995, 10, 26)}): "Missing key '5502100004900'"
2009-04-14 11:40:49,336:INFO:kladr:Code 2600000000000 missed in cache (1954 length)
2009-04-14 11:40:58,628:INFO:kladr:Code 7400000000000 missed in cache (1955 length)
2009-04-14 11:41:04,599:INFO:kladr:Code 7000000000000 missed in cache (1956 length)
2009-04-14 11:41:14,088:INFO:kladr:Code 2200000000000 missed in cache (1957 length)
2009-04-14 11:41:31,280:INFO:kladr:Code 3300000000000 missed in cache (1958 length)
2009-04-14 11:41:37,961:WARNING:root:Wrong snils 8610596171 for polis 3001 368932
2009-04-14 11:41:48,854:WARNING:root:Wrong snils 8610596171 for polis 3003 464602
2009-04-14 11:42:45,269:WARNING:root:Wrong snils 8436470783 for polis 3001 395026
2009-04-14 11:43:10,942:INFO:kladr:Code 200000000000 missed in cache (1959 length)
2009-04-14 11:43:10,954:WARNING:root:Running callbacks for record 16863 failed ({u'beg_date': datetime.date(2008, 9, 22), u'status_cod': 193, u'agr_num': u'\u0426\u041d0803-40', u'house': u'58', u'p_ser': 3006, u'rg_cod': 1723, u'sex': u'\u0416', u'ds_name': u'\u0418\u041d\u041e\u0413\u041e\u0420\u041e\u0414\u041d\u0418\u0419', u'st_kladr_code': None, u'street': u'\u0410\u0419\u0421\u041a\u0410\u042f', u'u_date': datetime.date(2009, 2, 14), u'lname': u'\u041d\u0418\u041a\u041e\u041b\u0410\u0415\u0412\u041d\u0410 ', u'str_name': u"\u0426\u041d \u041e\u041e\u041e '\u041e\u041c\u0421\u041a\u0412\u0418\u041d\u041f\u0420\u041e\u041c'", u'rp_cod': 35, u'street_code': 6285, u'rg_kladr_code': '200000000000', u'flat': u'26', u'agr_id': 2640, u'pasp_num': 274539, u'pop_area': u'\u0423\u0424\u0410', u'fname': u'\u0415\u041b\u0415\u041d\u0410 ', u'real_beg_date': None, u'rmv_i_date': datetime.date(2009, 2, 14), u'pasp_nser': 80, u'social_cod': 158, u'pens_num': u'05216957054', u'ds_kladr_code': None, u'sname': u'\u0413\u0415\u0417\u0410\u041b\u041e\u0412\u0410 ', u'building': None, u'end_date': datetime.date(2009, 2, 14), u'bday': datetime.date(1979, 9, 19), u'pp_kladr_code': None, u'pasp_doc': 197, u'p_num': 248327, u'pop_area_code': 7832, u'ds_cod': 114, u'pol_id': 4667796, u'pasp_ser': u'03', u'tmp_date': datetime.date(2009, 12, 21), u'status_name': u'=\u0418\u0421\u041a\u041b\u042e\u0427\u0415\u041d \u041e\u041f\u0415\u0420\u0410\u0422\u041e\u0420\u041e\u041c', u'fio_id': 2023475, u'addr_id': 1512954, u'agr_end_date': datetime.date(2009, 12, 21), u'agr_beg_date': datetime.date(1995, 12, 21)}): "Missing key '200000000000'"
2009-04-14 11:43:50,703:INFO:kladr:Code 1800000000000 missed in cache (1960 length)
2009-04-14 11:43:51,002:INFO:kladr:Code 8600000000000 missed in cache (1961 length)
2009-04-14 11:44:05,159:INFO:kladr:Code 6100000000000 missed in cache (1962 length)
2009-04-14 11:44:13,785:INFO:kladr:Code 7300000000000 missed in cache (1963 length)
2009-04-14 11:44:15,973:INFO:kladr:Code 7800000000000 missed in cache (1964 length)
2009-04-14 11:44:42,460:INFO:kladr:Code 3700000000000 missed in cache (1965 length)
2009-04-14 11:44:52,067:WARNING:root:Wrong snils 06406390950 for polis 3003 44858
2009-04-14 11:44:55,541:INFO:kladr:Code 4900000000000 missed in cache (1966 length)
2009-04-14 11:44:57,169:INFO:kladr:Code 2700000000000 missed in cache (1967 length)
2009-04-14 11:44:58,301:WARNING:root:Wrong snils 13021232210 for polis 3003 582012
2009-04-14 11:45:14,419:INFO:kladr:Code 5900000000000 missed in cache (1968 length)
2009-04-14 11:45:40,121:INFO:kladr:Code 2500000000000 missed in cache (1969 length)
2009-04-14 11:46:15,119:WARNING:root:Wrong snils 8513020025 for polis 3002 13955
2009-04-14 11:46:30,390:WARNING:root:Wrong snils 10874612160 for polis 368 12548
2009-04-14 11:46:31,694:INFO:kladr:Code 7500000000000 missed in cache (1970 length)
2009-04-14 11:46:46,880:INFO:kladr:Code 4500000000000 missed in cache (1971 length)
2009-04-14 11:48:01,074:INFO:kladr:Code 3500000000000 missed in cache (1972 length)
2009-04-14 11:50:12,499:INFO:kladr:Code 3100000000000 missed in cache (1973 length)
2009-04-14 11:50:34,767:WARNING:root:Wrong snils 12300366050 for polis 3003 163665
2009-04-14 11:50:52,964:INFO:kladr:Code 6300000000000 missed in cache (1974 length)
2009-04-14 11:50:59,257:WARNING:root:Wrong snils 8825944718 for polis 3001 339049
2009-04-14 11:51:19,629:INFO:kladr:Code 4600000000000 missed in cache (1975 length)
2009-04-14 11:51:23,384:INFO:kladr:Code 2800000000000 missed in cache (1976 length)
2009-04-14 11:51:59,991:WARNING:root:Wrong snils 8513020530 for polis 3002 13998
2009-04-14 11:52:07,749:INFO:kladr:Code 4800000000000 missed in cache (1977 length)
Start filling related data at 2009-04-14 11:36:57.883766
Start join at 2009-04-14 11:36:58.615533