[OpenSER-Devel] presence duplicate entry error

[Anca-Maria Vamanu]

Juha Heinanen wrote:
> i'll try again without word subscribe on subject line (which caused the
> email being blocked).
>
> handling subscribe causes the following error:
>
> Aug 24 10:31:29 localhost /usr/sbin/openser[5962]: submit_query: Duplicate entry 'sip:jh at vm.test.fi-jh-test.fi' for key 2
> Aug 24 10:31:29 localhost /usr/sbin/openser[5962]: db_insert: Error while submitting query
> Aug 24 10:31:29 localhost /usr/sbin/openser[5962]: PRESENCE: subscribe:ERROR while updating watchers table
>
> i do have en entry in watchers table where
>
> p_uri = sip:jh at vm.test.fi
> w_user = jh
> w_domain = test.fi
> event = presence
> subs_status = 1
> reason = NULL
> inserted_time = 1187602182
>
> why does openser try to insert an entry that already exists?  should it
> try to update it instead?
>
>   
Indeed it shouldn't and it doesn't (insert always follows an 
unsuccessful query). A new column was added to watchers table and the 
index updated to (p_uri, w_user, w_domain, event) and you probably did 
not update the table definition.

Anca

> -- juha
>
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>
>