Topic: MySql service is not restarting.
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.2
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version: Ubuntu 18.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Dear All,
I am not able to restart service and getting the below error:
root@bit:/etc/dovecot# systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@bit:/etc/dovecot#
root@bit:/etc/dovecot# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.48 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─override.conf
Active: failed (Result: exit-code) since Tue 2023-07-18 08:01:35 +03; 10min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 58860 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 58765 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status
Process: 58763 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 58762 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 58860 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
يوليو 18 08:01:34 bit systemd[1]: Starting MariaDB 10.1.48 database server...
يوليو 18 08:01:35 bit mysqld[58860]: 2023-07-18 8:01:35 140042777926784 [Warning] option 'net_buffer_length': unsigned value 536870912 adjusted to 1048576
يوليو 18 08:01:35 bit mysqld[58860]: 2023-07-18 8:01:35 140042777926784 [Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0ubuntu0.18.04.1) starting as process 58860 ...
يوليو 18 08:01:35 bit systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
يوليو 18 08:01:35 bit systemd[1]: mariadb.service: Failed with result 'exit-code'.
يوليو 18 08:01:35 bit systemd[1]: Failed to start MariaDB 10.1.48 database server.
lines 1-20/20 (END)
====MySQL error.log======
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: The InnoDB memory heap is disabled
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Using Linux native AIO
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Using SSE crc32 instructions
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Initializing buffer pool, size = 8.0G
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Completed initialization of buffer pool
2023-07-18 8:58:39 140574977502336 [Note] InnoDB: Highest supported file format is Barracuda.
2023-07-18 8:58:40 140574977502336 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*32768 pages, LSN=1600616
2023-07-18 8:58:40 140574977502336 [Warning] InnoDB: Starting to delete and rewrite log files.
2023-07-18 8:58:40 140574977502336 [Note] InnoDB: Setting log file ./ib_logfile101 size to 512 MB
2023-07-18 8:58:40 140574977502336 [Note] InnoDB: Setting log file ./ib_logfile1 size to 512 MB
2023-07-18 8:58:41 140574977502336 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2023-07-18 8:58:41 140574977502336 [Warning] InnoDB: New log files created, LSN=1601036
2023-07-18 8:58:41 140574977502336 [Note] InnoDB: 128 rollback segment(s) are active.
2023-07-18 8:58:41 140574977502336 [Note] InnoDB: Waiting for purge to start
2023-07-18 8:58:41 140574977502336 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.49-89.0 started; log sequence number 1600616
2023-07-18 8:58:41 140565098231552 [Note] InnoDB: Dumping buffer pool(s) not yet started
2023-07-18 8:58:41 140574977502336 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-18 8:58:41 140574977502336 [Note] Recovering after a crash using tc.log
2023-07-18 8:58:41 140574977502336 [ERROR] Can't init tc log
2023-07-18 8:58:41 140574977502336 [ERROR] Aborting
===POSTCONF -N======
root@bit:~# postconf -n
alias_database = hash:/etc/postfix/aliases
alias_maps = hash:/etc/postfix/aliases
allow_min_user = no
allow_percent_hack = no
biff = no
body_checks = pcre:/etc/postfix/body_checks.pcre
command_directory = /usr/sbin
compatibility_level = 2
content_filter = smtp-amavis:[127.0.0.1]:10024
daemon_directory = /usr/lib/postfix/sbin
data_directory = /var/lib/postfix
debug_peer_level = 2
debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd $daemon_directory/$process_name $process_id & sleep 5
disable_vrfy_command = yes
dovecot_destination_recipient_limit = 1
enable_long_queue_ids = yes
enable_original_recipient = no
header_checks = pcre:/etc/postfix/header_checks
inet_interfaces = all
inet_protocols = ipv4
lmtp_tls_mandatory_protocols = !SSLv2 !SSLv3
lmtp_tls_protocols = !SSLv2 !SSLv3
mail_owner = postfix
mailbox_size_limit = 52428800
mailq_path = /usr/bin/mailq
message_size_limit = 52428800
mlmmj_destination_recipient_limit = 1
mydestination = $myhostname, localhost, localhost.localdomain
mydomain = mydomain.com
myhostname = hostname.mydomain.com
mynetworks = 127.0.0.1 [::1]
myorigin = hostname.mydomain.com
newaliases_path = /usr/bin/newaliases
postscreen_access_list = permit_mynetworks cidr:/etc/postfix/postscreen_access.cidr
postscreen_blacklist_action = drop
postscreen_dnsbl_action = drop
postscreen_dnsbl_reply_map = texthash:/etc/postfix/postscreen_dnsbl_reply
postscreen_dnsbl_sites = zen.spamhaus.org*3 b.barracudacentral.org=127.0.0.[2..11]*2 bl.spameatingmonkey.net*2 bl.spamcop.net dnsbl.sorbs.net swl.spamhaus.org*-4 list.dnswl.org=127.[0..255].[0..255].0*-2 list.dnswl.org=127.[0..255].[0..255].1*-4 list.dnswl.org=127.[0..255].[0..255].[2..255]*-6
postscreen_dnsbl_threshold = 3
postscreen_dnsbl_whitelist_threshold = -2
postscreen_greet_action = drop
proxy_read_maps = $canonical_maps $lmtp_generic_maps $local_recipient_maps $mydestination $mynetworks $recipient_bcc_maps $recipient_canonical_maps $relay_domains $relay_recipient_maps $relocated_maps $sender_bcc_maps $sender_canonical_maps $smtp_generic_maps $smtpd_sender_login_maps $transport_maps $virtual_alias_domains $virtual_alias_maps $virtual_mailbox_domains $virtual_mailbox_maps $smtpd_sender_restrictions $sender_dependent_relayhost_maps
queue_directory = /var/spool/postfix
recipient_bcc_maps = proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf
recipient_delimiter = +
relay_domains = $mydestination proxy:mysql:/etc/postfix/mysql/relay_domains.cf
sender_bcc_maps = proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf
sender_dependent_relayhost_maps = proxy:mysql:/etc/postfix/mysql/sender_dependent_relayhost_maps.cf
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
show_user_unknown_table_name = no
smtp-amavis_destination_recipient_limit = 1
smtp_tls_CAfile = $smtpd_tls_CAfile
smtp_tls_CApath = /etc/ssl/certs
smtp_tls_loglevel = 1
smtp_tls_mandatory_protocols = !SSLv2 !SSLv3
smtp_tls_note_starttls_offer = yes
smtp_tls_protocols = !SSLv2 !SSLv3
smtp_tls_security_level = may
smtpd_command_filter = pcre:/etc/postfix/command_filter.pcre
smtpd_data_restrictions = reject_unauth_pipelining
smtpd_end_of_data_restrictions = check_policy_service inet:127.0.0.1:7777
smtpd_helo_required = yes
smtpd_helo_restrictions = permit_mynetworks permit_sasl_authenticated check_helo_access pcre:/etc/postfix/helo_access.pcre reject_non_fqdn_helo_hostname reject_unknown_helo_hostname reject_invalid_helo_hostname
smtpd_proxy_options = speed_adjust
smtpd_recipient_restrictions = permit_mynetworks permit_sasl_authenticated check_policy_service inet:127.0.0.1:7777 check_policy_service inet:127.0.0.1:12340 reject_non_fqdn_recipient reject_unlisted_recipient reject_unauth_destination reject_non_fqdn_hostname reject_non_fqdn_sender reject_unknown_sender_domain reject_invalid_hostname reject_unknown_recipient_domain reject_unauth_pipelining reject_rbl_client zen.spamhaus.org reject_rbl_client sbl.spamhaus.org reject_rbl_client b.barracudacentral.org reject_rbl_client bl.spamcop.net reject_rbl_client dnsbl.sobrs.net reject_rbl_client dnsbl-1.uceprotect.net reject_rbl_client cbl.abuseat.org reject_rhsbl_helo dbl.spamhaus.org reject_rhsbl_reverse_client dbl.spamhaus.org reject_rhsbl_sender dbl.spamhaus.org
smtpd_reject_unlisted_recipient = yes
smtpd_reject_unlisted_sender = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl_path = private/dovecot-auth
smtpd_sasl_security_options = noanonymous
smtpd_sasl_type = dovecot
smtpd_sender_login_maps = proxy:mysql:/etc/postfix/mysql/sender_login_maps.cf
smtpd_sender_restrictions = permit_mynetworks permit_sasl_authenticated check_sender_access pcre:/etc/postfix/sender_access.pcre reject_non_fqdn_sender reject_unlisted_sender reject_unknown_sender_domain reject_sender_login_mismatch reject_unknown_reverse_client_hostname reject_unknown_client_hostname
smtpd_tls_CAfile = /etc/ssl/certs/iRedMail.crt
smtpd_tls_CApath = /etc/ssl/certs/
smtpd_tls_auth_only = yes
smtpd_tls_cert_file = /etc/ssl/certs/iRedMail.crt
smtpd_tls_dh1024_param_file = /etc/ssl/dh2048_param.pem
smtpd_tls_dh512_param_file = /etc/ssl/dh512_param.pem
smtpd_tls_exclude_ciphers = aNULL, eNULL, EXPORT, DES, RC4, MD5, PSK, aECDH, EDH-DSS-DES-CBC3-SHA, EDH-RSA-DES-CDC3-SHA, KRB5-DE5, CBC3-SHA
smtpd_tls_key_file = /etc/ssl/private/iRedMail.key
smtpd_tls_loglevel = 1
smtpd_tls_mandatory_protocols = !SSLv2 !SSLv3
smtpd_tls_protocols = !SSLv2 !SSLv3
swap_bangpath = no
tls_random_source = dev:/dev/urandom
transport_maps = proxy:mysql:/etc/postfix/mysql/transport_maps_user.cf proxy:mysql:/etc/postfix/mysql/transport_maps_maillist.cf proxy:mysql:/etc/postfix/mysql/transport_maps_domain.cf
unknown_local_recipient_reject_code = 550
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias_maps.cf proxy:mysql:/etc/postfix/mysql/catchall_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias_catchall_maps.cf
virtual_gid_maps = static:2000
virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf
virtual_minimum_uid = 2000
virtual_transport = dovecot
virtual_uid_maps = static:2000
Your help is highly appreciated. (This is production server)
Thanks you so much.
JunG
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.