[TASK][40] Message: job-||{"task_id":40} [TASK][40] Message: ---- time start: 2025-05-28 09:47:03----||{"task_id":40} [TASK][40] Message: ---- TASK START ----||{"task_id":40} [TASK][40] Message: Starting GDB import process||{"task_id":40} [TASK][40] Message: Dataset created||{"task_id":40,"id":41,"schema":"dataset_41","display_name":"CSDL"} [TASK][40] Message: Schema created||{"task_id":40,"schema":"dataset_41"} [TASK][40] Message: ZIP file extracted||{"task_id":40,"extractPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/5c070a02-8b36-4be4-acc3-499363f39be0"} [TASK][40] Message: Found GDB file||{"task_id":40,"gdbPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/5c070a02-8b36-4be4-acc3-499363f39be0\/CSDL\/T91_CSDL_KG_244\/T91_CSDL_KG_024.gdb"} [TASK][40] Message: Run ogrinfo||{"task_id":40,"extractPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/5c070a02-8b36-4be4-acc3-499363f39be0"} [TASK][40] Message: Executing command||{"task_id":40,"command":"\"\/usr\/bin\/ogrinfo\" -ro -q \"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/5c070a02-8b36-4be4-acc3-499363f39be0\/CSDL\/T91_CSDL_KG_244\/T91_CSDL_KG_024.gdb\""} [TASK][40] Message: ogrinfo process completed||{"task_id":40,"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)"]} [TASK][40] Message: ogrinfo process completed||{"task_id":40,"layers":[]} [TASK][40] Message: Run ogr2ogr||{"task_id":40,"extractPath":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/5c070a02-8b36-4be4-acc3-499363f39be0"} [TASK][40] Message: Executing command||{"task_id":40,"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\/5c070a02-8b36-4be4-acc3-499363f39be0\/CSDL\/T91_CSDL_KG_244\/T91_CSDL_KG_024.gdb\" -lco SCHEMA=dataset_41 -skipfailures -progress -lco OVERWRITE=YES -lco GEOMETRY_NAME=geom"} [TASK][40] Message: ogr2ogr process completed||{"task_id":40,"result":"0...10...20..","output":["0...10...20.."]} [TASK][40] Message: ogr2ogr execution completed||{"task_id":40} [TASK][40] Message: Found tables in schema||{"task_id":40,"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"]} [TASK][40] Message: Table created||{"task_id":40,"id":1986,"table":"dvhc cap huyen_region","schema":"dataset_41","display_name":"Dvhc Cap Huyen Region"} [TASK][40] Message: Table created||{"task_id":40,"id":1987,"table":"khu xu ly ctr_text","schema":"dataset_41","display_name":"Khu Xu Ly Ctr Text"} [TASK][40] Message: Table created||{"task_id":40,"id":1988,"table":"khu xu ly ctr_font_point","schema":"dataset_41","display_name":"Khu Xu Ly Ctr Font Point"} [TASK][40] Message: Table created||{"task_id":40,"id":1989,"table":"cell_ccn_text","schema":"dataset_41","display_name":"Cell Ccn Text"} [TASK][40] Message: Table created||{"task_id":40,"id":1990,"table":"cell_ccn_font_point","schema":"dataset_41","display_name":"Cell Ccn Font Point"} [TASK][40] Message: srid get: 900914||{"task_id":40} [TASK][40] Message: SRID detected||{"task_id":40,"table":"dvhc cap huyen_region","schema":"dataset_41","info":900914} [TASK][40] Message: Geometry type detected||{"task_id":40,"table":"dvhc cap huyen_region","schema":"dataset_41","info":{"type":"POLYGON"}} [TASK][40] Message: Error detecting Bbox||{"task_id":40,"table":"dvhc cap huyen_region","schema":"dataset_41","error":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"huyen_region\"\nLINE 8: FROM dataset_41.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_41.dvhc cap huyen_region\n ) AS bbox;)"} [TASK][40] Message: Table SRID updated||{"task_id":40,"id":1986,"old_srid":900914,"new_srid":900914} [TASK][40] Message: Fields processed||{"task_id":40,"table":"dvhc cap huyen_region","schema":"dataset_41","total":3,"created":2,"updated":0,"deleted":0} [TASK][40] Message: srid get: 900914||{"task_id":40} [TASK][40] Message: SRID detected||{"task_id":40,"table":"khu xu ly ctr_text","schema":"dataset_41","info":900914} [TASK][40] Message: Geometry type detected||{"task_id":40,"table":"khu xu ly ctr_text","schema":"dataset_41","info":{"type":"POINT"}} [TASK][40] Message: Error detecting Bbox||{"task_id":40,"table":"khu xu ly ctr_text","schema":"dataset_41","error":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ly\"\nLINE 8: FROM dataset_41.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_41.khu xu ly ctr_text\n ) AS bbox;)"} [TASK][40] Message: Table SRID updated||{"task_id":40,"id":1987,"old_srid":900914,"new_srid":900914} [TASK][40] Message: Fields processed||{"task_id":40,"table":"khu xu ly ctr_text","schema":"dataset_41","total":6,"created":5,"updated":0,"deleted":0} [TASK][40] Message: srid get: 900914||{"task_id":40} [TASK][40] Message: SRID detected||{"task_id":40,"table":"khu xu ly ctr_font_point","schema":"dataset_41","info":900914} [TASK][40] Message: Geometry type detected||{"task_id":40,"table":"khu xu ly ctr_font_point","schema":"dataset_41","info":{"type":"POINT"}} [TASK][40] Message: Error detecting Bbox||{"task_id":40,"table":"khu xu ly ctr_font_point","schema":"dataset_41","error":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ly\"\nLINE 8: FROM dataset_41.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_41.khu xu ly ctr_font_point\n ) AS bbox;)"} [TASK][40] Message: Table SRID updated||{"task_id":40,"id":1988,"old_srid":900914,"new_srid":900914} [TASK][40] Message: Fields processed||{"task_id":40,"table":"khu xu ly ctr_font_point","schema":"dataset_41","total":3,"created":2,"updated":0,"deleted":0} [TASK][40] Message: srid get: 900914||{"task_id":40} [TASK][40] Message: SRID detected||{"task_id":40,"table":"cell_ccn_text","schema":"dataset_41","info":900914} [TASK][40] Message: Geometry type detected||{"task_id":40,"table":"cell_ccn_text","schema":"dataset_41","info":{"type":"POINT"}} [TASK][40] Message: Bbox detected||{"task_id":40,"table":"cell_ccn_text","schema":"dataset_41","bbox":{"minx":null,"miny":null,"maxx":null,"maxy":null}} [TASK][40] Message: Bbox detected||{"task_id":40,"table":"cell_ccn_text","schema":"dataset_41","bbox":[0,0,0,0]} [TASK][40] Message: Table SRID updated||{"task_id":40,"id":1989,"old_srid":900914,"new_srid":900914} [TASK][40] Message: Fields processed||{"task_id":40,"table":"cell_ccn_text","schema":"dataset_41","total":11,"created":10,"updated":0,"deleted":0} [TASK][40] Message: srid get: 900914||{"task_id":40} [TASK][40] Message: SRID detected||{"task_id":40,"table":"cell_ccn_font_point","schema":"dataset_41","info":900914} [TASK][40] Message: Geometry type detected||{"task_id":40,"table":"cell_ccn_font_point","schema":"dataset_41","info":{"type":"POINT"}} [TASK][40] Message: Bbox detected||{"task_id":40,"table":"cell_ccn_font_point","schema":"dataset_41","bbox":{"minx":null,"miny":null,"maxx":null,"maxy":null}} [TASK][40] Message: Bbox detected||{"task_id":40,"table":"cell_ccn_font_point","schema":"dataset_41","bbox":[0,0,0,0]} [TASK][40] Message: Table SRID updated||{"task_id":40,"id":1990,"old_srid":900914,"new_srid":900914} [TASK][40] Message: Fields processed||{"task_id":40,"table":"cell_ccn_font_point","schema":"dataset_41","total":8,"created":7,"updated":0,"deleted":0} [TASK][40] Message: Cleanup||{"task_id":40,"0":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/5c070a02-8b36-4be4-acc3-499363f39be0","1":"\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/5c070a02-8b36-4be4-acc3-499363f39be0\/CSDL.zip"} [TASK][40] Message: Cleanup completed||{"task_id":40} [TASK][40] Message: Create vector tile view||{"task_id":40} [TASK][40] Message: Found tables in schema||{"task_id":40,"count":5} [TASK][40] Message: Processing table||{"task_id":40,"table":"dvhc cap huyen_region","columns":3} [TASK][40] Message: Processing table 1 of 5: dvhc cap huyen_region||{"task_id":40} [TASK][40] Message: Processing table||{"task_id":40,"table":"khu xu ly ctr_text","columns":6} [TASK][40] Message: Processing table 2 of 5: khu xu ly ctr_text||{"task_id":40} [TASK][40] Message: Processing table||{"task_id":40,"table":"khu xu ly ctr_font_point","columns":3} [TASK][40] Message: Processing table 3 of 5: khu xu ly ctr_font_point||{"task_id":40} [TASK][40] Message: Processing table||{"task_id":40,"table":"cell_ccn_text","columns":11} [TASK][40] Message: Processing table 4 of 5: cell_ccn_text||{"task_id":40} [TASK][40] Message: Processing table||{"task_id":40,"table":"cell_ccn_font_point","columns":8} [TASK][40] Message: Processing table 5 of 5: cell_ccn_font_point||{"task_id":40} [TASK][40] Message: Creating view||{"task_id":40,"view_name":"view_title_41"} PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "huyen_region" LINE 2: dvhc cap huyen_region.ogc_fid || '-'... ^ in /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php:587 Stack trace: #0 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(587): PDOStatement->execute() #1 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #3 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(576): Illuminate\Database\Connection->run() #4 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(509): Illuminate\Database\Connection->statement() #5 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Database\DatabaseManager->__call() #6 /var/www/webgis/backend/app/Traits/DatasetViewProcessingTrait.php(130): Illuminate\Support\Facades\Facade::__callStatic() #7 /var/www/webgis/backend/app/Jobs/ProcessGdbImport.php(116): App\Jobs\ProcessGdbImport->processCreateVectorTileView() #8 /var/www/webgis/backend/app/Jobs/AJob.php(58): App\Jobs\ProcessGdbImport->App\Jobs\{closure}() #9 /var/www/webgis/backend/app/Jobs/ProcessGdbImport.php(36): App\Jobs\AJob->cb_handle() #10 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\ProcessGdbImport->handle() #11 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #12 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #13 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #14 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #15 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call() #16 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}() #17 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then() #19 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\Bus\Dispatcher->dispatchNow() #20 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}() #21 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(122): Illuminate\Pipeline\Pipeline->then() #23 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware() #24 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\Queue\CallQueuedHandler->call() #25 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/SyncQueue.php(43): Illuminate\Queue\Jobs\Job->fire() #26 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(254): Illuminate\Queue\SyncQueue->push() #27 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(230): Illuminate\Bus\Dispatcher->pushCommandToQueue() #28 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(77): Illuminate\Bus\Dispatcher->dispatchToQueue() #29 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Bus/PendingDispatch.php(193): Illuminate\Bus\Dispatcher->dispatch() #30 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Bus/Dispatchable.php(19): Illuminate\Foundation\Bus\PendingDispatch->__destruct() #31 /var/www/webgis/backend/app/Http/Controllers/Dataset/ImportController.php(47): App\Jobs\AJob::dispatch() #32 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\Dataset\ImportController->processGdb() #33 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction() #34 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\Routing\ControllerDispatcher->dispatch() #35 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #36 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run() #37 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #38 /var/www/webgis/backend/app/Http/Middleware/ForceJsonResponse.php(14): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #39 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\ForceJsonResponse->handle() #40 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #41 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle() #42 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(159): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #43 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(125): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest() #44 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter() #45 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\ThrottleRequests->handle() #46 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #47 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Auth\Middleware\Authenticate->handle() #48 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #49 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then() #50 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack() #51 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute() #52 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute() #53 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch() #54 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #55 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #56 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #57 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #58 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #59 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #60 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #61 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #62 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #63 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #64 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #65 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #66 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle() #67 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #68 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle() #69 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #70 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then() #71 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #72 /var/www/webgis/backend/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle() #73 {main} Next Illuminate\Database\QueryException: 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_41.view_title_41 AS SELECT dvhc cap huyen_region.ogc_fid || '-' || '1986' as id, dvhc cap huyen_region.ogc_fid::text as name, dvhc cap huyen_region.ogc_fid::text as feature_id, '1986' 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_41.dvhc cap huyen_region UNION ALL SELECT khu xu ly ctr_text.ogc_fid || '-' || '1987' as id, khu xu ly ctr_text.ogc_fid::text as name, khu xu ly ctr_text.ogc_fid::text as feature_id, '1987' 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_41.khu xu ly ctr_text UNION ALL SELECT khu xu ly ctr_font_point.ogc_fid || '-' || '1988' 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, '1988' 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_41.khu xu ly ctr_font_point UNION ALL SELECT cell_ccn_text.ogc_fid || '-' || '1989' as id, cell_ccn_text.ogc_fid::text as name, cell_ccn_text.ogc_fid::text as feature_id, '1989' 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_41.cell_ccn_text UNION ALL SELECT cell_ccn_font_point.ogc_fid || '-' || '1990' as id, cell_ccn_font_point.ogc_fid::text as name, cell_ccn_font_point.ogc_fid::text as feature_id, '1990' 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_41.cell_ccn_font_point) in /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829 Stack trace: #0 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(576): Illuminate\Database\Connection->run() #2 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(509): Illuminate\Database\Connection->statement() #3 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Database\DatabaseManager->__call() #4 /var/www/webgis/backend/app/Traits/DatasetViewProcessingTrait.php(130): Illuminate\Support\Facades\Facade::__callStatic() #5 /var/www/webgis/backend/app/Jobs/ProcessGdbImport.php(116): App\Jobs\ProcessGdbImport->processCreateVectorTileView() #6 /var/www/webgis/backend/app/Jobs/AJob.php(58): App\Jobs\ProcessGdbImport->App\Jobs\{closure}() #7 /var/www/webgis/backend/app/Jobs/ProcessGdbImport.php(36): App\Jobs\AJob->cb_handle() #8 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\ProcessGdbImport->handle() #9 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #10 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #11 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #12 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #13 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call() #14 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}() #15 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then() #17 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\Bus\Dispatcher->dispatchNow() #18 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}() #19 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(122): Illuminate\Pipeline\Pipeline->then() #21 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware() #22 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\Queue\CallQueuedHandler->call() #23 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Queue/SyncQueue.php(43): Illuminate\Queue\Jobs\Job->fire() #24 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(254): Illuminate\Queue\SyncQueue->push() #25 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(230): Illuminate\Bus\Dispatcher->pushCommandToQueue() #26 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(77): Illuminate\Bus\Dispatcher->dispatchToQueue() #27 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Bus/PendingDispatch.php(193): Illuminate\Bus\Dispatcher->dispatch() #28 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Bus/Dispatchable.php(19): Illuminate\Foundation\Bus\PendingDispatch->__destruct() #29 /var/www/webgis/backend/app/Http/Controllers/Dataset/ImportController.php(47): App\Jobs\AJob::dispatch() #30 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\Dataset\ImportController->processGdb() #31 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction() #32 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\Routing\ControllerDispatcher->dispatch() #33 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #34 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run() #35 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #36 /var/www/webgis/backend/app/Http/Middleware/ForceJsonResponse.php(14): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #37 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\ForceJsonResponse->handle() #38 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #39 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle() #40 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(159): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #41 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(125): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest() #42 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter() #43 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\ThrottleRequests->handle() #44 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #45 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Auth\Middleware\Authenticate->handle() #46 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #47 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then() #48 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack() #49 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute() #50 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute() #51 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch() #52 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #53 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #54 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #55 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #56 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #57 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #58 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #59 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #60 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #61 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #62 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #63 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #64 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle() #65 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #66 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle() #67 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #68 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then() #69 /var/www/webgis/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #70 /var/www/webgis/backend/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle() #71 {main} [TASK][40] Message: ---- time end: 2025-05-28 09:47:05----||{"task_id":40} [TASK][40] Message: ---- TASK ERROR ----||{"task_id":40}