Issues with restoring H2 database

#1

I am trying to restore from a former backup the process stalled and I am now unable to login with any account. The system doesn’t appear to recognize any of my earlier user accounts. So I can’t log in to attempt another restore, what can do?

#2
  1. Increase the memory of your Tomcat installation. H2 uses a lot of memory and errors out internally if it cannot use memory.

  2. Do NOT use H2, but move to MySQL.

  3. We don’t have a utility to reset your access, but you can use the reset tool to reset the password which will provide you with the SystemAdmins email address in the output. Doing so is simple:

  • Rename the file SysAdminsReset.z to SysAdminsReset.cfm. (file is located at /razuna/admin/maintenance/)
  • Open the file and edit the line “” and enter the database you are using. Guess you didn’t switch the database so this would be the value “H2”.
  • Hit this template at the URL http://localhost:8080/razuna/admin/maintenance/SysAdminsReset.cfm
#3

Many thanks for your reply.

Allow me to clarify the background. And please let me know if I am missing something.

I attempted to migrate from H2 to MYSQL, This failed.

Then I attempted to restore the H2 database, this failed too, the restore stopped halfway … see below.

I then attempted the reset procedure as documented in your reply, this doesn’t seem to produce any results. I suspect this is because the earlier restore failed and the user’s table wasn’t created. As such there are no users to send the reset password to.

I set the following

http://localhost:8080/razuna/admin/maintenance/SysAdminsReset.cfm - just shows the submit button and no fields, I am not sure this is expected. This leads me to the conclusion that no users exist.

So I hoping for a method to fully reset the system and hoping that it will find the existing backups. I have noted in another thread there is a method to manually restore. Could this be documented?

PS: I have allocated 4GB RAM already.
Starting the Restore

Checking consistency of records…

Database setup…

Currently cleaning up api_basket
Currently cleaning up cache
Currently cleaning up ct_aliases
Currently cleaning up ct_groups_permissions
Currently cleaning up ct_groups_users
Currently cleaning up ct_labels
Currently cleaning up ct_plugins_hosts
Currently cleaning up ct_users_hosts
Currently cleaning up ct_users_remoteusers
Currently cleaning up file_types
Currently cleaning up groups
Currently cleaning up hosts
Currently cleaning up log_actions
Currently cleaning up lucene
Currently cleaning up modules
Currently cleaning up news
Currently cleaning up options
Currently cleaning up permissions
Currently cleaning up plugins
Currently cleaning up plugins_actions
Currently cleaning up raz1_additional_versions
Currently cleaning up raz1_approval
Currently cleaning up raz1_approval_done
Currently cleaning up raz1_assets_temp
Currently cleaning up raz1_audios
Currently cleaning up raz1_audios_text
Currently cleaning up raz1_cart
Currently cleaning up raz1_collections
Currently cleaning up raz1_collections_ct_files
Currently cleaning up raz1_collections_groups
Currently cleaning up raz1_collections_text
Currently cleaning up raz1_comments
Currently cleaning up raz1_custom
Currently cleaning up raz1_custom_fields
Currently cleaning up raz1_custom_fields_text
Currently cleaning up raz1_custom_fields_values
Currently cleaning up raz1_export_template
Currently cleaning up raz1_files
Currently cleaning up raz1_files_desc
Currently cleaning up raz1_files_xmp
Currently cleaning up raz1_folders
Currently cleaning up raz1_folders_desc
Currently cleaning up raz1_folders_groups
Currently cleaning up raz1_folders_name
Currently cleaning up raz1_folder_subscribe
Currently cleaning up raz1_folder_subscribe_groups
Currently cleaning up raz1_images
Currently cleaning up raz1_images_text
Currently cleaning up raz1_import_templates
Currently cleaning up raz1_import_templates_val
Currently cleaning up raz1_labels
Currently cleaning up raz1_languages
Currently cleaning up raz1_log_assets
Currently cleaning up raz1_log_folders
Currently cleaning up raz1_log_search
Currently cleaning up raz1_log_users
Currently cleaning up raz1_schedules
Currently cleaning up raz1_schedules_log
Currently cleaning up raz1_settings
Currently cleaning up raz1_settings_2
Currently cleaning up raz1_share_options
Currently cleaning up raz1_smart_folders
Currently cleaning up raz1_smart_folders_prop
Currently cleaning up raz1_temp
Currently cleaning up raz1_upload_templates
Currently cleaning up raz1_upload_templates_val
Currently cleaning up raz1_users_accounts
Currently cleaning up raz1_users_favorites
Currently cleaning up raz1_versions
Currently cleaning up raz1_videos
Currently cleaning up raz1_videos_text
Currently cleaning up raz1_widgets
Currently cleaning up raz1_wm_templates
Currently cleaning up raz1_wm_templates_val
Currently cleaning up raz1_xmp
Currently cleaning up rfs
Currently cleaning up search_reindex
Currently cleaning up tools
Currently cleaning up users
Currently cleaning up users_comments
Currently cleaning up users_login
Currently cleaning up webservices
Currently cleaning up wisdom
Database setup done. Continuing…

The database is now empty. Starting to import data…
Importing to tables… (please wait)

Currently restoring table api_basket
Currently restoring table cache
Currently restoring table ct_aliases
Currently restoring table ct_groups_permissions
Currently restoring table ct_groups_users
Currently restoring table ct_labels
Currently restoring table ct_plugins_hosts
Currently restoring table ct_users_hosts
Currently restoring table ct_users_remoteusers
Currently restoring table file_types
Currently restoring table groups
Currently restoring table hosts
Currently restoring table log_actions
Currently restoring table lucene
Currently restoring table modules
Currently restoring table news
Currently restoring table options
Currently restoring table permissions
Currently restoring table plugins
Currently restoring table plugins_actions
Currently restoring table raz1_additional_versions
Currently restoring table raz1_approval
Currently restoring table raz1_approval_done
Currently restoring table raz1_assets_temp
Currently restoring table raz1_audios
Currently restoring table raz1_audios_text
Currently restoring table raz1_cart
Currently restoring table raz1_collections
Currently restoring table raz1_collections_ct_files
Currently restoring table raz1_collections_groups
Currently restoring table raz1_collections_text
Currently restoring table raz1_comments
Currently restoring table raz1_custom
Currently restoring table raz1_custom_fields
Currently restoring table raz1_custom_fields_text
Currently restoring table raz1_custom_fields_values
Currently restoring table raz1_export_template
Currently restoring table raz1_files
Currently restoring table raz1_files_desc
Currently restoring table raz1_files_xmp
Currently restoring table raz1_folders
Currently restoring table raz1_folders_desc
Currently restoring table raz1_folders_groups
Currently restoring table raz1_folders_name
Currently restoring table raz1_folder_subscribe
Currently restoring table raz1_folder_subscribe_groups
Currently restoring table raz1_images

FAILED after that.

#4

You complained to me in email that there is not enough documentation, but I see that you don’t even read our installation documentation, that clearly says to have at least 8 GB of memory, better even provide 16 GB or upwards. 4 GB is not enough. Heck, I have on my development machine 16 GB.

You did not reply if you increase memory in Tomcat as suggested.

To reset you can simply remove the “DB” folder in the Razuna folder. Backups are stored in the admin/backup folder. This is also documented on here. Use the search.

#5

Thanks for you feedback, I have been able to delete the DB folder and now I can setup and import the database using MySQL. However it seems the user table is empty and we back at the same point where I am unable to login, but using MySQL in clearly see this was skipped yet the restore completed successfully.

Your notes on the required environment is well noted - we have already ordered more RAM which will used to upgrade the VM running this app.

To be fair, there are still many broken links in the documentation, these often point to wiki.razuna.com which no longer functions.

Your help resolving the above would be most welcome.
Similar issue here