[Spce-user] Adding an alias to a subscriber deletes specific existing set of alias
Gerhard Jungwirth
gjungwirth at sipwise.com
Thu Aug 6 12:52:26 EDT 2015
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
More information about the Spce-user
mailing list