Обсуждение: DB Creations/ Drop DB :: Not working...

Поиск

Список

Период

Сортировка

DB Creations/ Drop DB :: Not working...

От

Дата:

05 декабря 2018 г., 20:10:23

Hi All,

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

And why this comes in?

postgres=# CREATE DATABASE symuatdb

postgres-# WITH

postgres-# OWNER = postgres

postgres-# ENCODING = 'UTF8'

postgres-# LC_COLLATE = 'en_US.utf8'

postgres-# LC_CTYPE = 'en_US.utf8'

postgres-# TABLESPACE = sym_m_data1

postgres-# CONNECTION LIMIT = 10;

ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory

postgres=#

Thanks

Soumik

Re: DB Creations/ Drop DB :: Not working...

От

Tom Lane

Дата:

05 декабря 2018 г., 20:29:06

<soumik.bhattacharjee@kpn.com> writes:
> postgres=# CREATE DATABASE symuatdb
> postgres-#     WITH
> postgres-#     OWNER = postgres
> postgres-#     ENCODING = 'UTF8'
> postgres-#     LC_COLLATE = 'en_US.utf8'
> postgres-#     LC_CTYPE = 'en_US.utf8'
> postgres-#     TABLESPACE = sym_m_data1
> postgres-#     CONNECTION LIMIT = 10;
> ERROR:  could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory

It looks like somebody's deleted the directory your tablespace sym_m_data1
is pointing at.

            regards, tom lane

Re: DB Creations/ Drop DB :: Not working...

От

Ron

Дата:

05 декабря 2018 г., 20:48:47

On 12/05/2018 11:29 AM, Tom Lane wrote:
> <soumik.bhattacharjee@kpn.com> writes:
>> postgres=# CREATE DATABASE symuatdb
>> postgres-#     WITH
>> postgres-#     OWNER = postgres
>> postgres-#     ENCODING = 'UTF8'
>> postgres-#     LC_COLLATE = 'en_US.utf8'
>> postgres-#     LC_CTYPE = 'en_US.utf8'
>> postgres-#     TABLESPACE = sym_m_data1
>> postgres-#     CONNECTION LIMIT = 10;
>> ERROR:  could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
> It looks like somebody's deleted the directory your tablespace sym_m_data1
> is pointing at.

$PGDATA/pg_tblspc?


-- 
Angular momentum makes the world go 'round.

RE: DB Creations/ Drop DB :: Not working...

От

Дата:

06 декабря 2018 г., 13:32:27

Thanks,

So I need to re-create - pg_tblspc : no such file or directory  ?

Or I need to re-install the complete postgres?



-----Original Message-----
From: Ron <ronljohnsonjr@gmail.com> 
Sent: Wednesday, December 05, 2018 6:49 PM
To: pgsql-admin@lists.postgresql.org
Subject: Re: DB Creations/ Drop DB :: Not working...

On 12/05/2018 11:29 AM, Tom Lane wrote:
> <soumik.bhattacharjee@kpn.com> writes:
>> postgres=# CREATE DATABASE symuatdb
>> postgres-#     WITH
>> postgres-#     OWNER = postgres
>> postgres-#     ENCODING = 'UTF8'
>> postgres-#     LC_COLLATE = 'en_US.utf8'
>> postgres-#     LC_CTYPE = 'en_US.utf8'
>> postgres-#     TABLESPACE = sym_m_data1
>> postgres-#     CONNECTION LIMIT = 10;
>> ERROR:  could not create directory 
>> "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
> It looks like somebody's deleted the directory your tablespace 
> sym_m_data1 is pointing at.

$PGDATA/pg_tblspc?


--
Angular momentum makes the world go 'round.

Re: DB Creations/ Drop DB :: Not working...

От

Shreeyansh Dba

Дата:

06 декабря 2018 г., 13:41:55

Hi Soumik,

It seems your tablespace directory deleted by someone and you need to recreate tablespace for your database.

Go through the below link for more details.

https://www.postgresql.org/docs/10/manage-ag-tablespaces.html

Hope this will helps.

On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com> wrote:

Hi All,

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

And why this comes in?

postgres=# CREATE DATABASE symuatdb
postgres-#     WITH
postgres-#     OWNER = postgres
postgres-#     ENCODING = 'UTF8'
postgres-#     LC_COLLATE = 'en_US.utf8'
postgres-#     LC_CTYPE = 'en_US.utf8'
postgres-#     TABLESPACE = sym_m_data1
postgres-#     CONNECTION LIMIT = 10;
ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
postgres=#

Thanks
Soumik

RE: DB Creations/ Drop DB :: Not working...

От

Дата:

06 декабря 2018 г., 13:47:34

Thanks,

But i can see the below in server.

postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ ls -ltr

total 0

lrwxrwxrwx. 1 postgres postgres 24 Dec 5 15:21 16386 -> /var/lib/postgresql/data

lrwxrwxrwx. 1 postgres postgres 28 Dec 5 15:27 16389 -> /var/lib/postgresql/data/idx

postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ pwd

/var/lib/postgresql/data/pgdata/postgresql-db/pg_tblspc

Do I need to re-create the pg_tblspc or user defined tablespaces?

Thanks

Soumik

From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: DB Creations/ Drop DB :: Not working...

On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com> wrote:

Hi All,

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

And why this comes in?

postgres=# CREATE DATABASE symuatdb
postgres-#     WITH
postgres-#     OWNER = postgres
postgres-#     ENCODING = 'UTF8'
postgres-#     LC_COLLATE = 'en_US.utf8'
postgres-#     LC_CTYPE = 'en_US.utf8'
postgres-#     TABLESPACE = sym_m_data1
postgres-#     CONNECTION LIMIT = 10;
ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
postgres=#

Thanks
Soumik

RE: DB Creations/ Drop DB :: Not working...

От

Дата:

06 декабря 2018 г., 13:49:32

postgres=# SELECT spcname FROM pg_tablespace;

spcname

--------------

pg_default

pg_global

sym_m_data1

sym_m_index1

(4 rows)

postgres=#

From: Bhattacharjee, Soumik
Sent: Thursday, December 06, 2018 11:48 AM
To: 'Shreeyansh Dba' <shreeyansh2014@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: RE: DB Creations/ Drop DB :: Not working...

Thanks,

But i can see the below in server.

postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ ls -ltr

total 0

lrwxrwxrwx. 1 postgres postgres 24 Dec 5 15:21 16386 -> /var/lib/postgresql/data

lrwxrwxrwx. 1 postgres postgres 28 Dec 5 15:27 16389 -> /var/lib/postgresql/data/idx

postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ pwd

/var/lib/postgresql/data/pgdata/postgresql-db/pg_tblspc

Do I need to re-create the pg_tblspc or user defined tablespaces?

Thanks

Soumik

On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com> wrote:

Hi All,

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

And why this comes in?

postgres=# CREATE DATABASE symuatdb
postgres-#     WITH
postgres-#     OWNER = postgres
postgres-#     ENCODING = 'UTF8'
postgres-#     LC_COLLATE = 'en_US.utf8'
postgres-#     LC_CTYPE = 'en_US.utf8'
postgres-#     TABLESPACE = sym_m_data1
postgres-#     CONNECTION LIMIT = 10;
ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
postgres=#

Thanks
Soumik

Re: DB Creations/ Drop DB :: Not working...

От

Avinash Kumar

Дата:

06 декабря 2018 г., 14:14:45

Hi Sounim,

Lets make it simple.

Do the following steps.

$ psql

\db

You should see the list of tablespaces and their locations.

Check if the location specified for the tablespace => sym_m_data1 exists. If not, create it or fix the permission issues, if any.

Regards,
Avinash Vallarapu.

On Thu, Dec 6, 2018 at 4:19 PM <soumik.bhattacharjee@kpn.com> wrote:

postgres=# SELECT spcname FROM pg_tablespace;
   spcname
--------------
pg_default
pg_global
sym_m_data1
sym_m_index1
(4 rows)

postgres=#

From: Bhattacharjee, Soumik
Sent: Thursday, December 06, 2018 11:48 AM
To: 'Shreeyansh Dba' <shreeyansh2014@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: RE: DB Creations/ Drop DB :: Not working...

Thanks,

But i can see the below in server.

postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ ls -ltr
total 0
lrwxrwxrwx. 1 postgres postgres 24 Dec 5 15:21 16386 -> /var/lib/postgresql/data
lrwxrwxrwx. 1 postgres postgres 28 Dec 5 15:27 16389 -> /var/lib/postgresql/data/idx
postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ pwd
/var/lib/postgresql/data/pgdata/postgresql-db/pg_tblspc

Do I need to re-create the pg_tblspc or user defined tablespaces?

Thanks
Soumik

From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: DB Creations/ Drop DB :: Not working...

Hi Soumik,

It seems your tablespace directory deleted by someone and you need to recreate tablespace for your database.

Go through the below link for more details.

https://www.postgresql.org/docs/10/manage-ag-tablespaces.html

Hope this will helps.

On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com> wrote:
Hi All,

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

And why this comes in?

postgres=# CREATE DATABASE symuatdb
postgres-#     WITH
postgres-#     OWNER = postgres
postgres-#     ENCODING = 'UTF8'
postgres-#     LC_COLLATE = 'en_US.utf8'
postgres-#     LC_CTYPE = 'en_US.utf8'
postgres-#     TABLESPACE = sym_m_data1
postgres-#     CONNECTION LIMIT = 10;
ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
postgres=#

Thanks
Soumik

9000799060

Re: DB Creations/ Drop DB :: Not working...

От

Shreeyansh Dba

Дата:

06 декабря 2018 г., 14:35:10

Hi Soumik,

It looks like your tablespace is as pointing correctly on 16386 to $PGDATA/pg_tblspc location. However, files in this goes missing(16386).

May consider recreating the tablespace.

On Thu, Dec 6, 2018 at 4:19 PM <soumik.bhattacharjee@kpn.com> wrote:

postgres=# SELECT spcname FROM pg_tablespace;
   spcname
--------------
pg_default
pg_global
sym_m_data1
sym_m_index1
(4 rows)

postgres=#

From: Bhattacharjee, Soumik
Sent: Thursday, December 06, 2018 11:48 AM
To: 'Shreeyansh Dba' <shreeyansh2014@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: RE: DB Creations/ Drop DB :: Not working...

Thanks,

But i can see the below in server.

postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ ls -ltr
total 0
lrwxrwxrwx. 1 postgres postgres 24 Dec 5 15:21 16386 -> /var/lib/postgresql/data
lrwxrwxrwx. 1 postgres postgres 28 Dec 5 15:27 16389 -> /var/lib/postgresql/data/idx
postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ pwd
/var/lib/postgresql/data/pgdata/postgresql-db/pg_tblspc

Do I need to re-create the pg_tblspc or user defined tablespaces?

Thanks
Soumik

From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: DB Creations/ Drop DB :: Not working...

Hi Soumik,

It seems your tablespace directory deleted by someone and you need to recreate tablespace for your database.

Go through the below link for more details.

https://www.postgresql.org/docs/10/manage-ag-tablespaces.html

Hope this will helps.

On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com> wrote:
Hi All,

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

And why this comes in?

postgres=# CREATE DATABASE symuatdb
postgres-#     WITH
postgres-#     OWNER = postgres
postgres-#     ENCODING = 'UTF8'
postgres-#     LC_COLLATE = 'en_US.utf8'
postgres-#     LC_CTYPE = 'en_US.utf8'
postgres-#     TABLESPACE = sym_m_data1
postgres-#     CONNECTION LIMIT = 10;
ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
postgres=#

Thanks
Soumik

RE: DB Creations/ Drop DB :: Not working...

От

Дата:

06 декабря 2018 г., 15:12:12

Thanks to you and All here.

I will follow the steps and update you all.

From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, December 06, 2018 12:35 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: DB Creations/ Drop DB :: Not working...

Hi Soumik,

It looks like your tablespace is as pointing correctly on 16386 to $PGDATA/pg_tblspc location. However, files in this goes missing(16386).

May consider recreating the tablespace.

On Thu, Dec 6, 2018 at 4:19 PM <soumik.bhattacharjee@kpn.com> wrote:

postgres=# SELECT spcname FROM pg_tablespace;
   spcname
--------------
pg_default
pg_global
sym_m_data1
sym_m_index1
(4 rows)

postgres=#

From: Bhattacharjee, Soumik
Sent: Thursday, December 06, 2018 11:48 AM
To: 'Shreeyansh Dba' <shreeyansh2014@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: RE: DB Creations/ Drop DB :: Not working...

Thanks,

But i can see the below in server.

postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ ls -ltr
total 0
lrwxrwxrwx. 1 postgres postgres 24 Dec 5 15:21 16386 -> /var/lib/postgresql/data
lrwxrwxrwx. 1 postgres postgres 28 Dec 5 15:27 16389 -> /var/lib/postgresql/data/idx
postgres@postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$ pwd
/var/lib/postgresql/data/pgdata/postgresql-db/pg_tblspc

Do I need to re-create the pg_tblspc or user defined tablespaces?

Thanks
Soumik

From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: DB Creations/ Drop DB :: Not working...

Hi Soumik,

It seems your tablespace directory deleted by someone and you need to recreate tablespace for your database.

Go through the below link for more details.

https://www.postgresql.org/docs/10/manage-ag-tablespaces.html

Hope this will helps.

On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com> wrote:
Hi All,

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

And why this comes in?

postgres=# CREATE DATABASE symuatdb
postgres-#     WITH
postgres-#     OWNER = postgres
postgres-#     ENCODING = 'UTF8'
postgres-#     LC_COLLATE = 'en_US.utf8'
postgres-#     LC_CTYPE = 'en_US.utf8'
postgres-#     TABLESPACE = sym_m_data1
postgres-#     CONNECTION LIMIT = 10;
ERROR: could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory
postgres=#

Thanks
Soumik

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: DB Creations/ Drop DB :: Not working...