Cannot Reproduce
Details
Assignee
Michael OffnerMichael OffnerReporter
Geoff BowersGeoff BowersPriority
BlockerNew Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Details
Details
Assignee
Michael Offner
Michael OffnerReporter
Geoff Bowers
Geoff BowersPriority
BlockerNew Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Created 9 October 2015 at 04:26
Updated 10 August 2023 at 07:59
Resolved 25 November 2015 at 12:22
Error:
Can't create/write to file '/tmp/#sql_39d_0.MYI' (Errcode: 2 - No such file or directory)Sample code:
<cfset var qColumns = "" /> <cfdbinfo datasource="#this.dsn#" type="columns" table="#arguments.tablename#" name="qColumns" /> <cfreturn qColumns />Full stack trace:
lucee.runtime.exp.DatabaseException: Can't create/write to file '/tmp/#sql_39d_0.MYI' (Errcode: 2 - No such file or directory) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1556) at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2531) at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:51) at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2405) at lucee.runtime.tag.DBInfo.typeColumns(DBInfo.java:305) at lucee.runtime.tag.DBInfo.doStartTag(DBInfo.java:261) at core.packages.dbgateways.mysqlgateway_cfc$cf.udfCall1(/var/www/farcry/core/packages/dbgateways/MySQLGateway.cfc:356) at core.packages.dbgateways.mysqlgateway_cfc$cf.udfCall(/var/www/farcry/core/packages/dbgateways/MySQLGateway.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:336) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:222) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:751) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1582) at core.packages.dbgateways.mysqlgateway_cfc$cf.udfCall2(/var/www/farcry/core/packages/dbgateways/MySQLGateway.cfc:453) at core.packages.dbgateways.mysqlgateway_cfc$cf.udfCall(/var/www/farcry/core/packages/dbgateways/MySQLGateway.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:336) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:222) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:751) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1582) at core.packages.dbgateways.mysqlgateway_cfc$cf.udfCall2(/var/www/farcry/core/packages/dbgateways/MySQLGateway.cfc:542) at core.packages.dbgateways.mysqlgateway_cfc$cf.udfCall(/var/www/farcry/core/packages/dbgateways/MySQLGateway.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:336) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:222) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:691) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:574) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1890) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:751) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1582) at core.packages.types.farrole_cfc$cf.udfCall2(/var/www/farcry/core/packages/types/farRole.cfc:795) at core.packages.types.farrole_cfc$cf.udfCall(/var/www/farcry/core/packages/types/farRole.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:336) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:222) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:691) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:574) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1890) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:751) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1582) at core.tags.farcry._farcryapplicationinit_cfm$cf.call(/var/www/farcry/core/tags/farcry/_farcryApplicationInit.cfm:277) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:910) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:826) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:821) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812) at core.application_cfc$cf.udfCall1(/var/www/farcry/core/Application.cfc:315) at core.application_cfc$cf.udfCall(/var/www/farcry/core/Application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:336) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:208) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:582) at lucee.runtime.SuperComponent.callWithNamedValues(SuperComponent.java:92) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:792) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1592) at application_cfc$cf.udfCall(/var/www/farcry/projects/chelsea/www/Application.cfc:5) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:336) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:222) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:691) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:574) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1890) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:422) at lucee.runtime.listener.ModernAppListener.onApplicationStart(ModernAppListener.java:300) at lucee.runtime.PageContextImpl.initApplicationContext(PageContextImpl.java:2828) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:120) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2258) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2250) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2218) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:595) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:103) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)