pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Upgrade Failure
7+ messages / 4 participants
[nested] [flat]

* Upgrade Failure
@ 2023-07-18 10:02  Johnathan Tiamoh <johnathantiamoh@gmail.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Johnathan Tiamoh @ 2023-07-18 10:02 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

Hello,

I was running an upgrade from 9.5 to 14.8 and encountered the below error.

Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok

The source cluster was not shut down cleanly.
Failure, exiting

Please how do you resolve this

Kind Regards
Tiamoh M

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrade Failure
@ 2023-07-18 10:12  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
  1 sibling, 1 reply; 7+ messages in thread

From: Laurenz Albe @ 2023-07-18 10:12 UTC (permalink / raw)
  To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; pgsql-general@lists.postgresql.org

On Tue, 2023-07-18 at 06:02 -0400, Johnathan Tiamoh wrote:
> I was running an upgrade from 9.5 to 14.8 and encountered the below error.
> 
> Running in verbose mode
> Performing Consistency Checks
> -----------------------------
> Checking cluster versions                                   ok
>  
> The source cluster was not shut down cleanly.
> Failure, exiting
> 
> Please how do you resolve this

Well, start the 9.5 server and shut it down cleanly.

Yours,
Laurenz Albe





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrade Failure
@ 2023-07-18 10:14  Johnathan Tiamoh <johnathantiamoh@gmail.com>
  parent: Laurenz Albe <laurenz.albe@cybertec.at>
  0 siblings, 0 replies; 7+ messages in thread

From: Johnathan Tiamoh @ 2023-07-18 10:14 UTC (permalink / raw)
  To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-general@lists.postgresql.org

Thank You  Laurenz.

On Tue, Jul 18, 2023 at 6:12 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:

> On Tue, 2023-07-18 at 06:02 -0400, Johnathan Tiamoh wrote:
> > I was running an upgrade from 9.5 to 14.8 and encountered the below
> error.
> >
> > Running in verbose mode
> > Performing Consistency Checks
> > -----------------------------
> > Checking cluster versions                                   ok
> >
> > The source cluster was not shut down cleanly.
> > Failure, exiting
> >
> > Please how do you resolve this
>
> Well, start the 9.5 server and shut it down cleanly.
>
> Yours,
> Laurenz Albe
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrade Failure
@ 2023-07-18 10:14  Daniel Gustafsson <daniel@yesql.se>
  parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
  1 sibling, 1 reply; 7+ messages in thread

From: Daniel Gustafsson @ 2023-07-18 10:14 UTC (permalink / raw)
  To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

> On 18 Jul 2023, at 12:02, Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:

> The source cluster was not shut down cleanly.
> Failure, exiting
> 
> Please how do you resolve this

pg_upgrade runs bin/pg_controldata on the source cluster data directory and
ensures that the "Database cluster state" says "shut down".  If you run the
same command, which state is the cluster reported to be in?

--
Daniel Gustafsson






^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrade Failure
@ 2023-07-18 10:26  Johnathan Tiamoh <johnathantiamoh@gmail.com>
  parent: Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 2 replies; 7+ messages in thread

From: Johnathan Tiamoh @ 2023-07-18 10:26 UTC (permalink / raw)
  To: daniel@yesql.se; +Cc: pgsql-general@lists.postgresql.org

I used pg_ctl to stop the cluster.

When I used the same pg_ctl to check status, it says no server is running

On Tue, Jul 18, 2023 at 6:14 AM Daniel Gustafsson <daniel@yesql.se> wrote:

> > On 18 Jul 2023, at 12:02, Johnathan Tiamoh <johnathantiamoh@gmail.com>
> wrote:
>
> > The source cluster was not shut down cleanly.
> > Failure, exiting
> >
> > Please how do you resolve this
>
> pg_upgrade runs bin/pg_controldata on the source cluster data directory and
> ensures that the "Database cluster state" says "shut down".  If you run the
> same command, which state is the cluster reported to be in?
>
> --
> Daniel Gustafsson
>
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrade Failure
@ 2023-07-18 10:38  Daniel Gustafsson <daniel@yesql.se>
  parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Daniel Gustafsson @ 2023-07-18 10:38 UTC (permalink / raw)
  To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

> On 18 Jul 2023, at 12:26, Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:
> 
> I used pg_ctl to stop the cluster. 
> 
> When I used the same pg_ctl to check status, it says no server is running 

Right, but what does "pg_controldata" say for the cluster?

--
Daniel Gustafsson






^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrade Failure
@ 2023-07-18 14:44  Ron <ronljohnsonjr@gmail.com>
  parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Ron @ 2023-07-18 14:44 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

pg_ctl is not pg_controldata.

(I bet you ran "pg_ctl stop --mode=immediate".  That's not a clean shutdown.)

On 7/18/23 05:26, Johnathan Tiamoh wrote:
> I used pg_ctl to stop the cluster.
>
> When I used the same pg_ctl to check status, it says no server is running
>
> On Tue, Jul 18, 2023 at 6:14 AM Daniel Gustafsson <daniel@yesql.se> wrote:
>
>     > On 18 Jul 2023, at 12:02, Johnathan Tiamoh
>     <johnathantiamoh@gmail.com> wrote:
>
>     > The source cluster was not shut down cleanly.
>     > Failure, exiting
>     >
>     > Please how do you resolve this
>
>     pg_upgrade runs bin/pg_controldata on the source cluster data
>     directory and
>     ensures that the "Database cluster state" says "shut down". If you run the
>     same command, which state is the cluster reported to be in?
>
>     --
>     Daniel Gustafsson
>

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2023-07-18 14:44 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-18 10:02 Upgrade Failure Johnathan Tiamoh <johnathantiamoh@gmail.com>
2023-07-18 10:12 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-07-18 10:14   ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
2023-07-18 10:14 ` Daniel Gustafsson <daniel@yesql.se>
2023-07-18 10:26   ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
2023-07-18 10:38     ` Daniel Gustafsson <daniel@yesql.se>
2023-07-18 14:44     ` Ron <ronljohnsonjr@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox