Re: Failed to start mysql due to start_lsn and ens_lsn issue
Thanks for the links provided the second link was the one I was referring to in previous posts.
mysql Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
As you can see from the commands below for some reason the 'performance_schema.innodb_redo_log_files' doesn't exist. It shows on the tables but one cannot query it. It also has 0 rows. In the Comments of the table it also says "The table performance_schema does not exist." All other tables in the performance_schema DB seems to be intact.
At this point I think my best option would be to DISABLE INNODB REDO_LOG, second would try to delete and recreate the innodb_redo_log_files table. Although getting the values might be impossible. But I cannot seem to find any docs explaining if that would be use full. In the same breath It might also be non excitant becasue I started mysql with "innodb_force_recovery=6 "
OUTPUT:
mysql> use performance_schema
Database changed
mysql> SELECT FILE_NAME, START_LSN, END_LSN FROM performance_schema.innodb_redo_log_files;
ERROR 1146 (42S02): Table 'performance_schema.innodb_redo_log_files' doesn't exist
mysql> show tables
-> ;
+------------------------------------------------------+
| Tables_in_performance_schema |
+------------------------------------------------------+
| accounts |
| binary_log_transaction_compression_stats |
| cond_instances |
| data_lock_waits |
| data_locks |
| error_log |
| events_errors_summary_by_account_by_error |
| events_errors_summary_by_host_by_error |
| events_errors_summary_by_thread_by_error |
| events_errors_summary_by_user_by_error |
| events_errors_summary_global_by_error |
| events_stages_current |
| events_stages_history |
| events_stages_history_long |
| events_stages_summary_by_account_by_event_name |
| events_stages_summary_by_host_by_event_name |
| events_stages_summary_by_thread_by_event_name |
| events_stages_summary_by_user_by_event_name |
| events_stages_summary_global_by_event_name |
| events_statements_current |
| events_statements_histogram_by_digest |
| events_statements_histogram_global |
| events_statements_history |
| events_statements_history_long |
| events_statements_summary_by_account_by_event_name |
| events_statements_summary_by_digest |
| events_statements_summary_by_host_by_event_name |
| events_statements_summary_by_program |
| events_statements_summary_by_thread_by_event_name |
| events_statements_summary_by_user_by_event_name |
| events_statements_summary_global_by_event_name |
| events_transactions_current |
| events_transactions_history |
| events_transactions_history_long |
| events_transactions_summary_by_account_by_event_name |
| events_transactions_summary_by_host_by_event_name |
| events_transactions_summary_by_thread_by_event_name |
| events_transactions_summary_by_user_by_event_name |
| events_transactions_summary_global_by_event_name |
| events_waits_current |
| events_waits_history |
| events_waits_history_long |
| events_waits_summary_by_account_by_event_name |
| events_waits_summary_by_host_by_event_name |
| events_waits_summary_by_instance |
| events_waits_summary_by_thread_by_event_name |
| events_waits_summary_by_user_by_event_name |
| events_waits_summary_global_by_event_name |
| file_instances |
| file_summary_by_event_name |
| file_summary_by_instance |
| global_status |
| global_variables |
| host_cache |
| hosts |
| innodb_redo_log_files |
| keyring_component_status |
| keyring_keys |
| log_status |
| memory_summary_by_account_by_event_name |
| memory_summary_by_host_by_event_name |
| memory_summary_by_thread_by_event_name |
| memory_summary_by_user_by_event_name |
| memory_summary_global_by_event_name |
| metadata_locks |
| mutex_instances |
| objects_summary_global_by_type |
| performance_timers |
| persisted_variables |
| prepared_statements_instances |
| processlist |
| replication_applier_configuration |
| replication_applier_filters |
| replication_applier_global_filters |
| replication_applier_status |
| replication_applier_status_by_coordinator |
| replication_applier_status_by_worker |
| replication_asynchronous_connection_failover |
| replication_asynchronous_connection_failover_managed |
| replication_connection_configuration |
| replication_connection_status |
| replication_group_member_stats |
| replication_group_members |
| rwlock_instances |
| session_account_connect_attrs |
| session_connect_attrs |
| session_status |
| session_variables |
| setup_actors |
| setup_consumers |
| setup_instruments |
| setup_objects |
| setup_threads |
| socket_instances |
| socket_summary_by_event_name |
| socket_summary_by_instance |
| status_by_account |
| status_by_host |
| status_by_thread |
| status_by_user |
| table_handles |
| table_io_waits_summary_by_index_usage |
| table_io_waits_summary_by_table |
| table_lock_waits_summary_by_table |
| threads |
| tls_channel_status |
| user_defined_functions |
| user_variables_by_thread |
| users |
| variables_by_thread |
| variables_info |
+------------------------------------------------------+
111 rows in set (0.01 sec)
mysql>
mysql> SELECT * FROM users;
+-----------------+---------------------+-------------------+
| USER | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+-----------------+---------------------+-------------------+
| NULL | 17 | 23 |
| event_scheduler | 1 | 1 |
| root | 1 | 3 |
+-----------------+---------------------+-------------------+
3 rows in set (0.14 sec)
mysql> SELECT * FROM hosts;
+-----------+---------------------+-------------------+
| HOST | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+-----------+---------------------+-------------------+
| NULL | 17 | 23 |
| localhost | 2 | 4 |
+-----------+---------------------+-------------------+
2 rows in set (0.00 sec)
Subject
Views
Written By
Posted
4853
August 03, 2022 10:49AM
1557
August 03, 2022 02:49PM
1362
August 04, 2022 04:59AM
1373
August 04, 2022 06:58AM
3061
August 04, 2022 07:56AM
1706
August 04, 2022 10:00AM
Re: Failed to start mysql due to start_lsn and ens_lsn issue
1660
August 05, 2022 06:12AM
1291
August 05, 2022 08:33AM
2970
August 06, 2022 12:43AM
3288
August 07, 2022 01:56AM
932
August 08, 2022 05:14AM
933
August 08, 2022 10:23AM
1430
August 09, 2022 03:14AM
1252
August 09, 2022 06:08AM
854
August 10, 2022 07:58AM
960
August 10, 2022 08:55AM
1689
August 10, 2022 09:19AM
1384
August 11, 2022 04:29AM
1237
August 08, 2022 02:49AM
890
August 08, 2022 05:11AM
773
August 08, 2022 05:39AM
738
August 08, 2022 05:49AM
798
August 08, 2022 09:52AM
755
August 08, 2022 10:03AM
782
August 08, 2022 06:13AM
842
August 08, 2022 06:21AM
892
August 08, 2022 09:57AM
1228
August 08, 2022 10:10AM
743
November 21, 2023 01:56AM
Sorry, you can't reply to this topic. It has been closed.
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.