InnoDB:启动 mamp 时无法锁定错误 45

发布于 2024-10-31 00:53:30 字数 1750 浏览 0 评论 0原文

我正在将 mamp 的数据库移动到我的删除驱动器,我认为它几乎可以工作,但是每当我启动 mamp mysql 就不会启动,如果我检查错误日志,我会遇到这个:

110406 23:00:12 mysqld_safe Starting mysqld daemon with databases from /Volumes/WALL-E/db/mysql
110406 23:00:12 [Warning] One can only use the --user switch if running as root

110406 23:00:12 [Note] Plugin 'FEDERATED' is disabled.
110406 23:00:12 InnoDB: The InnoDB memory heap is disabled
110406 23:00:12 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
110406 23:00:12 InnoDB: Compressed tables use zlib 1.2.3
110406 23:00:12 InnoDB: Initializing buffer pool, size = 128.0M
110406 23:00:12 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
110406 23:00:13  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45

我也发现了这个问题 < a href="https://stackoverflow.com/questions/3415270/i-got-an-error-when-starting-mysql-unable-to-lock-ibdata1-error-11"> 但不能'似乎发现一种使 MAMP 工作的方法,我做错了什么,是权限问题吗?

PS - 是的,我的驱动器叫做 WALL-E :)

i am in the process of moving the db for mamp to my remove drive and it is almost working i think but whenever i start mamp mysql won't start and if i check the error log i come across this:

110406 23:00:12 mysqld_safe Starting mysqld daemon with databases from /Volumes/WALL-E/db/mysql
110406 23:00:12 [Warning] One can only use the --user switch if running as root

110406 23:00:12 [Note] Plugin 'FEDERATED' is disabled.
110406 23:00:12 InnoDB: The InnoDB memory heap is disabled
110406 23:00:12 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
110406 23:00:12 InnoDB: Compressed tables use zlib 1.2.3
110406 23:00:12 InnoDB: Initializing buffer pool, size = 128.0M
110406 23:00:12 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
110406 23:00:13  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45
InnoDB: Unable to lock /Volumes/WALL-E/db/mysql/ibdata1, error: 45

i also found this question but couldn't seem to find a way to make that work for MAMP, what am i doing wrong, is it a permissions problem ?

PS - Yep, my drive is called WALL-E :)

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

水水月牙 2024-11-07 00:53:30

可能是文件系统级文件锁定的问题。尝试使用 --skip-locking 启动 Mysql。我不确定如何使用 MAMP 来做到这一点,因为我从未使用过它。在其首选项中查找可以提供自定义启动选项的位置。

或者,您可能可以自定义可移动介质的安装,以启用 autofs 锁定,但我的 autofs-fu 很弱,所以我无法在那里给出任何指示。

Probably an issue with filesystem level file locking. Try starting Mysql with --skip-locking. Im not sure how to do that with MAMP as I'ver never used it. Look for a place in its preferences where you can supply a custom options for startup.

Alternatively you might be bale to customize the mounting of removable media to enable locks with autofs, but my autofs-fu is weak so i cant give any pointers there.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文