Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0001470 [Resin] minor always 11-21-06 15:49 11-30-06 12:28
Reporter ferg View Status public  
Assigned To ferg
Priority normal Resolution fixed  
Status closed   Product Version 3.0.22
Summary 0001470: jdbcstore insert issue
Description (rep by Shane Cruz)

We are seeing problems with the JdbcStore with Resin Pro 3.0.22. It has always worked fine with previous versions, but we are seeing the following exception when we use the <save-mode>before-headers</save-mode> session configuration:
 
[18:54:33.814] com.caucho.log.EnvironmentLogger.log java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry 'www.mysite.edu_08080__MyApp;abcddb_nINlOW6ispYh' for key 1"
[18:54:33.814] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
[18:54:33.814] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
[18:54:33.814] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
[18:54:33.814] at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
[18:54:33.814] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1772)
[18:54:33.814] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1619)
[18:54:33.814] at com.caucho.sql.UserPreparedStatement.executeUpdate(UserPreparedStatement.java:117)
[18:54:33.814] at com.caucho.sql.UserPreparedStatement.executeUpdate(UserPreparedStatement.java:117)
[18:54:33.814] at com.caucho.server.cluster.JdbcStore.store(JdbcStore.java:335)
[18:54:33.814] at com.caucho.server.cluster.ClusterObject.store(ClusterObject.java:411)
[18:54:33.814] at com.caucho.server.session.SessionImpl.save(SessionImpl.java:861)
[18:54:33.814] at com.caucho.server.session.SessionImpl.saveBeforeHeaders(SessionImpl.java:838)
[18:54:33.814] at com.caucho.server.connection.AbstractHttpResponse.writeHeaders(AbstractHttpResponse.java:1558)
[18:54:33.814] at com.caucho.server.connection.ResponseStream.writeHeaders(ResponseStream.java:216)
[18:54:33.814] at com.caucho.server.connection.ResponseStream.writeNext(ResponseStream.java:401)
[18:54:33.814] at com.caucho.server.connection.ToByteResponseStream.flushByteBuffer(ToByteResponseStream.java:518)
[18:54:33.814] at com.caucho.server.connection.ToByteResponseStream.flushBuffer(ToByteResponseStream.java:424)
[18:54:33.814] at com.caucho.server.connection.ResponseStream.finish(ResponseStream.java:664)
[18:54:33.814] at com.caucho.server.connection.AbstractHttpResponse.finish(AbstractHttpResponse.java:1958)
[18:54:33.814] at com.caucho.server.connection.AbstractHttpResponse.finish(AbstractHttpResponse.java:1927)
[18:54:33.814] at com.caucho.server.connection.AbstractHttpResponse.sendError(AbstractHttpResponse.java:482)
[18:54:33.814] at com.caucho.server.connection.AbstractHttpResponse.sendError(AbstractHttpResponse.java:440)
[18:54:33.814] at com.caucho.servlets.FileServlet.service(FileServlet.java:267)
[18:54:33.814] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
[18:54:33.814] at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:209)
[18:54:33.814] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
[18:54:33.814] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[18:54:33.814] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[18:54:33.814] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[18:54:33.814] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[18:54:33.814] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[18:54:33.814] at java.lang.Thread.run(Thread.java:595)
 
If I remove the save-mode configuration, we get a slightly different stack trace:
 
[14:46:55.236] com.caucho.log.EnvironmentLogger.log java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry 'www.mysite.edu_08080__MyApp;abcDSulG1TIm8gwmOdm' for key 1"
[14:46:55.236] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
[14:46:55.236] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
[14:46:55.236] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
[14:46:55.236] at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
[14:46:55.236] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1772)
[14:46:55.236] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1619)
[14:46:55.236] at com.caucho.sql.UserPreparedStatement.executeUpdate(UserPreparedStatement.java:117)
[14:46:55.236] at com.caucho.sql.UserPreparedStatement.executeUpdate(UserPreparedStatement.java:117)
[14:46:55.236] at com.caucho.server.cluster.JdbcStore.store(JdbcStore.java:335)
[14:46:55.236] at com.caucho.server.cluster.ClusterObject.store(ClusterObject.java:411)
[14:46:55.236] at com.caucho.server.session.SessionImpl.save(SessionImpl.java:861)
[14:46:55.236] at com.caucho.server.session.SessionImpl.saveAfterRequest(SessionImpl.java:850)
[14:46:55.236] at com.caucho.server.session.SessionImpl.finish(SessionImpl.java:811)
[14:46:55.236] at com.caucho.server.connection.AbstractHttpRequest.finish(AbstractHttpRequest.java:2389)
[14:46:55.236] at com.caucho.server.http.HttpRequest.finish(HttpRequest.java:1422)
[14:46:55.236] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:211)
[14:46:55.236] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[14:46:55.236] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[14:46:55.236] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
[14:46:55.236] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[14:46:55.236] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[14:46:55.236] at java.lang.Thread.run(Thread.java:595)
 
The real weird part is that this only seems to be happening for some of our sites, but not all of them (all sites are running the same webapp). Unfortunately this JSP is doing some javascript redirects, so I wonder if that has something to do with it.
 
Has anybody else noticed this? We are using regular expressions to specify the virtual hosts, but we have always done that and never saw problems with 3.0.12, 3.0.14, or 3.0.19 (wasn?t tested extensively).
 
Additional Information
Attached Files

- Relationships

- Notes
(0001619)
ferg
11-30-06 12:28

server/01jb, server/01jc
 

- Issue History
Date Modified Username Field Change
11-21-06 15:49 ferg New Issue
11-30-06 12:28 ferg Note Added: 0001619
11-30-06 12:28 ferg Assigned To  => ferg
11-30-06 12:28 ferg Status new => closed
11-30-06 12:28 ferg Resolution open => fixed
11-30-06 12:28 ferg Fixed in Version  => 3.0.23
11-30-06 12:28 ferg Description Updated


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
29 total queries executed.
25 unique queries executed.
Powered by Mantis Bugtracker