[Spce-user] Adding an alias to a subscriber deletes specific existing set of alias

Abel Alejandro aalejandro at alliedtechnologygrouppr.com
Tue Aug 4 10:38:59 EDT 2015


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> 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
<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/mailman/private/spce-user_lists.sipwise.com/attachments/20150804/83d9cfa8/attachment.html>


More information about the Spce-user mailing list