[EP-tech] Re: mysqldump problem with cachetables
M.Bodger at westminster.ac.uk
Fri Apr 19 15:07:49 BST 2013
Thanks for this information, it's very helpful, and I'll go with the 'force' option.
From: Paolo Tealdi [paolo.tealdi at polito.it]
Sent: 19 April 2013 14:23
To: Malcolm Bodger
Cc: <eprints-tech at ecs.soton.ac.uk>
Subject: Re: [EP-tech] mysqldump problem with cachetables
Il 19/04/2013 15:01, Malcolm Bodger ha scritto:
> Hi Paolo,
> I run the cleanup_cachemaps, but it only removed one orphaned table, leaving me with 942.
> Would you know why I have so many cache tables?
This is normal.
When you make a web search on your eprints web interface, the system saves the result records in a cache table, avoiding to repeat a (possibly) cpu intensive operation (for example to present the next search page).
The server saves the recordset result in a table named "cache$number" and adds a line also in "cachemap" table.
The epadmin command i wrote matches the records in "cache" table with the cache"number" table, cleaning orphaned table (NOT all cache table on the orphaned one).
The server has a setting for the max number of cache table active, when you go beyond that number, automatically the server drops the oldest table "table$number" and deletes its related record in "cachemap" table.
The error you find in the mysqldump is due to this automatic cache cleaning by eprints: mysqldump tries to dump a table that eprints has already deleted.
I think it's not a problem if you put --force in the mysqldump parameters.
Ing. Paolo Tealdi Area IT - Politecnico Torino
Telefono/Phone : +39-011-0906714 , FAX : +39-011-0906799
Indirizzo/Address : C.so Duca degli Abruzzi, 24 - 10129 Torino - ITALY
Skype : tealdi.paolo
Please consider your environmental responsibility before printing this e-mail
The University of Westminster is a charity and a company limited by guarantee. Registration number: 977818 England. Registered Office: 309 Regent Street, London W1B 2UW.
More information about the Eprints-tech