[Spce-user] sip:provider CE v3.0 released!

[Andrew Pogrebennyk]

Theo,

this is the problem John reported here:
http://lists.sipwise.com/pipermail/spce-user/2013-August/004605.html

The problem is that in 2.8 installation when we create permanent
contacts the ruid is not unique. In 3.0 it must be unique.

Please check how many permanent contacts you have:

SELECT  *
FROM    location loc1
WHERE   EXISTS
        (
        SELECT  1
        FROM    location loc2
        WHERE   loc2.ruid = loc1.ruid
        LIMIT 1, 1
        )

if there are just a few of them you can delete them, re-run upgrade
script and re-create the permanent contacts afterwards.

Victor is working on the permanent fix, ETA: tomorrow.

Andrew

On 08/22/2013 05:46 PM, Theo wrote:
> Hi Andrew
> 
> Thanks as always for quick replies! Got past that now but now have:
> 
> Applying revision script
> /usr/share/ngcp-db-schema/db_scripts/diff/13659.up: ERROR 1062 (23000)
> at line 13: Duplicate entry 'ulcx-516bff41-36e4-1' for key 'ruid_idx'
> failed. :(
> Please resolve the problem and run ngcp-update-db-schema again.
> root at sipwise:~# 
> 
> 
> 
> On Thu, Aug 22, 2013 at 5:42 PM, Andrew Pogrebennyk
> <apogrebennyk at sipwise.com <mailto:apogrebennyk at sipwise.com>> wrote:
> 
>     Hi Theo,
> 
>     it seems you've had postgresql installed. Could you please deinstall it
>     manually (apt-get remove --purge) and re-run the upgrade script again?
>     It should continue from where it stopped last time.
> 
>     On 08/22/2013 04:42 PM, Theo wrote:
>     > Hi
>     >
>     > That didn't go as planned :-( - I did not get the request to reboot at
>     > the end. It ended with the famous last words:
>     >
>     > Removing linux-kbuild-2.6.32 ...
>     > Removing postgresql-contrib-8.4 ...
>     > Removing postgresql-8.4 ...
>     > invoke-rc.d: policy-rc.d denied execution of stop.
>     > Purging configuration files for postgresql-8.4 ...
>     > Dropping cluster main...
>     > Can't exec "": No such file or directory at /usr/bin/pg_ctlcluster
>     line 268.
>     > Error: could not stop server, aborting
>     > dpkg: error processing postgresql-8.4 (--purge):
>     >  subprocess installed post-removal script returned error exit status 1
>     > Removing postgresql-client-8.4 ...
>     > Removing postgresql-doc-8.4 ...
>     > Processing triggers for man-db ...
>     > Errors were encountered while processing:
>     >  postgresql-8.4
>     > E: Sub-process /usr/bin/dpkg returned an error code (1)
>     >
>     >
>     > I can no longer login on the webinterface - not accepting my user and
>     > pass and presumably most other things are borked? Any thoughts?
> 
>