8000 Tests stability · Issue #21 · postgrespro/pg_query_state · GitHub
[go: up one dir, main page]

Skip to content
Tests stability #21
Closed
Closed
@ololobus

Description

@ololobus

There are two types of errors occurring from time to time when running docker tests.

  1. Assertion failure with basic python tests:
test when two backends compete with each other to extract state from third running backend...
ok!
test statistics under calling function...
[(9429, 0, 'select * from n_join_foo_bar()', 'Function Scan on n_join_foo_bar (Current loop: actual rows=0, loop number=1)', None)]
Traceback (most recent call last):
  File "tests/pg_qs_test_runner.py", line 129, in <module>
    main(args)
  File "tests/pg_qs_test_runner.py", line 112, in main
    test(conn_params)
  File "/pg/testdir/tests/test_cases.py", line 122, in test_nested_call
    assert len(qs) == 2 \
AssertionError
  1. And division by zero with TPC-DS:
Database is setup successfully
Starting stress test
Preparing TPC-DS queries...
Starting TPC-DS queries...
 91% (94 of 103) |##############################################################################################################################################################                | Elapsed Time: 0:01:06 ETA:   0:00:06Traceback (most recent call last):
  File "tests/pg_qs_test_runner.py", line 129, in <module>
    main(args)
  File "tests/pg_qs_test_runner.py", line 98, in main
    tpcds.run_tpcds(conn_params)
  File "/pg/testdir/tests/tpcds.py", line 107, in run_tpcds
    common.wait(acon)
  File "/pg/testdir/tests/common.py", line 17, in wait
    state = conn.poll()
psycopg2.errors.DivisionByZero: division by zero

100% (103 of 103) |#############################################################################################################################################################################| Elapsed Time: 0:01:07 Time:  0:01:07

First one looks like a real issue to fix or at least we have to correct our expectations.

Second one looks like a problem with test infrastructure and does not actually lead to a test failure.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0