[Unicode]   Common Locale Data Repository : Bug Tracking Home | Site Map | Search
 
Modify

CLDR Ticket #11226(accepted survey)

Opened 3 weeks ago

Last modified 3 weeks ago

ST: Survey Tool is down with SQL exception

Reported by: fredrik Owned by: backend
Component: survey Data Locale:
Phase: dsub Review:
Weeks: Data Xpath:
Xref:

Description

The production side of survey tool is offline. (The opening message is interesting as I wasn't doing anything with locale es.)

Could not vote for value in locale locale es
SQL exception:
-
java.sql.SQLException: The table 'cldr_vote_value_34' is full
Stack:
java.sql.SQLException: The table 'cldr_vote_value_34' is full

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
at org.unicode.cldr.web.STFactory$PerLocaleData.voteForValue(STFactory.java:1252)
at org.unicode.cldr.web.STFactory$PerLocaleData.voteForValue(STFactory.java:1133)
at org.unicode.cldr.web.STFactory$PerLocaleData.voteForValue(STFactory.java:369)
at org.unicode.cldr.web.SurveyAjax.importAllOldWinningVotes(SurveyAjax.java:2151)
at org.unicode.cldr.web.SurveyAjax.doAutoImportOldWinningVotes(SurveyAjax.java:2083)
at org.unicode.cldr.web.SurveyAjax.processRequest(SurveyAjax.java:914)
at org.unicode.cldr.web.SurveyAjax.doGet(SurveyAjax.java:310)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.filters.ExpiresFilter.doFilter(ExpiresFilter.java:1223)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

[25 Jun 2018 11:44:11 GMT] (hide.)

Attachments

Change History

comment:1 follow-up: ↓ 2 Changed 3 weeks ago by srl

Maybe you voted for es in the past, this was an import

Full?? This is a new one. I've never heard of a table being full.

That table has 1,265,259 rows - is there some limit?

The disk is not full. 1.3G used for ST.

cldr_vote_value_34.ibd is 167,772,160 bytes (160M).

Last edited 3 weeks ago by srl (previous) (diff)

comment:2 in reply to: ↑ 1 Changed 3 weeks ago by fredrik

Replying to srl:

Maybe you voted for es in the past, this was an import

Well, I've used TC vote for many locales in the past, so that is possible and just es happened to come first in the list?

comment:3 Changed 3 weeks ago by mark

Saw that John seems to have fixed it.

We should repurpose this bug to preventing the logs from filling up in the future. Could be something automatic, or just a matter of having a periodic BRS item + instructions on how to flush the logs.

comment:4 Changed 3 weeks ago by tbishop

Was the disk full due to the logs getting too large?

I've noticed a lot of exceptions are thrown when importing old votes, for invalid xpath, or user lacking permission. Since the stack is dumped to the log every time, it is a lot of data. Under some circumstances it might make sense to write less, or nothing at all, to the log, depending of course on how the logs are expected to used. Logging the stack dump can be very helpful for debugging programming errors, but maybe not very useful when the exceptions don't result from programming errors.

comment:5 Changed 3 weeks ago by mark

  • Owner changed from anybody to backend
  • Status changed from new to accepted
  • Milestone changed from UNSCH to 34
View

Add a comment

Modify Ticket

Action
as accepted
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.