My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 772: Publish Comment causes jdbc errors - requires gerrit restart
2 people starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


Sign in to add a comment
 
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
Sign in to add a comment

Powered by Google Project Hosting