[ https://issues.apache.org/jira/browse/FALCON-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pragya Mittal updated FALCON-2286: ---------------------------------- Description: 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 upgrade -sqlfile falcon.sql -run DONE DB schema exists Get Falcon DB version DONE Falcon DB already upgraded to Falcon version '0.11-SNAPSHOT' {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} was: 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} > 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 > upgrade -sqlfile falcon.sql -run > DONE > DB schema exists > Get Falcon DB version > DONE > Falcon DB already upgraded to Falcon version '0.11-SNAPSHOT' > {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)