alist icon indicating copy to clipboard operation
alist copied to clipboard

数据库索引过多导致报错(初步判断是启动次数过多导致)

Open xiaoman1221 opened this issue 3 years ago • 1 comments

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 alist and not something else(such as Dependencies or Operational).

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
日志结束

xiaoman1221 avatar Jul 12 '22 02:07 xiaoman1221

sqlite和mysql都试了一下 未能复现。

xhofe avatar Jul 12 '22 04:07 xhofe

Hello @, this issue was closed due to inactive more than 60 days. You can reopen or recreate it if you think it should continue.

github-actions[bot] avatar Oct 01 '22 00:10 github-actions[bot]