MySQL Bugs: #38901: InnoDB logs error repeatedly when trying to load page into buffer pool

Bug #38901	InnoDB logs error repeatedly when trying to load page into buffer pool
Submitted:	19 Aug 2008 23:06	Modified:	22 Oct 21:51
Reporter:	Kyle Joiner
Status:	Open
Category:	Server: InnoDB	Severity:	S2 (Serious)
Version:	5.0.18-max, 5.0.66a, 5.1.28, 5.1.40	OS:	Any
Assigned to:		Target Version:
Tags:	innodb, buffer pool, error log, repeat

Description:
InnoDB logs an error repeatedly when attempting to load a page into the buffer pool from
a corrupted tablespace.

buf_page_get_gen calls buf_read_page to load the page into the buffer pool
buf_read_page produces this error message

080815 12:05:52 InnoDB: Error: trying to access tablespace 120729648 page no. 942485559,
InnoDB: but the tablespace does not exist or is just being dropped.
080815 12:05:52 InnoDB: Error: trying to access tablespace 120729648 page no. 942485559,
InnoDB: but the tablespace does not exist or is just being dropped.

buf_page_get_gen doesn't check it for any problems however and it then loops to try to
read the buffer pool, finds it isn't present and again calls buf_read_page to try to
load, repeat, etc...

How to repeat:
Not positive on how to repeat.  It would require the corruption to be in the page being
loaded into the buffer pool.

Suggested fix:
Have buf_page_get_gen verify that an error did not occur.

Any ideas on how to repeat and/or fragments of code with possible loop to review are
greatly appreciated.

I repeated this while selecting from a table, flushing a table while 'alter table ..
discard tablespace' was being run.

080914 11:26:46  InnoDB: Error: trying to access tablespace 15 page no. 9,
InnoDB: but the tablespace does not exist or is just being dropped.
080914 11:26:46  InnoDB: Error: trying to access tablespace 15 page no. 9,
InnoDB: but the tablespace does not exist or is just being dropped.
080914 11:26:46  InnoDB: Error: trying to access tablespace 15 page no. 9,
InnoDB: but the tablespace does not exist or is just being dropped.
080914 11:26:46  InnoDB: Error: trying to access tablespace 15 page no. 9,
InnoDB: but the tablespace does not exist or is just being dropped.

11GB of the above messages appeared in 10 minutes (until I killed server).

hi calvin! here's the info i have. i'll try put together a proper testcase soon

Attachment: bug38901_preliminary_info.txt (text/plain), 16.09 KiB.

Hi, could you send the structure of table5 and some idea of how many rows there are?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hm, I'm having trouble repeating this now, because I keep crashing the server due to bug
#39436 .

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

still happens in 5.1.40...
endless loop:

InnoDB: but the tablespace does not exist or is just being dropped.
091022 21:52:56  InnoDB: Error: trying to access tablespace 21 page no. 5,
InnoDB: but the tablespace does not exist or is just being dropped.
091022 21:52:56  InnoDB: Error: trying to access tablespace 21 page no. 5,
InnoDB: but the tablespace does not exist or is just being dropped.
091022 21:52:56  InnoDB: Error: trying to access tablespace 21 page no. 5,
InnoDB: but the tablespace does not exist or is just being dropped.