Amazon Redshift
Database Developer Guide (API Version 2012-12-01)


Records internal processing errors generated by the Amazon Redshift database engine. STL_ERROR does not record SQL errors or messages. The information in STL_ERROR is useful for troubleshooting certain errors. An AWS support engineer might ask you to provide this information as part of the troubleshooting process.

This table is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of Data in System Tables and Views.

Table Columns

Column Name Data Type Description
userid integer ID of the user who generated the entry.
process character(12) Process that threw the exception.
recordtime timestamp Time that the error occurred.
pid integer Process ID. The STL_QUERY table contains process IDs and unique query IDs for executed queries.
errcode integer Error code corresponding to the error category.
file character(90) Name of the source file where the error occurred.
linenum integer Line number in the source file where the error occurred.
context character(100) Cause of the error.
error character(512) Error message.

Sample Queries

The following example retrieves the error information from STL_ERROR.

select process, errcode, linenum as line, trim(error) as err from stl_error; process | errcode | line | err --------------+---------+------+------------------------------------------------------------------ padbmaster | 8001 | 194 | Path prefix: s3://awssampledb/testnulls/venue.txt* padbmaster | 8001 | 529 | Listing bucket=awssampledb prefix=tests/category-csv-quotes padbmaster | 2 | 190 | database "template0" is not currently accepting connections padbmaster | 32 | 1956 | pq_flush: could not send data to client: Broken pipe (4 rows)