Re: [I] MariaDB as metadata storage: facing ClassNotFoundException: com.mysql.jdbc.exceptions.MySQLTransientException (druid)

["kazuhirokomoda (via GitHub)" <gi...@apache.org>]

kazuhirokomoda commented on issue #14936:
URL: https://github.com/apache/druid/issues/14936#issuecomment-1788291910

   @LakshSingla Thank you for sharing. I tried newer versions (`26.0.0`, `25.0.0`, `24.0.2`, `0.23.0`), they didn't throw `MySQLTransientException` but instead they froze until I pressed Ctrl+C.
   
   With `0.22.1`, along with the `MySQLTransientException`, I observed a particular table (`druid_pendingSegments`) was created on 2 nodes, but not on 1 node (out of 3 nodes).
   
   Also I highlight that manual execution of `CREATE TABLE` statements (which I obtained from our another old MySQL `5.7.25` cluster) worked fine.
   
   I talked with DB Admin of the on-prem cluster, and he addressed some questions to ask:
   
   - Is the [`metadata-init` tool](https://druid.apache.org/docs/0.22.1/operations/metadata-migration.html#create-druid-tables) compatible with MariaDB 10.6.15 (upgraded from 10.5.12), 3-node Galera cluster? Especially when it uses [Total Order Isolation](https://galeracluster.com/library/documentation/schema-upgrades.html#toi) for DDL?
   - Could you provide entire/exact SQL it uses to create tables?
   - Is there any retry mechanism inside the tool?
   - Does it open transaction, or set any variable before execution?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org