0003914: database: 'INSERT isn't parsed properly

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

Status

closed

Product Version

4.0.2

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

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.