Cannot remove Entries in Database

[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.

[mflorell]

When you do a "show channels concise" in the Asterisk CLI do these not show up in there?

[enjay]

well yes they do as a matter of fact

[enjay]

how do I clear those from asterisk?

[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.

[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.

[mflorell]

How many Zap channels do you have and what kind of circuit are they connected to?

[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

[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

[kpanik]

I modify the zapata ... Now testing after I post the result

[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 ?

[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

[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

[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 ?