4

Im using AWS aurora which is MySQL 5,6 Recently I can see an error like below.

2017-02-14 20:42:34 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 264 from the cache but
InnoDB: it is not there.
2017-02-14 20:42:34 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 264 from the cache but
InnoDB: it is not there.
2017-02-14 20:49:56 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 378 from the cache but
InnoDB: it is not there.
2017-02-14 20:49:56 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 378 from the cache but
InnoDB: it is not there.
2017-02-14 20:50:41 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 361 from the cache but
InnoDB: it is not there.
2017-02-14 20:50:41 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 361 from the cache but
InnoDB: it is not there.
2017-02-14 20:51:10 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 393 from the cache but
InnoDB: it is not there.
2017-02-14 20:51:10 2b2ca6a00700 InnoDB: Error: trying to remove tablespace 393 from the cache but
InnoDB: it is not there.

I don't know why its coming, Can anyone tell what its actually trying to say?

7
  • Did the server crash recently? And you were in the process of doing something such as ALTER TABLE?
    – Rick James
    Sep 26, 2017 at 20:59
  • Does this come up with anything? SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%';
    – Rick James
    Sep 26, 2017 at 21:00
  • Its showing Empty set (0.00 sec)
    – TheDataGuy
    Sep 27, 2017 at 0:49
  • And my questions in the previous Comment?
    – Rick James
    Sep 27, 2017 at 1:05
  • No it's actuall a new server
    – TheDataGuy
    Sep 27, 2017 at 1:40

1 Answer 1

1

That seems to be a AWS problem bug. Please, see https://forums.aws.amazon.com/thread.jspa?threadID=226520

3
  • Yes, its a bug. But it would be great if someone explains about this issue.
    – TheDataGuy
    Sep 26, 2017 at 17:59
  • 'fix next release' from 2 years ago. Not very reassuring.
    – danblack
    Sep 4, 2018 at 9:06
  • still not fixed ;)
    – Alan Sereb
    Dec 14, 2019 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.