Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
AquaHydro opened this issue Nov 7, 2024 · 16 comments
Closed
Labels
🤔 Need Reproduce Further information is requested | 需要更多信息复现

Comments

@AquaHydro
Copy link
Contributor

AquaHydro commented Nov 7, 2024

📦 部署环境

Vercel

📌 软件版本

chore(release): v1.28.3

💻 系统环境

macOS

🌐 浏览器

Chrome

🐛 问题描述

image

column sessions_agentsToSessions_agent.accessed_at does not exist

📷 复现步骤

No response

🚦 期望结果

No response

📝 补充信息

No response

@AquaHydro AquaHydro added the 🐛 Bug Something isn't working | 缺陷 label Nov 7, 2024
@github-project-automation github-project-automation bot moved this to Roadmap - Chat 1.x in Lobe Chat Routine Nov 7, 2024
@lobehubbot
Copy link
Member

👀 @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。我们会尽快调查此事,并尽快回复您。 请确保您已经提供了尽可能多的背景信息。

Copy link

dosubot bot commented Nov 7, 2024

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
Copy link
Contributor Author

AquaHydro commented Nov 7, 2024

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

@lobehubbot
Copy link
Member

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
Copy link

Miku2G commented Nov 7, 2024

+1,我也遇到这个情况

@lobehubbot
Copy link
Member

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


+1, I also encountered this situation

@arvinxx
Copy link
Contributor

arvinxx commented Nov 7, 2024

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

@arvinxx arvinxx added 🤔 Need Reproduce Further information is requested | 需要更多信息复现 and removed 🐛 Bug Something isn't working | 缺陷 labels Nov 7, 2024
@lobehubbot
Copy link
Member

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
Copy link
Contributor Author

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

@lobehubbot
Copy link
Member

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
Copy link
Contributor

arvinxx commented Nov 7, 2024

@AquaHydro 发下

@lobehubbot
Copy link
Member

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


Posted by @AquaHydro

@AquaHydro
Copy link
Contributor Author

@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 "[email protected]"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "[email protected]"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "[email protected]"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "[email protected]"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "[email protected]"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "[email protected]"
[02:24:31.424] 
[02:24:31.424] warn: incorrect peer dependency "@octokit/[email protected]"
[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/[email protected]
[02:24:35.309] + @next/[email protected]
[02:24:35.309] + @next/[email protected]
[02:24:35.309] + [email protected]
[02:24:35.309] + [email protected]
[02:24:35.309] + @langchain/[email protected]
[02:24:35.309] + @neondatabase/[email protected]
[02:24:35.309] + @next/[email protected]
[02:24:35.309] + @tanstack/[email protected]
[02:24:35.309] + [email protected]
[02:24:35.309] + [email protected]
[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
Copy link
Contributor

arvinxx commented Nov 7, 2024

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

@arvinxx arvinxx closed this as completed Nov 7, 2024
@github-project-automation github-project-automation bot moved this from Roadmap - Chat 1.x to Done in Lobe Chat Routine Nov 7, 2024
@lobehubbot
Copy link
Member

@AquaHydro

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

@lobehubbot
Copy link
Member

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🤔 Need Reproduce Further information is requested | 需要更多信息复现
Projects
Status: Done
Development

No branches or pull requests

4 participants