• 136 Posts
  • 561 Comments
Joined 1 year ago
cake
Cake day: June 8th, 2023

help-circle













  • 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___