MySQL Forums
Forum List  »  Chinese

mysql主从在数据透明加密过程中,从库发生了crash事件
Posted by: YINGYIFNEG YING
Date: March 21, 2024 05:00AM

MySQL版本:8.0.31

问题:主从复制架构上都install加载了加密插件后,主库执行了ALTER TABLE t1 ENCRYPTION='Y';加密命令,从库开始同步数据,同步到一张19G的临时表时,从库产生了crash。后手动拉起从库数据库,从库正常加密,数据同步正常。疑问为什么从库会发生crash?

具体的日志信息如下:
2024-03-20T02:30:02.446372+08:00 47611 [Warning] [MY-013712] [Server] No suitable 'keyring_component_metadata_query' service implementation found to fulfill the request.
2024-03-20T13:58:12Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=30a13d091dc0c69784b16dd4169f1382a73d2f9d
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x2128b81]
/usr/sbin/mysqld(print_fatal_signal(int)+0x387) [0xfd62d7]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xfd6395]
/lib64/libpthread.so.0(+0x12ce0) [0x7fa150c1ece0]
/usr/sbin/mysqld(rec_get_offsets(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, ut::Location, mem_block_info_t**)+0x22) [0x24309d2]
/usr/sbin/mysqld(btr_search_drop_page_hash_index(buf_block_t*)+0x4cc) [0x24710dc]
/usr/sbin/mysqld(buf_LRU_free_page(buf_page_t*, bool)+0x7c5) [0x24b5895]
/usr/sbin/mysqld(buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*)+0xca6) [0x24a9936]
/usr/sbin/mysqld() [0x24aa09e]
/usr/sbin/mysqld() [0x24ac4fd]
/usr/sbin/mysqld(void Detached_thread::operator()<void (*)()>(void (*&&)())+0xca) [0x22e78aa]
/lib64/libstdc++.so.6(+0xc2ba3) [0x7fa14f9a1ba3]
/lib64/libpthread.so.0(+0x81cf) [0x7fa150c141cf]
/lib64/libc.so.6(clone+0x43) [0x7fa14efb9d83]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2024-03-20T21:58:15.824852+08:00 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2024-03-20T21:58:15.824897+08:00 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2024-03-20T21:58:15.824903+08:00 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2024-03-20T21:58:15.824919+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2024-03-20T21:58:15.824934+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_skip_errors' is deprecated and will be removed in a future release. Please use replica_skip_errors instead.
2024-03-20T21:58:15.824940+08:00 0 [Warning] [MY-011069] [Server] The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release.
2024-03-20T21:58:15.824951+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
2024-03-20T21:58:15.824969+08:00 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2024-03-20T21:58:15.825983+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 787138
2024-03-20T21:58:15.850478+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-20T21:58:16.364389+08:00 1 [ERROR] [MY-012657] [InnoDB] Encryption can't find master key, please check the keyring is loaded.
2024-03-20T21:58:16.364430+08:00 1 [ERROR] [MY-012226] [InnoDB] Encryption information in datafile: ./icm/#sql-a278f_9.ibd can't be decrypted, please confirm that keyring is loaded.
2024-03-20T21:58:16.898658+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 0 for {space: 1615, page_no:390535} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898686+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 1 for {space: 1615, page_no:303826} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898692+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 2 for {space: 1615, page_no:382794} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898697+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 3 for {space: 1615, page_no:260842} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898702+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 4 for {space: 1615, page_no:332990} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898707+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 5 for {space: 1615, page_no:316131} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898712+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 6 for {space: 1615, page_no:11504} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898717+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 7 for {space: 1615, page_no:263396} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898722+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 8 for {space: 1615, page_no:384707} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898735+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 9 for {space: 1615, page_no:445810} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898740+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 10 for {space: 1615, page_no:215338} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898747+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 11 for {space: 1615, page_no:234022} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898752+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 12 for {space: 1615, page_no:49176} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898757+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 13 for {space: 1615, page_no:280063} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898762+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 14 for {space: 1615, page_no:106606} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898766+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 15 for {space: 1615, page_no:39945} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898772+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 16 for {space: 1615, page_no:445811} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898776+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 17 for {space: 1615, page_no:71416} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898781+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 18 for {space: 1615, page_no:71344} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898786+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 19 for {space: 1615, page_no:437571} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898791+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 20 for {space: 1615, page_no:402287} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898796+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 21 for {space: 1615, page_no:297545} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898801+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 22 for {space: 1615, page_no:310188} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898806+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 23 for {space: 1615, page_no:49348} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898811+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 24 for {space: 1615, page_no:191608} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898816+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 25 for {space: 1615, page_no:282704} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898820+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 26 for {space: 1615, page_no:160972} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898825+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 27 for {space: 1615, page_no:55215} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898830+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 28 for {space: 1615, page_no:381013} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898835+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 29 for {space: 1615, page_no:453898} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898840+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 30 for {space: 1615, page_no:476051} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898846+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 31 for {space: 1615, page_no:447088} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898851+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 32 for {space: 1615, page_no:360299} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898855+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 33 for {space: 1615, page_no:402264} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898863+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 34 for {space: 1615, page_no:281424} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898868+08:00 1 [Warning] [MY-013541] [InnoDB] Doublewrite page 35 for {space: 1615, page_no:280052} could not be restored. File name unknown for tablespace ID 1615
2024-03-20T21:58:16.898931+08:00 1 [ERROR] [MY-012179] [InnoDB] Could not find any file associated with the tablespace ID: 1615
2024-03-20T21:58:16.898941+08:00 1 [ERROR] [MY-012964] [InnoDB] Use --innodb-directories to find the tablespace files. If that fails then use --innodb-force-recovery=1 to ignore this and to permanently lose all changes to the missing tablespace(s)
2024-03-20T21:58:16.999256+08:00 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-20T21:58:17.288414+08:00 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-03-20T21:58:17.288809+08:00 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-20T21:58:17.288891+08:00 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-20T21:58:17.290497+08:00 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31) MySQL Community Server - GPL.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql主从在数据透明加密过程中,从库发生了crash事件
544
March 21, 2024 05:00AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.