Created
March 2, 2016 18:18
-
-
Save andrewSC/cb4ddc7a3f438baed525 to your computer and use it in GitHub Desktop.
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
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