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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
