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

Andrew Pogrebennyk apogrebennyk at sipwise.com
Tue Aug 4 10:40:40 EDT 2015


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>




More information about the Spce-user mailing list