problem applying postgres migrations: problem migrating: Dirty database version 5.

[etodanik]

Getting the following simply from changing the version in my toml:

2024-06-17 21:58:53 hasura-storage time="2024-06-17T18:58:53Z" level=error msg="problem applying postgres migrations: problem migrating: Dirty database version 5. Fix and force version."
2024-06-17 21:58:53 hasura-storage time="2024-06-17T18:58:53Z" level=info msg="applying postgres migrations"
2024-06-17 21:58:53 hasura-storage time="2024-06-17T18:58:53Z" level=info msg="Using static aws credentials"
2024-06-17 21:58:53 hasura-storage time="2024-06-17T18:58:53Z" level=info msg="storage version 0.6.0"

[dbarrosop]

a previous deploy probably failed due to some other reason and the storage migrations are not correctly applied. Ideally you'd dig for that error, otherwise, you could try looking into the migrations table in the storage schema and setting the dirty column to false

[etodanik]

I did it, and now seeing a new error:

2024-06-18 12:39:08 | hasura | {"detail":{"http_info":{"content_encoding":null,"http_version":"HTTP/1.1","ip":"10.110.30.110","method":"POST","status":400,"url":"/v1/metadata"},"operation":{"error":{"code":"invalid-configuration","error":"Inconsistent object: no such table/view exists in source: \"storage.virus\"","internal":[{"definition":{"name":"virus","schema":"storage"},"name":"table storage.virus in source default","reason":"Inconsistent object: no such table/view exists in source: \"storage.virus\"","type":"table"}],"path":"$.args"},"query":{"type":"pg_track_table"},"request_id":"28bd2539-c22c-446e-b584-a8be705cbec3","request_mode":"error","response_size":347,"uncompressed_response_size":347,"user_vars":{"x-hasura-role":"admin"}},"request_id":"28bd2539-c22c-446e-b584-a8be705cbec3"},"level":"error","span_id":"2802deaa80c88703","timestamp":"2024-06-18T09:39:07.235+0000","trace_id":"a193e303bddf355e1e7a0e584d21ff5a","type":"http-log"}
-- | -- | --
2024-06-18 12:39:08 | hasura | {"detail":{"http_info":{"content_encoding":null,"http_version":"HTTP/1.1","ip":"10.110.30.110","method":"POST","status":400,"url":"/v1/metadata"},"operation":{"error":{"code":"already-tracked","error":"view/table already tracked: \"storage.files\"","path":"$.args"},"query":{"type":"pg_track_table"},"request_id":"1ed9aa74-c737-413e-81dc-c5c29def6365","request_mode":"error","response_size":98,"uncompressed_response_size":98,"user_vars":{"x-hasura-role":"admin"}},"request_id":"1ed9aa74-c737-413e-81dc-c5c29def6365"},"level":"error","span_id":"fbfe5adca9d8f929","timestamp":"2024-06-18T09:39:07.235+0000","trace_id":"00d4019bde4402374be3d11d927cfea2","type":"http-log"}
2024-06-18 12:39:08 | hasura-storage | time="2024-06-18T09:39:08Z" level=error msg="problem applying hasura metadata: problem adding metadata for the virus table: status_code: 400\nresponse: {\"error\":\"Inconsistent object: no such table/view exists in source: \\\"storage.virus\\\"\",\"path\":\"$.args\",\"code\":\"invalid-configuration\",\"internal\":[{\"definition\":{\"name\":\"virus\",\"schema\":\"storage\"},\"name\":\"table storage.virus in source default\",\"reason\":\"Inconsistent object: no such table/view exists in source: \\\"storage.virus\\\"\",\"type\":\"table\"}]}"
2024-06-18 12:39:07 | hasura | {"detail":{"http_info":{"content_encoding":null,"http_version":"HTTP/1.1","ip":"10.110.30.110","method":"POST","status":400,"url":"/v1/metadata"},"operation":{"error":{"code":"already-tracked","error":"view/table already tracked: \"storage.buckets\"","path":"$.args"},"query":{"type":"pg_track_table"},"request_id":"9b412ec3-b138-4a17-bc18-825bc5b267e8","request_mode":"error","response_size":100,"uncompressed_response_size":100,"user_vars":{"x-hasura-role":"admin"}},"request_id":"9b412ec3-b138-4a17-bc18-825bc5b267e8"},"level":"error","span_id":"e89a0dd729d0adf6","timestamp":"2024-06-18T09:39:07.235+0000","trace_id":"6557d62ba56671eeb2f708a060a49999","type":"http-log"}

[dbarrosop]

Try running the migration #5 yourself:

CREATE TABLE IF NOT EXISTS storage.virus (
  id uuid DEFAULT public.gen_random_uuid () NOT NULL PRIMARY KEY,
  created_at timestamp with time zone DEFAULT now() NOT NULL,
  updated_at timestamp with time zone DEFAULT now() NOT NULL,
  file_id UUID NOT NULL REFERENCES storage.files(id),
  filename TEXT NOT NULL,
  virus TEXT NOT NULL,
  user_session JSONB NOT NULL
);

DROP TRIGGER IF EXISTS set_storage_virus_updated_at ON storage.virus;
CREATE TRIGGER set_storage_virus_updated_at
  BEFORE UPDATE ON storage.virus
  FOR EACH ROW
  EXECUTE FUNCTION storage.set_current_timestamp_updated_at ();

I am guessing it will fail but let's see the error.

[etodanik]

I'm using the nhost.io version of this, so I get permission denied for schema storage. Can't do it myself.

[dbarrosop]

Send an email to [email protected] and provide your subdomain. Thanks