hello! I am trying start martin with post 3.0. but everytime i try access .pbf endpoint, it returned err 500 like that
nguyenmanhcuong@NGUYENs-MacBook-Pro ~ % curl -i localhost:3000/import.giao-thong/0/0/0.pbf HTTP/1.1 500 Internal Server Error content-length: 0 access-control-allow-origin: * date: Tue, 07 Apr 2020 09:02:55 GMT
I have run martin tin DEBUG mode and this was the result. help me pls:
nguyenmanhcuong@NGUYENs-MacBook-Pro ~ % export RUST_LOG=actix_web=info,martin=debug,postgres=debug martin postgres://nguyenmanhcuong:123456@localhost/gis [2020-04-07T08:38:24Z INFO martin] Starting martin v0.5.0 [2020-04-07T08:38:24Z INFO martin] Config is not set, scanning database [2020-04-07T08:38:24Z INFO martin] Connected to postgres://nguyenmanhcuong:123456@localhost/gis [2020-04-07T08:38:24Z DEBUG postgres] executing query: [2020-04-07T08:38:24Z DEBUG postgres] preparing query with name ``: WITH columns AS ( SELECT ns.nspname AS table_schema, class.relname AS table_name, attr.attname AS column_name, trim(leading '_' from tp.typname) AS type_name FROM pg_attribute attr JOIN pg_catalog.pg_class AS class ON class.oid = attr.attrelid JOIN pg_catalog.pg_namespace AS ns ON ns.oid = class.relnamespace JOIN pg_catalog.pg_type AS tp ON tp.oid = attr.atttypid WHERE NOT attr.attisdropped AND attr.attnum > 0) SELECT f_table_schema, f_table_name, f_geometry_column, srid, type, COALESCE( jsonb_object_agg(columns.column_name, columns.type_name) FILTER (WHERE columns.column_name IS NOT NULL), '{}'::jsonb ) as properties FROM geometry_columns LEFT JOIN columns ON geometry_columns.f_table_schema = columns.table_schema AND geometry_columns.f_table_name = columns.table_name AND geometry_columns.f_geometry_column != columns.column_name GROUP BY f_table_schema, f_table_name, f_geometry_column, srid, type; [2020-04-07T08:38:24Z DEBUG postgres] executing statement with parameters: [] [2020-04-07T08:38:25Z INFO martin::table_source] Found OSM.2017-07-03_vietnam_ho-chi-minh-city table source [2020-04-07T08:38:25Z INFO martin::table_source] Found OSM.2017-07-03_vietnam_ho-chi-minh-city transportation_name table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.10 table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.14 table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.22 table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.28 table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.Added geom info table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.Centroids table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.Joined layer table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.geocoding table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.giao-thong table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.logioiline table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.mepDuong table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.nen table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.pncenter table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.pndc table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.road table source [2020-04-07T08:38:25Z INFO martin::table_source] Found import.xd table source [2020-04-07T08:38:25Z INFO martin::table_source] Found my_topology.edge table source [2020-04-07T08:38:25Z INFO martin::table_source] Found my_topology.edge_data table source [2020-04-07T08:38:25Z INFO martin::table_source] Found my_topology.face table source [2020-04-07T08:38:25Z INFO martin::table_source] Found my_topology.node table source [2020-04-07T08:38:25Z INFO martin::table_source] Found my_topology.p10 table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.beacons table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.beacons_intersect table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.beacons_views table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.bearing_labels table source [2020-04-07T08:38:25Z WARN martin::table_source] public.bearing_labels has SRID 0, skipping [2020-04-07T08:38:25Z INFO martin::table_source] Found public.boundaries table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.boundary_labels table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.derived_boundaries table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.giao-thong table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.hist_beacons table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.ne_10m_admin_0_countries table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.parcel_overlap_matviews table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.parcels table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.parcels_intersect table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.parcels_line_length table source [2020-04-07T08:38:25Z WARN martin::table_source] public.parcels_line_length has SRID 0, skipping [2020-04-07T08:38:25Z INFO martin::table_source] Found public.parcels_lines table source [2020-04-07T08:38:25Z WARN martin::table_source] public.parcels_lines has SRID 0, skipping [2020-04-07T08:38:25Z INFO martin::table_source] Found public.perimeters table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.perimeters_original table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.pndc table source [2020-04-07T08:38:25Z INFO martin::table_source] Found public.reference_view table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.addrfeat table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.bg table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.county table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.cousub table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.edges table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.faces table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.place table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.state table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.tabblock table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.tract table source [2020-04-07T08:38:25Z INFO martin::table_source] Found tiger.zcta5 table source [2020-04-07T08:38:25Z DEBUG postgres] preparing query with name ``: SELECT routines.specific_schema, routines.routine_name FROM information_schema.routines LEFT JOIN information_schema.parameters ON routines.specific_name=parameters.specific_name WHERE routines.data_type = 'bytea' GROUP BY routines.specific_schema, routines.routine_name, routines.data_type HAVING array_agg(array[parameters.parameter_name::text, parameters.data_type::text]) @> array[array['z', 'integer'], array['x', 'integer'], array['y', 'integer'], array['query_params', 'json']]; [2020-04-07T08:38:25Z DEBUG postgres] executing statement with parameters: [] [2020-04-07T08:38:25Z DEBUG postgres] executing query: [2020-04-07T08:38:25Z DEBUG postgres] preparing query with name ``: select (regexp_matches(postgis_lib_version(), '^(\d+\.\d+\.\d+)', 'g'))[1] as postgis_lib_version [2020-04-07T08:38:25Z DEBUG postgres] executing statement with parameters: [] [2020-04-07T08:38:25Z INFO martin] Martin has been started on 0.0.0.0:3000. [2020-04-07T08:39:18Z INFO actix_web::middleware::logger] 127.0.0.1:49385 "GET /index.json HTTP/1.1" 200 29455 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36" 0.012087 [2020-04-07T08:39:18Z INFO actix_web::middleware::logger] 127.0.0.1:49385 "GET /favicon.ico HTTP/1.1" 404 0 "http://localhost:3000/index.json" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36" 0.000102 [2020-04-07T08:39:58Z DEBUG postgres] executing query: [2020-04-07T08:39:58Z DEBUG postgres] preparing query with name ``: WITH bounds AS (SELECT ST_MakeEnvelope(11876479.705184326, 1210151.0316424556, 11877091.201410523, 1209539.5354162594, 3857) as mercator, ST_Transform(ST_MakeEnvelope(11876479.705184326, 1210151.0316424556, 11877091.201410523, 1209539.5354162594, 3857), 4326) as original) SELECT ST_AsMVT(tile, 'import.10', 4096, 'geom' ) FROM ( SELECT ST_AsMVTGeom(ST_Transform(geom, 3857), bounds.mercator, 4096, 64, true) AS geom , "10_id","id","length" FROM import.10, bounds WHERE geom && bounds.original ) AS tile WHERE geom IS NOT NULL [2020-04-07T08:39:58Z INFO actix_web::middleware::logger] 127.0.0.1:49418 "GET /import.10/16/52190/30789.pbf HTTP/1.1" 500 0 "-" "PostmanRuntime/7.24.0" 0.033219 [2020-04-07T08:40:00Z DEBUG postgres] executing query: [2020-04-07T08:40:00Z DEBUG postgres] preparing query with name ``: WITH bounds AS (SELECT ST_MakeEnvelope(11876479.705184326, 1210151.0316424556, 11877091.201410523, 1209539.5354162594, 3857) as mercator, ST_Transform(ST_MakeEnvelope(11876479.705184326, 1210151.0316424556, 11877091.201410523, 1209539.5354162594, 3857), 4326) as original) SELECT ST_AsMVT(tile, 'import.10', 4096, 'geom' ) FROM ( SELECT ST_AsMVTGeom(ST_Transform(geom, 3857), bounds.mercator, 4096, 64, true) AS geom , "10_id","id","length" FROM import.10, bounds WHERE geom && bounds.original ) AS tile WHERE geom IS NOT NULL [2020-04-07T08:40:00Z INFO actix_web::middleware::logger] 127.0.0.1:49418 "GET /import.10/16/52190/30789.pbf HTTP/1.1" 500 0 "-" "PostmanRuntime/7.24.0" 0.000931 [2020-04-07T08:40:20Z INFO actix_web::middleware::logger] 127.0.0.1:49418 "GET /index.json HTTP/1.1" 200 29455 "-" "PostmanRuntime/7.24.0" 0.005915 [2020-04-07T08:41:02Z INFO actix_web::middleware::logger] 127.0.0.1:49418 "GET /import.giao-thong.json HTTP/1.1" 200 317 "-" "PostmanRuntime/7.24.0" 0.001562 [2020-04-07T08:41:05Z INFO actix_web::middleware::logger] 127.0.0.1:49442 "GET /import.giao-thong/%7Bz%7D/%7Bx%7D/%7By%7D.pbf HTTP/1.1" 404 28 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36" 0.003709 [2020-04-07T08:41:22Z DEBUG postgres] executing query: [2020-04-07T08:41:22Z DEBUG postgres] preparing query with name ``: WITH bounds AS (SELECT ST_MakeEnvelope(-20037508.34, 20037508.34, 20037508.34, -20037508.34, 3857) as mercator, ST_Transform(ST_MakeEnvelope(-20037508.34, 20037508.34, 20037508.34, -20037508.34, 3857), 4326) as original) SELECT ST_AsMVT(tile, 'import.giao-thong', 4096, 'geom' ) FROM ( SELECT ST_AsMVTGeom(ST_Transform(geom, 3857), bounds.mercator, 4096, 64, true) AS geom , "name_ja","name_tr","name_th","name_he","name_uk","name_kn","name_sr-la","name_de_1","name_gd","name_ga","name_de","name_hy","name_bs","name_ka","name_lv","name_be","name_sr","name_ja_rm","name_ko_rm","name_mt","name_ru","name_nonla","name_latin","name_sl","name_ro","name_sk","ref","name_az","name_int","name_ca","name_br","name_fi","name_fr","name","name_nl","name_ja_ka","name_bg","name_pl","name_zh","name_sv","ref_length","name_is","name_fy","name_en_1","name_el","name_et","class","name_la","network","name_lt","name_mk","name_ar","name_es","name_cy","name_lb","name_pt","name_it","name_ko","name_cs","name_en","name_rm","name_sq","name_hu","id","mvt_id","name_hr","name_da","name_kk","name_no" FROM import.giao-thong, bounds WHERE geom && bounds.original ) AS tile WHERE geom IS NOT NULL [2020-04-07T08:41:22Z INFO actix_web::middleware::logger] 127.0.0.1:49442 "GET /import.giao-thong/0/0/0.pbf HTTP/1.1" 500 0 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36" 0.006816 [2020-04-07T09:02:55Z DEBUG postgres] executing query: [2020-04-07T09:02:55Z DEBUG postgres] preparing query with name ``: WITH bounds AS (SELECT ST_MakeEnvelope(-20037508.34, 20037508.34, 20037508.34, -20037508.34, 3857) as mercator, ST_Transform(ST_MakeEnvelope(-20037508.34, 20037508.34, 20037508.34, -20037508.34, 3857), 4326) as original) SELECT ST_AsMVT(tile, 'import.giao-thong', 4096, 'geom' ) FROM ( SELECT ST_AsMVTGeom(ST_Transform(geom, 3857), bounds.mercator, 4096, 64, true) AS geom , "name_ja","name_tr","name_th","name_he","name_uk","name_kn","name_sr-la","name_de_1","name_gd","name_ga","name_de","name_hy","name_bs","name_ka","name_lv","name_be","name_sr","name_ja_rm","name_ko_rm","name_mt","name_ru","name_nonla","name_latin","name_sl","name_ro","name_sk","ref","name_az","name_int","name_ca","name_br","name_fi","name_fr","name","name_nl","name_ja_ka","name_bg","name_pl","name_zh","name_sv","ref_length","name_is","name_fy","name_en_1","name_el","name_et","class","name_la","network","name_lt","name_mk","name_ar","name_es","name_cy","name_lb","name_pt","name_it","name_ko","name_cs","name_en","name_rm","name_sq","name_hu","id","mvt_id","name_hr","name_da","name_kk","name_no" FROM import.giao-thong, bounds WHERE geom && bounds.original ) AS tile WHERE geom IS NOT NULL [2020-04-07T09:02:55Z INFO actix_web::middleware::logger] 127.0.0.1:49641 "GET /import.giao-thong/0/0/0.pbf HTTP/1.1" 500 0 "-" "curl/7.64.1" 0.008419