SQL state [HY000]; Error code [3]; Problem analysis

The workflow form uses Freemarker technology to bind the form to the background database, and each modification of the form definition will perform an ALTER operation on the database corresponding to the form. Today, the test system reports the following error when performing a save form definition operation:

HTTP Status 500-statementcallback; Uncategorized SQLException for SQL [ALTER TABLEt_dymc_20140522141004 Change f_xqdbm f_xqdbm VARCHAR (COMMENT ' demand single code ';]; SQL state [HY000]; error code [3];Error writing file './oa_dev_test/#sql -131a6_41120.frm' (errcode:28); nested exception is java.sql.SQLException:Error writing file './oa_dev_test/#sql -131a6_41120.frm ' /c3>(errcode:28)
Type Exception report
message statementcallback; Uncategorized SQLException for SQL [ALTER TABLE t_dymc_20140522141004 Change f_xqdbm f_xqd BM VARCHAR (COMMENT) ' demand single code '; SQL state [HY000]; Error code [3]; Error writing file './oa_dev_test/#sql -131a6_41120.frm ' (errcode:28); Nested exception is java.sql.SQLException:Error writing file './oa_dev_test/#sql -131a6_41120.frm ' (errcode:28)
Description The server encountered an internal error that prevented it from fulfilling this request.
Exception
org.springframework.jdbc.UncategorizedSQLException:StatementCallback; Uncategorized SQLException for SQL [ALTER TABLE t_dymc_20140522141004 Change f_xqdbm f_xqdbm VARCHAR (COMMENT ' demand single code ';]; SQL state [HY000]; Error code [3]; Error writing file './oa_dev_test/#sql -131a6_41120.frm ' (errcode:28); Nested exception is java.sql.SQLException:Error writing file './oa_dev_test/#sql -131a6_41120.frm ' (errcode:28)
Org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate ( abstractfallbacksqlexceptiontranslator.java:83)
Org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate ( ABSTRACTFALLBACKSQLEXCEPTIONTRANSLATOR.JAVA:80)
Org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate ( ABSTRACTFALLBACKSQLEXCEPTIONTRANSLATOR.JAVA:80)
Org.springframework.jdbc.core.JdbcTemplate.execute (jdbctemplate.java:407)
Org.springframework.jdbc.core.JdbcTemplate.execute (jdbctemplate.java:428)
Com.gaochao.oa.module.bpm.dymcform.server.service.impl.MysqlTableOperatorService.newUpdateColumn ( mysqltableoperatorservice.java:280)

The following keywords are related to the above errors:

1.ALTER TABLE, that is, perform table structure modification operations;

2. : After MySQL is installed in the Data folder -RW-RW---- 1 MYSQL MYSQL 14506 AUG 23 2014 T_SYS_SETINTERFACE.FRM

3.SQL State [HY000]; error code [3];

4.errcode:28

Check the MySQL database exception code (error codes) to obtain error code [3] the system could not find the corresponding path; errcode:28 is related to insufficient storage space

after the DBA confirmed that the test database storage space is insufficient, after finishing, no longer reported the above error .

Gaochao
DBA, are you there?
SQL state [HY000]; error code [3]; Error writing file './oa_dev_test/#sql -131a6_41120.frm ' (errcode:28)
10:27 Lee DBA
Yes, what do you mean?
I don't know, uh.
Test the library.
10:28gaochao
Yes
I looked it up on the internet, the wrong meaning.
The system could not find the specified path
Code Error Message
0 operation completed successfully.
1 functional error.
2 The system cannot find the file specified.
3 The system could not find the path specified.
4 The system cannot open the file.
What file is the file that ends with frm
What's your extension number?
10:38 Lee DBA
83***
files in frm format in the database
A table corresponds to a name
-RW-RW----1 MySQL mysql 14506 t_sys_setinterface.frm
-RW-RW----1 MySQL mysql 8688 t_sys_setportal.frm
-RW-RW----1 MySQL mysql 14552 t_sys_sysinfo.frm
-RW-RW----1 MySQL mysql 9070 t_sys_tabledependence.frm
-RW-RW----1 MySQL mysql 13497 t_sys_taskcenter.frm
-RW-RW----1 MySQL mysql 8594 Jan 6 11:01 t_sys_test.frm
-RW-RW----1 MySQL mysql 22051 t_sys_unit.frm
-RW-RW----1 mysql mysql 13006 Feb 3 13:51 t_sys_usercodepool.frm
-RW-RW----1 MySQL mysql 8660 t_sys_userdatarule.frm
-RW-RW----1 MySQL mysql 14600 t_sys_userext.frm
-RW-RW----1 mysql mysql 23523 Nov 11:36 t_sys_user.frm
-RW-RW----1 MySQL mysql 13265 t_sys_usergroup.frm
-RW-RW----1 MySQL mysql 8900 t_sys_userrole.frm
-RW-RW----1 MySQL mysql 1539 Jan 14:19 t_sys_user. TRG
-RW-RW----1 MySQL mysql 8644 t_sys_weather.frm
Similar to this
I just checked, and there's no such file sql-131a6_41120.frm.
10:42gaochao
That's not a temp file.
10:45gaochao
Dba
10:48gaochao
t_dymc_20140522141004
10:50 Lee DBA
-RW-RW----1 mysql mysql 16059 Jan 14:22 t_dymc_20140522141004.frm
There's a definition for this table.
I don't know if that sql-131a6_41120.frm is a file.
Temporary Files
10:53gaochao
the wrong side of the report, is also said to find the path of the file, that is, Errorcode:3
10:53 Lee DBA
Yes, I'll see.
10:54gaochao
I just tested it.Modify the table structure of the same table the name of this file is the same, the different tables are different
10:54 Lee DBA
Well
10:58 Lee DBA
You try it again.
11:02 Lee DBA
Are you ready?
11:07gaochao
What have you changed?
It's not a reboot.
11:07 Lee DBA
No, disk space is gone.
Freed up some space.
11:07gaochao
Yes, OK.
3ks

This article is from the "South Lake Miner Technology Space" blog, please be sure to keep this source http://jncumter.blog.51cto.com/812546/1615708

SQL state [HY000]; Error code [3]; Problem analysis