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 2023/01/19 01:21:40 UTC
[GitHub] [shardingsphere] strongduanmu opened a new issue, #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
strongduanmu opened a new issue, #23643:
URL: https://github.com/apache/shardingsphere/issues/23643
## Bug Report
### Which version of ShardingSphere did you use?
[cd60a19](https://github.com/apache/shardingsphere/commit/cd60a19ec3230b7f8d36d832b56b7586a0e02b81)
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
Execute `./mvnw -nsu -B install -f test/e2e/suite/pom.xml -Dspotless.apply.skip=true -Dit.cluster.env.type=DOCKER -Dit.cluster.adapters=proxy -Dit.run.modes=Cluster -Dit.run.additional.cases=true -Dit.cluster.databases=PostgreSQL -Dit.scenarios=db` successfully
### Actual behavior
```
[INFO ] 2023-01-19 09:19:27.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - working demos
[INFO ] 2023-01-19 09:19:27.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - access to the full documentation
[INFO ] 2023-01-19 09:19:27.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - special exclusive bonus offers not available to others
[INFO ] 2023-01-19 09:19:27.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - everything you need to get the most out of using Atomikos!
[INFO ] 2023-01-19 09:19:27.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: Thanks for using Atomikos! This installation is not registered yet.
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: REGISTER FOR FREE at http://www.atomikos.com/Main/RegisterYourDownload and receive:
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - tips & advice
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - working demos
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - access to the full documentation
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - special exclusive bonus offers not available to others
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - everything you need to get the most out of using Atomikos!
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING core version: 5.0.9
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.allow_subtransactions = true
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 300000
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.throw_on_heuristic = false
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.logcloud_datasource_name = logCloudDS
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.jvm_id = 11@7fb8decbf0b6
[INFO ] 2023-01-19 09:19:27.994 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_actives = 10000
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.443 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.enable_logging = true
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_timeout = 300000
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.tm_unique_name = 192.168.192.4.tm
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.444 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - Using default (local) logging and recovery...
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.600 [Curator-SafeNotifyService-0] c.a.icatch.imp.TransactionServiceImp - Entering shutdown (false, 0)...
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.600 [Curator-SafeNotifyService-0] c.a.icatch.imp.TransactionServiceImp - Shutdown leaves no pending transactions - ok to delete logfiles
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.813 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/opt/shardingsphere-proxy/lib/transactions-5.0.9.jar!/transactions-defaults.properties
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.814 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/opt/shardingsphere-proxy/lib/shardingsphere-transaction-xa-atomikos-5.3.2-SNAPSHOT.jar!/transactions.properties
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:19:27.817 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - Thanks for using Atomikos! This installation is not registered yet.
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: REGISTER FOR FREE at http://www.atomikos.com/Main/RegisterYourDownload and receive:
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - tips & advice
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - working demos
[INFO ] 2023-01-19 09:19:27.995 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - access to the full documentation
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - special exclusive bonus offers not available to others
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - everything you need to get the most out of using Atomikos!
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: Thanks for using Atomikos! This installation is not registered yet.
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: REGISTER FOR FREE at http://www.atomikos.com/Main/RegisterYourDownload and receive:
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - tips & advice
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - working demos
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - access to the full documentation
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - special exclusive bonus offers not available to others
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: - everything you need to get the most out of using Atomikos!
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.819 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING core version: 5.0.9
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.819 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.819 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.allow_subtransactions = true
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 300000
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.throw_on_heuristic = false
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.logcloud_datasource_name = logCloudDS
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 2023-01-19 09:19:27.996 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.jvm_id = 11@7fb8decbf0b6
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_actives = 10000
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.enable_logging = true
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_timeout = 300000
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.tm_unique_name = 192.168.192.4.tm
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.forget_orp
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: haned_log_entries_delay = 86400000
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.820 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 2023-01-19 09:19:27.997 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:27.821 [Curator-SafeNotifyService-0] c.a.icatch.provider.imp.AssemblerImp - Using default (local) logging and recovery...
[INFO ] 2023-01-19 09:19:28.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:28.327 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c] REGISTERED
[INFO ] 2023-01-19 09:19:28.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:28.330 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c] BIND: /0.0.0.0:3307
[INFO ] 2023-01-19 09:19:28.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:28.334 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy Cluster mode started successfully
[INFO ] 2023-01-19 09:19:28.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:28.343 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c, L:/0.0.0.0:3307] ACTIVE
[INFO ] 2023-01-19 09:19:28.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:28.432 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c, L:/0.0.0.0:3307] READ: [id: 0xf1fad2ac, L:/192.168.192.4:3307 - R:/192.168.192.1:61880]
[INFO ] 2023-01-19 09:19:28.993 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:28.449 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 2023-01-19 09:19:30.215 [main] 🐳 [apache/shardingsphere-proxy-test:latest] - Container apache/shardingsphere-proxy-test:latest started in PT7.80209S
[INFO ] 2023-01-19 09:19:30.992 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:30.263 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c, L:/0.0.0.0:3307] READ: [id: 0x4b4f2c00, L:/192.168.192.4:3307 - R:/192.168.192.1:61882]
[INFO ] 2023-01-19 09:19:30.992 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:30.264 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 2023-01-19 09:19:30.992 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:30.499 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c, L:/0.0.0.0:3307] READ: [id: 0x161a5b34, L:/192.168.192.4:3307 - R:/192.168.192.1:61884]
[INFO ] 2023-01-19 09:19:30.992 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2023-01-19 01:19:30.499 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x09ffd21c, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.484 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.484 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.516 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.516 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.552 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.552 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.584 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.585 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.978 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:01.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:01.978 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO ] 2023-01-19 09:20:02.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:02.010 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:02.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:02.010 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO ] 2023-01-19 09:20:02.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:02.040 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:02.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:02.040 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO ] 2023-01-19 09:20:02.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:02.068 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?0) => >($0, ?1) is not there
[INFO ] 2023-01-19 09:20:02.976 [docker-java-stream-1008931742] db:ShardingSphere-Proxy - STDOUT: [WARN ] 2023-01-19 01:20:02.068 [Connection-2-ThreadExecutor] o.a.c.plan.RexImplicationChecker - Support for checking >($0, ?1) => >($0, ?0) is not there
[INFO] Tests run: 1496, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 57.971 s - in org.apache.shardingsphere.test.e2e.engine.dql.AdditionalDQLE2EIT
[INFO] Running org.apache.shardingsphere.test.e2e.engine.dql.GeneralDQLE2EIT
[INFO ] 2023-01-19 09:20:18.340 [docker-java-stream--179718200] db:zookeeper - STDOUT: 2023-01-19 01:20:18,341 [myid:1] - INFO [ContainerManagerTask:ContainerManager@134] - Attempting to delete candidate container: /it_db/lock/exclusive/locks/sys_data_dbpg_catalogpg_class
[INFO ] 2023-01-19 09:20:18.344 [docker-java-stream--179718200] db:zookeeper - STDOUT: 2023-01-19 01:20:18,346 [myid:1] - INFO [ContainerManagerTask:ContainerManager@134] - Attempting to delete candidate container: /it_db/lock/exclusive/locks/sys_data_dbshardingspheresharding_table_statistics
[INFO ] 2023-01-19 09:20:18.351 [docker-java-stream--179718200] db:zookeeper - STDOUT: 2023-01-19 01:20:18,353 [myid:1] - INFO [ContainerManagerTask:ContainerManager@134] - Attempting to delete candidate container: /it_db/lock/exclusive/locks/sys_data_dbpg_catalogpg_namespace
```
### Reason analyze (If you can)
<img width="1700" alt="image" src="https://user-images.githubusercontent.com/10829171/213333350-536f738b-2c9d-4f06-8d27-f385ac10be3f.png">
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
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] TeslaCN commented on issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #23643:
URL: https://github.com/apache/shardingsphere/issues/23643#issuecomment-1408085560
--
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] TeslaCN commented on issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #23643:
URL: https://github.com/apache/shardingsphere/issues/23643#issuecomment-1408028191
--
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] TeslaCN commented on issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #23643:
URL: https://github.com/apache/shardingsphere/issues/23643#issuecomment-1585977874
Close via #23865.
--
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] TeslaCN commented on issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #23643:
URL: https://github.com/apache/shardingsphere/issues/23643#issuecomment-1408036112
The default `prepareThreshold` of pgjdbc is `5`. We could set it to `2` or `1` to make the tests cover more codes 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] strongduanmu commented on issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #23643:
URL: https://github.com/apache/shardingsphere/issues/23643#issuecomment-1396323848
When I execute GeneralDQLE2EIT alone, this problem does not occur, so I guess that the incomplete test scenario support in AdditionalDQLE2EIT may cause this exception.
You can search `TODO fix e2e test blocked exception with PostgreSQL or openGuass in #23643` in source code.
--
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] TeslaCN commented on issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #23643:
URL: https://github.com/apache/shardingsphere/issues/23643#issuecomment-1408092254
--
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] boyjoy1127 commented on issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "boyjoy1127 (via GitHub)" <gi...@apache.org>.
boyjoy1127 commented on issue #23643:
URL: https://github.com/apache/shardingsphere/issues/23643#issuecomment-1585969413
Will this issue be completed before June 15 which is the final date of version 5.4.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] TeslaCN closed issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN closed issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
URL: https://github.com/apache/shardingsphere/issues/23643
--
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 closed issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
Posted by "tristaZero (via GitHub)" <gi...@apache.org>.
tristaZero closed issue #23643: E2E test blocks when I execute AdditionalDQLE2EIT and GeneralDQLE2EIT together
URL: https://github.com/apache/shardingsphere/issues/23643
--
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