[
https://issues.apache.org/jira/browse/SPARK-46592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated SPARK-46592:
-----------------------------------
Labels: pull-request-available (was: )
> 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
> 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
