# Warehouse Errors

## ERROR: Schema "XXX" does not exist. (SQLSTATE 3F000)

This is a permissioning issue. To learn how to set up proper permissions, you can check out our [Postgres](/docs/segment/connections/storage/catalog/postgres/) and [Redshift](/docs/segment/connections/storage/catalog/redshift/) guides.

## ERROR: Cannot execute query because system is in resize mode (SQLSTATE 57014)

This error occurs when your cluster is currently resizing. The warehouse will continue on its scheduled run interval - once the resize is complete, we'll load all data from the failed run.

## ERROR: 1040 (SQLSTATE XX000)

This is a Redshift 500 - an internal server error. This is usually caused by having too many tables or too many columns. If you're seeing this error, [contact the Segment Support team](https://segment.com/help/contact/).

## read tcp XXX.XX.XX.XXXX:XXXX-XXX.XX.XX.XXXX:XXXX: read: connection timed out

This is a networking error that typically arises when Redshift doesn't close properly close the connection or gets rebooted.

If you see this error on consecutive syncs, [contact us](https://segment.com/help/contact/).

## pq: role "XXX" is not permitted to log in

This is a permissioning issue. To learn how to set up proper permissions, you can check out our [postgres](/docs/segment/connections/storage/catalog/postgres/) and [redshift](/docs/segment/connections/storage/catalog/redshift/) guides.

## pq: password authentication failed for user "XXX";

This is a credential issue. To fix your credentials, head over to Warehouse > Settings > Connection.

## dial tcp: lookup XXX-hostname on 10.50.0.2:53: no such host

This is a credential issue. To fix your credentials, head over to Warehouse > Settings > Connection.

## dial tcp XX.XXX.XXX.XXX:XXXX: getsockopt: connection timed out / refused

This is a networking error. The connection times out because Redshift doesn't close properly or gets rebooted.

If you see this error on consecutive syncs, [contact us](https://segment.com/help/contact/).

## ERROR: syntax error at or near "ENCODE"; (SQLSTATE 42601)

This occurs when a Postgres database is incorrectly connected as Redshift. To resolve this, delete the warehouse and reconnect, using the Postgres set up option.

## Error during deduping step for collectionXXX: EOF

This error is generally a network error when Redshift closes the connection. If the problem persists on multiple runs, [contact us](https://segment.com/help/contact/).

## ERROR: permission denied for relation update (SQLSTATE 42501)

This is a permissioning issue. To learn how to set up proper permissions, you can check out our [postgres](/docs/segment/connections/storage/catalog/postgres/) and [redshift](/docs/segment/connections/storage/catalog/redshift/) guides.

## EOF

This error is generally a network error when Redshift closes the connection. If the problem persists on multiple runs, [contact us](https://segment.com/help/contact/).

## ERROR: failed to create table: 002318 (42601): SQL compilation error: invalid column definition name "XXX" (ANSI reserved)

This error indicates that a column that is attempting to sync has the same title as a reserved keyword in Snowflake. More information regarding Snowflake's reserved keywords can be found [in Snowflake's docs](https://docs.snowflake.com/en/sql-reference/reserved-keywords).