lss602726449 commented on issue #1537:
URL: https://github.com/apache/cloudberry/issues/1537#issuecomment-3767095989
I have try to create pax table or create a database, create pax table, and
then drop database. Then I try to restart database by gpstop. But I have not
reproduce this problem. Could you please provide more info like sql and
operation you do to help me better reproduce this problem. Thanks @IPetrov2013
```
[gpadmin@hashdata cloudberrydb]$ psql postgres -p 7000
psql (14.4, server 14.4)
Type "help" for help.
postgres=# create table test(a int) using pax;
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named
'a' as the Apache Cloudberry data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
postgres=# insert into test values(1);
INSERT 0 1
postgres=# select *from test;
a
---
1
(1 row)
postgres=# quit
[gpadmin@hashdata cloudberrydb]$ gpstop ^C
[gpadmin@hashdata cloudberrydb]$ export
COORDINATOR_DATA_DIRECTORY=/home/gpadmin/cloudberrydb/gpAux/gpdemo/datadir
s/qddir/demoDataDir-1/
[gpadmin@hashdata cloudberrydb]$ make create-demo-cluster^C
[gpadmin@hashdata cloudberrydb]$ gpstop -ar
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Starting gpstop
with args: -ar
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Gathering
information and validating the environment...
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Obtaining
Cloudberry Coordinator catalog information
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Obtaining Segment
details from coordinator...
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Cloudberry Version:
'postgres (Apache Cloudberry) 3.0.0-devel+dev.2219.gc80e93d4d57 build dev'
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Commencing
Coordinator instance shutdown with mode='smart'
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Coordinator segment
instance
directory=/home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
20260119:16:23:10:023206 gpstop:hashdata:gpadmin-[INFO]:-Stopping
coordinator segment and waiting for user connections to finish ...
server shutting down
20260119:16:23:11:023206 gpstop:hashdata:gpadmin-[INFO]:-Attempting forceful
termination of any leftover coordinator process
20260119:16:23:11:023206 gpstop:hashdata:gpadmin-[INFO]:-Terminating
processes for segment
/home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
20260119:16:23:11:023206 gpstop:hashdata:gpadmin-[INFO]:-Stopping
coordinator standby host hashdata mode=smart
20260119:16:23:11:023206 gpstop:hashdata:gpadmin-[INFO]:-Successfully
shutdown standby process on hashdata
20260119:16:23:11:023206 gpstop:hashdata:gpadmin-[INFO]:-Targeting dbid [2,
5, 3, 6, 4, 7] for shutdown
20260119:16:23:11:023206 gpstop:hashdata:gpadmin-[INFO]:-Commencing parallel
primary segment instance shutdown, please wait...
20260119:16:23:11:023206 gpstop:hashdata:gpadmin-[INFO]:-0.00% of jobs
completed
20260119:16:23:14:023206 gpstop:hashdata:gpadmin-[INFO]:-100.00% of jobs
completed
20260119:16:23:14:023206 gpstop:hashdata:gpadmin-[INFO]:-Commencing parallel
mirror segment instance shutdown, please wait...
20260119:16:23:14:023206 gpstop:hashdata:gpadmin-[INFO]:-0.00% of jobs
completed
20260119:16:23:16:023206 gpstop:hashdata:gpadmin-[INFO]:-100.00% of jobs
completed
20260119:16:23:16:023206
gpstop:hashdata:gpadmin-[INFO]:-----------------------------------------------------
20260119:16:23:16:023206 gpstop:hashdata:gpadmin-[INFO]:- Segments stopped
successfully = 6
20260119:16:23:16:023206 gpstop:hashdata:gpadmin-[INFO]:- Segments with
errors during stop = 0
20260119:16:23:16:023206
gpstop:hashdata:gpadmin-[INFO]:-----------------------------------------------------
20260119:16:23:16:023206 gpstop:hashdata:gpadmin-[INFO]:-Successfully
shutdown 6 of 6 segment instances
20260119:16:23:16:023206 gpstop:hashdata:gpadmin-[INFO]:-Database
successfully shutdown with no errors reported
20260119:16:23:16:023206 gpstop:hashdata:gpadmin-[INFO]:-Restarting System...
[gpadmin@hashdata cloudberrydb]$ psql postgres -p 7000
psql (14.4, server 14.4)
Type "help" for help.
postgres=# create database test;
CREATE DATABASE
postgres=# \c test;
psql (14.4, server 14.4)
You are now connected to database "test" as user "gpadmin".
test=# create table test(a int) using pax;
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named
'a' as the Apache Cloudberry data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
test=# insert into test values(1);
INSERT 0 1
test=# \c postgres
psql (14.4, server 14.4)
You are now connected to database "postgres" as user "gpadmin".
postgres=# drop database test;
DROP DATABASE
postgres=# quit
[gpadmin@hashdata cloudberrydb]$ gpstop -ar
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Starting gpstop
with args: -ar
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Gathering
information and validating the environment...
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Obtaining
Cloudberry Coordinator catalog information
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Obtaining Segment
details from coordinator...
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Cloudberry Version:
'postgres (Apache Cloudberry) 3.0.0-devel+dev.2219.gc80e93d4d57 build dev'
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Commencing
Coordinator instance shutdown with mode='smart'
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Coordinator segment
instance
directory=/home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
20260119:16:26:48:026180 gpstop:hashdata:gpadmin-[INFO]:-Stopping
coordinator segment and waiting for user connections to finish ...
server shutting down
20260119:16:26:49:026180 gpstop:hashdata:gpadmin-[INFO]:-Attempting forceful
termination of any leftover coordinator process
20260119:16:26:49:026180 gpstop:hashdata:gpadmin-[INFO]:-Terminating
processes for segment
/home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
20260119:16:26:49:026180 gpstop:hashdata:gpadmin-[INFO]:-Stopping
coordinator standby host hashdata mode=smart
20260119:16:26:49:026180 gpstop:hashdata:gpadmin-[INFO]:-Successfully
shutdown standby process on hashdata
20260119:16:26:49:026180 gpstop:hashdata:gpadmin-[INFO]:-Targeting dbid [2,
5, 3, 6, 4, 7] for shutdown
20260119:16:26:49:026180 gpstop:hashdata:gpadmin-[INFO]:-Commencing parallel
primary segment instance shutdown, please wait...
20260119:16:26:49:026180 gpstop:hashdata:gpadmin-[INFO]:-0.00% of jobs
completed
20260119:16:26:52:026180 gpstop:hashdata:gpadmin-[INFO]:-100.00% of jobs
completed
20260119:16:26:52:026180 gpstop:hashdata:gpadmin-[INFO]:-Commencing parallel
mirror segment instance shutdown, please wait...
20260119:16:26:52:026180 gpstop:hashdata:gpadmin-[INFO]:-0.00% of jobs
completed
20260119:16:26:54:026180 gpstop:hashdata:gpadmin-[INFO]:-100.00% of jobs
completed
20260119:16:26:54:026180
gpstop:hashdata:gpadmin-[INFO]:-----------------------------------------------------
20260119:16:26:54:026180 gpstop:hashdata:gpadmin-[INFO]:- Segments stopped
successfully = 6
20260119:16:26:54:026180 gpstop:hashdata:gpadmin-[INFO]:- Segments with
errors during stop = 0
20260119:16:26:54:026180
gpstop:hashdata:gpadmin-[INFO]:-----------------------------------------------------
20260119:16:26:54:026180 gpstop:hashdata:gpadmin-[INFO]:-Successfully
shutdown 6 of 6 segment instances
20260119:16:26:54:026180 gpstop:hashdata:gpadmin-[INFO]:-Database
successfully shutdown with no errors reported
20260119:16:26:54:026180 gpstop:hashdata:gpadmin-[INFO]:-Restarting System...
[gpadmin@hashdata cloudberrydb]$
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
