jtcohen6
commented
2 years ago @hua0129 As mentioned in #40, we've developed a new testing suite to replace the one in this repository. Documentation and details: https://docs.getdbt.com/docs/contributing/testing-a-new-adapter
That new testing suite invokes pytest differently, so that it's easier to interactively debug, and less likely to encounter hanging issues like the one you've identified in this issue.
We won't be able to prioritize any investigations or fixes for the old test suite (the one in this repository).
command: pytest -v -s --log-level=DEBUG test/integration/longdb.dbtspec
hang here: ...
02:17:53.429763 [info ] [MainThread]:
02:17:53.430034 [info ] [MainThread]: Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1 02:17:53.430034 [info ] [MainThread]: Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1 02:17:53.430998 [debug] [MainThread]: Flushing usage events
02:17:53.430998 [debug] [MainThread]: Flushing usage events
Executing step 2/15
Executing step 3/15
Tail of log: ... 02:17:59.682279 [debug] [MainThread]: Connection 'master' was properly closed. 02:17:59.682582 [debug] [MainThread]: longdb adapter: Close connection. 02:17:59.682911 [debug] [MainThread]: Connection 'model.dbt_test_project.view_model' was properly closed. 02:17:59.683202 [debug] [MainThread]: longdb adapter: Close connection. 02:17:59.689768 [info ] [MainThread]: 02:17:59.690323 [info ] [MainThread]: ^[[32mCompleted successfully^[[0m 02:17:59.690793 [info ] [MainThread]: 02:17:59.691093 [info ] [MainThread]: Done. PASS=3 WARN=0 ERROR=0 SKIP=0 TOTAL=3
longdb.dbtspec target: type: longdb port: 1527 database: dbttest{{ var('_dbt_random_suffix') }} schema: dbttest{{ var('_dbt_random_suffix') }} server: "{{ env_var('DBT_LONGDB_SERVER_NAME', 'localhost') }}" username: "{{ env_var('DBT_LONGDB_USERNAME', 'splice') }}" password: "{{ env_var('DBT_LONGDB_PASSWORD', 'admin') }}" clspath: "{{ env_var('DBT_LONGDB_DRIVER_CLASSPATH', 'dbt_driver') }}" driver: "{{ env_var('DBT_LONGDB_DRIVER', 'dbt_driver') }}" threads: 1
sequences:
List of sequences:
https://github.com/dbt-labs/dbt-adapter-tests/tree/main/pytest_dbt_adapter/sequences
test_dbt_empty: empty
test_dbt_base: base
test_dbt_ephemeral: ephemeral
test_dbt_incremental: incremental
test_dbt_snapshot_strategy_timestamp: snapshot_strategy_timestamp
test_dbt_snapshot_strategy_check_cols: snapshot_strategy_check_cols
test_dbt_data_test: data_test
test_dbt_schema_test: schema_test
test_dbt_ephemeral_data_tests: data_test_ephemeral_models
No exceptions, just hang. Help please. Thanks.