Creating snapshot of FusionAuth data? #95
Description
Hi!
During development, we are using FusionAuth and Postgres with Docker Compose.
We pre-load the database with data (also FusionAuth data), and when necessary, we dump the data from database to a file, so it can be reused.
However, sometimes when starting FusionAuth from a recent database dump, it will log a whole lot of errors [0]. I believe the backup process is at fault.
To do a backup, we run:
$ # Start the services
$ docker compose up db fusionauth
$ # Save the data to a file
$ pg_dumpall --clean -h localhost -U postgres > db.outTo restore, we run:
$ # Start database and load with data
$ docker compose up db
$ # Load fixtures
$ psql $DATABASE_URL -f ./fixtures/db.out
$ # Start FusionAuth
$ docker compose up fusionauth # Here fusionauth starts complaining!When FusionAuth is started, it will log a whole lot of errors similar to [0].
What are we doing wrong? Is there a better approach of creating a snapshot image of FusionAuth?
[0]:
platform-fusionauth-1 | 2023-10-31 08:42:02.592 AM ERROR com.inversoft.migration.Migrator - Unable to run migration [io.fusionauth.api.migration.guice.Migration_1_42_0]
platform-fusionauth-1 | com.google.inject.ProvisionException: Unable to provision, see the following errors:
platform-fusionauth-1 |
platform-fusionauth-1 | 1) [Guice/ErrorInCustomProvider]: TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2
platform-fusionauth-1 | at FusionAuthMVCModule.configure(FusionAuthMVCModule.java:31)
platform-fusionauth-1 | \_ installed by: FusionAuthModule -> Modules$OverrideModule -> FusionAuthMVCModule
platform-fusionauth-1 | at BooleanConverter.<init>(BooleanConverter.java:35)
platform-fusionauth-1 | \_ for 1st parameter
platform-fusionauth-1 | while locating BooleanConverter
platform-fusionauth-1 | while locating GlobalConverter annotated with @Element(setName=,uniqueId=202, type=MAPBINDER, keyType=Class<?>)
platform-fusionauth-1 | at DefaultConverterProvider.<init>(DefaultConverterProvider.java:47)
platform-fusionauth-1 | \_ for 2nd parameter
platform-fusionauth-1 | while locating DefaultConverterProvider
platform-fusionauth-1 | at ParameterModule.bindConverterProvider(ParameterModule.java:42)
platform-fusionauth-1 | \_ installed by: FusionAuthModule -> Modules$OverrideModule -> MVCModule -> ParameterModule
platform-fusionauth-1 | at DefaultExpressionEvaluator.<init>(DefaultExpressionEvaluator.java:47)
platform-fusionauth-1 | \_ for 1st parameter
platform-fusionauth-1 | while locating DefaultExpressionEvaluator
platform-fusionauth-1 | at ParameterModule.bindExpressionEvaluator(ParameterModule.java:46)
platform-fusionauth-1 | \_ installed by: FusionAuthModule -> Modules$OverrideModule -> MVCModule -> ParameterModule
platform-fusionauth-1 | at InUseValidator.<init>(InUseValidator.java:21)
platform-fusionauth-1 | \_ for 1st parameter
platform-fusionauth-1 | at DefaultEmailTemplateService.<init>(DefaultEmailTemplateService.java:59)
platform-fusionauth-1 | \_ for 5th parameter
platform-fusionauth-1 | while locating DefaultEmailTemplateService
platform-fusionauth-1 | at SystemDefaultsSingleton.<init>(SystemDefaultsSingleton.java:185)
platform-fusionauth-1 | \_ for 1st parameter
platform-fusionauth-1 | at SystemDefaultsSingleton.class(SystemDefaultsSingleton.java:28)
platform-fusionauth-1 | at Migration_1_42_0.<init>(Migration_1_42_0.java:20)
platform-fusionauth-1 | \_ for 1st parameter
platform-fusionauth-1 | while locating Migration_1_42_0
platform-fusionauth-1 |
platform-fusionauth-1 | Learn more:
platform-fusionauth-1 | https://github.com/google/guice/wiki/ERROR_IN_CUSTOM_PROVIDER
platform-fusionauth-1 |
platform-fusionauth-1 | 1 error
platform-fusionauth-1 |