Hi Team,
I am trying to create a table in Starrock DB with Mysql client. I am able to connect with Liquibase and its creating Databasechangelog table, but fails while creating Databasechangeloglock tables and observing below errors. Can someone help us on this, is there any issues with Liquibase version?
Connect to my starrock Db using mysql client:
mysql -h localhost -P 9030 -u starrocks-usr -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 33605853
Server version: 8.0.33 3.5.2-69de616
Copyright (c) 2000, 2026, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> use telemetry;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
±-------------------------+
| Tables_in_telemetry |
±-------------------------+
| mdi_wifi_station_pm_1min |
±-------------------------+
1 row in set (0.00 sec)
mysql> exit
Now I ran liquibase from my my machine and output as below.
liquibase update --classpath=lib/mysql-connector-j-8.0.33.jar --defaultsFile=liquibase.properties --changeLogfile=test.sql
####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ __ __ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \___/_|\__, |\__,_|_|_.__/ \__,_|__/\__| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## ##
####################################################
Starting Liquibase at 20:35:37 using Java 21.0.10 (version 4.31.0 #6261 built at 2025-01-14 14:24+0000)
Liquibase Version: 4.31.0
Liquibase Open Source 4.31.0 by Liquibase
ERROR: Exception Details
ERROR: Exception Primary Class: SQLSyntaxErrorException
ERROR: Exception Primary Reason: Getting syntax error at line 1, column 181. Detail message: Unexpected input ‘PRIMARY’, the most similar input is {‘(’}.
ERROR: Exception Primary Source: MySQL 8.0.33
Unexpected error running Liquibase: Getting syntax error at line 1, column 181. Detail message: Unexpected input ‘PRIMARY’, the most similar input is {‘(’}. [Failed SQL: (1064) CREATE TABLE telemetry.DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` TINYINT NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
For more information, please use the --log-level flag
localhost: /opt/mysql$ liquibase update --classpath=lib/mysql-connector-j-8.0.33.jar --defaultsFile=liquibase.properties --changeLogfile=test.sql
my test.sql as below.
cat test.sql
--liquibase formatted sql
--changeset svemulur:test.sql
create table test3(id int,name varchar(65533));
my properties file as below:
url=jdbc:mysql://localhost.internal.data.perf.xilac.net:9030/telemetry
username=starrocks-usr
password=******
driver=com.mysql.cj.jdbc.Driver