Skip to content

Instantly share code, notes, and snippets.

@Sharelter
Created June 16, 2022 02:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Sharelter/cb3e9d9c37093461b64355bc28ee5800 to your computer and use it in GitHub Desktop.
Save Sharelter/cb3e9d9c37093461b64355bc28ee5800 to your computer and use it in GitHub Desktop.
Aknoadi database error message
2022-06-16 10:21:19 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_addre>
2022-06-16 10:21:19 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_addre>
2022-06-16 10:21:19 0 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsre>
2022-06-16 10:21:19 0 [Note] WSREP: Node addr:
2022-06-16 10:21:19 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
2022-06-16 10:21:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-06-16 10:21:19 0 [Note] InnoDB: Number of transaction pools: 1
2022-06-16 10:21:19 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-06-16 10:21:19 0 [Note] InnoDB: Using Linux native AIO
2022-06-16 10:21:19 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2022-06-16 10:21:19 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-16 10:21:19 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
2022-06-16 10:21:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-06-16 10:21:19 0 [Note] InnoDB: Starting shutdown...
2022-06-16 10:21:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-06-16 10:21:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-06-16 10:21:19 0 [ERROR] Unknown/unsupported storage engine: innodb
2022-06-16 10:21:19 0 [ERROR] Aborting
@Sharelter
Copy link
Author

Here is my mysql.conf file.
I haven't modified it since I freshly install KDE.

#
# Global Akonadi MySQL server settings,
# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
#
# Based on advice by Kris Köhntopp <kris@mysql.com>
#
[mysqld]

# strict query parsing/interpretation
# TODO: make Akonadi work with those settings enabled
# sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
# sql_mode=strict_trans_tables

# DEBUGGING:
# log all queries, useful for debugging but generates an enormous amount of data
# log=mysql.full
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
# log_slow_queries=mysql.slow
# long_query_time=1
# log queries not using indices, debug only, disable for production use
# log_queries_not_using_indexes=1
#
# measure database size and adjust innodb_buffer_pool_size
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");

# NOTES:
# Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)

#expire_logs_days=3

#sync_bin_log=0

# Use UTF-8 encoding for tables
character_set_server=utf8
collation_server=utf8_general_ci

# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb

# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M)
# Larger values means less I/O
innodb_buffer_pool_size=128M

# Create a .ibd file for each table (default:0)
innodb_file_per_table=1

# Write out the log buffer to the log file at each commit (default:1)
innodb_flush_log_at_trx_commit=2

# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin)
# larger values means less I/O
innodb_log_buffer_size=1M

# Size of each log file in a log group (default:5M) larger means less I/O but more time for recovery.
innodb_log_file_size=64M

# # error log file name, relative to datadir (default:hostname.err)
log_error=mysql.err

# print warnings and connection errors (default:1)
loose_log_warnings=2

# Convert table named to lowercase
lower_case_table_names=1

# Maximum size of one packet or any generated/intermediate string. (default:1M)
max_allowed_packet=32M

# Maximum simultaneous connections allowed (default:100)
max_connections=256

# The two options below make no sense with prepared statements and/or transactions
# (make sense when having the same query multiple times)

# Memory allocated for caching query results (default:0 (disabled))
loose_query_cache_size=0

# Do not cache results (default:1)
loose_query_cache_type=0

# Do not use the privileges mechanisms
skip_grant_tables

# Do not listen for TCP/IP connections at all
skip_networking

# The number of open tables for all threads. (default:64)
table_open_cache=200

# How many threads the server should cache for reuse (default:0)
thread_cache_size=3

# wait 365d before dropping the DB connection (default:8h)
wait_timeout=31536000

# We use InnoDB, so don't let MyISAM eat up memory
key_buffer_size=16K

[client]
default-character-set=utf8

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment