Problem when updating to last v14 version

Hello,

I have been stucked with this for a couple of weeks now.

I recently moved from Ubuntu v20 and ERPNext V13 to Ubuntu v22 and ERPNext v14.

It was going everything very well, but when I updated to the last version:

**ERPNext:** v14.4.0 (version-14)
**Frappe Framework:** v14.13.0 (version-14)
**WooCommerce Connector:** v1.7.0 (master)

I have a problem that I stop being able to browse my invoices.

I can see the list of invoices, but if I try to open one of them, nothing happens. The browser displays the link to that particular invoice on the url bar, but the view stays on the list of invoices. This happens with all of them.

I can’t see any error meaningful on the console, nor on Error Doctype inside ERPNext.

I see on worker error log, connection errors to Redis, and errors of Cryptography, but everything else seems to be fine. As:

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/erp/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 109, in <module>
    main()
  File "/home/erp/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/home/erp/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/erp/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/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/home/erp/frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 189, in start_worker
    start_worker(queue, quiet=quiet, rq_username=rq_username, rq_password=rq_password)
  File "/home/erp/frappe-bench/apps/frappe/frappe/utils/background_jobs.py", line 218, in start_worker
    Worker(queues, name=get_worker_name(queue_name)).work(logging_level=logging_level)
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/rq/worker.py", line 637, in work
    self.register_death()
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/rq/worker.py", line 337, in register_death
    p.execute()
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/redis/client.py", line 4012, in execute
    conn = self.connection_pool.get_connection('MULTI',
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/redis/connection.py", line 1192, in get_connection
    connection.connect()
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/redis/connection.py", line 563, in connect
    raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
ERROR	PropertyValue: Missing token for production Choice(ColorValue, Dimension, URIValue, Value, variable, MSValue, CSSCalc, function): ('HASH', '#0000001a', 1, 3198)
ERROR	PropertyValue: Unknown syntax or no value: 0 3px 6px #0000001a
ERROR	CSSStyleDeclaration: Syntax Error in Property: box-shadow:0 3px 6px #0000001a

On web log error logs there are warnings and errors as:

serWarning: The 'filters_config' hook used to add custom operators is not yet implemented in frappe.db.query engine. Use db_query (frappe.get_list) instead.
and
TypeError: Object of type <class 're.Match'> with value of <re.Match object; span=(8, 12), match='1978'> is not JSON serializable

If I go back to backup before last update, everything goes back to normal.

I forgot to tell that the route to each invoice is like this:

https://erp1.domain.com/app/sales-invoice/2022/082

The code of each invoice is like this 2022/###. Could this be something related to routes?

Many thanks for your help and kind regards from Spain,

try bench migrate --skip-failing

Hi @nomi-gee ,

Many thanks for your prompt reply.

Did as you suggested: bench --site erp.domain.com migrate --skip-failing

That produces no error, finishes well, but the problem is still there afterwards.

Many thanks and kind regards,

yes … which branch you are using develop or version-14

Thanks.

I would say that I am in production version-14.

**ERPNext:** v14.4.0 (version-14)
**Frappe Framework:** v14.13.0 (version-14)
**WooCommerce Connector:** v1.7.0 (master)

This is what I see in About.

Thanks and kind regards,

Alb

Can you login to server and share output

sudo systemctl status redis-server.service

and

sudo lsof -i :11000

Thanks @nomi-gee.

Here are the outputs:

redis-server.service - Advanced key-value store
     Loaded: loaded (/lib/systemd/system/redis-server.service; enabled; vendor >
     Active: active (running) since Sun 2022-10-30 20:15:21 UTC; 14h ago
       Docs: http://redis.io/documentation,
             man:redis-server(1)
   Main PID: 622 (redis-server)
     Status: "Ready to accept connections"
      Tasks: 5 (limit: 9257)
     Memory: 6.5M
        CPU: 1min 42.427s
     CGroup: /system.slice/redis-server.service
             └─622 "/usr/bin/redis-server 127.0.0.1:6379" "" "" "" "" "" "" "" >

Oct 30 20:15:21 ubuntu-4gb-fsn1-1 systemd[1]: Starting Advanced key-value store>
Oct 30 20:15:21 ubuntu-4gb-fsn1-1 systemd[1]: Started Advanced key-value store.

And:


COMMAND   PID        USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
redis-ser 835 erp    6u  IPv4  19002      0t0  TCP localhost:11000 (LISTEN)
redis-ser 835 erp    7u  IPv4  19561      0t0  TCP localhost:11000->localhost:47626 (ESTABLISHED)
redis-ser 835 erp    8u  IPv4  19563      0t0  TCP localhost:11000->localhost:47638 (ESTABLISHED)
redis-ser 835 erp    9u  IPv4  19565      0t0  TCP localhost:11000->localhost:47652 (ESTABLISHED)
redis-ser 835 erp   10u  IPv4  19133      0t0  TCP localhost:11000->localhost:47658 (ESTABLISHED)
redis-ser 835 erp   11u  IPv4  19135      0t0  TCP localhost:11000->localhost:47670 (ESTABLISHED)
redis-ser 835 erp   12u  IPv4  19137      0t0  TCP localhost:11000->localhost:47674 (ESTABLISHED)
redis-ser 835 erp   13u  IPv4 259653      0t0  TCP localhost:11000->localhost:36002 (ESTABLISHED)
redis-ser 835 erp   14u  IPv4 259655      0t0  TCP localhost:11000->localhost:36012 (ESTABLISHED)
redis-ser 835 erp   15u  IPv4 259657      0t0  TCP localhost:11000->localhost:36016 (ESTABLISHED)
python    839 erp    5u  IPv4 258809      0t0  TCP localhost:36002->localhost:11000 (ESTABLISHED)
python    839 erp    6u  IPv4 258814      0t0  TCP localhost:36012->localhost:11000 (ESTABLISHED)
python    839 erp    7u  IPv4 258819      0t0  TCP localhost:36016->localhost:11000 (ESTABLISHED)
python    840 erp    3u  IPv4  19560      0t0  TCP localhost:47626->localhost:11000 (ESTABLISHED)
python    840 erp    4u  IPv4  19571      0t0  TCP localhost:47658->localhost:11000 (ESTABLISHED)
python    849 erp    3u  IPv4  19578      0t0  TCP localhost:47670->localhost:11000 (ESTABLISHED)
python    849 erp    4u  IPv4  19583      0t0  TCP localhost:47674->localhost:11000 (ESTABLISHED)
python    850 erp    3u  IPv4  19127      0t0  TCP localhost:47638->localhost:11000 (ESTABLISHED)
python    850 erp    4u  IPv4  19132      0t0  TCP localhost:47652->localhost:11000 (ESTABLISHED)

Thanks and kind regards,

Alb

All is working fine for you. this might be the issue you are facing. Frappe team will fix it soon I think

1 Like

Hi @nomi-gee,

Many thanks for all your help!!

I had the suspicion that this had to do with the naming series.

I will revert to my backup and wait for a fix.

Many thanks and kind regards from Spain,

Alb

1 Like