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
4719
August 03, 2022 10:49AM
1538
August 03, 2022 02:49PM
1346
August 04, 2022 04:59AM
1357
August 04, 2022 06:58AM
3031
August 04, 2022 07:56AM
1688
August 04, 2022 10:00AM
Re: Failed to start mysql due to start_lsn and ens_lsn issue
1635
August 05, 2022 06:12AM
1272
August 05, 2022 08:33AM
2941
August 06, 2022 12:43AM
3257
August 07, 2022 01:56AM
920
August 08, 2022 05:14AM
920
August 08, 2022 10:23AM
1416
August 09, 2022 03:14AM
1230
August 09, 2022 06:08AM
847
August 10, 2022 07:58AM
949
August 10, 2022 08:55AM
1674
August 10, 2022 09:19AM
1375
August 11, 2022 04:29AM
1218
August 08, 2022 02:49AM
879
August 08, 2022 05:11AM
765
August 08, 2022 05:39AM
729
August 08, 2022 05:49AM
785
August 08, 2022 09:52AM
745
August 08, 2022 10:03AM
772
August 08, 2022 06:13AM
825
August 08, 2022 06:21AM
882
August 08, 2022 09:57AM
1219
August 08, 2022 10:10AM
727
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.