Issue 772: Publish Comment causes jdbc errors - requires gerrit restart
Status:  New
Owner: ----
Reported by ni...@codeaurora.org, Nov 5, 2010
Affected Version: 2.1.5

Note: I'm not able to reproduce it yet, but I'm going to log it either way.

What is the expected output? 
The comment is published for the Patchset under review.

What do you see instead?
Gerrit Application Error.

Please provide any additional information below.
1. Select "Review"
2. Inside the Cover Message block, enter text
3. Publish comments
4. Application Error

It required a gerrit restart to bring it back online. 

From gerrit/logs/error_log:

[2010-11-05 21:00:42,668] ERROR com.google.gerrit.server.query.change.QueryProcessor : Cannot execute query: status:open
com.google.gwtorm.client.OrmException: fetch failure on tracking_ids
        at com.google.gwtorm.schema.sql.SqlDialect.convertError(SqlDialect.java:122)
        at com.google.gwtorm.schema.sql.DialectPostgreSQL.convertError(DialectPostgreSQL.java:60)
        at com.google.gwtorm.jdbc.JdbcAccess.convertError(JdbcAccess.java:331)
        at com.google.gwtorm.jdbc.JdbcAccess.queryList(JdbcAccess.java:152)
        at com.google.gerrit.reviewdb.TrackingId_Access_trackingIds_GwtOrm$$26.byChange(Unknown Source)
        at com.google.gerrit.server.query.change.ChangeData.trackingIds(ChangeData.java:189)
        at com.google.gerrit.server.query.change.QueryProcessor.query(QueryProcessor.java:151)
        at com.google.gerrit.sshd.commands.Query$1.run(Query.java:56)
        at com.google.gerrit.sshd.BaseCommand$TaskThunk.run(BaseCommand.java:395)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:207)
        at com.google.gerrit.server.git.WorkQueue$Task.run(WorkQueue.java:324)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: Bad value for type int : Idd044a317da17bdf93c2d6da68ef47fe6e1a9840
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2759)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2003)
        at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
        at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
        at com.google.gerrit.reviewdb.TrackingId_Access_trackingIds_GwtOrm$$26.bindOneFetch(Unknown Source)
        at com.google.gwtorm.jdbc.JdbcAccess.queryList(JdbcAccess.java:141)
        ... 14 more
[2010-11-05 21:00:48,002] WARN  com.google.gerrit.server.IdentifiedUser : Cannot query starred by user changes
com.google.gwtorm.client.OrmException: fetch failure on starred_changes
        at com.google.gwtorm.schema.sql.SqlDialect.convertError(SqlDialect.java:122)
        at com.google.gwtorm.schema.sql.DialectPostgreSQL.convertError(DialectPostgreSQL.java:60)
        at com.google.gwtorm.jdbc.JdbcAccess.convertError(JdbcAccess.java:331)
        at com.google.gwtorm.jdbc.JdbcAccess.queryList(JdbcAccess.java:152)
        at com.google.gerrit.reviewdb.StarredChange_Access_starredChanges_GwtOrm$$16.byAccount(Unknown Source)
        at com.google.gerrit.server.IdentifiedUser.getStarredChanges(IdentifiedUser.java:228)
        at com.google.gerrit.httpd.rpc.ChangeListServiceImpl$QueryNext.run(ChangeListServiceImpl.java:322)
        at com.google.gerrit.httpd.rpc.ChangeListServiceImpl$QueryNext.run(ChangeListServiceImpl.java:307)
        at com.google.gerrit.httpd.rpc.BaseServiceImplementation.run(BaseServiceImplementation.java:64)
        at com.google.gerrit.httpd.rpc.ChangeListServiceImpl.allQueryNext(ChangeListServiceImpl.java:133)
        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.google.gwtjsonrpc.server.MethodHandle.invoke(MethodHandle.java:91)
        at com.google.gwtjsonrpc.server.JsonServlet.doService(JsonServlet.java:382)
        at com.google.gwtjsonrpc.server.JsonServlet.service(JsonServlet.java:268)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:216)
 at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:141)
        at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:93)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:63)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:134)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:134)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
        at com.google.gwtexpui.server.CacheControlFilter.doFilter(CacheControlFilter.java:76)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
        at com.google.gerrit.httpd.RequireSslFilter.doFilter(RequireSslFilter.java:68)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
        at com.google.gerrit.httpd.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:54)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:129)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:134)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:59)
        at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:122)
        at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:110)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:424)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:931)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:361)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113)
        at org.eclipse.jetty.server.Server.handle(Server.java:337)
        at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581)
        at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1020)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:775)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:228)
        at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:417)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:474)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:437)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: Bad value for type int : N
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2759)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2003)
        at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
        at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
        at com.google.gerrit.reviewdb.StarredChange_Access_starredChanges_GwtOrm$$16.bindOneFetch(Unknown Source)
        at com.google.gwtorm.jdbc.JdbcAccess.queryList(JdbcAccess.java:141)
        ... 50 more