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

[dant (JIRA)]

dant created ASTERISK-24582:
-------------------------------

             Summary: realtime with multiple 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: Core/Configuration
    Affects Versions: 11.14.1
         Environment: Using asterisk 11.14.1 RPMs on CentOS 6.6
            Reporter: dant
            Severity: Minor


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)