bench.exceptions.CommandFailedError: supervisorctl restart frappe:

[Thaya_Govzig]

Why is this error occurring when I give bench restart. the previous thing was I was installing erpnext after that I had to restart and I am getting this.

[avc]

Hi @Thaya_Govzig:

bench restart just works in production environment …

If your bench is running, stop in console with Ctrl+c … Maybe you closed your console and running bench is not “visible”. Take a look here:

Stopping bench in a Multi-bench setup

Here goes: Installation $ cd frappe-bench #or whatever your bench directory is $ git clone https://github.com/proenterprise/bench-stop $ mv ./bench-stop/stop.py . $ sudo rm -r ./bench-stop Usage $ python stop.py

Hope this helps.

[adam26d]

Looks like they’re in production. That script on the previous answer is for development.

This is most likely a permission issue or just bad config

Try redoing the production setup

sudo bench setup production yourusername

You can run it twice to be sure

[avc]

Hi @adam26d:

My answer is based on previous @Thaya_Govzig topic thread (When bench start is given this shows - #7 by Thaya_Govzig) so I guess they are not still in production I don’t really know.

I think bench restart causes exactly this error if you try it in development mode.

Btw, seems you are the creator of stop.py . Many thanks, made my day every day

[adam26d]

It was a community effort that keeps giving

[Thaya_Govzig]

what’s the reason for this

Installing erpnext…
An error occurred while installing erpnext: (‘Module Def’, ‘Accounts’, IntegrityError(1062, “Duplicate entry ‘Accounts’ for key ‘PRIMARY’”))
Traceback (most recent call last):
File “apps/frappe/frappe/model/base_document.py”, line 532, in db_insert
frappe.db.sql(
File “apps/frappe/frappe/database/database.py”, line 217, in sql
self._cursor.execute(query, values)
File “env/lib/python3.11/site-packages/pymysql/cursors.py”, line 153, in execute
result = self._query(query)
^^^^^^^^^^^^^^^^^^
File “env/lib/python3.11/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 822, in _read_query_result
result.read()
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 1200, in read
first_packet = self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 772, in _read_packet
packet.raise_for_error()
File “env/lib/python3.11/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.11/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1062, “Duplicate entry ‘Accounts’ for key ‘PRIMARY’”)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “apps/frappe/frappe/commands/site.py”, line 462, in install_app
_install_app(app, verbose=context.verbose, force=force)
File “apps/frappe/frappe/installer.py”, line 294, in install_app
add_module_defs(name, ignore_if_duplicate=force)
File “apps/frappe/frappe/installer.py”, line 633, in add_module_defs
d.insert(ignore_permissions=True, ignore_if_duplicate=ignore_if_duplicate)
File “apps/frappe/frappe/model/document.py”, line 295, in insert
self.db_insert(ignore_if_duplicate=ignore_if_duplicate)
File “apps/frappe/frappe/model/base_document.py”, line 559, in db_insert
raise frappe.DuplicateEntryError(self.doctype, self.name, e)
frappe.exceptions.DuplicateEntryError: (‘Module Def’, ‘Accounts’, IntegrityError(1062, “Duplicate entry ‘Accounts’ for key ‘PRIMARY’”))

when I use the command " Bench -site yoursitename.com install-app erpnext

[avc]

Hi @Thaya_Govzig:

This happened because your previous app installation process has not been finished properly.
Check this video from Geoffrey Karani:

Integrity error while installing a frappe app | Frappe IntegrityError(1062)

Please open separate topic for this question next time
Hope this helps.