Re: [HACKERS] New pg_ctl has retrogressed in error messages - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [HACKERS] New pg_ctl has retrogressed in error messages
Date
Msg-id 200405311756.i4VHuxb05190@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] New pg_ctl has retrogressed in error messages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:
> 7.4, on not finding a postmaster:
>
> [tgl@rh1 pgsql]$ pg_ctl stop
> /home/tgl/version74/bin/pg_ctl: line 274: kill: (15273) - No such process
> waiting for postmaster to shut down................................................................ failed
> pg_ctl: postmaster does not shut down
>
> CVS tip, same scenario:
>
> [tgl@rh1 pgsql]$ pg_ctl stop
> stop signal failed
>
> Not waiting for the results of a failed kill() is good, but the error
> message is exceedingly unhelpful.  It should mention the PID it tried to
> kill and give the errno string.  Perhaps
>
> failed to signal postmaster process 15273: No such process

OK, new output is:

    $ aspg pg_ctl stop
    stop signal failed (PID: 3603): No such process

I also changed all the pid variables to use pid_t.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
Index: src/bin/pg_ctl/pg_ctl.c
===================================================================
RCS file: /cvsroot/pgsql-server/src/bin/pg_ctl/pg_ctl.c,v
retrieving revision 1.1
diff -c -c -r1.1 pg_ctl.c
*** src/bin/pg_ctl/pg_ctl.c    27 May 2004 03:37:55 -0000    1.1
--- src/bin/pg_ctl/pg_ctl.c    31 May 2004 17:56:20 -0000
***************
*** 59,65 ****
  static bool silence_echo = false;
  static ShutdownMode shutdown_mode = SMART_MODE;
  static int    sig = SIGTERM;    /* default */
- static int    killproc;
  static CtlCommand ctl_command = NO_COMMAND;
  static char *pg_data_opts = NULL;
  static char *pg_data = NULL;
--- 59,64 ----
***************
*** 80,87 ****
  static void do_restart(void);
  static void do_reload(void);
  static void do_status(void);
! static void do_kill(void);
! static long get_pgpid(void);
  static char **readfile(char *path);
  static int start_postmaster(void);
  static bool test_postmaster_connection(void);
--- 79,86 ----
  static void do_restart(void);
  static void do_reload(void);
  static void do_status(void);
! static void do_kill(pid_t pid);
! static pid_t get_pgpid(void);
  static char **readfile(char *path);
  static int start_postmaster(void);
  static bool test_postmaster_connection(void);
***************
*** 127,137 ****



! static long
  get_pgpid(void)
  {
      FILE       *pidf;
!     long        pid;

      pidf = fopen(pid_file, "r");
      if (pidf == NULL)
--- 126,136 ----



! static pid_t
  get_pgpid(void)
  {
      FILE       *pidf;
!     pid_t        pid;

      pidf = fopen(pid_file, "r");
      if (pidf == NULL)
***************
*** 145,151 ****
              exit(1);
          }
      }
!     fscanf(pidf, "%ld", &pid);
      fclose(pidf);
      return pid;
  }
--- 144,150 ----
              exit(1);
          }
      }
!     fscanf(pidf, "%u", &pid);
      fclose(pidf);
      return pid;
  }
***************
*** 324,331 ****
  static void
  do_start(void)
  {
!     long        pid;
!     long        old_pid = 0;
      char       *optline = NULL;

      if (ctl_command != RESTART_COMMAND)
--- 323,330 ----
  static void
  do_start(void)
  {
!     pid_t        pid;
!     pid_t        old_pid = 0;
      char       *optline = NULL;

      if (ctl_command != RESTART_COMMAND)
***************
*** 458,464 ****
  do_stop(void)
  {
      int            cnt;
!     long        pid;

      pid = get_pgpid();

--- 457,463 ----
  do_stop(void)
  {
      int            cnt;
!     pid_t        pid;

      pid = get_pgpid();

***************
*** 473,486 ****
          pid = -pid;
          fprintf(stderr,
                  _("%s: cannot stop postmaster; "
!                 "postgres is running (PID: %ld)\n"),
                  progname, pid);
          exit(1);
      }

!     if (kill((pid_t) pid, sig) != 0)
      {
!         fprintf(stderr, _("stop signal failed\n"));
          exit(1);
      }

--- 472,486 ----
          pid = -pid;
          fprintf(stderr,
                  _("%s: cannot stop postmaster; "
!                 "postgres is running (PID: %u)\n"),
                  progname, pid);
          exit(1);
      }

!     if (kill(pid, sig) != 0)
      {
!         fprintf(stderr, _("stop signal failed (PID: %u): %s\n"), pid,
!                 strerror(errno));
          exit(1);
      }

***************
*** 537,543 ****
  do_restart(void)
  {
      int            cnt;
!     long        pid;

      pid = get_pgpid();

--- 537,543 ----
  do_restart(void)
  {
      int            cnt;
!     pid_t        pid;

      pid = get_pgpid();

***************
*** 553,567 ****
          pid = -pid;
          fprintf(stderr,
                  _("%s: cannot restart postmaster; "
!                 "postgres is running (PID: %ld)\n"),
                  progname, pid);
          fprintf(stderr, _("Please terminate postgres and try again.\n"));
          exit(1);
      }

!     if (kill((pid_t) pid, sig) != 0)
      {
!         fprintf(stderr, _("stop signal failed\n"));
          exit(1);
      }

--- 553,568 ----
          pid = -pid;
          fprintf(stderr,
                  _("%s: cannot restart postmaster; "
!                 "postgres is running (PID: %u)\n"),
                  progname, pid);
          fprintf(stderr, _("Please terminate postgres and try again.\n"));
          exit(1);
      }

!     if (kill(pid, sig) != 0)
      {
!         fprintf(stderr, _("stop signal failed (PID: %u): %s\n"), pid,
!                 strerror(errno));
          exit(1);
      }

***************
*** 608,614 ****
  static void
  do_reload(void)
  {
!     long        pid;

      pid = get_pgpid();
      if (pid == 0)                /* no pid file */
--- 609,615 ----
  static void
  do_reload(void)
  {
!     pid_t        pid;

      pid = get_pgpid();
      if (pid == 0)                /* no pid file */
***************
*** 622,636 ****
          pid = -pid;
          fprintf(stderr,
                  _("%s: cannot reload postmaster; "
!                 "postgres is running (PID: %ld)\n"),
                  progname, pid);
          fprintf(stderr, _("Please terminate postgres and try again.\n"));
          exit(1);
      }

!     if (kill((pid_t) pid, sig) != 0)
      {
!         fprintf(stderr, _("reload signal failed\n"));
          exit(1);
      }

--- 623,638 ----
          pid = -pid;
          fprintf(stderr,
                  _("%s: cannot reload postmaster; "
!                 "postgres is running (PID: %u)\n"),
                  progname, pid);
          fprintf(stderr, _("Please terminate postgres and try again.\n"));
          exit(1);
      }

!     if (kill(pid, sig) != 0)
      {
!         fprintf(stderr, _("reload signal failed (PID: %u): %s\n"), pid,
!                 strerror(errno));
          exit(1);
      }

***************
*** 645,651 ****
  static void
  do_status(void)
  {
!     long        pid;

      pid = get_pgpid();
      if (pid == 0)                /* no pid file */
--- 647,653 ----
  static void
  do_status(void)
  {
!     pid_t        pid;

      pid = get_pgpid();
      if (pid == 0)                /* no pid file */
***************
*** 656,668 ****
      else if (pid < 0)            /* standalone backend */
      {
          pid = -pid;
!         fprintf(stdout, _("%s: a standalone backend \"postgres\" is running (PID: %ld)\n"), progname, pid);
      }
      else                        /* postmaster */
      {
          char      **optlines;

!         fprintf(stdout, _("%s: postmaster is running (PID: %ld)\n"), progname, pid);

          optlines = readfile(postopts_file);
          if (optlines != NULL)
--- 658,670 ----
      else if (pid < 0)            /* standalone backend */
      {
          pid = -pid;
!         fprintf(stdout, _("%s: a standalone backend \"postgres\" is running (PID: %u)\n"), progname, pid);
      }
      else                        /* postmaster */
      {
          char      **optlines;

!         fprintf(stdout, _("%s: postmaster is running (PID: %u)\n"), progname, pid);

          optlines = readfile(postopts_file);
          if (optlines != NULL)
***************
*** 674,684 ****


  static void
! do_kill(void)
  {
!     if (kill(killproc, sig) != 0)
      {
!         fprintf(stderr, _("signal %d failed\n"), sig);
          exit(1);
      }
  }
--- 676,687 ----


  static void
! do_kill(pid_t pid)
  {
!     if (kill(pid, sig) != 0)
      {
!         fprintf(stderr, _("signal %d failed (PID: %u): %s\n"), sig, pid,
!                 strerror(errno));
          exit(1);
      }
  }
***************
*** 810,815 ****
--- 813,819 ----

      int            option_index;
      int            c;
+     int            killproc = 0;

  #ifdef WIN32
      setvbuf(stderr, NULL, _IONBF, 0);
***************
*** 1005,1011 ****
              do_reload();
              break;
          case KILL_COMMAND:
!             do_kill();
              break;
          default:
              break;
--- 1009,1015 ----
              do_reload();
              break;
          case KILL_COMMAND:
!             do_kill(killproc);
              break;
          default:
              break;

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: use new List API names
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] New pg_ctl has retrogressed in error messages