unsupported jsonb version number 123

[lordyod]

I'm getting this error repeatedly and not able to figure out what might be causing it.

[ERROR] [HTTP:Internal Server Error] / => store: unable to create app session: pq: unsupported jsonb version number 123
[ERROR] [HTTP:Internal Server Error] /favicon.ico => store: unable to create app session: pq: unsupported jsonb version number 123

This is occurring with miniflux-2.0.36-r7 x86_64 installed on alpine, connected to postgres 14 using schema version 63. Up until this week it was a stable install so I'm not sure if something got corrupted or what.

[fguillot]

I'm not able to reproduce this issue with the information provided.

[jenrik]

I'm facing the same issue, and I'm running version 2.1.3. It started appearing after setting binary_parameters=yes in the DATABASE_URL, and it stopped after I removed it.

Related postgresql logs:

patroni 2024-06-06 10:53:30 UTC [114680]: db=miniflux,user=miniflux,app=app - 127.0.0.1:50180,client=[local] ERROR:  unsupported jsonb version number 123
patroni 2024-06-06 10:53:30 UTC [114680]: db=miniflux,user=miniflux,app=app - 127.0.0.1:50180,client=[local] CONTEXT:  unnamed portal parameter $2
patroni 2024-06-06 10:53:30 UTC [114680]: db=miniflux,user=miniflux,app=app - 127.0.0.1:50180,client=[local] STATEMENT:  INSERT INTO sessions (id, data) VALUES ($1, $2)
patroni 2024-06-06 10:53:30 UTC [114680]: db=miniflux,user=miniflux,app=app - 127.0.0.1:50180,client=[local] ERROR:  unsupported jsonb version number 123
patroni 2024-06-06 10:53:30 UTC [114680]: db=miniflux,user=miniflux,app=app - 127.0.0.1:50180,client=[local] CONTEXT:  unnamed portal parameter $2
patroni 2024-06-06 10:53:30 UTC [114680]: db=miniflux,user=miniflux,app=app - 127.0.0.1:50180,client=[local] STATEMENT:  INSERT INTO sessions (id, data) VALUES ($1, $2)

Related miniflux logs:

{
  "level": "ERROR",
  "msg": "Internal Server Error",
  "error": "store: unable to create app session: pq: unsupported jsonb version number 123",
  "client_ip": "1.2.3.4",
  "request": {
    "method": "GET",
    "uri": "/",
    "user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:126.0) Gecko/20100101 Firefox/126.0"
  },
  "response": {
    "status_code": 500
  }
}
{
  "level": "ERROR",
  "msg": "Internal Server Error",
  "error": "store: unable to create app session: pq: unsupported jsonb version number 123",
  "client_ip": "1.2.3.4",
  "request": {
    "method": "GET",
    "uri": "/favicon.ico",
    "user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:126.0) Gecko/20100101 Firefox/126.0"
  },
  "response": {
    "status_code": 500
  }
}