The NAS does make snapshots periodically (every few hours), but it
doesn't look like the timestamps of the records match up with when the
backup would have run (the records are written each minute) so I
don't think that that is the cause.
What did you do to resolve the issue?
--
Mark P. Hennessy
Dan Buettner wrote:
---
Mark, any chance that a process on the NAS is accessing your data files
for some reason? Backups?
We had some severe crashing problems with MySQL years ago we eventually
traced to a backup process accessing the live data directory.
Dan
[EMAIL PROTECTED] wrote:
*** This happens for me using FreeBSD 6.0 or FreeBSD 6.1 with the most
recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files
reside on a NetApp NAS share shared over NFS. It only seems to happen
with very frequently written-to tables. I sent this to the list last
week and no one responded. ***
Hi, I was wondering if anyone else had encountered this issue and/or
come
up with what needs to be done to resolve it:
I currently have MySQL 5.0.22 built from ports on a FreeBSD 6.1 machine
with the DB data residing on a NetApp share connected via NFS. A
strange
thing happens often after a few hours or a couple of days, some tables
that are very active start to crash for no apparent reason as far as I
can tell.
Example output from check table tablename:
+----------------------------+-------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+----------------------------+-------+----------+-------------------------------------------------------------------+
| dbname.tablename | check | warning | Table is marked as crashed |
| dbname.tablename | check | error | Found key at page 18259968 that
points to record outside datafile |
| dbname.tablename | check | error | Corrupt
|
+----------------------------+-------+----------+-------------------------------------------------------------------+
I've seen this happen on FreeBSD 6.0 and 6.1 with MySQL 4.1.x and MySQL
5.0.x built from ports. Has anyone else seen this and if so has a
resolution been found?
--
Mark P. Hennessy
--
Dan Buettner
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
