[asterisk-bugs] [JIRA] (ASTERISK-24582) Realtime with multiple DB destinations using priorities results in duplicate queries

[Rusty Newton (JIRA)]

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

Rusty Newton updated ASTERISK-24582:
------------------------------------

    Component/s: Resources/res_odbc

> Realtime with multiple DB destinations using priorities results in duplicate queries
> ------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-24582
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24582
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_odbc, Resources/res_odbc
>    Affects Versions: 11.14.1
>         Environment: Using asterisk 11.14.1 RPMs on CentOS 6.6
>            Reporter: dant
>            Severity: Minor
>         Attachments: queue_log_insert.txt, registration_update.txt
>
>
> Asterisk is configured to use realtime via ODBC. The database is Percona XtraDB Cluster with 4 configured nodes (multi-master) for Asterisk for failover, priorities have been defined. Pulling realtime information works well, but, updates that store to realtime show running against all databases, this is most noticeable for INSERTs to queue log where entries appear 4 times in the database with only the autoincrementing ID different between rows, but can be seen with sippeers UPDATES in logging too.
> From extconfig.conf:
> queue_log => odbc,db1,queue_log,1
> queue_log => odbc,db2,queue_log,2
> queue_log => odbc,db3,queue_log,3
> queue_log => odbc,db4,queue_log,4
> Expected behavior:
> If the log can be written to db1, then it is written only to db1. If there is a failure, the next highest priority, i.e. db2, is tried.
> Observed behavior:
> The log appears to be written to all servers, which, being multi-master, results in duplicate log inserts.



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