A exportação para o DarwinCode não está funcionando atualmente #373
Description
Log do servidor
2026-03-11T22:05:19.846003145Z Executing (default): SELECT count(DISTINCT(*)) AS "count" FROM "tombos" AS "tombos";
2026-03-11T22:05:19.849662130Z DatabaseError [SequelizeDatabaseError]: syntax error at or near "*"
2026-03-11T22:05:19.849717492Z at Query.formatError (/home/hcf_api/app/node_modules/sequelize/lib/dialects/postgres/query.js:363:16)
2026-03-11T22:05:19.849731730Z at /home/hcf_api/app/node_modules/sequelize/lib/dialects/postgres/query.js:86:18
2026-03-11T22:05:19.849736378Z From previous event:
2026-03-11T22:05:19.849740560Z at Query.run (/home/hcf_api/app/node_modules/sequelize/lib/dialects/postgres/query.js:79:23)
2026-03-11T22:05:19.849744832Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:561:20
2026-03-11T22:05:19.849748699Z From previous event:
2026-03-11T22:05:19.849752322Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:558:8
2026-03-11T22:05:19.849756405Z at /home/hcf_api/app/node_modules/retry-as-promised/index.js:39:21
2026-03-11T22:05:19.849760128Z at retryAsPromised (/home/hcf_api/app/node_modules/retry-as-promised/index.js:29:10)
2026-03-11T22:05:19.849763867Z at Sequelize.query (/home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:457:28)
2026-03-11T22:05:19.849767826Z at QueryInterface.rawSelect (/home/hcf_api/app/node_modules/sequelize/lib/query-interface.js:1153:27)
2026-03-11T22:05:19.849771623Z at tombos.aggregate (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1810:32)
2026-03-11T22:05:19.849775401Z at /home/hcf_api/app/node_modules/sequelize/lib/model.js:1855:19
2026-03-11T22:05:19.849779185Z at process.processImmediate (node:internal/timers:491:21)
2026-03-11T22:05:19.849783071Z From previous event:
2026-03-11T22:05:19.849786765Z at tombos.count (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1839:8)
2026-03-11T22:05:19.849790560Z at obterModeloDarwinCore (/home/hcf_api/app/dist/controllers/darwincore-controller.js:237:40)
2026-03-11T22:05:19.849794367Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.849798302Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-03-11T22:05:19.849802045Z at /home/hcf_api/app/dist/middlewares/tokens-middleware.js:30:5
2026-03-11T22:05:19.849805755Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.849809520Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-03-11T22:05:19.849813436Z at Route.dispatch (/home/hcf_api/app/node_modules/router/lib/route.js:117:3)
2026-03-11T22:05:19.849817199Z at handle (/home/hcf_api/app/node_modules/router/index.js:435:11)
2026-03-11T22:05:19.849820977Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.849824765Z at /home/hcf_api/app/node_modules/router/index.js:295:15
2026-03-11T22:05:19.849830284Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-03-11T22:05:19.849834272Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-03-11T22:05:19.849837981Z at Function.handle (/home/hcf_api/app/node_modules/router/index.js:186:3)
2026-03-11T22:05:19.849848913Z at Function.handle (/home/hcf_api/app/node_modules/express/lib/application.js:177:15)
2026-03-11T22:05:19.849852757Z at mounted_app (/home/hcf_api/app/node_modules/express/lib/application.js:232:10)
2026-03-11T22:05:19.849879965Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.849884740Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-03-11T22:05:19.849888559Z at /home/hcf_api/app/node_modules/router/index.js:297:9
2026-03-11T22:05:19.849892545Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-03-11T22:05:19.849896302Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-03-11T22:05:19.849900159Z at logger (/home/hcf_api/app/node_modules/morgan/index.js:144:5)
2026-03-11T22:05:19.849903986Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.849908015Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-03-11T22:05:19.849912051Z at /home/hcf_api/app/node_modules/router/index.js:297:9 {
2026-03-11T22:05:19.849915898Z parent: error: syntax error at or near "*"
2026-03-11T22:05:19.849919836Z at Parser.parseErrorMessage (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/parser.js:285:98)
2026-03-11T22:05:19.849923826Z at Parser.handlePacket (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/parser.js:122:29)
2026-03-11T22:05:19.849927671Z at Parser.parse (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/parser.js:35:38)
2026-03-11T22:05:19.849931472Z at Socket.<anonymous> (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/index.js:11:42)
2026-03-11T22:05:19.849935778Z at Socket.emit (node:events:518:28)
2026-03-11T22:05:19.849939912Z at addChunk (node:internal/streams/readable:561:12)
2026-03-11T22:05:19.849943764Z at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2026-03-11T22:05:19.849947597Z at Readable.push (node:internal/streams/readable:392:5)
2026-03-11T22:05:19.849951309Z at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
2026-03-11T22:05:19.849955204Z From previous event:
2026-03-11T22:05:19.849959308Z at Query.run (/home/hcf_api/app/node_modules/sequelize/lib/dialects/postgres/query.js:65:9)
2026-03-11T22:05:19.849965927Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:561:20
2026-03-11T22:05:19.849969870Z From previous event:
2026-03-11T22:05:19.849974257Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:558:8
2026-03-11T22:05:19.849978240Z at /home/hcf_api/app/node_modules/retry-as-promised/index.js:39:21
2026-03-11T22:05:19.849982207Z at retryAsPromised (/home/hcf_api/app/node_modules/retry-as-promised/index.js:29:10)
2026-03-11T22:05:19.849990530Z at Sequelize.query (/home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:457:28)
2026-03-11T22:05:19.850009897Z at QueryInterface.rawSelect (/home/hcf_api/app/node_modules/sequelize/lib/query-interface.js:1153:27)
2026-03-11T22:05:19.850014376Z at tombos.aggregate (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1810:32)
2026-03-11T22:05:19.850018557Z at /home/hcf_api/app/node_modules/sequelize/lib/model.js:1855:19
2026-03-11T22:05:19.850022558Z at process.processImmediate (node:internal/timers:491:21)
2026-03-11T22:05:19.850026710Z From previous event:
2026-03-11T22:05:19.850030769Z at tombos.count (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1839:8)
2026-03-11T22:05:19.850034793Z at obterModeloDarwinCore (/home/hcf_api/app/dist/controllers/darwincore-controller.js:237:40)
2026-03-11T22:05:19.850038835Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850042997Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-03-11T22:05:19.850046991Z at /home/hcf_api/app/dist/middlewares/tokens-middleware.js:30:5
2026-03-11T22:05:19.850050971Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850054992Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-03-11T22:05:19.850059182Z at Route.dispatch (/home/hcf_api/app/node_modules/router/lib/route.js:117:3)
2026-03-11T22:05:19.850063371Z at handle (/home/hcf_api/app/node_modules/router/index.js:435:11)
2026-03-11T22:05:19.850067375Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850071420Z at /home/hcf_api/app/node_modules/router/index.js:295:15
2026-03-11T22:05:19.850075569Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-03-11T22:05:19.850079588Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-03-11T22:05:19.850083577Z at Function.handle (/home/hcf_api/app/node_modules/router/index.js:186:3)
2026-03-11T22:05:19.850087574Z at Function.handle (/home/hcf_api/app/node_modules/express/lib/application.js:177:15)
2026-03-11T22:05:19.850091749Z at mounted_app (/home/hcf_api/app/node_modules/express/lib/application.js:232:10)
2026-03-11T22:05:19.850095836Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850100669Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-03-11T22:05:19.850120395Z at /home/hcf_api/app/node_modules/router/index.js:297:9
2026-03-11T22:05:19.850124968Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-03-11T22:05:19.850129139Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-03-11T22:05:19.850133569Z at logger (/home/hcf_api/app/node_modules/morgan/index.js:144:5)
2026-03-11T22:05:19.850141124Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850145879Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-03-11T22:05:19.850150295Z at /home/hcf_api/app/node_modules/router/index.js:297:9 {
2026-03-11T22:05:19.850154603Z length: 90,
2026-03-11T22:05:19.850158821Z severity: 'ERROR',
2026-03-11T22:05:19.850162920Z code: '42601',
2026-03-11T22:05:19.850166982Z detail: undefined,
2026-03-11T22:05:19.850171068Z hint: undefined,
2026-03-11T22:05:19.850175105Z position: '23',
2026-03-11T22:05:19.850179160Z internalPosition: undefined,
2026-03-11T22:05:19.850183338Z internalQuery: undefined,
2026-03-11T22:05:19.850187423Z where: undefined,
2026-03-11T22:05:19.850191466Z schema: undefined,
2026-03-11T22:05:19.850195540Z table: undefined,
2026-03-11T22:05:19.850199604Z column: undefined,
2026-03-11T22:05:19.850203664Z dataType: undefined,
2026-03-11T22:05:19.850207724Z constraint: undefined,
2026-03-11T22:05:19.850211787Z file: 'scan.l',
2026-03-11T22:05:19.850215853Z line: '1236',
2026-03-11T22:05:19.850219910Z routine: 'scanner_yyerror',
2026-03-11T22:05:19.850224004Z sql: 'SELECT count(DISTINCT(*)) AS "count" FROM "tombos" AS "tombos";'
2026-03-11T22:05:19.850228582Z },
2026-03-11T22:05:19.850232646Z original: error: syntax error at or near "*"
2026-03-11T22:05:19.850236897Z at Parser.parseErrorMessage (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/parser.js:285:98)
2026-03-11T22:05:19.850241171Z at Parser.handlePacket (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/parser.js:122:29)
2026-03-11T22:05:19.850245428Z at Parser.parse (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/parser.js:35:38)
2026-03-11T22:05:19.850249771Z at Socket.<anonymous> (/home/hcf_api/app/node_modules/pg/node_modules/pg-protocol/dist/index.js:11:42)
2026-03-11T22:05:19.850254146Z at Socket.emit (node:events:518:28)
2026-03-11T22:05:19.850258429Z at addChunk (node:internal/streams/readable:561:12)
2026-03-11T22:05:19.850262713Z at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2026-03-11T22:05:19.850267138Z at Readable.push (node:internal/streams/readable:392:5)
2026-03-11T22:05:19.850271333Z at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
2026-03-11T22:05:19.850275492Z From previous event:
2026-03-11T22:05:19.850279534Z at Query.run (/home/hcf_api/app/node_modules/sequelize/lib/dialects/postgres/query.js:65:9)
2026-03-11T22:05:19.850284106Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:561:20
2026-03-11T22:05:19.850298167Z From previous event:
2026-03-11T22:05:19.850302268Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:558:8
2026-03-11T22:05:19.850306481Z at /home/hcf_api/app/node_modules/retry-as-promised/index.js:39:21
2026-03-11T22:05:19.850310812Z at retryAsPromised (/home/hcf_api/app/node_modules/retry-as-promised/index.js:29:10)
2026-03-11T22:05:19.850315266Z at Sequelize.query (/home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:457:28)
2026-03-11T22:05:19.850319481Z at QueryInterface.rawSelect (/home/hcf_api/app/node_modules/sequelize/lib/query-interface.js:1153:27)
2026-03-11T22:05:19.850323869Z at tombos.aggregate (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1810:32)
2026-03-11T22:05:19.850328085Z at /home/hcf_api/app/node_modules/sequelize/lib/model.js:1855:19
2026-03-11T22:05:19.850355265Z at process.processImmediate (node:internal/timers:491:21)
2026-03-11T22:05:19.850359629Z From previous event:
2026-03-11T22:05:19.850363705Z at tombos.count (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1839:8)
2026-03-11T22:05:19.850367941Z at obterModeloDarwinCore (/home/hcf_api/app/dist/controllers/darwincore-controller.js:237:40)
2026-03-11T22:05:19.850372098Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850376149Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-03-11T22:05:19.850391582Z at /home/hcf_api/app/dist/middlewares/tokens-middleware.js:30:5
2026-03-11T22:05:19.850395795Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850399843Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-03-11T22:05:19.850403833Z at Route.dispatch (/home/hcf_api/app/node_modules/router/lib/route.js:117:3)
2026-03-11T22:05:19.850407873Z at handle (/home/hcf_api/app/node_modules/router/index.js:435:11)
2026-03-11T22:05:19.850412042Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850416086Z at /home/hcf_api/app/node_modules/router/index.js:295:15
2026-03-11T22:05:19.850420204Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-03-11T22:05:19.850424230Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-03-11T22:05:19.850428359Z at Function.handle (/home/hcf_api/app/node_modules/router/index.js:186:3)
2026-03-11T22:05:19.850432403Z at Function.handle (/home/hcf_api/app/node_modules/express/lib/application.js:177:15)
2026-03-11T22:05:19.850436456Z at mounted_app (/home/hcf_api/app/node_modules/express/lib/application.js:232:10)
2026-03-11T22:05:19.850440946Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850458990Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-03-11T22:05:19.850463199Z at /home/hcf_api/app/node_modules/router/index.js:297:9
2026-03-11T22:05:19.850467301Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-03-11T22:05:19.850471331Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-03-11T22:05:19.850475360Z at logger (/home/hcf_api/app/node_modules/morgan/index.js:144:5)
2026-03-11T22:05:19.850479387Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-03-11T22:05:19.850483412Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-03-11T22:05:19.850487453Z at /home/hcf_api/app/node_modules/router/index.js:297:9 {
2026-03-11T22:05:19.850491449Z length: 90,
2026-03-11T22:05:19.850495401Z severity: 'ERROR',
2026-03-11T22:05:19.850499308Z code: '42601',
2026-03-11T22:05:19.850503205Z detail: undefined,
2026-03-11T22:05:19.850507152Z hint: undefined,
2026-03-11T22:05:19.850511051Z position: '23',
2026-03-11T22:05:19.850514971Z internalPosition: undefined,
2026-03-11T22:05:19.850518886Z internalQuery: undefined,
2026-03-11T22:05:19.850522792Z where: undefined,
2026-03-11T22:05:19.850526689Z schema: undefined,
2026-03-11T22:05:19.850530569Z table: undefined,
2026-03-11T22:05:19.850534469Z column: undefined,
2026-03-11T22:05:19.850538387Z dataType: undefined,
2026-03-11T22:05:19.850542325Z constraint: undefined,
2026-03-11T22:05:19.850546266Z file: 'scan.l',
2026-03-11T22:05:19.850550148Z line: '1236',
2026-03-11T22:05:19.850554016Z routine: 'scanner_yyerror',
2026-03-11T22:05:19.850557983Z sql: 'SELECT count(DISTINCT(*)) AS "count" FROM "tombos" AS "tombos";'
2026-03-11T22:05:19.850562159Z },
2026-03-11T22:05:19.850566089Z sql: 'SELECT count(DISTINCT(*)) AS "count" FROM "tombos" AS "tombos";'
2026-03-11T22:05:19.850570390Z }
2026-03-11T22:05:19.850854037Z GET /api/darwincore 500 8.037 ms - 54
2026-03-11T22:05:47.373408864Z Executing (default): SELECT "id", "hora_inicio", "hora_fim", "periodicidade", "data_proxima_atualizacao", "nome_arquivo", "servico" FROM "configuracao" AS "configuracao" WHERE "configuracao"."hora_fim" IS NULL AND "configuracao"."servico" = 'REFLORA';
2026-03-11T22:05:47.374421819Z Executing (default): SELECT "id", "hora_inicio", "hora_fim", "periodicidade", "data_proxima_atualizacao", "nome_arquivo", "servico" FROM "configuracao" AS "configuracao" WHERE "configuracao"."hora_fim" IS NULL AND "configuracao"."servico" = 'SPECIESLINK';