Upgrade failures

[novastar]

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:utHistory 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:utHistory ERROR: duplicate key violates unique constraint "history_pkey"

14:03:49.640 DBPostgressAccessor:utHistory 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:utHistory ERROR: duplicate key violates unique constraint "history_pkey"

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

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


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

 

[Wardy]

To fix the " "history_pkey"" error try doing a new backup and then restoring it

Stephen

 

[N_G]

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.

 

[novastar]

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.

 

[amartini]

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.