search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.78k stars 6.7k forks source link

There may be many H2 cases run in Proxy Standalone integration tests #21958

Closed TeslaCN closed 2 months ago

TeslaCN commented 1 year ago

Integration tests

Which version of ShardingSphere did you use?

9b046d579f107d916fdfc480ce91e2230f6c984c

Expected behavior

No H2 cases run in Proxy Standalone MySQL integration tests.

Actual behavior

If it did run H2 cases in Proxy integration tests, it will be a waste of time and resources.

Part of logs:

[INFO] Scanning for projects...
[INFO] ------------------------------------------------------------------------
[INFO] Detecting the operating system and CPU architecture
[INFO] ------------------------------------------------------------------------
[INFO] os.detected.name: linux
[INFO] os.detected.arch: x86_64
[INFO] os.detected.version: 5.15
[INFO] os.detected.version.major: 5
[INFO] os.detected.version.minor: 15
[INFO] os.detected.release: ubuntu
[INFO] os.detected.release.version: 22.04
[INFO] os.detected.release.like.ubuntu: true
[INFO] os.detected.release.like.debian: true
[INFO] os.detected.classifier: linux-x86_64
[INFO] 
[INFO] --< org.apache.shardingsphere:shardingsphere-integration-test-suite >---
[INFO] Building shardingsphere-integration-test-suite 5.2.2-SNAPSHOT
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- maven-clean-plugin:3.1.0:clean (default-clean) @ shardingsphere-integration-test-suite ---
[INFO] Deleting /home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/target
[INFO] 
[INFO] --- maven-enforcer-plugin:3.0.0:enforce (enforce-maven-version) @ shardingsphere-integration-test-suite ---
[INFO] 
[INFO] --- maven-enforcer-plugin:3.0.0:enforce (enforce-banned-dependencies) @ shardingsphere-integration-test-suite ---
[INFO] 
[INFO] --- maven-checkstyle-plugin:3.1.0:check (validate) @ shardingsphere-integration-test-suite ---
[INFO] 
[INFO] --- maven-resources-plugin:3.3.0:copy-resources (copy-resources) @ shardingsphere-integration-test-suite ---
[INFO] Copying 924 resources
[INFO] The encoding used to copy filtered properties files have not been set. This means that the same encoding will be used to copy filtered properties files as when copying other filtered resources. This might not be what you want! Run your build with --debug to see which files might be affected. Read more at https://maven.apache.org/plugins/maven-resources-plugin/examples/filtering-properties-files.html
[INFO] 
[INFO] --- jacoco-maven-plugin:0.8.8:prepare-agent (default) @ shardingsphere-integration-test-suite ---
[INFO] argLine set to -javaagent:/home/wuweijie/.m2/repository/org/jacoco/org.jacoco.agent/0.8.8/org.jacoco.agent-0.8.8-runtime.jar=destfile=/home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/target/jacoco.exec
[INFO] 
[INFO] --- maven-remote-resources-plugin:1.5:process (process-resource-bundles) @ shardingsphere-integration-test-suite ---
[INFO] 
[INFO] --- maven-resources-plugin:3.3.0:resources (default-resources) @ shardingsphere-integration-test-suite ---
[INFO] skip non existing resourceDirectory /home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/src/main/resources
[INFO] Copying 3 resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.8.0:compile (default-compile) @ shardingsphere-integration-test-suite ---
[INFO] No sources to compile
[INFO] 
[INFO] --- spotless-maven-plugin:2.22.1:apply (default) @ shardingsphere-integration-test-suite ---
[INFO] Sorting file /tmp/pom3302798861740941905.xml
[INFO] Saved sorted pom file to /tmp/pom3302798861740941905.xml
[INFO] 
[INFO] --- maven-resources-plugin:3.3.0:testResources (default-testResources) @ shardingsphere-integration-test-suite ---
[INFO] Copying 924 resources
[INFO] Copying 3 resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.8.0:testCompile (default-testCompile) @ shardingsphere-integration-test-suite ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 64 source files to /home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/target/test-classes
[INFO] /home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/runner/parallel/ParameterizedParallelRunnerScheduler.java: /home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/runner/parallel/ParameterizedParallelRunnerScheduler.java uses unchecked or unsafe operations.
[INFO] /home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/runner/parallel/ParameterizedParallelRunnerScheduler.java: Recompile with -Xlint:unchecked for details.
[INFO] 
[INFO] --- maven-surefire-plugin:3.0.0-M7:test (default-test) @ shardingsphere-integration-test-suite ---
[INFO] Using auto detected provider org.apache.maven.surefire.junitplatform.JUnitPlatformProvider
[INFO] 
[INFO] -------------------------------------------------------
[INFO]  T E S T S
[INFO] -------------------------------------------------------
[INFO] 
[INFO] Results:
[INFO] 
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0
[INFO] 
[INFO] 
[INFO] --- jacoco-maven-plugin:0.8.8:report (report) @ shardingsphere-integration-test-suite ---
[INFO] Skipping JaCoCo execution due to missing execution data file.
[INFO] 
[INFO] --- maven-jar-plugin:3.2.0:jar (default-jar) @ shardingsphere-integration-test-suite ---
[INFO] Building jar: /home/wuweijie/projects/shardingsphere/test/integration-test/test-suite/target/shardingsphere-integration-test-suite-5.2.2-SNAPSHOT.jar
[INFO] 
[INFO] --- maven-javadoc-plugin:3.3.0:jar (attach-javadocs) @ shardingsphere-integration-test-suite ---
[INFO] 
[INFO] --- maven-site-plugin:3.4:attach-descriptor (attach-descriptor) @ shardingsphere-integration-test-suite ---
[INFO] 
[INFO] --- maven-failsafe-plugin:2.22.0:integration-test (integration-tests) @ shardingsphere-integration-test-suite ---
[INFO] 
[INFO] -------------------------------------------------------
[INFO]  T E S T S
[INFO] -------------------------------------------------------
[INFO] Running JUnit Vintage
[INFO ] 2022-11-04 16:24:19.836 [main] o.t.utility.ImageNameSubstitutor - Image name substitution will be performed by: DefaultImageNameSubstitutor (composite of 'ConfigurationFileImageNameSubstitutor' and 'PrefixingImageNameSubstitutor')
[INFO ] 2022-11-04 16:24:19.860 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW STORAGE UNITS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:19.886 [main] o.t.d.DockerClientProviderStrategy - Loaded org.testcontainers.dockerclient.UnixSocketClientProviderStrategy from ~/.testcontainers.properties, will try it first
[INFO ] 2022-11-04 16:24:20.481 [main] o.t.d.DockerClientProviderStrategy - Found Docker environment with local Unix socket (unix:///var/run/docker.sock)
[INFO ] 2022-11-04 16:24:20.483 [main] o.testcontainers.DockerClientFactory - Docker host IP address is localhost
[INFO ] 2022-11-04 16:24:20.499 [main] o.testcontainers.DockerClientFactory - Connected to docker: 
  Server Version: 20.10.21
  API Version: 1.41
  Operating System: Ubuntu 22.04.1 LTS
  Total Memory: 30971 MB
[INFO ] 2022-11-04 16:24:20.540 [main] 🐳 [testcontainers/ryuk:0.3.3] - Creating container for image: testcontainers/ryuk:0.3.3
[INFO ] 2022-11-04 16:24:20.665 [main] 🐳 [testcontainers/ryuk:0.3.3] - Container testcontainers/ryuk:0.3.3 is starting: 24a024792db59d6d21b150a67d23c82f4bf9eb160afa2162a0c60c8c127d8d5a
[INFO ] 2022-11-04 16:24:21.035 [main] 🐳 [testcontainers/ryuk:0.3.3] - Container testcontainers/ryuk:0.3.3 started in PT0.524101S
[INFO ] 2022-11-04 16:24:21.039 [main] o.t.utility.RyukResourceReaper - Ryuk started - will monitor and terminate Testcontainers containers on JVM exit
[INFO ] 2022-11-04 16:24:21.039 [main] o.testcontainers.DockerClientFactory - Checking the system...
[INFO ] 2022-11-04 16:24:21.040 [main] o.testcontainers.DockerClientFactory - ✔︎ Docker server version should be at least 1.6.0
[INFO ] 2022-11-04 16:24:21.045 [main] 🐳 [mysql/mysql-server:5.7] - Creating container for image: mysql/mysql-server:5.7
[INFO ] 2022-11-04 16:24:21.238 [main] 🐳 [mysql/mysql-server:5.7] - Container mysql/mysql-server:5.7 is starting: 6d1f35708a36e2ffba5810d709897ecb4b816c771a727df7dfe4c1a5fa7ab3a6
[INFO ] 2022-11-04 16:24:21.528 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] MySQL Docker Image 5.7.36-1.2.6-server
[INFO ] 2022-11-04 16:24:21.577 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] Initializing database
[INFO ] 2022-11-04 16:24:21.585 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.583587Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[INFO ] 2022-11-04 16:24:21.586 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.583641Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
[INFO ] 2022-11-04 16:24:21.699 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.699131Z 0 [Warning] InnoDB: New log files created, LSN=45790
[INFO ] 2022-11-04 16:24:21.727 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.726835Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
[INFO ] 2022-11-04 16:24:21.733 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.733251Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 15764ae1-5c1a-11ed-8cf2-0242ac130002.
[INFO ] 2022-11-04 16:24:21.734 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.734250Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
[INFO ] 2022-11-04 16:24:21.799 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.799114Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
[INFO ] 2022-11-04 16:24:21.799 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.799133Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
[INFO ] 2022-11-04 16:24:21.800 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.799483Z 0 [Warning] CA certificate ca.pem is self signed.
[INFO ] 2022-11-04 16:24:21.813 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:21.812775Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[INFO ] 2022-11-04 16:24:23.710 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] Database initialized
[INFO ] 2022-11-04 16:24:23.871 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.868996Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[INFO ] 2022-11-04 16:24:23.871 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.869084Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
[INFO ] 2022-11-04 16:24:23.872 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.869756Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory.
[INFO ] 2022-11-04 16:24:23.872 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.869791Z 0 [Note] mysqld (mysqld 5.7.36-log) starting as process 50 ...
[INFO ] 2022-11-04 16:24:23.872 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872221Z 0 [Note] InnoDB: PUNCH HOLE support available
[INFO ] 2022-11-04 16:24:23.872 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872247Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
[INFO ] 2022-11-04 16:24:23.872 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872251Z 0 [Note] InnoDB: Uses event mutexes
[INFO ] 2022-11-04 16:24:23.872 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872255Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
[INFO ] 2022-11-04 16:24:23.872 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872260Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
[INFO ] 2022-11-04 16:24:23.873 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872265Z 0 [Note] InnoDB: Using Linux native AIO
[INFO ] 2022-11-04 16:24:23.873 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872493Z 0 [Note] InnoDB: Number of pools: 1
[INFO ] 2022-11-04 16:24:23.873 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.872555Z 0 [Note] InnoDB: Using CPU crc32 instructions
[INFO ] 2022-11-04 16:24:23.873 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.873386Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
[INFO ] 2022-11-04 16:24:23.877 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.877004Z 0 [Note] InnoDB: Completed initialization of buffer pool
[INFO ] 2022-11-04 16:24:23.878 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.878019Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
[INFO ] 2022-11-04 16:24:23.889 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.889171Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
[INFO ] 2022-11-04 16:24:23.894 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.893814Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
[INFO ] 2022-11-04 16:24:23.894 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.893869Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[INFO ] 2022-11-04 16:24:23.905 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.904794Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
[INFO ] 2022-11-04 16:24:23.905 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.905422Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
[INFO ] 2022-11-04 16:24:23.905 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.905430Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
[INFO ] 2022-11-04 16:24:23.905 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.905709Z 0 [Note] InnoDB: Waiting for purge to start
[INFO ] 2022-11-04 16:24:23.956 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.955877Z 0 [Note] InnoDB: 5.7.36 started; log sequence number 2749723
[INFO ] 2022-11-04 16:24:23.956 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.956026Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
[INFO ] 2022-11-04 16:24:23.956 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.956181Z 0 [Note] Plugin 'FEDERATED' is disabled.
[INFO ] 2022-11-04 16:24:23.957 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.957162Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221104  8:24:23
[INFO ] 2022-11-04 16:24:23.963 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.962710Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
[INFO ] 2022-11-04 16:24:23.963 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.962723Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
[INFO ] 2022-11-04 16:24:23.963 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.962727Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
[INFO ] 2022-11-04 16:24:23.963 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.962730Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
[INFO ] 2022-11-04 16:24:23.963 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.963081Z 0 [Warning] CA certificate ca.pem is self signed.
[INFO ] 2022-11-04 16:24:23.964 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.963104Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
[INFO ] 2022-11-04 16:24:23.966 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.966363Z 0 [Note] Failed to start slave threads for channel ''
[INFO ] 2022-11-04 16:24:23.969 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.969566Z 0 [Note] Event Scheduler: Loaded 0 events
[INFO ] 2022-11-04 16:24:23.970 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:23.969729Z 0 [Note] mysqld: ready for connections.
[INFO ] 2022-11-04 16:24:23.970 [docker-java-stream--112742646] db:mysql - STDERR: Version: '5.7.36-log'  socket: '/var/lib/mysql/mysql.sock'  port: 0  MySQL Community Server (GPL)
[INFO ] 2022-11-04 16:24:24.236 [docker-java-stream--112742646] db:mysql - STDERR: Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
[INFO ] 2022-11-04 16:24:24.236 [docker-java-stream--112742646] db:mysql - STDERR: Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
[INFO ] 2022-11-04 16:24:24.727 [docker-java-stream--112742646] db:mysql - STDERR: Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
[INFO ] 2022-11-04 16:24:24.727 [docker-java-stream--112742646] db:mysql - STDERR: Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
[INFO ] 2022-11-04 16:24:24.727 [docker-java-stream--112742646] db:mysql - STDERR: Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[INFO ] 2022-11-04 16:24:24.749 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] GENERATED ROOT PASSWORD: u1PM5@f:70@uwvDg&n7B+Q/L3,Q9C_0W
[INFO ] 2022-11-04 16:24:24.755 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:24.755 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] running /docker-entrypoint-initdb.d/00-init-authority.sql
[INFO ] 2022-11-04 16:24:24.759 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:24.759 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:24.759 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] running /docker-entrypoint-initdb.d/01-actual-init.sql
[INFO ] 2022-11-04 16:24:25.144 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:25.144 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:25.144 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] running /docker-entrypoint-initdb.d/01-expected-init.sql
[INFO ] 2022-11-04 16:24:25.268 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:25.268 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:25.272 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.271587Z 0 [Note] Giving 0 client threads a chance to die gracefully
[INFO ] 2022-11-04 16:24:25.272 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.271608Z 0 [Note] Shutting down slave threads
[INFO ] 2022-11-04 16:24:25.272 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.271613Z 0 [Note] Forcefully disconnecting 0 remaining clients
[INFO ] 2022-11-04 16:24:25.272 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.271617Z 0 [Note] Event Scheduler: Purging the queue. 0 events
[INFO ] 2022-11-04 16:24:25.272 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.271660Z 0 [Note] Binlog end
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273002Z 0 [Note] Shutting down plugin 'ngram'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273011Z 0 [Note] Shutting down plugin 'partition'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273013Z 0 [Note] Shutting down plugin 'BLACKHOLE'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273017Z 0 [Note] Shutting down plugin 'ARCHIVE'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273019Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273046Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273051Z 0 [Note] Shutting down plugin 'MyISAM'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273055Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273057Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273058Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
[INFO ] 2022-11-04 16:24:25.273 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273060Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273061Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273062Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273063Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273065Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273067Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273069Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273070Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273071Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273072Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273073Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273075Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273077Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273078Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273080Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
[INFO ] 2022-11-04 16:24:25.274 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273081Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273082Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273085Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273086Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273087Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273089Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273090Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273091Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273093Z 0 [Note] Shutting down plugin 'INNODB_CMP'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273094Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273095Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273097Z 0 [Note] Shutting down plugin 'INNODB_TRX'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273098Z 0 [Note] Shutting down plugin 'InnoDB'
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273141Z 0 [Note] InnoDB: FTS optimize thread exiting.
[INFO ] 2022-11-04 16:24:25.275 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.273199Z 0 [Note] InnoDB: Starting shutdown...
[INFO ] 2022-11-04 16:24:25.373 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.373366Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
[INFO ] 2022-11-04 16:24:25.374 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:25.373622Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 221104  8:24:25
[INFO ] 2022-11-04 16:24:26.881 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.881252Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12666362
[INFO ] 2022-11-04 16:24:26.882 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.882460Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
[INFO ] 2022-11-04 16:24:26.882 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.882472Z 0 [Note] Shutting down plugin 'MEMORY'
[INFO ] 2022-11-04 16:24:26.883 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.882477Z 0 [Note] Shutting down plugin 'CSV'
[INFO ] 2022-11-04 16:24:26.883 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.882480Z 0 [Note] Shutting down plugin 'sha256_password'
[INFO ] 2022-11-04 16:24:26.883 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.882482Z 0 [Note] Shutting down plugin 'mysql_native_password'
[INFO ] 2022-11-04 16:24:26.883 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.882582Z 0 [Note] Shutting down plugin 'binlog'
[INFO ] 2022-11-04 16:24:26.884 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:26.884001Z 0 [Note] mysqld: Shutdown complete
[INFO ] 2022-11-04 16:24:26.884 [docker-java-stream--112742646] db:mysql - STDERR: 
[INFO ] 2022-11-04 16:24:27.274 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] Server shut down
[INFO ] 2022-11-04 16:24:27.274 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:27.274 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] MySQL init process done. Ready for start up.
[INFO ] 2022-11-04 16:24:27.274 [docker-java-stream--112742646] db:mysql - STDOUT: 
[INFO ] 2022-11-04 16:24:27.276 [docker-java-stream--112742646] db:mysql - STDOUT: [Entrypoint] Starting MySQL 5.7.36-1.2.6-server
[INFO ] 2022-11-04 16:24:27.432 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.429949Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[INFO ] 2022-11-04 16:24:27.432 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.430003Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
[INFO ] 2022-11-04 16:24:27.432 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.430677Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory.
[INFO ] 2022-11-04 16:24:27.432 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.430714Z 0 [Note] mysqld (mysqld 5.7.36-log) starting as process 1 ...
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.432992Z 0 [Note] InnoDB: PUNCH HOLE support available
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433012Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433015Z 0 [Note] InnoDB: Uses event mutexes
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433018Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433021Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433024Z 0 [Note] InnoDB: Using Linux native AIO
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433212Z 0 [Note] InnoDB: Number of pools: 1
[INFO ] 2022-11-04 16:24:27.433 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433262Z 0 [Note] InnoDB: Using CPU crc32 instructions
[INFO ] 2022-11-04 16:24:27.434 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.433962Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
[INFO ] 2022-11-04 16:24:27.437 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.437478Z 0 [Note] InnoDB: Completed initialization of buffer pool
[INFO ] 2022-11-04 16:24:27.438 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.438455Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
[INFO ] 2022-11-04 16:24:27.450 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.449743Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
[INFO ] 2022-11-04 16:24:27.456 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.456421Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
[INFO ] 2022-11-04 16:24:27.457 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.456484Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[INFO ] 2022-11-04 16:24:27.476 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.475589Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
[INFO ] 2022-11-04 16:24:27.476 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.476260Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
[INFO ] 2022-11-04 16:24:27.476 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.476271Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
[INFO ] 2022-11-04 16:24:27.476 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.476563Z 0 [Note] InnoDB: Waiting for purge to start
[INFO ] 2022-11-04 16:24:27.527 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.526733Z 0 [Note] InnoDB: 5.7.36 started; log sequence number 12666362
[INFO ] 2022-11-04 16:24:27.527 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.526895Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
[INFO ] 2022-11-04 16:24:27.527 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.527041Z 0 [Note] Plugin 'FEDERATED' is disabled.
[INFO ] 2022-11-04 16:24:27.530 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.529918Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221104  8:24:27
[INFO ] 2022-11-04 16:24:27.533 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.533582Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.533592Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.533596Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.533599Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.533963Z 0 [Warning] CA certificate ca.pem is self signed.
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.533985Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.534169Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.534197Z 0 [Note] IPv6 is available.
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.534207Z 0 [Note]   - '::' resolves to '::';
[INFO ] 2022-11-04 16:24:27.534 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.534217Z 0 [Note] Server socket created on IP: '::'.
[INFO ] 2022-11-04 16:24:27.538 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.538518Z 0 [Note] Failed to start slave threads for channel ''
[INFO ] 2022-11-04 16:24:27.541 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.541408Z 0 [Note] Event Scheduler: Loaded 0 events
[INFO ] 2022-11-04 16:24:27.541 [docker-java-stream--112742646] db:mysql - STDERR: 2022-11-04T08:24:27.541576Z 0 [Note] mysqld: ready for connections.
[INFO ] 2022-11-04 16:24:27.542 [docker-java-stream--112742646] db:mysql - STDERR: Version: '5.7.36-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
[INFO ] 2022-11-04 16:24:27.823 [main] 🐳 [mysql/mysql-server:5.7] - Container mysql/mysql-server:5.7 started in PT6.777863925S
[INFO ] 2022-11-04 16:24:51.643 [main] 🐳 [apache/shardingsphere-proxy-test:latest] - Creating container for image: apache/shardingsphere-proxy-test:latest
[INFO ] 2022-11-04 16:24:51.709 [main] 🐳 [apache/shardingsphere-proxy-test:latest] - Container apache/shardingsphere-proxy-test:latest is starting: ef7ff959e48f74dbcdab27a47368214e7aa3d7e42e23073ef2aa0c082bbd1a04
[INFO ] 2022-11-04 16:24:52.008 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: Starting the ShardingSphere-Proxy ...
[INFO ] 2022-11-04 16:24:52.009 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: The classpath is /opt/shardingsphere-proxy/conf:.:/opt/shardingsphere-proxy/lib/*:/opt/shardingsphere-proxy/ext-lib/*
[INFO ] 2022-11-04 16:24:53.006 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: Please check the STDOUT file: /opt/shardingsphere-proxy/logs/stdout.log

...... omit some logs

[INFO ] 2022-11-04 16:24:55.009 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:54.812 [main] o.a.s.p.v.ShardingSphereProxyVersion - Database name is `MySQL`, version is `5.7.36-log`, database name is `db`
[INFO ] 2022-11-04 16:24:56.007 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:55.081 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f] REGISTERED
[INFO ] 2022-11-04 16:24:56.008 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:55.082 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f] BIND: /0.0.0.0:3307
[INFO ] 2022-11-04 16:24:56.008 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:55.083 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy Standalone mode started successfully
[INFO ] 2022-11-04 16:24:56.008 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:55.084 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f, L:/0.0.0.0:3307] ACTIVE
[INFO ] 2022-11-04 16:24:57.007 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:56.032 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f, L:/0.0.0.0:3307] READ: [id: 0x4354378c, L:/172.19.0.3:3307 - R:/172.19.0.1:42776]
[INFO ] 2022-11-04 16:24:57.007 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:56.035 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 2022-11-04 16:24:57.349 [main] 🐳 [apache/shardingsphere-proxy-test:latest] - Container apache/shardingsphere-proxy-test:latest started in PT5.716374429S
[INFO ] 2022-11-04 16:24:57.920 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW STORAGE UNITS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:57.928 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.007 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:57.365 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f, L:/0.0.0.0:3307] READ: [id: 0x9b0b16eb, L:/172.19.0.3:3307 - R:/172.19.0.1:42778]
[INFO ] 2022-11-04 16:24:58.007 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:57.365 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 2022-11-04 16:24:58.007 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:57.493 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f, L:/0.0.0.0:3307] READ: [id: 0x5816a199, L:/172.19.0.3:3307 - R:/172.19.0.1:42780]
[INFO ] 2022-11-04 16:24:58.007 [docker-java-stream--1103693496] db:ShardingSphere-Proxy - STDOUT: [INFO ] 2022-11-04 08:24:57.494 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xdaae251f, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 2022-11-04 16:24:58.052 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.057 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULE t_order](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.063 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULE t_order](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.067 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING ALGORITHMS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.076 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING ALGORITHMS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.085 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW UNUSED SHARDING ALGORITHMS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.093 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW UNUSED SHARDING ALGORITHMS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.097 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES USED ALGORITHM it_standard_fixture](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.105 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES USED ALGORITHM it_standard_fixture](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.109 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING AUDITORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.114 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING AUDITORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.117 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING KEY GENERATORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.122 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING KEY GENERATORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.125 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW UNUSED SHARDING KEY GENERATORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.131 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW UNUSED SHARDING KEY GENERATORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.135 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW UNUSED SHARDING AUDITORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.141 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW UNUSED SHARDING AUDITORS](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.144 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES USED KEY GENERATOR constant](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.151 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES USED KEY GENERATOR constant](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.155 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES USED AUDITOR auditor_constant](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.161 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE RULES USED AUDITOR auditor_constant](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.166 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW DEFAULT SHARDING STRATEGY](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.172 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW DEFAULT SHARDING STRATEGY](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.176 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE NODES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.184 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE NODES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.189 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE REFERENCE RULES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.199 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SHARDING TABLE REFERENCE RULES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.203 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW BROADCAST TABLE RULES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.209 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW BROADCAST TABLE RULES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.213 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW DEFAULT SINGLE TABLE STORAGE UNIT](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.216 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW DEFAULT SINGLE TABLE STORAGE UNIT](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.219 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SINGLE TABLE t_single_table](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.225 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SINGLE TABLE t_single_table](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.229 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> SHOW SINGLE TABLES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.232 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> SHOW SINGLE TABLES](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.236 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[proxy: db -> MySQL -> Literal -> COUNT SINGLE_TABLE RULE](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.240 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[proxy: db -> MySQL -> Literal -> COUNT SINGLE_TABLE RULE](org.apache.shardingsphere.test.integration.engine.rql.GeneralRQLIT)
[INFO ] 2022-11-04 16:24:58.250 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecuteQuery[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:24:59.688 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/home/wuweijie/.m2/repository/com/atomikos/transactions/5.0.9/transactions-5.0.9.jar!/transactions-defaults.properties
[INFO ] 2022-11-04 16:24:59.689 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/home/wuweijie/.m2/repository/org/apache/shardingsphere/shardingsphere-transaction-xa-atomikos/5.2.2-SNAPSHOT/shardingsphere-transaction-xa-atomikos-5.2.2-SNAPSHOT.jar!/transactions.properties
[WARN ] 2022-11-04 16:24:59.694 [main] c.a.icatch.provider.imp.AssemblerImp - Thanks for using Atomikos! This installation is not registered yet. 
REGISTER FOR FREE at http://www.atomikos.com/Main/RegisterYourDownload and receive:
- tips & advice 
- working demos 
- access to the full documentation 
- special exclusive bonus offers not available to others 
- everything you need to get the most out of using Atomikos!
Thanks for using Atomikos! This installation is not registered yet. 
REGISTER FOR FREE at http://www.atomikos.com/Main/RegisterYourDownload and receive:
- tips & advice 
- working demos 
- access to the full documentation 
- special exclusive bonus offers not available to others 
- everything you need to get the most out of using Atomikos!
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING core version: 5.0.9
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.tm_unique_name = 127.0.1.1.tm
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.allow_subtransactions = true
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.jvm_id = 2187248@wuweijie-ubuntu
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.throw_on_heuristic = false
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.enable_logging = true
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_timeout = 300000
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 300000
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.logcloud_datasource_name = logCloudDS
[INFO ] 2022-11-04 16:24:59.700 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_actives = 10000
[INFO ] 2022-11-04 16:24:59.701 [main] c.a.icatch.provider.imp.AssemblerImp - Using default (local) logging and recovery...
[INFO ] 2022-11-04 16:25:01.170 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecuteQuery[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.171 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.174 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.175 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecuteQuery[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.178 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecuteQuery[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.178 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.180 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[jdbc: db -> H2 -> Literal -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.181 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecuteQuery[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.196 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecuteQuery[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.197 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.200 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.200 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecuteQuery[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.202 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecuteQuery[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.202 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.204 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecute[jdbc: db -> H2 -> Placeholder -> SELECT t_order.* FROM t_order t_order WHERE user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.204 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecuteQuery[jdbc: db -> H2 -> Literal -> SELECT t_order.order_id,t_order.user_id,status FROM t_order t_order WHERE t_order.user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.212 [main] o.a.s.t.i.f.watcher.ITWatcher - succeeded assertExecuteQuery[jdbc: db -> H2 -> Literal -> SELECT t_order.order_id,t_order.user_id,status FROM t_order t_order WHERE t_order.user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)
[INFO ] 2022-11-04 16:25:01.212 [main] o.a.s.t.i.f.watcher.ITWatcher - starting assertExecute[jdbc: db -> H2 -> Literal -> SELECT t_order.order_id,t_order.user_id,status FROM t_order t_order WHERE t_order.user_id = ? AND order_id = ?](org.apache.shardingsphere.test.integration.engine.dql.GeneralDQLIT)

Omit the rest of logs......

Reason analyze (If you can)

https://github.com/apache/shardingsphere/blob/b8afbeb52da3efaaf72ece36f2d6cdaea0f4cfc7/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/param/array/ParameterizedArrayFactory.java#L51

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

I print the test description in TestWatcher.

diff --git a/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/watcher/ITWatcher.java b/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/watcher/ITWatcher.java
index f6fa257bdd2..ef7a86d8526 100644
--- a/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/watcher/ITWatcher.java
+++ b/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/watcher/ITWatcher.java
@@ -30,6 +30,18 @@ import java.io.PrintStream;
 @Slf4j
 public final class ITWatcher extends TestWatcher {

+    @Override
+    protected void starting(final Description description) {
+        super.starting(description);
+        log.info("starting {}", description.getDisplayName());
+    }
+    
+    @Override
+    protected void succeeded(final Description description) {
+        super.succeeded(description);
+        log.info("succeeded {}", description.getDisplayName());
+    }
+    
     @Override
     protected void failed(final Throwable cause, final Description description) {
         log.error("Error case: {}, message: {}", description.getMethodName(), getStackTrace(cause));
diff --git a/test/integration-test/test-suite/src/test/resources/logback-test.xml b/test/integration-test/test-suite/src/test/resources/logback-test.xml
index c7fbb061cd7..c8f8633271a 100644
--- a/test/integration-test/test-suite/src/test/resources/logback-test.xml
+++ b/test/integration-test/test-suite/src/test/resources/logback-test.xml
@@ -25,6 +25,9 @@
     <logger name="org.apache.shardingsphere" level="warn" additivity="true">
         <appender-ref ref="console" />
     </logger>
+    <logger name="org.apache.shardingsphere.test.integration.framework.watcher.ITWatcher" level="info" additivity="false">

Then run tests:

mvn clean install -pl test/integration-test/test-suite -Dit.run.modes=Standalone -Dit.cluster.databases=MySQL -Dit.cluster.adapters=proxy -Dit.scenarios=db -Dit.cluster.env.type=DOCKER -l /tmp/standalone_proxy_mysql.log
TeslaCN commented 1 year ago

Possibly related to

github-actions[bot] commented 5 months ago

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.