Unable to get Next application to start

[maccamb]

Hello,

• I have created a brand new vanilla Next application. And I added a small utility file to initialize Sequelize. I have a mariadb instance up and running.
• I confirmed that using Node, Sequelize and MariaDB work fine using this running instance of mariadb in this same Next project (I used the test code from https://github.com/mariadb-developers/nodejs-sequelize-quickstart).
• However when I try using it with Next, it consistently fails with an error (see below).

I believe the base error is:

 ⚠ ./node_modules/sequelize/lib/dialects/abstract/connection-manager.js
Critical dependency: the request of a dependency is an expression

which also leads to:

⨯ Error: Please install mariadb package manually

Notes:

• mariadb is installed globally
• I use nvm
• nvm is not installed in my home folder
• nvm is installed on a mounted SMB filesystem.

I would greatly appreciate any guidance on this issue.

Thank you!

dude@MyMachine-Ubuntu:~/mfs/Dev/scratch/lrn_next$ npm run dev

> dev
> next dev

  ▲ Next.js 14.2.3
  - Local:        http://localhost:3000
  - Environments: .env.local

 ✓ Starting...
 ✓ Ready in 5.3s
 ○ Compiling / ...
 ⚠ ./node_modules/sequelize/lib/dialects/abstract/connection-manager.js
Critical dependency: the request of a dependency is an expression

Import trace for requested module:
./node_modules/sequelize/lib/dialects/abstract/connection-manager.js
./node_modules/sequelize/lib/dialects/mariadb/connection-manager.js
./node_modules/sequelize/lib/dialects/mariadb/index.js
./node_modules/sequelize/lib/sequelize.js
./node_modules/sequelize/lib/index.js
./lib/auth/db/auth-db-lib.js
./app/page.tsx
Error: Please install mariadb package manually
    at ConnectionManager._loadDialectModule (webpack-internal:///(rsc)/./node_modules/sequelize/lib/dialects/abstract/connection-manager.js:55:15)
    at new ConnectionManager (webpack-internal:///(rsc)/./node_modules/sequelize/lib/dialects/mariadb/connection-manager.js:30:21)
    at new MariadbDialect (webpack-internal:///(rsc)/./node_modules/sequelize/lib/dialects/mariadb/index.js:13:30)
    at new Sequelize (webpack-internal:///(rsc)/./node_modules/sequelize/lib/sequelize.js:194:20)
    at eval (webpack-internal:///(rsc)/./lib/auth/db/auth-db-lib.js:4:19)
    at (rsc)/./lib/auth/db/auth-db-lib.js (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:317:1)
    at __webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at eval (webpack-internal:///(rsc)/./app/page.tsx:10:12)
    at (rsc)/./app/page.tsx (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:306:1)
    at Function.__webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at runNextTicks (node:internal/process/task_queues:60:5)
    at process.processTimers (node:internal/timers:511:9)
    at async e9 (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:396554)
    at async tb (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:400212)
    at async tS (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:400773)
    at async tS (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:400904)
    at async tR (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:36:2130)
    at async /home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:36:2722 {
  digest: '340355734'
}
 ⨯ Error: Please install mariadb package manually
    at eval (./lib/auth/db/auth-db-lib.js:4:19)
    at (rsc)/./lib/auth/db/auth-db-lib.js (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:317:1)
    at __webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at eval (./app/page.tsx:10:12)
    at (rsc)/./app/page.tsx (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:306:1)
    at Function.__webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at async Promise.all (index 0)
digest: "3676413438"
 ⨯ Error: Please install mariadb package manually
    at eval (./lib/auth/db/auth-db-lib.js:4:19)
    at (rsc)/./lib/auth/db/auth-db-lib.js (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:317:1)
    at __webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at eval (./app/page.tsx:10:12)
    at (rsc)/./app/page.tsx (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:306:1)
    at Function.__webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at async Promise.all (index 0)
digest: "3676413438"
 ⨯ Error: Please install mariadb package manually
    at eval (./lib/auth/db/auth-db-lib.js:4:19)
    at (rsc)/./lib/auth/db/auth-db-lib.js (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:317:1)
    at __webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at eval (./app/page.tsx:10:12)
    at (rsc)/./app/page.tsx (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:306:1)
    at Function.__webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
digest: "340355734"
 ⨯ Error: Please install mariadb package manually
    at ConnectionManager._loadDialectModule (webpack-internal:///(rsc)/./node_modules/sequelize/lib/dialects/abstract/connection-manager.js:55:15)
    at new ConnectionManager (webpack-internal:///(rsc)/./node_modules/sequelize/lib/dialects/mariadb/connection-manager.js:30:21)
    at new MariadbDialect (webpack-internal:///(rsc)/./node_modules/sequelize/lib/dialects/mariadb/index.js:13:30)
    at new Sequelize (webpack-internal:///(rsc)/./node_modules/sequelize/lib/sequelize.js:194:20)
    at eval (webpack-internal:///(rsc)/./lib/auth/db/auth-db-lib.js:4:19)
    at (rsc)/./lib/auth/db/auth-db-lib.js (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:317:1)
    at __webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at eval (webpack-internal:///(rsc)/./app/page.tsx:10:12)
    at (rsc)/./app/page.tsx (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/app/page.js:306:1)
    at Function.__webpack_require__ (/home/dude/mfs/Dev/scratch/lrn_next/.next/server/webpack-runtime.js:33:43)
    at runNextTicks (node:internal/process/task_queues:60:5)
    at process.processTimers (node:internal/timers:511:9)
    at async e9 (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:396554)
    at async tb (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:400212)
    at async tS (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:400773)
    at async tS (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:35:400904)
    at async tR (/home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:36:2130)
    at async /home/dude/mfs/Dev/scratch/lrn_next/node_modules/next/dist/compiled/next-server/app-page.runtime.dev.js:36:2722 {
  digest: '340355734',
  page: '/'
}
 ⚠ ./node_modules/sequelize/lib/dialects/abstract/connection-manager.js
Critical dependency: the request of a dependency is an expression

Import trace for requested module:
./node_modules/sequelize/lib/dialects/abstract/connection-manager.js
./node_modules/sequelize/lib/dialects/mariadb/connection-manager.js
./node_modules/sequelize/lib/dialects/mariadb/index.js
./node_modules/sequelize/lib/sequelize.js
./node_modules/sequelize/lib/index.js
./lib/auth/db/auth-db-lib.js
./app/page.tsx

^C

[maccamb]

I located the solution after some deep digging on google searches.

Hat tips to these posts:

• nextjs middleware issue while calling sequelize model into it vercel/next.js#50587
• https://www.youtube.com/watch?v=jO8y1vHsyD0

My fixes:

1. Install mariadb locally (not globally)

2. Add the entry for sequelize and sequelize-typescript to next.config.js

// @ts-check
/** @type {import('next').NextConfig} */
const nextConfig = {
    /* config options here */
    experimental: {
        serverComponentsExternalPackages: ['sequelize', 'sequelize-typescript'],
    }
}
module.exports = nextConfig

3. Import mariadb before calling the constructor on Sequelize
   import mariadb from 'mariadb';

I hope this help someone!

[maccamb]

My solution provided above