0003914: database: 'INSERT isn't parsed properly

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0003914

[Resin]

major

always

02-25-10 04:44

03-26-10 14:59

Reporter

egemens

View Status

public

Assigned To

ferg

Priority

normal

Resolution

unable to reproduce

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

4.0.6

Product Version

4.0.2

Product Build

Summary

0003914: database: 'INSERT isn't parsed properly

Description

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

Steps To Reproduce

Additional Information

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.

Attached Files

Relationships

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.

Issue History
Date Modified	Username	Field	Change
02-25-10 04:44	egemens	New Issue
03-01-10 15:43	emil	Note Added: 0004450
03-05-10 15:59	ferg	Summary	resin-admin exception => database: 'INSERT isn't parsed properly
03-26-10 14:59	ferg	Note Added: 0004492
03-26-10 14:59	ferg	Assigned To	=> ferg
03-26-10 14:59	ferg	Status	new => closed
03-26-10 14:59	ferg	Resolution	open => unable to reproduce
03-26-10 14:59	ferg	Fixed in Version	=> 4.0.6

Mantis 1.0.0rc3[^]

32 total queries executed.
28 unique queries executed.