Upgrade failures

Discussion in '3CX Phone System - General' started by novastar, Feb 15, 2008.

  1. novastar

    Joined:
    Jul 16, 2007
    Messages:
    15
    Likes Received:
    0
    First, I manually updated the backup/restore files. After making a backup, I de-installed version 5.0 and installed 5.1 (4128). First major problem is that restoring the backup does not function properly. After a little while the restore function gets stuck which results in no restore of all the voiceprompts, music on hold file, voicemails and recordings. What a big pitty that this doesn't work. I fixed this manually by opening the backup file and restore the files manually to the right locations.

    Second problem is this strange thing in the logs:

    14:03:49.640 Call::Terminate [CM503008]: Call(1): Call is terminated
    14:03:49.640 DBPostgressAccessor::putHistory ERROR: duplicate key violates unique constraint "history_pkey"

    14:03:49.640 Call::Terminate [CM503008]: Call(1): Call is terminated
    14:03:49.640 DBPostgressAccessor::putHistory ERROR: duplicate key violates unique constraint "history_pkey"

    14:03:49.640 DBPostgressAccessor::putHistory ERROR: duplicate key violates unique constraint "history_pkey"

    14:03:49.640 Call::Terminate [CM503008]: Call(1): Call is terminated
    14:03:49.625 DBPostgressAccessor::putHistory ERROR: duplicate key violates unique constraint "history_pkey"

    14:03:49.625 DBPostgressAccessor::putHistory ERROR: duplicate key violates unique constraint "history_pkey"

    14:03:49.625 DBPostgressAccessor::putHistory ERROR: duplicate key violates unique constraint "history_pkey"


    Third thing: Diverting calls to external numbers still doesn't work properly.
     
  2. Wardy

    Wardy New Member

    Joined:
    Sep 18, 2007
    Messages:
    110
    Likes Received:
    0
    To fix the " "history_pkey"" error try doing a new backup and then restoring it

    Stephen
     
  3. Nick Galea

    Nick Galea Site Admin

    Joined:
    Jun 6, 2006
    Messages:
    1,731
    Likes Received:
    41
    Can you provide us with the backup file? We have done extensive testing on the backup and restore function and we should not be having such issues. You can email it to ng at 3cx.com and i will follow it up.
     
  4. novastar

    Joined:
    Jul 16, 2007
    Messages:
    15
    Likes Received:
    0
    I'm sorry but I can't send the backup file since it contains to many sensitive company information. I do have some other information about ongoing problems. I added an extension and this showed up:

    3CX Phone System internal error.
    HOME | LOGOUT



    Object duplication error


    Cannot save User object: ERROR: duplicate key violates unique constraint "users_pkey"<br>#0 C:\Program Files\3CX PhoneSystem\Data\Http\functions\fUser.php(56): safeExec(Object(PDOStatement), 'Cannot save Use...')<br />
    #1 C:\Program Files\3CX PhoneSystem\Data\Http\user_extension_info.php(1046): fUser::save(Object(oUser))<br />
    #2 C:\Program Files\3CX PhoneSystem\Data\Http\functions\gui\fmPage.php(70): aOnOk->execute()<br />
    #3 C:\Program Files\3CX PhoneSystem\Data\Http\functions\gui\fmPage.php(85): fmPage->processData()<br />
    #4 C:\Program Files\3CX PhoneSystem\Data\Http\functions\gui\fmPageEx.php(110): fmPage->toHTML()<br />
    #5 C:\Program Files\3CX PhoneSystem\Data\Http\user_extension_info.php(1096): fmCustomPage->toHTML()<br />
    #6 {main}

    --------------

    When I try to make a new backup file and restore it, then the restore stops at this point:

    Restore started
    loading table. dn 13 row(s)
    loading table. specialmenu 1 row(s)
    loading table. faxextension 1 row(s)
    loading table. parkextension 0 row(s)
    loading table. extension 2 row(s)
    loading table. extensionforward 8 row(s)
    loading table. users 2 row(s)
    loading table. voicemail 2 row(s)
    loading table. gateway 3 row(s)
    loading table. iprange2gateway 0 row(s)
    loading table. provider 3 row(s)
    loading table. codec2gateway 9 row(s)
    loading table. inboundruledid 0 row(s)
    loading table. inboundrule 3 row(s)
    loading table. externalline 3 row(s)
    loading table. outboundrule 4 row(s)
    loading table. dnrange2rule 0 row(s)
    loading table. rule2line 0 row(s)
    loading table. ringgroup 0 row(s)
    loading table. ringgroup2dn 0 row(s)
    loading table. queue 1 row(s)
    loading table. queue2dn 1 row(s)
    loading table. ivr 5 row(s)
    loading table. ivrmenuitem 7 row(s)
    loading table. sysfile 16 row(s)
    loading table. ivrmidn 0 row(s)
    loading table. ivrmireturn 0 row(s)
    loading table. ivrmimenu 5 row(s)
    loading table. ivrmisave 2 row(s)
    loading table. ivrmilisten 0 row(s)
    loading table. ivrmicbn 0 row(s)
    loading table. parameter 22 row(s)
    loading table. calendar 5 row(s)
    loading table. holiday 0 row(s)
    loading table. gwpar2gateway 48 row(s)
    loading table. gatewaytplvalue 0 row(s)
    loading table. history .

    (at this point, CPU usage goes to 100%, the restore does not end)

    UPDATE: After some minutes, the restore function DOES end normally, and after that adding extions also works again.
     
  5. amartini

    Joined:
    Dec 28, 2007
    Messages:
    17
    Likes Received:
    0
    When I restore the backup, the restore process stop due a time out script in utils.php (7200 seconds) even if my history refer to a 1 month of data...
    Now I have only 1 backup with call history and cannot restore it in the previous version nor in the new version.

    please help.
     

Share This Page