Support

Just an update on the migration, I never managed to hit the go button last weekend as my daughter banged her head.

I just completed it today woth lots of pulling of hair.

Errors encountered:

postgres-1  | 2024-06-22 02:33:27.732 UTC [288] ERROR:  function name "hot_rank" is not unique
postgres-1  | 2024-06-22 02:33:27.732 UTC [288] HINT:  Specify the argument list to select the function unambiguously.
postgres-1  | 2024-06-22 02:33:27.732 UTC [288] STATEMENT:  CREATE UNIQUE INDEX idx_site_aggregates_1_row_only ON site_aggregates ((TRUE));

I had two hot_rank functions in the DB, probably from back in the 0.19.0-rc line

drop FUNCTION hot_rank(numeric, timestamp without time zone) cascade; above to fix, but this was exasperated by psql for some reason not working well so had to be dropped from Docker:

ubuntu@lemmy:~/Lemmy-Easy-Deploy$ sudo docker exec -t lemmy-easy-deploy-postgres-1 psql -U lemmy -c 'drop FUNCTION hot_rank(numeric, timestamp without time zone) cascade;'

----> 'lemmy-ui' is still starting up. Log excerpt:

lemmy-ui-1  |     at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
lemmy-ui-1  |   [cause]: Error: connect EHOSTUNREACH 192.9.190.2:443
lemmy-ui-1  |       at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1607:16) {
lemmy-ui-1  |     errno: -113,
lemmy-ui-1  |     code: 'EHOSTUNREACH',
lemmy-ui-1  |     syscall: 'connect',
lemmy-ui-1  |     address: '192.9.190.2',
lemmy-ui-1  |     port: 443
lemmy-ui-1  |   }
lemmy-ui-1  | }

Caddy wasn't starting, although it was being created in the stack, had to manually start it___