jason_waldrip
12/22/2020, 12:02 AMmeltano | Incremental state has been updated at 2020-12-21 20:36:59.943053.
meltano | Extraction failed (1): TypeError: can't compare offset-naive and offset-aware datetimes
meltano | ELT could not be completed: Tap failed
douwe_maan
12/22/2020, 12:03 AMdouwe_maan
12/22/2020, 12:04 AMstart_date
setting also look like YYYY-MM-DD
rather than YYYY-MM-DDTHH:MM:SSZ
?jason_waldrip
12/22/2020, 12:07 AMjason_waldrip
12/22/2020, 12:09 AMschedules:
- name: gitlab-to-bigquery
extractor: tap-gitlab
loader: target-bigquery
transform: run
interval: '@hourly'
start_date: 2020-12-01 00:00:00
- name: postgres-to-bigquery
extractor: tap-postgres
loader: target-bigquery
transform: skip
interval: '@daily'
start_date: 2020-12-17 22:20:30.188498
douwe_maan
12/22/2020, 12:10 AMstart_date
value from meltano config tap-gitlab
?douwe_maan
12/22/2020, 12:10 AMmeltano schedule run gitlab-to-bigquery --dump=state
?jason_waldrip
12/22/2020, 12:11 AM"start_date": "2018-01-01"
douwe_maan
12/22/2020, 12:11 AMdouwe_maan
12/22/2020, 12:12 AMjason_waldrip
12/22/2020, 12:13 AMjason_waldrip
12/22/2020, 12:13 AMdouwe_maan
12/22/2020, 12:13 AMdouwe_maan
12/22/2020, 12:13 AMdouwe_maan
12/22/2020, 12:15 AMdouwe_maan
12/23/2020, 9:37 PMdouwe_maan
12/23/2020, 10:12 PMbenjamin_maquet
01/13/2021, 3:16 PMtap-zendesk
? I got the error ELT could not be completed: Tap failed
(without any extra info :/) when I used start_date: '2021-01-13'
and this error went away once I changed to start_date: '2021-01-13T10:00:00Z'
benjamin_maquet
01/13/2021, 3:29 PM1.58.0
. I just switched to 1.65.0
and I get the same issue.
Here’s the log output. Can’t seem to understand the problembenjamin_maquet
01/13/2021, 3:29 PMbenjamin_maquet
01/13/2021, 3:45 PMstart_date: '2021-01-13T00:00:00Z'
is failing but start_date: '2021-01-13T10:00:00Z'
is succeeding… 🤷♂️douwe_maan
01/13/2021, 4:36 PMstart_date
to be a full timestamp, since this is what the spec prescribes. Meltano can do better here by making sure the tap always receives a full timestamp even if the user only set a date, but I haven't gotten to it yet: https://gitlab.com/meltano/meltano/-/issues/2234 A contribution would be much appreciated 🙂
At first glance, the log output doesn't point to an issue with start_date
, since there's no exception stacktrace coming from the tap, and Extraction failed (-9)
shows that the tap process exited with exit code 9 (which Python's async subprocess library calls -9), which indicates the process was killed with SIGKILL, i.e. some outside influence rather than an error in the tap itself. But you're confident you're only only seeing that error with an incomplete start_date
, and everything's fine otherwise?
Looks likeThat also suggests the issue isn't actuallyis failing butstart_date: '2021-01-13T00:00:00Z'
is succeeding… 🤷♂️start_date: '2021-01-13T10:00:00Z'
start_date
, since both of those are obviously valid... Are you consistently seeing the tap will with exitcode -9
with 2021-01-13
and 2021-01-13T00:00:00Z
, but never with 2021-01-13T10:00:00Z
?benjamin_maquet
01/14/2021, 1:52 PM2021-01-13
or 2021-01-13T00:00:00Z
but never happened for 2021-01-13T10:00:00Z
, and I tested 10+ runs. I am still trying to understand what is causing this issuedouwe_maan
01/14/2021, 3:31 PMbenjamin_maquet
01/14/2021, 4:37 PMdouwe_maan
01/14/2021, 4:39 PMdouwe_maan
01/14/2021, 4:41 PMbenjamin_maquet
01/14/2021, 4:41 PMbenjamin_maquet
01/14/2021, 4:42 PMdouwe_maan
01/14/2021, 4:43 PMbenjamin_maquet
01/14/2021, 4:44 PMdouwe_maan
01/14/2021, 4:49 PMps <some flags> | grep python
to find the memory usage of each python process, and then use the pids to determine if that's Meltano itself, the tap, or the targetdouwe_maan
01/14/2021, 4:50 PMdouwe_maan
01/14/2021, 4:51 PMroot 1354 56.7 24.3 2087740 1982028 pts/1 R 16:46 1:14 /artemis/.meltano/extractors/tap-zendesk-tickets/venv/bin/python /artemis/.meltano/extractors/tap-zendesk-tickets/venv/bin/tap-zendesk --config /artemis/.meltano/run/elt/zen
benjamin_maquet
01/14/2021, 4:51 PMdouwe_maan
01/14/2021, 4:54 PMdouwe_maan
01/14/2021, 4:56 PMdouwe_maan
01/14/2021, 4:57 PMdouwe_maan
01/14/2021, 4:57 PMbenjamin_maquet
01/14/2021, 5:25 PMbenjamin_maquet
01/14/2021, 5:28 PMdouwe_maan
01/14/2021, 5:40 PM