Cannot remove Entries in Database
Posted: Thu Sep 21, 2006 10:25 pm
This is kind of wierd, I seem to have stale entries in my live_channels and live_sip_channels tables.
live_channels:
live_sip_channels
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.
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.