job- ---- time start: 2025-06-05 03:16:25---- ---- TASK START ---- Starting GDB import process Dataset created||{"id":55,"schema":"dataset_55","display_name":"T91_CSDL_KG_024.gdb"} Schema created||{"schema":"dataset_55"} ZIP file extracted||{"extractPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87"} Found GDB file||{"gdbPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87\/T91_CSDL_KG_024.gdb"} Run ogrinfo||{"extractPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87"} Executing command||{"command":"\"\/usr\/bin\/ogrinfo\" -ro -q \"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87\/T91_CSDL_KG_024.gdb\""} ogrinfo process completed||{"return_code":0,"result":"5: CELL_CCN_font_point (3D Point)","output":["1: DVHC cap huyen_region (3D Polygon)","2: KHU XU LY CTR_text (3D Point)","3: KHU XU LY CTR_font_point (3D Point)","4: CELL_CCN_text (3D Point)","5: CELL_CCN_font_point (3D Point)"]} ogrinfo process completed||{"layers":[]} Run ogr2ogr||{"extractPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87"} Executing command||{"command":"\"\/usr\/bin\/ogr2ogr\" -f \"PostgreSQL\" \"PG:host=127.0.0.1 port=5432 dbname=webgis user=postgres password=**** \"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87\/T91_CSDL_KG_024.gdb\" -lco SCHEMA=dataset_55 -skipfailures -progress -lco OVERWRITE=YES -lco GEOMETRY_NAME=geom"} ogr2ogr process completed||{"result":"0...10...20..","output":["0...10...20.."]} ogr2ogr execution completed Found tables in schema||{"count":5,"table":["dvhc cap huyen_region","khu xu ly ctr_text","khu xu ly ctr_font_point","cell_ccn_text","cell_ccn_font_point"]} Table created||{"id":2929,"table":"dvhc cap huyen_region","schema":"dataset_55","display_name":"Dvhc Cap Huyen Region"} Table created||{"id":2930,"table":"khu xu ly ctr_text","schema":"dataset_55","display_name":"Khu Xu Ly Ctr Text"} Table created||{"id":2931,"table":"khu xu ly ctr_font_point","schema":"dataset_55","display_name":"Khu Xu Ly Ctr Font Point"} Table created||{"id":2932,"table":"cell_ccn_text","schema":"dataset_55","display_name":"Cell Ccn Text"} Table created||{"id":2933,"table":"cell_ccn_font_point","schema":"dataset_55","display_name":"Cell Ccn Font Point"} srid get: 900914 SRID detected||{"table":"dvhc cap huyen_region","schema":"dataset_55","info":900914} Geometry type detected||{"table":"dvhc cap huyen_region","schema":"dataset_55","info":{"type":"POLYGON"}} Error detecting Bbox||{"table":"dvhc cap huyen_region","schema":"dataset_55","error":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"huyen_region\"\nLINE 8: FROM dataset_55.dvhc cap huyen_region\n ^ (Connection: pgsql, SQL: SELECT\n ST_XMin(ext) AS minX,\n ST_YMin(ext) AS minY,\n ST_XMax(ext) AS maxX,\n ST_YMax(ext) AS maxY\n FROM (\n SELECT ST_Extent(ST_Transform(geom, 4326)) AS ext\n FROM dataset_55.dvhc cap huyen_region\n ) AS bbox;)"} Metadata dvhc cap huyen_region||{"field_id":"ogc_fid","field_name":"ogc_fid"} Table SRID updated||{"id":2929,"old_srid":900914,"new_srid":900914} Fields processed||{"table":"dvhc cap huyen_region","schema":"dataset_55","total":3,"created":2,"updated":0,"deleted":0} srid get: 900914 SRID detected||{"table":"khu xu ly ctr_text","schema":"dataset_55","info":900914} Geometry type detected||{"table":"khu xu ly ctr_text","schema":"dataset_55","info":{"type":"POINT"}} Error detecting Bbox||{"table":"khu xu ly ctr_text","schema":"dataset_55","error":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ly\"\nLINE 8: FROM dataset_55.khu xu ly ctr_text\n ^ (Connection: pgsql, SQL: SELECT\n ST_XMin(ext) AS minX,\n ST_YMin(ext) AS minY,\n ST_XMax(ext) AS maxX,\n ST_YMax(ext) AS maxY\n FROM (\n SELECT ST_Extent(ST_Transform(geom, 4326)) AS ext\n FROM dataset_55.khu xu ly ctr_text\n ) AS bbox;)"} Metadata khu xu ly ctr_text||{"field_id":"ogc_fid","field_name":"ogc_fid"} Table SRID updated||{"id":2930,"old_srid":900914,"new_srid":900914} Fields processed||{"table":"khu xu ly ctr_text","schema":"dataset_55","total":6,"created":5,"updated":0,"deleted":0} srid get: 900914 SRID detected||{"table":"khu xu ly ctr_font_point","schema":"dataset_55","info":900914} Geometry type detected||{"table":"khu xu ly ctr_font_point","schema":"dataset_55","info":{"type":"POINT"}} Error detecting Bbox||{"table":"khu xu ly ctr_font_point","schema":"dataset_55","error":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ly\"\nLINE 8: FROM dataset_55.khu xu ly ctr_font_point\n ^ (Connection: pgsql, SQL: SELECT\n ST_XMin(ext) AS minX,\n ST_YMin(ext) AS minY,\n ST_XMax(ext) AS maxX,\n ST_YMax(ext) AS maxY\n FROM (\n SELECT ST_Extent(ST_Transform(geom, 4326)) AS ext\n FROM dataset_55.khu xu ly ctr_font_point\n ) AS bbox;)"} Metadata khu xu ly ctr_font_point||{"field_id":"ogc_fid","field_name":"ogc_fid"} Table SRID updated||{"id":2931,"old_srid":900914,"new_srid":900914} Fields processed||{"table":"khu xu ly ctr_font_point","schema":"dataset_55","total":3,"created":2,"updated":0,"deleted":0} srid get: 900914 SRID detected||{"table":"cell_ccn_text","schema":"dataset_55","info":900914} Geometry type detected||{"table":"cell_ccn_text","schema":"dataset_55","info":{"type":"POINT"}} Bbox detected||{"table":"cell_ccn_text","schema":"dataset_55","bbox":{"minx":null,"miny":null,"maxx":null,"maxy":null}} Bbox detected||{"table":"cell_ccn_text","schema":"dataset_55","bbox":[0,0,0,0]} Metadata cell_ccn_text||{"bbox":[0,0,0,0],"field_id":"ogc_fid","field_name":"ogc_fid"} Table SRID updated||{"id":2932,"old_srid":900914,"new_srid":900914} Fields processed||{"table":"cell_ccn_text","schema":"dataset_55","total":11,"created":10,"updated":0,"deleted":0} srid get: 900914 SRID detected||{"table":"cell_ccn_font_point","schema":"dataset_55","info":900914} Geometry type detected||{"table":"cell_ccn_font_point","schema":"dataset_55","info":{"type":"POINT"}} Bbox detected||{"table":"cell_ccn_font_point","schema":"dataset_55","bbox":{"minx":null,"miny":null,"maxx":null,"maxy":null}} Bbox detected||{"table":"cell_ccn_font_point","schema":"dataset_55","bbox":[0,0,0,0]} Metadata cell_ccn_font_point||{"bbox":[0,0,0,0],"field_id":"ogc_fid","field_name":"ogc_fid"} Table SRID updated||{"id":2933,"old_srid":900914,"new_srid":900914} Fields processed||{"table":"cell_ccn_font_point","schema":"dataset_55","total":8,"created":7,"updated":0,"deleted":0} Cleanup||["\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87","\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/818e0eab-0a17-4c21-aee4-e3653ace9a87\/T91_CSDL_KG_024.gdb.zip"] Cleanup completed Create vector tile view Found tables in schema||{"count":5} Processing table dvhc cap huyen_region||{"columns":3,"count":11} Processing table 1 of 5: dvhc cap huyen_region Processing table khu xu ly ctr_text||{"columns":6,"count":0} Processing table 2 of 5: khu xu ly ctr_text Processing table khu xu ly ctr_font_point||{"columns":3,"count":0} Processing table 3 of 5: khu xu ly ctr_font_point Processing table cell_ccn_text||{"columns":11,"count":0} Processing table 4 of 5: cell_ccn_text Processing table cell_ccn_font_point||{"columns":8,"count":0} Processing table 5 of 5: cell_ccn_font_point Creating view||{"view_name":"view_title_55"} Error: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "huyen_region" LINE 2: dvhc cap huyen_region.ogc_fid || '-'... ^ (Connection: pgsql, SQL: CREATE MATERIALIZED VIEW dataset_55.view_title_55 AS SELECT dvhc cap huyen_region.ogc_fid || '-' || '2929' as id, dvhc cap huyen_region.ogc_fid::text as name, dvhc cap huyen_region.ogc_fid::text as feature_id, '2929' as dataset_table_id, 'dvhc cap huyen_region' as layer_name, jsonb_build_object('properties.ogc_fid', "ogc_fid", 'properties.id', "id") as properties, CASE WHEN ST_SRID(geom) = 0 THEN ST_SetSRID(geom, 3857) ELSE ST_Transform(geom, 3857) END as geom FROM dataset_55.dvhc cap huyen_region UNION ALL SELECT khu xu ly ctr_text.ogc_fid || '-' || '2930' as id, khu xu ly ctr_text.ogc_fid::text as name, khu xu ly ctr_text.ogc_fid::text as feature_id, '2930' as dataset_table_id, 'khu xu ly ctr_text' as layer_name, jsonb_build_object('properties.ogc_fid', "ogc_fid", 'properties.text_angle', "text_angle", 'properties.text_size', "text_size", 'properties.textstring', "textstring", 'properties.id', "id") as properties, CASE WHEN ST_SRID(geom) = 0 THEN ST_SetSRID(geom, 3857) ELSE ST_Transform(geom, 3857) END as geom FROM dataset_55.khu xu ly ctr_text UNION ALL SELECT khu xu ly ctr_font_point.ogc_fid || '-' || '2931' as id, khu xu ly ctr_font_point.ogc_fid::text as name, khu xu ly ctr_font_point.ogc_fid::text as feature_id, '2931' as dataset_table_id, 'khu xu ly ctr_font_point' as layer_name, jsonb_build_object('properties.ogc_fid', "ogc_fid", 'properties.id', "id") as properties, CASE WHEN ST_SRID(geom) = 0 THEN ST_SetSRID(geom, 3857) ELSE ST_Transform(geom, 3857) END as geom FROM dataset_55.khu xu ly ctr_font_point UNION ALL SELECT cell_ccn_text.ogc_fid || '-' || '2932' as id, cell_ccn_text.ogc_fid::text as name, cell_ccn_text.ogc_fid::text as feature_id, '2932' as dataset_table_id, 'cell_ccn_text' as layer_name, jsonb_build_object('properties.ogc_fid', "ogc_fid", 'properties.text_angle', "text_angle", 'properties.text_size', "text_size", 'properties.textstring', "textstring", 'properties.id', "id", 'properties.ten_kccn', "ten_kccn", 'properties.dt', "dt", 'properties.xa', "xa", 'properties.huyen', "huyen", 'properties.tinhchat', "tinhchat") as properties, CASE WHEN ST_SRID(geom) = 0 THEN ST_SetSRID(geom, 3857) ELSE ST_Transform(geom, 3857) END as geom FROM dataset_55.cell_ccn_text UNION ALL SELECT cell_ccn_font_point.ogc_fid || '-' || '2933' as id, cell_ccn_font_point.ogc_fid::text as name, cell_ccn_font_point.ogc_fid::text as feature_id, '2933' as dataset_table_id, 'cell_ccn_font_point' as layer_name, jsonb_build_object('properties.ogc_fid', "ogc_fid", 'properties.id', "id", 'properties.ten_kccn', "ten_kccn", 'properties.dt', "dt", 'properties.xa', "xa", 'properties.huyen', "huyen", 'properties.tinhchat', "tinhchat") as properties, CASE WHEN ST_SRID(geom) = 0 THEN ST_SetSRID(geom, 3857) ELSE ST_Transform(geom, 3857) END as geom FROM dataset_55.cell_ccn_font_point) ---- time end: 2025-06-05 03:16:27---- ---- TASK ERROR ----