Page 1 of 1

Cannot remove Entries in Database

PostPosted: Thu Sep 21, 2006 10:25 pm
by enjay
This is kind of wierd, I seem to have stale entries in my live_channels and live_sip_channels tables.

live_channels:
Code: Select all
+-----------------------+-------------+---------------+--------------------+-----------------------+
| channel               | server_ip   | channel_group | extension          | channel_data          |
+-----------------------+-------------+---------------+--------------------+-----------------------+
| Zap/pseudo-190154997  | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/pseudo-582971722  | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/13-1              | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/12-1              | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/9-1               | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| IAX2/cobsrv01-16385   | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/pseudo-712883138  | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/pseudo-1555705878 | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| IAX2/cobsrv01-16384   | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/pseudo-1831758540 | 192.168.0.6 | NULL          | ring               | SIP/ring              |
| Zap/pseudo-1801674112 | 192.168.0.5 | NULL          | ring               | SIP/ring              |
| Zap/pseudo-23505741   | 192.168.0.5 | NULL          | ring               | SIP/ring              |
| Zap/50-1              | 192.168.0.5 | NULL          | ring               | SIP/ring              |
| IAX2/cobsrv02-6       | 192.168.0.5 | NULL          | Zap/g4/15054257904 | Zap/g4/15054257904||o |
| Zap/49-1              | 192.168.0.5 | NULL          | ring               | SIP/ring              |
| IAX2/cobsrv02-3       | 192.168.0.5 | NULL          | Zap/g4/15053241569 | Zap/g4/15053241569||o |
+-----------------------+-------------+---------------+--------------------+-----------------------+
16 rows in set (0.00 sec)


live_sip_channels
Code: Select all
+------------------------------+-------------+---------------+------------------------------------+---------------------------------------+
| channel                      | server_ip   | channel_group | extension                          | channel_data                          |
+------------------------------+-------------+---------------+------------------------------------+---------------------------------------+
| SIP/202-08ab37a8             | 192.168.0.6 | NULL          | 8600155                            | 8600155                               |
| SIP/204-08a86a30             | 192.168.0.6 | NULL          | 8600154                            | 8600154                               |
| SIP/202-08a9dcf8             | 192.168.0.6 | NULL          | 8600155                            | 8600155                               |
| Local/8600152@default-0953,2 | 192.168.0.6 | NULL          | 8600152                            | 8600152                               |
| Local/8600152@default-0953,1 | 192.168.0.6 | NULL          | Zap/g1/15054610566                 | Zap/g1/15054610566||o                 |
| Local/8600152@default-f0cb,2 | 192.168.0.6 | NULL          | 8600152                            | 8600152                               |
| Local/8600152@default-f0cb,1 | 192.168.0.6 | NULL          | Zap/g1/15054610566                 | Zap/g1/15054610566||o                 |
| Local/8600152@default-eb3e,2 | 192.168.0.6 | NULL          | 8600152                            | 8600152                               |
| Local/8600152@default-eb3e,1 | 192.168.0.6 | NULL          | Zap/g1/15054610566                 | Zap/g1/15054610566||o                 |
| Local/8600158@default-397b,2 | 192.168.0.6 | NULL          | 8600158                            | 8600158                               |
| Local/8600158@default-397b,1 | 192.168.0.6 | NULL          | IAX2/cobsrv02@cobsrv01/15054257904 | IAX2/cobsrv02@cobsrv01/15054257904||o |
| Local/8600156@default-9e94,2 | 192.168.0.6 | NULL          | 8600156                            | 8600156                               |
| Local/8600156@default-9e94,1 | 192.168.0.6 | NULL          | IAX2/cobsrv02@cobsrv01/15053241569 | IAX2/cobsrv02@cobsrv01/15053241569||o |
| SIP/224-0845a878             | 192.168.0.5 | NULL          | 8600061                            | 8600061                               |
| SIP/250-b7418b40             | 192.168.0.5 | NULL          | 8600057                            | 8600057|mq                            |
+------------------------------+-------------+---------------+------------------------------------+---------------------------------------+


when I try to remove entries or empty the whole table they just stay there. Any idea how to get rid of those since I know the system is not dialing so those are crap.

PostPosted: Thu Sep 21, 2006 10:37 pm
by mflorell
When you do a "show channels concise" in the Asterisk CLI do these not show up in there?

PostPosted: Thu Sep 21, 2006 10:38 pm
by enjay
well yes they do as a matter of fact :)

PostPosted: Thu Sep 21, 2006 10:39 pm
by enjay
how do I clear those from asterisk?

PostPosted: Fri Sep 22, 2006 5:09 am
by mflorell
Are they zombie channels or do they just sit in there forever?

You know that non/zap channels have to have a pseudo channel created in order to use meetme, and for every call placed out before it is answered there will be two Local/ channels for it, so what you posted is quite normal while calls are being placed in Asterisk.

PostPosted: Fri Sep 22, 2006 6:11 am
by kpanik
Also to me this problem happens and little after all this it involves this message:

NOTICE[11145]: app_dial.c:1056 dial_exec_full: Unable to create channel of type 'Zap' (cause 34 - Circuit/channel congestion)

I have tried to put wait the 4, but the problem does not change.

PostPosted: Fri Sep 22, 2006 6:28 am
by mflorell
How many Zap channels do you have and what kind of circuit are they connected to?

PostPosted: Fri Sep 22, 2006 6:38 am
by kpanik
I've a TE410P with 90 channels ( 3 PRI E1),

My zapata.conf is:

[channels]
language=it
;pridialplan=unknown
;prilocaldialplan=unknown

resetinterval=never
switchtype=euroisdn

pridialplan=local
prilocaldialplan=local

;internationalprefix=00

nationalprefix=0
usecallingpres=yes

callprogress=no

progzone=it

;callwaitingcallerid=yes

;echotraining=yes
;echocancel=64

;echocancelwhenbridged=yes

;overlapdial=yes

immediate=no
;callerid=asreceived
rxgain=1.0
txgain=1.0
priindication = outofband
;usecallerid=yes
;threewaycalling=yes
;transfer=yes
;canpark=yes
;cancallforward=yes
;callreturn=yes

busydetect=yes
busycount=6

answeronpolarityswitch=yes
hanguponpolarityswitch=yes

group=1
signalling=pri_cpe
;context=pri1
context=default
channel => 1-15
channel => 17-31
channel => 32-46
channel => 48-62
channel => 63-77
channel => 79-93
;channel => 94-108
;channel => 110-124

PostPosted: Fri Sep 22, 2006 6:48 am
by mflorell
Sine you have PRIs, busydetect and busycount are completely useless, you should comment those out or delete them then stop asterisk and ztcfg -s and ztcfg -vvvv

PostPosted: Fri Sep 22, 2006 7:12 am
by kpanik
I modify the zapata ... Now testing after I post the result

PostPosted: Fri Sep 22, 2006 7:15 am
by kpanik
In this moment I use, asterisk 1.2.12.1 (+ pathc ), zaptel 1.2.9.1 and libpri 1.2.3 ... Is a good idea, turn back at asterisk 1.2.10, zaptel, 1,2,8 ?

PostPosted: Fri Sep 22, 2006 11:05 am
by enjay
I bounced asterisk and they went away they had to be stale entries as the dialer had not been in use for hours at that point.

-enjay

PostPosted: Fri Sep 22, 2006 11:06 am
by enjay
Kpanik,

That could be attributed to (not enough lines) the fact that you get that cannot create Zap channel would lead me to believe you are trying to dial more lines than you have available. Look into this.

-enjay

PostPosted: Fri Sep 22, 2006 11:22 am
by kpanik
The problem it seems resolve but I changed kernel version ( 2.6.17.13 ) , zaptel svn trunk, asterisk 1.2.12.1, and libpri 1.2.3 ....

I see, than sometimes the queue, was blokked. I try use "target call" balancet, in place of "1 agent waiting for call" ...

Suggestion ?