Welcome to AWS re:Post
re:Post gives you access to a vibrant community that helps you become even more successful on AWS
Learn AWS faster by following popular topics
see all1/18
Recent questions
see all1/18
0
answers
0
votes
0
views
AWS-User-8008609
asked 14 minutes ago
0
answers
0
votes
1
views
mike-lm
asked 5 hours ago
0
answers
0
votes
0
views
Basem
asked 6 hours ago
0
answers
0
votes
1
views
elidexter
asked 7 hours ago
Trying to track redshift Assert error
Since today we are having this error, the DBT/SQL was not touched I'm receiving errors in many processes with this same message. A full refresh on DBT clears it, but when the first incremental runs, it starts to fail again with the same error, "context" is not helping.
I ran the query manually and had no trouble at all. It's a query that creates a table, a delete on the destination table (with a where), and inserts into it (managed by DBT that wasn't modified for more than 6 months, the query runs daily and also wasn't changed on the last months).
The only thing that I think changed was the Redshift version via an auto-maintenance yesterday, but can't do a rollback to validate, or can I?
I was in "current" version on maintenance, just switched to "trailing", now I'm on 1.0.38361, and can't find the changelog for that version.
```
20:26:44 |
20:26:44 | 1 of 1 START incremental model xxxxxx......... [RUN]
20:26:51 | 1 of 1 ERROR creating incremental model xxxxxx [ERROR in 6.44s]
20:26:51 |
20:26:51 | Finished running 1 incremental model in 8.55s.
Completed with 1 error and 0 warnings:
Database Error in model xxxxx (models/xxxxx.sql)
Assert
DETAIL:
-----------------------------------------------
error: Assert
code: 1000
context: size >= 0 - size=-2, 0=0.
query: 62706875
location: tbl_trans.cpp:867
process: padbmaster [pid=70356]
-----------------------------------------------
compiled SQL at target/run/xxxxx/xxxxx.sql
Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1
```
Any idea of what can be happening?
Thanks!
Accepted AnswerAmazon Redshift
1
answers
0
votes
2
views
AWS-User-3279708
asked 8 hours ago
0
answers
0
votes
0
views
AWS-User-2833423
asked 8 hours ago
2
answers
0
votes
3
views
AWS-User-6419781
asked 9 hours ago
0
answers
0
votes
1
views
AWS-User-6960343
asked 10 hours ago
0
answers
0
votes
1
views
H Baligh
asked 11 hours ago
0
answers
0
votes
1
views
AWS-User-5701586
asked 12 hours ago
1
answers
0
votes
1
views
AWS-User-6663831
asked 13 hours ago
0
answers
0
votes
0
views
joapen
asked 14 hours ago
0
answers
0
votes
1
views
AWS-User-3115305
asked 14 hours ago
1
answers
0
votes
2
views
AWS-User-2527555
asked 15 hours ago
1
answers
0
votes
1
views
CKD
asked 19 hours ago
0
answers
0
votes
1
views
AWS-User-7204079
asked a day ago