[Serusers] preload_udomain error

[caio]

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 at 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 at 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 at 10.10.60.115:5060
      received: NULL
       expires: 2009-02-05 11:46:16
             q: -1.00
        callid: 1f46c06d5e034425286f095b11cf4a1a at 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