apache / apache/camel-quarkus

Intermittent failure of debezium-oracle tests

Open
#7,773 2 comments 0 reactions 0 assignees View on GitHub
area/debezium-oracle area/testing bug flaky-test test
Dominant language
Java
Stars
302
Forks
232
Avg merge
1d 20h
Merged PRs (30d)
114

Description

### Bug description

The container startup seems to hang periodically on GitHub CI. I tried increasing the startup wait timeout to 10 minutes but it didn't help.

The container is supposed to output `DATABASE IS READY TO USE!` but it stops at `Grant succeeded`.

Container logs

```
CONTAINER: starting up...
CONTAINER: first database startup, initializing...
CONTAINER: starting up Oracle Database...

LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 24-SEP-2025 14:16:06

Copyright (c) 1991, 2025, Oracle. All rights reserved.

Starting /opt/oracle/product/23ai/dbhomeFree/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 23.0.0.0.0 - Production
System parameter file is /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/b3d23514ec0c/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_FREE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_FREE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 23.0.0.0.0 - Production
Start Date 24-SEP-2025 14:16:06
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service FREE
Listener Parameter File /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/b3d23514ec0c/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_FREE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The listener supports no services
The command completed successfully
ORACLE instance started.

Total System Global Area 1603293992 bytes
Fixed Size 4928296 bytes
Variable Size 637534208 bytes
Database Buffers 956301312 bytes
Redo Buffers 4530176 bytes
Database mounted.
Database opened.

CONTAINER: Resetting SYS and SYSTEM passwords.

User altered.

User altered.

CONTAINER: Creating new pluggable database 'oracle'.

Pluggable database created.

Pluggable database altered.

Pluggable database altered.

System altered.

CONTAINER: DONE: Pluggable database 'oracle' available, duration: 6 seconds.
CONTAINER: Creating app user for default pluggable database.

Session altered.

User created.

Grant succeeded.

CONTAINER: DONE: Creating app user for default pluggable database.
CONTAINER: Creating app user for pluggable database 'oracle'.

Session altered.

User created.

Grant succeeded.

CONTAINER: DONE: Creating app user for pluggable database 'oracle'.

CONTAINER: Executing user-defined scripts...

CONTAINER: running /docker-entrypoint-initdb.d/init.sql ...

System altered.

System altered.

Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 1603293992 bytes
Fixed Size 4928296 bytes
Variable Size 637534208 bytes
Database Buffers 956301312 bytes
Redo Buffers 4530176 bytes
Database mounted.

Database altered.

Database altered.

Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 17
Next log sequence to archive 17
Current log sequence 16

Database altered.

Tablespace created.

Session altered.

Tablespace created.

Session altered.

Tablespace created.

Session altered.

User created.

Grant succeeded.

Grant succeeded.
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the debezium-oracle test setup and its GitHub CI container logs, then reproduce the startup hang around /docker-entrypoint-initdb.d/init.sql and the final Grant succeeded message. Trace why the container does not reach DATABASE IS READY TO USE!; done means the tests start reliably without intermittent CI hangs.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, github-actions, java
Domain
ci-cd, databases, testing
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.