My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 2508: error 500 when adding a member
6 people starred this issue and may be notified of changes. Back to list
Status:  AwaitingInformation
Owner:  ----


Sign in to add a comment
 
Reported by ncos...@gmail.com, Feb 28, 2014
************************************************************
***** 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
Please provide a stack trace from the logs/error_log file.

Status: AwaitingInformation
May 4, 2014
#2 kokomi...@gmail.com
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.




catalina_log.txt
5.9 KB   View   Download
May 12, 2014
#3 kokomi...@gmail.com
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
#4 s...@bordingvista.com
I am also having this issue while attempting to add a reviewer.
Apr 23, 2015
#5 ce...@knewton.com
how was this resolved?

Aug 6, 2015
#6 sven.lu...@googlemail.com
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
#7 sven.lu...@googlemail.com
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

Powered by Google Project Hosting