After entering username and password screen gets hanged

ERPNext User Forum
1

Hello,

When I open erpnext i get the login but after entering username and password I got a modal window:

Session Start Failed
Close
u’print’

on the javascript console I get :
Uncaught boot failed desk.min.js:1173 ​

I clean the browser cache and cookies and I also run bench clear-cache && bench clear-website-cache

Doing bench update gets the next error :
Traceback (most recent call last): File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main "__main__", fname, loader, pkg_name) File "/usr/lib/python2.7/runpy.py", line 72, in _run_code exec code in run_globals File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", lin e 79, in <module> main() File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", lin e 16, in main click.Group(commands=commands)(prog_name='bench') File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/co re.py", line 722, in __call__ return self.main(*args, **kwargs) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/co re.py", line 697, in main rv = self.invoke(ctx) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/co re.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/co re.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/co re.py", line 895, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/co re.py", line 535, in invoke return callback(*args, **kwargs) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/de corators.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 24, in _func ret = f(frappe._dict(ctx.obj), *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 211 , in migrate migrate(context.verbose, rebuild_website=rebuild_website) File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 31, in mi grate frappe.modules.patch_handler.run_all() File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 29, in run_all if not run_single(patchmodule = patch): File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 89, in execute_patch frappe.db.rollback() File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 737, in rollback self.sql("rollback") File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 149, in sql self._cursor.execute(query) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/ cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/ connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')
By the way I’m running the .ova

Any ideas ?

Thanks
Pepe

2

The issue is mostly on your DB scaling on the server, you might need to run free -m to check how much ram is available because most likely MySQL is dying because the ram is not enough.

3

I think that I have enough memory :
$ free -m total used free shared buffers cached Mem: 3943 1261 2681 0 123 701 -/+ buffers/cache: 436 3507 Swap: 764 0 764

4

@Jose_Alberto_Magana Ya a that is enough, could you retry again after restarting the server?
MYSQL socket might have hiccup

5

I restarted the server the vm and tried again and now I get the message :

Updating
Your system is being updated. Please refresh again after a few moments

Status: 503

bench update will trigger the same error :confused:

File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/ connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')
6

@Jose_Alberto_Magana
i think I might know the issue. (not really sure because I am not on the server side to run diagnoses)

the first issue (error 503) means there is an error either by nginx or supervisor, run the following commands please:

bench setup nginx
bench setup supervisor
bench setup mysql (not sure this will work or not but it should…i think)
service nginx restart
service mysql restart
service supervisor restart

if you are lazy to copy paste all of them then use this:

bench setup nginx &&bench setup supervisor && bench setup mysql && service nginx restart && service mysql restart && service supervisor restart

P.s: again, I use I think or am not sure because I am not on the server side and just reading what you experience.

7

@ramielian I did what you said but the same error is triggered…
I backup my site erp.foobar.com with files, then I deleted files and database from erp.foobar.com and finally I recreate the site erp.foobar.com
with the next commands:

bench new-site erp.foobar.com
bench --site erp.foobar.com install-app erpnext
bench update

Now bench update works correctly but restoring the database will trigger the next error :

Error
SQL query:
CREATE TABLE __Auth (
doctype varchar(140) COLLATE utf8mb4_unicode_ci NOT NULL,
name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
fieldname varchar(140) COLLATE utf8mb4_unicode_ci NOT NULL,
password varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
salt varchar(140) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
encrypted int(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (doctype,name,fieldname)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED;

#1071 - Specified key was too long; max key length is 767 bytes

So it seems that the database was corrupted

8

i have the same problem too, did you found out how to fix this?

`
Updating DocTypes for frappe : [========================================]
Syncing help database…
Traceback (most recent call last):
File “/Users/xcorex/.pyenv/versions/2.7.12/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/Users/xcorex/.pyenv/versions/2.7.12/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/commands/site.py”, line 214, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/migrate.py”, line 52, in migrate
frappe.utils.help.sync()
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/utils/help.py”, line 23, in sync
help_db.make_table()
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/utils/help.py”, line 80, in make_table
CHARACTER SET=utf8mb4’‘’)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/apps/frappe/frappe/database.py”, line 149, in sql
self._cursor.execute(query)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/Users/xcorex/Documents/Projects/Erpnext/sample1/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1071, ‘Specified key was too long; max key length is 1000 bytes’)

`

9

Not yet… I’m starting a new VM with official ova but when I run bench update --upgrade I got the same error so I can’t restore the backup
Maybe I will try the ova from bitnami that seems to be more stable and running on debian 64bits

10

install mariadb fixed my error (before im using mysql)

1 Like
11

bench setup mysql gave result “no such command”

service mysql restart permission denied

service supervisor restart NOT ALLOWED permission denied

1 Like