You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/04/16 06:32:22 UTC

[GitHub] [shardingsphere] aa310958153 opened a new issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

aa310958153 opened a new issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106


   ## Bug Report
   Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8473' for column 'user_remark' at row 1
   UPDATE soa_ord_order SET user_remark='小心发货😄102' WHERE id=429102753254514691 
   #Test
   Execute update successfully: connect mysql
   Execute failed: connect proxy
   
   database config utf8mb4,utf8mb4_general_ci
   filed config utf8mb4,utf8mb4_general_ci


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] aa310958153 commented on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
aa310958153 commented on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-820948037


   proxy log
   [ERROR] 13:50:37.761 [ShardingSphere-Command-10] o.a.s.p.f.c.CommandExecutorTask - Exception occur: 
   java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x84\xF0\x9F...' for column 'consignee_name' at row 1
           at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
           at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
           at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
           at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
           at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
           at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
           at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
           at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
           at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:939)
           at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:103)
           at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.statement.accessor.impl.StatementAccessor.execute(StatementAccessor.java:43)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxySQLExecutorCallback.executeSQL(ProxySQLExecutorCallback.java:84)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxySQLExecutorCallback.executeSQL(ProxySQLExecutorCallback.java:77)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxySQLExecutorCallback.executeSQL(ProxySQLExecutorCallback.java:48)
           at org.apache.shardingsphere.infra.executor.sql.resourced.jdbc.executor.impl.DefaultSQLExecutorCallback.execute0(DefaultSQLExecutorCallback.java:75)
           at org.apache.shardingsphere.infra.executor.sql.resourced.jdbc.executor.impl.DefaultSQLExecutorCallback.execute(DefaultSQLExecutorCallback.java:57)
           at org.apache.shardingsphere.infra.executor.kernel.ExecutorKernel.syncExecute(ExecutorKernel.java:99)
           at org.apache.shardingsphere.infra.executor.kernel.ExecutorKernel.parallelExecute(ExecutorKernel.java:95)
           at org.apache.shardingsphere.infra.executor.kernel.ExecutorKernel.execute(ExecutorKernel.java:78)
           at org.apache.shardingsphere.infra.executor.sql.resourced.jdbc.executor.SQLExecutor.execute(SQLExecutor.java:65)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.executeWithManagedResource(JDBCExecuteEngine.java:130)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:123)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:103)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.doExecute(JDBCDatabaseCommunicationEngine.java:93)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:79)
           at org.apache.shardingsphere.proxy.backend.text.query.QueryBackendHandler.execute(QueryBackendHandler.java:61)
           at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:62)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:100)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:76)
           at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(T


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu closed issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-822888980


   Hi which client did you use? Sharding Proxy or Sharding JDBC?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] sangewuxie commented on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
sangewuxie commented on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-826439916






-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] aa310958153 removed a comment on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
aa310958153 removed a comment on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-820968618


   org.apache.shardingsphere.proxy.backend.communication.jdbc.datasource.factory.JDBCRawBackendDataSourceFactory#build
   add
   config.setConnectionInitSql("set names utf8mb4;");  successfully


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu commented on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-927304419


   Closed because of no response anymore.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] sangewuxie commented on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
sangewuxie commented on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-826440192


   昨天才更新也时遇到类似的问题，出现emoji就会报错


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] aa310958153 commented on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
aa310958153 commented on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-820968618


   org.apache.shardingsphere.proxy.backend.communication.jdbc.datasource.factory.JDBCRawBackendDataSourceFactory#build
   add
   config.setConnectionInitSql("set names utf8mb4;");  successfully


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] sangewuxie commented on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
sangewuxie commented on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-826439916


   sharding proxy插入时存在emoji报错  这个问题目前是否有解决


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] aa310958153 removed a comment on issue #10106: bug, emoji cant save(insert) or update, update is work shardingsphere-5.0.0-alpha

Posted by GitBox <gi...@apache.org>.
aa310958153 removed a comment on issue #10106:
URL: https://github.com/apache/shardingsphere/issues/10106#issuecomment-820948037


   proxy log
   [ERROR] 13:50:37.761 [ShardingSphere-Command-10] o.a.s.p.f.c.CommandExecutorTask - Exception occur: 
   java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x84\xF0\x9F...' for column 'consignee_name' at row 1
           at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
           at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
           at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
           at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
           at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
           at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
           at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
           at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
           at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:939)
           at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:103)
           at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.statement.accessor.impl.StatementAccessor.execute(StatementAccessor.java:43)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxySQLExecutorCallback.executeSQL(ProxySQLExecutorCallback.java:84)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxySQLExecutorCallback.executeSQL(ProxySQLExecutorCallback.java:77)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxySQLExecutorCallback.executeSQL(ProxySQLExecutorCallback.java:48)
           at org.apache.shardingsphere.infra.executor.sql.resourced.jdbc.executor.impl.DefaultSQLExecutorCallback.execute0(DefaultSQLExecutorCallback.java:75)
           at org.apache.shardingsphere.infra.executor.sql.resourced.jdbc.executor.impl.DefaultSQLExecutorCallback.execute(DefaultSQLExecutorCallback.java:57)
           at org.apache.shardingsphere.infra.executor.kernel.ExecutorKernel.syncExecute(ExecutorKernel.java:99)
           at org.apache.shardingsphere.infra.executor.kernel.ExecutorKernel.parallelExecute(ExecutorKernel.java:95)
           at org.apache.shardingsphere.infra.executor.kernel.ExecutorKernel.execute(ExecutorKernel.java:78)
           at org.apache.shardingsphere.infra.executor.sql.resourced.jdbc.executor.SQLExecutor.execute(SQLExecutor.java:65)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.executeWithManagedResource(JDBCExecuteEngine.java:130)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:123)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:103)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.doExecute(JDBCDatabaseCommunicationEngine.java:93)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:79)
           at org.apache.shardingsphere.proxy.backend.text.query.QueryBackendHandler.execute(QueryBackendHandler.java:61)
           at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:62)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:100)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:76)
           at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(T


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org