[Spce-user] Adding an alias to a subscriber deletes specific existing set of alias
Abel Alejandro
aalejandro at alliedtechnologygrouppr.com
Thu Aug 6 13:01:25 EDT 2015
Hello,
The procedure would be:
apt-get update && apt-get upgrade && \ ngcp-update-db-schema &&
ngcp-update-cfg-schema && \ ngcpcfg apply
Do you think I can apply without dropping calls or better wait for maint
window?
On Thu, Aug 6, 2015 at 12:52 PM, Gerhard Jungwirth <gjungwirth at sipwise.com>
wrote:
> Hi,
>
> thanks for the bugreport. This issue has now been fixed with the latest
> release of ngcp-panel (mr3.8.2.12). Please update and tell us if that
> solves your issue.
>
> Gerhard
>
>
> On 08/04/2015 04:40 PM, Andrew Pogrebennyk wrote:
>
>> Ok, thanks for dump.. I will check with our web dev. This may take a
>> couple of days before I get back to you, though.
>>
>> Andrew
>>
>> On 08/04/2015 04:38 PM, Abel Alejandro wrote:
>>
>>> The count looks the same but the ORDER of the DID that do not appear on
>>> the Edit form is different. The BAD did are 17877487645 and 17879057355
>>>
>>>
>>> mysql> select count(*) from provisioning.voip_dbaliases where
>>> subscriber_id=47;
>>> +----------+
>>> | count(*) |
>>> +----------+
>>> | 85 |
>>> +----------+
>>> 1 row in set (0.00 sec)
>>>
>>> mysql> select count(*) from billing.voip_numbers where subscriber_id=43;
>>> +----------+
>>> | count(*) |
>>> +----------+
>>> | 85 |
>>> +----------+
>>> 1 row in set (0.00 sec)
>>>
>>> mysql> select * from billing.voip_numbers where subscriber_id=43;
>>>
>>> +-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+
>>> | id | cc | ac | sn | reseller_id | subscriber_id | status |
>>> ported | list_timestamp |
>>>
>>> +-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+
>>> | 911 | 1 | 787 | 7052432 | 10 | 43 | active |
>>> 0 | 2014-06-17 13:11:32 |
>>> | 8972 | 1 | 787 | 2687353 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8973 | 1 | 787 | 6524000 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8974 | 1 | 787 | 6524001 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8975 | 1 | 787 | 6524002 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8976 | 1 | 787 | 6524003 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8977 | 1 | 787 | 6524004 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8978 | 1 | 787 | 8054100 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8979 | 1 | 787 | 8346242 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8980 | 1 | 787 | 9354000 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8981 | 1 | 787 | 9354001 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:44 |
>>> | 8982 | 1 | 787 | 9354002 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8983 | 1 | 787 | 9354004 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8984 | 1 | 787 | 9350102 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8985 | 1 | 787 | 8492888 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8986 | 1 | 787 | 6525000 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8987 | 1 | 787 | 6525001 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8988 | 1 | 787 | 6525002 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8989 | 1 | 787 | 6525003 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8990 | 1 | 787 | 6524005 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8991 | 1 | 787 | 6524006 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8992 | 1 | 787 | 6524007 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8993 | 1 | 787 | 6524008 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8994 | 1 | 787 | 6524009 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8995 | 1 | 787 | 6525004 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8996 | 1 | 787 | 2968286 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 8997 | 1 | 787 | 2968284 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9004 | 1 | 787 | 9576222 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9006 | 1 | 787 | 9667163 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9007 | 1 | 787 | 9667586 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9008 | 1 | 787 | 9667589 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9009 | 1 | 787 | 9667592 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9011 | 1 | 787 | 9619786 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9012 | 1 | 787 | 9619787 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9013 | 1 | 787 | 9619788 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9014 | 1 | 787 | 9619789 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9015 | 1 | 787 | 7109657 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9016 | 1 | 787 | 6657891 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9017 | 1 | 787 | 6657892 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9018 | 1 | 787 | 7050939 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9019 | 1 | 787 | 7050940 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9020 | 1 | 787 | 7050948 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9021 | 1 | 787 | 7086472 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9022 | 1 | 787 | 7086473 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9023 | 1 | 787 | 9455094 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9024 | 1 | 787 | 9455096 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9025 | 1 | 787 | 9455097 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9026 | 1 | 787 | 9455098 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9028 | 1 | 787 | 7052433 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9030 | 1 | 787 | 7052436 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9031 | 1 | 787 | 7052437 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9032 | 1 | 787 | 7109659 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9033 | 1 | 787 | 7109661 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9034 | 1 | 787 | 7107631 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9035 | 1 | 787 | 7107632 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9036 | 1 | 787 | 9667014 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9037 | 1 | 787 | 9667019 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9038 | 1 | 787 | 9667017 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9039 | 1 | 787 | 9667029 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9040 | 1 | 787 | 3957441 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9041 | 1 | 787 | 9619794 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9042 | 1 | 787 | 9619793 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9043 | 1 | 787 | 7057382 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9044 | 1 | 787 | 7057383 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9045 | 1 | 787 | 2667259 | 10 | 43 | active |
>>> 0 | 2014-09-23 10:02:45 |
>>> | 9514 | 1 | 787 | 9619790 | 10 | 43 | active |
>>> 0 | 2014-11-14 14:38:30 |
>>> | 9610 | 1 | 787 | 7650130 | 10 | 43 | active |
>>> 0 | 2015-01-07 11:17:19 |
>>> | 9611 | 1 | 787 | 7657386 | 10 | 43 | active |
>>> 0 | 2015-01-07 11:17:19 |
>>> | 9612 | 1 | 787 | 7729149 | 10 | 43 | active |
>>> 0 | 2015-01-07 11:17:19 |
>>> | 9755 | 1 | 787 | 7845000 | 10 | 43 | active |
>>> 0 | 2015-03-26 10:45:52 |
>>> | 9758 | 1 | 787 | 7845051 | 10 | 43 | active |
>>> 0 | 2015-03-26 16:01:08 |
>>> | 9780 | 1 | 787 | 7265929 | 10 | 43 | active |
>>> 0 | 2015-04-09 13:26:54 |
>>> | 9781 | 1 | 787 | 7286969 | 10 | 43 | active |
>>> 0 | 2015-04-09 13:26:54 |
>>> | 9843 | 1 | 787 | 7551210 | 10 | 43 | active |
>>> 0 | 2015-06-11 11:14:59 |
>>> | 9844 | 1 | 787 | 7487645 | 10 | 43 | active |
>>> 0 | 2015-08-02 10:41:06 |
>>> | 9845 | 1 | 787 | 7551235 | 10 | 43 | active |
>>> 0 | 2015-06-11 11:14:59 |
>>> | 9846 | 1 | 787 | 7551260 | 10 | 43 | active |
>>> 0 | 2015-06-11 11:14:59 |
>>> | 9847 | 1 | 787 | 7551300 | 10 | 43 | active |
>>> 0 | 2015-06-11 11:14:59 |
>>> | 9850 | 1 | 787 | 9057355 | 10 | 43 | active |
>>> 0 | 2015-08-02 10:41:06 |
>>> | 10096 | 1 | 787 | 4740636 | 10 | 43 | active |
>>> 0 | 2015-07-30 13:42:56 |
>>> | 10097 | 1 | 787 | 4740637 | 10 | 43 | active |
>>> 0 | 2015-07-30 15:38:45 |
>>> | 10098 | 1 | 787 | 4740638 | 10 | 43 | active |
>>> 0 | 2015-07-30 15:38:45 |
>>> | 10099 | 1 | 787 | 4740639 | 10 | 43 | active |
>>> 0 | 2015-07-30 15:38:45 |
>>> | 10100 | 1 | 787 | 4740640 | 10 | 43 | active |
>>> 0 | 2015-07-30 15:38:45 |
>>> | 10101 | 1 | 787 | 4740641 | 10 | 43 | active |
>>> 0 | 2015-07-30 15:38:45 |
>>>
>>> +-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+
>>>
>>> mysql> select * from provisioning.voip_dbaliases where subscriber_id=47;
>>> +-------+-------------+-----------+---------------+------------+
>>> | id | username | domain_id | subscriber_id | is_primary |
>>> +-------+-------------+-----------+---------------+------------+
>>> | 9221 | 17877052432 | 3 | 47 | 1 |
>>> | 9222 | 17872687353 | 3 | 47 | 0 |
>>> | 9223 | 17876524000 | 3 | 47 | 0 |
>>> | 9224 | 17876524001 | 3 | 47 | 0 |
>>> | 9225 | 17876524002 | 3 | 47 | 0 |
>>> | 9226 | 17876524003 | 3 | 47 | 0 |
>>> | 9227 | 17876524004 | 3 | 47 | 0 |
>>> | 9228 | 17878054100 | 3 | 47 | 0 |
>>> | 9229 | 17878346242 | 3 | 47 | 0 |
>>> | 9230 | 17879354000 | 3 | 47 | 0 |
>>> | 9231 | 17879354001 | 3 | 47 | 0 |
>>> | 9232 | 17879354002 | 3 | 47 | 0 |
>>> | 9233 | 17879354004 | 3 | 47 | 0 |
>>> | 9234 | 17879350102 | 3 | 47 | 0 |
>>> | 9235 | 17878492888 | 3 | 47 | 0 |
>>> | 9236 | 17876525000 | 3 | 47 | 0 |
>>> | 9237 | 17876525001 | 3 | 47 | 0 |
>>> | 9238 | 17876525002 | 3 | 47 | 0 |
>>> | 9239 | 17876525003 | 3 | 47 | 0 |
>>> | 9240 | 17876524005 | 3 | 47 | 0 |
>>> | 9241 | 17876524006 | 3 | 47 | 0 |
>>> | 9242 | 17876524007 | 3 | 47 | 0 |
>>> | 9243 | 17876524008 | 3 | 47 | 0 |
>>> | 9244 | 17876524009 | 3 | 47 | 0 |
>>> | 9245 | 17876525004 | 3 | 47 | 0 |
>>> | 9246 | 17872968286 | 3 | 47 | 0 |
>>> | 9247 | 17872968284 | 3 | 47 | 0 |
>>> | 9254 | 17879576222 | 3 | 47 | 0 |
>>> | 9256 | 17879667163 | 3 | 47 | 0 |
>>> | 9257 | 17879667586 | 3 | 47 | 0 |
>>> | 9258 | 17879667589 | 3 | 47 | 0 |
>>> | 9259 | 17879667592 | 3 | 47 | 0 |
>>> | 9261 | 17879619786 | 3 | 47 | 0 |
>>> | 9262 | 17879619787 | 3 | 47 | 0 |
>>> | 9263 | 17879619788 | 3 | 47 | 0 |
>>> | 9264 | 17879619789 | 3 | 47 | 0 |
>>> | 9265 | 17877109657 | 3 | 47 | 0 |
>>> | 9266 | 17876657891 | 3 | 47 | 0 |
>>> | 9267 | 17876657892 | 3 | 47 | 0 |
>>> | 9268 | 17877050939 | 3 | 47 | 0 |
>>> | 9269 | 17877050940 | 3 | 47 | 0 |
>>> | 9270 | 17877050948 | 3 | 47 | 0 |
>>> | 9271 | 17877086472 | 3 | 47 | 0 |
>>> | 9272 | 17877086473 | 3 | 47 | 0 |
>>> | 9273 | 17879455094 | 3 | 47 | 0 |
>>> | 9274 | 17879455096 | 3 | 47 | 0 |
>>> | 9275 | 17879455097 | 3 | 47 | 0 |
>>> | 9276 | 17879455098 | 3 | 47 | 0 |
>>> | 9278 | 17877052433 | 3 | 47 | 0 |
>>> | 9280 | 17877052436 | 3 | 47 | 0 |
>>> | 9281 | 17877052437 | 3 | 47 | 0 |
>>> | 9282 | 17877109659 | 3 | 47 | 0 |
>>> | 9283 | 17877109661 | 3 | 47 | 0 |
>>> | 9284 | 17877107631 | 3 | 47 | 0 |
>>> | 9285 | 17877107632 | 3 | 47 | 0 |
>>> | 9286 | 17879667014 | 3 | 47 | 0 |
>>> | 9287 | 17879667019 | 3 | 47 | 0 |
>>> | 9288 | 17879667017 | 3 | 47 | 0 |
>>> | 9289 | 17879667029 | 3 | 47 | 0 |
>>> | 9290 | 17873957441 | 3 | 47 | 0 |
>>> | 9291 | 17879619794 | 3 | 47 | 0 |
>>> | 9292 | 17879619793 | 3 | 47 | 0 |
>>> | 9293 | 17877057382 | 3 | 47 | 0 |
>>> | 9294 | 17877057383 | 3 | 47 | 0 |
>>> | 9295 | 17872667259 | 3 | 47 | 0 |
>>> | 9785 | 17879619790 | 3 | 47 | 0 |
>>> | 9916 | 17877650130 | 3 | 47 | 0 |
>>> | 9917 | 17877657386 | 3 | 47 | 0 |
>>> | 9918 | 17877729149 | 3 | 47 | 0 |
>>> | 10116 | 17877845000 | 3 | 47 | 0 |
>>> | 10122 | 17877845051 | 3 | 47 | 0 |
>>> | 10147 | 17877265929 | 3 | 47 | 0 |
>>> | 10148 | 17877286969 | 3 | 47 | 0 |
>>> | 10227 | 17877551210 | 3 | 47 | 0 |
>>> | 10229 | 17877551235 | 3 | 47 | 0 |
>>> | 10230 | 17877551260 | 3 | 47 | 0 |
>>> | 10231 | 17877551300 | 3 | 47 | 0 |
>>> | 10505 | 17874740636 | 3 | 47 | 0 |
>>> | 10506 | 17874740637 | 3 | 47 | 0 |
>>> | 10507 | 17874740638 | 3 | 47 | 0 |
>>> | 10508 | 17874740639 | 3 | 47 | 0 |
>>> | 10509 | 17874740640 | 3 | 47 | 0 |
>>> | 10510 | 17874740641 | 3 | 47 | 0 |
>>> | 10524 | 17879057355 | 3 | 47 | 0 |
>>> | 10525 | 17877487645 | 3 | 47 | 0 |
>>> +-------+-------------+-----------+---------------+------------+
>>> 85 rows in set (0.02 sec)
>>>
>>> mysql>
>>>
>>> On Tue, Aug 4, 2015 at 10:05 AM, Andrew Pogrebennyk
>>> <apogrebennyk at sipwise.com <mailto:apogrebennyk at sipwise.com>> wrote:
>>>
>>> Hi,
>>> I've encountered this issue once but was unable to find out what is
>>> causing it. Please provide the dump of all numbers from the billing
>>> and
>>> provisioning DBs:
>>>
>>> select * from provisioning.voip_dbaliases where subscriber_id=73;
>>> select * from billing.voip_numbers where subscriber_id=69;
>>>
>>> The id of subscriber in billing.voip_numbers table is the one you
>>> see in
>>> your browser's address bar when you go to subscriber details. The
>>> id in
>>> provisioning database you can figure out by alias.
>>>
>>> Please check if the two tables look in sync to you. Also, after you
>>> get
>>> the lists of numbers please specify which ones of those are missing
>>> when
>>> you get into Edit mode.
>>>
>>> Regards,
>>> Andrew
>>>
>>> On 08/02/2015 04:43 PM, Abel Alejandro wrote:
>>> > Hello,
>>> >
>>> > We have a bug (it happens to anyone so its not a local browser
>>> issue)
>>> > when we modify a particular subscriber in order to add new extra
>>> alias,
>>> > it keeps deleting a specific set number of aliases because they
>>> do not
>>> > appear automatically when we "Edit" the subscriber. We have to
>>> manually
>>> > keep putting the numbers of existing alias on the Alias edit form
>>> so
>>> > they do not get deleted.
>>> >
>>> > Any tips how to troubleshoot?
>>>
>>>
>>>
>>>
>>> --
>>> /Abel Alejandro/
>>>
>>> 787 586 8313 | 787 705 0555
>>> <mailto:joquendo at alliedtechnologygrouppr.com>
>>>
>>> 400 Calle Calaf 477
>>> San Juan, PR 00918
>>> aalejandro at alliedtechnologygrouppr.com
>>> <mailto:aalejandro at alliedtechnologygrouppr.com>
>>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
>>
>
>
--
*Abel Alejandro*
787 586 8313 | 787 705 0555
<joquendo at alliedtechnologygrouppr.com>
400 Calle Calaf 477
San Juan, PR 00918
aalejandro at alliedtechnologygrouppr.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150806/bf8ee624/attachment-0001.html>
More information about the Spce-user
mailing list