You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@falcon.apache.org by "Pragya Mittal (JIRA)" <ji...@apache.org> on 2017/02/15 12:41:41 UTC
[jira] [Updated] (FALCON-2286) Falcon upgradation fails to create
new tables
[ 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)