Hi All,
I am facing Below Error When I Do bench Restore
MySQL root password:
b'ERROR 1227 (42000) at line 32794: Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation\n'
b'SETVAL(`access_log_id_seq`, 187, 0)\n187\nSETVAL(`activity_log_id_seq`, 20959, 0)\n20959\nSETVAL(`bisect_nodes_id_seq`, 1, 0)\n1\nSETVAL(`console_log_id_seq`, 1, 0)\n1\nSETVAL(`crm_note_id_seq`, 2175, 0)\n2175\nSETVAL(`department_hod_mapping_id_seq`, 1, 0)\n1\nSETVAL(`docshare_id_seq`, 1015, 0)\n1015\nSETVAL(`document_follow_id_seq`, 1, 0)\n1\nSETVAL(`email_queue_id_seq`, 21620, 0)\n21620\nSETVAL(`energy_point_log_id_seq`, 1, 0)\n1\nSETVAL(`error_log_id_seq`, 1542, 0)\n1542\nSETVAL(`event_sync_log_id_seq`, 1, 0)\n1\nSETVAL(`event_update_log_id_seq`, 1, 0)\n1\nSETVAL(`gma_marketing_campaign_id_seq`, 24, 0)\n24\nSETVAL(`lead_assignee_id_seq`, 2, 0)\n2\nSETVAL(`ledger_health_id_seq`, 1, 0)\n1\nSETVAL(`leftuser_id_seq`, 1, 0)\n1\nSETVAL(`new_employee_id_seq`, 148, 0)\n148\nSETVAL(`notification_log_id_seq`, 196, 0)\n196\nSETVAL(`online_lead_id_seq`, 2, 0)\n2\nSETVAL(`onlinelead_id_seq`, 32674, 0)\n32674\nSETVAL(`prospect_opportunity_id_seq`, 12, 0)\n12\nSETVAL(`rm_activities_id_seq`, 10413, 0)\n10413\nSETVAL(`scheduled_job_log_id_seq`, 402150, 0)\n402150\nSETVAL(`social_media_leads_id_seq`, 1, 0)\n1\nSETVAL(`transfer_lead_id_seq`, 8, 0)\n8\nSETVAL(`version_id_seq`, 689160, 0)\n689160\nSETVAL(`view_log_id_seq`, 18533, 0)\n18533\nSETVAL(`web_form_list_column_id_seq`, 1, 0)\n1\n'
Traceback (most recent call last):
File "/home/srvadm/frappe-bench/apps/frappe/frappe/commands/site.py", line 291, in restore_backup
_new_site(
File "/home/srvadm/frappe-bench/apps/frappe/frappe/installer.py", line 87, in _new_site
install_db(
File "/home/srvadm/frappe-bench/apps/frappe/frappe/installer.py", line 160, in install_db
setup_database(force, source_sql, verbose, no_mariadb_socket)
File "/home/srvadm/frappe-bench/apps/frappe/frappe/database/__init__.py", line 21, in setup_database
return frappe.database.mariadb.setup_db.setup_database(
File "/home/srvadm/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py", line 53, in setup_database
bootstrap_database(db_name, verbose, source_sql)
File "/home/srvadm/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py", line 70, in bootstrap_database
import_db_from_sql(source_sql, verbose)
File "/home/srvadm/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py", line 93, in import_db_from_sql
DbManager(frappe.local.db).restore_database(
File "/home/srvadm/frappe-bench/apps/frappe/frappe/database/db_manager.py", line 87, in restore_database
execute_in_shell(" ".join(command), check_exit_code=True, verbose=verbose)
File "/home/srvadm/frappe-bench/apps/frappe/frappe/utils/__init__.py", line 484, in execute_in_shell
raise Exception("Command failed")
Exception: Command failed
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.10/runpy.py", line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File "/usr/lib/python3.10/runpy.py", line 86, in _run_code
exec(code, run_globals)
File "/home/srvadm/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 114, in <module>
main()
File "/home/srvadm/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 20, in main
click.Group(commands=commands)(prog_name="bench")
File "/home/srvadm/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
return self.main(*args, **kwargs)
File "/home/srvadm/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1078, in main
rv = self.invoke(ctx)
File "/home/srvadm/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/srvadm/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/srvadm/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/srvadm/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "/home/srvadm/frappe-bench/env/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/srvadm/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File "/home/srvadm/frappe-bench/apps/frappe/frappe/commands/site.py", line 135, in restore
_restore(
File "/home/srvadm/frappe-bench/apps/frappe/frappe/commands/site.py", line 197, in _restore
restore_backup(
File "/home/srvadm/frappe-bench/apps/frappe/frappe/commands/site.py", line 305, in restore_backup
print(err.args[1])
IndexError: tuple index out of range
Please Help