Skip to content

Latest commit

 

History

History
166 lines (155 loc) · 13.2 KB

1-todo-2020-12-06.md

File metadata and controls

166 lines (155 loc) · 13.2 KB

切换到了mysql 数据库 5.7 的版本

$ docker logs mysqldb
2020-12-06 23:01:40+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.32-1debian10 started.
2020-12-06 23:01:41+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2020-12-06 23:01:41+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.32-1debian10 started.
2020-12-06 23:01:41+08:00 [Note] [Entrypoint]: Initializing database files
2020-12-06T15:01:41.637316Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-12-06T15:01:43.872609Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-12-06T15:01:44.535591Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-12-06T15:01:44.961598Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f4ccb5f1-37d3-11eb-8fd1-0242ac180002.
2020-12-06T15:01:45.054324Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-12-06T15:01:45.604908Z 0 [Warning] CA certificate ca.pem is self signed.
2020-12-06T15:01:45.765331Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-12-06 23:02:35+08:00 [Note] [Entrypoint]: Database files initialized
2020-12-06 23:02:35+08:00 [Note] [Entrypoint]: Starting temporary server
2020-12-06 23:02:35+08:00 [Note] [Entrypoint]: Waiting for server startup
2020-12-06T15:02:35.990607Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-12-06T15:02:35.992115Z 0 [Note] mysqld (mysqld 5.7.32) starting as process 81 ...
2020-12-06T15:02:35.995048Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-12-06T15:02:35.995066Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-06T15:02:35.995070Z 0 [Note] InnoDB: Uses event mutexes
2020-12-06T15:02:35.995075Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-12-06T15:02:35.995078Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-06T15:02:35.995082Z 0 [Note] InnoDB: Using Linux native AIO
2020-12-06T15:02:35.995320Z 0 [Note] InnoDB: Number of pools: 1
2020-12-06T15:02:35.995429Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-12-06T15:02:35.996774Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-12-06T15:02:36.007354Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-06T15:02:36.009348Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-06T15:02:36.021712Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-12-06T15:02:36.153467Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-06T15:02:36.153634Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-06T15:02:37.782713Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-12-06T15:02:37.784862Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-12-06T15:02:37.784894Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-12-06T15:02:37.785844Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2748463
2020-12-06T15:02:37.786241Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-12-06T15:02:37.786817Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-12-06T15:02:37.790246Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201206 23:02:37
2020-12-06T15:02:37.803947Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-12-06T15:02:37.803988Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-12-06T15:02:37.806098Z 0 [Warning] CA certificate ca.pem is self signed.
2020-12-06T15:02:37.806183Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-12-06T15:02:37.950541Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2020-12-06T15:02:37.973492Z 0 [Note] Event Scheduler: Loaded 0 events
2020-12-06T15:02:37.974048Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
2020-12-06 23:02:38+08:00 [Note] [Entrypoint]: Temporary server started.
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2020-12-06 23:02:54+08:00 [Note] [Entrypoint]: Creating database stock_data

2020-12-06 23:02:54+08:00 [Note] [Entrypoint]: Stopping temporary server
2020-12-06T15:02:54.825959Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-12-06T15:02:54.825987Z 0 [Note] Shutting down slave threads
2020-12-06T15:02:54.825992Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-12-06T15:02:54.825998Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-12-06T15:02:54.826139Z 0 [Note] Binlog end
2020-12-06T15:02:54.826658Z 0 [Note] Shutting down plugin 'ngram'
2020-12-06T15:02:54.826669Z 0 [Note] Shutting down plugin 'partition'
2020-12-06T15:02:54.826673Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-12-06T15:02:54.826677Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-12-06T15:02:54.826682Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-12-06T15:02:54.826714Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-12-06T15:02:54.826723Z 0 [Note] Shutting down plugin 'MyISAM'
2020-12-06T15:02:54.826732Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-12-06T15:02:54.826737Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-12-06T15:02:54.826741Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-12-06T15:02:54.826746Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-12-06T15:02:54.826749Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-12-06T15:02:54.826786Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-12-06T15:02:54.826791Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-12-06T15:02:54.826795Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-12-06T15:02:54.826800Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-12-06T15:02:54.826804Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-12-06T15:02:54.826808Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-12-06T15:02:54.826811Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-12-06T15:02:54.826813Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-12-06T15:02:54.826816Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-12-06T15:02:54.826819Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-12-06T15:02:54.826822Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-12-06T15:02:54.826825Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-12-06T15:02:54.826828Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-12-06T15:02:54.826831Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-12-06T15:02:54.826834Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-12-06T15:02:54.826836Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-12-06T15:02:54.826839Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-12-06T15:02:54.826842Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-12-06T15:02:54.826845Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-12-06T15:02:54.826848Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-12-06T15:02:54.826851Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-12-06T15:02:54.826854Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-12-06T15:02:54.826857Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-12-06T15:02:54.826859Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-12-06T15:02:54.826862Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-12-06T15:02:54.826910Z 0 [Note] Shutting down plugin 'InnoDB'
2020-12-06T15:02:54.826953Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-12-06T15:02:54.827046Z 0 [Note] InnoDB: Starting shutdown...
2020-12-06T15:02:54.927339Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-12-06T15:02:54.993267Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201206 23:02:54
2020-12-06T15:02:57.668186Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12619636
2020-12-06T15:02:57.673193Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-06T15:02:57.673260Z 0 [Note] Shutting down plugin 'MEMORY'
2020-12-06T15:02:57.673278Z 0 [Note] Shutting down plugin 'CSV'
2020-12-06T15:02:57.673291Z 0 [Note] Shutting down plugin 'sha256_password'
2020-12-06T15:02:57.673302Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-12-06T15:02:57.673866Z 0 [Note] Shutting down plugin 'binlog'
2020-12-06T15:02:57.677294Z 0 [Note] mysqld: Shutdown complete

2020-12-06 23:02:57+08:00 [Note] [Entrypoint]: Temporary server stopped

2020-12-06 23:02:57+08:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.

2020-12-06T15:02:58.038797Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-12-06T15:02:58.040198Z 0 [Note] mysqld (mysqld 5.7.32) starting as process 1 ...
2020-12-06T15:02:58.043137Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-12-06T15:02:58.043152Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-06T15:02:58.043155Z 0 [Note] InnoDB: Uses event mutexes
2020-12-06T15:02:58.043158Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-12-06T15:02:58.043161Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-06T15:02:58.043163Z 0 [Note] InnoDB: Using Linux native AIO
2020-12-06T15:02:58.043392Z 0 [Note] InnoDB: Number of pools: 1
2020-12-06T15:02:58.043486Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-12-06T15:02:58.044796Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-12-06T15:02:58.055082Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-06T15:02:58.057154Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-06T15:02:58.068627Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-12-06T15:02:58.191412Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-06T15:02:58.191760Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-06T15:02:58.636078Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-12-06T15:02:58.638452Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-12-06T15:02:58.638497Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-12-06T15:02:58.639548Z 0 [Note] InnoDB: Waiting for purge to start
2020-12-06T15:02:58.689910Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 12619636
2020-12-06T15:02:58.690442Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-12-06T15:02:58.691219Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-12-06T15:02:58.702492Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201206 23:02:58
2020-12-06T15:02:58.715442Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-12-06T15:02:58.715904Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-12-06T15:02:58.717982Z 0 [Warning] CA certificate ca.pem is self signed.
2020-12-06T15:02:58.718051Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-12-06T15:02:58.719045Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2020-12-06T15:02:58.720034Z 0 [Note] IPv6 is available.
2020-12-06T15:02:58.720077Z 0 [Note]   - '::' resolves to '::';
2020-12-06T15:02:58.720116Z 0 [Note] Server socket created on IP: '::'.
2020-12-06T15:02:59.182050Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2020-12-06T15:02:59.217680Z 0 [Note] Event Scheduler: Loaded 0 events
2020-12-06T15:02:59.218060Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)

要是第一次启动,没有数据,启动会比较慢,需要1分多钟,为了保险,定2分钟后执行初始化任务。

2,初始化数据接口被停用

本接口即将停止更新,请尽快使用Pro版接口:https://tushare.pro/document/2
error : HTTP Error 404: Not Found