首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >超出了MariaDB/MySQL资源限制

问超出了MariaDB/MySQL资源限制
EN

Stack Overflow用户
提问于 2016-04-12 23:13:48
回答 1查看 7.5K关注 0票数 0

我正在尝试连接到安装在我的CentOS 7上的MariaDB/Mysql,并在尝试使用mysql -u root -p连接时得到以下错误:mysql -u root -p。

错误2002 (HY000):无法通过套接字'/var/lib/ MySQL /mysql.sock‘(111)连接到本地mysql服务器

我已经尝试通过指定IP地址来连接到它,而不是使用localhost,但是我得到了相同的错误。

当我试图获得MariaDB状态时,我得到以下消息(/bin/systemctl status mariadb.service):

已加载的mariadb.service - MariaDB数据库服务器:已加载(/usr/lib/systemd/system/maradb.service;已启用;供应商预置:禁用)活动:失败(结果:资源)

启动它会产生以下错误(/bin/systemctl start mariadb.service):

由于超出了配置的资源限制,mariadb.service的作业失败。有关详细信息,请参阅"systemctl status mariadb.service“和"journalctl -xe”。

我还查看了位于/var/log/mariadb/maradb.log的日志。

代码语言:javascript
复制
160408 12:21:00 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
160408 16:11:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160408 16:11:01 [Note] /usr/libexec/mysqld (mysqld 5.5.47-MariaDB) starting as process 3054 ...
160408 16:11:02 InnoDB: The InnoDB memory heap is disabled
160408 16:11:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160408 16:11:02 InnoDB: Compressed tables use zlib 1.2.7
160408 16:11:02 InnoDB: Using Linux native AIO
160408 16:11:02 InnoDB: Initializing buffer pool, size = 128.0M
160408 16:11:02 InnoDB: Completed initialization of buffer pool
160408 16:11:02 InnoDB: highest supported file format is Barracuda.
160408 16:11:04  InnoDB: Waiting for the background threads to start
160408 16:11:05 Percona XtraDB (http://www.percona.com) 5.5.46-MariaDB-37.6 started; log sequence number 54018416776
160408 16:11:06 [Note] Plugin 'FEEDBACK' is disabled.
160408 16:11:07 [Note] Server socket created on IP: '0.0.0.0'.
160408 16:11:07 [Note] Event Scheduler: Loaded 0 events
160408 16:11:07 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.47-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306 MariaDB Server
160409  6:26:06  InnoDB: Error: Write to file ./ibdata1 failed at offset 9 615514112.
InnoDB: 1048576 bytes should have been written, only 585728 were written.
InnoDB: Operating system error number 28.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
160409  6:26:06  InnoDB: Assertion failure in thread 140463216400128 in file os0file.c line 4377

有人对如何纠正这个错误有什么想法吗?

谢谢您:)

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2016-04-13 22:25:54

代码语言:javascript
复制
> perror 28
OS error code  28:  No space left on device

我还需要再说几句吗?

票数 5
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/36585745

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档