Opened 3 months ago

Last modified 2 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 3 months ago by https://id.mayfirst.org/jaimev

  • Owner set to https://id.mayfirst.org/jaimev
  • Status changed from new to assigned

This is something I forgot to ask you about today. The error seems to have resolved itself though.

comment:2 Changed 3 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 2 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 2 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 2 months ago by https://id.mayfirst.org/jaimev

This error has appeared again today.

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.