cannot upload a file called 🌍.csv (or similar)

GENERAL

TESTING

GENERAL

TESTING

Description

Oddly named file (🌍.csv) cannot be uploaded

You see this

after 10 secs, the error is reported.

Attachments

01 Feb 2025, 08:52 PM
28 Mar 2023, 08:06 PM
28 Mar 2023, 08:06 PM
28 Mar 2023, 08:04 PM

Linked issues

is related to

SAK-31945

Support MySQL utf8mb4 (emojis)

Activity

Show:

Adam Marshall February 4, 2025 at 11:20 AM

this bug was created many years ago. I guess it’s been fixed under a different ticket

Christopher Maurer February 1, 2025 at 8:52 PM

This works for me locally under these conditions:

Created a fresh (mysql) database using the utf8mb4 character set.
Set the following props in sakai.properties (as instructed from https://sakaiproject.atlassian.net/wiki/spaces/DOC/pages/32324812927/Sakai+23+Database+Support):
- driverClassName@javax.sql.BaseDataSource=com.mysql.cj.jdbc.Driver
  hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
  url@javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8&useSSL=false
  content.cleaner.filter.utf8=false

So, it seems like the application will support it just fine, you just have to convince the database!

I don’t know exactly how the nightly servers are configured with respect to the databases, but this doesn’t work on the mariadb or mysql8 instances. Oracle instance is currently down, so can’t test it at all.

Christopher Maurer April 29, 2023 at 3:25 PM

Locally, I got this in the logs:

29-Apr-2023 11:23:24.686 WARN [http-nio-8080-exec-1] o.s.d.i.BasicSqlService.dbRead Sql.dbRead: sql: select XML, BINARY_ENTITY from CONTENT_RESOURCE where (RESOURCE_ID = ?) /group/2503ca13-d048-4336-bb90-06414714bf16/🌍.csv
java.sql.SQLException: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1288) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:788) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-5.0.1.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-5.0.1.jar:?]
	at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:552) ~[?:?]
	at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:469) ~[?:?]
	at org.sakaiproject.util.BaseDbDualSingleStorage.loadResources(BaseDbDualSingleStorage.java:511) ~[sakai-kernel-storage-util-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.util.BaseDbDualSingleStorage.getResource(BaseDbDualSingleStorage.java:356) ~[sakai-kernel-storage-util-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.content.impl.DbContentService$DbStorage.getResource(DbContentService.java:1525) ~[?:?]
	at org.sakaiproject.content.impl.BaseContentService.findResource(BaseContentService.java:4397) ~[?:?]
	at org.sakaiproject.content.impl.BaseContentService.getEntityAuthzGroups(BaseContentService.java:7548) ~[?:?]
	at org.sakaiproject.entity.impl.ReferenceComponent.getAuthzGroups(ReferenceComponent.java:267) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.checkAuthzGroups(SakaiSecurity.java:759) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:737) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:704) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:696) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:682) ~[?:?]
	at org.sakaiproject.content.impl.BaseContentService.unlock(BaseContentService.java:1720) ~[?:?]
	at org.sakaiproject.content.impl.BaseContentService.getResource(BaseContentService.java:4319) ~[?:?]
	at org.sakaiproject.content.cover.ContentHostingService.getResource(ContentHostingService.java:642) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.content.tool.ResourcesHelperAction.doDragDropUpload(ResourcesHelperAction.java:2099) ~[classes/:?]
	at org.sakaiproject.content.tool.ResourcesHelperAction.doPost(ResourcesHelperAction.java:1967) ~[classes/:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:450) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:353) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:313) ~[catalina.jar:9.0.69]
	at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.help(ActiveToolComponent.java:578) ~[?:?]
	at org.sakaiproject.cheftool.ToolServlet.sendToHelper(ToolServlet.java:675) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.ToolServlet.doGet(ToolServlet.java:219) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.VelocityPortletPaneledAction.doGet(VelocityPortletPaneledAction.java:1098) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.ToolServlet.doPost(ToolServlet.java:152) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:450) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:353) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:313) ~[catalina.jar:9.0.69]
	at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:508) ~[?:?]
	at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1545) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doToolBuffer(SiteHandler.java:1297) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.bufferContent(SiteHandler.java:1131) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:511) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:286) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:184) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.WorksiteHandler.doPost(WorksiteHandler.java:69) ~[?:?]
	at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1218) ~[?:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:500) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[catalina.jar:9.0.69]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[catalina.jar:9.0.69]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[catalina.jar:9.0.69]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[catalina.jar:9.0.69]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[catalina.jar:9.0.69]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.69]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.69]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.69]
	at java.lang.Thread.run(Thread.java:829) ~[?:?]
29-Apr-2023 11:23:24.740 WARN [http-nio-8080-exec-1] o.s.d.i.BasicSqlService.dbRead Sql.dbRead: sql: select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and  SAKAI_REALM.REALM_ID IN (?,?,?,?,?,?) and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = ?)  and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = ?  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where  SAKAI_REALM.REALM_ID IN (?,?,?,?,?,?)))  or ROLE_KEY in (?, ?) ) /content/ /content/group/ /content/group/2503ca13-d048-4336-bb90-06414714bf16/ /content/group/2503ca13-d048-4336-bb90-06414714bf16/🌍.csv /site/2503ca13-d048-4336-bb90-06414714bf16 !site.helper content.read faa4db2b-2cc4-4fde-a572-aee1ac2331e5 /content/ /content/group/ /content/group/2503ca13-d048-4336-bb90-06414714bf16/ /content/group/2503ca13-d048-4336-bb90-06414714bf16/🌍.csv /site/2503ca13-d048-4336-bb90-06414714bf16 !site.helper 1 2
java.sql.SQLException: Illegal mix of collations for operation ' IN '
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1288) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:788) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011) ~[mysql-connector-java-5.1.47.jar:5.1.47]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-5.0.1.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-5.0.1.jar:?]
	at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:552) ~[?:?]
	at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:469) ~[?:?]
	at org.sakaiproject.authz.impl.DbAuthzGroupService$DbStorage.isAllowed(DbAuthzGroupService.java:2231) ~[?:?]
	at org.sakaiproject.authz.impl.BaseAuthzGroupService.isAllowed(BaseAuthzGroupService.java:1029) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.checkAuthzGroups(SakaiSecurity.java:805) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:737) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:704) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:696) ~[?:?]
	at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:682) ~[?:?]
	at org.sakaiproject.content.impl.BaseContentService.unlock(BaseContentService.java:1720) ~[?:?]
	at org.sakaiproject.content.impl.BaseContentService.getResource(BaseContentService.java:4319) ~[?:?]
	at org.sakaiproject.content.cover.ContentHostingService.getResource(ContentHostingService.java:642) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.content.tool.ResourcesHelperAction.doDragDropUpload(ResourcesHelperAction.java:2099) ~[classes/:?]
	at org.sakaiproject.content.tool.ResourcesHelperAction.doPost(ResourcesHelperAction.java:1967) ~[classes/:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:450) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:353) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:313) ~[catalina.jar:9.0.69]
	at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.help(ActiveToolComponent.java:578) ~[?:?]
	at org.sakaiproject.cheftool.ToolServlet.sendToHelper(ToolServlet.java:675) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.ToolServlet.doGet(ToolServlet.java:219) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.VelocityPortletPaneledAction.doGet(VelocityPortletPaneledAction.java:1098) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.ToolServlet.doPost(ToolServlet.java:152) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:450) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:353) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:313) ~[catalina.jar:9.0.69]
	at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:508) ~[?:?]
	at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1545) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doToolBuffer(SiteHandler.java:1297) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.bufferContent(SiteHandler.java:1131) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:511) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:286) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:184) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.WorksiteHandler.doPost(WorksiteHandler.java:69) ~[?:?]
	at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1218) ~[?:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:500) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[catalina.jar:9.0.69]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[catalina.jar:9.0.69]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[catalina.jar:9.0.69]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[catalina.jar:9.0.69]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[catalina.jar:9.0.69]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.69]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.69]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.69]
	at java.lang.Thread.run(Thread.java:829) ~[?:?]
29-Apr-2023 11:23:24.759 WARN [http-nio-8080-exec-1] o.s.c.t.ResourcesHelperAction.doDragDropUpload Drag and drop upload failed: {}
org.sakaiproject.exception.PermissionException: user=faa4db2b-2cc4-4fde-a572-aee1ac2331e5 lock=content.read resource=/content/group/2503ca13-d048-4336-bb90-06414714bf16/🌍.csv
	at org.sakaiproject.content.impl.BaseContentService.unlock(BaseContentService.java:1722) ~[?:?]
	at org.sakaiproject.content.impl.BaseContentService.getResource(BaseContentService.java:4319) ~[?:?]
	at org.sakaiproject.content.cover.ContentHostingService.getResource(ContentHostingService.java:642) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.content.tool.ResourcesHelperAction.doDragDropUpload(ResourcesHelperAction.java:2099) ~[classes/:?]
	at org.sakaiproject.content.tool.ResourcesHelperAction.doPost(ResourcesHelperAction.java:1967) ~[classes/:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:450) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:353) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:313) ~[catalina.jar:9.0.69]
	at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.help(ActiveToolComponent.java:578) ~[?:?]
	at org.sakaiproject.cheftool.ToolServlet.sendToHelper(ToolServlet.java:675) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.ToolServlet.doGet(ToolServlet.java:219) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.VelocityPortletPaneledAction.doGet(VelocityPortletPaneledAction.java:1098) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.sakaiproject.cheftool.ToolServlet.doPost(ToolServlet.java:152) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56) ~[sakai-velocity-tool-24-SNAPSHOT.jar:24-SNAPSHOT]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:450) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:711) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:353) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:313) ~[catalina.jar:9.0.69]
	at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:508) ~[?:?]
	at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1545) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doToolBuffer(SiteHandler.java:1297) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.bufferContent(SiteHandler.java:1131) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:511) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:286) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:184) ~[?:?]
	at org.sakaiproject.portal.charon.handlers.WorksiteHandler.doPost(WorksiteHandler.java:69) ~[?:?]
	at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1218) ~[?:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) ~[servlet-api.jar:4.0.FR]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:500) ~[sakai-kernel-api-24-SNAPSHOT.jar:24-SNAPSHOT]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[catalina.jar:9.0.69]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[catalina.jar:9.0.69]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[catalina.jar:9.0.69]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) ~[catalina.jar:9.0.69]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[catalina.jar:9.0.69]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[catalina.jar:9.0.69]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:9.0.69]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.69]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.69]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.69]
	at java.lang.Thread.run(Thread.java:829) ~[?:?]
29-Apr-2023 11:23:39.579 INFO [pool-3-thread-1] o.s.a.i.DbAuthzGroupService.run RefreshAuthzGroupTask.run() refreshed 2 realms in 0.005 seconds, longest realm was /site/2503ca13-d048-4336-bb90-06414714bf16 at 0.004 seconds
29-Apr-2023 11:23:59.549 DEBUG [[elasticsearch content indexer default]] o.s.s.e.SiteElasticSearchIndexBuilder.run Running content indexing task for index builder [default]

Christina Schwiebert April 4, 2023 at 12:51 PM

Note that this seems to affect a file with any emoji in the title, it is not specific to the globe emoji

Details

Priority

Major

Affects versions

23 Status

Please Merge

22 Status

Please Merge

21 Status

Please Merge

Components

Resources

Assignee

Christopher Maurer

Reporter

Adam Marshall

Environment

macos / safari

Created March 28, 2023 at 8:04 PM

Updated February 4, 2025 at 11:20 AM

Configure

Sakai

cannot upload a file called 🌍.csv (or similar)

Description

Attachments

Linked issues

is related to

Activity

Adam Marshall February 4, 2025 at 11:20 AM

Christopher Maurer February 1, 2025 at 8:52 PM

Christopher Maurer April 29, 2023 at 3:25 PM

Christina Schwiebert April 4, 2023 at 12:51 PM

Details

Priority

Affects versions

23 Status

22 Status

21 Status

Components

Assignee

Reporter

Environment

Flag notifications

Something's gone wrong