falcon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pragya Mittal (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (FALCON-2286) Falcon upgradation fails to create new tables
Date Wed, 15 Feb 2017 12:41:41 GMT

     [ 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)

Mime
View raw message