[asterisk-bugs] [JIRA] (ASTERISK-24311) Populating database via Alembic fails when using same database for multiple schema sets

[George Joseph (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-24311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

George Joseph updated ASTERISK-24311:
-------------------------------------

    Target Release Version/s: 15.0.0

> Populating database via Alembic fails when using same database for multiple schema sets
> ---------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-24311
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24311
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General
>    Affects Versions: 12.5.0
>         Environment: Ubuntu 14.04 LTS
>            Reporter: Dafi Ni
>            Assignee: George Joseph
>            Severity: Minor
>      Target Release: 13.12.0, 14.1.0, 15.0.0
>
>         Attachments: ASTERISK-24311-set-version-table.diff
>
>
> When using same database for:
> config.ini cdr.ini voicemail.ini
> populate config is fine
> next running cdr :
> {quote} 
> root at KRA-WS-DAFI:/usr/src/asterisk-svn/contrib/ast-db-manage# alembic -c cdr.ini upgrade head
> INFO  \[alembic.migration] Context impl MySQLImpl.
> INFO  \[alembic.migration] Will assume non-transactional DDL.
> ERROR \[alembic.util] No such revision '5139253c0423'
>   FAILED: No such revision '5139253c0423'
> {quote}
> because in table "alembic_version" alembic store last migration from config.ini
> same is with voicemail:
> {quote}
> root at KRA-WS-DAFI:/usr/src/asterisk-svn/contrib/ast-db-manage# alembic -c voicemail.ini upgrade head
> INFO  \[alembic.migration] Context impl MySQLImpl.
> INFO  \[alembic.migration] Will assume non-transactional DDL.
> ERROR \[alembic.util] No such revision '5139253c0423'
>   FAILED: No such revision '5139253c0423'
> {quote}
> As workaround it is necessary to rename alembic_version when using different configs.



--
This message was sent by Atlassian JIRA
(v6.2#6252)