[gsingh@aq-qa2-front1 ~]$ java -jar aml-data-tool-2.9.0-BETA11.jar migrate -s qos -t 1.0.0
Enter the DB username: spike
Enter the DB password: ******
Enter the target DB server: aq-qa2-mysql1
[INFO] Flyway 3.2.1 by Boxfuse
[INFO] Database: jdbc:mysql://aq-qa2-mysql1:3306/qos?useUnicode=true&characterEncoding=utf8 (MySQL 5.5)
[INFO] Validated 3 migrations (execution time 00:00.094s)
[INFO] Creating Metadata table: `qos`.`schema_version`
[INFO] Current version of schema `qos`: << Empty Schema >>
[INFO] Migrating schema `qos` to version 0.0.99.01 - initial schema definition
[INFO] Migrating schema `qos` to version 0.0.99.02 - seed default limiters
[INFO] Migrating schema `qos` to version 0.0.99.03 - seed realm specific api limiters
[WARN] DB: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),
('49c573dc025c9e68633562793cbe3ad8',50,1000,'DEPLOYMENT_READ_OPERATION','Depl' at line 2 (SQL State: 42000 - Error Code: 1064)
[ERROR] Migration of schema `qos` to version 0.0.99.03 failed! Please restore backups and roll back database and code!
Unexpected exception:
Migration V0.0.99_03__seed_realm_specific_api_limiters.sql failed
-----------------------------------------------------------------
SQL State  : 42000
Error Code : 1064
Message    : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),
('49c573dc025c9e68633562793cbe3ad8',50,1000,'DEPLOYMENT_READ_OPERATION','Depl' at line 2
Location   : db/qos/migrations/1.0.0/V0.0.99_03__seed_realm_specific_api_limiters.sql (/home/gsingh/file:/home/gsingh/aml-data-tool-2.9.0-BETA11.jar!/db/qos/migrations/1.0.0/V0.0.99_03__seed_realm_specific_api_limiters.sql)
Line       : 1
Statement  : INSERT INTO limits (limiter_key, tickets, period, name, description, filter) VALUES
('2af3f197425aac921ec3782e8ee47135',10,1000,'DEPLOYMENT_WRITE_OPERATION','Deployment write operations. Includes all PUT and POST operations.','{"discriminator":"write","path":"/deployments","method":"ANY"}',),
('49c573dc025c9e68633562793cbe3ad8',50,1000,'DEPLOYMENT_READ_OPERATION','Deployment read operations.','{"discriminator":"read","path":"/deployments","method":"ANY"}',),
('4e661f24ddbe43f26b067a17f66dd9c3',50,1000,'BUDGET_ESTIMATE_REQUEST','Get budget estimates operations.','{"discriminator":"","path":"/budget-estimates","method":"POST"}',),
('84f8294d16f7f3bbc72faa35f4cec03a',2,60000,'GET_ALL_BUSINESS_ACTIVITIES','Get whole business taxonomy.','{"discriminator":"","path":"/taxonomy/business","method":"GET"}',),
('8bad3a1224163768578ba528e4597f7e',10,1000,'SEARCH_BUSINESS_ACTIVITIES','Search for business areas by keyword.','{"discriminator":"","path":"/taxonomy/business-search","method":"GET"}',),
('a4e3ea1936c6a0f2b3401da839322e3a',2,60000,'GET_ALL_LOCATIONS','Get whole location taxonomy.','{"discriminator":"","path":"/taxonomy/locations","method":"GET"}',),
('d39ee6b950ef1171d4eae5b40f8ef4a2',50,1000,'MERCHANT_API_OPS','Any Merchant API Operation','{"discriminator":"","path":"/merchants","method":"ANY"}')