V12 restore error

[Sanath_Udayawansa2]

sanath@vmi322732:~/frappe-bench$ bench --site 8210 --force restore /sites/8210/private/backups/20200328_174059-site1_local-database.sql
MySQL root password:
Creating Database…
3.62GiB 0:13:54 [4.44MiB/s] [================================>] 100%
Traceback (most recent call last):
File “/usr/lib/python3.5/runpy.py”, line 193, in _run_module_as_main
“main”, mod_spec)
File “/usr/lib/python3.5/runpy.py”, line 85, in _run_code
exec(code, run_globals)
File “/home/sanath/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
main()
File “/home/sanath/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/sanath/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/sanath/frappe-bench/apps/frappe/frappe/commands/site.py”, line 125, in restore
force=context.force)
File “/home/sanath/frappe-bench/apps/frappe/frappe/commands/site.py”, line 75, in _new_site
source_sql=source_sql, force=force, reinstall=reinstall, db_type=db_type, db_host=db_host, db_port=db_port, db_password=db_password, no_mariadb_socket=no_mariadb_socket)
File “/home/sanath/frappe-bench/apps/frappe/frappe/installer.py”, line 35, in install_db
setup_database(force, source_sql, verbose, no_mariadb_socket)
File “/home/sanath/frappe-bench/apps/frappe/frappe/database/init.py”, line 16, in setup_database
return frappe.database.mariadb.setup_db.setup_database(force, source_sql, verbose, no_mariadb_socket=no_mariadb_socket)
File “/home/sanath/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py”, line 64, in setup_database
bootstrap_database(db_name, verbose, source_sql)
File “/home/sanath/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py”, line 95, in bootstrap_database
if not ‘tabDefaultValue’ in frappe.db.get_tables():
File “/home/sanath/frappe-bench/apps/frappe/frappe/database/database.py”, line 772, in get_tables
return [d[0] for d in self.sql(“select table_name from information_schema.tables where table_schema not in (‘pg_catalog’, ‘information_schema’)”)]
File “/home/sanath/frappe-bench/apps/frappe/frappe/database/database.py”, line 171, in sql
self._cursor.execute(query)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 732, in _read_query_result
result.read()
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 657, in _read_packet
packet_header = self._read_bytes(4)
File “/home/sanath/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 707, in _read_bytes
CR.CR_SERVER_LOST, “Lost connection to MySQL server during query”)
pymysql.err.OperationalError: (2013, ‘Lost connection to MySQL server during query’)
sanath@vmi322732:~/frappe-bench$

[smino]

It might be helpful to describe the operating environment and why you are restoring the database.

Can you access the database by: bench mariadb ?

[Sanath_Udayawansa2]

Well, I am having V11 VPS and now I am moving this DB to V12 VPS
I am using Dedian 9 OS
I can access to DB since we have another site here in multi tenent.