“pytest -v -s” hang after 3/15

[hua0129]

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: dbt_test_{{ var('dbt_random_suffix') }}
schema: dbt_test{{ 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.

[jtcohen6]

@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).