MySQL Forums
Forum List  »  General

Re: databases are lost
Posted by: jm L
Date: March 15, 2021 10:03AM

Hi,Peter!
Before this, I upgraded mysql.
systemctl stop mysqld
use command:rpm -Uvh mysql-community-common-5.7.33-1.el7.x86_64.rpm mysql-community-libs-5.7.33-1.el7.x86_64.rpm mysql-community-client-5.7.33-1.el7.x86_64.rpm mysql-community-server-5.7.33-1.el7.x86_64.rpm
systemctl start mysqld
Is there a problem with this upgrade process?

This is the MySQL log,table performance_schema there seems to be something wrong.

2021-02-27T00:18:05.601644Z 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 3
2021-02-27T00:18:05.601652Z 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply
2021-02-27T00:18:05.605197Z 0 [Note] Event Scheduler: Stopped
2021-02-27T00:18:05.605223Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-02-27T00:18:05.613254Z 0 [Note] Binlog end
2021-02-27T00:18:05.628290Z 0 [Note] Shutting down plugin 'CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS'
2021-02-27T00:18:05.628320Z 0 [Note] Shutting down plugin 'CONNECTION_CONTROL'
2021-02-27T00:18:05.628353Z 0 [Note] Shutting down plugin 'ngram'
2021-02-27T00:18:05.628357Z 0 [Note] Shutting down plugin 'partition'
2021-02-27T00:18:05.628362Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-02-27T00:18:05.628366Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-02-27T00:18:05.628369Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-02-27T00:18:05.628394Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-02-27T00:18:05.628401Z 0 [Note] Shutting down plugin 'MyISAM'
2021-02-27T00:18:05.628454Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-02-27T00:18:05.628460Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-02-27T00:18:05.628463Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-02-27T00:18:05.628466Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-02-27T00:18:05.628470Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-02-27T00:18:05.628473Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-02-27T00:18:05.628476Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-02-27T00:18:05.628478Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-02-27T00:18:05.628481Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-02-27T00:18:05.628484Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-02-27T00:18:05.628487Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-02-27T00:18:05.628489Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-02-27T00:18:05.628492Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-02-27T00:18:05.628495Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-02-27T00:18:05.628497Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-02-27T00:18:05.628500Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-02-27T00:18:05.628503Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-02-27T00:18:05.628505Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-02-27T00:18:05.628508Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-02-27T00:18:05.628510Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-02-27T00:18:05.628513Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-02-27T00:18:05.628516Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-02-27T00:18:05.628518Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-02-27T00:18:05.628521Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-02-27T00:18:05.628524Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-02-27T00:18:05.628527Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-02-27T00:18:05.628530Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-02-27T00:18:05.628533Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-02-27T00:18:05.628535Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-02-27T00:18:05.628537Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-02-27T00:18:05.628540Z 0 [Note] Shutting down plugin 'InnoDB'
2021-02-27T00:18:05.628625Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-02-27T00:18:05.628708Z 0 [Note] InnoDB: Starting shutdown...
2021-02-27T00:18:05.728907Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2021-02-27T00:18:06.006884Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210227 8:18:06
2021-02-27T00:18:11.996284Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1374903821772
2021-02-27T00:18:11.997374Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-27T00:18:11.997408Z 0 [Note] Shutting down plugin 'MEMORY'
2021-02-27T00:18:11.997427Z 0 [Note] Shutting down plugin 'CSV'
2021-02-27T00:18:11.997433Z 0 [Note] Shutting down plugin 'sha256_password'
2021-02-27T00:18:11.997436Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-02-27T00:18:11.997696Z 0 [Note] Shutting down plugin 'binlog'
2021-02-27T00:18:11.999813Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2021-02-27T00:19:17.366314Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 100000)
2021-02-27T00:19:17.366814Z 0 [Warning] Changed limits: max_connections: 4190 (requested 20000)
2021-02-27T00:19:17.366845Z 0 [Warning] Changed limits: table_open_cache: 400 (requested 8000)
2021-02-27T00:19:17.485976Z 0 [Warning] The syntax '--metadata_locks_hash_instances' is deprecated and will be removed in a future release
2021-02-27T00:19:17.486127Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-27T00:19:17.487837Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.33-log) starting as process 174532 ...
2021-02-27T00:19:17.517942Z 0 [Warning] InnoDB: Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed.
2021-02-27T00:19:17.518043Z 0 [Warning] InnoDB: Setting innodb_checksums to OFF is DEPRECATED. This option may be removed in future releases. You should set innodb_checksum_algorithm=NONE instead.
2021-02-27T00:19:17.518052Z 0 [Warning] InnoDB: innodb_open_files should not be greater than the open_files_limit.

2021-02-27T00:19:17.518090Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-02-27T00:19:17.518103Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-27T00:19:17.518107Z 0 [Note] InnoDB: Uses event mutexes
2021-02-27T00:19:17.518111Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-02-27T00:19:17.518118Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-27T00:19:17.518127Z 0 [Note] InnoDB: Using Linux native AIO
2021-02-27T00:19:17.523907Z 0 [Note] InnoDB: Number of pools: 1
2021-02-27T00:19:17.524131Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-02-27T00:19:17.543669Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80G, instances = 32, chunk size = 128M
2021-02-27T00:19:23.647051Z 0 [Note] InnoDB: Completed initialization of buffer pool
tcmalloc: large alloc 1359822848 bytes == 0xfe00a000 @ 0x7f0cd3b134b9 0x7f0cd3b32049 0x10f2c85 0x1369bd1 0x1148132 0x1228706 0x10ee55f 0x83f7b1 0xd2e185 0xd34390 0x7e4234 0x7e7ab5 0x7f0cd20bc3d5 0x7dd174 (nil)
2021-02-27T00:19:24.819772Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-27T00:19:24.871403Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
tcmalloc: large alloc 1359822848 bytes == 0xfe00a000 @ 0x7f0cd3b134b9 0x7f0cd3b32049 0x10f2c85 0x1369bd1 0x1146456 0x114ff04 0x115122d 0x122a85e 0x10ee55f 0x83f7b1 0xd2e185 0xd34390 0x7e4234 0x7e7ab5 0x7f0cd20bc3d5 0x7dd174 (nil)
tcmalloc: large alloc 1359822848 bytes == 0xfe00a000 @ 0x7f0cd3b134b9 0x7f0cd3b32049 0x10f2c85 0x1369bd1 0x1146456 0x114e57a 0x122b24f 0x10ee55f 0x83f7b1 0xd2e185 0xd34390 0x7e4234 0x7e7ab5 0x7f0cd20bc3d5 0x7dd174 (nil)
2021-02-27T00:19:27.850124Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-27T00:19:27.850508Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-27T00:19:27.903292Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-02-27T00:19:27.905652Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-02-27T00:19:27.905678Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-02-27T00:19:27.906296Z 0 [Note] InnoDB: Waiting for purge to start
2021-02-27T00:19:27.957133Z 0 [Note] InnoDB: 5.7.33 started; log sequence number 1374903821772
2021-02-27T00:19:27.957745Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-02-27T00:19:27.958161Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-02-27T00:19:31.516134Z 0 [Note] Auto generated SSL certificates are placed in data directory.
2021-02-27T00:19:31.517489Z 0 [Warning] CA certificate ca.pem is self signed.
2021-02-27T00:19:31.645457Z 0 [Note] Auto generated RSA key files are placed in data directory.
2021-02-27T00:19:31.646961Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-02-27T00:19:31.647293Z 0 [Note] IPv6 is available.
2021-02-27T00:19:31.647309Z 0 [Note] - '::' resolves to '::';
2021-02-27T00:19:31.647319Z 0 [Note] Server socket created on IP: '::'.
2021-02-27T00:19:31.694711Z 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=database-M-relay-bin' to avoid this problem.
2021-02-27T00:19:31.723242Z 1 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2021-02-27T00:19:31.725450Z 2 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0
2021-02-27T00:19:31.733107Z 1 [Note] Slave I/O thread for channel '': connected to master 'admin@10.210.65.12:3306',replication started in log 'master6512.000170' at position 1007314
2021-02-27T00:19:31.755947Z 2 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'master6512.000170' at position 1007314, relay log './database-M-relay-bin.000393' position: 369
2021-02-27T00:19:31.857531Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
2021-02-27T00:19:31.857559Z 2 [Note] Failed to delete file './database-M-relay-bin.000393'
2021-02-27T00:19:31.857589Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
2021-02-27T00:19:31.857615Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
2021-02-27T00:19:31.857639Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
2021-02-27T00:19:31.857661Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
2021-02-27T00:19:31.857686Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
2021-02-27T00:19:31.857705Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
2021-02-27T00:19:31.862613Z 2 [ERROR] Failed to open log (file './database-M-relay-bin.000394', errno 2)
2021-02-27T00:19:31.862635Z 2 [ERROR] Error reading relay log event for channel '': Could not open log file
2021-02-27T00:19:31.862650Z 2 [ERROR] Slave SQL for channel '': Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code: 1594
2021-02-27T00:19:31.862654Z 2 [ERROR] Slave (additional info): File './database-M-relay-bin.000394' not found (Errcode: 2 - No such file or directory) Error_code: 29
2021-02-27T00:19:31.862658Z 2 [Warning] Slave: Being purged log ./database-M-relay-bin.000393 was not found Error_code: 1612
2021-02-27T00:19:31.862662Z 2 [Warning] Slave: File './database-M-relay-bin.000394' not found (Errcode: 2 - No such file or directory) Error_code: 29
2021-02-27T00:19:31.862666Z 2 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master6512.000170' position 1007314.
2021-02-27T00:19:31.870453Z 0 [ERROR] Cannot open mysql.db
2021-02-27T00:19:31.878314Z 0 [ERROR] Cannot open mysql.user
2021-02-27T00:19:31.878379Z 0 [ERROR] Cannot open mysql.event
2021-02-27T00:19:31.878385Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2021-02-27T00:19:31.878573Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.33-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2021-02-27T00:19:34.753852Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2021-02-27T00:19:34.753889Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2021-02-27T00:19:34.753901Z 0 [Warning] InnoDB: Cannot open './account_platform/tb_log.ibd'. Have you deleted .ibd files under a running mysqld server?
2021-02-27T00:19:34.753949Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2021-02-27T00:19:34.753954Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2021-02-27T00:19:34.753958Z 0 [Warning] InnoDB: Cannot open './account_platform/tb_log.ibd'. Have you deleted .ibd files under a running mysqld server?
2021-02-27T00:19:34.753974Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2021-02-27T00:19:34.753978Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2021-02-27T00:19:34.753982Z 0 [Warning] InnoDB: Cannot open './account_platform/tb_log.ibd'. Have you deleted .ibd files under a running mysqld server?
2021-02-27T00:19:34.753997Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.

Options: ReplyQuote


Subject
Written By
Posted
March 02, 2021 03:33AM
March 02, 2021 11:25AM
March 09, 2021 08:31PM
March 09, 2021 09:17PM
March 09, 2021 09:25PM
March 10, 2021 10:08AM
March 10, 2021 07:53PM
March 10, 2021 09:23PM
March 11, 2021 12:11AM
March 11, 2021 05:36AM
March 11, 2021 06:39AM
March 11, 2021 09:37AM
March 11, 2021 08:04PM
March 12, 2021 09:11AM
March 12, 2021 07:36PM
March 12, 2021 08:17PM
March 12, 2021 08:41PM
March 13, 2021 09:41AM
Re: databases are lost
March 15, 2021 10:03AM
March 15, 2021 11:34AM
March 15, 2021 08:45PM
March 15, 2021 09:10PM
March 15, 2021 09:26PM
March 15, 2021 09:38PM
March 15, 2021 09:47PM
March 15, 2021 10:30PM
March 16, 2021 09:24PM
March 16, 2021 10:31PM
March 16, 2021 11:09PM
March 17, 2021 07:08AM
March 17, 2021 07:17AM
March 15, 2021 09:56PM
March 17, 2021 11:16AM
March 19, 2021 12:02AM


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.