Your system is being updated. Please refresh again after a few moments Status 503, While upgrade to latest version 12_4

after upgrade
File “/usr/lib/python3.5/runpy.py”, line 184, 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/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
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.5/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/home/frappe/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/frappe/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/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/home/frappe/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/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 233, in migrate
migrate(context.verbose, rebuild_website=rebuild_website, skip_failing=skip_failing)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 48, in migrate
frappe.modules.patch_handler.run_all(skip_failing)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 41, in run_all
run_patch(patch)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 30, in run_patch
if not run_single(patchmodule = patch):
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 71, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 91, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v12_0/update_gst_category.py”, line 14, in execute
“”")
File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 171, in sql
self._cursor.execute(query)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/frappe/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/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 732, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, “Unknown column ‘customer_gstin’ in ‘where clause’”)

$- bench start

14:05:38 system | redis_queue.1 started (pid=3668)
14:05:38 redis_queue.1 | 3673:M 27 Jan 14:05:38.684 * Increased maximum number of open files to 10032 (it was originally set to 1024).
14:05:38 redis_queue.1 | 3673:M 27 Jan 14:05:38.684 # Creating Server TCP listening socket 127.0.0.1:11000: bind: Address already in use
14:05:38 system | redis_queue.1 stopped (rc=1)
14:05:38 system | worker_short.1 started (pid=3667)
14:05:38 system | redis_cache.1 started (pid=3666)
14:05:38 system | redis_socketio.1 started (pid=3669)
14:05:38 redis_socketio.1 | 3676:M 27 Jan 14:05:38.692 * Increased maximum number of open files to 10032 (it was originally set to 1024).
14:05:38 redis_cache.1 | 3675:M 27 Jan 14:05:38.714 * Increased maximum number of open files to 10032 (it was originally set to 1024).
14:05:38 redis_cache.1 | 3675:M 27 Jan 14:05:38.714 # Creating Server TCP listening socket 127.0.0.1:13000: bind: Address already in use
14:05:38 system | worker_default.1 started (pid=3670)
14:05:38 system | redis_cache.1 stopped (rc=1)
14:05:38 system | web.1 started (pid=3671)
14:05:38 system | worker_long.1 started (pid=3672)
14:05:38 redis_socketio.1 | 3676:M 27 Jan 14:05:38.723 # Creating Server TCP listening socket 127.0.0.1:12000: bind: Address already in use
14:05:38 system | redis_socketio.1 stopped (rc=1)
14:05:38 system | schedule.1 started (pid=3685)
14:05:38 system | watch.1 started (pid=3688)
14:05:38 system | socketio.1 started (pid=3689)
14:05:38 system | sending SIGTERM to worker_short.1 (pid 3667)
14:05:38 system | sending SIGTERM to worker_default.1 (pid 3670)
14:05:38 system | sending SIGTERM to worker_long.1 (pid 3672)
14:05:38 system | sending SIGTERM to web.1 (pid 3671)
14:05:38 system | sending SIGTERM to schedule.1 (pid 3685)
14:05:38 system | sending SIGTERM to watch.1 (pid 3688)
14:05:38 system | sending SIGTERM to socketio.1 (pid 3689)
14:05:38 system | watch.1 stopped (rc=-15)
14:05:38 system | web.1 stopped (rc=-15)
14:05:38 system | socketio.1 stopped (rc=-15)
14:05:38 system | worker_default.1 stopped (rc=-15)
14:05:38 system | worker_short.1 stopped (rc=-15)
14:05:38 system | worker_long.1 stopped (rc=-15)
14:05:38 system | schedule.1 stopped (rc=-15)

Try doing a bench migrate and check your port because the start error is that the address 127.0.0.1:12000 is already in use. If there is nothing that you know is using it, try to restart your computer to check if it stops being in use.

Migrating site1.local
Executing erpnext.patches.v12_0.update_gst_category in site1.local (_1bd3e0294da19198)
Traceback (most recent call last):
File “/usr/lib/python3.5/runpy.py”, line 184, 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/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
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.5/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/home/frappe/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/frappe/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/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/home/frappe/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/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 233, in migrate
migrate(context.verbose, rebuild_website=rebuild_website, skip_failing=skip_failing)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 48, in migrate
frappe.modules.patch_handler.run_all(skip_failing)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 41, in run_all
run_patch(patch)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 30, in run_patch
if not run_single(patchmodule = patch):
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 71, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 91, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v12_0/update_gst_category.py”, line 14, in execute
“”")
File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 171, in sql
self._cursor.execute(query)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/frappe/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/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 732, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, “Unknown column ‘customer_gstin’ in ‘where clause’”)

_________–
I m getting above error after bench migrate

Hi @Abid_Jagrala

What version are you on? Have you tried running bench update --patch ?

Kind regards,

It sounds like the message that is posted when you try to access a frappe/erpnext server that has had the maintenance mode turned on.

Try going the the frappe-bench directory and typing the following command:

bench set-maintenance-mode off

I seem to remember getting the message you describe if I forget to turn off the maintenance mode after I am doing bench updates. It is possible that something happened during an update and the maintenance mode was not returned to the off setting before the process ended.

Just a thought, but worth trying.

BKM

This is because the migrate can’t end in a nice way and after that it does not deactivate the maintenance mode. If you deactivate the maintenance mode manually you are likely to get bugs in the erp because the migrate does not end successfully. You need to solve the migrate problem first. Start by doing a bench update --patch and bench update --requirements. Or search in the forum for “Unknown column ‘customer_gstin’ in ‘where clause’” I think that i already saw that error in here.

In a side note, a quick and ugly solution would be to comment the content of this patch update_gst_category or removing it from patches.txt

Welcome to ERPNext!

Lots of helpful advise for sure…

To rebuild and recompile the code can often help?

frappe@erpnext:~/frappe-bench$ bench build
frappe@erpnext:~/frappe-bench$ find . -name '*.pyc' -delete

Also note the travis tests run Python 3.6 while you are running Python 3.5.
So eventually you may want to switch [SOLVED] Frappe v11 + python3 + Ldap - #3 by vrms