程序在大量进行mysql操作时,偶尔会遇到类似这样的异常:“Can't open file: './etl/etl_portal_offline_20160316.frm' (errno: 24”
016-03-17 02:30:14.011 INFO com.maipu.analyse.plugins.AbstractAnalyzer.excuteUpdateSql(AbstractAnalyzer.java:229)
- <ExcuteUpdateSql success inffect row10000 use 2084 sql=DELETE FROM A_RegistUserStatEveryWeek WHERE stat_week=1458403200000>
2016-03-17 02:30:15.791 ERROR com.maipu.analyse.plugins.AbstractAnalyzer.excuteSelectSql(AbstractAnalyzer.java:323) - <ExcuteSelectSql
exception for sql SELECT id,user,online_time,occurence_time_milli,group_code,user_mac,user_ip FROM etl.ETL_PORTAL_OFFLINE_20160316 limit
0, 10000>
java.sql.SQLException: Can't open file: './etl/etl_portal_offline_20160316.frm' (errno: 24)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2799)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2139)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2306)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.maipu.analyse.plugins.AbstractAnalyzer.excuteSelectSql(AbstractAnalyzer.java:303)
at com.maipu.analyse.plugins.userActionAnalyzer.UserActionAnalyzer.beginAnalyse(UserActionAnalyzer.java:160)
at com.maipu.analyse.service.AnalyzerRunTask.call(AnalyzerRunTask.java:93)
at com.maipu.analyse.service.AnalyzerRunTask.call(AnalyzerRunTask.java:31)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2016-03-17 02:30:15.844 INFO com.maipu.analyse.plugins.userActionAnalyzer.UserActionAnalyzer.beginAnalyse(UserActionAnalyzer.java:190) - <success
read 0 row from logTable>
cat /etc/security/limits.conf
* soft nofile 65535
* hard nofile 65535
open_files_limit=65535