DB Restarting daily at midnight

Started by Gayatri Singhabout 1 year ago3 messageshackers
Jump to latest
#1Gayatri Singh
gayatripremselvi@gmail.com

Hi All,

We are using postgresql ver 15 , some Talend jobs to load data when we
start to do this , DB server goes into kernel panic and reboot .

Any idea how to troubleshoot this?

DBA says there is some binary data usage .

Regards,
Gayatri.

#2Ashutosh Bapat
ashutosh.bapat@enterprisedb.com
In reply to: Gayatri Singh (#1)
Re: DB Restarting daily at midnight

Hi Gayatri,

On Thu, Feb 20, 2025 at 10:04 AM Gayatri Singh
<gayatripremselvi@gmail.com> wrote:

Hi All,

We are using postgresql ver 15 , some Talend jobs to load data when we start to do this , DB server goes into kernel panic and reboot .

Any idea how to troubleshoot this?

DBA says there is some binary data usage .

This mailing list is for development discussion. You may use
pgsql-general to start the discussion. It may turn out to be a
PostgreSQL bug in which case you may post it to pgsql-bugs or here.

But in order to move forward, you will need to share at least the
following information
1. exact server version - is it latest minor release of PG 15?
2. Any stack trace or other information from PostgreSQL backend
coredump? Stack traces which will point us to the problematic code
3. Snippets of server error log when server restarts? Any noticeable
errors there?
4. What queries/utilities trigger server restart? Standalone reproduction?

--
Best Wishes,
Ashutosh Bapat

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Gayatri Singh (#1)
Re: DB Restarting daily at midnight

Gayatri Singh <gayatripremselvi@gmail.com> writes:

We are using postgresql ver 15 , some Talend jobs to load data when we
start to do this , DB server goes into kernel panic and reboot .
Any idea how to troubleshoot this?

A repeatable kernel panic indicates either a buggy kernel or
a hardware fault; there is no universe in which it's the fault
of an application such as postgres. But since you've told us zero
about either your kernel or your hardware, it's difficult to help.

regards, tom lane