Lucee 5.3.7.47 Error (database)
Message Error writing file '/tmp/#sql684_1d68312_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 = 1152 )
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 = 1152 )
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 = 1152 )
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 67
65: UNION ALL
66: (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# <cfif isDefined("FORM.ricerca")>AND (Pagine.Titolo like '%#FORM.ricerca#%' OR Pagine.Descrizione like '%#FORM.ricerca#%' OR Testo like '%#FORM.ricerca#%' OR Voce like '%#FORM.ricerca#%')</cfif>)
67: </cfquery>
68: <cfquery name="Archivio" datasource="Navigare2009">
69: Select * FROM MyTemp1 ORDER BY LaData DESC LIMIT #numpagina#, 6

called from /var/www/Navigare2016/TuttoLingueIT/archivio.cfm: line 11
Java Stacktrace lucee.runtime.exp.DatabaseException: Error writing file '/tmp/#sql684_1d68312_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$exb.call(../TemplateNavigare2016/11/archivio.cfm:67)
  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$exa.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:02:39 CET