search

bytedance / bitsail

BitSail is a distributed high-performance data integration engine which supports batch, streaming and incremental scenarios. BitSail is widely used to synchronize hundreds of trillions of data every day.
https://bytedance.github.io/bitsail/
Apache License 2.0
1.61k stars 330 forks source link

[BitSail][Test] OracleSourceITCase failed when insert data #312

Open liuxiaocs7 opened 1 year ago

liuxiaocs7 commented 1 year ago

Describe the bug

OracleSourceITCase failed when insert data.

To Reproduce

Run OracleSourceITCase on a windows machine

Error messages:

12:04:11.936 [testcontainers-lifecycle-0] INFO  org.testcontainers.ext.ScriptUtils - Executing database script from scripts/oracle_source_to_print.sql
12:04:24.722 [testcontainers-lifecycle-0] ERROR 🐳 [gvenzl/oracle-xe:18.4.0-slim] - Could not start container
org.testcontainers.ext.ScriptUtils$UncategorizedScriptException: Failed to execute database script from resource [/*
 * Copyright 2022 Bytedance Ltd. and/or its affiliates.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

create table ORACLE_DYNAMIC_TABLE
(
    ID          VARCHAR2(1024),
    INT_TYPE    NUMBER,
    BIGINT_TYPE NUMBER,
    FLOAT_TYPE  NUMBER,
    DOUBLE_TYPE NUMBER,
    RAW_TYPE    RAW(1024),
    DATE_TYPE   DATE
);

insert into ORACLE_DYNAMIC_TABLE (ID, INT_TYPE, BIGINT_TYPE, FLOAT_TYPE, DOUBLE_TYPE, RAW_TYPE, DATE_TYPE)
values ('id', 123, 1e12, 1.23, 1.2345, '1afe28', '05-JUL-2022');]
    at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:460)
    at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:375)
    at org.testcontainers.ext.ScriptUtils.runInitScript(ScriptUtils.java:363)
    at org.testcontainers.containers.JdbcDatabaseContainer.runInitScriptIfRequired(JdbcDatabaseContainer.java:323)
    at org.testcontainers.containers.JdbcDatabaseContainer.containerIsStarted(JdbcDatabaseContainer.java:188)
    at org.testcontainers.containers.GenericContainer.containerIsStarted(GenericContainer.java:701)
    at org.testcontainers.containers.GenericContainer.tryStart(GenericContainer.java:521)
    at org.testcontainers.containers.GenericContainer.lambda$doStart$0(GenericContainer.java:344)
    at org.rnorth.ducttape.unreliables.Unreliables.retryUntilSuccess(Unreliables.java:81)
    at org.testcontainers.containers.GenericContainer.doStart(GenericContainer.java:334)
    at org.testcontainers.containers.GenericContainer.start(GenericContainer.java:322)
    at java.util.concurrent.CompletableFuture.uniRun(CompletableFuture.java:719)
    at java.util.concurrent.CompletableFuture$UniRun.tryFire(CompletableFuture.java:701)
    at java.util.concurrent.CompletableFuture$Completion.run(CompletableFuture.java:456)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.testcontainers.ext.ScriptUtils$ScriptStatementFailedException: Script execution failed (scripts/oracle_source_to_print.sql:2): insert into ORACLE_DYNAMIC_TABLE (ID, INT_TYPE, BIGINT_TYPE, FLOAT_TYPE, DOUBLE_TYPE, RAW_TYPE, DATE_TYPE) values ('id', 123, 1e12, 1.23, 1.2345, '1afe28', '05-JUL-2022')
    at org.testcontainers.jdbc.JdbcDatabaseDelegate.execute(JdbcDatabaseDelegate.java:61)
    at org.testcontainers.delegate.AbstractDatabaseDelegate.execute(AbstractDatabaseDelegate.java:39)
    at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:448)
    ... 16 common frames omitted
Caused by: java.sql.SQLDataException: ORA-01843: ζ— ζ•ˆηš„ζœˆδ»½

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300)
    at org.testcontainers.jdbc.JdbcDatabaseDelegate.execute(JdbcDatabaseDelegate.java:48)
    ... 18 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01843: ζ— ζ•ˆηš„ζœˆδ»½

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
    ... 31 common frames omitted
12:04:24.830 [testcontainers-lifecycle-0] ERROR 🐳 [gvenzl/oracle-xe:18.4.0-slim] - Log output from the failed container:
CONTAINER: starting up...
CONTAINER: first database startup, initializing...
CONTAINER: uncompressing database data files, please wait...
CONTAINER: done uncompressing database data files, duration: 100 seconds.
CONTAINER: starting up Oracle Database...

(Note that the above sentences are not necessary for each bug report issue.)

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots

If applicable, add screenshots to help explain your problem.

Build Environment

Describe the environment where the test project was build.

Execution Environment

Describe the environment where the test project ran.

Same as above

Additional context

Add any other context about the problem here.

hk-lrzy commented 1 year ago

@liuxiaocs7 It's compatibility problem for oralce with windows, do you have any interset to fix it?

liuxiaocs7 commented 1 year ago

@liuxiaocs7 It's compatibility problem for oralce with windows, do you have any interset to fix it?

sure, i'll try it