Lucee 5.3.7.47 Error (database)
Message Error writing file '/tmp/#sql684_1d6bcfc_0.frm' (Errcode: 28 - No space left on device)
SQL CREATE TEMPORARY TABLE MyTemp1
Select CPTitolo AS Titolo, CPSottotitolo AS Sottotitolo, CPTesto AS Testo, CPImmagine AS Immagine, CPData AS LaData, CPNomePagina AS Pagina, CPCategoria AS Categoria, CPSottocategoria AS Sottocategoria FROM ContenutiPortali WHERE CPIDJ = 150 AND (CPTipo = 3 OR CPTipo = 2) AND (CPCategoria = 'Tesoro' OR CPSottocategoria = 'Tesoro')
DatabaseName MySQL
DatabaseVersion 5.7.37-0ubuntu0.18.04.1
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.19 (Revision: a0ca826f5cdf51a98356fdfb1bf251eb042f80bf)
Datasource Portali2016
Stacktrace The Error Occurred in
/var/www/Portali2016/TemplatePortali2016/3/archivio.cfm: line 40
38: CREATE TEMPORARY TABLE MyTemp1
39: Select CPTitolo AS Titolo, CPSottotitolo AS Sottotitolo, CPTesto AS Testo, CPImmagine AS Immagine, CPData AS LaData, CPNomePagina AS Pagina, CPCategoria AS Categoria, CPSottocategoria AS Sottocategoria FROM ContenutiPortali WHERE CPIDJ = #idsito# AND (CPTipo = 3 OR CPTipo = 2) AND (CPCategoria = '#URL.Categoria#' OR CPSottocategoria = '#URL.Categoria#')
40: </cfquery>
41: <cfquery name="Archivio" datasource="Portali2016">
42: Select * FROM MyTemp1 ORDER BY LaData DESC LIMIT #numpagina#, 6

called from /var/www/Portali2016/ClipperIT/archivio.cfm: line 11
Java Stacktrace lucee.runtime.exp.DatabaseException: Error writing file '/tmp/#sql684_1d6bcfc_0.frm' (Errcode: 28 - No space left on device)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
  at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:319)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:227)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1112)
  at lucee.runtime.tag.Query._doEndTag(Query.java:686)
  at lucee.runtime.tag.Query.doEndTag(Query.java:553)
  at __138.templateportali2016._3.archivio_cfm$cf.call(../TemplatePortali2016/3/archivio.cfm:40)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
  at archivio_cfm$cf.call(/archivio.cfm:11)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:904)
  at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:961)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
  at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.base/java.lang.Thread.run(Thread.java:834)
 
Timestamp 19/03/24 12:12:26 CET