Created
October 29, 2018 17:26
-
-
Save chrowe/203953681cece9c75f9b510c334a5d41 to your computer and use it in GitHub Desktop.
fill_geocoder.sh output
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
ubuntu@carto:~$ sudo docker exec -ti cartodb bash -c /cartodb/script/fill_geocoder.sh | |
--2018-10-29 16:36:55-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/admin0_synonyms.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.86.109 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.86.109|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 130898 (128K) [application/octet-stream] | |
Saving to: ‘db_dumps/admin0_synonyms.sql’ | |
admin0_synonyms.sql 100%[=================================================================================================>] 127.83K --.-KB/s in 0.004s | |
2018-10-29 16:36:55 (32.1 MB/s) - ‘db_dumps/admin0_synonyms.sql’ saved [130898/130898] | |
--2018-10-29 16:36:55-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/available_services.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.86.109 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.86.109|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 21203 (21K) [application/octet-stream] | |
Saving to: ‘db_dumps/available_services.sql’ | |
available_services.sql 100%[=================================================================================================>] 20.71K --.-KB/s in 0s | |
2018-10-29 16:36:55 (41.8 MB/s) - ‘db_dumps/available_services.sql’ saved [21203/21203] | |
--2018-10-29 16:36:55-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/country_decoder.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.86.109 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.86.109|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 162894 (159K) [application/octet-stream] | |
Saving to: ‘db_dumps/country_decoder.sql’ | |
country_decoder.sql 100%[=================================================================================================>] 159.08K --.-KB/s in 0.002s | |
2018-10-29 16:36:55 (78.0 MB/s) - ‘db_dumps/country_decoder.sql’ saved [162894/162894] | |
--2018-10-29 16:36:55-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/admin1_decoder.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.86.109 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.86.109|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 1171808 (1.1M) [application/octet-stream] | |
Saving to: ‘db_dumps/admin1_decoder.sql’ | |
admin1_decoder.sql 100%[=================================================================================================>] 1.12M --.-KB/s in 0.01s | |
2018-10-29 16:36:55 (113 MB/s) - ‘db_dumps/admin1_decoder.sql’ saved [1171808/1171808] | |
--2018-10-29 16:36:55-- 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.86.109 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.86.109|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 569041563 (543M) [application/octet-stream] | |
Saving to: ‘db_dumps/global_cities_alternates_limited.sql’ | |
global_cities_alternates_limited.sql 100%[=================================================================================================>] 542.68M 67.6MB/s in 8.7s | |
2018-10-29 16:37:04 (62.6 MB/s) - ‘db_dumps/global_cities_alternates_limited.sql’ saved [569041563/569041563] | |
--2018-10-29 16:37:04-- 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.160.77 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.160.77|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 985438451 (940M) [application/octet-stream] | |
Saving to: ‘db_dumps/global_cities_points_limited.sql’ | |
global_cities_points_limited.sql 100%[=================================================================================================>] 939.79M 71.7MB/s in 19s | |
2018-10-29 16:37:23 (50.2 MB/s) - ‘db_dumps/global_cities_points_limited.sql’ saved [985438451/985438451] | |
--2018-10-29 16:37:23-- 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.98.45 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.98.45|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 204631141 (195M) [application/octet-stream] | |
Saving to: ‘db_dumps/global_postal_code_points.sql’ | |
global_postal_code_points.sql 100%[=================================================================================================>] 195.15M 54.2MB/s in 3.6s | |
2018-10-29 16:37:27 (54.2 MB/s) - ‘db_dumps/global_postal_code_points.sql’ saved [204631141/204631141] | |
--2018-10-29 16:37:27-- 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.98.45 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.98.45|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 129113125 (123M) [application/octet-stream] | |
Saving to: ‘db_dumps/global_province_polygons.sql’ | |
global_province_polygons.sql 100%[=================================================================================================>] 123.13M 76.6MB/s in 1.6s | |
2018-10-29 16:37:28 (76.6 MB/s) - ‘db_dumps/global_province_polygons.sql’ saved [129113125/129113125] | |
--2018-10-29 16:37:28-- 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.16.131 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.16.131|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 562523924 (536M) [application/octet-stream] | |
Saving to: ‘db_dumps/ip_address_locations.sql’ | |
ip_address_locations.sql 100%[=================================================================================================>] 536.46M 80.6MB/s in 9.5s | |
2018-10-29 16:37:38 (56.5 MB/s) - ‘db_dumps/ip_address_locations.sql’ saved [562523924/562523924] | |
--2018-10-29 16:37:38-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/ne_admin0_v3.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 54.231.82.140 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|54.231.82.140|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 35447642 (34M) [application/octet-stream] | |
Saving to: ‘db_dumps/ne_admin0_v3.sql’ | |
ne_admin0_v3.sql 100%[=================================================================================================>] 33.80M 73.8MB/s in 0.5s | |
2018-10-29 16:37:39 (73.8 MB/s) - ‘db_dumps/ne_admin0_v3.sql’ saved [35447642/35447642] | |
--2018-10-29 16:37:39-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/global_postal_code_polygons.sql | |
Resolving s3.amazonaws.com (s3.amazonaws.com)... 54.231.82.140 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|54.231.82.140|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 3742780612 (3.5G) [application/octet-stream] | |
Saving to: ‘db_dumps/global_postal_code_polygons.sql’ | |
global_postal_code_polygons.sql 100%[=================================================================================================>] 3.49G 63.1MB/s in 66s | |
2018-10-29 16:38:45 (54.2 MB/s) - ‘db_dumps/global_postal_code_polygons.sql’ saved [3742780612/3742780612] | |
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: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin0_synonyms.sql:1351: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin0_synonyms.sql:1351: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin0_synonyms.sql:1351: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin0_synonyms.sql:1351: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin0_synonyms.sql:1351: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 1332 | |
setval | |
-------- | |
43957 | |
(1 row) | |
Done with db_dumps/admin0_synonyms.sql. | |
Importing db_dumps/admin1_decoder.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
psql:db_dumps/admin1_decoder.sql:3911: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin1_decoder.sql:3911: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin1_decoder.sql:3911: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin1_decoder.sql:3911: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin1_decoder.sql:3911: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/admin1_decoder.sql:3911: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 3892 | |
setval | |
-------- | |
3892 | |
(1 row) | |
Done with db_dumps/admin1_decoder.sql. | |
Importing db_dumps/available_services.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
psql:db_dumps/available_services.sql:275: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/available_services.sql:275: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/available_services.sql:275: WARNING: Varnish fetch error: Bad response code: 101 Unknown request.e: 101 Unknown request. e: 101 Unknown request. | |
psql:db_dumps/available_services.sql:275: WARNING: Varnish fetch error: Bad response code: 101 Unknown request.e: 101 Unknown request. e: 101 Unknown request. | |
psql:db_dumps/available_services.sql:275: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/available_services.sql:275: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 256 | |
setval | |
-------- | |
256 | |
(1 row) | |
Done with db_dumps/available_services.sql. | |
Importing db_dumps/country_decoder.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
setval | |
-------- 101 Unknown request. | |
251 101 Unknown request. | |
(1 row) 101 Unknown request. | |
101 Unknown request. | |
psql:db_dumps/country_decoder.sql:276: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
101 Unknown request. 101 Unknown request. | |
psql:db_dumps/country_decoder.sql:276: WARNING: Varnish fetch error: Bad response code: | |
101 Unknown request. | |
psql:db_dumps/country_decoder.sql:276: WARNING: Varnish fetch error: Bad response code: | |
101 Unknown request. | |
psql:db_dumps/country_decoder.sql:276: WARNING: Varnish fetch error: Bad response code: | |
101 Unknown request. | |
psql:db_dumps/country_decoder.sql:276: WARNING: Varnish fetch error: Bad response code: | |
101 Unknown request. | |
psql:db_dumps/country_decoder.sql:276: WARNING: Varnish fetch error: Bad response code: | |
101 Unknown request. | |
COPY 250 | |
Done with db_dumps/country_decoder.sql. | |
Importing db_dumps/global_cities_alternates_limited.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
psql:db_dumps/global_cities_alternates_limited.sql:4532979: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_alternates_limited.sql:4532979: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_alternates_limited.sql:4532979: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_alternates_limited.sql:4532979: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_alternates_limited.sql:4532979: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_alternates_limited.sql:4532979: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 4532960 | |
setval | |
--------- | |
8026448 | |
(1 row) | |
Done with db_dumps/global_cities_alternates_limited.sql. | |
Importing db_dumps/global_cities_points_limited.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
psql:db_dumps/global_cities_points_limited.sql:3843517: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_points_limited.sql:3843517: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_points_limited.sql:3843517: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_points_limited.sql:3843517: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_points_limited.sql:3843517: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_cities_points_limited.sql:3843517: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 3843498 | |
setval | |
---------- | |
10183531 | |
(1 row) | |
Done with db_dumps/global_cities_points_limited.sql. | |
Importing db_dumps/global_postal_code_points.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
setval | |
--------- | |
1403640 | |
(1 row) | |
psql:db_dumps/global_postal_code_points.sql:843622: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_points.sql:843622: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_points.sql:843622: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_points.sql:843622: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_points.sql:843622: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_points.sql:843622: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 843596 | |
Done with db_dumps/global_postal_code_points.sql. | |
Importing db_dumps/global_postal_code_polygons.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
psql:db_dumps/global_postal_code_polygons.sql:43313: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_polygons.sql:43313: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_polygons.sql:43313: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_polygons.sql:43313: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_polygons.sql:43313: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_postal_code_polygons.sql:43313: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 43294 | |
setval | |
-------- | |
43294 | |
(1 row) | |
Done with db_dumps/global_postal_code_polygons.sql. | |
Importing db_dumps/global_province_polygons.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
psql:db_dumps/global_province_polygons.sql:4676: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_province_polygons.sql:4676: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_province_polygons.sql:4676: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_province_polygons.sql:4676: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_province_polygons.sql:4676: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/global_province_polygons.sql:4676: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 4657 | |
setval | |
-------- | |
4723 | |
(1 row) | |
Done with db_dumps/global_province_polygons.sql. | |
Importing db_dumps/ip_address_locations.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
setval | |
--------- | |
5746773 | |
(1 row) | |
psql:db_dumps/ip_address_locations.sql:2963551: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/ip_address_locations.sql:2963551: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/ip_address_locations.sql:2963551: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/ip_address_locations.sql:2963551: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/ip_address_locations.sql:2963551: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:db_dumps/ip_address_locations.sql:2963551: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
COPY 2963525 | |
Done with db_dumps/ip_address_locations.sql. | |
Importing db_dumps/ne_admin0_v3.sql... | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
SET | |
setval | |
-------- | |
1562 | |
(1 row) | |
psql:db_dumps/ne_admin0_v3.sql:293: ERROR: function _cdb_nonanalysistablesinschema(text) does not exist | |
LINE 6: SELECT table_name FROM _CDB_NonAnalysisTablesInSchema(sc... | |
^ | |
HINT: No function matches the given name and argument types. You might need to add explicit type casts. | |
QUERY: WITH raster_tables AS ( | |
SELECT o_table_name, r_table_name FROM raster_overviews | |
WHERE o_table_schema = schema_name AND o_table_catalog = current_database() | |
), | |
user_tables AS ( | |
SELECT table_name FROM _CDB_NonAnalysisTablesInSchema(schema_name) | |
), | |
table_cat AS ( | |
SELECT | |
table_name, | |
( | |
EXISTS(select * from raster_tables where o_table_name = table_name) | |
OR table_name SIMILAR TO _CDB_OverviewTableDiscriminator() || '[\w\d]*' | |
) AS is_overview, | |
EXISTS(SELECT * FROM raster_tables WHERE r_table_name = table_name) AS is_raster | |
FROM user_tables | |
), | |
sizes AS ( | |
SELECT COALESCE(INT8(SUM(cartodb._CDB_total_relation_size(schema_name, table_name)))) table_size, | |
CASE | |
WHEN is_overview THEN 0 | |
WHEN is_raster THEN 1 | |
ELSE 0.5 -- Division by 2 is for not counting the_geom_webmercator | |
END AS multiplier FROM table_cat GROUP BY is_overview, is_raster | |
) | |
SELECT sum(table_size*multiplier)::int8 FROM sizes | |
CONTEXT: PL/pgSQL function cartodb.cdb_userdatasize(text) line 5 at SQL statement | |
SQL statement "SELECT cartodb.CDB_UserDataSize(schema_name)" | |
PL/pgSQL function cartodb.cdb_checkquota() line 42 at SQL statement | |
--2018-10-29 17:06:49-- 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.102.37 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.102.37|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 110 [application/octet-stream] | |
Saving to: ‘data_patches/20160203_countries_bh_isocode.sql’ | |
20160203_countries_bh_ 100%[=========================>] 110 --.-KB/s in 0s | |
2018-10-29 17:06:49 (2.50 MB/s) - ‘data_patches/20160203_countries_bh_isocode.sql’ saved | |
[110/110] | |
--2018-10-29 17:06:49-- 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.102.37 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.102.37|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 351 [application/x-sql] | |
Saving to: ‘data_patches/20160622_countries_synonym_congo.sql’ | |
20160622_countries_syn 100%[=========================>] 351 --.-KB/s in 0s | |
2018-10-29 17:06:49 (10.6 MB/s) - ‘data_patches/20160622_countries_synonym_congo.sql’ saved [351/351] | |
--2018-10-29 17:06:49-- 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)... 52.216.102.37 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.102.37|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 184 [application/sql] | |
Saving to: ‘data_patches/20171004_merge_corsica_and_france.sql’ | |
20171004_merge_corsica 100%[=========================>] 184 --.-KB/s in 0s | |
2018-10-29 17:06:49 (4.53 MB/s) - ‘data_patches/20171004_merge_corsica_and_france.sql’ saved [184/184] | |
--2018-10-29 17:06:49-- 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.102.37 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.102.37|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 180 [application/sql] | |
Saving to: ‘data_patches/20180117_hsinchu_synonyms.sql’ | |
20180117_hsinchu_synon 100%[=========================>] 180 --.-KB/s in 0s | |
2018-10-29 17:06:49 (5.80 MB/s) - ‘data_patches/20180117_hsinchu_synonyms.sql’ saved [180/180] | |
--2018-10-29 17:06:49-- 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.102.37 | |
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.102.37|:443... connected. | |
HTTP request sent, awaiting response... 200 OK | |
Length: 301 [application/x-sql] | |
Saving to: ‘data_patches/20180306_add_ssd_rows_for_south_sudan.sql’ | |
20180306_add_ssd_rows_ 100%[=========================>] 301 --.-KB/s in 0s | |
2018-10-29 17:06:49 (10.2 MB/s) - ‘data_patches/20180306_add_ssd_rows_for_south_sudan.sql’ saved [301/301] | |
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 48 | |
Done with data_patches/20160203_countries_bh_isocode.sql. | |
Importing data_patches/20160622_countries_synonym_congo.sql... | |
psql:data_patches/20160622_countries_synonym_congo.sql:9: WARNING: Varnish fetch error: Bad response code: 101 Unknown request.psql:data_patches/20160622_countries_synonym_congo.sql:9: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20160622_countries_synonym_congo.sql:9: WARNING: Varnish fetch error: Bad response code: 101 Unknown request.psql:data_patches/20160622_countries_synonym_congo.sql:9: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20160622_countries_synonym_congo.sql:9: WARNING: Varnish fetch error: Bad response code: 101 Unknown request.psql:data_patches/20160622_countries_synonym_congo.sql:9: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
DODone 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 0psql: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 1 | |
Done with data_patches/20180117_hsinchu_synonyms.sql. | |
Importing data_patches/20180306_add_ssd_rows_for_south_sudan.sql... | |
psql:data_patches/20180306_add_ssd_rows_for_south_sudan.sql:8: WARNING: Varnish fetch error: Bad response code: 101 Unknown request.psql:data_patches/20180306_add_ssd_rows_for_south_sudan.sql:8: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180306_add_ssd_rows_for_south_sudan.sql:8: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180306_add_ssd_rows_for_south_sudan.sql:8: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180306_add_ssd_rows_for_south_sudan.sql:8: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
psql:data_patches/20180306_add_ssd_rows_for_south_sudan.sql:8: WARNING: Varnish fetch error: Bad response code: 101 Unknown request. | |
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