Hi all,
Running ser0.9.7 on Solaris 10 (mysql 5.0.51 + serweb 0.9.6)
Have this problem when I stop ser service, and then start it again (ser
-E -D)..
0(0) preload_udomain: ERROR: bad callid record in table aliases
0(0) preload_udomain: ERROR: for username 579981, contact
sip:579981@mydomain.com
0(0) preload_udomain: ERROR: skipping...
And finally it dies with:
0(0) get_connection(): Connection not found in the pool
Fallo de segmentación (core dumped)
It happens with many records on aliases table and happens too with only
one record:
mysql> select * from aliases\G
*************************** 1. row ***************************
username: 579981
domain: 10.10.1.1
contact: sip:579981@mydomain.com
received: NULL
expires: 2009-02-05 11:45:21
q: 1.00
callid:
The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything
cseq: 42
last_modified: 2009-02-05 11:45:46
replicate: 0
state: 0
flags: 128
user_agent: SIP Express Router FIFO
1 row in set (0.00 sec)
SER start normally if I delete all the records on this table. But I need
create the aliases again, and this is not the normal behaviour..I think.
Here the description of aliases table:
mysql> desc aliases;
+---------------+---------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default
| Extra |
+---------------+---------------------+------+-----+---------------------+-------+
| username | varchar(64) | NO | PRI |
| |
| domain | varchar(128) | NO | PRI |
| |
| contact | varchar(255) | NO | PRI |
| |
| received | varchar(255) | YES | | NULL
| |
| expires | datetime | NO | | 2020-05-28 21:32:15
| |
| q | float(10,2) | NO | | 1.00
| |
| callid | varchar(255) | NO | | Default-Call-ID
| |
| cseq | int(11) | NO | | 42
| |
| last_modified | timestamp | NO | | CURRENT_TIMESTAMP
| |
| replicate | int(10) unsigned | NO | | 0
| |
| state | tinyint(1) unsigned | NO | | 0
| |
| flags | int(11) | NO | | 0
| |
| user_agent | varchar(50) | NO | |
| |
+---------------+---------------------+------+-----+---------------------+-------+
13 rows in set (0.01 sec)
Important: when "location" table keeps some records, ser doesn't start too:
mysql> select * from location\G
*************************** 1. row ***************************
username: 579981
domain:
mydomain.com
contact: sip:579981@10.10.60.115:5060
received: NULL
expires: 2009-02-05 11:46:16
q: -1.00
callid: 1f46c06d5e034425286f095b11cf4a1a(a)10.10.60.115
cseq: 6
last_modified: 2009-02-05 11:45:46
replicate: 0
state: 0
flags: 0
user_agent: CM5K-TA2S (807100.02)
1 row in set (0.00 sec)
Here too I must to delete all the records to let SER start successfully.
Does anyone knows about this issue?
Regards,
Claudio