Question When I start a sample with shadow feature, it complains '

When the initEnvironment() method in ShawTest is commented out, directly executi

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

I'm just providing some additional information. In fact, NativeTest und

Shadow sample throws exception 'Table does not exist' about shardingsphere HOT 6 CLOSED

bobbyz007 commented on June 26, 2024

Shadow sample throws exception 'Table does not exist'

from shardingsphere.

Comments (6)

TherChenYang commented on June 26, 2024 1

When the initEnvironment() method in ShawTest is commented out, directly executing selectAll will still result in the same error. When using the shadow module, we do not restrict that table initialization must be done within ShardingSphere.
I think we should load the tables that have already been configured in the configuration file. See PR #31378.

from shardingsphere.

zhaojinchao95 commented on June 26, 2024 1

@bobbyz007 Hello，maybe you should add single configuration. such as:

databaseName: shadow_db

dataSources:
  ds:
    url: jdbc:mysql://127.0.0.1:3306/ds?useSSL=false
    username: root
    password: 123456
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1
  ds_shadow:
    url: jdbc:mysql://127.0.0.1:3306/ds_shadow?useSSL=false
    username: root
    password: 123456
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1

rules:
  - !SINGLE
    tables:
      - "*.*"
  - !SHADOW
    dataSources:
      shadowDataSource:
        productionDataSourceName: ds
        shadowDataSourceName: ds_shadow
    tables:
      t_user:
        dataSourceNames:
          - shadowDataSource
        shadowAlgorithmNames:
          - user_id_insert_match_algorithm
          - user_id_delete_match_algorithm
          - user_id_select_match_algorithm
          - sql_hint_algorithm
    shadowAlgorithms:
      user_id_insert_match_algorithm:
        type: REGEX_MATCH
        props:
          operation: insert
          column: user_type
          regex: "[1]"
      user_id_delete_match_algorithm:
        type: REGEX_MATCH
        props:
          operation: delete
          column: user_type
          regex: "[1]"
      user_id_select_match_algorithm:
        type: REGEX_MATCH
        props:
          operation: select
          column: user_type
          regex: "[1]"
      sql_hint_algorithm:
        type: SQL_HINT

from shardingsphere.

TherChenYang commented on June 26, 2024

@bobbyz007 Thank you for your feedback, I have verified the same issue in master, and will investigate this issue and provide a response.

from shardingsphere.