Pragya Mittal created FALCON-2286:
-------------------------------------
Summary: Falcon upgradation fails to create new tables
Key: FALCON-2286
URL: https://issues.apache.org/jira/browse/FALCON-2286
Project: Falcon
Issue Type: Bug
Components: extensions
Affects Versions: trunk, 0.10
Reporter: Pragya Mittal
While installing falcon it fails to create new tables into existing database.
{noformat}
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)
{noformat}
Creating database :
{noformat}
pragya.mittal@falcon1001:/mnt/falcon/server$ sudo -u ivory ./bin/falcon-db.sh
create -sqlfile falcon.sql -run
DONE
DB schema exists
The SQL commands have been written to: falcon.sql
{noformat}
Database is not updated with tables : EXTENSIONS<,EXTENSION_JOBS
{noformat}
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)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
