Open wphyojpl opened 21 hours ago
New error while creating a creation
{
"error": {
"name": "error",
"message": "insert into \"collections\" (\"created_at\", \"duplicate_handling\", \"files\", \"granule_id_extraction_regex\", \"granule_id_validation_regex\", \"ignore_files_config_for_discovery\", \"meta\", \"name\", \"process\", \"report_to_ems\", \"sample_file_name\", \"tags\", \"updated_at\", \"url_path\", \"version\") values ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6, $7, $8, $9, DEFAULT, $10, $11, $12) returning * - relation \"collections\" does not exist",
"stack": [
"error: insert into \"collections\" (\"created_at\", \"duplicate_handling\", \"files\", \"granule_id_extraction_regex\", \"granule_id_validation_regex\", \"ignore_files_config_for_discovery\", \"meta\", \"name\", \"process\", \"report_to_ems\", \"sample_file_name\", \"tags\", \"updated_at\", \"url_path\", \"version\") values ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6, $7, $8, $9, DEFAULT, $10, $11, $12) returning * - relation \"collections\" does not exist",
" at Parser.parseErrorMessage (/var/task/db/node_modules/pg-protocol/dist/parser.js:283:1)",
" at Parser.handlePacket (/var/task/db/node_modules/pg-protocol/dist/parser.js:122:1)",
" at Parser.parse (/var/task/db/node_modules/pg-protocol/dist/parser.js:35:1)",
" at TLSSocket.<anonymous> (/var/task/db/node_modules/pg-protocol/dist/index.js:11:1)",
" at TLSSocket.emit (node:events:519:28)",
" at addChunk (node:internal/streams/readable:559:12)",
" at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)",
" at TLSSocket.Readable.push (node:internal/streams/readable:390:5)",
" at TLSWrap.onStreamRead (node:internal/stream_base_commons:191:23)"
]
},
"level": "error",
"message": "Error occurred while trying to create collection: {\"reportToEms\":false,\"duplicateHandling\":\"skip\",\"granuleId\":\"^test_file.*$\",\"granuleIdExtraction\":\"(^test_file.*)(\\\\.nc|\\\\.nc\\\\.cas|\\\\.cmr\\\\.xml)\",\"process\":\"stac\",\"name\":\"URN:NASA:UNITY:UDS_LOCAL_TEST:DEV:TEST2\",\"version\":\"2403201440\",\"url_path\":\"^test_file.*\\\\.nc$\",\"sampleFileName\":\"test_file01.nc\",\"files\":[{\"reportToEms\":false,\"type\":\"data\",\"sampleFileName\":\"test_file01.nc\",\"bucket\":\"protected\",\"regex\":\"^test_file.*\\\\.nc$\"},{\"reportToEms\":false,\"type\":\"metadata\",\"sampleFileName\":\"test_file01.nc.cas\",\"bucket\":\"protected\",\"regex\":\"^test_file.*\\\\.nc.cas$\"},{\"reportToEms\":false,\"type\":\"metadata\",\"sampleFileName\":\"test_file01.nc.cmr.xml\",\"bucket\":\"protected\",\"regex\":\"^test_file.*\\\\.nc.cmr.xml$\"},{\"reportToEms\":false,\"type\":\"metadata\",\"sampleFileName\":\"test_file01.nc.stac.json\",\"bucket\":\"protected\",\"regex\":\"^test_file.*\\\\.nc.stac.json$\"}],\"updatedAt\":1732061375428,\"createdAt\":1732061375428}",
"sender": "@cumulus/api/collections",
"timestamp": "2024-11-20T00:09:35.566Z"
}
There are 3 changes which are done directly in cumulus terraform
Error 1:
permissions_boundary has to be hardcoded to "arn:aws:iam::xxxxxxxxxxxxx:policy/mcp-tenantOperator-AMI-APIG" to fix that in
/cumulus-tf/.terraform/modules/cumulus/lambdas/dla-migration/iam.tf
Error 2:
Cloudwatch logs:
Adding the following in
/cumulus-tf/.terraform/modules/cumulus/tf-modules/cumulus/iam.tf
, but it did not help.The following access policy is also added to Cumulus Opensearch