SQL error in normalisation process (MariaDB)

Connector Questions & Issues
, ,
1
  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: Kubernetes
  • Airbyte Version: 0.41.0

Hi there,

i get errors trying to sync MariaDB to MariaDB while normalization.

2023-04-13 21:44:09 INFO i.a.w.n.DefaultNormalizationRunner(close):190 - Terminating normalization process...
2023-04-13 21:44:09 ERROR i.a.w.g.DefaultNormalizationWorker(run):83 - Normalization failed for job 2.
io.airbyte.workers.exception.WorkerException: Normalization process did not terminate normally (exit code: 1)
	at io.airbyte.workers.normalization.DefaultNormalizationRunner.close(DefaultNormalizationRunner.java:201) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
	at io.airbyte.workers.general.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:81) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
	at io.airbyte.workers.general.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:34) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
	at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
	at java.lang.Thread.run(Thread.java:1589) ~[?:?]
2023-04-13 21:44:09 INFO i.a.w.g.DefaultNormalizationWorker(run):94 - Normalization executed in 13 seconds for job 2.
2023-04-13 21:44:09 INFO i.a.w.g.DefaultNormalizationWorker(run):106 - Normalization summary: io.airbyte.config.NormalizationSummary@52677704[startTime=1681422236342,endTime=1681422249814,failures=[io.airbyte.config.FailureReason@29749b6e[failureOrigin=normalization,failureType=system_error,internalMessage=1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RETURNING CHAR) as id,,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@29d7fccc[additionalProperties={attemptNumber=2, jobId=2, from_trace_message=true}],stacktrace=AirbyteDbtError: 
1 of 1 ERROR creating table model tableau.airbyte_report................................................................ [ERROR in 0.07s]
Database Error in model airbyte_report (models/generated/airbyte_incremental/tableau/airbyte_report.sql)
  1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RETURNING CHAR) as id,
      json_value(_airbyte_data, 
      '$."date"' RETURNIN...' at line 14
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/tableau/airbyte_report.sql

Is MariaDB unsupported? Any advice?

Regards

2

Can you share the complete log file?
I don’t have the right information about MariaDB but you can use without normalization.

3

bce0c69a_579c_4121_86d9_3564075f75e8_logs_4.txt (136.4 KB)

It runs through without normalization, but that is not the result we need for our use case.