Opened 8 months ago
Last modified 7 months ago
#13830 assigned Bug/Something is broken
mysql error claudette
Reported by: | https://id.mayfirst.org/jaimev | Owned by: | https://id.mayfirst.org/jaimev |
---|---|---|---|
Priority: | High | Component: | Tech |
Keywords: | mysql error | Cc: | https://id.mayfirst.org/jamie |
Sensitive: | no |
Description
There is a new mysql error on claudette
180626 8:13:07 InnoDB: Warning: trying to delete tablespace '/tmp/#sql3aae_104160_0.ibd', InnoDB: but there are 0 flushes and 1 pending i/o's on it
Change History (5)
comment:1 Changed 8 months ago by https://id.mayfirst.org/jaimev
- Owner set to https://id.mayfirst.org/jaimev
- Status changed from new to assigned
comment:2 Changed 8 months ago by https://id.mayfirst.org/jaimev
This hasn't show up yet this morning because of the log rotation but the error was still present as of yesterday.
comment:3 Changed 7 months ago by https://id.mayfirst.org/jamie
This one is baffling - it keeps coming back and my web searches turn up nothing (except this ticket).
I have seen strange errors when MySQL tries to write temporary tables to the /tmp directory and runs out of disk space, so I just boosted the /tmp directory from 1GB to 2GB. Let's see if the errors go away.
comment:4 Changed 7 months ago by https://id.mayfirst.org/jamie
My only other idea would be to upgrade claudette to stretch and see if mariadb can do better.
comment:5 Changed 7 months ago by https://id.mayfirst.org/jaimev
This error has appeared again today.
Please login to add comments to this ticket.
This is something I forgot to ask you about today. The error seems to have resolved itself though.