Error When Restore Database in v14: Table 'tabSingles' doesn't exist

,
1

Hi Everyone,

I have a new server that I have installed v14 on it and everything is ok, but when I want to restore the DB, I faced this error.


Note:
The two sites are v14, and the same apps

SETVAL(`crm_note_id_seq`, 1, 0)
1
SETVAL(`designation_duty_and_responsibility_id_seq`, 5, 0)
5
SETVAL(`designation_experience_id_seq`, 2, 0)
2
SETVAL(`designation_leader_for_id_seq`, 1, 0)
1
SETVAL(`designation_qualification_id_seq`, 2, 0)
2
SETVAL(`feedback_on_non_recipients_statements_table_id_seq`, 3, 0)
3
SETVAL(`job_applicant_log_detail_id_seq`, 1, 0)
1
SETVAL(`manager_appraisal_template_goal_id_seq`, 20, 0)
20
SETVAL(`procurement_method_detail_id_seq`, 1, 0)
1
SETVAL(`prospect_opportunity_id_seq`, 1, 0)
1
SETVAL(`tax_withheld_vouchers_id_seq`, 1, 0)
1
SETVAL(`web_form_list_column_id_seq`, 1, 0)
1
ERROR 2006 (HY000) at line 15409: Server has gone away
App frappe already installed
Table '_9920798c4fa8eea4.tabSingles' doesn't exist

Thank you in Advance

2

This means mysql server went away during restore. I’d suggest just attempting restore again.

3

You might want to check if the max-allowed-packet in /etc/mysql/mariadb.conf.d/mariadb.cnf is big enough

4

@ankush,

Tried several times and it didn’t work

5

@trentmu,

I make it 4024M it and still the same error.

7

@trentmu, @ankush

I think that the reason is the database that I want to restore because it did not save all the tables in the database.

Do you have a solution to make the backup copy pull all the tables and not be incomplete?

8

Something like this will create an sql+TGZ copy of the entire DB in the home subdir of the user that runs it. Obviously that user needs to have permission to access it

u="root";
p="YOUR_MySQL_root_PassW0rD";
BUfile="ERPNext_BU"
DBname="_9920798c4fa8eea4";     # based on the line above `Table '_9920798c4fa8eea4.tabSingles' doesn't exist`
buDate=`date +%Y%m%d-%H%M%S`;

#Create a backup from the local machine
mysqldump -u$u -p$p -B $DBname > $HOME/$buDate-$BUfile-$DBname.sql;
# Compress the backup
tar -cvzf $HOME/$buDate-$BUfile-$DBname.DB.tgz $HOME/$buDate-$BUfile-$DBname.sql;
# rm -f $HOME/$buDate-$BUfile-$DBname.sql;  # [optional - uncomment if reqd] remove the local .SQL file (since it is already zipped)
1 Like
9

Where you able to get the solution to this cause I am facing the same error.