newrelic-experimental / newrelic-snowflake-integration

New Relic integration with Snowflake to monitor query performance, logins, potential security incidents, optimise warehouse and cloud credit costs, capture any data stored in Snowflake for real-time alerting and reporting
Apache License 2.0
13 stars 17 forks source link

Ubuntu Linux - Integration process gets killed by OOM and no data in new relic #55

Open kunalmehta1 opened 8 months ago

kunalmehta1 commented 8 months ago

Hello,

The backend process in linux gets terminated with this error. I can see queries running in snowflake but no data in new relic and hence raising this issue.

Jan 11 15:19:36 ip-172-31-33-45 kernel: [15464.013019] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=cron.service,mems_allowed=0,global_oom,task_memcg=/system.slice/newrelic-infra.service,task=snowflakeintegr,pid=24613,uid=0

Jan 11 15:19:36 ip-172-31-33-45 kernel: [15464.013051] Out of memory: Killed process 24613 (snowflakeintegr) total-vm:2773360kB, anon-rss:1714644kB, file-rss:2432kB, shmem-rss:0kB, UID:0 pgtables:14428kB oom_score_adj:0

Jan 11 15:19:36 ip-172-31-33-45 systemd[1]: snapd.service: State 'stop-watchdog' timed out. Killing.

Jan 11 15:19:36 ip-172-31-33-45 newrelic-infra-service[24342]: time="2024-01-11T15:19:36Z" level=info msg="Service is stopping. waiting for agent process to terminate..."

Jan 11 15:19:36 ip-172-31-33-45 systemd[1]: snapd.service: Killing process 456 (snapd) with signal SIGKILL.