Skip to contentSkip to navigationSkip to topbar
On this page
Looking for more inspiration?Visit the
(information)
You're in the right place! Segment documentation is now part of Twilio Docs. The content you are used to is still here—just in a new home with a refreshed look.

Warehouse Errors



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

error-schema-xxx-does-not-exist-sqlstate-3f000 page anchor

This is a permissioning issue. To learn how to set up proper permissions, you can check out our Postgres and Redshift guides.


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

error-cannot-execute-query-because-system-is-in-resize-mode-sqlstate-57014 page anchor

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)

error-1040-sqlstate-xx000 page anchor

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(link takes you to an external page).


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

read-tcp-xxxxxxxxxxxxxxx-xxxxxxxxxxxxxxx-read-connection-timed-out page anchor

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(link takes you to an external page).


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

pq-role-xxx-is-not-permitted-to-log-in page anchor

This is a permissioning issue. To learn how to set up proper permissions, you can check out our postgres and redshift guides.


pq: password authentication failed for user "XXX";

pq-password-authentication-failed-for-user-xxx page anchor

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

dial-tcp-lookup-xxx-hostname-on-10500253-no-such-host page anchor

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

dial-tcp-xxxxxxxxxxxxxxx-getsockopt-connection-timed-out--refused page anchor

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(link takes you to an external page).


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

error-syntax-error-at-or-near-encode-sqlstate-42601 page anchor

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

error-during-deduping-step-for-collectionxxx-eof page anchor

This error is generally a network error when Redshift closes the connection. If the problem persists on multiple runs, contact us(link takes you to an external page).


ERROR: permission denied for relation update (SQLSTATE 42501)

error-permission-denied-for-relation-update-sqlstate-42501 page anchor

This is a permissioning issue. To learn how to set up proper permissions, you can check out our postgres and redshift guides.


This error is generally a network error when Redshift closes the connection. If the problem persists on multiple runs, contact us(link takes you to an external page).


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

error-failed-to-create-table-002318-42601-sql-compilation-error-invalid-column-definition-name-xxx-ansi-reserved page anchor

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(link takes you to an external page).