Error: Can't find meta/_journal.json file when trying to apply migrations in a lambda

I'm trying to apply migration in a lambda locally with running sls invoke local -f db_run_migrations
I use serverless framework with the serverless-esbuild plugin to package my lambdas
I execute the lambda using the

sls invoke local -f db_run_migrations

sls invoke local -f db_run_migrations

sls invoke local -f db_run_migrations

sls invoke local -f db_run_migrationscommand
This is my folder structure and lambda handler

pandareaper•8/10/23, 10:30 PM

I'm doing the same thing in my project without issue, play around with fs.existsSync()fs.existsSync() to make sure the path you are setting is correct, it likely isn't

This is what we set as the path to our migrations folders path.join(__dirname, 'drizzle')path.join(__dirname, 'drizzle')

We copy the migration folder into our lambda bundle as part of our build

"postbuild": "cp -r ../../packages/database/drizzle dist","postbuild": "cp -r ../../packages/database/drizzle dist",

Ppandareaper I'm doing the same thing in my project without issue, play around with `fs.exist...

AmurOP•8/11/23, 5:46 PM

and what's executin the 'postbuild' script? are you also using the serverless-esbuild plugin? or i assume you are using sst because i'm using serverless framewrok

AmurOP•8/11/23, 6:17 PM

the migrations are definitely not getting included now, so i just have to find out how to include them

AmurOP•8/12/23, 6:11 PM

@pandareaper is the migration folder part of all your lambda's bundle? or just the one that's doing the migration?

pandareaper•8/12/23, 10:11 PM

Just the one thats doing the migration, after the build my distdist directory looks like this. main.jsmain.js is my javascript bundle, using webpack.

drizzle

drizzle

is my migration files etc. which are copied into the folder postbuildpostbuild which yarn runs automatically when I run yarn buildyarn build

pandareaper•8/12/23, 10:12 PM

I use the CDK and bundle everything in the distdist folder as a ZIP

Locally I use serverless-offlineserverless-offline and just point to the dist/main.jsdist/main.js as my handler, so it can work with serverless as well

AmurOP•8/13/23, 9:15 AM

you bundle everything in the distdist folder so you don't package them individually
so your main.jsmain.jsfile will have all the code for all your lambdas if i understand correctly
this is how my .build.build dir look like when i esbuild bundles everything

AmurOP•8/13/23, 9:16 AM

so then serverless-framework packages them individually

AmurOP•8/13/23, 9:49 AM

ah i think i got it working, i just had to set it up in serverless framework

added the inlcludeinlclude option to my function

  db_run_migrations:
    handler: src/core/database/runMigrations.handler
    events:
      - http:
          path: "api/migrations"
          method: GET
          <<: *cors_config
    package:
      include:
        - src/core/database/migrations/**

  db_run_migrations:
    handler: src/core/database/runMigrations.handler
    events:
      - http:
          path: "api/migrations"
          method: GET
          <<: *cors_config
    package:
      include:
        - src/core/database/migrations/**

pandareaper•8/14/23, 6:56 AM

Nice, thats effectively equivalent to my postbuild step where I copy over the migration files

Error: Can't find meta/_journal.json file when trying to apply migrations in a lambda

Similar Threads

Similar Threads

Similar Threads