Bug #2831 --external-locking does not fully work with --myisam-recover
| Submitted: | 16 Feb 2004 15:06 | Modified: | 27 Sep 2008 9:51 |
|---|---|---|---|
| Reporter: | Peter Zaitsev (Basic Quality Contributor) | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server: MyISAM storage engine | Severity: | S3 (Non-critical) |
| Version: | 4.0 | OS: | Any (all) |
| Assigned to: | Ingo Strüwing | CPU Architecture: | Any |
[16 Feb 2004 15:06]
Peter Zaitsev
[18 Sep 2004 19:48]
Ingo Strüwing
We do now check if the table has been properly unlocked after each external lock. If it is not, we check and repair it. For the technical interested: We set the field 'open_count' before each modification to the table and reset it before each unlock. If the open_count is set after a successful locking, another server 'forgot' to unlock the table (because it crashed). Fixed in 4.0.22.
[5 Oct 2004 21:11]
Michael Widenius
Sorry, but the suggested approch doesn't work so I had to revert the fix. The better fix would be to mark the old myisam index file as invalid and force MyISAM to reopen the table when it finds such a header. This is however too big change in MySQL 4.0 and has to wait until MySQL 5 In the mean time: Don't run repair or optimize table on a table that is shared between multiple MySQL severs.
[27 Sep 2008 9:51]
Konstantin Osipov
I believe we have no plans to fix --external-locking.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.