Re: [1'b68'1 astrad v8] forcer l'expire sur tous les ASTRADs

[Oussama Hammami <oussama.hammami@switzernet.com>]

Résultat d’exécution de la procédure 'Active_Notify' après l'activation du forçage de l'expire : (nombre des clients avec le problème port mapping)

From	To	Servers	Customers
2011-06-24 10:00	2011-06-24 13:00	DB3	72
2011-06-24 13:00	2011-06-24 16:00	DB3	10
2011-06-24 10:00	2011-06-24 13:00	DB4	128
2011-06-24 13:00	2011-06-24 16:00	DB4	13

DB3

mysql> CALL Active_Notify('2011-06-24 10:00:00','2011-06-24 13:00:00');
+-------------+
| username    |
+-------------+
| 41215500XXX |
|     ...     |
| 41215500XXX |
+-------------+
72 rows in set (0.57 sec)

Query OK, 72 rows affected (0.58 sec)

mysql> CALL Active_Notify('2011-06-24 13:00:00','2011-06-24 16:00:00');
+-------------+
| username    |
+-------------+
| 41215500XXX |
|     ...     |
| 41215500XXX |
+-------------+
10 rows in set (0.15 sec)

Query OK, 10 rows affected (0.15 sec)
      

DB3

mysql>  CALL Active_Notify('2011-06-24 10:00:00','2011-06-24 13:00:00');
+-------------+
| username    |
+-------------+
| 41215500XXX |
|     ...     |
| 41215500XXX |
+-------------+
128 rows in set (1.04 sec)

Query OK, 128 rows affected (1.04 sec)

mysql> CALL Active_Notify('2011-06-24 13:00:00','2011-06-24 16:00:00');
+-------------+
| username    |
+-------------+
| 41215500XXX |
|     ...     |
| 41215500XXX |
+-------------+
13 rows in set (0.20 sec)

Query OK, 13 rows affected (0.20 sec)
      

On 2011-06-24 12:05, Oussama Hammami wrote:

Exécuter la procédure 'Active_Notify' après l'activation du forçage de l'expire.
Re: [1'b68'1 astrad v8] potential list of customers with 'no incoming calls' problems.

Cette procédure doit afficher une liste vide.