agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rob Sargent <robjsargent@gmail.com>
To: p.sun.fun@gmail.com
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Subject: Re: libpq CREATE DATABASE operation from multiple treads
Date: Thu, 8 Oct 2020 14:50:31 -0600
Message-ID: <23F4DE61-F81D-4740-A227-74B5EB41304C@gmail.com> (raw)
In-Reply-To: <47a7c4ffa62aaf2b86854a657f484f33913207c9.camel@gmail.com>
References: <390804abe88e4e9da9049f6e05c841783acaca47.camel@gmail.com>
<CAAfz9KOVPRptcva6T97+VgLhYbqMJGC07yHVHMW3Ugxki6y6dA@mail.gmail.com>
<124ce8dff8402159f20dec1bc1ac27e26ee39c23.camel@gmail.com>
<96718FB0-E258-4342-BD6E-BCE6603BCBD5@gmail.com>
<e11780112264fddbae35f53a3b26095f1789e413.camel@gmail.com>
<058A9601-35F6-42C1-AC4C-8DD4643E418F@gmail.com>
<47a7c4ffa62aaf2b86854a657f484f33913207c9.camel@gmail.com>
> On Oct 8, 2020, at 2:46 PM, p.sun.fun@gmail.com wrote:
>
> On Thu, 2020-10-08 at 14:43 -0600, Rob Sargent wrote:
>>
>>
>>> On Oct 8, 2020, at 2:41 PM, p.sun.fun@gmail.com wrote:
>>>
>>> On Thu, 2020-10-08 at 14:35 -0600, Rob Sargent wrote:
>>>>> On Oct 8, 2020, at 2:30 PM, p.sun.fun@gmail.com wrote:
>>>>>
>>>>> Indeed, this is a FATAL_ERROR. From two threads I got:
>>>>>
>>>>> // Thread #1
>>>>> FATAL_ERROR: ERROR: source database "template1" is being
>>>>> accessed
>>>>> by
>>>>> other users
>>>>> DETAIL: There is 1 other session using the database.
>>>>>
>>>>> // Thread #2
>>>>> FATAL_ERROR: ERROR: source database "template1" is being
>>>>> accessed
>>>>> by
>>>>> other users
>>>>> DETAIL: There is 1 other session using the database.
>>>>>
>>>> I would try using dbname=postgres.
>>> aaaaand.... it works. Two databases have been created with return
>>> status "COMMAND_OK".
>>>
>>>> If you get the same error, I would say your server is in single
>>>> user
>>>> mode?
>>
>> And if you try it again using template1?
>>
>
> Nope, the same errors:
> // Thread #1
> FATAL_ERROR: ERROR: source database "template1" is being accessed by
> other users
> DETAIL: There is 1 other session using the database.
>
> // Thread #2
> FATAL_ERROR: ERROR: source database "template1" is being accessed by
> other users
> DETAIL: There is 1 other session using the database.
>
>
>
OK, well that’s a special db. Didn’t know it was that special, though!
view thread (18+ messages) latest in thread
Message-ID: <23F4DE61-F81D-4740-A227-74B5EB41304C@gmail.com>
Permalink: ../23F4DE61-F81D-4740-A227-74B5EB41304C@gmail.com/
Also on: postgresql.org/message-id/23F4DE61-F81D-4740-A227-74B5EB41304C@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, p.sun.fun@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: libpq CREATE DATABASE operation from multiple treads
In-Reply-To: <23F4DE61-F81D-4740-A227-74B5EB41304C@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox