Re: InnoDB: Cannot allocate 18446744073709540680 bytes of memory after 60 retries over 60 seconds.

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Wed, 1 Feb 2017 16:48:22 +0000
Message-ID: <o6t3gm$fmd$3_at_news.albasani.net>


On 01/02/17 16:11, djburbridge_at_gmail.com wrote:
> Thanks again - I tried innodb_force_recovery=2, and was then able to get into the database & copy everything.
>
> I then moved to 5.7.17. Tried with the same datadir, but still got the error.
>
> Reinitialised with a new datadir, no error - now I just need to import all the data back in again:-)
>
> Still don't really know what was wrong...
>
> Thanks for you assistance anyway!
>
Sounds like disk corruption.

If the disk has any diagnostics, now might be a good time to use them.

-- 
Ideas are more powerful than guns. We would not let our enemies have 
guns, why should we let them have ideas?

Josef Stalin
Received on Wed Feb 01 2017 - 17:48:22 CET

Original text of this message