vdesabou / kafka-docker-playground

🐳✨ Fully automated Apache Kafka® and Confluent Docker based examples // 👷‍♂️ Easily build examples or reproduction models
https://kafka-docker-playground.io
MIT License
652 stars 206 forks source link

🔥 connect/connect-jdbc-sybase-sink #5873

Open vdesabou opened 3 weeks ago

vdesabou commented 3 weeks ago

🆕💥 New issue !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-08-27 18:52 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10583658656/job/29326595105

vdesabou commented 3 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-08-28 18:34 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10602234116/job/29384225869

vdesabou commented 2 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-08-29 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10620498904/job/29440764590

vdesabou commented 2 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-08-30 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10637365691/job/29491387154

vdesabou commented 2 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-08-31 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10647334089/job/29515290122

vdesabou commented 2 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-01 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10656325893/job/29534964057

vdesabou commented 2 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-02 18:34 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10671590339/job/29577856563

vdesabou commented 2 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-03 18:37 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10688440283/job/29628672956

vdesabou commented 2 weeks ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-04 18:37 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10707297549/job/29687381882

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-05 18:34 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10725971027/job/29745394590

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-06 19:15 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10743284674/job/29798039978

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-07 18:31 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10753493097/job/29823101807

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-08 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10762121575/job/29842198302

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-09 14:21 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10774925871/job/29878666604

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-09 18:34 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10778959456/job/29891842901

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-10 18:34 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10798354381/job/29952063280

vdesabou commented 1 week ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-11 18:53 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10817372417/job/30011087808

vdesabou commented 6 days ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-12 18:36 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10836503102/job/30070844498

vdesabou commented 6 days ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.0 🔢 Connector v10.7.11 (📅 release date 2024-08-27) 🕐 2024-09-12 18:36 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10836503102/job/30070844498

vdesabou commented 6 days ago

broken due to https://github.com/confluentinc/kafka-connect-jdbc/pull/1420

vdesabou commented 6 days ago
[2024-09-13 12:32:07,315] INFO [sybase-sink|task-0] Checking Sybase dialect for existence of TABLE "master"."orders" (io.confluent.connect.jdbc.dialect.GenericDatabaseDialect:595)
[2024-09-13 12:32:07,362] INFO [sybase-sink|task-0] Using Sybase dialect TABLE "master"."orders" absent (io.confluent.connect.jdbc.dialect.GenericDatabaseDialect:603)
[2024-09-13 12:32:07,365] INFO [sybase-sink|task-0] Creating table with sql: CREATE TABLE "master"."orders" (
"id" int NOT NULL,
"product" text NOT NULL,
"quantity" int NOT NULL,
"price" real NOT NULL) (io.confluent.connect.jdbc.sink.DbStructure:122)
[2024-09-13 12:32:07,369] WARN [sybase-sink|task-0] Create failed, will attempt amend if table already exists (io.confluent.connect.jdbc.sink.DbStructure:69)
java.sql.SQLException: User name master does not exist in sysusers.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241)
    at io.confluent.connect.jdbc.dialect.SybaseDatabaseDialect.applyDdlStatements(SybaseDatabaseDialect.java:225)
    at io.confluent.connect.jdbc.sink.DbStructure.create(DbStructure.java:123)
    at io.confluent.connect.jdbc.sink.DbStructure.createOrAmendIfNecessary(DbStructure.java:67)
    at io.confluent.connect.jdbc.sink.BufferedRecords.add(BufferedRecords.java:122)
    at io.confluent.connect.jdbc.sink.JdbcDbWriter.write(JdbcDbWriter.java:77)
    at io.confluent.connect.jdbc.sink.JdbcSinkTask.put(JdbcSinkTask.java:90)
    at org.apache.kafka.connect.runtime.WorkerSinkTask.deliverMessages(WorkerSinkTask.java:607)
    at org.apache.kafka.connect.runtime.WorkerSinkTask.poll(WorkerSinkTask.java:354)
    at org.apache.kafka.connect.runtime.WorkerSinkTask.iteration(WorkerSinkTask.java:251)
    at org.apache.kafka.connect.runtime.WorkerSinkTask.execute(WorkerSinkTask.java:220)
    at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:229)
    at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:284)
    at org.apache.kafka.connect.runtime.isolation.Plugins.lambda$withClassLoader$7(Plugins.java:339)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.base/java.lang.Thread.run(Thread.java:840)
vdesabou commented 6 days ago
[2024-09-13 12:55:06,972] DEBUG [sybase-sink|task-0] Querying Sybase dialect column metadata for catalog:master schema:null table:orders (io.confluent.connect.jdbc.dialect.GenericDatabaseDialect:663)
vdesabou commented 5 days ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.1 🔢 Connector v10.7.12 (📅 release date 2024-09-13) 🕐 2024-09-13 19:36 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10854153629/job/30124353064

vdesabou commented 4 days ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.1 🔢 Connector v10.7.12 (📅 release date 2024-09-13) 🕐 2024-09-14 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10864557957/job/30150073335

vdesabou commented 3 days ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.1 🔢 Connector v10.7.12 (📅 release date 2024-09-13) 🕐 2024-09-15 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10873285354/job/30169357276

vdesabou commented 3 days ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.1 🔢 Connector v10.7.12 (📅 release date 2024-09-13) 🕐 2024-09-15 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10873285354/job/30169357276

vdesabou commented 2 days ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.1 🔢 Connector v10.7.12 (📅 release date 2024-09-13) 🕐 2024-09-16 18:34 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10889710437/job/30217321784

vdesabou commented 1 day ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.1 🔢 Connector v10.7.12 (📅 release date 2024-09-13) 🕐 2024-09-17 18:35 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10908774969/job/30275897791

vdesabou commented 19 hours ago

🤦‍♂️💥 Still failing !

🔥 CP 7.7.1 🔢 Connector v10.7.12 (📅 release date 2024-09-13) 🕐 2024-09-18 18:33 📄 sybase-sink.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/10927897725/job/30335499969