Mantis - Resin
Viewing Issue Advanced Details
3914 major always 02-25-10 04:44 03-26-10 14:59
egemens  
ferg  
normal  
closed 4.0.2  
unable to reproduce  
none    
none 4.0.6  
0003914: database: 'INSERT isn't parsed properly
I received the following error after resin-admin login



com.caucho.db.sql.SQLParseException: unknown query at `'INSERT''
    at com.caucho.db.sql.Parser.parse(Parser.java:198)
    at com.caucho.db.sql.Parser.parse(Parser.java:147)
    at com.caucho.db.Database.parseQuery(Database.java:305)
    at com.caucho.db.jdbc.ConnectionImpl.prepareStatementImpl(ConnectionImpl.java:331)
    at com.caucho.db.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:271)
    at com.caucho.server.distcache.DataStore$DataConnection.prepareInsert(DataStore.java:764)
    at com.caucho.server.distcache.DataStore.insert(DataStore.java:368)
    at com.caucho.server.distcache.DataStore.save(DataStore.java:344)
    at com.caucho.server.distcache.AbstractDataCacheManager.writeData(AbstractDataCacheManager.java:922)
    at com.caucho.server.distcache.AbstractDataCacheManager.put(AbstractDataCacheManager.java:371)
    at com.caucho.server.distcache.AbstractDataCacheManager.put(AbstractDataCacheManager.java:350)
    at com.caucho.server.distcache.ProCacheEntry.put(ProCacheEntry.java:125)
    at com.caucho.distcache.AbstractCache.put(AbstractCache.java:479)
    at com.caucho.security.ClusterSingleSignon.put(ClusterSingleSignon.java:97)
    at com.caucho.security.AbstractLogin.saveUser(AbstractLogin.java:367)
    at com.caucho.security.AbstractLogin.login(AbstractLogin.java:299)
    at com.caucho.server.security.FormLoginServlet.service(FormLoginServlet.java:69)
    at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:112)
    at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:183)
    at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:169)
    at com.caucho.server.webapp.AccessLogFilterChain.doFilter(AccessLogFilterChain.java:103)
    at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:290)
    at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:784)
    at com.caucho.server.port.TcpConnection.handleRequestsImpl(TcpConnection.java:619)
    at com.caucho.server.port.TcpConnection.handleRequests(TcpConnection.java:556)
    at com.caucho.server.port.TcpConnection$KeepaliveRequestTask.doTask(TcpConnection.java:1250)
    at com.caucho.server.port.TcpConnection$ConnectionReadTask.runThread(TcpConnection.java:1127)
    at com.caucho.server.port.TcpConnection$KeepaliveRequestTask.run(TcpConnection.java:1235)
    at com.caucho.util.ThreadPool$PoolThread.runTasks(ThreadPool.java:901)
    at com.caucho.util.ThreadPool$PoolThread.run(ThreadPool.java:866)
[14:03:28.721] {http--80-28} DataStore[resin_data_default] can't save data 'HashKey[ece99539]'
[14:03:28.722] {http--80-28} java.lang.RuntimeException: java.lang.IllegalStateException: Can't save the data 'HashKey[ece99539]'
[14:03:28.722] {http--80-28} at com.caucho.server.distcache.AbstractDataCacheManager.writeData(AbstractDataCacheManager.java:929)
[14:03:28.722] {http--80-28} at com.caucho.server.distcache.AbstractDataCacheManager.put(AbstractDataCacheManager.java:371)
[14:03:28.722] {http--80-28} at com.caucho.server.distcache.AbstractDataCacheManager.put(AbstractDataCacheManager.java:350)
[14:03:28.722] {http--80-28} at com.caucho.server.distcache.ProCacheEntry.put(ProCacheEntry.java:125)
[14:03:28.722] {http--80-28} at com.caucho.distcache.AbstractCache.put(AbstractCache.java:479)
[14:03:28.722] {http--80-28} at com.caucho.security.ClusterSingleSignon.put(ClusterSingleSignon.java:97)
[14:03:28.722] {http--80-28} at com.caucho.security.AbstractLogin.saveUser(AbstractLogin.java:367)
[14:03:28.722] {http--80-28} at com.caucho.security.AbstractLogin.login(AbstractLogin.java:299)
[14:03:28.722] {http--80-28} at com.caucho.server.security.FormLoginServlet.service(FormLoginServlet.java:69)
[14:03:28.722] {http--80-28} at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:112)
[14:03:28.722] {http--80-28} at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:183)
[14:03:28.722] {http--80-28} at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:169)
[14:03:28.722] {http--80-28} at com.caucho.server.webapp.AccessLogFilterChain.doFilter(AccessLogFilterChain.java:103)
[14:03:28.722] {http--80-28} at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:290)
[14:03:28.722] {http--80-28} at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:784)
[14:03:28.722] {http--80-28} at com.caucho.server.port.TcpConnection.handleRequestsImpl(TcpConnection.java:619)
[14:03:28.722] {http--80-28} at com.caucho.server.port.TcpConnection.handleRequests(TcpConnection.java:556)
[14:03:28.722] {http--80-28} at com.caucho.server.port.TcpConnection$KeepaliveRequestTask.doTask(TcpConnection.java:1250)
[14:03:28.722] {http--80-28} at com.caucho.server.port.TcpConnection$ConnectionReadTask.runThread(TcpConnection.java:1127)
[14:03:28.722] {http--80-28} at com.caucho.server.port.TcpConnection$KeepaliveRequestTask.run(TcpConnection.java:1235)
[14:03:28.722] {http--80-28} at com.caucho.util.ThreadPool$PoolThread.runTasks(ThreadPool.java:901)
[14:03:28.722] {http--80-28} at com.caucho.util.ThreadPool$PoolThread.run(ThreadPool.java:866)
[14:03:28.722] {http--80-28} Caused by: java.lang.IllegalStateException: Can't save the data 'HashKey[ece99539]'
[14:03:28.722] {http--80-28} at com.caucho.server.distcache.AbstractDataCacheManager.writeData(AbstractDataCacheManager.java:923)
[14:03:28.722] {http--80-28} ... 21 more


Resin Professional 4.0.2

Centos 5.4
Linux 2.6.18-164.11.1.el5 amd64

OpenJDK Runtime Environment 1.6.0-b09, UTF-8, en
OpenJDK 64-Bit Server VM 1.6.0-b09, 64, mixed mode, Sun Microsystems Inc.

Notes
(0004450)
emil   
03-01-10 15:43   
Issue remains in 4.0.4
(0004492)
ferg   
03-26-10 14:59   
Unable to reproduce in 4.0.6. If the issue persists, please open a new bug, set logging level="finer" and post the relevant log.