Migration mysql -> postgres fails

[tilmang...@googlemail.com]

Dear all

I am trying to migrate following this recipe:

https://mirror.netcologne.de/bareos.org/experimental/CD/PR-619/BareosMainReference/Appendix/Howtos.html#section-migrationmysqltopostgresql

I am getting an error message and and wonder if there are log files somewhere that help me to understand why the database could not be opened. The message "double free or corruption (!prev)" points to a bug when deallocating memory. It is probably a consequence of the database not being opened rather than the root cause for it.

See also: https://www.linuxquestions.org/questions/programming-9/what-does-this-error-mean-double-free-or-corruption-661294/

./dird/dbcopy/bareos-dbcopy  -c /etc/bareos/bareos-dir.conf  QtronCatalog QtronCatalog-psql
Copying tables from "QtronCatalog" to "QtronCatalog-psql"
03-Jul 19:13  JobId 0: Fatal error: 03-Jul 19:13  JobId 0: Fatal error:

Could not open database QtronCatalog.
double free or corruption (!prev)
Aborted (core dumped)

Thanks

Tilman

[Philipp Storz]

Hello,

Am 03.07.21 um 19:30 schrieb 'tilmang...@googlemail.com' via bareos-users:

> Dear all
>
> I am trying to migrate following this recipe:
> https://mirror.netcologne.de/bareos.org/experimental/CD/PR-619/BareosMainReference/Appendix/Howtos.html#section-migrationmysqltopostgresql

you should always use the current documentation available on docs.bareos.org.
Please do not use the docs from other sources as only this documentation is kept up-to-date:

https://docs.bareos.org/Appendix/Howtos.html?highlight=migrate#migrate-mysql-to-postgresql

> I am getting an error message and and wonder if there are log files somewhere that help me to
> understand why the database could not be opened. The message "double free or corruption (!prev)"
> points to a bug when deallocating memory. It is probably a consequence of the database not being
> opened rather than the root cause for it

Exactly.

> See also:
> https://www.linuxquestions.org/questions/programming-9/what-does-this-error-mean-double-free-or-corruption-661294/
>
> ./dird/dbcopy/bareos-dbcopy  -c /etc/bareos/bareos-dir.conf  QtronCatalog QtronCatalog-psql
> Copying tables from "QtronCatalog" to "QtronCatalog-psql"
> 03-Jul 19:13  JobId 0: Fatal error: 03-Jul 19:13  JobId 0: Fatal error:
>
> Could not open database QtronCatalog.

This is for sure the source of your problem. Make sure that the connection to both databases works,
then the migration will work without problems.

Best regards,

Philipp




--
Mit freundlichen Grüßen

Philipp Storz philip...@bareos.com
Bareos GmbH & Co. KG Phone: +49 221 63 06 93-92
http://www.bareos.com Fax: +49 221 63 06 93-10

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Geschäftsführer: Stephan Dühr, M. Außendorf,
J. Steffens, P. Storz