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

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

Can I redirect output to a log file and background a process at the same time?2019 Community Moderator ElectionUnable to write to file in shell script when running command in backgroundredirect and log script outputhow to properly log the output of a console program that frequently updates “parts” of the screen, resulting in a messy log file?How can I redirect the output of a child process?grep script - output lines at the same time into echoHow to run process in background and get its pid to create log file nameHow to redirect output to a log from expect commandHow to clear a redirect log file content in shell?Log background jobs started in all the manually started shells?Why do `jobs` and `dirs` run in command subsitution, process substitution, pipeline, and background jobs output the same as in original shell?How to redirect output to file to STDOUT?

Image
Makefile strange variable substitution Are all players supposed to be able to see each others' character sheets? How to draw cubes in a 3 dimensional plane Shifting between bemols (flats) and diesis (sharps)in the key signature They call me Inspector Morse An alternative proof of an application of Hahn-Banach Virginia employer terminated employee and wants signing bonus returned Why was Goose renamed from Chewie for the Captain Marvel film? Accepted offer letter, position changed Why does Captain Marvel assume the people on this planet know this? Word for a person who has no opinion about whether god exists Are babies of evil humanoid species inherently evil? How do I express some one as a black person? Am I not good enough for you? Does the nature of the Apocalypse in The Umbrella Academy change from the first to the last episode? Definition of Statistic What problems would a superhuman have whose skin is constantly hot? meaning and function of ...
Read more