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

[Rusty Newton (JIRA)]

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

Rusty Newton updated ASTERISK-24311:
------------------------------------

    Summary: Populating database via Alembic fails when using same database for multiple schema sets  (was: Unable to run all alembic migration when using same database for config,cdr,voicemail)

> 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
>            Severity: Minor
>
> 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)