Support

Akeeba Backup for Joomla!

#31384 Backup fails with duplicate entry database errors

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by on Monday, 22 July 2019 17:17 CDT

dwreski
Hi,

I started to notice the size of the daily backups was increasing by five or six megs each day. I also today received an email stating the backup didn't succeed, although it was successfully uploaded to S3 and there was no indication in the akeeba.cli log (backup run from cron).

After attempting to restore the backup, it failed with dozens of "duplicate entry" messages. I've attached a screenshot.

We're using jinbound to manage the landing pages with call-to-action submission forms. Is this a problem with their plugin?

I've uploaded a copy of our daily backup log, with company name changed to "example.com"

nicholas
Akeeba Staff
Manager
Before answering that question I need to know what was your choice during restoration about existing tables: did you use Drop or Backup? If it's Drop then yes, that would be a problem with their plugin creating duplicate records which is a bit weird considering that MySQL should have cried bloody murder when that happened.

If it's Backup (or you have another site's or an older site's tables in the same database) then the problem is with the plugin using a primary key name which does not use the prefix of the database, meaning that now we have two tables sharing the same primary key. A solution to that problem is dropping the tables of the other site or using a different database.

Moreover, another solution is trying to use the "Use REPLACE instead of INSERT" option during restoration. This will try to restore the data in a way that is not affected by duplicate keys.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

dwreski
Thanks so much for your help. Using REPLACE instead of INSERT appears to have fixed it.

I've also opened a ticket with jinbound to determine why there are so many entries in that table and why there are duplicates.

nicholas
Akeeba Staff
Manager
You're welcome!

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!