[ https://issues.apache.org/jira/browse/SPARK-46592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Max Gekk reassigned SPARK-46592: -------------------------------- Assignee: Kent Yao > 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 > Assignee: Kent Yao > Priority: Major > Labels: pull-request-available > > {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