Skip to content

Instantly share code, notes, and snippets.

@andrewSC
Created March 2, 2016 18:18
Show Gist options
  • Save andrewSC/cb4ddc7a3f438baed525 to your computer and use it in GitHub Desktop.
Save andrewSC/cb4ddc7a3f438baed525 to your computer and use it in GitHub Desktop.
Started POST "/user/development/api/v1/imports" for 10.125.0.2 at 2016-03-02 18:11:54 +0000
Processing by Api::Json::ImportsController#create as JSON
Parameters: {"table_name"=>"shapes_merge", "sql"=>"SELECT shapes.shape_id, shapes.shape_pt_lat, shapes.shape_pt_lon, shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL
THEN shapes.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_id, trips.service_id, trips.shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_
id FROM shapes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.shape_id))", "user_domain"=>"development"}
(0.000788s) SELECT * FROM "users" WHERE ("username" = 'development') LIMIT 1
(0.000701s) SELECT * FROM "users" WHERE "id" = '86de79d4-2177-4d21-a8aa-790c564c9476'
(0.000123s) BEGIN
(0.000530s) INSERT INTO "logs" ("type", "user_id", "entries", "updated_at") VALUES ('import', '86de79d4-2177-4d21-a8aa-790c564c9476', '', '2016-03-02 18:11:54.105590+0000') RETUR
NING *
(0.004477s) COMMIT
(0.000110s) BEGIN
(0.000727s) INSERT INTO "data_imports" ("user_id", "table_name", "data_type", "data_source", "original_url", "table_id", "append", "table_copy", "from_query", "service_name", "se
rvice_item_id", "type_guessing", "quoted_fields_guessing", "content_guessing", "state", "upload_host", "create_visualization", "user_defined_limits", "privacy", "logger", "update
d_at") VALUES ('86de79d4-2177-4d21-a8aa-790c564c9476', 'shapes_merge', 'datasource', '', '', NULL, false, NULL, 'SELECT shapes.shape_id, shapes.shape_pt_lat, shapes.shape_pt_lon,
shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL THEN shapes.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_id, trips.service_id, trips.
shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_id FROM shapes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.shape_id))', 'public_url', NUL
L, true, true, false, 'pending', 'ubuntu-12-04-cartodb-1', false, '{"twitter_credits_limit":0}', NULL, '76697154-a916-495e-a3b3-826c97b8dea6', '2016-03-02 18:11:54.111569+0000')
RETURNING *
(0.000565s) SELECT * FROM "users" WHERE ("id" = '86de79d4-2177-4d21-a8aa-790c564c9476') LIMIT 1
(0.003954s) COMMIT
Completed 200 OK in 45.0ms (Views: 0.3ms | Models: 0.0ms)
Carto::DataImport Load (0.9ms) SELECT "data_imports".* FROM "data_imports" WHERE "data_imports"."id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb' LIMIT 1
(0.000212s) SET standard_conforming_strings = ON
(0.000152s) SET client_min_messages = 'WARNING'
(0.000156s) SET DateStyle = 'ISO'
(0.001959s) SELECT * FROM "data_imports" WHERE "id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb'
(0.000588s) SELECT * FROM "logs" WHERE ("id" = '76697154-a916-495e-a3b3-826c97b8dea6') LIMIT 1
(0.001171s) SELECT * FROM "users" WHERE "id" = '86de79d4-2177-4d21-a8aa-790c564c9476'
(0.000123s) BEGIN
(0.000806s) UPDATE "data_imports" SET "data_source" = '', "data_type" = 'query', "table_name" = 'shapes_merge', "state" = 'uploading', "success" = false, "logger" = '76697154-a91
6-495e-a3b3-826c97b8dea6', "updated_at" = '2016-03-02 18:11:55.438519+0000', "created_at" = '2016-03-02 18:11:54.111400+0000', "error_code" = NULL, "queue_id" = NULL, "tables_cre
ated_count" = NULL, "table_names" = NULL, "append" = false, "migrate_table" = NULL, "table_copy" = NULL, "from_query" = 'SELECT shapes.shape_id, shapes.shape_pt_lat, shapes.shape
_pt_lon, shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL THEN shapes.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_id, trips.service_id
, trips.shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_id FROM shapes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.shape_id))', "synchron
ization_id" = NULL, "user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476', "table_id" = NULL, "service_name" = 'public_url', "service_item_id" = NULL, "stats" = '{}', "type_guessing
" = true, "quoted_fields_guessing" = true, "content_guessing" = false, "server" = 'ubuntu-12-04-cartodb-1', "host" = NULL, "upload_host" = 'ubuntu-12-04-cartodb-1', "resque_ppid"
= 15297, "create_visualization" = false, "visualization_id" = NULL, "user_defined_limits" = '{"twitter_credits_limit":0}', "import_extra_options" = NULL, "original_url" = '', "p
rivacy" = NULL, "cartodbfy_time" = 0.0, "http_response_code" = NULL, "rejected_layers" = NULL, "runner_warnings" = NULL WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb')
(0.004542s) COMMIT
(0.000959s) SELECT "name" FROM "user_tables" WHERE ("user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476') ORDER BY "id" DESC
(0.000204s) SET standard_conforming_strings = ON
(0.000170s) SET client_min_messages = 'WARNING'
(0.000190s) SET DateStyle = 'ISO'
(0.000212s) SET search_path TO "development", cartodb, cdb_dataservices_client, public
[pool] Creating a new connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (1)
(0.014973s) select relname from pg_stat_user_tables WHERE schemaname='development'
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (1)
Started GET "/user/development/api/v1/imports/ef49baeb-53c3-4b1d-8496-36d5b4e7cebb" for 10.125.0.2 at 2016-03-02 18:11:55 +0000
Processing by Carto::Api::ImportsController#show as JSON
Parameters: {"user_domain"=>"development", "id"=>"ef49baeb-53c3-4b1d-8496-36d5b4e7cebb"}
(0.000755s) SELECT * FROM "users" WHERE ("username" = 'development') LIMIT 1
Completed 200 OK in 38.0ms (Views: 0.8ms | Models: 0.0ms)
Carto::DataImport Load (1.2ms) SELECT "data_imports".* FROM "data_imports" WHERE "data_imports"."id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb' LIMIT 1
Started GET "/user/development/api/v1/imports/ef49baeb-53c3-4b1d-8496-36d5b4e7cebb" for 10.125.0.2 at 2016-03-02 18:11:57 +0000
Processing by Carto::Api::ImportsController#show as JSON
Parameters: {"user_domain"=>"development", "id"=>"ef49baeb-53c3-4b1d-8496-36d5b4e7cebb"}
(0.000851s) SELECT * FROM "users" WHERE ("username" = 'development') LIMIT 1
Completed 200 OK in 5.1ms (Views: 0.7ms | Models: 0.0ms)
Carto::DataImport Load (1.3ms) SELECT "data_imports".* FROM "data_imports" WHERE "data_imports"."id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb' LIMIT 1
Started GET "/user/development/api/v1/imports/ef49baeb-53c3-4b1d-8496-36d5b4e7cebb" for 10.125.0.2 at 2016-03-02 18:12:18 +0000
Processing by Carto::Api::ImportsController#show as JSON
Parameters: {"user_domain"=>"development", "id"=>"ef49baeb-53c3-4b1d-8496-36d5b4e7cebb"}
(0.001171s) SELECT * FROM "users" WHERE ("username" = 'development') LIMIT 1
Completed 200 OK in 5.9ms (Views: 0.7ms | Models: 0.0ms)
Carto::DataImport Load (0.7ms) SELECT "data_imports".* FROM "data_imports" WHERE "data_imports"."id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb' LIMIT 1
(23.979339s) CREATE TABLE shapes_merge AS SELECT shapes.shape_id, shapes.shape_pt_lat, shapes.shape_pt_lon, shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL THEN shapes
.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_id, trips.service_id, trips.shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_id FROM sha
pes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.shape_id))
(0.000148s) SET standard_conforming_strings = ON
(0.000126s) SET client_min_messages = 'WARNING'
(0.000160s) SET DateStyle = 'ISO'
(0.000159s) SET search_path TO "development", cartodb, cdb_dataservices_client, public
[pool] Creating a new connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:postgres:sequel (2)
(0.000590s) SELECT cartodb.cdb_version() AS v
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:postgres:sequel (2)
(0.014294s) SELECT cartodb.CDB_UserDataSize('development')
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.012452s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.002223s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.002205s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.002074s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.002348s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.002803s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.002819s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.002900s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.003231s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.003402s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.003548s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.003674s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
(0.000422s) BEGIN
(0.000759s) UPDATE "data_imports" SET "updated_at" = '2016-03-02 18:12:19.585717+0000', "table_names" = 'shapes_merge', "service_name" = NULL WHERE ("id" = 'ef49baeb-53c3-4b1d-84
96-36d5b4e7cebb')
(0.005154s) COMMIT
(0.000570s) SELECT "name" FROM "user_tables" WHERE ("user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476') ORDER BY "id" DESC
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.000867s) SELECT COUNT(*) AS "count" FROM "user_tables" WHERE (("name" = 'shapes_merge') AND ("user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476')) LIMIT 1
(0.000529s) SELECT COUNT(*) AS "count" FROM "user_tables" WHERE (("name" = 'shapes_merge') AND ("user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476')) LIMIT 1
(0.000191s) BEGIN
(0.001403s) SELECT COUNT(*) AS "count" FROM "visualizations" WHERE (("map_id" IS NULL) AND ("type" = 'table')) LIMIT 1
(0.000876s) SELECT * FROM "visualizations" WHERE (("map_id" IS NULL) AND ("type" = 'table')) LIMIT 300 OFFSET 0
(0.000777s) SELECT * FROM "data_imports" WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb') LIMIT 1
(0.000453s) SELECT * FROM "logs" WHERE ("id" = '76697154-a916-495e-a3b3-826c97b8dea6') LIMIT 1
(0.000495s) UPDATE "data_imports" SET "data_source" = '', "data_type" = 'external_table', "table_name" = 'shapes_merge', "state" = 'uploading', "success" = false, "logger" = '766
97154-a916-495e-a3b3-826c97b8dea6', "updated_at" = '2016-03-02 18:12:19.622897+0000', "created_at" = '2016-03-02 18:11:54.111400+0000', "error_code" = NULL, "queue_id" = NULL, "t
ables_created_count" = NULL, "table_names" = 'shapes_merge', "append" = false, "migrate_table" = NULL, "table_copy" = NULL, "from_query" = 'SELECT shapes.shape_id, shapes.shape_p
t_lat, shapes.shape_pt_lon, shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL THEN shapes.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_i
d, trips.service_id, trips.shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_id FROM shapes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.sha
pe_id))', "synchronization_id" = NULL, "user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476', "table_id" = NULL, "service_name" = NULL, "service_item_id" = NULL, "stats" = '{}', "ty
pe_guessing" = true, "quoted_fields_guessing" = true, "content_guessing" = false, "server" = 'ubuntu-12-04-cartodb-1', "host" = NULL, "upload_host" = 'ubuntu-12-04-cartodb-1', "r
esque_ppid" = 15297, "create_visualization" = false, "visualization_id" = NULL, "user_defined_limits" = '{"twitter_credits_limit":0}', "import_extra_options" = NULL, "original_ur
l" = '', "privacy" = NULL, "cartodbfy_time" = 0.0, "http_response_code" = NULL, "rejected_layers" = NULL, "runner_warnings" = NULL WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7
cebb')
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:postgres:sequel (2)
(0.009120s) SELECT cartodb.CDB_UserDataSize('development')
Started GET "/user/development/api/v1/imports/ef49baeb-53c3-4b1d-8496-36d5b4e7cebb" for 10.125.0.2 at 2016-03-02 18:12:19 +0000
Processing by Carto::Api::ImportsController#show as JSON
Parameters: {"user_domain"=>"development", "id"=>"ef49baeb-53c3-4b1d-8496-36d5b4e7cebb"}
(0.001267s) SELECT * FROM "users" WHERE ("username" = 'development') LIMIT 1
Completed 200 OK in 6.6ms (Views: 0.7ms | Models: 0.0ms)
Carto::DataImport Load (0.7ms) SELECT "data_imports".* FROM "data_imports" WHERE "data_imports"."id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb' LIMIT 1
Started GET "/user/development/api/v1/imports/ef49baeb-53c3-4b1d-8496-36d5b4e7cebb" for 10.125.0.2 at 2016-03-02 18:12:21 +0000
Processing by Carto::Api::ImportsController#show as JSON
Parameters: {"user_domain"=>"development", "id"=>"ef49baeb-53c3-4b1d-8496-36d5b4e7cebb"}
(0.001249s) SELECT * FROM "users" WHERE ("username" = 'development') LIMIT 1
Completed 200 OK in 6.1ms (Views: 0.8ms | Models: 0.0ms)
Carto::DataImport Load (0.8ms) SELECT "data_imports".* FROM "data_imports" WHERE "data_imports"."id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb' LIMIT 1
(0.000714s) SELECT * FROM "data_imports" WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb') LIMIT 1
(0.000499s) UPDATE "data_imports" SET "data_source" = '', "data_type" = 'external_table', "table_name" = 'shapes_merge', "state" = 'uploading', "success" = false, "logger" = '766
97154-a916-495e-a3b3-826c97b8dea6', "updated_at" = '2016-03-02 18:12:22.372844+0000', "created_at" = '2016-03-02 18:11:54.111400+0000', "error_code" = NULL, "queue_id" = NULL, "t
ables_created_count" = NULL, "table_names" = 'shapes_merge', "append" = false, "migrate_table" = NULL, "table_copy" = NULL, "from_query" = 'SELECT shapes.shape_id, shapes.shape_p
t_lat, shapes.shape_pt_lon, shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL THEN shapes.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_i
d, trips.service_id, trips.shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_id FROM shapes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.sha
pe_id))', "synchronization_id" = NULL, "user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476', "table_id" = NULL, "service_name" = NULL, "service_item_id" = NULL, "stats" = '{}', "ty
pe_guessing" = true, "quoted_fields_guessing" = true, "content_guessing" = false, "server" = 'ubuntu-12-04-cartodb-1', "host" = NULL, "upload_host" = 'ubuntu-12-04-cartodb-1', "r
esque_ppid" = 15297, "create_visualization" = false, "visualization_id" = NULL, "user_defined_limits" = '{"twitter_credits_limit":0}', "import_extra_options" = NULL, "original_ur
l" = '', "privacy" = NULL, "cartodbfy_time" = 0.0, "http_response_code" = NULL, "rejected_layers" = NULL, "runner_warnings" = NULL WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7
cebb')
(0.000397s) SELECT * FROM "data_imports" WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb') LIMIT 1
(0.000664s) UPDATE "data_imports" SET "data_source" = '', "data_type" = 'external_table', "table_name" = 'shapes_merge', "state" = 'uploading', "success" = false, "logger" = '766
97154-a916-495e-a3b3-826c97b8dea6', "updated_at" = '2016-03-02 18:12:22.375412+0000', "created_at" = '2016-03-02 18:11:54.111400+0000', "error_code" = NULL, "queue_id" = NULL, "t
ables_created_count" = NULL, "table_names" = 'shapes_merge', "append" = false, "migrate_table" = NULL, "table_copy" = NULL, "from_query" = 'SELECT shapes.shape_id, shapes.shape_p
t_lat, shapes.shape_pt_lon, shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL THEN shapes.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_i
d, trips.service_id, trips.shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_id FROM shapes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.sha
pe_id))', "synchronization_id" = NULL, "user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476', "table_id" = NULL, "service_name" = NULL, "service_item_id" = NULL, "stats" = '{}', "ty
pe_guessing" = true, "quoted_fields_guessing" = true, "content_guessing" = false, "server" = 'ubuntu-12-04-cartodb-1', "host" = NULL, "upload_host" = 'ubuntu-12-04-cartodb-1', "r
esque_ppid" = 15297, "create_visualization" = false, "visualization_id" = NULL, "user_defined_limits" = '{"twitter_credits_limit":0}', "import_extra_options" = NULL, "original_ur
l" = '', "privacy" = NULL, "cartodbfy_time" = 0.0, "http_response_code" = NULL, "rejected_layers" = NULL, "runner_warnings" = NULL WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7
cebb')
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.002727s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.001256s)
SELECT DISTINCT ST_GeometryType(the_geom) FROM (
SELECT the_geom
FROM "development"."shapes_merge"
WHERE (the_geom is not null) LIMIT 10
) as foo
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.000559s) select GeometryType(the_geom) FROM "development"."shapes_merge" where the_geom is not null limit 1
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:postgres:sequel (2)
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.001265s)
SELECT c.conname AS pk_name
FROM pg_class r, pg_constraint c, pg_namespace n
WHERE r.oid = c.conrelid AND contype='p' AND relname = 'shapes_merge'
AND r.relnamespace = n.oid and n.nspname= 'development'
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.003344s) SELECT "pg_attribute"."attname" AS "name", CAST("pg_attribute"."atttypid" AS integer) AS "oid", format_type("pg_type"."oid", "pg_attribute"."atttypmod") AS "db_type",
pg_get_expr("pg_attrdef"."adbin", "pg_class"."oid") AS "default", NOT "pg_attribute"."attnotnull" AS "allow_null", COALESCE(("pg_attribute"."attnum" = ANY("pg_index"."indkey")),
false) AS "primary_key", "pg_namespace"."nspname" FROM "pg_class" INNER JOIN "pg_attribute" ON ("pg_attribute"."attrelid" = "pg_class"."oid") INNER JOIN "pg_type" ON ("pg_type".
"oid" = "pg_attribute"."atttypid") INNER JOIN "pg_namespace" ON ("pg_namespace"."oid" = "pg_class"."relnamespace") LEFT OUTER JOIN "pg_attrdef" ON (("pg_attrdef"."adrelid" = "pg_
class"."oid") AND ("pg_attrdef"."adnum" = "pg_attribute"."attnum")) LEFT OUTER JOIN "pg_index" ON (("pg_index"."indrelid" = "pg_class"."oid") AND ("pg_index"."indisprimary" IS TR
UE)) WHERE (("pg_attribute"."attisdropped" IS FALSE) AND ("pg_attribute"."attnum" > 0) AND ("pg_class"."relname" = 'shapes_merge') AND ("pg_namespace"."nspname" = 'development'))
ORDER BY "pg_attribute"."attnum"
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
Started GET "/user/development/api/v1/imports/ef49baeb-53c3-4b1d-8496-36d5b4e7cebb" for 10.125.0.2 at 2016-03-02 18:17:22 +0000
Processing by Carto::Api::ImportsController#show as JSON
Parameters: {"user_domain"=>"development", "id"=>"ef49baeb-53c3-4b1d-8496-36d5b4e7cebb"}
(0.000768s) SELECT * FROM "users" WHERE ("username" = 'development') LIMIT 1
Completed 200 OK in 5.7ms (Views: 0.8ms | Models: 0.0ms)
Carto::DataImport Load (1.0ms) SELECT "data_imports".* FROM "data_imports" WHERE "data_imports"."id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb' LIMIT 1
PG::Error: ERROR: canceling statement due to statement timeout
CONTEXT: SQL statement "CREATE INDEX ON shapes_merge USING GIST (the_geom_webmercator)"
PL/pgSQL function _cdb_sql(text,text) line 5 at EXECUTE statement
SQL statement "SELECT _CDB_SQL(sql, '_CDB_Add_Indexes')"
PL/pgSQL function _cdb_add_indexes(regclass) line 89 at PERFORM
SQL statement "SELECT _CDB_Add_Indexes(destoid)"
PL/pgSQL function cdb_cartodbfytable(text,regclass) line 57 at PERFORM:
SELECT cartodb.CDB_CartodbfyTable('development'::TEXT,'development.shapes_merge'::REGCLASS);
[table#create error] === #<Sequel::DatabaseError: PG::Error: ERROR: canceling statement due to statement timeout
CONTEXT: SQL statement "CREATE INDEX ON shapes_merge USING GIST (the_geom_webmercator)"
PL/pgSQL function _cdb_sql(text,text) line 5 at EXECUTE statement
SQL statement "SELECT _CDB_SQL(sql, '_CDB_Add_Indexes')"
PL/pgSQL function _cdb_add_indexes(regclass) line 89 at PERFORM
SQL statement "SELECT _CDB_Add_Indexes(destoid)"
PL/pgSQL function cdb_cartodbfytable(text,regclass) line 57 at PERFORM
>
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:postgres:sequel (2)
[pool] Found a connection for localhost:cartodb_dev_user_86de79d4-2177-4d21-a8aa-790c564c9476_db:development_cartodb_user_86de79d4-2177-4d21-a8aa-790c564c9476:sequel (2)
(0.000501s) SELECT '"development"."shapes_merge"'::regclass::oid
(0.000615s) DROP SEQUENCE IF EXISTS cartodb_id_40003_seq
(0.258990s) DROP TABLE IF EXISTS "development"."shapes_merge"
(0.000290s) ROLLBACK
(0.000225s) BEGIN
(0.000541s) UPDATE "logs" SET "type" = 'import', "user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476', "created_at" = '2016-03-02 18:11:54.105376+0000', "updated_at" = '2016-03-02
18:17:23.110442+0000', "entries" = '2016-03-02 18:11:55 UTC: Running on server ubuntu-12-04-cartodb-1 with PID: 18564
2016-03-02 18:11:55 UTC: from_table()
2016-03-02 18:11:55 UTC: import_from_query()
2016-03-02 18:12:19 UTC: migrate_existing()
2016-03-02 18:12:19 UTC: Table valid
2016-03-02 18:17:23 UTC: Going to set merge error with code 8003
2016-03-02 18:17:23 UTC: Additional error info: PG::Error: ERROR: canceling statement due to statement timeout
CONTEXT: SQL statement "CREATE INDEX ON shapes_merge USING GIST (the_geom_webmercator)"
PL/pgSQL function _cdb_sql(text,text) line 5 at EXECUTE statement
SQL statement
2016-03-02 18:17:23 UTC: After dispatch
2016-03-02 18:17:23 UTC: ERROR!
' WHERE ("id" = '76697154-a916-495e-a3b3-826c97b8dea6')
(0.007112s) COMMIT
(0.000087s) BEGIN
(0.001496s) UPDATE "data_imports" SET "data_source" = '', "data_type" = 'query', "table_name" = 'shapes_merge', "state" = 'failure', "success" = false, "logger" = '76697154-a916-
495e-a3b3-826c97b8dea6', "updated_at" = '2016-03-02 18:17:23.119039+0000', "created_at" = '2016-03-02 18:11:54.111400+0000', "error_code" = 8003, "queue_id" = NULL, "tables_creat
ed_count" = NULL, "table_names" = 'shapes_merge', "append" = false, "migrate_table" = NULL, "table_copy" = NULL, "from_query" = 'SELECT shapes.shape_id, shapes.shape_pt_lat, shap
es.shape_pt_lon, shapes.shape_pt_sequence, CASE WHEN trips.the_geom IS NULL THEN shapes.the_geom ELSE trips.the_geom END AS the_geom, trips.direction_id, trips.route_id, trips.se
rvice_id, trips.shape_id AS trips_shape_id, trips.trip_headsign, trips.trip_id FROM shapes FULL OUTER JOIN trips ON LOWER(TRIM(shapes.shape_id)) = LOWER(TRIM(trips.shape_id))', "
synchronization_id" = NULL, "user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476', "table_id" = NULL, "service_name" = NULL, "service_item_id" = NULL, "stats" = '{}', "type_guessing
" = true, "quoted_fields_guessing" = true, "content_guessing" = false, "server" = 'ubuntu-12-04-cartodb-1', "host" = NULL, "upload_host" = 'ubuntu-12-04-cartodb-1', "resque_ppid"
= 15297, "create_visualization" = false, "visualization_id" = NULL, "user_defined_limits" = '{"twitter_credits_limit":0}', "import_extra_options" = NULL, "original_url" = '', "p
rivacy" = NULL, "cartodbfy_time" = 0.0, "http_response_code" = NULL, "rejected_layers" = NULL, "runner_warnings" = NULL WHERE ("id" = 'ef49baeb-53c3-4b1d-8496-36d5b4e7cebb')
(0.004516s) COMMIT
(0.000531s) SELECT * FROM "users" WHERE ("id" = '86de79d4-2177-4d21-a8aa-790c564c9476') LIMIT 1
(0.000089s) BEGIN
(0.000449s) UPDATE "logs" SET "type" = 'import', "user_id" = '86de79d4-2177-4d21-a8aa-790c564c9476', "created_at" = '2016-03-02 18:11:54.105376+0000', "updated_at" = '2016-03-02
18:17:23.134062+0000', "entries" = '2016-03-02 18:11:55 UTC: Running on server ubuntu-12-04-cartodb-1 with PID: 18564
2016-03-02 18:11:55 UTC: from_table()
2016-03-02 18:11:55 UTC: import_from_query()
2016-03-02 18:12:19 UTC: migrate_existing()
2016-03-02 18:12:19 UTC: Table valid
2016-03-02 18:17:23 UTC: Going to set merge error with code 8003
2016-03-02 18:17:23 UTC: Additional error info: PG::Error: ERROR: canceling statement due to statement timeout
CONTEXT: SQL statement "CREATE INDEX ON shapes_merge USING GIST (the_geom_webmercator)"
PL/pgSQL function _cdb_sql(text,text) line 5 at EXECUTE statement
SQL statement
2016-03-02 18:17:23 UTC: After dispatch
2016-03-02 18:17:23 UTC: ERROR!
2016-03-02 18:17:23 UTC: Exception: no implicit conversion of nil into String
2016-03-02 18:17:23 UTC: ["/home/ubuntu/Dev/cartodb/services/importer/lib/importer/mail_notifier.rb:58:in `basename''", "/home/ubuntu/Dev/cartodb/services/importer/lib/importer/m
ail_notifier.rb:58:in `extract_file_names''", "/home/ubuntu/Dev/cartodb/services/importer/lib/importer/mail_notifier.rb:31:in `send!''", "/home/ubuntu/Dev/cartodb/services/import
er/lib/importer/mail_notifier.rb:18:in `notify_if_needed''", "/home/ubuntu/Dev/cartodb/app/models/data_import.rb:818:in `notify''", "/home/ubuntu/Dev/cartodb/app/models/data_impo
rt.rb:336:in `handle_failure''", "/home/ubuntu/Dev/cartodb/app/models/data_import.rb:191:in `run_import!''", "/home/ubuntu/Dev/cartodb/lib/resque/importer_jobs.rb:9:in `block in
perform''", "/home/ubuntu/Dev/cartodb/lib/resque/base_job.rb:21:in `call''", "/home/ubuntu/Dev/cartodb/lib/resque/base_job.rb:21:in `run_action''", "/home/ubuntu/Dev/cartodb/lib/
resque/importer_jobs.rb:9:in `perform''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:240:in `block (3 levels) in perform''", "/opt/rubies/ru
by-2.2.3/lib/ruby/gems/2.2.0/gems/resque-metrics-0.1.1/lib/resque/metrics.rb:353:in `around_perform_metrics''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib
/resque/job.rb:239:in `block (2 levels) in perform''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:247:in `call''", "/opt/rubies/ruby-2.2.3/l
ib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:247:in `perform''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:250:in `perform''"
, "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:189:in `block in work''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib
/resque/worker.rb:166:in `loop''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:166:in `work''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.
0/gems/resque-1.25.2/lib/resque/tasks.rb:41:in `block (2 levels) in <top (required)>''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `ca
ll''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `block in execute''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/l
ib/rake/task.rb:200:in `each''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/ge
ms/rake-0.9.2.2/lib/rake/task.rb:158:in `block in invoke_with_call_chain''", "/opt/rubies/ruby-2.2.3/lib/ruby/2.2.0/monitor.rb:211:in `mon_synchronize''", "/opt/rubies/ruby-2.2.3
/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `
invoke''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9
.2.2/lib/rake/application.rb:94:in `block (2 levels) in top_level''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each''", "/opt/
rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `block in top_level''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/ra
ke/application.rb:133:in `standard_exception_handling''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level''", "/opt/rubies/
ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `block in run''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/applicatio
n.rb:133:in `standard_exception_handling''", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run''", "/opt/rubies/ruby-2.2.3/lib/ruby
/gems/2.2.0/gems/rake-0.9.2.2/bin/rake:33:in `<top (required)>''", "/opt/rubies/ruby-2.2.3/bin/rake:23:in `load''", "/opt/rubies/ruby-2.2.3/bin/rake:23:in `<main>''"]
' WHERE ("id" = '76697154-a916-495e-a3b3-826c97b8dea6')
(0.004086s) COMMIT
2016-03-02 18:11:55 UTC: Running on server ubuntu-12-04-cartodb-1 with PID: 18564
2016-03-02 18:11:55 UTC: from_table()
2016-03-02 18:11:55 UTC: import_from_query()
2016-03-02 18:12:19 UTC: migrate_existing()
2016-03-02 18:12:19 UTC: Table valid
2016-03-02 18:17:23 UTC: Going to set merge error with code 8003
2016-03-02 18:17:23 UTC: Additional error info: PG::Error: ERROR: canceling statement due to statement timeout
CONTEXT: SQL statement "CREATE INDEX ON shapes_merge USING GIST (the_geom_webmercator)"
PL/pgSQL function _cdb_sql(text,text) line 5 at EXECUTE statement
SQL statement
2016-03-02 18:17:23 UTC: After dispatch
2016-03-02 18:17:23 UTC: ERROR!
2016-03-02 18:17:23 UTC: Exception: no implicit conversion of nil into String
2016-03-02 18:17:23 UTC: ["/home/ubuntu/Dev/cartodb/services/importer/lib/importer/mail_notifier.rb:58:in `basename'", "/home/ubuntu/Dev/cartodb/services/importer/lib/importer/ma
il_notifier.rb:58:in `extract_file_names'", "/home/ubuntu/Dev/cartodb/services/importer/lib/importer/mail_notifier.rb:31:in `send!'", "/home/ubuntu/Dev/cartodb/services/importer/
lib/importer/mail_notifier.rb:18:in `notify_if_needed'", "/home/ubuntu/Dev/cartodb/app/models/data_import.rb:818:in `notify'", "/home/ubuntu/Dev/cartodb/app/models/data_import.rb
:336:in `handle_failure'", "/home/ubuntu/Dev/cartodb/app/models/data_import.rb:191:in `run_import!'", "/home/ubuntu/Dev/cartodb/lib/resque/importer_jobs.rb:9:in `block in perform
'", "/home/ubuntu/Dev/cartodb/lib/resque/base_job.rb:21:in `call'", "/home/ubuntu/Dev/cartodb/lib/resque/base_job.rb:21:in `run_action'", "/home/ubuntu/Dev/cartodb/lib/resque/imp
orter_jobs.rb:9:in `perform'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:240:in `block (3 levels) in perform'", "/opt/rubies/ruby-2.2.3/lib
/ruby/gems/2.2.0/gems/resque-metrics-0.1.1/lib/resque/metrics.rb:353:in `around_perform_metrics'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/job.r
b:239:in `block (2 levels) in perform'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:247:in `call'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.
2.0/gems/resque-1.25.2/lib/resque/job.rb:247:in `perform'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:250:in `perform'", "/opt/rubies/ru
by-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:189:in `block in work'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:
166:in `loop'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:166:in `work'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/resque-1.25.2
/lib/resque/tasks.rb:41:in `block (2 levels) in <top (required)>'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'", "/opt/rubies/ru
by-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `block in execute'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:200:in
`each'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/
task.rb:158:in `block in invoke_with_call_chain'", "/opt/rubies/ruby-2.2.3/lib/ruby/2.2.0/monitor.rb:211:in `mon_synchronize'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/r
ake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'", "/opt/rubies/ruby-
2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:9
4:in `block (2 levels) in top_level'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/
2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `block in top_level'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standar
d_exception_handling'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems
/rake-0.9.2.2/lib/rake/application.rb:66:in `block in run'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_hand
ling'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'", "/opt/rubies/ruby-2.2.3/lib/ruby/gems/2.2.0/gems/rake-0.9.2.2/bin/rake
:33:in `<top (required)>'", "/opt/rubies/ruby-2.2.3/bin/rake:23:in `load'", "/opt/rubies/ruby-2.2.3/bin/rake:23:in `<main>'"]
===LOG END===
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment