Lucee 5.3.7.47 Error (database)
Message Error writing file '/tmp/#sql684_1d682e5_0.frm' (Errcode: 28 - No space left on device)
SQL CREATE TEMPORARY TABLE MyTemp1
(Select MTitolo AS Titolo, MSottotitolo AS Sottotitolo, MTesto AS Testo, MImmagine AS Immagine, MData AS LaData, MPagina AS Pagina, MCategoria AS Categoria, MSottocategoria AS Sottocategoria FROM More WHERE MIDJDominio = 3715 AND MKeywords LIKE '%Carciofi%')
UNION ALL
(Select NTitolo AS Titolo, NSottotitolo AS Sottotitolo, NTesto AS Testo, NImmagine AS Immagine, NData AS LaData, NPagina AS Pagina, NCategoria AS Categoria, NSottocategoria AS Sottocategoria FROM News WHERE NIDJDominio = 3715 AND NKeywords LIKE '%Carciofi%')
UNION ALL
(Select Pagine.Titolo, Pagine.Descrizione AS Sottotitolo, Testo, Immagine, DataRipubblicato AS LaData, NomePagina AS Pagina, Voce AS Categoria, Voce AS Sottocategoria FROM Pagine INNER JOIN Siti ON PIDJDominio=Siti.Id WHERE PIDJDominio = 3715 AND Keywords LIKE '%Carciofi%')
DatabaseName MySQL
DatabaseVersion 5.7.37-0ubuntu0.18.04.1
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.19 (Revision: a0ca826f5cdf51a98356fdfb1bf251eb042f80bf)
Datasource Navigare2009
Stacktrace The Error Occurred in
/var/www/Navigare2016/TemplateNavigare2016/11/archivio.cfm: line 88
86: UNION ALL
87: (Select Pagine.Titolo, Pagine.Descrizione AS Sottotitolo, Testo, Immagine, DataRipubblicato AS LaData, NomePagina AS Pagina, Voce AS Categoria, Voce AS Sottocategoria FROM Pagine INNER JOIN Siti ON PIDJDominio=Siti.Id WHERE PIDJDominio = #idsito# AND Keywords LIKE '%#URL.Tag#%')
88: </cfquery>
89: <cfquery name="Archivio" datasource="Navigare2009">
90: Select * FROM MyTemp1 ORDER BY LaData DESC LIMIT #numpagina#, 6

called from /var/www/Navigare2016/DietainformaIT/archivio.cfm: line 11
Java Stacktrace lucee.runtime.exp.DatabaseException: Error writing file '/tmp/#sql684_1d682e5_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.templatenavigare2016._11.archivio_cfm$cf.call(../TemplateNavigare2016/11/archivio.cfm:88)
  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 04:00:57 CET