Created
August 24, 2018 22:23
-
-
Save christophekey/853ad3df5e9d1d83550aa13c724b726b to your computer and use it in GitHub Desktop.
step 1 - fill geocoder varnish error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
root@carto:/home/christophe# docker exec -ti 1e8fbd412722 bash -c /cartodb/script/fill_geocoder.sh | |
--2018-08-24 22:21:56-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/admin0_synonyms.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.169.37 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.169.37|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:21:56-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/available_services.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.99.29 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.99.29|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:21:57-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/country_decoder.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.97.21 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.97.21|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:21:57-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/admin1_decoder.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.97.21 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.97.21|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:21:58-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/global_cities_alternates_limited.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.82.19 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.82.19|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:21:58-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/global_cities_points_limited.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.163.109 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.163.109|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:21:59-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/global_postal_code_points.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.32.91 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.32.91|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:21:59-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/global_province_polygons.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.101.101 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.101.101|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:22:00-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/ip_address_locations.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.81.195 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.81.195|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:22:00-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/ne_admin0_v3.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.32.179 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.32.179|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:22:00-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/global_postal_code_polygons.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.81.115 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.81.115|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
About to import the following files: db_dumps/admin0_synonyms.sql db_dumps/admin1_decoder.sql db_dumps/available_services.sql db_dumps/country_decoder.sql db_dumps/global_cities_alternates_limited.sql db_dumps/global_cities_points_limited.sql db_dumps/global_postal_code_points.sql db_dumps/global_postal_code_polygons.sql db_dumps/global_province_polygons.sql db_dumps/ip_address_locations.sql db_dumps/ne_admin0_v3.sql | |
Importing db_dumps/admin0_synonyms.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
psql:db_dumps/admin0_synonyms.sql:1351: ERROR: duplicate key value violates unique constraint "admin0_synonyms_cartodb_id_key" | |
DETAIL: Key (cartodb_id)=(41604) already exists. | |
CONTEXT: COPY admin0_synonyms, line 1: "Angola 0 2015-11-04 17:17:40.882056+00 2015-11-04 17:17:40.882056+00 \N \N 41604 AGO angola" | |
--2018-08-24 22:22:01-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/patches/20160203_countries_bh_isocode.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.81.195 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.81.195|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:22:02-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/patches/20160622_countries_synonym_congo.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.104.253 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.104.253|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:22:02-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/patches/20171004_merge_corsica_and_france.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 54.231.49.164 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|54.231.49.164|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:22:02-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/patches/20180117_hsinchu_synonyms.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.133.29 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.133.29|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
--2018-08-24 22:22:03-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/patches/20180306_add_ssd_rows_for_south_sudan.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.105.221 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.105.221|:443... connected. | |
HTTP request sent, awaiting response... 416 Requested Range Not Satisfiable | |
The file is already fully retrieved; nothing to do. | |
About to import the following files: data_patches/20160203_countries_bh_isocode.sql data_patches/20160622_countries_synonym_congo.sql data_patches/20171004_merge_corsica_and_france.sql data_patches/20180117_hsinchu_synonyms.sql data_patches/20180306_add_ssd_rows_for_south_sudan.sql | |
Importing data_patches/20160203_countries_bh_isocode.sql... | |
psql:data_patches/20160203_countries_bh_isocode.sql:3: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20160203_countries_bh_isocode.sql:3: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20160203_countries_bh_isocode.sql:3: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20160203_countries_bh_isocode.sql:3: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20160203_countries_bh_isocode.sql:3: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20160203_countries_bh_isocode.sql:3: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
DELETE 0 | |
Done with data_patches/20160203_countries_bh_isocode.sql. | |
Importing data_patches/20160622_countries_synonym_congo.sql... | |
DO | |
Done with data_patches/20160622_countries_synonym_congo.sql. | |
Importing data_patches/20171004_merge_corsica_and_france.sql... | |
psql:data_patches/20171004_merge_corsica_and_france.sql:1: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:1: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:1: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:1: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:1: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:1: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
UPDATE 0 | |
psql:data_patches/20171004_merge_corsica_and_france.sql:2: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:2: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:2: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:2: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:2: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20171004_merge_corsica_and_france.sql:2: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
DELETE 0 | |
Done with data_patches/20171004_merge_corsica_and_france.sql. | |
Importing data_patches/20180117_hsinchu_synonyms.sql... | |
psql:data_patches/20180117_hsinchu_synonyms.sql:4: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180117_hsinchu_synonyms.sql:4: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180117_hsinchu_synonyms.sql:4: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180117_hsinchu_synonyms.sql:4: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180117_hsinchu_synonyms.sql:4: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180117_hsinchu_synonyms.sql:4: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
UPDATE 0 | |
Done with data_patches/20180117_hsinchu_synonyms.sql. | |
Importing data_patches/20180306_add_ssd_rows_for_south_sudan.sql... | |
DO | |
Done with data_patches/20180306_add_ssd_rows_for_south_sudan.sql. | |
** Everything OK ** |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment