2

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?

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

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

  • Yes, its a bug. But it would be great if someone explains about this issue. – Bhuvanesh Sep 26 '17 at 17:59
  • 'fix next release' from 2 years ago. Not very reassuring. – danblack Sep 4 '18 at 9:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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