[Bug]: Upgrade to 35.0.3 leads to numerous errors

Đang mở
#66,559 5 bình luận 0 reaction 0 người được giao Xem trên GitHub

Maintainer thường phản hồi trong vòng 1 ngày

Chưa có ai nhận issue này.

Đánh giá

Độ khó
4/5
Thời gian dự kiến
3-5 ngày
Mức phù hợp với người mới
15/100
Loại issue
Lỗi
Độ rõ ràng
Cần làm rõ
Mức độ hoạt động
Sôi nổi
Công nghệ
mariadb, php
Lĩnh vực
backend, database

Hướng nghiên cứu

The report centres on the output of sudo -u www-data php ./occ db:schema:check -vvv after an upgrade to 35.0.3, which lists missing tables and columns across core and several apps. Start by reproducing that command on a test instance with a MariaDB database and comparing its output with the schema definitions the payload names, such as oc_federated_invites and oc_jobs. Done means the reporter can explain which migration step failed or was skipped, and the upgrade completes with a clean schema check. The issue does not say what code change is wanted, so confirm the expected fix with maintainers before starting.

Do mô hình lập chỉ mục viết ra từ nội dung của issue.

Mô tả

0. Needs triage 35-feedback bug
⚠️ This issue respects the following points: ⚠️
  • This is not a troubleshooting question, general support matter, or webserver/proxy problem, but likely a bug (if unsure, ask the Community Help Forum).
  • This issue is not already reported on Github OR solved at the Community Help Forum (I've searched!).
  • I'm using a maintained major version of Nextcloud Server and tested against the latest patch level. (Supported major versions and current patch levels).
  • I agree to follow Nextcloud's Code of Conduct.
  • I've tried my best to provide clear reproduction steps that someone unfamiliar with this bug could use to reproduce it.
Bug description

Hi! I have started the upgrade procedure from 35.0.2 to 35.0.3 (the latest) on a bare metal instance. The process took a lot of time, and frozen finally. I have restarted the page and it shows broken UI of the Files app. Sending the CLI occ upgrade command lead to the finishing the procedure. However, the sutuation hasn't changed, the occ db:schema:check -vvv says that there are missing tables.

Steps to reproduce
  1. upgrade NC to the latest process, feel that the process took very long
  2. the process is stuck
  3. the NC UI is broken
  4. Running the command sudo -u www-data php ./occ db:schema:check -vvv I see:
missing table 'oc_federated_invites'
oc_jobs: column 'id' differs in: autoincrement
oc_preview_locations: column 'id' differs in: autoincrement
oc_preview_versions: column 'id' differs in: autoincrement
oc_previews: column 'id' differs in: autoincrement
oc_bookmarks_tree: column 'id' differs in: type, autoincrement
oc_bookmarks_folders_public: column 'id' differs in: type, autoincrement
oc_sharing_share_recipients: unexpected index 'UNIQ_734621B62AE63FDB4185A14495A838F'
oc_text_documents: column 'id' differs in: autoincrement
Disabled apps (not affecting exit code):
If the schema for a disabled app differs from what is expected, this might indicate the app was updated since it was disabled. Missing migrations will be applied once the app is enabled again.
Tables listed under '(unknown app)' could not be attributed to any app - most likely leftovers from an app that was removed entirely (occ app:remove only deletes its code, not its tables or config).
  app_api:
    - missing table 'oc_ex_apps_talk_bots'
    - oc_ex_ui_files_actions: missing column 'default_action'
  circles:
    - missing table 'oc_circles_invitations'
    - oc_circles_mount: missing column 'remote'
    - oc_circles_mount: missing column 'remote_id'
    - oc_circles_mount: missing index 'm_sid_rmt_rid'
  (unknown app):
    - unexpected table 'oc_ex_text_processing_q'
    - unexpected table 'oc_appconfig_ex'
    - unexpected table 'oc_ex_speech_to_text'
    - unexpected table 'oc_recent_contact'
    - unexpected table 'oc_onlyoffice_filekey'
    - unexpected table 'oc_richdocuments_direct'
    - unexpected table 'oc_preferences_ex'
    - unexpected table 'oc_webhook_listeners'
    - unexpected table 'oc_files_reminders'
    - unexpected table 'oc_ex_text_processing'
    - unexpected table 'oc_ex_speech_to_text_q'
    - unexpected table 'oc_richdocuments_wopi'
    - unexpected table 'oc_richdocuments_template'
    - unexpected table 'oc_ex_translation_q'
    - unexpected table 'oc_richdocuments_assets'
    - unexpected table 'oc_secrets'
    - unexpected table 'oc_onlyoffice_permissions'
    - unexpected table 'oc_ex_translation'
    - unexpected table 'oc_ex_event_handlers'
    - unexpected table 'oc_onlyoffice_instance'
  files_downloadlimit:
    - oc_shares_limits: column 'id' differs in: type, autoincrement
  photos:
    - oc_photos_albums: missing column 'filters'
Expected behavior

The upgrade should go smoothly without errors.

Nextcloud Server version

35

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.4

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?
  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other
Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

No response

Ngôn ngữ chính
PHP
Star
37.5k
Fork
5.4k
Merge trung bình
1 ngày 13 giờ
Pull request đã merge (30 ngày)
639

Chuẩn bị môi trường

Mở trong Codespaces

Khởi chạy dev container của dự án ngay trên trình duyệt, bằng tài khoản GitHub của bạn.

Bắt đầu từ đâu

  1. Đọc hết issue, rồi đọc hướng dẫn đóng góp của dự án.
  2. Bình luận trên issue rằng bạn sẽ nhận — tránh hai người làm cùng một việc.
  3. Fork repository và làm thay đổi trên một nhánh.
  4. Mở pull request có tham chiếu số hiệu của issue.

Issue khác của nextcloud/server

Tất cả issue của nextcloud/server

Issue tương tự

Thêm issue về PHP

Nhận issue mới trong hộp thư của bạn

Bản tóm tắt ngắn những issue GitHub phù hợp với người mới.