Skip to content

Instantly share code, notes, and snippets.

@chrowe
Created October 29, 2018 17:26
Show Gist options
  • Save chrowe/203953681cece9c75f9b510c334a5d41 to your computer and use it in GitHub Desktop.
Save chrowe/203953681cece9c75f9b510c334a5d41 to your computer and use it in GitHub Desktop.
fill_geocoder.sh output
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