[FALCON-2286] Falcon upgradation fails to create new tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: trunk, 0.10
• Fix Version/s: trunk, 0.11
• Component/s: extensions
• Assignee: Pracheer Agarwal
• Reporter: Pragya Mittal
• Created: 15/Feb/17 12:06
• Updated: 10/Mar/17 03:22
• Resolved: 10/Mar/17 03:22

Description

While installing falcon it fails to create new tables into existing database.

mysql> show tables;
+------------------------+
| Tables_in_falcon       |
+------------------------+
| BACKLOG_METRIC         |
| ENTITIES               |
| ENTITY_SLA_ALERTS      |
| FALCON_DB_PROPS        |
| INSTANCES              |
| MONITORED_ENTITY       |
| OPENJPA_SEQUENCE_TABLE |
| PENDING_INSTANCES      |
| ProcessInstanceInfo    |
+------------------------+
9 rows in set (0.01 sec)

Creating database :

pragya.mittal@falcon1001:/mnt/falcon/server$ sudo -u ivory ./bin/falcon-db.sh upgrade -sqlfile falcon.sql -run
DONE
DB schema exists
Get Falcon DB version
DONE
Falcon DB already upgraded to Falcon version '0.11-SNAPSHOT'

Database is not updated with tables : EXTENSIONS<,EXTENSION_JOBS

mysql> show tables;                                                                                                                                                                +------------------------+
| Tables_in_falcon       |
+------------------------+
| BACKLOG_METRIC         |
| ENTITIES               |
| ENTITY_SLA_ALERTS      |
| FALCON_DB_PROPS        |
| INSTANCES              |
| MONITORED_ENTITY       |
| OPENJPA_SEQUENCE_TABLE |
| PENDING_INSTANCES      |
| ProcessInstanceInfo    |
+------------------------+
9 rows in set (0.00 sec)

Issue Links

• blocks: FALCON-2182 Add support for Falcon user extensions
• links to: GitHub Pull Request #376