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
659
August 03, 2022 10:49AM
255
August 03, 2022 02:49PM
247
August 04, 2022 04:59AM
265
August 04, 2022 06:58AM
475
August 04, 2022 07:56AM
345
August 04, 2022 10:00AM
Re: Failed to start mysql due to start_lsn and ens_lsn issue
286
August 05, 2022 06:12AM
241
August 05, 2022 08:33AM
327
August 06, 2022 12:43AM
326
August 07, 2022 01:56AM
197
August 08, 2022 05:14AM
195
August 08, 2022 10:23AM
280
August 09, 2022 03:14AM
231
August 09, 2022 06:08AM
194
August 10, 2022 07:58AM
185
August 10, 2022 08:55AM
554
August 10, 2022 09:19AM
333
August 11, 2022 04:29AM
229
August 08, 2022 02:49AM
208
August 08, 2022 05:11AM
182
August 08, 2022 05:39AM
176
August 08, 2022 05:49AM
169
August 08, 2022 09:52AM
169
August 08, 2022 10:03AM
184
August 08, 2022 06:13AM
176
August 08, 2022 06:21AM
204
August 08, 2022 09:57AM
251
August 08, 2022 10:10AM
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.