提问者:小点点

物理上将文件写入已满 - mysql 错误


我正在使用xampp,每次启动mysql时,我都会在xampp中出现以下错误

Error: MySQL shutdown unexpectedly.
13:16:14  [mysql]   This may be due to a blocked port, missing dependencies, 
13:16:14  [mysql]   improper privileges, a crash, or a shutdown by another method.
13:16:14  [mysql]   Press the Logs button to view error logs and check

我检查了错误日志,下面是输出,我甚至改变了端口,但这没有帮助。以前我删除了ibdata,因为我看到了一些其他的stackoverflow答案,整个数据库都丢失了,所以我不想犯那个错误。有没有安全修复这个错误的指南?

2019-08-07 13:16:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-07 13:16:01 0 [Note] InnoDB: Uses event mutexes
2019-08-07 13:16:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-07 13:16:01 0 [Note] InnoDB: Number of pools: 1
2019-08-07 13:16:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-07 13:16:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-07 13:16:01 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-07 13:16:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-07 13:16:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-07 13:16:01 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-07 13:16:01 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-07 13:16:01 0 [Note] InnoDB: Waiting for purge to start
2019-08-07 13:16:01 0 [Note] InnoDB: 10.3.16 started; log sequence number 1951328; transaction id 1068
2019-08-07 13:16:01 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-08-07 13:16:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-07 13:16:01 0 [Note] Server socket created on IP: '::'.
2019-08-07 13:16:01 0 [Note] InnoDB: Buffer pool(s) load completed at 190807 13:16:01

我得到以下错误在Windows事件

The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist in engine, Internal MariaDB error code: 1932

共2个答案

匿名用户

一个简单有效的解决方案是:

  1. 将数据库文件ibdata1和数据库文件夹从c:\xamp\mysql\data复制到安全位置作为备份
  2. 将所有网站文件从c:\xample\htdocs复制到安全位置作为备份
  3. 转到应用程序(MAC)或控制面板(Windows)并卸载当前的xampp版本
  4. 下载最新的xampp版本并安装
  5. 将文件复制回各自的位置
  6. 完成。您的应用程序应该恢复正常,工作正常。我希望这对某人有所帮助

匿名用户

如果你想要一个更快的

master-...@...@...@..@...
multi-...@...@...@..@...
mysql-relay-bin-...@...@...@..@...
relay-log-...@...@...@..@...

如果找到这些文件(不是标准的短表名,而是崩溃转储文件),请创建/backup文件夹

附录:7-24-2022如果MySQL在删除这些文件后无法启动,请也删除此文件:

multi-master.info

然后MySQL应该启动,并保持正常运行