lobehub / lobe-chat

🤯 Lobe Chat - an open-source, modern-design AI chat framework. Supports Multi AI Providers( OpenAI / Claude 3 / Gemini / Ollama / Azure / DeepSeek), Knowledge Base (file upload / knowledge management / RAG ), Multi-Modals (Vision/TTS) and plugin system. One-click FREE deployment of your private ChatGPT/ Claude application.
https://chat-preview.lobehub.com
Other
44.97k stars 10.14k forks source link

[Bug] 新版本ci更新之后出现< 列“accessed_at”不存在>的报错 #4636

Closed AquaHydro closed 2 weeks ago

AquaHydro commented 2 weeks ago

📦 部署环境

Vercel

📌 软件版本

chore(release): v1.28.3

💻 系统环境

macOS

🌐 浏览器

Chrome

🐛 问题描述

image

column sessions_agentsToSessions_agent.accessed_at does not exist

📷 复现步骤

No response

🚦 期望结果

No response

📝 补充信息

No response

lobehubbot commented 2 weeks ago

👀 @AquaHydro

Thank you for raising an issue. We will investigate into the matter and get back to you as soon as possible. Please make sure you have given us as much context as possible.\ 非常感谢您提交 issue。我们会尽快调查此事,并尽快回复您。 请确保您已经提供了尽可能多的背景信息。

dosubot[bot] commented 2 weeks ago

Hello, @AquaHydro! I'm here to help you with any bugs, questions, or contributions. Let's work together to solve the issue you're facing.

To resolve the error "column 'accessed_at' does not exist" after updating to version v1.28.3, ensure that the database migrations have been applied correctly. Follow these steps:

  1. Check Migration Status: Verify that the migration script 0010_add_accessed_at_and_clean_tables.sql has been executed. Check the migration status in your database to confirm if this specific migration has been applied.

  2. Apply Migrations: If the migration has not been applied, run the migration command to apply it. This will add the accessed_at column to the necessary tables.

  3. Verify Database Schema: After applying the migration, ensure that the accessed_at column exists in the tables mentioned in the migration script.

If the migration script is correctly applied, the error should be resolved. If issues persist, check your database connection and migration setup in your CI environment on Vercel [1].

To continue talking to Dosu, mention @dosu.

AquaHydro commented 2 weeks ago

这个pr新增字段导致的,似乎是相关脚步没有被执行? #4626

lobehubbot commented 2 weeks ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


This is caused by the new field in PR. What needs to be done? #4626

Miku2G commented 2 weeks ago

+1,我也遇到这个情况

lobehubbot commented 2 weeks ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


+1, I also encountered this situation

arvinxx commented 2 weeks ago

Vercel 应该都会自动执行的,你是不是改了构建配置

lobehubbot commented 2 weeks ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Vercel should be executed automatically. Have you changed the build configuration?

AquaHydro commented 2 weeks ago

@arvinxx 构建配置没有动过。是否需要提供vercel构建日志?

lobehubbot commented 2 weeks ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


@arvinxx The build configuration has not been touched. Do I need to provide vercel build logs?

arvinxx commented 2 weeks ago

@AquaHydro 发下

lobehubbot commented 2 weeks ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Posted by @AquaHydro

AquaHydro commented 2 weeks ago

@arvinxx

[02:23:32.935] Running build in Washington, D.C., USA (East) – iad1
[02:23:33.246] Cloning github.com/AquaHydro/lobe-chat (Branch: main, Commit: d2f4ad7)
[02:23:34.725] Cloning completed: 1.478s
[02:24:10.978] Restored build cache from previous deployment (9P45BtGxTZtZWzrUvXxTcqStwLr8)
[02:24:11.174] Running "vercel build"
[02:24:12.484] Vercel CLI 37.14.0
[02:24:13.890] Running "install" command: `bun install`...
[02:24:13.932] bun install v1.1.33 (247456b6)
[02:24:13.948] Resolving dependencies
[02:24:31.423] Resolved, downloaded and extracted [9734]
[02:24:31.424] warn: incorrect peer dependency "eslint@8.57.1"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "next@14.2.8"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "stylelint@15.11.0"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "stylelint@15.11.0"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "stylelint@15.11.0"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "stylelint@15.11.0"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "@octokit/core@5.2.0"
[02:24:34.932] Saved lockfile
[02:24:34.932] 
[02:24:35.034] $ husky
[02:24:35.308] 
[02:24:35.308] + @edge-runtime/vm@4.0.4
[02:24:35.309] + @next/bundle-analyzer@14.2.17
[02:24:35.309] + @next/eslint-plugin-next@14.2.17
[02:24:35.309] + drizzle-kit@0.27.2
[02:24:35.309] + happy-dom@15.10.1
[02:24:35.309] + @langchain/community@0.3.12
[02:24:35.309] + @neondatabase/serverless@0.10.3
[02:24:35.309] + @next/third-parties@14.2.17
[02:24:35.309] + @tanstack/react-query@5.59.20
[02:24:35.309] + modern-screenshot@4.5.1
[02:24:35.309] + openai@4.71.1
[02:24:35.310] 
[02:24:35.310] 38 packages installed [21.40s]
[02:24:35.343] Detected Next.js version: 14.2.8
[02:24:35.343] Running "NODE_OPTIONS=--max-old-space-size=6144 next build"
[02:24:38.584]   ▲ Next.js 14.2.8
[02:24:38.585] 
[02:24:39.022]    Creating an optimized production build ...
[02:24:39.665]  ○ (serwist) The service worker will not be automatically registered, please call 'window.serwist.register()' in 'componentDidMount' or 'useEffect'.
[02:24:39.671]  ✓ (serwist) Bundling the service worker script with the URL '/sw.js' and the scope '/'...
[02:30:48.487]  ✓ Compiled successfully
[02:30:48.489]    Linting and checking validity of types ...
[02:33:36.150]    Collecting page data ...
[02:33:38.887]  ⚠ Using edge runtime on a page currently disables static generation for that page
[02:34:03.757]    Generating static pages (0/99) ...
[02:34:14.411]    Generating static pages (24/99) 
[02:34:17.805]    Generating static pages (49/99) 
[02:34:19.284]    Generating static pages (74/99) 
[02:34:21.229]  ✓ Generating static pages (99/99)
[02:34:21.536]    Finalizing page optimization ...
[02:34:21.537]    Collecting build traces ...
[02:34:25.775] 
[02:34:25.796] Route (app)                                   Size     First Load JS
[02:34:25.796] ┌ ƒ /                                         9.46 kB         406 kB
[02:34:25.796] ├ ƒ /_not-found                               171 B           105 kB
[02:34:25.796] ├ ƒ /(.)settings/modal                        5.23 kB         142 kB
[02:34:25.797] ├ ƒ /api/auth/[...nextauth]                   0 B                0 B
[02:34:25.797] ├ ƒ /api/auth/error                           1.23 kB         106 kB
[02:34:25.797] ├ ƒ /api/webhooks/casdoor                     0 B                0 B
[02:34:25.797] ├ ƒ /api/webhooks/clerk                       0 B                0 B
[02:34:25.797] ├ ƒ /api/webhooks/logto                       0 B                0 B
[02:34:25.798] ├ ƒ /chat                                     17.3 kB         641 kB
[02:34:25.798] ├ ƒ /chat/(.)settings/modal                   5.08 kB         142 kB
[02:34:25.798] ├ ƒ /chat/settings                            10.4 kB         1.4 MB
[02:34:25.798] ├ ƒ /chat/settings/modal                      3.15 kB         108 kB
[02:34:25.798] ├ ƒ /discover                                 7.6 kB          512 kB
[02:34:25.799] ├ ƒ /discover/assistant/[slug]                24.8 kB         887 kB
[02:34:25.799] ├ ƒ /discover/assistants                      216 B           357 kB
[02:34:25.799] ├ ● /discover/assistants/[slug]               217 B           357 kB
[02:34:25.799] ├   ├ /discover/assistants/academic
[02:34:25.799] ├   ├ /discover/assistants/all
[02:34:25.799] ├   ├ /discover/assistants/career
[02:34:25.799] ├   └ [+12 more paths]
[02:34:25.799] ├ ƒ /discover/model/[...slugs]                9.21 kB         610 kB
[02:34:25.799] ├ ƒ /discover/models                          202 B           482 kB
[02:34:25.800] ├ ● /discover/models/[slug]                   202 B           482 kB
[02:34:25.800] ├   ├ /discover/models/openai
[02:34:25.800] ├   ├ /discover/models/ollama
[02:34:25.800] ├   ├ /discover/models/anthropic
[02:34:25.800] ├   └ [+28 more paths]
[02:34:25.800] ├ ƒ /discover/plugin/[slug]                   16.7 kB         706 kB
[02:34:25.800] ├ ƒ /discover/plugins                         212 B           356 kB
[02:34:25.800] ├ ● /discover/plugins/[slug]                  213 B           356 kB
[02:34:25.800] ├   ├ /discover/plugins/all
[02:34:25.800] ├   ├ /discover/plugins/gaming-entertainment
[02:34:25.800] ├   ├ /discover/plugins/lifestyle
[02:34:25.800] ├   └ [+6 more paths]
[02:34:25.800] ├ ƒ /discover/provider/[slug]                 23.5 kB         920 kB
[02:34:25.800] ├ ƒ /discover/providers                       8.08 kB         486 kB
[02:34:25.800] ├ ƒ /discover/search                          10.5 kB         573 kB
[02:34:25.800] ├ ƒ /files                                    628 B           681 kB
[02:34:25.801] ├ ƒ /files/(.)[id]                            8.72 kB         844 kB
[02:34:25.801] ├ ƒ /files/[id]                               1.04 kB         832 kB
[02:34:25.801] ├ ƒ /login/[[...login]]                       2.84 kB         136 kB
[02:34:25.801] ├ ƒ /manifest.webmanifest                     0 B                0 B
[02:34:25.801] ├ ƒ /me                                       21.5 kB         468 kB
[02:34:25.801] ├ ƒ /me/data                                  18.9 kB         897 kB
[02:34:25.801] ├ ƒ /me/profile                               9.38 kB         400 kB
[02:34:25.801] ├ ƒ /me/settings                              4.47 kB         267 kB
[02:34:25.801] ├ ƒ /profile/[[...slugs]]                     2.36 kB         253 kB
[02:34:25.801] ├ ƒ /repos                                    170 B           105 kB
[02:34:25.801] ├ ƒ /repos/[id]                               320 B           680 kB
[02:34:25.801] ├ ƒ /repos/[id]/evals                         171 B           105 kB
[02:34:25.801] ├ ƒ /repos/[id]/evals/dataset                 8.49 kB         954 kB
[02:34:25.801] ├ ƒ /repos/[id]/evals/evaluation              3.4 kB          895 kB
[02:34:25.801] ├ ○ /robots.txt                               0 B                0 B
[02:34:25.801] ├ ƒ /settings/about                           20.7 kB         470 kB
[02:34:25.802] ├ ƒ /settings/agent                           10.2 kB         1.4 MB
[02:34:25.802] ├ ƒ /settings/common                          40.4 kB         748 kB
[02:34:25.802] ├ ƒ /settings/llm                             39.6 kB        1.23 MB
[02:34:25.802] ├ ƒ /settings/modal                           4.18 kB         109 kB
[02:34:25.802] ├ ƒ /settings/sync                            19.7 kB         511 kB
[02:34:25.802] ├ ƒ /settings/system-agent                    25.1 kB         685 kB
[02:34:25.802] ├ ƒ /settings/tts                             18.3 kB         678 kB
[02:34:25.802] ├ ƒ /signup/[[...signup]]                     2.84 kB         136 kB
[02:34:25.802] ├ ● /sitemap/[__metadata_id__]                0 B                0 B
[02:34:25.803] ├   ├ /sitemap/pages.xml
[02:34:25.803] ├   ├ /sitemap/assistants.xml
[02:34:25.803] ├   ├ /sitemap/plugins.xml
[02:34:25.803] ├   └ [+2 more paths]
[02:34:25.803] ├ ƒ /trpc/async/[trpc]                        0 B                0 B
[02:34:25.803] ├ ƒ /trpc/edge/[trpc]                         0 B                0 B
[02:34:25.803] ├ ƒ /trpc/lambda/[trpc]                       0 B                0 B
[02:34:25.803] ├ ƒ /trpc/tools/[trpc]                        0 B                0 B
[02:34:25.803] ├ ƒ /webapi/assistant/[id]                    0 B                0 B
[02:34:25.803] ├ ƒ /webapi/assistant/store                   0 B                0 B
[02:34:25.803] ├ ƒ /webapi/chat/[provider]                   0 B                0 B
[02:34:25.803] ├ ƒ /webapi/chat/anthropic                    0 B                0 B
[02:34:25.803] ├ ƒ /webapi/chat/google                       0 B                0 B
[02:34:25.803] ├ ƒ /webapi/chat/minimax                      0 B                0 B
[02:34:25.804] ├ ƒ /webapi/chat/models/[provider]            0 B                0 B
[02:34:25.804] ├ ƒ /webapi/chat/openai                       0 B                0 B
[02:34:25.804] ├ ƒ /webapi/chat/wenxin                       0 B                0 B
[02:34:25.804] ├ ƒ /webapi/plugin/gateway                    0 B                0 B
[02:34:25.804] ├ ƒ /webapi/plugin/store                      0 B                0 B
[02:34:25.804] ├ ƒ /webapi/proxy                             0 B                0 B
[02:34:25.804] ├ ƒ /webapi/stt/openai                        0 B                0 B
[02:34:25.804] ├ ƒ /webapi/text-to-image/[provider]          0 B                0 B
[02:34:25.804] ├ ƒ /webapi/tokenizer                         0 B                0 B
[02:34:25.804] ├ ƒ /webapi/trace                             0 B                0 B
[02:34:25.804] ├ ƒ /webapi/tts/edge                          0 B                0 B
[02:34:25.804] ├ ƒ /webapi/tts/microsoft                     0 B                0 B
[02:34:25.804] ├ ƒ /webapi/tts/openai                        0 B                0 B
[02:34:25.804] └ ƒ /welcome                                  96.8 kB         710 kB
[02:34:25.804] + First Load JS shared by all                 105 kB
[02:34:25.805]   ├ chunks/46106-9923930df7cf4a4a.js          33 kB
[02:34:25.805]   ├ chunks/fd9d1056-46c90b2196254a0e.js       53.6 kB
[02:34:25.805]   ├ chunks/webpack-7f6b3d820599eb9b.js        18.3 kB
[02:34:25.805]   └ other shared chunks (total)               235 B
[02:34:25.805] 
[02:34:25.805] 
[02:34:25.805] ƒ Middleware                                  123 kB
[02:34:25.805] 
[02:34:25.805] ○  (Static)   prerendered as static content
[02:34:25.805] ●  (SSG)      prerendered as static HTML (uses getStaticProps)
[02:34:25.805] ƒ  (Dynamic)  server-rendered on demand
[02:34:25.805] 
[02:34:26.271] Traced Next.js server files in: 83.228ms
[02:34:28.236] Created all serverless functions in: 1.964s
[02:34:30.052] Collected static files (public/, static/, .next/static): 75.602ms
[02:34:30.463] Build Completed in /vercel/output [10m]
[02:34:30.968] Deploying outputs...
[02:35:05.293] 
[02:35:05.566] Deployment completed
[02:36:06.141] Uploading build cache [463.53 MB]...
[02:36:11.767] Build cache uploaded: 5.626s
arvinxx commented 2 weeks ago

NODE_OPTIONS=--max-old-space-size=6144 next build 你这不自己改了脚本么?改回来重跑下就行

lobehubbot commented 2 weeks ago

✅ @AquaHydro

This issue is closed, If you have any questions, you can comment and reply.\ 此问题已经关闭。如果您有任何问题,可以留言并回复。

lobehubbot commented 2 weeks ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


NODE_OPTIONS=--max-old-space-size=6144 next build Didn't you change the script yourself? Just change it back and run again.