| Issue 2508: | error 500 when adding a member | |
| 6 people starred this issue and may be notified of changes. | Back to list |
************************************************************ ***** NOTE: THIS BUG TRACKER IS FOR GERRIT CODE REVIEW ***** ***** DO NOT SUBMIT BUGS FOR CHROME, ANDROID, INTERNAL ***** ***** ISSUES WITH YOUR COMPANY'S GERRIT SETUP, ETC. ***** ***** THOSE ISSUE BELONG IN DIFFERENT ISSUE TRACKERS! ***** ************************************************************ Affected Version: What steps will reproduce the problem? 1.Installed through chef version 2.8.1 2. Login with openId 3.Go to "People-> List Groups -> Non Interactive users -> Members 4. Try to type a letter in Member text box. What is the expected output? What do you see instead? - Type the user name and add it to group. - Instead i get a grey screen with "Code Review - Error Server Error Internal Server Error" and a button "continue". Please provide any additional information below. From the access-log of the apache2 "POST /gerrit_ui/rpc/SuggestService HTTP/1.1" 200 83 "http://gargareta.gt.central/" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36" 172.16.2.200 - - [28/Feb/2014:14:20:12 +0200] "PUT /groups/10b67d1f9a6cebfe2a6876cfa36ab59c0dc4acea/members/n HTTP/1.1" 500 42 "http://gargareta.gt.central/" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36"
Mar 4, 2014
Project Member
#1
david.pu...@sonymobile.com
Status:
AwaitingInformation
May 4, 2014
I am seeing the exact same issue under the following config: Gerrit 2.8.4 Tomcat 8.1 MySql 5.6 Gerrit is configured to use LDAP via Active Directory on Windows Server 2012. I've attached the end of the Catalina log file. It looks like it is trying to suggest and account as you are typing in but it is throwing an error in suggestAccount.
May 12, 2014
This is also happening when attempting to add a reviewer. This is now a lot more serious as Gerrit can't be used for its core purpose.
Nov 23, 2014
I am also having this issue while attempting to add a reviewer.
Apr 23, 2015
how was this resolved?
Aug 6, 2015
Exists a solution for this problem? I have got the same problem. After pressing "A" the following AJAX-Call was created: https://review.domain.com:8443/accounts/?q=A&n=20 The result of the Call was the HTTP-Code 500 (Internal Server Error). The log reports the following error: [2015-08-06 10:10:19,878] ERROR com.google.gerrit.httpd.restapi.RestApiServlet : Error in GET /accounts/?q=A&n=20 com.google.gwtorm.server.OrmException: fetch failure on accounts at com.google.gwtorm.schema.sql.SqlDialect.convertError(SqlDialect.java:158) at com.google.gwtorm.schema.sql.DialectMySQL.convertError(DialectMySQL.java:232) at com.google.gwtorm.jdbc.JdbcAccess.convertError(JdbcAccess.java:459) at com.google.gwtorm.jdbc.JdbcAccess.queryList(JdbcAccess.java:156) at com.google.gerrit.reviewdb.client.Account_Access_accounts_GwtOrm$$11.suggestByFullName(Unknown Source) at com.google.gerrit.server.account.SuggestAccounts.apply(SuggestAccounts.java:110) at com.google.gerrit.server.account.SuggestAccounts.apply(SuggestAccounts.java:42) at com.google.gerrit.httpd.restapi.RestApiServlet.service(RestApiServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:279) at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:269) at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:180) at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85) at com.google.gerrit.httpd.GetUserFilter.doFilter(GetUserFilter.java:82) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) at com.google.gwtexpui.server.CacheControlFilter.doFilter(CacheControlFilter.java:73) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) at com.google.gerrit.httpd.RunAsFilter.doFilter(RunAsFilter.java:117) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) at com.google.gerrit.httpd.RequireSslFilter.doFilter(RequireSslFilter.java:68) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) at com.google.gerrit.httpd.AllRequestFilter$FilterProxy$1.doFilter(AllRequestFilter.java:64) at com.google.gerrit.httpd.AllRequestFilter$FilterProxy.doFilter(AllRequestFilter.java:57) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) at com.google.gerrit.httpd.RequestContextFilter.doFilter(RequestContextFilter.java:75) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:119) at com.google.inject.servlet.GuiceFilter$1.call(GuiceFilter.java:133) at com.google.inject.servlet.GuiceFilter$1.call(GuiceFilter.java:130) at com.google.inject.servlet.GuiceFilter$Context.call(GuiceFilter.java:203) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:130) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:95) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:497) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '<=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2297) at com.google.gwtorm.jdbc.JdbcAccess.queryList(JdbcAccess.java:144) ... 46 more
Aug 6, 2015
My Problem was solved after executing the following two SQL-Statements: ALTER TABLE accounts CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_external_ids CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; Maybe you want to change the charset of all tables: ALTER TABLE account_diff_preferences CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_external_ids CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_group_by_id CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_group_by_id_aud CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_group_id CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_group_members CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_group_members_audit CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_group_names CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_id CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_patch_reviews CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_project_watches CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE account_ssh_keys CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE accounts CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE change_id CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE change_message_id CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE change_messages CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE changes CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE patch_comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE patch_set_ancestors CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE patch_set_approvals CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE patch_sets CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE schema_version CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE starred_changes CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE submodule_subscriptions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE system_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; |
|
| ► Sign in to add a comment |