update to v4.1.1 error

[Blesta Addons]

we have uploaded the patch files from 4.0.1 to 4.1.1 and when we have run the upgrade script , the progress was stopped and the end of the bar and it was stacked there , we have waiting a long time to complete the upgrade, so mush time for waiting without any progress . so we have relunshed the upgrade again, then the progress show a error

 

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3-3571' for key 'PRIMARY' on line 196 in /home/XXXX/public_html/vendors/minphp/db/src/PdoConnection.php

Printing Stack Trace:
#0 /home/xxxx/public_html/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array)
#1 /home/xxxx/public_html/vendors/minphp/record/src/Record.php(275): Minphp\Db\PdoConnection->query('INSERT INTO `se...', Array)
#2 /home/xxxx/public_html/components/upgrades/tasks/upgrade4_1_1.php(95): Minphp\Record\Record->insert('service_invoice...', Array, Array)
#3 /home/xxxx/public_html/components/upgrades/tasks/upgrade4_1_1.php(54): upgrade4_1_1->addServiceInvoiceAssociations()
#4 /home/xxxx/public_html/components/upgrades/upgrades.php(266): upgrade4_1_1->process('addServiceInvoi...')
#5 /home/xxxx/public_html/components/upgrades/upgrades.php(101): Upgrades->processObject(Object(upgrade4_1_1), NULL)
#6 /home/xxxx/public_html/app/controllers/admin_upgrade.php(108): Upgrades->start('4.1.0-b1', '4.1.1')
#7 /home/xxxx/public_html/vendors/minphp/bridge/src/Lib/Dispatcher.php(143): AdminUpgrade->process()
#8 /home/xxxx/public_html/index.php(21): Dispatcher::dispatch('/admin/upgrade/...')
#9 {main}

 

how we should verify if the upgrade was completed successfully or how we should re-run the upgrade script ?

[Blesta Addons]

i will drop the table 'service_invoices' and run again the upgrade script .

For what used the new table 'service_invoices' , in wich case ?

[Paul]

The table is to resolve CORE-2167. If you run into the issue again, try upgrading via CLI. 

[Blesta Addons]

 

37 minutes ago, Paul said:

The table is to resolve CORE-2167. If you run into the issue again, try upgrading via CLI. 

we have run the upgrade from CLI, and is still running until this post , is about 40 minute now !!! and i see the table  'service_invoices'  was filled until now with more than  25000 lines, is this normal ?

[Blesta Addons]

arrived now to 29574 lines . when this will be finished !

Finished NOW , ufff, this is the long update process since v3 !!!!

[mukesh]

i try to upgrade using browser it takes  5 sec only

[Blesta Addons]

5 hours ago, mukesh said:

i try to upgrade using browser it takes  5 sec only

This depends on how invoice you have in your blesta. i assume you have under 100 invoices

[Paul]

Anyone that has a large number of invoices should run the upgrade via CLI. The data in the table is required to reliably process renewals through a module. Not many modules support renewals, so for some people it might not be a big deal to skip populating the table (would require a modification to the migrator). If the table isn't populated though, and you have say a domain name for an invoice that was generated before the upgrade, then paid after the upgrade, it would not be renewed through the module.

Hopefully this doesn't turn into a big issue. It may have been better for the cron to handle initial population.