[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