MySql InnoDB ALTER TABLE 错误
我的问题与此问题类似：
我的消息是：
#1025 - Error on rename of './balance/#A' to './balance/#B' (errno: -1)
任何时候我想更改表我收到一条神秘的消息，表明它无法完成（如上面的问题）。
我所做的所有研究都指出了引用相关表的外键的问题。我的表没有外键，非常简单，只有一个唯一的主键。
关于此问题的 MySQL 文档非常简明，没有提供任何详细信息。我过去遇到过权限问题，我什至看不到 innoDB 表的内容，但我解决了这个问题。我想知道这是否可能是某种许可问题。使用MySQL 5.5.15-日志。
此问题已解决。就我而言，这与启用 innodb 表的强制恢复有关。我通过查看我的日志找到了它。当强制恢复打开时，显然不允许对数据库进行任何更改。
现在，它在我的 InnoDB 引擎日志中生成一个没有 FK 的外键错误的事实是另一个问题......我将其作为错误发布到 MySQL。
My issue is similar to this question:
My message is:
#1025 - Error on rename of './balance/#A' to './balance/#B' (errno: -1)
Anytime I want to alter the table I get a cryptic message that it can't be done (like the above question).
All the research I've done points to an issue with foreign keys referencing the table in question. My table has no foreign keys and is quite simple, just a unique primary key.
MySQL documentation for this issue is spartan and does not give any details. I've had an issue in the past with permissions, and I couldn't even see the contents of innoDB tables, but I resolved that. I wonder if this could be some sort of permission issue. Using MySQL 5.5.15-log.
This issue was resolved. In my case it had to with with having forced recovery for my innodb tables enabled. I found it by looking in my log. When forced recovery is on, apparently no changes are allowed to the DB.
Now, the fact that it generated a foreign key error in my InnoDB engine log with no FKs is another issue.....I posted it as a bug to MySQL.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论