MariaDB won't start, even after reinstallingStart Mysql/Mariadb in Fedora failedMySQL won't startCannot run ssh after upgrade to OpenSSL 1.0.1pMariaDB Dependencies issue after isntall/removemysql service restarted during user being connected lead to failing serviceScrewed up installing phpmyadmin and now mysql / mariadb won't startFailed to start MariaDB database server after upgrade to debian 9Debian 9: After upgrade from 8, MySQL (MariaDB) does no longer workMariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting

What is Tony Stark injecting into himself in Iron Man 3?

How can I portion out frozen cookie dough?

Precision notation for voltmeters

Is there a math expression equivalent to the conditional ternary operator?

What is the best index strategy or query SELECT when performing a search/lookup BETWEEN IP address (IPv4 and IPv6) ranges?

Draw this image in the TIKZ package

How to make sure I'm assertive enough in contact with subordinates?

Who has more? Ireland or Iceland?

How do you make a gun that shoots melee weapons and/or swords?

The (Easy) Road to Code

Is there a logarithm base for which the logarithm becomes an identity function?

Short story about cities being connected by a conveyor belt

Why would /etc/passwd be used every time someone executes `ls -l` command?

Ultrafilters as a double dual

How does learning spells work when leveling a multiclass character?

Tabular environment - text vertically positions itself by bottom of tikz picture in adjacent cell

Should I apply for my boss's promotion?

Help! My Character is too much for her story!

Unidentified signals on FT8 frequencies

Rationale to prefer local variables over instance variables?

Do I need a return ticket to Canada if I'm a Japanese National?

Create chunks from an array

How does a sound wave propagate?

Does the US political system, in principle, allow for a no-party system?



MariaDB won't start, even after reinstalling


Start Mysql/Mariadb in Fedora failedMySQL won't startCannot run ssh after upgrade to OpenSSL 1.0.1pMariaDB Dependencies issue after isntall/removemysql service restarted during user being connected lead to failing serviceScrewed up installing phpmyadmin and now mysql / mariadb won't startFailed to start MariaDB database server after upgrade to debian 9Debian 9: After upgrade from 8, MySQL (MariaDB) does no longer workMariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting













2















I've been reinstalling, update, upgrade but still didn't solve the problem. Been searching for answer on google but the problem persists.
Here's the output when i ran systemctl status mariadb.service:



● mariadb.service - MariaDB database server
 Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
 Drop-In: /etc/systemd/system/mariadb.service.d
 └─migrated-from-my.cnf-settings.conf
 Active: failed (Result: exit-code) since Sat 2017-12-30 03:57:41 UTC; 12s ago
 Process: 13654 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Process: 13637 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=ex
 Process: 13630 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Process: 13629 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 13654 (code=exited, status=1/FAILURE)
 Status: "MariaDB server is down"

Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Buffer pool(s) load completed at 171230 3:57:40
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Plugin 'FEEDBACK' is disabled.
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Recovering after a crash using tc.log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Can't init tc log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Aborting
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 30 03:57:41 virtu systemd[1]: Failed to start MariaDB database server.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Unit entered failed state.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Failed with result 'exit-code'.


At first i think that because of disk full, but after i clean up log in /var/logs, it's still has the same problem.



I also installed iRedMail in the server, and everytime i try to restart mysql, it always return "Job for mariadb.service failed because the control process exited with error code."
when i run journalctl -xe, it returns:



Dec 30 09:06:54 virtu postfix/cleanup[18579]: warning: 892ED21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:54 virtu postfix/pickup[17587]: warning: maildrop/980AE1F723: error writing 892ED21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: Invalid user admin from 82.159.78.242 port 60966
Dec 30 09:06:55 virtu sshd[18592]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:06:55 virtu postfix/pickup[17587]: 89CEB21A12: uid=0 from=<root>
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: 89CEB21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:55 virtu postfix/pickup[17587]: warning: maildrop/CB9FE1F645: error writing 89CEB21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:06:56 virtu postfix/pickup[17587]: 8A4DA21A12: uid=0 from=<root>
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: 8A4DA21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:56 virtu postfix/pickup[17587]: warning: maildrop/137012189C: error writing 8A4DA21A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Failed password for invalid user admin from 82.159.78.242 port 60966 ssh2
Dec 30 09:06:57 virtu postfix/pickup[17587]: 8AD3421A12: uid=0 from=<root>
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: 8AD3421A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:57 virtu postfix/pickup[17587]: warning: maildrop/C6D361F63D: error writing 8AD3421A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Connection closed by 82.159.78.242 port 60966 [preauth]
Dec 30 09:06:58 virtu postfix/pickup[17587]: 8B73F21A12: uid=0 from=<root>
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: 8B73F21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:58 virtu postfix/pickup[17587]: warning: maildrop/919EB1F6F3: error writing 8B73F21A12: queue file write error
Dec 30 09:06:59 virtu postfix/pickup[17587]: 8BFD121A12: uid=0 from=<root>
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: 8BFD121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:59 virtu postfix/pickup[17587]: warning: maildrop/0D6711F787: error writing 8BFD121A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: Invalid user admin from 82.159.78.242 port 32900
Dec 30 09:07:00 virtu sshd[18594]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:07:00 virtu postfix/pickup[17587]: 8C47321A12: uid=0 from=<root>
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: 8C47321A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:00 virtu postfix/pickup[17587]: warning: maildrop/9D14C1F6B5: error writing 8C47321A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session opened for user sogo by (uid=0)
Dec 30 09:07:01 virtu CRON[18598]: (sogo) CMD (/usr/sbin/sogo-tool expire-sessions 30 >/dev/null 2>&1; /usr/sbin/sogo-ealarms-notify >/dev/null 2>&1)
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session closed for user sogo
Dec 30 09:07:01 virtu postfix/pickup[17587]: 8CB7621A12: uid=0 from=<root>
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: 8CB7621A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:01 virtu postfix/pickup[17587]: warning: maildrop/729BD218B7: error writing 8CB7621A12: queue file write error
Dec 30 09:07:02 virtu postfix/pickup[17587]: 8D3DF21A12: uid=0 from=<root>
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: 8D3DF21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:02 virtu postfix/pickup[17587]: warning: maildrop/72D5621866: error writing 8D3DF21A12: queue file write error
Dec 30 09:07:03 virtu sshd[18594]: Failed password for invalid user admin from 82.159.78.242 port 32900 ssh2
Dec 30 09:07:03 virtu sshd[18594]: Connection closed by 82.159.78.242 port 32900 [preauth]
Dec 30 09:07:03 virtu postfix/pickup[17587]: 8DCF821A12: uid=0 from=<root>
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: 8DCF821A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:03 virtu postfix/pickup[17587]: warning: maildrop/578D6219A6: error writing 8DCF821A12: queue file write error
Dec 30 09:07:04 virtu postfix/pickup[17587]: 8E51121A12: uid=0 from=<root>
Dec 30 09:07:04 virtu postfix/proxymap[17757]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (115)
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: 8E51121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:04 virtu postfix/pickup[17587]: warning: maildrop/CBA4C218B9: error writing 8E51121A12: queue file write error


Kindly appreciate if anybody could help.
Thank you






linux debian mysql mariadb







share|improve this question
























  • Possible duplicate of MariaDB won't start

    – JdeBP
    Dec 30 '17 at 12:26






  • 1





    Well that was my old question which was moved from stack overflow. I will delete that question. Thanks for reminding

    – Raditya Adi Baskara
    Dec 30 '17 at 12:33















2















I've been reinstalling, update, upgrade but still didn't solve the problem. Been searching for answer on google but the problem persists.
Here's the output when i ran systemctl status mariadb.service:



● mariadb.service - MariaDB database server
 Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
 Drop-In: /etc/systemd/system/mariadb.service.d
 └─migrated-from-my.cnf-settings.conf
 Active: failed (Result: exit-code) since Sat 2017-12-30 03:57:41 UTC; 12s ago
 Process: 13654 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Process: 13637 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=ex
 Process: 13630 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Process: 13629 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 13654 (code=exited, status=1/FAILURE)
 Status: "MariaDB server is down"

Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Buffer pool(s) load completed at 171230 3:57:40
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Plugin 'FEEDBACK' is disabled.
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Recovering after a crash using tc.log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Can't init tc log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Aborting
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 30 03:57:41 virtu systemd[1]: Failed to start MariaDB database server.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Unit entered failed state.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Failed with result 'exit-code'.


At first i think that because of disk full, but after i clean up log in /var/logs, it's still has the same problem.



I also installed iRedMail in the server, and everytime i try to restart mysql, it always return "Job for mariadb.service failed because the control process exited with error code."
when i run journalctl -xe, it returns:



Dec 30 09:06:54 virtu postfix/cleanup[18579]: warning: 892ED21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:54 virtu postfix/pickup[17587]: warning: maildrop/980AE1F723: error writing 892ED21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: Invalid user admin from 82.159.78.242 port 60966
Dec 30 09:06:55 virtu sshd[18592]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:06:55 virtu postfix/pickup[17587]: 89CEB21A12: uid=0 from=<root>
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: 89CEB21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:55 virtu postfix/pickup[17587]: warning: maildrop/CB9FE1F645: error writing 89CEB21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:06:56 virtu postfix/pickup[17587]: 8A4DA21A12: uid=0 from=<root>
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: 8A4DA21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:56 virtu postfix/pickup[17587]: warning: maildrop/137012189C: error writing 8A4DA21A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Failed password for invalid user admin from 82.159.78.242 port 60966 ssh2
Dec 30 09:06:57 virtu postfix/pickup[17587]: 8AD3421A12: uid=0 from=<root>
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: 8AD3421A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:57 virtu postfix/pickup[17587]: warning: maildrop/C6D361F63D: error writing 8AD3421A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Connection closed by 82.159.78.242 port 60966 [preauth]
Dec 30 09:06:58 virtu postfix/pickup[17587]: 8B73F21A12: uid=0 from=<root>
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: 8B73F21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:58 virtu postfix/pickup[17587]: warning: maildrop/919EB1F6F3: error writing 8B73F21A12: queue file write error
Dec 30 09:06:59 virtu postfix/pickup[17587]: 8BFD121A12: uid=0 from=<root>
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: 8BFD121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:59 virtu postfix/pickup[17587]: warning: maildrop/0D6711F787: error writing 8BFD121A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: Invalid user admin from 82.159.78.242 port 32900
Dec 30 09:07:00 virtu sshd[18594]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:07:00 virtu postfix/pickup[17587]: 8C47321A12: uid=0 from=<root>
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: 8C47321A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:00 virtu postfix/pickup[17587]: warning: maildrop/9D14C1F6B5: error writing 8C47321A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session opened for user sogo by (uid=0)
Dec 30 09:07:01 virtu CRON[18598]: (sogo) CMD (/usr/sbin/sogo-tool expire-sessions 30 >/dev/null 2>&1; /usr/sbin/sogo-ealarms-notify >/dev/null 2>&1)
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session closed for user sogo
Dec 30 09:07:01 virtu postfix/pickup[17587]: 8CB7621A12: uid=0 from=<root>
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: 8CB7621A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:01 virtu postfix/pickup[17587]: warning: maildrop/729BD218B7: error writing 8CB7621A12: queue file write error
Dec 30 09:07:02 virtu postfix/pickup[17587]: 8D3DF21A12: uid=0 from=<root>
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: 8D3DF21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:02 virtu postfix/pickup[17587]: warning: maildrop/72D5621866: error writing 8D3DF21A12: queue file write error
Dec 30 09:07:03 virtu sshd[18594]: Failed password for invalid user admin from 82.159.78.242 port 32900 ssh2
Dec 30 09:07:03 virtu sshd[18594]: Connection closed by 82.159.78.242 port 32900 [preauth]
Dec 30 09:07:03 virtu postfix/pickup[17587]: 8DCF821A12: uid=0 from=<root>
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: 8DCF821A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:03 virtu postfix/pickup[17587]: warning: maildrop/578D6219A6: error writing 8DCF821A12: queue file write error
Dec 30 09:07:04 virtu postfix/pickup[17587]: 8E51121A12: uid=0 from=<root>
Dec 30 09:07:04 virtu postfix/proxymap[17757]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (115)
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: 8E51121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:04 virtu postfix/pickup[17587]: warning: maildrop/CBA4C218B9: error writing 8E51121A12: queue file write error


Kindly appreciate if anybody could help.
Thank you






linux debian mysql mariadb







share|improve this question
























  • Possible duplicate of MariaDB won't start

    – JdeBP
    Dec 30 '17 at 12:26






  • 1





    Well that was my old question which was moved from stack overflow. I will delete that question. Thanks for reminding

    – Raditya Adi Baskara
    Dec 30 '17 at 12:33













2












2








2


1






I've been reinstalling, update, upgrade but still didn't solve the problem. Been searching for answer on google but the problem persists.
Here's the output when i ran systemctl status mariadb.service:



● mariadb.service - MariaDB database server
 Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
 Drop-In: /etc/systemd/system/mariadb.service.d
 └─migrated-from-my.cnf-settings.conf
 Active: failed (Result: exit-code) since Sat 2017-12-30 03:57:41 UTC; 12s ago
 Process: 13654 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Process: 13637 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=ex
 Process: 13630 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Process: 13629 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 13654 (code=exited, status=1/FAILURE)
 Status: "MariaDB server is down"

Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Buffer pool(s) load completed at 171230 3:57:40
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Plugin 'FEEDBACK' is disabled.
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Recovering after a crash using tc.log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Can't init tc log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Aborting
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 30 03:57:41 virtu systemd[1]: Failed to start MariaDB database server.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Unit entered failed state.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Failed with result 'exit-code'.


At first i think that because of disk full, but after i clean up log in /var/logs, it's still has the same problem.



I also installed iRedMail in the server, and everytime i try to restart mysql, it always return "Job for mariadb.service failed because the control process exited with error code."
when i run journalctl -xe, it returns:



Dec 30 09:06:54 virtu postfix/cleanup[18579]: warning: 892ED21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:54 virtu postfix/pickup[17587]: warning: maildrop/980AE1F723: error writing 892ED21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: Invalid user admin from 82.159.78.242 port 60966
Dec 30 09:06:55 virtu sshd[18592]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:06:55 virtu postfix/pickup[17587]: 89CEB21A12: uid=0 from=<root>
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: 89CEB21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:55 virtu postfix/pickup[17587]: warning: maildrop/CB9FE1F645: error writing 89CEB21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:06:56 virtu postfix/pickup[17587]: 8A4DA21A12: uid=0 from=<root>
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: 8A4DA21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:56 virtu postfix/pickup[17587]: warning: maildrop/137012189C: error writing 8A4DA21A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Failed password for invalid user admin from 82.159.78.242 port 60966 ssh2
Dec 30 09:06:57 virtu postfix/pickup[17587]: 8AD3421A12: uid=0 from=<root>
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: 8AD3421A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:57 virtu postfix/pickup[17587]: warning: maildrop/C6D361F63D: error writing 8AD3421A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Connection closed by 82.159.78.242 port 60966 [preauth]
Dec 30 09:06:58 virtu postfix/pickup[17587]: 8B73F21A12: uid=0 from=<root>
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: 8B73F21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:58 virtu postfix/pickup[17587]: warning: maildrop/919EB1F6F3: error writing 8B73F21A12: queue file write error
Dec 30 09:06:59 virtu postfix/pickup[17587]: 8BFD121A12: uid=0 from=<root>
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: 8BFD121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:59 virtu postfix/pickup[17587]: warning: maildrop/0D6711F787: error writing 8BFD121A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: Invalid user admin from 82.159.78.242 port 32900
Dec 30 09:07:00 virtu sshd[18594]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:07:00 virtu postfix/pickup[17587]: 8C47321A12: uid=0 from=<root>
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: 8C47321A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:00 virtu postfix/pickup[17587]: warning: maildrop/9D14C1F6B5: error writing 8C47321A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session opened for user sogo by (uid=0)
Dec 30 09:07:01 virtu CRON[18598]: (sogo) CMD (/usr/sbin/sogo-tool expire-sessions 30 >/dev/null 2>&1; /usr/sbin/sogo-ealarms-notify >/dev/null 2>&1)
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session closed for user sogo
Dec 30 09:07:01 virtu postfix/pickup[17587]: 8CB7621A12: uid=0 from=<root>
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: 8CB7621A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:01 virtu postfix/pickup[17587]: warning: maildrop/729BD218B7: error writing 8CB7621A12: queue file write error
Dec 30 09:07:02 virtu postfix/pickup[17587]: 8D3DF21A12: uid=0 from=<root>
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: 8D3DF21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:02 virtu postfix/pickup[17587]: warning: maildrop/72D5621866: error writing 8D3DF21A12: queue file write error
Dec 30 09:07:03 virtu sshd[18594]: Failed password for invalid user admin from 82.159.78.242 port 32900 ssh2
Dec 30 09:07:03 virtu sshd[18594]: Connection closed by 82.159.78.242 port 32900 [preauth]
Dec 30 09:07:03 virtu postfix/pickup[17587]: 8DCF821A12: uid=0 from=<root>
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: 8DCF821A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:03 virtu postfix/pickup[17587]: warning: maildrop/578D6219A6: error writing 8DCF821A12: queue file write error
Dec 30 09:07:04 virtu postfix/pickup[17587]: 8E51121A12: uid=0 from=<root>
Dec 30 09:07:04 virtu postfix/proxymap[17757]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (115)
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: 8E51121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:04 virtu postfix/pickup[17587]: warning: maildrop/CBA4C218B9: error writing 8E51121A12: queue file write error


Kindly appreciate if anybody could help.
Thank you






linux debian mysql mariadb







share|improve this question
















I've been reinstalling, update, upgrade but still didn't solve the problem. Been searching for answer on google but the problem persists.
Here's the output when i ran systemctl status mariadb.service:



● mariadb.service - MariaDB database server
 Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
 Drop-In: /etc/systemd/system/mariadb.service.d
 └─migrated-from-my.cnf-settings.conf
 Active: failed (Result: exit-code) since Sat 2017-12-30 03:57:41 UTC; 12s ago
 Process: 13654 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Process: 13637 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=ex
 Process: 13630 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Process: 13629 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 13654 (code=exited, status=1/FAILURE)
 Status: "MariaDB server is down"

Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140601967003392 [Note] InnoDB: Buffer pool(s) load completed at 171230 3:57:40
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Plugin 'FEEDBACK' is disabled.
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [Note] Recovering after a crash using tc.log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Can't init tc log
Dec 30 03:57:40 virtu mysqld[13654]: 2017-12-30 3:57:40 140602510788800 [ERROR] Aborting
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 30 03:57:41 virtu systemd[1]: Failed to start MariaDB database server.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Unit entered failed state.
Dec 30 03:57:41 virtu systemd[1]: mariadb.service: Failed with result 'exit-code'.


At first i think that because of disk full, but after i clean up log in /var/logs, it's still has the same problem.



I also installed iRedMail in the server, and everytime i try to restart mysql, it always return "Job for mariadb.service failed because the control process exited with error code."
when i run journalctl -xe, it returns:



Dec 30 09:06:54 virtu postfix/cleanup[18579]: warning: 892ED21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:54 virtu postfix/pickup[17587]: warning: maildrop/980AE1F723: error writing 892ED21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: Invalid user admin from 82.159.78.242 port 60966
Dec 30 09:06:55 virtu sshd[18592]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:06:55 virtu postfix/pickup[17587]: 89CEB21A12: uid=0 from=<root>
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:55 virtu postfix/cleanup[18578]: warning: 89CEB21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:55 virtu postfix/pickup[17587]: warning: maildrop/CB9FE1F645: error writing 89CEB21A12: queue file write error
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:06:55 virtu sshd[18592]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:06:56 virtu postfix/pickup[17587]: 8A4DA21A12: uid=0 from=<root>
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:56 virtu postfix/cleanup[18577]: warning: 8A4DA21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:56 virtu postfix/pickup[17587]: warning: maildrop/137012189C: error writing 8A4DA21A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Failed password for invalid user admin from 82.159.78.242 port 60966 ssh2
Dec 30 09:06:57 virtu postfix/pickup[17587]: 8AD3421A12: uid=0 from=<root>
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:57 virtu postfix/cleanup[18579]: warning: 8AD3421A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:57 virtu postfix/pickup[17587]: warning: maildrop/C6D361F63D: error writing 8AD3421A12: queue file write error
Dec 30 09:06:57 virtu sshd[18592]: Connection closed by 82.159.78.242 port 60966 [preauth]
Dec 30 09:06:58 virtu postfix/pickup[17587]: 8B73F21A12: uid=0 from=<root>
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:58 virtu postfix/cleanup[18578]: warning: 8B73F21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:58 virtu postfix/pickup[17587]: warning: maildrop/919EB1F6F3: error writing 8B73F21A12: queue file write error
Dec 30 09:06:59 virtu postfix/pickup[17587]: 8BFD121A12: uid=0 from=<root>
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:06:59 virtu postfix/cleanup[18577]: warning: 8BFD121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:06:59 virtu postfix/pickup[17587]: warning: maildrop/0D6711F787: error writing 8BFD121A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: Invalid user admin from 82.159.78.242 port 32900
Dec 30 09:07:00 virtu sshd[18594]: input_userauth_request: invalid user admin [preauth]
Dec 30 09:07:00 virtu postfix/pickup[17587]: 8C47321A12: uid=0 from=<root>
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:00 virtu postfix/cleanup[18579]: warning: 8C47321A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:00 virtu postfix/pickup[17587]: warning: maildrop/9D14C1F6B5: error writing 8C47321A12: queue file write error
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): check pass; user unknown
Dec 30 09:07:00 virtu sshd[18594]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=82.159.78.242
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session opened for user sogo by (uid=0)
Dec 30 09:07:01 virtu CRON[18598]: (sogo) CMD (/usr/sbin/sogo-tool expire-sessions 30 >/dev/null 2>&1; /usr/sbin/sogo-ealarms-notify >/dev/null 2>&1)
Dec 30 09:07:01 virtu CRON[18597]: pam_unix(cron:session): session closed for user sogo
Dec 30 09:07:01 virtu postfix/pickup[17587]: 8CB7621A12: uid=0 from=<root>
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:01 virtu postfix/cleanup[18578]: warning: 8CB7621A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:01 virtu postfix/pickup[17587]: warning: maildrop/729BD218B7: error writing 8CB7621A12: queue file write error
Dec 30 09:07:02 virtu postfix/pickup[17587]: 8D3DF21A12: uid=0 from=<root>
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:02 virtu postfix/cleanup[18577]: warning: 8D3DF21A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:02 virtu postfix/pickup[17587]: warning: maildrop/72D5621866: error writing 8D3DF21A12: queue file write error
Dec 30 09:07:03 virtu sshd[18594]: Failed password for invalid user admin from 82.159.78.242 port 32900 ssh2
Dec 30 09:07:03 virtu sshd[18594]: Connection closed by 82.159.78.242 port 32900 [preauth]
Dec 30 09:07:03 virtu postfix/pickup[17587]: 8DCF821A12: uid=0 from=<root>
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:03 virtu postfix/cleanup[18579]: warning: 8DCF821A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:03 virtu postfix/pickup[17587]: warning: maildrop/578D6219A6: error writing 8DCF821A12: queue file write error
Dec 30 09:07:04 virtu postfix/pickup[17587]: 8E51121A12: uid=0 from=<root>
Dec 30 09:07:04 virtu postfix/proxymap[17757]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (115)
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mx.illuminareconsulting.com"
Dec 30 09:07:04 virtu postfix/cleanup[18578]: warning: 8E51121A12: sender_bcc_maps map lookup problem -- message not accepted, try again later
Dec 30 09:07:04 virtu postfix/pickup[17587]: warning: maildrop/CBA4C218B9: error writing 8E51121A12: queue file write error


Kindly appreciate if anybody could help.
Thank you






linux debian mysql mariadb




linux debian mysql mariadb






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Dec 30 '17 at 12:20









GAD3R

26.9k1757112




26.9k1757112










asked Dec 30 '17 at 9:10









Raditya Adi BaskaraRaditya Adi Baskara

134




134












  • Possible duplicate of MariaDB won't start

    – JdeBP
    Dec 30 '17 at 12:26






  • 1





    Well that was my old question which was moved from stack overflow. I will delete that question. Thanks for reminding

    – Raditya Adi Baskara
    Dec 30 '17 at 12:33

















  • Possible duplicate of MariaDB won't start

    – JdeBP
    Dec 30 '17 at 12:26






  • 1





    Well that was my old question which was moved from stack overflow. I will delete that question. Thanks for reminding

    – Raditya Adi Baskara
    Dec 30 '17 at 12:33
















Possible duplicate of MariaDB won't start

– JdeBP
Dec 30 '17 at 12:26





Possible duplicate of MariaDB won't start

– JdeBP
Dec 30 '17 at 12:26




1




1





Well that was my old question which was moved from stack overflow. I will delete that question. Thanks for reminding

– Raditya Adi Baskara
Dec 30 '17 at 12:33





Well that was my old question which was moved from stack overflow. I will delete that question. Thanks for reminding

– Raditya Adi Baskara
Dec 30 '17 at 12:33










1 Answer
1






active

oldest

votes


















2














Delete the file /var/lib/mysql/tc.log reboot the system and start maria db again. Also ensure there is enough space in /var and /tmp if you're using separate partition for them.



I think once your /var partition got full and so mariadb failed to create tc.log file and ended up creating a 0 bit file which is causing the problem.



This post may be helpful.






share|improve this answer























  • YOU'RE MY SAVIOR! One question, is it safe to delete files in /var/log and /var/temp? Because those two dirs is creating an enermous size of logs until it took all my disk space, especiall /var/log/.

    – Raditya Adi Baskara
    Dec 30 '17 at 10:26






  • 1





    You shall setup log rotation for log files. This will split log files daily or monthly basis depending on your setup. And then setup a cornjob to delete old logs. Otherwise you may manually delete them after some days. No harm in doing so. I don't have a /vat/temp directory and don't know about it. However /tmp contains some saved cookie etc. Removing them will log out your clients. And some temporary saved details like yum update details may gone. But no permanent harm to system.

    – Abhik Bose
    Dec 30 '17 at 10:33











  • Okay then probably i should create a cronjob to automatically delete old logs. Thank you so much for the explanation and solution!

    – Raditya Adi Baskara
    Dec 30 '17 at 10:54











  • @RadityaAdiBaskara Take a look at the logrotate.

    – setevoy
    Dec 30 '17 at 16:31










Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f413782%2fmariadb-wont-start-even-after-reinstalling%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









2














Delete the file /var/lib/mysql/tc.log reboot the system and start maria db again. Also ensure there is enough space in /var and /tmp if you're using separate partition for them.



I think once your /var partition got full and so mariadb failed to create tc.log file and ended up creating a 0 bit file which is causing the problem.



This post may be helpful.






share|improve this answer























  • YOU'RE MY SAVIOR! One question, is it safe to delete files in /var/log and /var/temp? Because those two dirs is creating an enermous size of logs until it took all my disk space, especiall /var/log/.

    – Raditya Adi Baskara
    Dec 30 '17 at 10:26






  • 1





    You shall setup log rotation for log files. This will split log files daily or monthly basis depending on your setup. And then setup a cornjob to delete old logs. Otherwise you may manually delete them after some days. No harm in doing so. I don't have a /vat/temp directory and don't know about it. However /tmp contains some saved cookie etc. Removing them will log out your clients. And some temporary saved details like yum update details may gone. But no permanent harm to system.

    – Abhik Bose
    Dec 30 '17 at 10:33











  • Okay then probably i should create a cronjob to automatically delete old logs. Thank you so much for the explanation and solution!

    – Raditya Adi Baskara
    Dec 30 '17 at 10:54











  • @RadityaAdiBaskara Take a look at the logrotate.

    – setevoy
    Dec 30 '17 at 16:31















2














Delete the file /var/lib/mysql/tc.log reboot the system and start maria db again. Also ensure there is enough space in /var and /tmp if you're using separate partition for them.



I think once your /var partition got full and so mariadb failed to create tc.log file and ended up creating a 0 bit file which is causing the problem.



This post may be helpful.






share|improve this answer























  • YOU'RE MY SAVIOR! One question, is it safe to delete files in /var/log and /var/temp? Because those two dirs is creating an enermous size of logs until it took all my disk space, especiall /var/log/.

    – Raditya Adi Baskara
    Dec 30 '17 at 10:26






  • 1





    You shall setup log rotation for log files. This will split log files daily or monthly basis depending on your setup. And then setup a cornjob to delete old logs. Otherwise you may manually delete them after some days. No harm in doing so. I don't have a /vat/temp directory and don't know about it. However /tmp contains some saved cookie etc. Removing them will log out your clients. And some temporary saved details like yum update details may gone. But no permanent harm to system.

    – Abhik Bose
    Dec 30 '17 at 10:33











  • Okay then probably i should create a cronjob to automatically delete old logs. Thank you so much for the explanation and solution!

    – Raditya Adi Baskara
    Dec 30 '17 at 10:54











  • @RadityaAdiBaskara Take a look at the logrotate.

    – setevoy
    Dec 30 '17 at 16:31













2












2








2







Delete the file /var/lib/mysql/tc.log reboot the system and start maria db again. Also ensure there is enough space in /var and /tmp if you're using separate partition for them.



I think once your /var partition got full and so mariadb failed to create tc.log file and ended up creating a 0 bit file which is causing the problem.



This post may be helpful.






share|improve this answer













Delete the file /var/lib/mysql/tc.log reboot the system and start maria db again. Also ensure there is enough space in /var and /tmp if you're using separate partition for them.



I think once your /var partition got full and so mariadb failed to create tc.log file and ended up creating a 0 bit file which is causing the problem.



This post may be helpful.







share|improve this answer












share|improve this answer



share|improve this answer










answered Dec 30 '17 at 9:45









Abhik BoseAbhik Bose

1,5711323




1,5711323












  • YOU'RE MY SAVIOR! One question, is it safe to delete files in /var/log and /var/temp? Because those two dirs is creating an enermous size of logs until it took all my disk space, especiall /var/log/.

    – Raditya Adi Baskara
    Dec 30 '17 at 10:26






  • 1





    You shall setup log rotation for log files. This will split log files daily or monthly basis depending on your setup. And then setup a cornjob to delete old logs. Otherwise you may manually delete them after some days. No harm in doing so. I don't have a /vat/temp directory and don't know about it. However /tmp contains some saved cookie etc. Removing them will log out your clients. And some temporary saved details like yum update details may gone. But no permanent harm to system.

    – Abhik Bose
    Dec 30 '17 at 10:33











  • Okay then probably i should create a cronjob to automatically delete old logs. Thank you so much for the explanation and solution!

    – Raditya Adi Baskara
    Dec 30 '17 at 10:54











  • @RadityaAdiBaskara Take a look at the logrotate.

    – setevoy
    Dec 30 '17 at 16:31

















  • YOU'RE MY SAVIOR! One question, is it safe to delete files in /var/log and /var/temp? Because those two dirs is creating an enermous size of logs until it took all my disk space, especiall /var/log/.

    – Raditya Adi Baskara
    Dec 30 '17 at 10:26






  • 1





    You shall setup log rotation for log files. This will split log files daily or monthly basis depending on your setup. And then setup a cornjob to delete old logs. Otherwise you may manually delete them after some days. No harm in doing so. I don't have a /vat/temp directory and don't know about it. However /tmp contains some saved cookie etc. Removing them will log out your clients. And some temporary saved details like yum update details may gone. But no permanent harm to system.

    – Abhik Bose
    Dec 30 '17 at 10:33











  • Okay then probably i should create a cronjob to automatically delete old logs. Thank you so much for the explanation and solution!

    – Raditya Adi Baskara
    Dec 30 '17 at 10:54











  • @RadityaAdiBaskara Take a look at the logrotate.

    – setevoy
    Dec 30 '17 at 16:31
















YOU'RE MY SAVIOR! One question, is it safe to delete files in /var/log and /var/temp? Because those two dirs is creating an enermous size of logs until it took all my disk space, especiall /var/log/.

– Raditya Adi Baskara
Dec 30 '17 at 10:26





YOU'RE MY SAVIOR! One question, is it safe to delete files in /var/log and /var/temp? Because those two dirs is creating an enermous size of logs until it took all my disk space, especiall /var/log/.

– Raditya Adi Baskara
Dec 30 '17 at 10:26




1




1





You shall setup log rotation for log files. This will split log files daily or monthly basis depending on your setup. And then setup a cornjob to delete old logs. Otherwise you may manually delete them after some days. No harm in doing so. I don't have a /vat/temp directory and don't know about it. However /tmp contains some saved cookie etc. Removing them will log out your clients. And some temporary saved details like yum update details may gone. But no permanent harm to system.

– Abhik Bose
Dec 30 '17 at 10:33





You shall setup log rotation for log files. This will split log files daily or monthly basis depending on your setup. And then setup a cornjob to delete old logs. Otherwise you may manually delete them after some days. No harm in doing so. I don't have a /vat/temp directory and don't know about it. However /tmp contains some saved cookie etc. Removing them will log out your clients. And some temporary saved details like yum update details may gone. But no permanent harm to system.

– Abhik Bose
Dec 30 '17 at 10:33













Okay then probably i should create a cronjob to automatically delete old logs. Thank you so much for the explanation and solution!

– Raditya Adi Baskara
Dec 30 '17 at 10:54





Okay then probably i should create a cronjob to automatically delete old logs. Thank you so much for the explanation and solution!

– Raditya Adi Baskara
Dec 30 '17 at 10:54













@RadityaAdiBaskara Take a look at the logrotate.

– setevoy
Dec 30 '17 at 16:31





@RadityaAdiBaskara Take a look at the logrotate.

– setevoy
Dec 30 '17 at 16:31

















draft saved

draft discarded
















































Thanks for contributing an answer to Unix & Linux Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f413782%2fmariadb-wont-start-even-after-reinstalling%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Creating 100m^2 grid automatically using QGIS?Creating grid constrained within polygon in QGIS?Createing polygon layer from point data using QGIS?Creating vector grid using QGIS?Creating grid polygons from coordinates using R or PythonCreating grid from spatio temporal point data?Creating fields in attributes table using other layers using QGISCreate .shp vector grid in QGISQGIS Creating 4km point grid within polygonsCreate a vector grid over a raster layerVector Grid Creates just one grid

Image
Pattern match does not work in bash script Mage Armor with Defense fighting style (for Adventurers League bladeslinger) LaTeX closing $ signs makes cursor jump String Manipulation Interpreter Can divisibility rules for digits be generalized to sum of digits I'm planning on buying a laser printer but concerned about the life cycle of toner in the machine What is the offset in a seaplane's hull? How can I make my BBEG immortal short of making them a Lich or Vampire? What are the differences between the usage of 'it' and 'they'? The use of multiple foreign keys on same column in SQL Server How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy? Is it tax fraud for an individual to declare non-taxable revenue as taxable income? (US tax laws) Why Is Death Allowed In the Matrix? Minkowski space Why are 150k or 200k jobs considered good when there are 300k+ births a month? Why do f...
Read more

What is this called? Old film camera viewer?What makes a good film camera?What to do with an old film camera?What should one look for when buying a used film camera?What is the value and age of this pre-1967 Ricoh 35 mm camera?DSLR recommendation, question about old Canon 35mm film Camera & lensesCan anyone identify the silver rangefinder-style camera in this advertisement?What kind of a Polaroid 600-camera is this?Will an old film camera still work even when not used in a very long time?What is this camera / Can I develop the film?How to fit an action camera into antique (bellows) housing?What to check when buying used and old film bodies?

Image
Why is delta-v is the most useful quantity for planning space travel? How to color a zone in Tikz Is there enough fresh water in the world to eradicate the drinking water crisis? Adding empty element to declared container without declaring type of element Can I use my Chinese passport to enter China after I acquired another citizenship? Superhero words! What to do when my ideas aren't chosen, when I strongly disagree with the chosen solution? My boss asked me to take a one-day class, then signs it up as a day off Can a Bard use an arcane focus? Can a malicious addon access internet history and such in chrome/firefox? Pronouncing Homer as in modern Greek Java - What do constructor type arguments mean when placed *before* the type? Is there a good way to store credentials outside of a password manager? Why are all the doors on Ferenginar (the Ferengi home world) far shorter than the average Ferengi? Have I saved too much for retirement so far? Why Were M...
Read more

Why is this plane circling around the Lucknow airport every day?Why do aircraft on Flight Radar 24 jump around randomly sometimes?What airport has this walkway over a taxiway?How does Chicago O'Hare's tower sequence aircraft at peak capacity?Which airport is featured in this Delta commercial?After a crash, for how long is the airport closed?Can a passenger plane stand still in the air, or hover at a fixed location above a ground?What are those trucks towing around, and why?What is this airport outside of Cairo, Egypt?Which US airport has the lowest circling MDH?What is this airport video?

Image
Freedom of speech and where it applies THT: What is a squared annular “ring”? Hot bath for aluminium engine block and heads Delete database accidentally by a bash, rescue please Why do IPv6 unique local addresses have to have a /48 prefix? How can Trident be so inexpensive? Will it orbit Triton or just do a (slow) flyby? Customize circled numbers Drawing ramified coverings with tikz How does the reference system of the Majjhima Nikaya work? Why did the EU agree to delay the Brexit deadline? Melting point of aspirin, contradicting sources Is Asuka Langley-Soryu disgusted by Shinji? Did US corporations pay demonstrators in the German demonstrations against article 13? Is camera lens focus an exact point or a range? Does a 'pending' US visa application constitute a denial? GraphicsGrid with a Label for each Column and Row How do you respond to a colleague from another team when they're wrongly expecting that you'll help them? How is flybla...
Read more