Re: Printing backtrace of postgres processes

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	vignesh C <vignesh21(at)gmail(dot)com>
Cc:	Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: Printing backtrace of postgres processes
Date:	2022-03-09 15:56:23
Message-ID:	20220309155623.GA27651@telsasoft.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2020-11-22 03:06:25 from vignesh C <vignesh21(at)gmail(dot)com> 📎  2020-11-22 06:25:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2020-11-30 04:58:56 from vignesh C <vignesh21(at)gmail(dot)com>   2020-11-30 05:35:46 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>    2020-11-30 23:04:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2020-12-01 03:11:24 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>    2020-12-01 03:31:03 from Andres Freund <andres(at)anarazel(dot)de>     2020-12-01 03:33:15 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>   2020-12-01 03:26:49 from Andres Freund <andres(at)anarazel(dot)de>    2020-12-01 04:01:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2020-12-01 08:45:17 from vignesh C <vignesh21(at)gmail(dot)com>      2020-12-08 09:38:11 from vignesh C <vignesh21(at)gmail(dot)com> 📎       2021-01-15 08:53:05 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>        2021-01-15 20:10:11 from Andres Freund <andres(at)anarazel(dot)de>         2021-01-16 17:34:52 from vignesh C <vignesh21(at)gmail(dot)com>          2021-01-16 17:39:28 from "Andres Freund" <andres(at)anarazel(dot)de>           2021-01-17 16:56:30 from vignesh C <vignesh21(at)gmail(dot)com>            2021-01-18 04:10:41 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>            2021-01-19 11:45:05 from vignesh C <vignesh21(at)gmail(dot)com> 📎          2021-01-16 20:21:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2021-01-19 17:30:52 from Robert Haas <robertmhaas(at)gmail(dot)com>            2021-01-19 17:50:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2021-01-19 20:58:36 from Robert Haas <robertmhaas(at)gmail(dot)com>              2021-01-19 21:22:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2021-01-20 13:45:49 from vignesh C <vignesh21(at)gmail(dot)com>               2021-01-21 01:42:35 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>                2021-01-21 01:56:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2021-01-21 02:23:48 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>                  2021-01-25 17:05:24 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2021-01-27 13:35:16 from vignesh C <vignesh21(at)gmail(dot)com> 📎                  2021-01-27 17:09:58 from Andres Freund <andres(at)anarazel(dot)de>                   2021-01-28 11:52:24 from vignesh C <vignesh21(at)gmail(dot)com> 📎                    2021-01-28 14:10:36 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                     2021-01-29 13:40:24 from vignesh C <vignesh21(at)gmail(dot)com> 📎                      2021-02-01 00:44:12 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                       2021-02-01 05:34:03 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                        2021-02-03 07:03:08 from vignesh C <vignesh21(at)gmail(dot)com>                         2021-02-03 07:30:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2021-02-03 08:19:27 from vignesh C <vignesh21(at)gmail(dot)com>                           2021-02-03 09:54:20 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                            2021-05-05 15:55:51 from vignesh C <vignesh21(at)gmail(dot)com> 📎                             2021-05-06 02:13:24 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                              2021-05-06 14:53:42 from vignesh C <vignesh21(at)gmail(dot)com> 📎                          2021-05-06 18:38:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2021-05-06 18:56:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2021-05-06 19:19:05 from Andres Freund <andres(at)anarazel(dot)de>                             2021-05-06 19:31:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                              2021-05-06 19:49:15 from Andres Freund <andres(at)anarazel(dot)de>                              2021-05-11 20:57:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2021-07-13 15:33:22 from vignesh C <vignesh21(at)gmail(dot)com>                                2021-07-21 10:22:39 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                 2021-07-21 17:26:04 from vignesh C <vignesh21(at)gmail(dot)com>                                  2021-08-26 14:56:58 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                   2021-11-04 10:36:45 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                    2021-11-09 11:15:36 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                     2021-11-10 06:47:06 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                      2021-11-11 06:43:49 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                       2021-11-12 11:45:22 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                        2021-11-12 12:41:12 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                         2021-11-14 15:18:52 from vignesh C <vignesh21(at)gmail(dot)com>                                          2021-11-15 02:07:40 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                           2021-11-15 05:04:00 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                            2021-11-15 05:30:41 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                             2021-11-15 06:43:12 from vignesh C <vignesh21(at)gmail(dot)com>                                              2021-11-15 06:46:10 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                            2021-11-15 06:07:33 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                             2021-11-15 06:23:44 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                              2021-11-15 06:38:19 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                               2021-11-15 07:28:54 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                             2021-11-15 15:42:49 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                              2021-11-15 19:42:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                               2021-11-16 02:34:23 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                               2021-11-17 14:42:44 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                2021-11-18 16:22:44 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                 2021-11-19 10:37:05 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                  2021-11-20 06:20:24 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                                   2022-01-14 10:48:21 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                    2022-01-24 07:35:22 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                     2022-01-24 16:36:07 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                                                      2022-01-25 05:49:38 from vignesh C <vignesh21(at)gmail(dot)com>                                                     2022-01-25 06:30:41 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                      2022-01-26 05:36:55 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                                       2022-01-27 05:14:54 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                        2022-01-28 08:24:19 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                                         2022-01-29 02:36:31 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                          2022-01-31 04:04:17 from vignesh C <vignesh21(at)gmail(dot)com>                                                          2022-03-09 15:56:23 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                           2022-03-12 07:29:08 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                            2022-03-30 15:53:52 from Greg Stark <stark(at)mit(dot)edu>                                                             2022-03-30 16:03:08 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                              2022-04-05 15:48:05 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                               2022-04-06 06:59:18 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                                2022-04-14 05:03:50 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                                 2022-04-15 06:19:22 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                  2022-04-18 03:39:49 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                                   2022-11-10 10:26:35 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                                                    2022-11-11 02:29:04 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                     2022-11-11 12:34:41 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                                                      2022-11-30 06:13:02 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                                       2023-01-11 14:44:13 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                                        2023-07-20 14:52:25 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                                                         2023-11-04 20:19:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                                          2024-01-14 23:20:48 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                                          2024-01-26 02:26:02 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                        2024-01-26 10:41:04 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                         2024-01-26 18:28:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                          2024-02-06 10:50:39 from Michael Paquier <michael(at)paquier(dot)xyz>                                                           2024-02-07 08:34:39 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                            2024-02-07 09:27:28 from Michael Paquier <michael(at)paquier(dot)xyz>                                                             2024-02-07 15:30:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                              2024-02-07 19:00:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                                               2024-02-08 03:25:18 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                2024-02-09 08:13:44 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                 2024-02-09 08:48:36 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                  2024-02-09 08:57:26 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                   2024-02-10 00:06:35 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                    2024-02-12 01:22:24 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                     2024-02-13 14:02:28 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                    2024-02-23 15:39:47 from Christoph Berg <myon(at)debian(dot)org>                                                                     2024-02-23 23:38:15 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                      2024-02-26 15:05:05 from Christoph Berg <myon(at)debian(dot)org>                                                                       2024-02-27 02:46:13 from Michael Paquier <michael(at)paquier(dot)xyz>                                        2021-11-14 15:16:00 from vignesh C <vignesh21(at)gmail(dot)com> 📎                           2021-05-06 19:14:06 from Andres Freund <andres(at)anarazel(dot)de>                            2021-05-06 19:22:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2021-05-06 19:55:20 from Andres Freund <andres(at)anarazel(dot)de>                       2021-02-03 06:41:15 from vignesh C <vignesh21(at)gmail(dot)com> 📎                        2021-03-01 05:13:16 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                         2021-03-04 12:55:13 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                          2021-03-05 09:47:52 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                      2021-02-01 08:45:42 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                      2021-02-01 09:32:56 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>            2021-01-21 01:35:32 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
0001-Add-function-to-log-the-backtrace-of-the-specified-p.patch	text/x-diff	30.9 KB
0002-f-minor-fixen.patch	text/x-diff	6.5 KB

In response to

• Re: Printing backtrace of postgres processes at 2022-01-29 02:36:31 from vignesh C

Responses

• Re: Printing backtrace of postgres processes at 2022-03-12 07:29:08 from vignesh C

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Magnus Hagander	2022-03-09 16:22:56	Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file
Previous Message	Stephen Frost	2022-03-09 15:42:10	Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file