Database Migrations Error

Divak · 2025-07-14T14:32:46.409Z

Hey there, I'm trying to set up the postgres database but for some reason it is encountering a syntax error. I believe that there should be quotation marks around the word all. I also looked through the repo but I can't seem to find where this sql query is. Please let me know what other info I should include ``` Query failed : { durationMs: 2.0561109999998735, error: PostgresError: syntax error at or near "all" at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) { severity_local: 'ERROR', severity: 'ERROR', code: '42601', position: '54', file: 'scan.l', line: '1245', routine: 'scanner_yyerror' }, sql: 'alter database "immich" set log_statement to all;', params: [] } ```

I

Immich•7/14/25, 2:32 PM

:wave: Hey @Divak,

Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.

References

Container Logs:
```
docker compose logs
```
```
docker compose logs
```
docs
Container Status:
```
docker ps -a
```
```
docker ps -a
```
docs
Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA

I

Immich•7/14/25, 2:32 PM

Checklist

I have...

:ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
:ballot_box_with_check: read applicable release notes.
:ballot_box_with_check: reviewed the FAQs for known issues.
:ballot_box_with_check: reviewed Github for known issues.
:ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
:ballot_box_with_check: uploaded the relevant information (see below).
:ballot_box_with_check: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

Information

In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:

Your docker-compose.yml and .env files.
Logs from all the containers and their status (see above).
All the troubleshooting steps you've tried so far.
Any recent changes you've made to Immich or your system.
Details about your system (both software/OS and hardware).
Details about your storage (filesystems, type of disks, output of commands like
```
fdisk -l
```
```
fdisk -l
```
and
```
df -h
```
```
df -h
```
).
The version of the Immich server, mobile app, and other relevant pieces.
Any other information that you think might be relevant.

Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)

If this ticket can be closed you can use the

/close

/close

command, and re-open it later if needed.

IImmich ## Checklist I have... 1. :ballot_box_with_check: verified I'm on the latest rel...

I

ImmichAPP•7/14/25, 2:34 PM

Successfully submitted, a tag has been added to inform contributors. :white_check_mark:

B

bo0tzz•7/14/25, 2:40 PM

Please post more detail like requested

D

DivakOP•7/14/25, 2:53 PM

I'm currently trying to deploy it using a dockerfile and an app_description. Dockerfile:

FROM ghcr.io/immich-app/immich-server:release
 
# Set environment variables for external AWS RDS PostgreSQL connection
ENV DB_HOSTNAME=${DB_HOSTNAME}
ENV DB_PORT=5432
# Variable name found in env.example file
ENV DB_DATABASE_NAME=${DB_DATABASE_NAME}
# Variable name found in env.example file
ENV DB_USERNAME=${DB_USERNAME}
ENV DB_PASSWORD=${DB_PASSWORD}
 
# Redis configuration
ENV REDIS_HOSTNAME=${REDIS_HOSTNAME}
ENV REDIS_PORT=${REDIS_PORT}
 
# Machine learning service URL
# ENV MACHINE_LEARNING_URL=${MACHINE_LEARNING_URL}
 
# Connection retry settings
ENV DB_CONNECTION_TIMEOUT=30
ENV REDIS_CONNECTION_TIMEOUT=30
 
# Vector extension settings
ENV VECTOR_EXTENSION="pgvector"
#Need to verify PG Vector extension is installed in the MedistranoPostgreSQL database
 
# Additional configuration for production
ENV NODE_ENV=production
ENV IMMICH_ENV=production
 
# Create upload directory with proper permissions
RUN mkdir -p /usr/src/app/upload && \
    chmod 755 /usr/src/app/upload
 
    # Create a startup script with better error handling
 
ADD https://raw.githubusercontent.com/vishnubob/wait-for-it/master/wait-for-it.sh /usr/local/bin/wait-for-it
RUN chmod +x /usr/local/bin/wait-for-it
RUN echo '#!/bin/bash\n\
set -e\n\
\n\
echo "Waiting for PostgreSQL..."\n\
wait-for-it -t 60 ${DB_HOSTNAME}:${DB_PORT} || { echo "PostgreSQL connection failed"; exit 1; }\n\
\n\
echo "Waiting for Redis..."\n\
wait-for-it -t 60 ${REDIS_HOSTNAME}:${REDIS_PORT} || { echo "Redis connection failed"; exit 1; }\n\
\n\
echo "All services are available, starting Immich..."\n\
exec /usr/src/app/start.sh\n' > /usr/local/bin/startup.sh && \
    chmod +x /usr/local/bin/startup.sh
 
# Set the working directory
WORKDIR /usr/src/app
 
# Expose the server port
EXPOSE 2283
 
# Use the default entrypoint and command from the base image
ENTRYPOINT ["tini", "--", "/bin/bash"]
CMD ["/usr/local/bin/startup.sh"]

FROM ghcr.io/immich-app/immich-server:release
 
# Set environment variables for external AWS RDS PostgreSQL connection
ENV DB_HOSTNAME=${DB_HOSTNAME}
ENV DB_PORT=5432
# Variable name found in env.example file
ENV DB_DATABASE_NAME=${DB_DATABASE_NAME}
# Variable name found in env.example file
ENV DB_USERNAME=${DB_USERNAME}
ENV DB_PASSWORD=${DB_PASSWORD}
 
# Redis configuration
ENV REDIS_HOSTNAME=${REDIS_HOSTNAME}
ENV REDIS_PORT=${REDIS_PORT}
 
# Machine learning service URL
# ENV MACHINE_LEARNING_URL=${MACHINE_LEARNING_URL}
 
# Connection retry settings
ENV DB_CONNECTION_TIMEOUT=30
ENV REDIS_CONNECTION_TIMEOUT=30
 
# Vector extension settings
ENV VECTOR_EXTENSION="pgvector"
#Need to verify PG Vector extension is installed in the MedistranoPostgreSQL database
 
# Additional configuration for production
ENV NODE_ENV=production
ENV IMMICH_ENV=production
 
# Create upload directory with proper permissions
RUN mkdir -p /usr/src/app/upload && \
    chmod 755 /usr/src/app/upload
 
    # Create a startup script with better error handling
 
ADD https://raw.githubusercontent.com/vishnubob/wait-for-it/master/wait-for-it.sh /usr/local/bin/wait-for-it
RUN chmod +x /usr/local/bin/wait-for-it
RUN echo '#!/bin/bash\n\
set -e\n\
\n\
echo "Waiting for PostgreSQL..."\n\
wait-for-it -t 60 ${DB_HOSTNAME}:${DB_PORT} || { echo "PostgreSQL connection failed"; exit 1; }\n\
\n\
echo "Waiting for Redis..."\n\
wait-for-it -t 60 ${REDIS_HOSTNAME}:${REDIS_PORT} || { echo "Redis connection failed"; exit 1; }\n\
\n\
echo "All services are available, starting Immich..."\n\
exec /usr/src/app/start.sh\n' > /usr/local/bin/startup.sh && \
    chmod +x /usr/local/bin/startup.sh
 
# Set the working directory
WORKDIR /usr/src/app
 
# Expose the server port
EXPOSE 2283
 
# Use the default entrypoint and command from the base image
ENTRYPOINT ["tini", "--", "/bin/bash"]
CMD ["/usr/local/bin/startup.sh"]

FROM ghcr.io/immich-app/immich-server:release
 
# Set environment variables for external AWS RDS PostgreSQL connection
ENV DB_HOSTNAME=${DB_HOSTNAME}
ENV DB_PORT=5432
# Variable name found in env.example file
ENV DB_DATABASE_NAME=${DB_DATABASE_NAME}
# Variable name found in env.example file
ENV DB_USERNAME=${DB_USERNAME}
ENV DB_PASSWORD=${DB_PASSWORD}
 
# Redis configuration
ENV REDIS_HOSTNAME=${REDIS_HOSTNAME}
ENV REDIS_PORT=${REDIS_PORT}
 
# Machine learning service URL
# ENV MACHINE_LEARNING_URL=${MACHINE_LEARNING_URL}
 
# Connection retry settings
ENV DB_CONNECTION_TIMEOUT=30
ENV REDIS_CONNECTION_TIMEOUT=30
 
# Vector extension settings
ENV VECTOR_EXTENSION="pgvector"
#Need to verify PG Vector extension is installed in the MedistranoPostgreSQL database
 
# Additional configuration for production
ENV NODE_ENV=production
ENV IMMICH_ENV=production
 
# Create upload directory with proper permissions
RUN mkdir -p /usr/src/app/upload && \
    chmod 755 /usr/src/app/upload
 
    # Create a startup script with better error handling
 
ADD https://raw.githubusercontent.com/vishnubob/wait-for-it/master/wait-for-it.sh /usr/local/bin/wait-for-it
RUN chmod +x /usr/local/bin/wait-for-it
RUN echo '#!/bin/bash\n\
set -e\n\
\n\
echo "Waiting for PostgreSQL..."\n\
wait-for-it -t 60 ${DB_HOSTNAME}:${DB_PORT} || { echo "PostgreSQL connection failed"; exit 1; }\n\
\n\
echo "Waiting for Redis..."\n\
wait-for-it -t 60 ${REDIS_HOSTNAME}:${REDIS_PORT} || { echo "Redis connection failed"; exit 1; }\n\
\n\
echo "All services are available, starting Immich..."\n\
exec /usr/src/app/start.sh\n' > /usr/local/bin/startup.sh && \
    chmod +x /usr/local/bin/startup.sh
 
# Set the working directory
WORKDIR /usr/src/app
 
# Expose the server port
EXPOSE 2283
 
# Use the default entrypoint and command from the base image
ENTRYPOINT ["tini", "--", "/bin/bash"]
CMD ["/usr/local/bin/startup.sh"]

FROM ghcr.io/immich-app/immich-server:release
 
# Set environment variables for external AWS RDS PostgreSQL connection
ENV DB_HOSTNAME=${DB_HOSTNAME}
ENV DB_PORT=5432
# Variable name found in env.example file
ENV DB_DATABASE_NAME=${DB_DATABASE_NAME}
# Variable name found in env.example file
ENV DB_USERNAME=${DB_USERNAME}
ENV DB_PASSWORD=${DB_PASSWORD}
 
# Redis configuration
ENV REDIS_HOSTNAME=${REDIS_HOSTNAME}
ENV REDIS_PORT=${REDIS_PORT}
 
# Machine learning service URL
# ENV MACHINE_LEARNING_URL=${MACHINE_LEARNING_URL}
 
# Connection retry settings
ENV DB_CONNECTION_TIMEOUT=30
ENV REDIS_CONNECTION_TIMEOUT=30
 
# Vector extension settings
ENV VECTOR_EXTENSION="pgvector"
#Need to verify PG Vector extension is installed in the MedistranoPostgreSQL database
 
# Additional configuration for production
ENV NODE_ENV=production
ENV IMMICH_ENV=production
 
# Create upload directory with proper permissions
RUN mkdir -p /usr/src/app/upload && \
    chmod 755 /usr/src/app/upload
 
    # Create a startup script with better error handling
 
ADD https://raw.githubusercontent.com/vishnubob/wait-for-it/master/wait-for-it.sh /usr/local/bin/wait-for-it
RUN chmod +x /usr/local/bin/wait-for-it
RUN echo '#!/bin/bash\n\
set -e\n\
\n\
echo "Waiting for PostgreSQL..."\n\
wait-for-it -t 60 ${DB_HOSTNAME}:${DB_PORT} || { echo "PostgreSQL connection failed"; exit 1; }\n\
\n\
echo "Waiting for Redis..."\n\
wait-for-it -t 60 ${REDIS_HOSTNAME}:${REDIS_PORT} || { echo "Redis connection failed"; exit 1; }\n\
\n\
echo "All services are available, starting Immich..."\n\
exec /usr/src/app/start.sh\n' > /usr/local/bin/startup.sh && \
    chmod +x /usr/local/bin/startup.sh
 
# Set the working directory
WORKDIR /usr/src/app
 
# Expose the server port
EXPOSE 2283
 
# Use the default entrypoint and command from the base image
ENTRYPOINT ["tini", "--", "/bin/bash"]
CMD ["/usr/local/bin/startup.sh"]

D

DivakOP•7/14/25, 2:53 PM

app_description:

{
  "version": 2,
  "build": {
    "images": {
      "default": {
        "filename": "Dockerfile"
      }
    }
  },
  "config": {
    "schema": {
      "type": "object",
      "properties": {
        "DB_HOSTNAME": {
          "type": "string",
          "description": "PostgreSQL database hostname (AWS RDS endpoint)"
        },
        "DB_DATABASE_NAME": {
          "type": "string",
          "description": "PostgreSQL database name"
        },
        "DB_USERNAME": {
          "type": "string",
          "description": "PostgreSQL database username"
        },
        "DB_PASSWORD": {
          "type": "string",
          "description": "PostgreSQL database password"
        },
        "REDIS_HOSTNAME": {
          "type": "string",
          "description": "Redis hostname"
        },
        "REDIS_PORT": {
          "type": "string",
          "description": "Redis port"
        }
      }
    }
  },
  "deploy": {
    "tasks": [
      {
        "name": "immich-server",
        "type": "service",
        "build_image_key": "default",
        "command": "/usr/local/bin/startup.sh",
        "listening_ports": [2283],
        "max_ram": 2048,
        "health_check": {
          "path": "/api/server/ping",
          "grace_period_seconds": 60
        },
        "liveness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "readiness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "external_port": 2283,
        "protocol_version": "http1",
        "timeout_minutes": 15
      }
    ],
    "deploy_tasks": [
      {
        "name": "immich-server",
        "variant_name": "nonprod"
      }
    ]
  }
}

{
  "version": 2,
  "build": {
    "images": {
      "default": {
        "filename": "Dockerfile"
      }
    }
  },
  "config": {
    "schema": {
      "type": "object",
      "properties": {
        "DB_HOSTNAME": {
          "type": "string",
          "description": "PostgreSQL database hostname (AWS RDS endpoint)"
        },
        "DB_DATABASE_NAME": {
          "type": "string",
          "description": "PostgreSQL database name"
        },
        "DB_USERNAME": {
          "type": "string",
          "description": "PostgreSQL database username"
        },
        "DB_PASSWORD": {
          "type": "string",
          "description": "PostgreSQL database password"
        },
        "REDIS_HOSTNAME": {
          "type": "string",
          "description": "Redis hostname"
        },
        "REDIS_PORT": {
          "type": "string",
          "description": "Redis port"
        }
      }
    }
  },
  "deploy": {
    "tasks": [
      {
        "name": "immich-server",
        "type": "service",
        "build_image_key": "default",
        "command": "/usr/local/bin/startup.sh",
        "listening_ports": [2283],
        "max_ram": 2048,
        "health_check": {
          "path": "/api/server/ping",
          "grace_period_seconds": 60
        },
        "liveness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "readiness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "external_port": 2283,
        "protocol_version": "http1",
        "timeout_minutes": 15
      }
    ],
    "deploy_tasks": [
      {
        "name": "immich-server",
        "variant_name": "nonprod"
      }
    ]
  }
}

{
  "version": 2,
  "build": {
    "images": {
      "default": {
        "filename": "Dockerfile"
      }
    }
  },
  "config": {
    "schema": {
      "type": "object",
      "properties": {
        "DB_HOSTNAME": {
          "type": "string",
          "description": "PostgreSQL database hostname (AWS RDS endpoint)"
        },
        "DB_DATABASE_NAME": {
          "type": "string",
          "description": "PostgreSQL database name"
        },
        "DB_USERNAME": {
          "type": "string",
          "description": "PostgreSQL database username"
        },
        "DB_PASSWORD": {
          "type": "string",
          "description": "PostgreSQL database password"
        },
        "REDIS_HOSTNAME": {
          "type": "string",
          "description": "Redis hostname"
        },
        "REDIS_PORT": {
          "type": "string",
          "description": "Redis port"
        }
      }
    }
  },
  "deploy": {
    "tasks": [
      {
        "name": "immich-server",
        "type": "service",
        "build_image_key": "default",
        "command": "/usr/local/bin/startup.sh",
        "listening_ports": [2283],
        "max_ram": 2048,
        "health_check": {
          "path": "/api/server/ping",
          "grace_period_seconds": 60
        },
        "liveness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "readiness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "external_port": 2283,
        "protocol_version": "http1",
        "timeout_minutes": 15
      }
    ],
    "deploy_tasks": [
      {
        "name": "immich-server",
        "variant_name": "nonprod"
      }
    ]
  }
}

{
  "version": 2,
  "build": {
    "images": {
      "default": {
        "filename": "Dockerfile"
      }
    }
  },
  "config": {
    "schema": {
      "type": "object",
      "properties": {
        "DB_HOSTNAME": {
          "type": "string",
          "description": "PostgreSQL database hostname (AWS RDS endpoint)"
        },
        "DB_DATABASE_NAME": {
          "type": "string",
          "description": "PostgreSQL database name"
        },
        "DB_USERNAME": {
          "type": "string",
          "description": "PostgreSQL database username"
        },
        "DB_PASSWORD": {
          "type": "string",
          "description": "PostgreSQL database password"
        },
        "REDIS_HOSTNAME": {
          "type": "string",
          "description": "Redis hostname"
        },
        "REDIS_PORT": {
          "type": "string",
          "description": "Redis port"
        }
      }
    }
  },
  "deploy": {
    "tasks": [
      {
        "name": "immich-server",
        "type": "service",
        "build_image_key": "default",
        "command": "/usr/local/bin/startup.sh",
        "listening_ports": [2283],
        "max_ram": 2048,
        "health_check": {
          "path": "/api/server/ping",
          "grace_period_seconds": 60
        },
        "liveness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "readiness_probe": {
          "path": "/api/server/ping",
          "initial_delay_seconds": 30,
          "period_seconds": 15,
          "success_threshold": 1,
          "failure_threshold": 5
        },
        "external_port": 2283,
        "protocol_version": "http1",
        "timeout_minutes": 15
      }
    ],
    "deploy_tasks": [
      {
        "name": "immich-server",
        "variant_name": "nonprod"
      }
    ]
  }
}

D

DivakOP•7/14/25, 2:53 PM

It should be noted that I'm trying to use an AWS RDS instance for the postgres server

D

DivakOP•7/14/25, 2:53 PM

And I didn't paste the .env file due to privacy concerns

B

bo0tzz•7/14/25, 2:54 PM

This seems like a very odd deployment, not sure we can really help with it

D

DivakOP•7/14/25, 2:54 PM

Should be noted that when I set db_skip_migrations to true, the error goes away, but then since the tables aren't created there are other errors

Bbo0tzz This seems like a very odd deployment, not sure we can really help with it

D

DivakOP•7/14/25, 2:55 PM

Gotcha

D

DivakOP•7/14/25, 2:56 PM

It just seems weird that a syntax error like this would appear because of a deployment

B

bo0tzz•7/14/25, 2:56 PM

I'm guessing this is something about RDS not being perfectly postgres compatible or something, idk

B

bo0tzz•7/14/25, 2:56 PM

or locking down db parameters or whatever

D

DivakOP•7/14/25, 2:57 PM

I see

D

DivakOP•7/14/25, 2:57 PM

I wonder if there's anyone else who deployed their db on AWS

Database Migrations Error

References

Checklist

Information

Similar Threads

Similar Threads

References

Checklist

Information

Similar Threads