Oracle Oci mysql heatwave database issue

Alaa6 months ago

I have installed Traccar and I'm trying to use MySQL heatwave database in Oracle Oci and when initializing the database for Traccar I get the following 

2024-07-06 00:07:21 ERROR: Main method error - The table does not comply with the requirements by an external plugin. - SQLException (... < DatabaseModule:98 < <gener:-1 < *:-1 < ... < MainModule:128 < ...)
Anton Tananaev6 months ago

It looks like there are limitations that make it incompatible:

https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations.html

For example, it doesn't support cascading changes by foreign keys, which is something we use.

Alaa6 months ago

but heatwave cluster is disabled
SCR-20240706-kxye.png

Alaa6 months ago

or the use of the Ha database is not supported by Tracar ?

Anton Tananaev6 months ago

It's the other way around. Your database doesn't support some essential SQL features.