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

[Dafi Ni (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-24311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=222730#comment-222730 ] 

Dafi Ni commented on ASTERISK-24311:
------------------------------------

Yes I rename table "alembic_version" to alembic_version_cdr alembic_version_config etc.

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