Railo 4.2.1.008 Error (database)
Message
Detail Got error 28 from storage engine
SQL

SELECT website_post.*, website_image.*, website_channel.slug as "channel_slug"

FROM website_post, website_channel, website_image

WHERE

website_post.channel_id = website_channel.id AND
website_post.main_image_id = website_image.id AND
website_post.date_available < now() AND
website_post.published = 1

ORDER BY website_post.ID DESC

LIMIT 300 ;

DatabaseName MySQL
DatabaseVersion 5.5.29-0ubuntu0.12.04.1-log
DriverName MySQL-AB JDBC Driver
DriverVersion mysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasource cmscaras
Stacktrace The Error Occurred in
/opt/railo.new/webapps/novoportal/controller.cfm: line 302
300: website_post.channel_id = website_channel.id AND
301: website_post.main_image_id = website_image.id AND
302: website_post.date_available < now() AND
303: website_post.published = 1
304:

Java Stacktrace
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073):1073
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096):4096
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028):4028
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490):2490
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651):2651
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677):2677
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627):2627
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:841):841
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681):681
  at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19
  at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25
  at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:214):214
  at railo.runtime.type.QueryImpl.(QueryImpl.java:224):224
  at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687
  at railo.runtime.tag.Query.doEndTag(Query.java:531):531
  at controller_cfm$cf.call(/opt/railo.new/webapps/novoportal/controller.cfm:302):302
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:39):39
  at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:790):790
  at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738):738
  at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:551):551
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143):143
  at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568):568
  at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221):221
  at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111):1111
  at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478):478
  at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183):183
  at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045):1045
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141):141
  at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199):199
  at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109):109
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97):97
  at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:309):309
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97):97
  at org.eclipse.jetty.server.Server.handle(Server.java:462):462
  at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279):279
  at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232):232
  at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534):534
  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607):607
  at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536):536
  at java.lang.Thread.run(Thread.java:745):745
 
Timestamp 5/29/16 6:05:49 AM BRT