MySQL Forums
Forum List  »  InnoDB

Issue with `ibtmp1` file preventing start up
Posted by: C D
Date: April 01, 2020 09:28PM

I've been working with MySQL 8 within Ubuntu 18.04 for several weeks without issue. My MySQL installation exists on an external HD.

Earlier, I undocked my laptop, then later redocked and wasn't able to stop/start MySQL. Killing existing MySQL processes and restarting didn't work either. I've also restarted my machine without effect.

Checking the error.log file, the first error included was:
"File ibtmp1: 'stat' returned OS error 105."


The following is the output of `journalctl -xe`:

chris@chris-x1c6:/etc/mysql/mysql.conf.d$ journalctl -xe
Apr 01 18:39:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:30Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:39:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:40Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:39:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:40Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:39:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:50Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:39:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:50Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:00Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:40:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:00Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:10Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:40:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:10Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:20Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:40:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:20Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:30Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:40:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:30Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:40Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:40:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:40Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:50Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:40:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:50Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:00Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:41:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:00Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:01 chris-x1c6 sudo[4168]: chris : TTY=pts/0 ; PWD=/etc/mysql/mysql.conf.d ; USER=root ; COMMAND=/usr/bin/vim mysqld.cnf
Apr 01 18:41:01 chris-x1c6 sudo[4168]: pam_unix(sudo:session): session opened for user root by (uid=0)
Apr 01 18:41:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:10Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:41:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:10Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:14 chris-x1c6 sudo[4168]: pam_unix(sudo:session): session closed for user root
Apr 01 18:41:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:20Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:41:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:20Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:22 chris-x1c6 sudo[4173]: chris : TTY=pts/0 ; PWD=/etc/mysql/mysql.conf.d ; USER=root ; COMMAND=/bin/systemctl restart mysql
Apr 01 18:41:22 chris-x1c6 sudo[4173]: pam_unix(sudo:session): session opened for user root by (uid=0)
Apr 01 18:41:22 chris-x1c6 systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has begun starting up.
Apr 01 18:41:22 chris-x1c6 audit[4214]: AVC apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbi
Apr 01 18:41:22 chris-x1c6 kernel: audit: type=1400 audit(1585791682.149:59): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" p
Apr 01 18:41:22 chris-x1c6 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Apr 01 18:41:22 chris-x1c6 systemd[1]: mysql.service: Failed with result 'exit-code'.
Apr 01 18:41:22 chris-x1c6 systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has failed.
--
-- The result is RESULT.
Apr 01 18:41:22 chris-x1c6 sudo[4173]: pam_unix(sudo:session): session closed for user root
Apr 01 18:41:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:30Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=tel
Apr 01 18:41:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:30Z E! [agent] Error writing to outputs.influxdb: could not write any address
lines 1186-1234/1234 (END)
Apr 01 18:39:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:30Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:39:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:40Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:39:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:40Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:39:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:50Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:39:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:39:50Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:00Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:40:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:00Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:10Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:40:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:10Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:20Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:40:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:20Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:30Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:40:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:30Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:40Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:40:40 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:40Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:40:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:50Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:40:50 chris-x1c6 telegraf[1341]: 2020-04-02T01:40:50Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:00Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:41:00 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:00Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:01 chris-x1c6 sudo[4168]: chris : TTY=pts/0 ; PWD=/etc/mysql/mysql.conf.d ; USER=root ; COMMAND=/usr/bin/vim mysqld.cnf
Apr 01 18:41:01 chris-x1c6 sudo[4168]: pam_unix(sudo:session): session opened for user root by (uid=0)
Apr 01 18:41:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:10Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:41:10 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:10Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:14 chris-x1c6 sudo[4168]: pam_unix(sudo:session): session closed for user root
Apr 01 18:41:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:20Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:41:20 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:20Z E! [agent] Error writing to outputs.influxdb: could not write any address
Apr 01 18:41:22 chris-x1c6 sudo[4173]: chris : TTY=pts/0 ; PWD=/etc/mysql/mysql.conf.d ; USER=root ; COMMAND=/bin/systemctl restart mysql
Apr 01 18:41:22 chris-x1c6 sudo[4173]: pam_unix(sudo:session): session opened for user root by (uid=0)
Apr 01 18:41:22 chris-x1c6 systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has begun starting up.
Apr 01 18:41:22 chris-x1c6 audit[4214]: AVC apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" pid=4214 comm="apparmor_parser"
Apr 01 18:41:22 chris-x1c6 kernel: audit: type=1400 audit(1585791682.149:59): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" p
Apr 01 18:41:22 chris-x1c6 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Apr 01 18:41:22 chris-x1c6 systemd[1]: mysql.service: Failed with result 'exit-code'.
Apr 01 18:41:22 chris-x1c6 systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has failed.
--
-- The result is RESULT.
Apr 01 18:41:22 chris-x1c6 sudo[4173]: pam_unix(sudo:session): session closed for user root
Apr 01 18:41:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:30Z E! [outputs.influxdb] When writing to [http://localhost:8086]: Post http://localhost:8086/write?db=telegraf: dial tcp 127.0.0.1:8086: connect: conn
Apr 01 18:41:30 chris-x1c6 telegraf[1341]: 2020-04-02T01:41:30Z E! [agent] Error writing to outputs.influxdb: could not write any address

Options: ReplyQuote


Subject
Views
Written By
Posted
Issue with `ibtmp1` file preventing start up
1424
C D
April 01, 2020 09:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.