Deployment to Vercel fails with latest ai-chatbot codebase

[jb-dev1]

This happens frequently with Vercel AI SDK templates. I hope the dev staff will include "Deploy with Vercel" testing to releases/codebase updates to ensure success.

When clicking either the "Deploy with Vercel" top right icon at https://chat.vercel.ai/ or the "Deploy" button near the bottom of https://github.com/vercel/ai-chatbot, the deployment fails. Here is the data I've gathered:

Build logs:

[11:56:01.377] Running build in Washington, D.C., USA (East) – iad1
[11:56:01.500] Cloning gitlab.com/woodlandhills/fichat-v5 (Branch: main, Commit: 22c9d4f)
[11:56:01.822] Previous build cache not available
[11:56:02.768] Cloning completed: 1.268s
[11:56:03.109] Running "vercel build"
[11:56:03.546] Vercel CLI 39.1.0
[11:56:04.737] Detected pnpm-lock.yaml version 9 generated by pnpm@9.x
[11:56:04.753] Installing dependencies...
[11:56:05.394] Lockfile is up to date, resolution step is skipped
[11:56:05.475] Progress: resolved 1, reused 0, downloaded 0, added 0
[11:56:05.635] Packages: +632
[11:56:05.636] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[11:56:06.476] Progress: resolved 632, reused 0, downloaded 83, added 74
[11:56:07.476] Progress: resolved 632, reused 0, downloaded 130, added 124
[11:56:08.506] Progress: resolved 632, reused 0, downloaded 136, added 127
[11:56:09.507] Progress: resolved 632, reused 0, downloaded 141, added 130
[11:56:10.507] Progress: resolved 632, reused 0, downloaded 157, added 139
[11:56:11.508] Progress: resolved 632, reused 0, downloaded 166, added 148
[11:56:12.510] Progress: resolved 632, reused 0, downloaded 290, added 278
[11:56:13.512] Progress: resolved 632, reused 0, downloaded 442, added 439
[11:56:14.512] Progress: resolved 632, reused 0, downloaded 610, added 604
[11:56:14.760] Progress: resolved 632, reused 0, downloaded 632, added 632, done
[11:56:14.996] .../esbuild@0.18.20/node_modules/esbuild postinstall$ node install.js
[11:56:14.997] .../esbuild@0.19.12/node_modules/esbuild postinstall$ node install.js
[11:56:14.997] .../sharp@0.33.5/node_modules/sharp install$ node install/check
[11:56:14.998] .../esbuild@0.23.1/node_modules/esbuild postinstall$ node install.js
[11:56:15.017] .../node_modules/@biomejs/biome postinstall$ node scripts/postinstall.js
[11:56:15.128] .../esbuild@0.18.20/node_modules/esbuild postinstall: Done
[11:56:15.133] .../esbuild@0.19.12/node_modules/esbuild postinstall: Done
[11:56:15.157] .../node_modules/@biomejs/biome postinstall: Done
[11:56:15.236] .../node_modules/bufferutil install$ node-gyp-build
[11:56:15.660] .../esbuild@0.23.1/node_modules/esbuild postinstall: Done
[11:56:15.696] .../sharp@0.33.5/node_modules/sharp install: Done
[11:56:15.732] .../node_modules/bufferutil install: Done
[11:56:15.921]
[11:56:15.921] dependencies:
[11:56:15.921] + @ai-sdk/openai 1.0.0-canary.3
[11:56:15.921] + @radix-ui/react-alert-dialog 1.1.2
[11:56:15.921] + @radix-ui/react-dialog 1.1.2
[11:56:15.921] + @radix-ui/react-dropdown-menu 2.1.2
[11:56:15.921] + @radix-ui/react-icons 1.3.0
[11:56:15.922] + @radix-ui/react-label 2.1.0
[11:56:15.922] + @radix-ui/react-select 2.1.2
[11:56:15.922] + @radix-ui/react-separator 1.1.0
[11:56:15.922] + @radix-ui/react-slot 1.1.0
[11:56:15.922] + @radix-ui/react-tooltip 1.1.3
[11:56:15.922] + @radix-ui/react-visually-hidden 1.1.0
[11:56:15.922] + @vercel/analytics 1.3.2
[11:56:15.922] + @vercel/blob 0.24.1
[11:56:15.922] + @vercel/postgres 0.10.0
[11:56:15.922] + ai 4.0.0-canary.9
[11:56:15.922] + bcrypt-ts 5.0.2
[11:56:15.922] + class-variance-authority 0.7.0
[11:56:15.922] + classnames 2.5.1
[11:56:15.922] + clsx 2.1.1
[11:56:15.922] + date-fns 4.1.0
[11:56:15.922] + diff-match-patch 1.0.5
[11:56:15.922] + dotenv 16.4.5
[11:56:15.923] + drizzle-orm 0.34.1
[11:56:15.923] + framer-motion 11.11.10
[11:56:15.923] + geist 1.3.1
[11:56:15.923] + lucide-react 0.446.0
[11:56:15.923] + nanoid 5.0.8
[11:56:15.923] + next 15.0.3-canary.2
[11:56:15.923] + next-auth 5.0.0-beta.25
[11:56:15.923] + next-themes 0.3.0
[11:56:15.923] + orderedmap 2.1.1
[11:56:15.923] + postgres 3.4.5
[11:56:15.923] + prosemirror-example-setup 1.2.3
[11:56:15.923] + prosemirror-inputrules 1.4.0
[11:56:15.923] + prosemirror-markdown 1.13.1
[11:56:15.923] + prosemirror-model 1.23.0
[11:56:15.923] + prosemirror-schema-basic 1.2.3
[11:56:15.923] + prosemirror-schema-list 1.4.1
[11:56:15.923] + prosemirror-state 1.4.3
[11:56:15.923] + prosemirror-view 1.35.0
[11:56:15.923] + react 19.0.0-rc-45804af1-20241021
[11:56:15.923] + react-dom 19.0.0-rc-45804af1-20241021
[11:56:15.923] + react-markdown 9.0.1
[11:56:15.923] + remark-gfm 4.0.0
[11:56:15.924] + server-only 0.0.1
[11:56:15.924] + sonner 1.5.0
[11:56:15.924] + swr 2.2.5
[11:56:15.924] + tailwind-merge 2.5.4
[11:56:15.924] + tailwindcss-animate 1.0.7
[11:56:15.924] + usehooks-ts 3.1.0
[11:56:15.924] + zod 3.23.8
[11:56:15.924]
[11:56:15.924] devDependencies:
[11:56:15.924] + @biomejs/biome 1.9.4
[11:56:15.924] + @tailwindcss/typography 0.5.15
[11:56:15.924] + @types/d3-scale 4.0.8
[11:56:15.924] + @types/node 22.9.0
[11:56:15.924] + @types/pdf-parse 1.1.4
[11:56:15.924] + @types/react 18.3.12
[11:56:15.924] + @types/react-dom 18.3.1
[11:56:15.924] + drizzle-kit 0.25.0
[11:56:15.925] + eslint 8.57.1
[11:56:15.925] + eslint-config-next 14.2.5
[11:56:15.925] + eslint-config-prettier 9.1.0
[11:56:15.925] + eslint-import-resolver-typescript 3.6.3
[11:56:15.925] + eslint-plugin-tailwindcss 3.17.5
[11:56:15.925] + postcss 8.4.47
[11:56:15.925] + tailwindcss 3.4.14
[11:56:15.925] + tsx 4.19.2
[11:56:15.925] + typescript 5.6.3
[11:56:15.925]
[11:56:15.974] Done in 11.1s
[11:56:16.058] Running "pnpm run build"
[11:56:16.584]
[11:56:16.584] > ai-chatbot@0.1.0 build /vercel/path0
[11:56:16.584] > tsx lib/db/migrate && next build
[11:56:16.584]
[11:56:17.252] ⏳ Running migrations...
[11:56:18.697] {
[11:56:18.697] severity_local: 'NOTICE',
[11:56:18.697] severity: 'NOTICE',
[11:56:18.697] code: '42622',
[11:56:18.697] message: 'identifier "Suggestion_documentId_documentCreatedAt_Document_id_createdAt_fk" will be truncated to "Suggestion_documentId_documentCreatedAt_Document_id_createdAt_f"',
[11:56:18.697] where: 'compilation of PL/pgSQL function "inline_code_block" near line 1',
[11:56:18.697] file: 'scansup.c',
[11:56:18.697] line: '99',
[11:56:18.697] routine: 'truncate_identifier'
[11:56:18.697] }
[11:56:18.697] {
[11:56:18.697] severity_local: 'NOTICE',
[11:56:18.697] severity: 'NOTICE',
[11:56:18.697] code: '42622',
[11:56:18.697] message: 'identifier "Suggestion_documentId_documentCreatedAt_Document_id_createdAt_fk" will be truncated to "Suggestion_documentId_documentCreatedAt_Document_id_createdAt_f"',
[11:56:18.698] position: '15',
[11:56:18.698] file: 'scansup.c',
[11:56:18.698] line: '99',
[11:56:18.698] routine: 'truncate_identifier'
[11:56:18.698] }
[11:56:18.698] {
[11:56:18.698] severity_local: 'NOTICE',
[11:56:18.698] severity: 'NOTICE',
[11:56:18.698] code: '42622',
[11:56:18.698] message: 'identifier "Suggestion_documentId_documentCreatedAt_Document_id_createdAt_fk" will be truncated to "Suggestion_documentId_documentCreatedAt_Document_id_createdAt_f"',
[11:56:18.698] where: 'SQL statement "ALTER TABLE "Suggestion" ADD CONSTRAINT "Suggestion_documentId_documentCreatedAt_Document_id_createdAt_fk" FOREIGN KEY ("documentId","documentCreatedAt") REFERENCES "public"."Document"("id","createdAt") ON DELETE no action ON UPDATE no action"\n' +
[11:56:18.698] 'PL/pgSQL function inline_code_block line 2 at SQL statement',
[11:56:18.698] file: 'scansup.c',
[11:56:18.698] line: '99',
[11:56:18.698] routine: 'truncate_identifier'
[11:56:18.698] }
[11:56:19.529] ✅ Migrations completed in 2276 ms
[11:56:20.312] Attention: Next.js now collects completely anonymous telemetry regarding usage.
[11:56:20.312] This information is used to shape Next.js' roadmap and prioritize features.
[11:56:20.313] You can learn more, including how to opt-out if you'd not like to participate in this anonymous program, by visiting the following URL:
[11:56:20.313] https://nextjs.org/telemetry
[11:56:20.313]
[11:56:20.445] ▲ Next.js 15.0.3-canary.2
[11:56:20.445] - Experiments (use with caution):
[11:56:20.445] · ppr
[11:56:20.445]
[11:56:20.480] Creating an optimized production build ...
[11:57:01.213] ✓ Compiled successfully
[11:57:01.217] Linting and checking validity of types ...
[11:57:13.963] Collecting page data ...
[11:57:17.847] Generating static pages (0/16) ...
[11:57:19.564] Generating static pages (4/16)
[11:57:19.565] Generating static pages (8/16)
[11:57:19.565] Generating static pages (12/16)
[11:57:19.565] ✓ Generating static pages (16/16)
[11:57:20.512] Finalizing page optimization ...
[11:57:20.514] Collecting build traces ...
[11:57:30.749]
[11:57:30.773] Route (app) Size First Load JS
[11:57:30.773] ┌ ƒ / 157 B 467 kB
[11:57:30.773] ├ ○ /_not-found 898 B 101 kB
[11:57:30.773] ├ ƒ /api/auth/[...nextauth] 153 B 101 kB
[11:57:30.773] ├ ƒ /api/chat 153 B 101 kB
[11:57:30.773] ├ ƒ /api/document 153 B 101 kB
[11:57:30.773] ├ ƒ /api/files/upload 153 B 101 kB
[11:57:30.773] ├ ƒ /api/history 153 B 101 kB
[11:57:30.773] ├ ƒ /api/suggestions 153 B 101 kB
[11:57:30.773] ├ ƒ /api/vote 151 B 101 kB
[11:57:30.773] ├ ◐ /chat/[id] 157 B 467 kB
[11:57:30.774] ├ └ /chat/[id]
[11:57:30.774] ├ ○ /login 2.73 kB 135 kB
[11:57:30.774] ├ ○ /opengraph-image-12cog0.png 0 B 0 B
[11:57:30.774] ├ ○ /register 2.75 kB 135 kB
[11:57:30.774] └ ○ /twitter-image-12cog0.png 0 B 0 B
[11:57:30.774] + First Load JS shared by all 101 kB
[11:57:30.774] ├ chunks/3b878c1f-9ff175c475e661be.js 53 kB
[11:57:30.774] ├ chunks/481-6a23cffa051ce45e.js 45.7 kB
[11:57:30.774] └ other shared chunks (total) 1.92 kB
[11:57:30.774]
[11:57:30.775]
[11:57:30.775] ƒ Middleware 82 kB
[11:57:30.775]
[11:57:30.775] ○ (Static) prerendered as static content
[11:57:30.775] ◐ (Partial Prerender) prerendered as static HTML with dynamic server-streamed content
[11:57:30.775] ƒ (Dynamic) server-rendered on demand
[11:57:30.775]
[11:57:31.435] Using TypeScript 5.6.3 (local user-provided)
[11:57:35.174] Build Completed in /vercel/output [2m]
[11:57:35.277] Deploying outputs...
[11:57:36.768] Error: The Edge Function "middleware" is referencing unsupported modules:
[11:57:36.769] - vc__ns/0/middleware.js: @/app/(auth)/auth.config
[11:57:40.588]

[o1Suleyman]

fixed yet?

[jb-dev1]

Update: Vercel support told me that some accounts have access to the older "Vercel Postgres" service whereas newer accounts only have access to "Neon Serverless Postgres" service.

If you only have access to "Neon Serverless Postgres" you cannot deploy ai-chatbot using the "Deploy with Vercel" feature.

Here are screenshots of the differences of storage service options in my two Pro accounts by going to Vercel/Storage/Create Database (with no services specifically selected in Integrations):

The account that works:

The account that does not work: