Skip to content

Instantly share code, notes, and snippets.

@christophekey

christophekey/dead varnish

Created August 24, 2018 22:28
Show Gist options
  • Save christophekey/5805653cab2ba4b40c503d5c7a6171f9 to your computer and use it in GitHub Desktop.
Save christophekey/5805653cab2ba4b40c503d5c7a6171f9 to your computer and use it in GitHub Desktop.
Download ZIP
Step 2 - kill varnish run again
Raw
dead varnish
ps aux
root 2280 0.0 0.0 118376 3536 ? Ss 22:21 0:00 /opt/varnish/sbin/varnishd -a :6081 -T localhost:6082 -s malloc,256m -f /etc/varnish.vcl
nobody 2282 0.0 0.0 273108 3104 ? Sl 22:21 0:00 /opt/varnish/sbin/varnishd -a :6081 -T localhost:6082 -s malloc,256m -f /etc/varnish.vcl
kill 2280
kill 2282
killed varnish
run it again
root@carto:/home/christophe# docker exec -ti 1e8fbd412722 bash -c /cartodb/script/fill_geocoder.sh
--2018-08-24 22:26:58-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/admin0_synonyms.sql
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.165.181
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.165.181|: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:26:59-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/available_services.sql
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.85.53
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.85.53|: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:26:59-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/country_decoder.sql
Resolving s3.amazonaws.com (s3.amazonaws.com)... 52.216.233.125
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.233.125|: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:27:00-- https://s3.amazonaws.com/data.cartodb.net/geocoding/dumps/0.0.1/admin1_decoder.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:27:00-- 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.169.109
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.169.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:27:00-- 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.165.229
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.165.229|: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:27:01-- 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.1.107
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.1.107|: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:27:01-- 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.19.91
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.19.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:27:02-- 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.97.181
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.97.181|: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:27:02-- 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.232.85
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.232.85|: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:27:03-- 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.41.34
Connecting to s3.amazonaws.com (s3.amazonaws.com)|54.231.41.34|: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:27:03-- 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.230.85
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.230.85|: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:27:04-- 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.81.147
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.81.147|: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:27:04-- 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.81.147
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.81.147|: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:27:05-- 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.232.101
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.232.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:27:05-- 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.104.45
Connecting to s3.amazonaws.com (s3.amazonaws.com)|52.216.104.45|: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...
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...
UPDATE 0
DELETE 0
Done with data_patches/20171004_merge_corsica_and_france.sql.
Importing data_patches/20180117_hsinchu_synonyms.sql...
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 **
root@carto:/home/christophe#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment