[jira] [Commented] (FLINK-35503) OracleE2eITCase fails with error ORA-12528 on Mac M2
[
https://issues.apache.org/jira/browse/FLINK-35503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17865597#comment-17865597
]
Saketh Kurnool commented on FLINK-35503:
[~gongzhongqiang] [~xiqian_yu] any update on the fix here?
> OracleE2eITCase fails with error ORA-12528 on Mac M2
>
>
> Key: FLINK-35503
> URL: https://issues.apache.org/jira/browse/FLINK-35503
> Project: Flink
> Issue Type: Bug
> Components: Flink CDC
>Affects Versions: cdc-3.1.0
> Environment:
> * Mac M2 (Apple Silicon)
> * using docker desktop with Rosetta enabled for amd64 emulation
>
>Reporter: Saketh Kurnool
>Priority: Blocker
> Attachments: com.ververica.cdc.connectors.tests.OracleE2eITCase.txt,
> oracle-docker-setup-logs.txt
>
>
> Hello Flink CDC community,
> I am attempting to run `OracleE2eITCase` (in the cdc source connector e2e
> tests), and I am running into the following runtime exception:
> {code:java}
> java.sql.SQLException:
> Listener refused the connection with the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
> at
> oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.getOracleJdbcConnection(OracleE2eITCase.java:197)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.testOracleCDC(OracleE2eITCase.java:149)
> at java.base/java.lang.reflect.Method.invoke(Method.java:567)
> at
> org.apache.flink.util.TestNameProvider$1.evaluate(TestNameProvider.java:45)
> at
> org.testcontainers.containers.FailureDetectingExternalResource$1.evaluate(FailureDetectingExternalResource.java:29)
> Caused by: oracle.net.ns.NetException: Listener refused the connection with
> the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
> at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
> at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
> ... 11 more{code}
> I have attached the test results to this issue.
> `OracleE2eITCase` runs the `goodboy008/oracle-19.3.0-ee:non-cdb` docker
> image. I am able to reproduce the same issue when I run this docker image
> locally - my observation is that dockerized Oracle DB instance is not being
> set up properly, as I notice another ORA in the setup logs (`ORA-03113:
> end-of-file on communication channel`). I have also attached the logs from
> the docker image setup to this issue. To reproduce the ORA-12528 issue
> locally, I:
> * ran: `docker run goodboy008/oracle-19.3.0-ee:non-cdb`
> * ssh'ed into the db pod
> * ran: `sqlplus sys/top_secret@//localhost:1521/ORCLCDB as sysdba`
> Any insight/workaround on getting this e2e test and the docker image running
> on my machine would be much appreciated. I'm also happy to provide any other
> information regarding my setup in the comments. Thank you!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Commented] (FLINK-35503) OracleE2eITCase fails with error ORA-12528 on Mac M2
[
https://issues.apache.org/jira/browse/FLINK-35503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17851734#comment-17851734
]
Saketh Kurnool commented on FLINK-35503:
Thank you [~gongzhongqiang], [~xiqian_yu]! Is there a workaround I can use to
get the E2E test/docker image running while you repackage the image?
> OracleE2eITCase fails with error ORA-12528 on Mac M2
>
>
> Key: FLINK-35503
> URL: https://issues.apache.org/jira/browse/FLINK-35503
> Project: Flink
> Issue Type: Bug
> Components: Flink CDC
>Affects Versions: cdc-3.1.0
> Environment:
> * Mac M2 (Apple Silicon)
> * using docker desktop with Rosetta enabled for amd64 emulation
>
>Reporter: Saketh Kurnool
>Priority: Blocker
> Attachments: com.ververica.cdc.connectors.tests.OracleE2eITCase.txt,
> oracle-docker-setup-logs.txt
>
>
> Hello Flink CDC community,
> I am attempting to run `OracleE2eITCase` (in the cdc source connector e2e
> tests), and I am running into the following runtime exception:
> {code:java}
> java.sql.SQLException:
> Listener refused the connection with the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
> at
> oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.getOracleJdbcConnection(OracleE2eITCase.java:197)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.testOracleCDC(OracleE2eITCase.java:149)
> at java.base/java.lang.reflect.Method.invoke(Method.java:567)
> at
> org.apache.flink.util.TestNameProvider$1.evaluate(TestNameProvider.java:45)
> at
> org.testcontainers.containers.FailureDetectingExternalResource$1.evaluate(FailureDetectingExternalResource.java:29)
> Caused by: oracle.net.ns.NetException: Listener refused the connection with
> the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
> at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
> at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
> ... 11 more{code}
> I have attached the test results to this issue.
> `OracleE2eITCase` runs the `goodboy008/oracle-19.3.0-ee:non-cdb` docker
> image. I am able to reproduce the same issue when I run this docker image
> locally - my observation is that dockerized Oracle DB instance is not being
> set up properly, as I notice another ORA in the setup logs (`ORA-03113:
> end-of-file on communication channel`). I have also attached the logs from
> the docker image setup to this issue. To reproduce the ORA-12528 issue
> locally, I:
> * ran: `docker run goodboy008/oracle-19.3.0-ee:non-cdb`
> * ssh'ed into the db pod
> * ran: `sqlplus sys/top_secret@//localhost:1521/ORCLCDB as sysdba`
> Any insight/workaround on getting this e2e test and the docker image running
> on my machine would be much appreciated. I'm also happy to provide any other
> information regarding my setup in the comments. Thank you!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Commented] (FLINK-35503) OracleE2eITCase fails with error ORA-12528 on Mac M2
[
https://issues.apache.org/jira/browse/FLINK-35503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17851486#comment-17851486
]
Zhongqiang Gong commented on FLINK-35503:
-
[~xiqian_yu] Let me take this issue. Because It have some change to orginal.
> OracleE2eITCase fails with error ORA-12528 on Mac M2
>
>
> Key: FLINK-35503
> URL: https://issues.apache.org/jira/browse/FLINK-35503
> Project: Flink
> Issue Type: Bug
> Components: Flink CDC
>Affects Versions: cdc-3.1.0
> Environment:
> * Mac M2 (Apple Silicon)
> * using docker desktop with Rosetta enabled for amd64 emulation
>
>Reporter: Saketh Kurnool
>Priority: Blocker
> Attachments: com.ververica.cdc.connectors.tests.OracleE2eITCase.txt,
> oracle-docker-setup-logs.txt
>
>
> Hello Flink CDC community,
> I am attempting to run `OracleE2eITCase` (in the cdc source connector e2e
> tests), and I am running into the following runtime exception:
> {code:java}
> java.sql.SQLException:
> Listener refused the connection with the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
> at
> oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.getOracleJdbcConnection(OracleE2eITCase.java:197)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.testOracleCDC(OracleE2eITCase.java:149)
> at java.base/java.lang.reflect.Method.invoke(Method.java:567)
> at
> org.apache.flink.util.TestNameProvider$1.evaluate(TestNameProvider.java:45)
> at
> org.testcontainers.containers.FailureDetectingExternalResource$1.evaluate(FailureDetectingExternalResource.java:29)
> Caused by: oracle.net.ns.NetException: Listener refused the connection with
> the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
> at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
> at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
> ... 11 more{code}
> I have attached the test results to this issue.
> `OracleE2eITCase` runs the `goodboy008/oracle-19.3.0-ee:non-cdb` docker
> image. I am able to reproduce the same issue when I run this docker image
> locally - my observation is that dockerized Oracle DB instance is not being
> set up properly, as I notice another ORA in the setup logs (`ORA-03113:
> end-of-file on communication channel`). I have also attached the logs from
> the docker image setup to this issue. To reproduce the ORA-12528 issue
> locally, I:
> * ran: `docker run goodboy008/oracle-19.3.0-ee:non-cdb`
> * ssh'ed into the db pod
> * ran: `sqlplus sys/top_secret@//localhost:1521/ORCLCDB as sysdba`
> Any insight/workaround on getting this e2e test and the docker image running
> on my machine would be much appreciated. I'm also happy to provide any other
> information regarding my setup in the comments. Thank you!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Commented] (FLINK-35503) OracleE2eITCase fails with error ORA-12528 on Mac M2
[
https://issues.apache.org/jira/browse/FLINK-35503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17851479#comment-17851479
]
yux commented on FLINK-35503:
-
Hi [~sakkurn],
Currently [~gongzhongqiang] tweaks Oracle EE docker image for running E2e tests
and repackaged it as goodboy008/oracle-19.3.0-ee:non-cdb. However it supports
amd64 only, and requires Rosetta (or something similar) to run.
Oracle community discussions[2] revealed that ORA-03113 also appears when
running cross-architecture emulation, perhaps caused by a bug in Rosetta 2, but
is hard to investigate and debug since they're not open sourced.
As this PR [3] has brought official arm64 architecture support to Oracle docker
image, I think we can repackage Oracle E2e docker image to support both amd64
and arm64 architecture, which could help Mac developers run E2e tests easier.
I'd like to help implementing this if needed.
[1] https://hub.docker.com/r/gvenzl/oracle-xe/tags
[2] https://github.com/oracle/docker-images/discussions/1951
[3] https://github.com/oracle/docker-images/pull/2659
> OracleE2eITCase fails with error ORA-12528 on Mac M2
>
>
> Key: FLINK-35503
> URL: https://issues.apache.org/jira/browse/FLINK-35503
> Project: Flink
> Issue Type: Bug
> Components: Flink CDC
>Affects Versions: cdc-3.1.0
> Environment:
> * Mac M2 (Apple Silicon)
> * using docker desktop with Rosetta enabled for amd64 emulation
>
>Reporter: Saketh Kurnool
>Priority: Blocker
> Attachments: com.ververica.cdc.connectors.tests.OracleE2eITCase.txt,
> oracle-docker-setup-logs.txt
>
>
> Hello Flink CDC community,
> I am attempting to run `OracleE2eITCase` (in the cdc source connector e2e
> tests), and I am running into the following runtime exception:
> {code:java}
> java.sql.SQLException:
> Listener refused the connection with the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
> at
> oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.getOracleJdbcConnection(OracleE2eITCase.java:197)
> at
> com.ververica.cdc.connectors.tests.OracleE2eITCase.testOracleCDC(OracleE2eITCase.java:149)
> at java.base/java.lang.reflect.Method.invoke(Method.java:567)
> at
> org.apache.flink.util.TestNameProvider$1.evaluate(TestNameProvider.java:45)
> at
> org.testcontainers.containers.FailureDetectingExternalResource$1.evaluate(FailureDetectingExternalResource.java:29)
> Caused by: oracle.net.ns.NetException: Listener refused the connection with
> the following error:
> ORA-12528, TNS:listener: all appropriate instances are blocking new
> connections
>
> at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
> at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
> at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
> ... 11 more{code}
> I have attached the test results to this issue.
> `OracleE2eITCase` runs the `goodboy008/oracle-19.3.0-ee:non-cdb` docker
> image. I am able to reproduce the same issue when I run this docker image
> locally - my observation is that dockerized Oracle DB instance is not being
> set up properly, as I notice another ORA in the setup logs (`ORA-03113:
> end-of-file on communication channel`). I have also attached the logs from
> the docker image setup to this issue. To reproduce the ORA-12528 issue
> locally, I:
> * ran: `docker run goodboy008/oracle-19.3.0-ee:non-cdb`
> * ssh'ed into the db pod
> * ran: `sqlplus sys/top_secret@//localhost:1521/ORCLCDB as sysdba`
> Any insight/workaround on getting this e2e test and the docker image running
> on my machine would be much appreciated. I'm also happy to provide any other
> information regarding my setup in the comments. Thank you!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
