Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-09T02:54:06.122517Z 0 [Note] MySQL: Normal shutdown 2022-07-09T02:54:06.123496Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-09T02:54:06.123845Z 0 [Note] Shutting down slave threads 2022-07-09T02:54:06.125739Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-09T02:54:06.126613Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-09T02:54:06.127668Z 0 [Note] Binlog end 2022-07-09T02:54:06.131015Z 0 [Note] Shutting down plugin 'ngram' 2022-07-09T02:54:06.131854Z 0 [Note] Shutting down plugin 'partition' 2022-07-09T02:54:06.132180Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-09T02:54:06.132430Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-09T02:54:06.132668Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-09T02:54:06.133293Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-09T02:54:06.133802Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-09T02:54:06.134222Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-09T02:54:06.135005Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-09T02:54:06.135293Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-09T02:54:06.135591Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-09T02:54:06.135882Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-09T02:54:06.136222Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-09T02:54:06.136493Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-09T02:54:06.136799Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-09T02:54:06.137088Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-09T02:54:06.137417Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-09T02:54:06.137688Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-09T02:54:06.137979Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-09T02:54:06.138274Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-09T02:54:06.138568Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-09T02:54:06.138875Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-09T02:54:06.139268Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-09T02:54:06.139568Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-09T02:54:06.139828Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-09T02:54:06.140123Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-09T02:54:06.140433Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-09T02:54:06.140735Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-09T02:54:06.141018Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-09T02:54:06.141336Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-09T02:54:06.141646Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-09T02:54:06.141930Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-09T02:54:06.142195Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-09T02:54:06.142469Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-09T02:54:06.142722Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-09T02:54:06.143001Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-09T02:54:06.143261Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-09T02:54:06.143520Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-09T02:54:06.144005Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-09T02:54:06.144314Z 0 [Note] InnoDB: Starting shutdown... 2022-07-09T02:54:06.245242Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-09T02:54:06.246678Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220709 10:54:06 2022-07-09T02:54:07.342911Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2258848795 2022-07-09T02:54:07.343809Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-09T02:54:07.344107Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-09T02:54:07.344628Z 0 [Note] Shutting down plugin 'CSV' 2022-07-09T02:54:07.344867Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-09T02:54:07.345191Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-09T02:54:07.345541Z 0 [Note] Shutting down plugin 'binlog' 2022-07-09T02:54:07.346868Z 0 [Note] MySQL: Shutdown complete 2022-07-09T08:54:39.802142Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-09T08:54:39.802827Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-09T08:54:39.804088Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4700 ... 2022-07-09T08:54:39.881895Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-09T08:54:39.882687Z 0 [Note] InnoDB: Uses event mutexes 2022-07-09T08:54:39.883264Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-09T08:54:39.883579Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-09T08:54:39.890221Z 0 [Note] InnoDB: Number of pools: 1 2022-07-09T08:54:39.892880Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-09T08:54:39.897433Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-09T08:54:39.917741Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-09T08:54:39.943059Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-09T08:54:40.366347Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-09T08:54:40.367231Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-09T08:54:40.383839Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-09T08:54:40.385675Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-09T08:54:40.394327Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-09T08:54:40.400699Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-09T08:54:40.464406Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 2258848795 2022-07-09T08:54:40.467046Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-09T08:54:40.468999Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-09T08:54:40.494120Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220709 16:54:40 2022-07-09T08:54:40.496686Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-09T08:54:40.497375Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-09T08:54:40.502609Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-09T08:54:40.503709Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-09T08:54:40.507222Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-09T08:54:40.522692Z 0 [Note] IPv6 is available. 2022-07-09T08:54:40.524926Z 0 [Note] - '::' resolves to '::'; 2022-07-09T08:54:40.525710Z 0 [Note] Server socket created on IP: '::'. 2022-07-09T08:54:40.649836Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-09T08:54:40.650851Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-09T11:46:22.281349Z 4 [Note] Aborted connection 4 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:31:39.040589Z 5 [Note] Aborted connection 5 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:34:14.852897Z 6 [Note] Aborted connection 6 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:35:04.357573Z 7 [Note] Aborted connection 7 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:35:22.083465Z 8 [Note] Aborted connection 8 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:37:58.701821Z 9 [Note] Aborted connection 9 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:38:28.172993Z 10 [Note] Aborted connection 10 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:42:59.409634Z 11 [Note] Aborted connection 11 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T12:59:44.501340Z 12 [Note] Aborted connection 12 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T13:01:06.919206Z 14 [Note] Aborted connection 14 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T13:02:27.378491Z 15 [Note] Aborted connection 15 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T13:03:37.219396Z 16 [Note] Aborted connection 16 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T18:56:37.970346Z 18 [Note] Aborted connection 18 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-09T23:52:21.515796Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16726856ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2022-07-10T01:39:24.066454Z 20 [Note] Aborted connection 20 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error writing communication packets) 2022-07-10T02:10:35.872659Z 21 [Note] Aborted connection 21 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:11:50.468091Z 23 [Note] Aborted connection 23 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:12:38.116125Z 24 [Note] Aborted connection 24 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:14:44.103060Z 25 [Note] Aborted connection 25 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:14:52.978396Z 27 [Note] Aborted connection 27 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:15:52.923304Z 28 [Note] Aborted connection 28 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:16:07.082950Z 29 [Note] Aborted connection 29 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:17:36.044171Z 30 [Note] Aborted connection 30 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:19:40.439378Z 31 [Note] Aborted connection 31 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:20:49.097098Z 32 [Note] Aborted connection 32 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:45:46.450776Z 33 [Note] Aborted connection 33 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:48:00.669061Z 34 [Note] Aborted connection 34 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:48:27.604497Z 35 [Note] Aborted connection 35 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:48:43.160385Z 36 [Note] Aborted connection 36 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:49:34.200018Z 37 [Note] Aborted connection 37 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:50:54.005923Z 38 [Note] Aborted connection 38 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:51:08.182288Z 39 [Note] Aborted connection 39 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:51:49.920593Z 40 [Note] Aborted connection 40 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T02:52:05.841788Z 41 [Note] Aborted connection 41 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T04:23:10.300017Z 42 [Note] Aborted connection 42 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T07:31:33.179932Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 222112ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2022-07-10T07:44:36.993301Z 43 [Note] Aborted connection 43 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T08:02:16.158746Z 44 [Note] Aborted connection 44 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T10:57:10.321739Z 13 [Note] Aborted connection 13 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got timeout reading communication packets) 2022-07-10T11:48:17.526649Z 49 [Note] Aborted connection 49 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:25:29.199709Z 50 [Note] Aborted connection 50 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:48:36.128608Z 52 [Note] Aborted connection 52 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:48:45.910576Z 53 [Note] Aborted connection 53 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:49:15.744570Z 54 [Note] Aborted connection 54 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:51:29.354067Z 55 [Note] Aborted connection 55 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:53:00.114012Z 56 [Note] Aborted connection 56 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:53:09.039562Z 57 [Note] Aborted connection 57 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:56:42.845284Z 58 [Note] Aborted connection 58 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T12:56:56.940964Z 59 [Note] Aborted connection 59 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T16:55:41.084355Z 60 [ERROR] MySQL: The table 'baostock_history_k_data_plus' is full 2022-07-10T16:55:41.119046Z 60 [Note] Aborted connection 60 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T20:22:20.581259Z 48 [Note] Aborted connection 48 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got timeout reading communication packets) 2022-07-10T20:56:06.832835Z 51 [Note] Aborted connection 51 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got timeout reading communication packets) 2022-07-10T21:40:56.433249Z 47 [Note] Aborted connection 47 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got timeout reading communication packets) 2022-07-10T22:59:57.696628Z 62 [Note] Aborted connection 62 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T23:33:27.993350Z 63 [Note] Aborted connection 63 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-10T23:33:40.893224Z 0 [Note] MySQL: Normal shutdown 2022-07-10T23:33:40.897651Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-10T23:33:40.897998Z 0 [Note] Shutting down slave threads 2022-07-10T23:33:40.898681Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-10T23:33:40.899951Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-10T23:33:40.904056Z 0 [Note] Binlog end 2022-07-10T23:33:40.909545Z 0 [Note] Shutting down plugin 'ngram' 2022-07-10T23:33:40.910045Z 0 [Note] Shutting down plugin 'partition' 2022-07-10T23:33:40.910347Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-10T23:33:40.910832Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-10T23:33:40.911081Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-10T23:33:40.911391Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-10T23:33:40.912105Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-10T23:33:40.912383Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-10T23:33:40.912661Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-10T23:33:40.912953Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-10T23:33:40.913247Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-10T23:33:40.913549Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-10T23:33:40.913833Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-10T23:33:40.914112Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-10T23:33:40.914395Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-10T23:33:40.914699Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-10T23:33:40.915008Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-10T23:33:40.915292Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-10T23:33:40.915594Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-10T23:33:40.915899Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-10T23:33:40.916181Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-10T23:33:40.916492Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-10T23:33:40.916780Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-10T23:33:40.917100Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-10T23:33:40.917376Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-10T23:33:40.917693Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-10T23:33:40.918005Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-10T23:33:40.918331Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-10T23:33:40.918631Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-10T23:33:40.918964Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-10T23:33:40.919265Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-10T23:33:40.919561Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-10T23:33:40.919833Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-10T23:33:40.920115Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-10T23:33:40.920398Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-10T23:33:40.920695Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-10T23:33:40.920967Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-10T23:33:40.921232Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-10T23:33:40.922563Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-10T23:33:40.923311Z 0 [Note] InnoDB: Starting shutdown... 2022-07-10T23:33:41.031651Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-10T23:33:41.033313Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220711 7:33:41 2022-07-10T23:33:42.249869Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426765338 2022-07-10T23:33:42.250805Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-10T23:33:42.251114Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-10T23:33:42.251348Z 0 [Note] Shutting down plugin 'CSV' 2022-07-10T23:33:42.251576Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-10T23:33:42.251898Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-10T23:33:42.252272Z 0 [Note] Shutting down plugin 'binlog' 2022-07-10T23:33:42.260306Z 0 [Note] MySQL: Shutdown complete 2022-07-11T12:09:11.064098Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T12:09:11.064544Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T12:09:11.077597Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4724 ... 2022-07-11T12:09:11.109645Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T12:09:11.110165Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T12:09:11.110635Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T12:09:11.117602Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T12:09:11.119693Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T12:09:11.121673Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T12:09:11.125315Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T12:09:11.131234Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T12:09:11.165289Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T12:09:11.615552Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T12:09:11.616365Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T12:09:11.628725Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T12:09:11.630491Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T12:09:11.631056Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T12:09:11.631853Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T12:09:11.686405Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765338 2022-07-11T12:09:11.687888Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T12:09:11.688359Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T12:09:11.694787Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 20:09:11 2022-07-11T12:09:11.714344Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T12:09:11.715011Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T12:09:11.719568Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T12:09:11.720566Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T12:09:11.723683Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T12:09:11.725001Z 0 [Note] IPv6 is available. 2022-07-11T12:09:11.725442Z 0 [Note] - '::' resolves to '::'; 2022-07-11T12:09:11.726090Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T12:09:11.826770Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T12:09:11.827615Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T12:20:37.619994Z 0 [Note] MySQL: Normal shutdown 2022-07-11T12:20:37.621053Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-11T12:20:37.621457Z 0 [Note] Shutting down slave threads 2022-07-11T12:20:37.621838Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-11T12:20:37.622243Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-11T12:20:37.623069Z 0 [Note] Binlog end 2022-07-11T12:20:37.624439Z 0 [Note] Shutting down plugin 'ngram' 2022-07-11T12:20:37.624718Z 0 [Note] Shutting down plugin 'partition' 2022-07-11T12:20:37.624984Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-11T12:20:37.625256Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-11T12:20:37.625511Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-11T12:20:37.625838Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-11T12:20:37.626172Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-11T12:20:37.626451Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-11T12:20:37.626741Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-11T12:20:37.627048Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-11T12:20:37.627368Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-11T12:20:37.627702Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-11T12:20:37.628001Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-11T12:20:37.628303Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-11T12:20:37.628599Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-11T12:20:37.629000Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-11T12:20:37.629317Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-11T12:20:37.629613Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-11T12:20:37.629946Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-11T12:20:37.630254Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-11T12:20:37.630607Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-11T12:20:37.630928Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-11T12:20:37.631227Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-11T12:20:37.631553Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-11T12:20:37.631842Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-11T12:20:37.632282Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-11T12:20:37.632680Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-11T12:20:37.632984Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-11T12:20:37.633552Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-11T12:20:37.633905Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-11T12:20:37.634202Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-11T12:20:37.634533Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-11T12:20:37.634921Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-11T12:20:37.635203Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-11T12:20:37.635466Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-11T12:20:37.635760Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-11T12:20:37.636036Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-11T12:20:37.636304Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-11T12:20:37.636633Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-11T12:20:37.637032Z 0 [Note] InnoDB: Starting shutdown... 2022-07-11T12:20:37.744985Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T12:20:37.746294Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220711 20:20:37 2022-07-11T12:20:38.952193Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426765366 2022-07-11T12:20:38.952848Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-11T12:20:38.953216Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-11T12:20:38.953439Z 0 [Note] Shutting down plugin 'CSV' 2022-07-11T12:20:38.953744Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-11T12:20:38.954089Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-11T12:20:38.954553Z 0 [Note] Shutting down plugin 'binlog' 2022-07-11T12:20:38.955323Z 0 [Note] MySQL: Shutdown complete 2022-07-11T12:21:07.999281Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T12:21:07.999740Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T12:21:08.000871Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4664 ... 2022-07-11T12:21:08.033402Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T12:21:08.033855Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T12:21:08.041376Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T12:21:08.049687Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T12:21:08.054404Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T12:21:08.062100Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T12:21:08.065955Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T12:21:08.071688Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T12:21:08.132122Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T12:21:08.465456Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T12:21:08.466270Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T12:21:08.482564Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T12:21:08.487766Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T12:21:08.488475Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T12:21:08.489118Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T12:21:08.550718Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765366 2022-07-11T12:21:08.552035Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T12:21:08.557206Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T12:21:08.572413Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 20:21:08 2022-07-11T12:21:08.585380Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T12:21:08.586089Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T12:21:08.591144Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T12:21:08.592158Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T12:21:08.595758Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T12:21:08.596656Z 0 [Note] IPv6 is available. 2022-07-11T12:21:08.596982Z 0 [Note] - '::' resolves to '::'; 2022-07-11T12:21:08.597376Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T12:21:08.679564Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T12:21:08.680264Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T12:24:12.130363Z 2 [Note] Aborted connection 2 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-11T12:30:48.683511Z 3 [Note] Aborted connection 3 to db: 'stock_analyser' user: 'root' host: 'localhost' (Got an error reading communication packets) 2022-07-11T12:30:59.013701Z 4 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-11T12:30:59.015568Z 4 [ERROR] InnoDB: Server exits. 2022-07-11T12:33:30.123730Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T12:33:30.124272Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T12:33:30.125502Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4656 ... 2022-07-11T12:33:30.150883Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T12:33:30.175179Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T12:33:30.175594Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T12:33:30.225114Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T12:33:30.228374Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T12:33:30.231160Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T12:33:30.352041Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T12:33:30.358055Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T12:33:30.398687Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T12:33:30.401029Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765385 2022-07-11T12:33:30.401572Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765394 2022-07-11T12:33:30.402147Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-11T12:33:30.402606Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-11T12:33:30.909712Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-11T12:33:30.910253Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T12:33:30.910912Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T12:33:30.919901Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T12:33:30.921747Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T12:33:30.922302Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T12:33:30.923000Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T12:33:30.984844Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765394 2022-07-11T12:33:30.986594Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T12:33:30.986989Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T12:33:30.996944Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 20:33:30 2022-07-11T12:33:31.006743Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T12:33:31.007421Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T12:33:31.011321Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T12:33:31.012166Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T12:33:31.014921Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T12:33:31.015873Z 0 [Note] IPv6 is available. 2022-07-11T12:33:31.016194Z 0 [Note] - '::' resolves to '::'; 2022-07-11T12:33:31.016617Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T12:33:31.087268Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T12:33:31.087764Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T12:41:31.489943Z 3 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-11T12:41:31.491506Z 3 [ERROR] InnoDB: Server exits. 2022-07-11T12:50:59.333118Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T12:50:59.333169Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T12:50:59.333591Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 3292 ... 2022-07-11T12:50:59.340080Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T12:50:59.340610Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T12:50:59.340927Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T12:50:59.341266Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T12:50:59.341822Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T12:50:59.342205Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T12:50:59.344804Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T12:50:59.349710Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T12:50:59.385179Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T12:50:59.387229Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765413 2022-07-11T12:50:59.387725Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765422 2022-07-11T12:50:59.388230Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-11T12:50:59.388632Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-11T12:50:59.929438Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-11T12:50:59.929952Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T12:50:59.930683Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T12:50:59.938545Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T12:50:59.940861Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T12:50:59.941383Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T12:50:59.942084Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T12:50:59.995559Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765422 2022-07-11T12:50:59.999189Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T12:50:59.999190Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T12:51:00.009902Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T12:51:00.010397Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 20:51:00 2022-07-11T12:51:00.010763Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T12:51:00.012871Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T12:51:00.013405Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T12:51:00.015872Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T12:51:00.016902Z 0 [Note] IPv6 is available. 2022-07-11T12:51:00.017202Z 0 [Note] - '::' resolves to '::'; 2022-07-11T12:51:00.017562Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T12:51:00.059319Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T12:51:00.060016Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T12:51:20.317473Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-11T12:51:20.319006Z 2 [ERROR] InnoDB: Server exits. 2022-07-11T12:54:38.938537Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T12:54:38.938961Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T12:54:38.940139Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4700 ... 2022-07-11T12:54:38.984032Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T12:54:38.984624Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T12:54:38.985782Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T12:54:38.986149Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T12:54:38.988706Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T12:54:38.990973Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T12:54:39.000557Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T12:54:39.016650Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T12:54:39.058450Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T12:54:39.060238Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765450 2022-07-11T12:54:39.060690Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765459 2022-07-11T12:54:39.061117Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-11T12:54:39.061454Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-11T12:54:39.655891Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-11T12:54:39.656479Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T12:54:39.657142Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T12:54:39.666423Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T12:54:39.668186Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T12:54:39.668919Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T12:54:39.669802Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T12:54:39.725326Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765459 2022-07-11T12:54:39.736246Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T12:54:39.742572Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T12:54:39.764407Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 20:54:39 2022-07-11T12:54:39.776875Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T12:54:39.777506Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T12:54:39.780756Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T12:54:39.781577Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T12:54:39.784286Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T12:54:39.785445Z 0 [Note] IPv6 is available. 2022-07-11T12:54:39.786007Z 0 [Note] - '::' resolves to '::'; 2022-07-11T12:54:39.786404Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T12:54:39.886452Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T12:54:39.887096Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T12:56:29.832192Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-11T12:56:29.833693Z 2 [ERROR] InnoDB: Server exits. 2022-07-11T13:09:55.726167Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T13:09:55.726265Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T13:09:55.726769Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 6936 ... 2022-07-11T13:09:55.733232Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T13:09:55.733724Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T13:09:55.734039Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T13:09:55.734378Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T13:09:55.735010Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T13:09:55.735383Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T13:09:55.738260Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T13:09:55.743348Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T13:09:55.772624Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T13:09:55.774262Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765478 2022-07-11T13:09:55.774765Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765487 2022-07-11T13:09:55.775249Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-11T13:09:55.775627Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-11T13:09:56.300664Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-11T13:09:56.301213Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T13:09:56.302014Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T13:09:56.309979Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T13:09:56.312588Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T13:09:56.313218Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T13:09:56.313992Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T13:09:56.373126Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765487 2022-07-11T13:09:56.376897Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T13:09:56.376964Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T13:09:56.388033Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 21:09:56 2022-07-11T13:09:56.388341Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T13:09:56.389125Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T13:09:56.391003Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T13:09:56.391528Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T13:09:56.394027Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T13:09:56.395070Z 0 [Note] IPv6 is available. 2022-07-11T13:09:56.395372Z 0 [Note] - '::' resolves to '::'; 2022-07-11T13:09:56.395731Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T13:09:56.438031Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T13:09:56.438663Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T13:10:51.757956Z 4 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-11T13:10:51.759473Z 4 [ERROR] InnoDB: Server exits. 2022-07-11T14:10:27.226537Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T14:10:27.227129Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T14:10:27.228468Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4700 ... 2022-07-11T14:10:27.275898Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T14:10:27.283564Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T14:10:27.285145Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T14:10:27.285561Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T14:10:27.291040Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T14:10:27.303555Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T14:10:27.432476Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T14:10:27.440933Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T14:10:27.488316Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T14:10:27.491197Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765506 2022-07-11T14:10:27.491804Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765515 2022-07-11T14:10:27.492301Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-11T14:10:27.492733Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-11T14:10:28.189656Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-11T14:10:28.190123Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T14:10:28.191107Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T14:10:28.200776Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T14:10:28.202485Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T14:10:28.203010Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T14:10:28.203648Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T14:10:28.259692Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765515 2022-07-11T14:10:28.260692Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T14:10:28.261061Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T14:10:28.270530Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 22:10:28 2022-07-11T14:10:28.280872Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T14:10:28.281473Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T14:10:28.284796Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T14:10:28.285533Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T14:10:28.288065Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T14:10:28.289001Z 0 [Note] IPv6 is available. 2022-07-11T14:10:28.289292Z 0 [Note] - '::' resolves to '::'; 2022-07-11T14:10:28.289726Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T14:10:28.364446Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T14:10:28.364924Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T14:11:16.935269Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-11T14:11:16.936672Z 2 [ERROR] InnoDB: Server exits. 2022-07-11T14:12:58.010336Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-11T14:12:58.010841Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-11T14:12:58.012152Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4672 ... 2022-07-11T14:12:58.043351Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-11T14:12:58.043832Z 0 [Note] InnoDB: Uses event mutexes 2022-07-11T14:12:58.044235Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-11T14:12:58.044541Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-11T14:12:58.048214Z 0 [Note] InnoDB: Number of pools: 1 2022-07-11T14:12:58.050726Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-11T14:12:58.054333Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-11T14:12:58.060151Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-11T14:12:58.097200Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-11T14:12:58.099383Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765534 2022-07-11T14:12:58.099830Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765543 2022-07-11T14:12:58.100674Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-11T14:12:58.101039Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-11T14:12:58.665173Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-11T14:12:58.665757Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-11T14:12:58.666725Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-11T14:12:58.677947Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-11T14:12:58.680623Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-11T14:12:58.681438Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-11T14:12:58.682245Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-11T14:12:58.736370Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765543 2022-07-11T14:12:58.737183Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-11T14:12:58.737731Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-11T14:12:58.747948Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 22:12:58 2022-07-11T14:12:58.764537Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-11T14:12:58.765193Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-11T14:12:58.769046Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-11T14:12:58.769845Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-11T14:12:58.772425Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-11T14:12:58.773292Z 0 [Note] IPv6 is available. 2022-07-11T14:12:58.773594Z 0 [Note] - '::' resolves to '::'; 2022-07-11T14:12:58.773940Z 0 [Note] Server socket created on IP: '::'. 2022-07-11T14:12:58.847145Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-11T14:12:58.848191Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-11T14:14:38.166975Z 3 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-11T14:14:38.168521Z 3 [ERROR] InnoDB: Server exits. 2022-07-12T11:21:23.875410Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-12T11:21:23.875968Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-12T11:21:23.877198Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4736 ... 2022-07-12T11:21:23.928094Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-12T11:21:23.928628Z 0 [Note] InnoDB: Uses event mutexes 2022-07-12T11:21:23.928939Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-12T11:21:23.930326Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-12T11:21:23.933546Z 0 [Note] InnoDB: Number of pools: 1 2022-07-12T11:21:23.935857Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-12T11:21:23.939928Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-12T11:21:23.952704Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-12T11:21:24.000831Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-12T11:21:24.002575Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765562 2022-07-12T11:21:24.003044Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765571 2022-07-12T11:21:24.003524Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-12T11:21:24.003876Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-12T11:21:24.740893Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-12T11:21:24.741380Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-12T11:21:24.742126Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-12T11:21:24.752512Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-12T11:21:24.754734Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-12T11:21:24.755838Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-12T11:21:24.757000Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-12T11:21:24.822705Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765571 2022-07-12T11:21:24.825516Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-12T11:21:24.827652Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-12T11:21:24.839665Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220712 19:21:24 2022-07-12T11:21:24.850559Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-12T11:21:24.851262Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-12T11:21:24.854909Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-12T11:21:24.855746Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-12T11:21:24.859738Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-12T11:21:24.860633Z 0 [Note] IPv6 is available. 2022-07-12T11:21:24.860961Z 0 [Note] - '::' resolves to '::'; 2022-07-12T11:21:24.861340Z 0 [Note] Server socket created on IP: '::'. 2022-07-12T11:21:24.967216Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-12T11:21:24.967787Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-12T13:52:31.911218Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-12T13:52:31.912779Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T11:38:32.071317Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T11:38:32.071704Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T11:38:32.073211Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4892 ... 2022-07-13T11:38:32.123953Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T11:38:32.124434Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T11:38:32.124826Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T11:38:32.125150Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T11:38:32.127099Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T11:38:32.128921Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T11:38:32.132097Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T11:38:32.139639Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T11:38:32.170463Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T11:38:32.173105Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765599 2022-07-13T11:38:32.173642Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765608 2022-07-13T11:38:32.174151Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T11:38:32.175716Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T11:38:32.869709Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T11:38:32.870189Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T11:38:32.870922Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T11:38:32.881800Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T11:38:32.883727Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T11:38:32.884383Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T11:38:32.885061Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T11:38:32.942248Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765608 2022-07-13T11:38:32.943075Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T11:38:32.943558Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T11:38:32.952672Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 19:38:32 2022-07-13T11:38:32.962176Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T11:38:32.962834Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T11:38:32.966844Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T11:38:32.967626Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T11:38:32.970228Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T11:38:32.971159Z 0 [Note] IPv6 is available. 2022-07-13T11:38:32.971455Z 0 [Note] - '::' resolves to '::'; 2022-07-13T11:38:32.971787Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T11:38:33.085588Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T11:38:33.086302Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:21:22.823719Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T12:21:22.825315Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T12:40:52.114268Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:40:52.114324Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:40:52.114792Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 19428 ... 2022-07-13T12:40:52.121215Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:40:52.121708Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:40:52.122021Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:40:52.122355Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:40:52.122948Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:40:52.123321Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:40:52.125852Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:40:52.131002Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:40:52.163404Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:40:52.165303Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765627 2022-07-13T12:40:52.165776Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765636 2022-07-13T12:40:52.166258Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T12:40:52.166626Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T12:40:52.740372Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:40:52.740864Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:40:52.741708Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:40:52.750347Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:40:52.752918Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:40:52.753450Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:40:52.754252Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:40:52.810206Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765636 2022-07-13T12:40:52.813816Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:40:52.813820Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:40:52.824992Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:40:52.825481Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:40:52 2022-07-13T12:40:52.825764Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:40:52.827941Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:40:52.828463Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:40:52.830954Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:40:52.831979Z 0 [Note] IPv6 is available. 2022-07-13T12:40:52.832295Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:40:52.832650Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:40:52.875437Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:40:52.875980Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:41:12.485086Z 0 [Note] MySQL: Normal shutdown 2022-07-13T12:41:12.485574Z 0 [Note] Giving 2 client threads a chance to die gracefully 2022-07-13T12:41:12.486001Z 0 [Note] Shutting down slave threads 2022-07-13T12:41:14.487494Z 0 [Note] Forcefully disconnecting 2 remaining clients 2022-07-13T12:41:14.487826Z 0 [Warning] MySQL: Forcing close of thread 2 user: 'root' 2022-07-13T12:41:14.488215Z 0 [Warning] MySQL: Forcing close of thread 3 user: 'root' 2022-07-13T12:41:14.488636Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T12:41:14.490922Z 0 [Note] Binlog end 2022-07-13T12:41:14.492044Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T12:41:14.492279Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T12:41:14.492535Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T12:41:14.492790Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T12:41:14.493023Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T12:41:14.493303Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T12:41:14.493570Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T12:41:14.493827Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T12:41:14.494116Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T12:41:14.494413Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T12:41:14.494715Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T12:41:14.495021Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T12:41:14.495311Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T12:41:14.495595Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T12:41:14.495882Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T12:41:14.496169Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T12:41:14.496481Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T12:41:14.496746Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T12:41:14.497026Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T12:41:14.497307Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T12:41:14.497570Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T12:41:14.497855Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T12:41:14.498121Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T12:41:14.498417Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T12:41:14.498673Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T12:41:14.498955Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T12:41:14.499326Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T12:41:14.499611Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T12:41:14.499881Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T12:41:14.500178Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T12:41:14.500457Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T12:41:14.500730Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T12:41:14.500983Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T12:41:14.501246Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T12:41:14.501489Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T12:41:14.501755Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T12:41:14.502004Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T12:41:14.502248Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T12:41:14.502524Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-13T12:41:14.502925Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T12:41:14.612371Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:41:14.617524Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220713 20:41:14 2022-07-13T12:41:15.600700Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426765673 2022-07-13T12:41:15.601372Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:41:15.601709Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T12:41:15.601948Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T12:41:15.602176Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T12:41:15.602443Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T12:41:15.602827Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T12:41:15.603653Z 0 [Note] MySQL: Shutdown complete 2022-07-13T12:41:28.832723Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:41:28.832779Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:41:28.833197Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 19268 ... 2022-07-13T12:41:28.839292Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:41:28.839767Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:41:28.840081Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:41:28.840414Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:41:28.840966Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:41:28.841349Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:41:28.844096Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:41:28.849721Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:41:28.878211Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:41:29.309777Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:41:29.310564Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:41:29.318362Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:41:29.320784Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:41:29.321306Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:41:29.322189Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:41:29.384109Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765673 2022-07-13T12:41:29.387765Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:41:29.387800Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:41:29.400288Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:41:29.400992Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:41:29 2022-07-13T12:41:29.401080Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:41:29.403337Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:41:29.403854Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:41:29.406313Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:41:29.407336Z 0 [Note] IPv6 is available. 2022-07-13T12:41:29.407628Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:41:29.407985Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:41:29.450328Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:41:29.450906Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:43:37.198901Z 0 [Note] MySQL: Normal shutdown 2022-07-13T12:43:37.199440Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-13T12:43:37.199800Z 0 [Note] Shutting down slave threads 2022-07-13T12:43:37.200050Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-13T12:43:37.200368Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T12:43:37.200810Z 0 [Note] Binlog end 2022-07-13T12:43:37.201576Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T12:43:37.201833Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T12:43:37.202096Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T12:43:37.202357Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T12:43:37.202611Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T12:43:37.202918Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T12:43:37.203184Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T12:43:37.203443Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T12:43:37.203736Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T12:43:37.204035Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T12:43:37.204340Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T12:43:37.204660Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T12:43:37.204945Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T12:43:37.205225Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T12:43:37.205541Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T12:43:37.205825Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T12:43:37.206120Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T12:43:37.206436Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T12:43:37.206765Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T12:43:37.207100Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T12:43:37.207383Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T12:43:37.207692Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T12:43:37.208013Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T12:43:37.208332Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T12:43:37.208606Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T12:43:37.208904Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T12:43:37.209210Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T12:43:37.209510Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T12:43:37.209801Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T12:43:37.210116Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T12:43:37.210510Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T12:43:37.210863Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T12:43:37.211135Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T12:43:37.211420Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T12:43:37.211759Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T12:43:37.212047Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T12:43:37.212320Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T12:43:37.212586Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T12:43:37.212897Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-13T12:43:37.213303Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T12:43:37.321159Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:43:37.329528Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220713 20:43:37 2022-07-13T12:43:38.303795Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426765701 2022-07-13T12:43:38.304484Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:43:38.304828Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T12:43:38.305086Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T12:43:38.305318Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T12:43:38.305591Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T12:43:38.305982Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T12:43:38.306827Z 0 [Note] MySQL: Shutdown complete 2022-07-13T12:43:38.599846Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:43:38.599898Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:43:38.600307Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 19004 ... 2022-07-13T12:43:38.606488Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:43:38.606982Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:43:38.607304Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:43:38.607652Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:43:38.608226Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:43:38.608615Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:43:38.611328Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:43:38.616580Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:43:38.660839Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:43:39.099552Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:43:39.100344Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:43:39.108535Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:43:39.111160Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:43:39.111710Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:43:39.112405Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:43:39.166262Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765701 2022-07-13T12:43:39.167144Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:43:39.167201Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:43:39.178245Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:43:39.178884Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:43:39 2022-07-13T12:43:39.178944Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:43:39.181302Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:43:39.182038Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:43:39.182898Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:43:39.183938Z 0 [Note] IPv6 is available. 2022-07-13T12:43:39.184245Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:43:39.184697Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:43:39.227267Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:43:39.227806Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:44:44.259960Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T12:44:44.261922Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T12:45:02.958015Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:45:02.958068Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:45:02.958497Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 9476 ... 2022-07-13T12:45:02.964857Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:45:02.965379Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:45:02.965710Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:45:02.966060Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:45:02.966640Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:45:02.967024Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:45:02.969678Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:45:02.974761Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:45:03.031636Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:45:03.033483Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765720 2022-07-13T12:45:03.033983Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765729 2022-07-13T12:45:03.034449Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T12:45:03.034819Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T12:45:03.605628Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:45:03.606141Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:45:03.606883Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:45:03.615088Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:45:03.617649Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:45:03.618195Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:45:03.618909Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:45:03.670084Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765729 2022-07-13T12:45:03.671023Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:45:03.671033Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:45:03.683067Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:45:03 2022-07-13T12:45:03.683205Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:45:03.684160Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:45:03.686251Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:45:03.686822Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:45:03.687621Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:45:03.688751Z 0 [Note] IPv6 is available. 2022-07-13T12:45:03.689121Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:45:03.689522Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:45:03.731836Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:45:03.732379Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:46:07.786728Z 0 [Note] MySQL: Normal shutdown 2022-07-13T12:46:07.787286Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-13T12:46:07.787692Z 0 [Note] Shutting down slave threads 2022-07-13T12:46:07.787939Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-13T12:46:07.788249Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T12:46:07.788762Z 0 [Note] Binlog end 2022-07-13T12:46:07.789640Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T12:46:07.789894Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T12:46:07.790153Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T12:46:07.790417Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T12:46:07.790674Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T12:46:07.790982Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T12:46:07.791249Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T12:46:07.791606Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T12:46:07.791918Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T12:46:07.792209Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T12:46:07.792507Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T12:46:07.792806Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T12:46:07.793088Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T12:46:07.793366Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T12:46:07.793648Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T12:46:07.793929Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T12:46:07.794221Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T12:46:07.794511Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T12:46:07.794803Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T12:46:07.795095Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T12:46:07.795380Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T12:46:07.795713Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T12:46:07.795987Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T12:46:07.796292Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T12:46:07.796555Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T12:46:07.796845Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T12:46:07.797149Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T12:46:07.797463Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T12:46:07.797760Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T12:46:07.798071Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T12:46:07.798355Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T12:46:07.798660Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T12:46:07.798926Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T12:46:07.799202Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T12:46:07.799497Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T12:46:07.799770Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T12:46:07.800031Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T12:46:07.800284Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T12:46:07.800606Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-13T12:46:07.801004Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T12:46:07.905209Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:46:07.906962Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220713 20:46:07 2022-07-13T12:46:08.883934Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426765757 2022-07-13T12:46:08.884727Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:46:08.885075Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T12:46:08.885322Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T12:46:08.885557Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T12:46:08.885832Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T12:46:08.886225Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T12:46:08.887028Z 0 [Note] MySQL: Shutdown complete 2022-07-13T12:49:48.568280Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:49:48.568405Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:49:48.568925Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 1284 ... 2022-07-13T12:49:48.575635Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:49:48.576144Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:49:48.576461Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:49:48.576802Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:49:48.577371Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:49:48.577750Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:49:48.580376Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:49:48.585987Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:49:48.618482Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:49:49.041681Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:49:49.042488Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:49:49.050583Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:49:49.053095Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:49:49.053640Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:49:49.054329Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:49:49.106055Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765757 2022-07-13T12:49:49.109988Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:49:49.110049Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:49:49.134133Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:49:49 2022-07-13T12:49:49.134553Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:49:49.135204Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:49:49.137287Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:49:49.137830Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:49:49.138680Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:49:49.139718Z 0 [Note] IPv6 is available. 2022-07-13T12:49:49.140047Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:49:49.140413Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:49:49.182423Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:49:49.182949Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:54:59.851580Z 0 [Note] MySQL: Normal shutdown 2022-07-13T12:54:59.852220Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-13T12:54:59.852596Z 0 [Note] Shutting down slave threads 2022-07-13T12:54:59.852848Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-13T12:54:59.853164Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T12:54:59.853562Z 0 [Note] Binlog end 2022-07-13T12:54:59.854412Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T12:54:59.854674Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T12:54:59.854969Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T12:54:59.855235Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T12:54:59.855493Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T12:54:59.855811Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T12:54:59.856087Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T12:54:59.856352Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T12:54:59.856683Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T12:54:59.856997Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T12:54:59.857314Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T12:54:59.857633Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T12:54:59.857934Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T12:54:59.858228Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T12:54:59.858528Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T12:54:59.858827Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T12:54:59.859144Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T12:54:59.859440Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T12:54:59.859767Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T12:54:59.860073Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T12:54:59.860359Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T12:54:59.860670Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T12:54:59.860960Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T12:54:59.861286Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T12:54:59.861568Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T12:54:59.861884Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T12:54:59.862323Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T12:54:59.862718Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T12:54:59.863127Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T12:54:59.863515Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T12:54:59.863822Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T12:54:59.864393Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T12:54:59.864670Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T12:54:59.864959Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T12:54:59.865222Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T12:54:59.865665Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T12:54:59.865949Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T12:54:59.866219Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T12:54:59.866531Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-13T12:54:59.866917Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T12:54:59.981560Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:54:59.983202Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220713 20:54:59 2022-07-13T12:55:00.967230Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426765785 2022-07-13T12:55:00.968052Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:55:00.968431Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T12:55:00.968680Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T12:55:00.968915Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T12:55:00.969191Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T12:55:00.969584Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T12:55:00.970767Z 0 [Note] MySQL: Shutdown complete 2022-07-13T12:55:02.772297Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:55:02.772375Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:55:02.772816Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 18456 ... 2022-07-13T12:55:02.786190Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:55:02.786799Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:55:02.787134Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:55:02.787482Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:55:02.788136Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:55:02.788672Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:55:02.791559Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:55:02.796807Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:55:02.836378Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:55:03.268737Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:55:03.269559Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:55:03.277524Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:55:03.280295Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:55:03.280859Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:55:03.281626Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:55:03.340114Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765785 2022-07-13T12:55:03.341035Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:55:03.341075Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:55:03.352219Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:55:03.352925Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:55:03.352948Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:55:03 2022-07-13T12:55:03.354879Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:55:03.355452Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:55:03.356362Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:55:03.357428Z 0 [Note] IPv6 is available. 2022-07-13T12:55:03.357736Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:55:03.358109Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:55:03.400959Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:55:03.401487Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:55:30.771455Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T12:55:30.773002Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T12:55:49.364069Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:55:49.364122Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:55:49.364555Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 10704 ... 2022-07-13T12:55:49.377332Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:55:49.377945Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:55:49.378295Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:55:49.378755Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:55:49.379352Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:55:49.379754Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:55:49.382556Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:55:49.388010Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:55:49.417272Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:55:49.419300Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765804 2022-07-13T12:55:49.419805Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426765813 2022-07-13T12:55:49.420294Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T12:55:49.420677Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T12:55:49.965393Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:55:49.965894Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:55:49.966631Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:55:49.974476Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:55:49.977057Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:55:49.977602Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:55:49.978567Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:55:50.031812Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426765813 2022-07-13T12:55:50.032677Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:55:50.032703Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:55:50.044158Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:55:50 2022-07-13T12:55:50.044241Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:55:50.045185Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:55:50.047587Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:55:50.048199Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:55:50.049000Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:55:50.050038Z 0 [Note] IPv6 is available. 2022-07-13T12:55:50.050340Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:55:50.050704Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:55:50.092298Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:55:50.092844Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:56:17.890165Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T12:56:17.891648Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T12:56:58.912614Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:56:58.912675Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:56:58.913362Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 3404 ... 2022-07-13T12:56:58.927262Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:56:58.927907Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:56:58.928313Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:56:58.928660Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:56:58.929338Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:56:58.929775Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:56:58.932450Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:56:58.937713Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:56:58.972462Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:56:58.974273Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426765848 2022-07-13T12:56:58.974854Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773339 2022-07-13T12:56:58.981387Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T12:56:58.981793Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T12:56:59.033306Z 0 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 2022-07-13T12:56:59.549531Z 0 [Note] InnoDB: Apply batch completed 2022-07-13T12:57:00.029963Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:57:00.030477Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:57:00.031217Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:57:00.038609Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:57:00.041273Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:57:00.041993Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:57:00.042881Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:57:00.103442Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773339 2022-07-13T12:57:00.106223Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-07-13T12:57:00.108948Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:57:00.108953Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:57:00.121227Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:57:00.122147Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:57:00.122308Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:57:00 2022-07-13T12:57:00.124102Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:57:00.124624Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:57:00.125378Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:57:00.126487Z 0 [Note] IPv6 is available. 2022-07-13T12:57:00.126787Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:57:00.127151Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:57:00.169614Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:57:00.170188Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:57:09.959837Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T12:57:09.961479Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T12:57:32.240012Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:57:32.240065Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:57:32.240465Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 20972 ... 2022-07-13T12:57:32.253596Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:57:32.254187Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:57:32.254516Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:57:32.254858Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:57:32.255455Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:57:32.255841Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:57:32.258553Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:57:32.263868Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:57:32.296925Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:57:32.298738Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773607 2022-07-13T12:57:32.299231Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773616 2022-07-13T12:57:32.299712Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T12:57:32.300093Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T12:57:32.845086Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:57:32.845609Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:57:32.846360Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:57:32.855351Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:57:32.857773Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:57:32.858320Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:57:32.859058Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:57:32.911306Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773616 2022-07-13T12:57:32.911907Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-07-13T12:57:32.912766Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:57:32.912776Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:57:32.923851Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:57:32.924528Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:57:32.925025Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:57:32 2022-07-13T12:57:32.926448Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:57:32.927149Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:57:32.928064Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:57:32.929115Z 0 [Note] IPv6 is available. 2022-07-13T12:57:32.929416Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:57:32.929776Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:57:32.972290Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:57:32.972883Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:57:41.925315Z 0 [Note] MySQL: Normal shutdown 2022-07-13T12:57:41.925848Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-13T12:57:41.926204Z 0 [Note] Shutting down slave threads 2022-07-13T12:57:41.926453Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-13T12:57:41.926768Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T12:57:41.927190Z 0 [Note] Binlog end 2022-07-13T12:57:41.928444Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T12:57:41.928698Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T12:57:41.928956Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T12:57:41.929215Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T12:57:41.929681Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T12:57:41.930102Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T12:57:41.930383Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T12:57:41.930649Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T12:57:41.930954Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T12:57:41.931245Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T12:57:41.931544Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T12:57:41.931845Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T12:57:41.932128Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T12:57:41.932409Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T12:57:41.932693Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T12:57:41.932976Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T12:57:41.933269Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T12:57:41.933550Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T12:57:41.933845Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T12:57:41.934141Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T12:57:41.934419Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T12:57:41.934731Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T12:57:41.935010Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T12:57:41.935320Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T12:57:41.935591Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T12:57:41.935889Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T12:57:41.936195Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T12:57:41.936493Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T12:57:41.936778Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T12:57:41.937090Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T12:57:41.937379Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T12:57:41.937667Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T12:57:41.937932Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T12:57:41.938208Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T12:57:41.938463Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T12:57:41.938745Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T12:57:41.939009Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T12:57:41.939266Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T12:57:41.939557Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-13T12:57:41.939947Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T12:57:42.049784Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:57:42.051581Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220713 20:57:42 2022-07-13T12:57:42.597035Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426773644 2022-07-13T12:57:42.597836Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T12:57:42.598262Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T12:57:42.598508Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T12:57:42.598739Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T12:57:42.599013Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T12:57:42.599401Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T12:57:42.603529Z 0 [Note] MySQL: Shutdown complete 2022-07-13T12:58:23.102842Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T12:58:23.102895Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T12:58:23.103310Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 17788 ... 2022-07-13T12:58:23.117111Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T12:58:23.117715Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T12:58:23.118041Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T12:58:23.118385Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T12:58:23.118957Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T12:58:23.119346Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T12:58:23.122391Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T12:58:23.128141Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T12:58:23.171467Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T12:58:23.600046Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T12:58:23.600972Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T12:58:23.614590Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T12:58:23.617258Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T12:58:23.617824Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T12:58:23.618631Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T12:58:23.675200Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773644 2022-07-13T12:58:23.679018Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T12:58:23.679031Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T12:58:23.695482Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T12:58:23.696185Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T12:58:23.696217Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 20:58:23 2022-07-13T12:58:23.698166Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T12:58:23.698743Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T12:58:23.699523Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T12:58:23.700571Z 0 [Note] IPv6 is available. 2022-07-13T12:58:23.700878Z 0 [Note] - '::' resolves to '::'; 2022-07-13T12:58:23.701245Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T12:58:23.744454Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T12:58:23.744991Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T12:58:47.715561Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T12:58:47.717140Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T13:00:29.776151Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:00:29.776206Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:00:29.776713Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 21768 ... 2022-07-13T13:00:29.790872Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:00:29.791533Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:00:29.791873Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:00:29.792219Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:00:29.792835Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:00:29.793216Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:00:29.796021Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:00:29.801645Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:00:29.848926Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:00:29.850878Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773663 2022-07-13T13:00:29.851346Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773672 2022-07-13T13:00:29.851824Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T13:00:29.852200Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T13:00:30.388335Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:00:30.388840Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:00:30.389557Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:00:30.396854Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:00:30.399283Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T13:00:30.399813Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T13:00:30.400535Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T13:00:30.456638Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773672 2022-07-13T13:00:30.457205Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-07-13T13:00:30.458027Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:00:30.458044Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:00:30.469055Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:00:30.469598Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 21:00:30 2022-07-13T13:00:30.469723Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:00:30.471876Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:00:30.472498Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:00:30.473379Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:00:30.474558Z 0 [Note] IPv6 is available. 2022-07-13T13:00:30.474890Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:00:30.475264Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:00:30.517408Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:00:30.518093Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:00:37.583380Z 0 [Note] MySQL: Normal shutdown 2022-07-13T13:00:37.583846Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-13T13:00:37.584202Z 0 [Note] Shutting down slave threads 2022-07-13T13:00:37.584449Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-13T13:00:37.584771Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T13:00:37.585162Z 0 [Note] Binlog end 2022-07-13T13:00:37.586033Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T13:00:37.586290Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T13:00:37.586554Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T13:00:37.586815Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T13:00:37.587067Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T13:00:37.587388Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T13:00:37.587649Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T13:00:37.587904Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T13:00:37.588192Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T13:00:37.588484Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T13:00:37.588784Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T13:00:37.589086Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T13:00:37.589454Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T13:00:37.589736Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T13:00:37.590021Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T13:00:37.590305Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T13:00:37.590601Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T13:00:37.590923Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T13:00:37.591213Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T13:00:37.591535Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T13:00:37.591951Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T13:00:37.592362Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T13:00:37.592689Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T13:00:37.592997Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T13:00:37.593260Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T13:00:37.593555Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T13:00:37.593854Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T13:00:37.594147Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T13:00:37.594425Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T13:00:37.594733Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T13:00:37.595019Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T13:00:37.595301Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T13:00:37.595564Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T13:00:37.595841Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T13:00:37.596094Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T13:00:37.596372Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T13:00:37.596633Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T13:00:37.596885Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T13:00:37.597176Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-13T13:00:37.597588Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T13:00:37.711325Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:00:37.716718Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220713 21:00:37 2022-07-13T13:00:38.913325Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426773700 2022-07-13T13:00:38.914085Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:00:38.914453Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T13:00:38.914770Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T13:00:38.915055Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T13:00:38.915440Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T13:00:38.915831Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T13:00:38.919805Z 0 [Note] MySQL: Shutdown complete 2022-07-13T13:00:45.958963Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:00:45.959023Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:00:45.959443Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 3004 ... 2022-07-13T13:00:45.972403Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:00:45.973005Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:00:45.973328Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:00:45.973672Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:00:45.974262Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:00:45.974657Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:00:45.977531Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:00:45.982662Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:00:46.013537Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:00:46.436834Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:00:46.437632Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:00:46.445163Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:00:46.447651Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T13:00:46.448191Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T13:00:46.448900Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T13:00:46.501901Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773700 2022-07-13T13:00:46.502817Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:00:46.502875Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:00:46.513304Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:00:46.513972Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:00:46.514510Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 21:00:46 2022-07-13T13:00:46.515890Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:00:46.516413Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:00:46.517386Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:00:46.518437Z 0 [Note] IPv6 is available. 2022-07-13T13:00:46.518737Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:00:46.519260Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:00:46.561551Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:00:46.562090Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:01:04.727979Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T13:01:04.729505Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T13:19:51.428008Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:19:51.428062Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:19:51.428495Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 11180 ... 2022-07-13T13:19:51.441500Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:19:51.442136Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:19:51.442637Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:19:51.442990Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:19:51.443630Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:19:51.444037Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:19:51.447084Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:19:51.453632Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:19:51.491361Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:19:51.493280Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773719 2022-07-13T13:19:51.493788Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773728 2022-07-13T13:19:51.494305Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T13:19:51.494694Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T13:19:52.045775Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:19:52.046356Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:19:52.047135Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:19:52.054429Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:19:52.056924Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T13:19:52.057480Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T13:19:52.058322Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T13:19:52.121634Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773728 2022-07-13T13:19:52.122592Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:19:52.122650Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:19:52.132502Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:19:52.133212Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:19:52.135125Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 21:19:52 2022-07-13T13:19:52.135259Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:19:52.136055Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:19:52.136954Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:19:52.138293Z 0 [Note] IPv6 is available. 2022-07-13T13:19:52.138626Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:19:52.138985Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:19:52.182063Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:19:52.182596Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:19:59.916246Z 3 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T13:19:59.917739Z 3 [ERROR] InnoDB: Server exits. 2022-07-13T13:20:48.583919Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:20:48.583972Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:20:48.584413Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 84 ... 2022-07-13T13:20:48.596928Z 0 [Note] InnoDB: Started in read only mode 2022-07-13T13:20:48.597425Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:20:48.597895Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:20:48.598210Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:20:48.598616Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:20:48.599204Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:20:48.599588Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:20:48.599957Z 0 [Note] InnoDB: Disabling background log and ibuf IO write threads. 2022-07-13T13:20:48.601085Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:20:48.606215Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:20:48.645348Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:20:48.646338Z 0 [Note] InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on, skipping log redo 2022-07-13T13:20:48.649098Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:20:48.649558Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:20:48.650396Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:20:48.658278Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:20:48.662389Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 0 2022-07-13T13:20:48.662824Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!! 2022-07-13T13:20:48.663609Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:20:48.665334Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`plugin` in the cache. Attempting to load the tablespace with space id 2 2022-07-13T13:20:48.671077Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`gtid_executed` in the cache. Attempting to load the tablespace with space id 18 2022-07-13T13:20:48.677573Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:20:48.678289Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:20:48.680312Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:20:48.680896Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:20:48.681661Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:20:48.682701Z 0 [Note] IPv6 is available. 2022-07-13T13:20:48.683003Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:20:48.683356Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:20:48.684218Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`server_cost` in the cache. Attempting to load the tablespace with space id 19 2022-07-13T13:20:48.688898Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`engine_cost` in the cache. Attempting to load the tablespace with space id 20 2022-07-13T13:20:48.700802Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_leap_second` in the cache. Attempting to load the tablespace with space id 12 2022-07-13T13:20:48.705513Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_name` in the cache. Attempting to load the tablespace with space id 8 2022-07-13T13:20:48.710539Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone` in the cache. Attempting to load the tablespace with space id 9 2022-07-13T13:20:48.715340Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition_type` in the cache. Attempting to load the tablespace with space id 11 2022-07-13T13:20:48.719874Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition` in the cache. Attempting to load the tablespace with space id 10 2022-07-13T13:20:48.726860Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`servers` in the cache. Attempting to load the tablespace with space id 3 2022-07-13T13:20:48.749306Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:20:48.749863Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:20:51.935121Z 0 [Note] MySQL: Normal shutdown 2022-07-13T13:20:51.935598Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-13T13:20:51.935950Z 0 [Note] Shutting down slave threads 2022-07-13T13:20:51.936196Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-13T13:20:51.936504Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T13:20:51.936942Z 0 [Note] Binlog end 2022-07-13T13:20:51.937677Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T13:20:51.937930Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T13:20:51.938204Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T13:20:51.938457Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T13:20:51.938702Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T13:20:51.939002Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T13:20:51.939263Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T13:20:51.939513Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T13:20:51.939890Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T13:20:51.940384Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T13:20:51.940687Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T13:20:51.941025Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T13:20:51.941320Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T13:20:51.941596Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T13:20:51.941875Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T13:20:51.942154Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T13:20:51.942445Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T13:20:51.942721Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T13:20:51.943011Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T13:20:51.943343Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T13:20:51.943620Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T13:20:51.944030Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T13:20:51.944357Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T13:20:51.944718Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T13:20:51.944986Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T13:20:51.945362Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T13:20:51.945698Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T13:20:51.946089Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T13:20:51.946460Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T13:20:51.946885Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T13:20:51.947327Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T13:20:51.947634Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T13:20:51.947953Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T13:20:51.948312Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T13:20:51.948565Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T13:20:51.948892Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T13:20:51.949169Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T13:20:51.949436Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T13:20:51.949692Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T13:20:53.037907Z 0 [Note] InnoDB: Shutdown completed; log sequence number 8204 2022-07-13T13:20:53.038734Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:20:53.039146Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T13:20:53.039396Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T13:20:53.039634Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T13:20:53.039948Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T13:20:53.040332Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T13:20:53.044730Z 0 [Note] MySQL: Shutdown complete 2022-07-13T13:20:54.677806Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:20:54.677859Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:20:54.678278Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 20836 ... 2022-07-13T13:20:54.691555Z 0 [Note] InnoDB: Started in read only mode 2022-07-13T13:20:54.692054Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:20:54.692525Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:20:54.692840Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:20:54.693198Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:20:54.693778Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:20:54.694168Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:20:54.694621Z 0 [Note] InnoDB: Disabling background log and ibuf IO write threads. 2022-07-13T13:20:54.695707Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:20:54.701040Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:20:54.743262Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:20:54.744097Z 0 [Note] InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on, skipping log redo 2022-07-13T13:20:54.746399Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:20:54.747165Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:20:54.760689Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:20:54.765465Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 0 2022-07-13T13:20:54.765930Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!! 2022-07-13T13:20:54.766486Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:20:54.768201Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`plugin` in the cache. Attempting to load the tablespace with space id 2 2022-07-13T13:20:54.774200Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`gtid_executed` in the cache. Attempting to load the tablespace with space id 18 2022-07-13T13:20:54.780698Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:20:54.781397Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:20:54.783285Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:20:54.783867Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:20:54.784639Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:20:54.785682Z 0 [Note] IPv6 is available. 2022-07-13T13:20:54.785982Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:20:54.786339Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:20:54.787203Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`server_cost` in the cache. Attempting to load the tablespace with space id 19 2022-07-13T13:20:54.792668Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`engine_cost` in the cache. Attempting to load the tablespace with space id 20 2022-07-13T13:20:54.804750Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_leap_second` in the cache. Attempting to load the tablespace with space id 12 2022-07-13T13:20:54.810089Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_name` in the cache. Attempting to load the tablespace with space id 8 2022-07-13T13:20:54.814922Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone` in the cache. Attempting to load the tablespace with space id 9 2022-07-13T13:20:54.819624Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition_type` in the cache. Attempting to load the tablespace with space id 11 2022-07-13T13:20:54.824634Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition` in the cache. Attempting to load the tablespace with space id 10 2022-07-13T13:20:54.831782Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`servers` in the cache. Attempting to load the tablespace with space id 3 2022-07-13T13:20:54.855037Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:20:54.855698Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:21:24.259055Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_adjust_factor` in the cache. Attempting to load the tablespace with space id 721 2022-07-13T13:21:24.267966Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_all_performance_express_report` in the cache. Attempting to load the tablespace with space id 728 2022-07-13T13:21:24.273702Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_all_stock` in the cache. Attempting to load the tablespace with space id 757 2022-07-13T13:21:24.279112Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_all_trade_dates` in the cache. Attempting to load the tablespace with space id 730 2022-07-13T13:21:24.284653Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_balance_data` in the cache. Attempting to load the tablespace with space id 725 2022-07-13T13:21:24.289791Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_cash_flow_data` in the cache. Attempting to load the tablespace with space id 726 2022-07-13T13:21:24.294980Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_deposit_rate_data` in the cache. Attempting to load the tablespace with space id 732 2022-07-13T13:21:24.300180Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_dividend_data` in the cache. Attempting to load the tablespace with space id 720 2022-07-13T13:21:24.304856Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_dupont_data` in the cache. Attempting to load the tablespace with space id 727 2022-07-13T13:21:24.309654Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_forecast_report` in the cache. Attempting to load the tablespace with space id 729 2022-07-13T13:21:24.314693Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_growth_data` in the cache. Attempting to load the tablespace with space id 724 2022-07-13T13:21:24.319531Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_history_k_data_plus` in the cache. Attempting to load the tablespace with space id 790 2022-07-13T13:21:24.324256Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_hs300_stocks` in the cache. Attempting to load the tablespace with space id 743 2022-07-13T13:21:24.328824Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_loan_rate_data` in the cache. Attempting to load the tablespace with space id 736 2022-07-13T13:21:24.333554Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_money_supply_data_month` in the cache. Attempting to load the tablespace with space id 738 2022-07-13T13:21:24.338170Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_money_supply_data_year` in the cache. Attempting to load the tablespace with space id 739 2022-07-13T13:21:24.342851Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_operation_data` in the cache. Attempting to load the tablespace with space id 723 2022-07-13T13:21:24.348305Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_performance_express_report` in the cache. Attempting to load the tablespace with space id 733 2022-07-13T13:21:24.352939Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_profit_data` in the cache. Attempting to load the tablespace with space id 722 2022-07-13T13:21:24.357506Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_required_reserve_ratio_data` in the cache. Attempting to load the tablespace with space id 737 2022-07-13T13:21:24.362295Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_shibor_data` in the cache. Attempting to load the tablespace with space id 740 2022-07-13T13:21:24.367075Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_stock_basic` in the cache. Attempting to load the tablespace with space id 718 2022-07-13T13:21:24.371828Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_stock_industry` in the cache. Attempting to load the tablespace with space id 741 2022-07-13T13:21:24.376966Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_sz50_stocks` in the cache. Attempting to load the tablespace with space id 742 2022-07-13T13:21:24.381540Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_trade_dates` in the cache. Attempting to load the tablespace with space id 717 2022-07-13T13:21:24.386112Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`baostock_zz500_stocks` in the cache. Attempting to load the tablespace with space id 744 2022-07-13T13:21:24.390659Z 3 [ERROR] InnoDB: Failed to find tablespace for table `stock_analyser`.`tongdaxin_k_line_1d_ds` in the cache. Attempting to load the tablespace with space id 715 2022-07-13T13:21:45.229334Z 0 [Note] MySQL: Normal shutdown 2022-07-13T13:21:45.229998Z 0 [Note] Giving 2 client threads a chance to die gracefully 2022-07-13T13:21:45.230350Z 0 [Note] Shutting down slave threads 2022-07-13T13:21:47.238853Z 0 [Note] Forcefully disconnecting 2 remaining clients 2022-07-13T13:21:47.240611Z 0 [Warning] MySQL: Forcing close of thread 2 user: 'root' 2022-07-13T13:21:47.242630Z 0 [Warning] MySQL: Forcing close of thread 3 user: 'root' 2022-07-13T13:21:47.243125Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T13:21:47.243621Z 0 [Note] Binlog end 2022-07-13T13:21:47.244718Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T13:21:47.244979Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T13:21:47.245231Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T13:21:47.245484Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T13:21:47.245766Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T13:21:47.246067Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T13:21:47.246321Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T13:21:47.246565Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T13:21:47.246875Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T13:21:47.247158Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T13:21:47.247449Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T13:21:47.247745Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T13:21:47.248022Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T13:21:47.248295Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T13:21:47.248572Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T13:21:47.248850Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T13:21:47.249137Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T13:21:47.249412Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T13:21:47.249730Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T13:21:47.250017Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T13:21:47.250288Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T13:21:47.250582Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T13:21:47.250886Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T13:21:47.251191Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T13:21:47.251454Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T13:21:47.251777Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T13:21:47.252075Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T13:21:47.252366Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T13:21:47.252644Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T13:21:47.252979Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T13:21:47.253263Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T13:21:47.253544Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T13:21:47.253804Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T13:21:47.254074Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T13:21:47.254323Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T13:21:47.254602Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T13:21:47.255136Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T13:21:47.255537Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T13:21:47.256115Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T13:21:48.671502Z 0 [Note] InnoDB: Shutdown completed; log sequence number 8204 2022-07-13T13:21:48.672719Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:21:48.673085Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T13:21:48.673353Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T13:21:48.673581Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T13:21:48.673849Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T13:21:48.674263Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T13:21:48.678334Z 0 [Note] MySQL: Shutdown complete 2022-07-13T13:22:18.195791Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:22:18.195846Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:22:18.196284Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 13660 ... 2022-07-13T13:22:18.209624Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:22:18.210327Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:22:18.210726Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:22:18.211074Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:22:18.211651Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:22:18.212039Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:22:18.214832Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:22:18.220034Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:22:18.252962Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:22:18.254844Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773747 2022-07-13T13:22:18.255436Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773756 2022-07-13T13:22:18.255974Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T13:22:18.256356Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T13:22:18.807851Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:22:18.808660Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:22:18.816208Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:22:18.818746Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T13:22:18.819295Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T13:22:18.820120Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T13:22:18.883951Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773756 2022-07-13T13:22:18.884820Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:22:18.884879Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:22:18.896743Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 21:22:18 2022-07-13T13:22:18.896974Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:22:18.897768Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:22:18.899780Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:22:18.900341Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:22:18.901126Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:22:18.902177Z 0 [Note] IPv6 is available. 2022-07-13T13:22:18.902559Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:22:18.902925Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:22:18.946798Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:22:18.947857Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:22:27.481804Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T13:22:27.483361Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T13:22:42.412349Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:22:42.412402Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:22:42.412813Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 19164 ... 2022-07-13T13:22:42.426301Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:22:42.426938Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:22:42.427263Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:22:42.427605Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:22:42.428176Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:22:42.428560Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:22:42.431282Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:22:42.436420Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:22:42.468462Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:22:42.470475Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773775 2022-07-13T13:22:42.471012Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773784 2022-07-13T13:22:42.471526Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T13:22:42.471909Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T13:22:43.014495Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:22:43.015022Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:22:43.015738Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:22:43.023384Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:22:43.025869Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T13:22:43.026405Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T13:22:43.027141Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T13:22:43.081871Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773784 2022-07-13T13:22:43.082691Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:22:43.082702Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:22:43.094208Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:22:43.094595Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 21:22:43 2022-07-13T13:22:43.094893Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:22:43.097074Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:22:43.097667Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:22:43.098514Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:22:43.099602Z 0 [Note] IPv6 is available. 2022-07-13T13:22:43.099903Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:22:43.100263Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:22:43.142094Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:22:43.142624Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:23:04.413626Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T13:23:04.415156Z 2 [ERROR] InnoDB: Server exits. 2022-07-13T13:23:15.865448Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:23:15.865499Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:23:15.865918Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 10084 ... 2022-07-13T13:23:15.879677Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:23:15.880249Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:23:15.880575Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:23:15.880918Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:23:15.881484Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:23:15.881872Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:23:15.884521Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:23:15.889696Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:23:15.923350Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:23:15.925325Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773803 2022-07-13T13:23:15.925807Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773812 2022-07-13T13:23:15.926283Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T13:23:15.926662Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T13:23:16.477409Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:23:16.477922Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:23:16.478658Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:23:16.486319Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:23:16.488769Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T13:23:16.489420Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T13:23:16.490321Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T13:23:16.550882Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773812 2022-07-13T13:23:16.551799Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:23:16.551834Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:23:16.563071Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:23:16.563571Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 21:23:16 2022-07-13T13:23:16.563771Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:23:16.565956Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:23:16.566527Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:23:16.567444Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:23:16.568637Z 0 [Note] IPv6 is available. 2022-07-13T13:23:16.568977Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:23:16.569342Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:23:16.610491Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:23:16.611101Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T13:23:25.052049Z 2 [Note] Access denied for user 'ODBC'@'localhost' (using password: NO) 2022-07-13T13:36:10.464856Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2022-07-13T13:36:41.411436Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2022-07-13T13:43:16.692067Z 8 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-13T13:43:16.693852Z 8 [ERROR] InnoDB: Server exits. 2022-07-13T13:50:52.116692Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-13T13:50:52.116746Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-13T13:50:52.117233Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 10588 ... 2022-07-13T13:50:52.131086Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-13T13:50:52.131677Z 0 [Note] InnoDB: Uses event mutexes 2022-07-13T13:50:52.132003Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-13T13:50:52.132348Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-13T13:50:52.132931Z 0 [Note] InnoDB: Number of pools: 1 2022-07-13T13:50:52.133321Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-13T13:50:52.136311Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-13T13:50:52.141331Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-13T13:50:52.181687Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-13T13:50:52.183690Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773831 2022-07-13T13:50:52.184201Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773840 2022-07-13T13:50:52.184681Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-13T13:50:52.185143Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-13T13:50:52.745073Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T13:50:52.745591Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-13T13:50:52.746340Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-13T13:50:52.754289Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-13T13:50:52.757170Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-13T13:50:52.757712Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-13T13:50:52.758525Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-13T13:50:52.816524Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773840 2022-07-13T13:50:52.817484Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-13T13:50:52.817505Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T13:50:52.829217Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-13T13:50:52.829956Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220713 21:50:52 2022-07-13T13:50:52.829969Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-13T13:50:52.832487Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-13T13:50:52.833075Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-13T13:50:52.833920Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-13T13:50:52.835307Z 0 [Note] IPv6 is available. 2022-07-13T13:50:52.835625Z 0 [Note] - '::' resolves to '::'; 2022-07-13T13:50:52.836009Z 0 [Note] Server socket created on IP: '::'. 2022-07-13T13:50:52.880513Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-13T13:50:52.881212Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-13T15:06:10.171091Z 0 [Note] MySQL: Normal shutdown 2022-07-13T15:06:10.172242Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-07-13T15:06:10.172620Z 0 [Note] Shutting down slave threads 2022-07-13T15:06:10.172935Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-07-13T15:06:10.173255Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-07-13T15:06:10.173806Z 0 [Note] Binlog end 2022-07-13T15:06:10.174780Z 0 [Note] Shutting down plugin 'ngram' 2022-07-13T15:06:10.175038Z 0 [Note] Shutting down plugin 'partition' 2022-07-13T15:06:10.175297Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-13T15:06:10.175563Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-13T15:06:10.175818Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-13T15:06:10.176137Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-13T15:06:10.176406Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-13T15:06:10.176669Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-07-13T15:06:10.176969Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-07-13T15:06:10.177270Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-07-13T15:06:10.177577Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-07-13T15:06:10.177892Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-07-13T15:06:10.178195Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-07-13T15:06:10.178529Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-07-13T15:06:10.178824Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-07-13T15:06:10.179126Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-07-13T15:06:10.179445Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-07-13T15:06:10.179749Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-07-13T15:06:10.180063Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-07-13T15:06:10.180402Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-07-13T15:06:10.180693Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-07-13T15:06:10.181010Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-07-13T15:06:10.181306Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-07-13T15:06:10.181649Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-07-13T15:06:10.181939Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-07-13T15:06:10.182255Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-07-13T15:06:10.182582Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-07-13T15:06:10.182913Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-07-13T15:06:10.183216Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-07-13T15:06:10.183561Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-07-13T15:06:10.183907Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-07-13T15:06:10.184211Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-07-13T15:06:10.184491Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-07-13T15:06:10.184785Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-07-13T15:06:10.185061Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-07-13T15:06:10.185370Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-07-13T15:06:10.185646Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-07-13T15:06:10.185923Z 0 [Note] Shutting down plugin 'InnoDB' 2022-07-13T15:06:10.188668Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-07-13T15:06:10.189030Z 0 [Note] InnoDB: Starting shutdown... 2022-07-13T15:06:10.293057Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-13T15:06:10.294680Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220713 23:06:10 2022-07-13T15:06:11.615925Z 0 [Note] InnoDB: Shutdown completed; log sequence number 24426773877 2022-07-13T15:06:11.616460Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-13T15:06:11.616781Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-13T15:06:11.617010Z 0 [Note] Shutting down plugin 'CSV' 2022-07-13T15:06:11.617227Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-13T15:06:11.617484Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-13T15:06:11.617859Z 0 [Note] Shutting down plugin 'binlog' 2022-07-13T15:06:11.619769Z 0 [Note] MySQL: Shutdown complete 2022-07-14T11:59:07.895274Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-14T11:59:07.895671Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-14T11:59:07.896898Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 4820 ... 2022-07-14T11:59:07.938028Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-14T11:59:07.938554Z 0 [Note] InnoDB: Uses event mutexes 2022-07-14T11:59:07.938867Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-14T11:59:07.939205Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-14T11:59:07.941280Z 0 [Note] InnoDB: Number of pools: 1 2022-07-14T11:59:07.943236Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-14T11:59:07.946038Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-14T11:59:07.952889Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-14T11:59:08.027766Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-14T11:59:08.484361Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-14T11:59:08.485192Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-14T11:59:08.496117Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-14T11:59:08.498375Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-14T11:59:08.498941Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-14T11:59:08.499675Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-14T11:59:08.565087Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773877 2022-07-14T11:59:08.566299Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-14T11:59:08.585126Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-14T11:59:08.596715Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220714 19:59:08 2022-07-14T11:59:08.597962Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-14T11:59:08.598852Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-14T11:59:08.608358Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-14T11:59:08.609341Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-14T11:59:08.610525Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-14T11:59:08.611754Z 0 [Note] IPv6 is available. 2022-07-14T11:59:08.612104Z 0 [Note] - '::' resolves to '::'; 2022-07-14T11:59:08.612485Z 0 [Note] Server socket created on IP: '::'. 2022-07-14T11:59:08.693351Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-14T11:59:08.693875Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL) 2022-07-14T12:52:24.060962Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2022-07-14T12:53:58.348044Z 2 [ERROR] InnoDB: Trying to access page number 3 in space 790, space name stock_analyser/baostock_history_k_data_plus, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2022-07-14T12:53:58.349538Z 2 [ERROR] InnoDB: Server exits. 2022-07-14T12:58:13.630571Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-07-14T12:58:13.630623Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2022-07-14T12:58:13.631058Z 0 [Note] MySQL (mysqld 5.7.34) starting as process 8660 ... 2022-07-14T12:58:13.644066Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2022-07-14T12:58:13.644750Z 0 [Note] InnoDB: Uses event mutexes 2022-07-14T12:58:13.645091Z 0 [Note] InnoDB: Memory barrier is not used 2022-07-14T12:58:13.645422Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-07-14T12:58:13.645986Z 0 [Note] InnoDB: Number of pools: 1 2022-07-14T12:58:13.646356Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2022-07-14T12:58:13.648959Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-07-14T12:58:13.654011Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-14T12:58:13.687284Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-07-14T12:58:13.689049Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24426773896 2022-07-14T12:58:13.689561Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 24426773905 2022-07-14T12:58:13.690041Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-07-14T12:58:13.690408Z 0 [Note] InnoDB: Starting crash recovery. 2022-07-14T12:58:14.327423Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-14T12:58:14.327965Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-14T12:58:14.328754Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-14T12:58:14.337556Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2022-07-14T12:58:14.340087Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-07-14T12:58:14.340618Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-07-14T12:58:14.341518Z 0 [Note] InnoDB: Waiting for purge to start 2022-07-14T12:58:14.404154Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 24426773905 2022-07-14T12:58:14.407763Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\binarySoftware\mysql-5.7.34-win32\data\ib_buffer_pool 2022-07-14T12:58:14.407833Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-07-14T12:58:14.422427Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220714 20:58:14 2022-07-14T12:58:14.422711Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-07-14T12:58:14.423448Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-07-14T12:58:14.425343Z 0 [Warning] CA certificate ca.pem is self signed. 2022-07-14T12:58:14.425862Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-07-14T12:58:14.426622Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-07-14T12:58:14.427635Z 0 [Note] IPv6 is available. 2022-07-14T12:58:14.427929Z 0 [Note] - '::' resolves to '::'; 2022-07-14T12:58:14.428281Z 0 [Note] Server socket created on IP: '::'. 2022-07-14T12:58:14.470845Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-14T12:58:14.471392Z 0 [Note] MySQL: ready for connections. Version: '5.7.34' socket: '' port: 3306 MySQL Community Server (GPL)