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

Word for a person who has no opinion about whether god existsWord for having a definite opinion while simultaneously withholding judgment?What's the opposite of “newcomer? Is ”veteran" OK?What do you call an “atheist” who might believe in an afterlife?What's a word for someone who wants to voice opinions but not have them challenged?Word for someone who dismisses contrary opinions as irrational?Somone who thinks they are overly special/out of the ordinaryIs there a word, phrase or idiom for “a person who is incapable of thinking about the future”?The belief that a god is human-likeA word for a non-famous person/thing you have heard a lot aboutAdjective for a person who enjoys taking care of their appearance

Image
Reverse string, can I make it faster? How strictly should I take "Candidates must be local"? Are there historical instances of the capital of a colonising country being temporarily or permanently shifted to one of its colonies? Accepted offer letter, position changed Could you please stop shuffling the deck and play already? How to secure an aircraft at a transient parking space? At what distance can a bugbear, holding a reach weapon, with the Polearm Master feat, get their Opportunity Attack? Why was Goose renamed from Chewie for the Captain Marvel film? Is it necessary to separate DC power cables and data cables? Is "history" a male-biased word ("his+story")? Why the color red for the Republican Party What's wrong with this bogus proof? Doesn't allowing a user mode program to access kernel space memory and execute the IN and OUT instructions defeat the purpose of having CPU modes? Can one live in the U.S. and not use a c...
Read more

What was this official D&D 3.5e Lovecraft-flavored rulebook?What was this set of RPG tools called?As a first-time DM should I let my players play complex character classes and roles?Nymph's Kiss and the RelationshipWhat was the name of this Cleric Prestige Class that shapes metal with its bare hands?Are the 3.5e Dragonlance books third party or official works?What's up with the domain Vile Darkness?What was this 80s book about RPGs?What was the name of this Werewolf band?What book had Rituals to “upgrade” animal companions to keep them viable at higher levels?What was this RPG that had rules for player-owned businesses?

Image
Can a Bard use an arcane focus? Indicating multiple different modes of speech (fantasy language or telepathy) The most efficient algorithm to find all possible integer pairs which sum to a given integer A known event to a history junkie How to color a zone in Tikz Simple image editor tool to draw a simple box/rectangle in an existing image Golf game boilerplate Can I use my Chinese passport to enter China after I acquired another citizenship? No idea how to draw this using tikz Is there an Impartial Brexit Deal comparison site? Reply ‘no position’ while the job posting is still there (‘HiWi’ position in Germany) Bob has never been a M before Lifted its hind leg on or lifted its hind leg towards? Can I rely on these GitHub repository files? How do I repair my stair bannister? Pronouncing Homer as in modern Greek What do you call the infoboxes with text and sometimes images on the side of a page we find in textbooks? What will be t...
Read more

2017 IndyCar Series Contents Series news Teams and drivers Schedule Season summary Footnotes References External links Navigation menu"INDYCAR: Initial 2018 bodywork concepts unveiled"the original"IndyCar confirms switch to Performance Friction brakes in 2017""AJ Foyt Racing will switch to Chevy"the original"Carlos Munoz, Conor Daly will drive for AJ Foyt Racing""Zach Veach's Indy 500 Debut Confirmed with Foyt""No mass exodus from Honda after Ganassi switch""Ex-F1 driver Sato joins Andretti Autosport for 2017 IndyCar season""IndyCar's Ryan Hunter-Reay, sponsor DHL paired through 2020""hhgregg and Andretti Autosport announce partnership for key races in 2016""INDYCAR: Rossi re-signs with Andretti"the original"McLaren Formula 1 - Fernando Alonso to race at Indy 500 with McLaren, Honda and Andretti Autosport""Shank will finally take part in Indy 500 with Harvey, Andretti | MotorSportsTalk""Andretti adds Jack Harvey to Indy 500 field""Ganassi switches to Honda power for 2017""INDYCAR: Chilton returns to Ganassi"the original"IndyCar silly season: Who's going where in 2017?""INDYCAR: Kanaan, NTT Data return to Ganassi"the original"Kimball to remain at Ganassi for 2017""Coyne confirms Bourdais for 2017 IndyCar season""Davison to sub for Bourdais in Indy 500"the original"Gutierrez confirmed for Detroit IndyCar debut""Gutierrez returns with Coyne for rest of 2017 season""Vautier to drive for Coyne at Texas"the original"INDYCAR: Coyne confirms Jones for 2017"the original"Pippa Mann returns to Coyne for Indy 500""Karam, Dreyer & Reinbold teaming up again for Indianapolis 500""Pigot to return to Ed Carpenter Racing""Hildebrand confirmed as full-time Ed Carpenter driver""Veach to replace injured Hildebrand at Barber"the originalNew Team Harding Racing Enters Chaves for 101st Indianapolis 500"Juncos Racing Announces Entry in 101st Running of the Indianapolis 500 :: Juncos Racing""Juncos confirms Pigot for Indy 500""Saavedra confirmed in Juncos' second 500 entry"the original"Lazier confirms Indy 500 run after son's USF2000 debut"the original"Claman DeMelo to race for RLLR at Sonoma"the original"Rahal signs Servia and ace engineer for 2017""IndyCar: Aleshin returns with Schmidt"the original"Aleshin replaced by Saavedra for Toronto""Jack Harvey will pilot SPM No. 7 car at Watkins Glen, Sonoma""Jay Howard confirmed in Tony Stewart's supported SPM Indy entry""INDYCAR: Newgarden to wave the flag at Penske"the original"Pagenaud opts for No. 1 in 2017"the original"Penske confirms Newgarden for 2017""Montoya to stay with Team Penske in 2017""Target leaving IndyCar after 27 seasons with Chip Ganassi""Cavin: IndyCar could see complete driver/team shakeup in 2017""End of the road for KV Racing?""KV Racing confirms closure, equipment sold to Juncos""Juncos confirms IndyCar Series entry"the original"Juncos readies IndyCar program, aims for '17 500"the original"Harding Racing to add Texas, Pocono to schedule"the original"Sato signs with Andretti Autosport for 2017""INDYCAR: Aleshin in Doubt at SPM"the original"Long Beach notebook: JR Hildebrand breaks hand""Hildebrand cleared to return at Phoenix"the original"Bourdais to undergo surgery on multiple fractures""Aleshin loses Schmidt Peterson IndyCar ride""Saavedra in at SPM for Pocono, Gateway"the original"Bourdais to make return at Gateway"the original"The IndyCar Grand Prix no longer is sponsored by Angie's List""2017 IndyCar Series rulebook""2017 Verizon IndyCar Series Official Rulebook"Official websiteeeeee

Image
1905190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194619471948194919501951195219531954195519791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200819961996–971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019Kenny BräckBuzz CalkinsScott DixonDario FranchittiSam Hornish Jr.Ryan Hunter-ReayTony KanaanBuddy LazierJosef NewgardenSimon PagenaudWill PowerGreg RayScott SharpTony StewartDan WheldonGatewayIndianapolisIowaPoconoTexasBarberCircuit of the AmericasIndianapolisLaguna SecaMid-OhioPortlandRoad AmericaDetroitLong BeachSt. PetersburgTorontoAtlantaBaltimoreCharlotteChicagolandDoverEdmontonFontanaHomesteadHoustonKansasKentuckyLas VegasLouisianaMichiganMilwaukeeMotegiNashvilleNazarethNew HampshirePhoenixPikes PeakRichmondSão PauloSonomaSurfers ParadiseWalt Disney WorldWatkins GlenBostonBras...
Read more