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 2022/10/12 07:09:17 UTC
[GitHub] [shardingsphere] Dangshuangyin opened a new issue, #21521: .CommandExecutorTask - Exception occur:
Dangshuangyin opened a new issue, #21521:
URL: https://github.com/apache/shardingsphere/issues/21521
ShardingSphere-SQL - Actual SQL: ds_0 ::: SHOW STATUS
[ERROR] 2022-10-12 14:06:53.546 [ShardingSphere-Command-0] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.NullPointerException: null
at org.apache.shardingsphere.infra.federation.executor.original.OriginalFederationExecutor.createConnection(OriginalFederationExecutor.java:92)
at org.apache.shardingsphere.infra.federation.executor.original.OriginalFederationExecutor.executeQuery(OriginalFederationExecutor.java:83)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.doExecuteFederation(JDBCDatabaseCommunicationEngine.java:165)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:123)
at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:94)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:110)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:77)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
URL: https://github.com/apache/shardingsphere/issues/21521
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1280357750
@Dangshuangyin
Sorry, I tested again with your configuration and everything works fine.
Moreover, such a configuration will not use the `federation` engine.
Do you have other configurations for your proxy?
<img width="1061" alt="image" src="https://user-images.githubusercontent.com/5668787/196104867-04982df8-fe49-424c-9ec8-25d6c3dc6916.png">
--
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] koala775 commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
koala775 commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301732412
So,it's have a effect with the use?
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1302832096
> So,it's have a effect with the use?
Since there are too many differences between third-party clients, it is recommended to use the mysql command client to connect to the Proxy.
--
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] koala775 commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
koala775 commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1299507463
I also have this proplem,version:shardingsphere-proxy-5.2.1.I use DBeaver to connect then throw this exception.
--
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] koala775 commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
koala775 commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301697110
I haven't execute any sql,I just use DBeaver to connect proxy.
--
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] koala775 commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
koala775 commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301712243
Yes.I have saw some sql like,SELECT @@session.automoit.Then next line it's the exception.
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301729655
However, in distributed scenarios, `information_schema` is not easy to implement, and this work will still take a long time.
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301701750
> I haven't execute any sql,I just use DBeaver to connect proxy.
Yes, DBeaver will send SQL statement to query some data.
--
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] koala775 commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
koala775 commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301739998
The log is like:
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1407419915
duplicated with #18955.
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1277785050
Hi @Dangshuangyin
I verified with 5.2.0 and found no similar issues.
Can you provide the rule configuration in order to reproduce the problem?
<img width="803" alt="image" src="https://user-images.githubusercontent.com/5668787/195637391-728fad07-a4f2-4e70-8442-5b99cf7678af.png">
--
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] Dangshuangyin commented on issue #21521: .CommandExecutorTask - Exception occur:
Posted by GitBox <gi...@apache.org>.
Dangshuangyin commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1277061753
> Hi @Dangshuangyin Thanks for your feedback, what is your version of Proxy?
5.2.0
--
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] RaigorJiang commented on issue #21521: .CommandExecutorTask - Exception occur:
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1277059780
Hi @Dangshuangyin
Thanks for your feedback, what is your version of Proxy?
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301726719
@koala775
After my test, I found that the exception is not caused by the printed Actual SQL, we need to enable the Proxy's debug log and view the received packets.
- Find logback.xml
```xml
<logger name="org.apache.shardingsphere" level="info" additivity="false">
<appender-ref ref="console" />
</logger>
```
- Change it to debug:
```xml
<logger name="org.apache.shardingsphere" level="debug" additivity="false">
<appender-ref ref="console" />
</logger>
```
And then restart Proxy and connect with client.
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301728226
In my environment, it was the following SQL that caused the NPE, which was not the same as what @Dangshuangyin provided:
```sql
/* ApplicationName=DBeaver 22.2.3 - Main */ SELECT * FROM information_schema.TABLES t
WHERE t.TABLE_SCHEMA = 'information_schema' AND t.TABLE_NAME = 'CHECK_CONSTRAINTS';
```
--
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] RaigorJiang commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1301692847
> I also have this proplem,version:shardingsphere-proxy-5.2.1.I use DBeaver to connect then throw this exception.
@koala775 Please enable `sql_show` and provide the SQL and log when exception occurs, thank you!
--
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] Dangshuangyin commented on issue #21521: NPE occurred when execute `SHOW STATUS` in Proxy.
Posted by GitBox <gi...@apache.org>.
Dangshuangyin commented on issue #21521:
URL: https://github.com/apache/shardingsphere/issues/21521#issuecomment-1278362463
> [status: need more info ](/apache/shardingsphere/labels/status%3A%20need%20more%20info) l
CREATE TABLE `t_order` (
`id` bigint(20) NOT NULL COMMENT '主键id',
`order_id` int(20) NOT NULL DEFAULT 0 COMMENT '订单ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
--
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