ERROR clinical_solutions_tests/integration/features/sqllab/test_sqllab_api.py::TestSQLLabAPI::test__saved_query - sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1105, 'errCode = 2, detailMessage = replication num should be less than the number of available backends. replication num is 1, available backend num is 0')
[SQL: CREATE TABLE IF NOT EXISTS PG_VIEWS.crfs (
id BIGINT,
create_date DATETIME(6),
create_by BIGINT,
create_ip STRING,
update_date DATETIME(6),
update_by BIGINT,
update_ip STRING,
tenant_id BIGINT,
study_id BIGINT,
crf_name STRING,
crf_sas_name STRING,
dynamic_form BOOLEAN,
randomization_crf BOOLEAN,
survey_crf BOOLEAN
)
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Environment:
image: apache/doris:fe-3.0.7
image: apache/doris:be-3.0.7
Problem Description:
When running Doris in Docker for automated testing, the container intermittently fails to be fully operational despite health checks indicating it's ready. Tests pass consistently in local environment but fail sporadically in GitHub Actions CI pipeline.
Example of error, when i am trying to execute any sql:
docker-compose.test.yaml
Makefile.test.txt
backend-tests.yml