Kent Yao created SPARK-46592:
--------------------------------
Summary: OracleIntegrationSuite is flaky because of ORA-04021
Key: SPARK-46592
URL: https://issues.apache.org/jira/browse/SPARK-46592
Project: Spark
Issue Type: Test
Components: Spark Docker, Tests
Affects Versions: 4.0.0
Reporter: Kent Yao
{code:java}
24/01/04 04:22:09.270 pool-1-thread-1 INFO OracleIntegrationSuite:
===== CONTAINER LOGS FOR container Id:
CreateContainerResponse(id=a57f47c6c42f6307ab855bb6f940b97a046b23ea41607d9742e2c32fbe6aea19,
warnings=[]) =====24/01/04 04:22:09.272 pool-1-thread-1 INFO
OracleIntegrationSuite:
===== END OF CONTAINER LOGS FOR container Id:
CreateContainerResponse(id=a57f47c6c42f6307ab855bb6f940b97a046b23ea41607d9742e2c32fbe6aea19,
warnings=[]) =====24/01/04 04:22:09.275 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: CONTAINER: starting up...24/01/04 04:22:09.275
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: CONTAINER:
first database startup, initializing...24/01/04 04:22:09.275
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: CONTAINER:
uncompressing database data files, please wait...24/01/04 04:22:09.275
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: CONTAINER:
done uncompressing database data files, duration: 7 seconds.24/01/04
04:22:09.275 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
CONTAINER: starting up Oracle Database...24/01/04 04:22:09.276
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: 24/01/04
04:22:09.276 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 04-JAN-2024
04:15:1524/01/04 04:22:09.276 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: 24/01/04 04:22:09.276
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Copyright (c)
1991, 2023, Oracle. All rights reserved.24/01/04 04:22:09.277
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: 24/01/04
04:22:09.277 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Starting /opt/oracle/product/23c/dbhomeFree/bin/tnslsnr: please wait...24/01/04
04:22:09.277 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
24/01/04 04:22:09.277 docker-java-stream-568158377 INFO OracleIntegrationSuite:
STDOUT: TNSLSNR for Linux: Version 23.0.0.0.0 - Production24/01/04 04:22:09.277
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: System
parameter file is
/opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora24/01/04
04:22:09.278 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Log messages written to
/opt/oracle/diag/tnslsnr/a57f47c6c42f/listener/alert/log.xml24/01/04
04:22:09.278 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_FREE)))24/01/04
04:22:09.278 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))24/01/04
04:22:09.278 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
24/01/04 04:22:09.279 docker-java-stream-568158377 INFO OracleIntegrationSuite:
STDOUT: Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_FREE)))24/01/04
04:22:09.279 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
STATUS of the LISTENER24/01/04 04:22:09.279 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: ------------------------24/01/04 04:22:09.279
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Alias
LISTENER24/01/04 04:22:09.279 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: Version TNSLSNR for Linux:
Version 23.0.0.0.0 - Production24/01/04 04:22:09.279
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Start Date
04-JAN-2024 04:15:1724/01/04 04:22:09.280
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Uptime
0 days 0 hr. 0 min. 1 sec24/01/04 04:22:09.280
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Trace Level
off24/01/04 04:22:09.280 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: Security ON: Local OS
Authentication24/01/04 04:22:09.280 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: SNMP OFF24/01/04
04:22:09.280 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Default Service FREE24/01/04 04:22:09.281
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Listener
Parameter File
/opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora24/01/04
04:22:09.281 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Listener Log File
/opt/oracle/diag/tnslsnr/a57f47c6c42f/listener/alert/log.xml24/01/04
04:22:09.281 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Listening Endpoints Summary...24/01/04 04:22:09.281
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_FREE)))24/01/04
04:22:09.281 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))24/01/04
04:22:09.281 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
The listener supports no services24/01/04 04:22:09.282
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: The command
completed successfully24/01/04 04:22:09.282 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: ORACLE instance started.24/01/04 04:22:09.282
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: 24/01/04
04:22:09.282 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Total System Global Area 1603679416 bytes24/01/04 04:22:09.282
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Fixed Size
5313720 bytes24/01/04 04:22:09.283 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: Variable Size 738197504 bytes24/01/04
04:22:09.283 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
Database Buffers 855638016 bytes24/01/04 04:22:09.283
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Redo Buffers
4530176 bytes24/01/04 04:22:09.283 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: Database mounted.24/01/04 04:22:09.283
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Database
opened.24/01/04 04:22:09.283 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: 24/01/04 04:22:09.284
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: CONTAINER:
Resetting SYS and SYSTEM passwords.24/01/04 04:22:09.284
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: 24/01/04
04:22:09.284 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
User altered.24/01/04 04:22:09.284 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: 24/01/04 04:22:09.284
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: ALTER USER
SYSTEM IDENTIFIED BY "Th1s1sThe0racle#Pass"24/01/04 04:22:09.284
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: *24/01/04
04:22:09.284 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
ERROR at line 1:24/01/04 04:22:09.285 docker-java-stream-568158377 INFO
OracleIntegrationSuite: STDOUT: ORA-65048: error encountered when processing
the current DDL statement in24/01/04 04:22:09.285 docker-java-stream-568158377
INFO OracleIntegrationSuite: STDOUT: pluggable database FREEPDB124/01/04
04:22:09.285 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
ORA-04021: timeout occurred while waiting to lock object24/01/04 04:22:09.285
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: Help:
https://docs.oracle.com/error-help/db/ora-65048/24/01/04 04:22:09.285
docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT: 24/01/04
04:22:09.285 docker-java-stream-568158377 INFO OracleIntegrationSuite: STDOUT:
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
