Error When Delete Wiki App v14

1

Hi Everyone,

I have installed ERPNext in v14 ,and I want to uninstall the wiki app, but I have faced this error:

Backing up...
b"mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table `tabDeleted Document` at row: 22586\n"
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/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 109, in <module>
    main()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/decorators.py", line 21, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 29, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 798, in uninstall
    remove_app(app_name=app, dry_run=dry_run, yes=yes, no_backup=no_backup, force=force)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/installer.py", line 362, in remove_app
    scheduled_backup(ignore_files=True)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 532, in scheduled_backup
    odb = new_backup(
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 584, in new_backup
    odb.get_backup(older_than, ignore_files, force=force)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 190, in get_backup
    self.take_dump()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 460, in take_dump
    frappe.utils.execute_in_shell(command, low_priority=True, check_exit_code=True)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/__init__.py", line 450, in execute_in_shell
    raise Exception("Command failed")
Exception: Command failed

Note: I have tried to change the “max_allowed_packet” in my.cnf file, but nothing happened.

Thank you in advance

2

The problem was resolved by increasing the value of “max_allowed_packet” from 16M to 512M
in the file /etc/mysql/conf.d/mysqldump.cnf

2 Likes
3

this error was fixed also in the same way I have explained above :point_up_2:


ERROR 2006 (HY000) at line 9429: Server has gone away

Description: This is caused by the SQL import file being too big or the field carrying too much information, causing it to exceed the max_allowed_packet setting.

Solution: Increasing the maximum allowed packet by changing the parameter in my.cnf file will resolve this problem.

or by this command:
set global max_allowed_packet=1000000000;