{"id":1405,"date":"2016-10-31T14:12:54","date_gmt":"2016-10-31T06:12:54","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1405"},"modified":"2025-01-06T15:16:04","modified_gmt":"2025-01-06T07:16:04","slug":"mysql-error-1878%e6%8a%a5%e9%94%99%e8%a7%a3%e5%86%b3%e5%8a%9e%e6%b3%95","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/mysql-error-1878%e6%8a%a5%e9%94%99%e8%a7%a3%e5%86%b3%e5%8a%9e%e6%b3%95\/","title":{"rendered":"MySQL ERROR 1878\u62a5\u9519\u89e3\u51b3\u529e\u6cd5"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

MySQL ERROR 1878\u62a5\u9519\u89e3\u51b3\u529e\u6cd5<\/h2>\n\n\n\n

\u9519\u8bef\u91cd\u73b0<\/h3>\n\n\n\n

Part1:<\/strong>\u5927\u8868\u4fee\u6539\u5b57\u6bb5<\/strong><\/p>\n\n\n\n

mysql> ALTER TABLE `erp`<\/p>\n\n\n\n

    -> ADD COLUMN `eas_status`  tinyint(3) unsigned  NOT NULL DEFAULT 0 ‘ AFTER `totalprice`;<\/p>\n\n\n\n

ERROR 1878 (HY000): Temporary file write failure.<\/p>\n\n\n\n

mysql> \\q<\/p>\n\n\n\n

\u8fd9\u91cc\u53ef\u4ee5\u770b\u5230\uff0c\u6dfb\u52a0\u5b57\u6bb5\u7684\u65f6\u5019\u7206\u51fa\u4e861878\u9519\u8bef\u3002<\/p>\n\n\n\n

Part2:<\/strong>\u6392\u9519\u8fc7\u7a0b<\/strong><\/p>\n\n\n\n

\u5148\u770b\u6570\u636e\u5e93\u7684error<\/span>\u65e5\u5fd7<\/span><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n<\/td>\n
\n
\n
2016-10-27 10:19:22 7f5dca1bf700 InnoDB: Error: Write to <\/code>file<\/code> (merge) failed at offset 258998272.<\/code><\/div>\n
InnoDB: 1048576 bytes should have been written, only 651264 were written.<\/code><\/div>\n
InnoDB: Operating system error number 0.<\/code><\/div>\n
InnoDB: Check that your OS and <\/code>file<\/code> system support files of this size.<\/code><\/div>\n
InnoDB: Check also that the disk is not full or a disk <\/code>quota<\/code> exceeded.<\/code><\/div>\n
InnoDB: Error number 0 means <\/code>'Success'<\/code>.<\/code><\/div>\n
InnoDB: Some operating system error numbers are described at<\/code><\/div>\n
InnoDB: http:<\/code>\/\/dev<\/code>.mysql.com<\/code>\/doc\/refman\/5<\/code>.6<\/code>\/en\/operating-system-error-codes<\/code>.html<\/code><\/div>\n
2016-10-27 10:35:34 7f5dcb42f700 InnoDB: Error: Write to <\/code>file<\/code> (merge) failed at offset 88080384.<\/code><\/div>\n
InnoDB: 1048576 bytes should have been written, only 782336 were written.<\/code><\/div>\n
InnoDB: Operating system error number 0.<\/code><\/div>\n
InnoDB: Check that your OS and <\/code>file<\/code> system support files of this size.<\/code><\/div>\n
InnoDB: Check also that the disk is not full or a disk <\/code>quota<\/code> exceeded.<\/code><\/div>\n
InnoDB: Error number 0 means <\/code>'Success'<\/code>.<\/code><\/div>\n
InnoDB: Some operating system error numbers are described at<\/code><\/div>\n
InnoDB: http:<\/code>\/\/dev<\/code>.mysql.com<\/code>\/doc\/refman\/5<\/code>.6<\/code>\/en\/operating-system-error-codes<\/code>.html<\/code><\/div>\n
2016-10-27 10:37:02 7f5dd0076700 InnoDB: Error: Write to <\/code>file<\/code> (merge) failed at offset 88080384.<\/code><\/div>\n
InnoDB: 1048576 bytes should have been written, only 770048 were written.<\/code><\/div>\n
InnoDB: Operating system error number 0.<\/code><\/div>\n
InnoDB: Check that your OS and <\/code>file<\/code> system support files of this size.<\/code><\/div>\n
InnoDB: Check also that the disk is not full or a disk <\/code>quota<\/code> exceeded.<\/code><\/div>\n
InnoDB: Error number 0 means <\/code>'Success'<\/code>.<\/code><\/div>\n
InnoDB: Some operating system error numbers are described at<\/code><\/div>\n
InnoDB: http:<\/code>\/\/dev<\/code>.mysql.com<\/code>\/doc\/refman\/5<\/code>.6<\/code>\/en\/operating-system-error-codes<\/code>.html<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

\u67e5\u770b\u9519\u8bef\u65e5\u5fd7\u53ef\u4ee5\u770b\u5230\u78c1\u76d8\u7a7a\u95f4\u4e0d\u8db3<\/p>\n\n\n\n

Part3:\u9a8c\u8bc1<\/strong><\/p>\n\n\n\n

[root@dev1 helei]# df -h<\/p>\n\n\n\n

Filesystem            Size  Used Avail Use% Mounted on<\/p>\n\n\n\n

\/dev\/mapper\/VolGroup-lv_root<\/p>\n\n\n\n

                       45G   43G  160M 100% \/<\/p>\n\n\n\n

tmpfs                 7.9G  1.2M  7.9G   1% \/dev\/shm<\/p>\n\n\n\n

\/dev\/sda1             477M   90M  358M  21% \/boot<\/p>\n\n\n\n

\u53ef\u4ee5\u770b\u5230\u78c1\u76d8\u7a7a\u95f4\u4e0d\u591f\u4e86\uff0c\u9700\u8981\u91ca\u653e\u78c1\u76d8\u7a7a\u95f4\uff0c<\/p>\n\n\n\n

 <\/p>\n\n\n\n

\u2014\u2014\u603b\u7ed3<\/strong>\u2014\u2014<\/strong><\/p>\n\n\n\n

\u539f\u56e0\u662fmysql\u7684tmpdir\u5206\u533a\u7684\u5269\u4f59\u7a7a\u95f4\u5927\u5c0f\u6ca1\u6709<\/span>erp<\/span>\u5927\u3002<\/span> mysql<\/span>\u5728<\/span>alter table<\/span>\u65f6\u9700\u8981\u7684\u4e34\u65f6\u7a7a\u95f4\u8981\u6bd4\u8be5\u8868\u624d\u884c\u3002<\/span>\u7531\u4e8e\u7b14\u8005\u7684\u6c34\u5e73\u6709\u9650\uff0c\u7f16\u5199\u65f6\u95f4\u4e5f\u5f88\u4ed3\u4fc3\uff0c\u6587\u4e2d\u96be\u514d\u4f1a\u51fa\u73b0\u4e00\u4e9b\u9519\u8bef\u6216\u8005\u4e0d\u51c6\u786e\u7684\u5730\u65b9\uff0c\u4e0d\u59a5\u4e4b\u5904\u6073\u8bf7\u8bfb\u8005\u6279\u8bc4\u6307\u6b63\u3002<\/strong><\/strong><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL ERROR 1878\u62a5\u9519\u89e3\u51b3\u529e\u6cd5 \u9519\u8bef\u91cd\u73b0 Part1:\u5927\u8868\u4fee\u6539\u5b57\u6bb5 mysql> ALTE … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[458,45],"class_list":["post-1405","post","type-post","status-publish","format-standard","hentry","category-shujuku","tag-error","tag-mysql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1405"}],"version-history":[{"count":2,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1405\/revisions"}],"predecessor-version":[{"id":8886,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1405\/revisions\/8886"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}