MySQL Forums
Forum List  »  Partitioning

Failed to read from the .par file
Posted by: IGG t
Date: April 02, 2014 09:49AM

I've been doing some testing with Partitions, and have a problem (of sorts).

I was adding and deleting data into and from one of my partitions. This was going fine:

INSERT INTO p_table SELECT * FROM p_table2;
DELETE FROM p_table WHERE DATE(Pdate) = '2013-12-21';

I did this, with multiple dates, multiple times,


But I have now got a warning coming up.
SELECT PARTITION_NAME, TABLE_ROWS FROM information_schema.PARTITIONS WHERE TABLE_NAME = 'p_table';

error: Failed to read from the .par file


The query still seems to run OK though, and I can add / delete from the table with no seeming problem. Is this actually a problem, or can I ignore it? I want to know before I roll this out to my LIVE database.

It is running on MySQL 5.5.31 on Windows.

I have tried MySQLCheck.exe, and have restarted MySQL a few times.



Edited 1 time(s). Last edit at 04/02/2014 09:53AM by IGG t.

Options: ReplyQuote


Subject
Views
Written By
Posted
Failed to read from the .par file
9937
April 02, 2014 09:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.