alist
alist copied to clipboard
数据库索引过多导致报错(初步判断是启动次数过多导致)
Please make sure of the following things
- [X] I have read the documentation.
- [X] I'm sure there are no duplicate issues or discussions.
- [X] I'm sure it's due to
alistand not something else(such asDependenciesorOperational).
Alist Version / Alist 版本
v2.6.1
Driver used / 使用的存储驱动
Onedrive
Describe the bug / 问题描述
本人使用MySQL和SQLite3都有做过测试 问题是:程序启动次数达到一定数值(初步判断是64),会导致程序无法启动报错 报错信息在Logs
Reproduction / 复现链接
因为程序无法启动,所以链接不成立,本人查过的资料链接奉上:CSDN 辛苦大佬
Logs / 日志
==============================程序开始运行=============================
INFO[2022-07-12 04:33:43] init log...
INFO[2022-07-12 04:33:43] register driver: [123Pan]
INFO[2022-07-12 04:33:43] register driver: [139Yun]
INFO[2022-07-12 04:33:43] register driver: [189Cloud]
INFO[2022-07-12 04:33:43] register driver: [189CloudPC]
INFO[2022-07-12 04:33:43] register driver: [AliDrive]
INFO[2022-07-12 04:33:43] register driver: [Alist]
INFO[2022-07-12 04:33:43] register driver: [Baidu.Disk]
INFO[2022-07-12 04:33:43] register driver: [FTP]
INFO[2022-07-12 04:33:43] register driver: [GoogleDrive]
INFO[2022-07-12 04:33:43] register driver: [Lanzou]
INFO[2022-07-12 04:33:43] register driver: [MediaTrack]
INFO[2022-07-12 04:33:43] register driver: [Native]
INFO[2022-07-12 04:33:43] register driver: [Onedrive]
INFO[2022-07-12 04:33:43] register driver: [PikPak]
INFO[2022-07-12 04:33:43] register driver: [Quark]
INFO[2022-07-12 04:33:43] register driver: [S3]
INFO[2022-07-12 04:33:43] register driver: [SFTP]
INFO[2022-07-12 04:33:43] register driver: [ShandianPan]
INFO[2022-07-12 04:33:43] register driver: [Teambition]
INFO[2022-07-12 04:33:43] register driver: [USS]
INFO[2022-07-12 04:33:43] register driver: [WebDav]
INFO[2022-07-12 04:33:43] register driver: [XunLeiCloud]
INFO[2022-07-12 04:33:43] register driver: [Yandex.Disk]
INFO[2022-07-12 04:33:43] register driver: [Baidu.Photo]
INFO[2022-07-12 04:33:43] reading config file: data/config.json
INFO[2022-07-12 04:33:43] init cron...
INFO[2022-07-12 04:33:43] init model...
INFO[2022-07-12 04:33:43] auto migrate model...
FATA[2022-07-12 04:33:43] failed to auto migrate: Error 1069: Too many keys specified; max 64 keys allowed
==============================程序结束运行=============================
下面是本人排查数据库的日志:
[DTF] Data Transfer started
[DTF] 0> Getting tables
[DTF] 1> x_accounts: Getting table structure
[DTF] 1> x_accounts: Drop table
[DTF] 1> x_accounts: Create table
[DTF] 1> x_accounts: Fetching records
[DTF] 1> x_accounts: Transferring records
[DTF] 1> x_accounts: Records transferred
[DTF] 2> x_meta: Getting table structure
[DTF] 2> x_meta: Drop table
[DTF] 2> x_meta: Create table
[DTF] 2> x_meta: Fetching records
[DTF] 2> x_meta: Transferring records
[DTF] 2> x_meta: Records transferred
[DTF] 3> x_search_files: Getting table structure
[DTF] 3> x_search_files: Drop table
[DTF] 3> x_search_files: Create table
[DTF] 3> x_search_files: Fetching records
[DTF] 3> x_search_files: Transferring records
[DTF] 3> x_search_files: Records transferred
[DTF] 4> x_setting_items: Getting table structure
[DTF] 4> x_setting_items: Drop table
[DTF] 4> x_setting_items: Create table
[DTF] 4> x_setting_items: Fetching records
[DTF] 4> x_setting_items: Transferring records
[DTF] 4> x_setting_items: Records transferred
[DTF] 1> x_accounts: Create index "name"
[DTF] 1> x_accounts: Create index "name_2"
[DTF] 1> x_accounts: Create index "name_3"
[DTF] 1> x_accounts: Create index "name_4"
[DTF] 1> x_accounts: Create index "name_5"
[DTF] 1> x_accounts: Create index "name_6"
[DTF] 1> x_accounts: Create index "name_7"
[DTF] 1> x_accounts: Create index "name_8"
[DTF] 1> x_accounts: Create index "name_9"
[DTF] 1> x_accounts: Create index "name_10"
[DTF] 1> x_accounts: Create index "name_11"
[DTF] 1> x_accounts: Create index "name_12"
[DTF] 1> x_accounts: Create index "name_13"
[DTF] 1> x_accounts: Create index "name_14"
[DTF] 1> x_accounts: Create index "name_15"
[DTF] 1> x_accounts: Create index "name_16"
[DTF] 1> x_accounts: Create index "name_17"
[DTF] 1> x_accounts: Create index "name_18"
[DTF] 1> x_accounts: Create index "name_19"
[DTF] 1> x_accounts: Create index "name_20"
[DTF] 1> x_accounts: Create index "name_21"
[DTF] 1> x_accounts: Create index "name_22"
[DTF] 1> x_accounts: Create index "name_23"
[DTF] 1> x_accounts: Create index "name_24"
[DTF] 1> x_accounts: Create index "name_25"
[DTF] 1> x_accounts: Create index "name_26"
[DTF] 1> x_accounts: Create index "name_27"
[DTF] 1> x_accounts: Create index "name_28"
[DTF] 1> x_accounts: Create index "name_29"
[DTF] 1> x_accounts: Create index "name_30"
[DTF] 1> x_accounts: Create index "name_31"
[DTF] 1> x_accounts: Create index "name_32"
[DTF] 1> x_accounts: Create index "name_33"
[DTF] 1> x_accounts: Create index "name_34"
[DTF] 1> x_accounts: Create index "name_35"
[DTF] 1> x_accounts: Create index "name_36"
[DTF] 1> x_accounts: Create index "name_37"
[DTF] 1> x_accounts: Create index "name_38"
[DTF] 1> x_accounts: Create index "name_39"
[DTF] 1> x_accounts: Create index "name_40"
[DTF] 1> x_accounts: Create index "name_41"
[DTF] 1> x_accounts: Create index "name_42"
[DTF] 1> x_accounts: Create index "name_43"
[DTF] 1> x_accounts: Create index "name_44"
[DTF] 1> x_accounts: Create index "name_45"
[DTF] 1> x_accounts: Create index "name_46"
[DTF] 1> x_accounts: Create index "name_47"
[DTF] 1> x_accounts: Create index "name_48"
[DTF] 1> x_accounts: Create index "name_49"
[DTF] 1> x_accounts: Create index "name_50"
[DTF] 1> x_accounts: Create index "name_51"
[DTF] 1> x_accounts: Create index "name_52"
[DTF] 1> x_accounts: Create index "name_53"
[DTF] 1> x_accounts: Create index "name_54"
[DTF] 1> x_accounts: Create index "name_55"
[DTF] 1> x_accounts: Create index "name_56"
[DTF] 1> x_accounts: Create index "name_57"
[DTF] 1> x_accounts: Create index "name_58"
[DTF] 1> x_accounts: Create index "name_59"
[DTF] 1> x_accounts: Create index "name_60"
[DTF] 1> x_accounts: Create index "name_61"
[DTF] 1> x_accounts: Create index "name_62"
[DTF] 1> x_accounts: Create index "name_63"
[DTF] 2> x_meta: Create index "path"
[DTF] 2> x_meta: Create index "path_2"
[DTF] 2> x_meta: Create index "path_3"
[DTF] 2> x_meta: Create index "path_4"
[DTF] 2> x_meta: Create index "path_5"
[DTF] 2> x_meta: Create index "path_6"
[DTF] 2> x_meta: Create index "path_7"
[DTF] 2> x_meta: Create index "path_8"
[DTF] 2> x_meta: Create index "path_9"
[DTF] 2> x_meta: Create index "path_10"
[DTF] 2> x_meta: Create index "path_11"
[DTF] 2> x_meta: Create index "path_12"
[DTF] 2> x_meta: Create index "path_13"
[DTF] 2> x_meta: Create index "path_14"
[DTF] 2> x_meta: Create index "path_15"
[DTF] 2> x_meta: Create index "path_16"
[DTF] 2> x_meta: Create index "path_17"
[DTF] 2> x_meta: Create index "path_18"
[DTF] 2> x_meta: Create index "path_19"
[DTF] 2> x_meta: Create index "path_20"
[DTF] 2> x_meta: Create index "path_21"
[DTF] 2> x_meta: Create index "path_22"
[DTF] 2> x_meta: Create index "path_23"
[DTF] 2> x_meta: Create index "path_24"
[DTF] 2> x_meta: Create index "path_25"
[DTF] 2> x_meta: Create index "path_26"
[DTF] 2> x_meta: Create index "path_27"
[DTF] 2> x_meta: Create index "path_28"
[DTF] 2> x_meta: Create index "path_29"
[DTF] 2> x_meta: Create index "path_30"
[DTF] 2> x_meta: Create index "path_31"
[DTF] 2> x_meta: Create index "path_32"
[DTF] 2> x_meta: Create index "path_33"
[DTF] 2> x_meta: Create index "path_34"
[DTF] 2> x_meta: Create index "path_35"
[DTF] 2> x_meta: Create index "path_36"
[DTF] 2> x_meta: Create index "path_37"
[DTF] 2> x_meta: Create index "path_38"
[DTF] 2> x_meta: Create index "path_39"
[DTF] 2> x_meta: Create index "path_40"
[DTF] 2> x_meta: Create index "path_41"
[DTF] 2> x_meta: Create index "path_42"
[DTF] 2> x_meta: Create index "path_43"
[DTF] 2> x_meta: Create index "path_44"
[DTF] 2> x_meta: Create index "path_45"
[DTF] 2> x_meta: Create index "path_46"
[DTF] 2> x_meta: Create index "path_47"
[DTF] 2> x_meta: Create index "path_48"
[DTF] 2> x_meta: Create index "path_49"
[DTF] 2> x_meta: Create index "path_50"
[DTF] 2> x_meta: Create index "path_51"
[DTF] 2> x_meta: Create index "path_52"
[DTF] 2> x_meta: Create index "path_53"
[DTF] 2> x_meta: Create index "path_54"
[DTF] 2> x_meta: Create index "path_55"
[DTF] 2> x_meta: Create index "path_56"
[DTF] 2> x_meta: Create index "path_57"
[DTF] 2> x_meta: Create index "path_58"
[DTF] 2> x_meta: Create index "path_59"
[DTF] 2> x_meta: Create index "path_60"
[DTF] 2> x_meta: Create index "path_61"
[DTF] 2> x_meta: Create index "path_62"
[DTF] 2> x_meta: Create index "path_63"
[DTF] 3> x_search_files: Create index "idx_x_search_files_path"
[DTF] Finished successfully
日志结束
sqlite和mysql都试了一下 未能复现。
Hello @, this issue was closed due to inactive more than 60 days. You can reopen or recreate it if you think it should continue.