Bug 49572

Summary:	Access to template1 database prevents all users from creating databases.
Product:	Red Hat Database	Reporter:	Neil Padgett <npadgett>
Component:	backend/kernel	Assignee:	Patrick Macdonald <patrickm>
Status:	CLOSED DEFERRED	QA Contact:	Patrick Macdonald <patrickm>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	7.1	CC:	dewayneneal94
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2001-07-20 19:57:25 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Neil Padgett 2001-07-20 19:57:21 UTC

From Bugzilla Helper:
User-Agent: Mozilla/4.77 [en] (X11; U; Linux 2.4.3-12smp i686)

Description of problem:
A user connected to database template1 prevents all database creation
attempts, until said user disconnects from the table. (Lock related?)

How reproducible:
Always

Steps to Reproduce:
1. Connect as user with access to database template1 to template1.
2. While that user is connected attempt to create a database -- creation
will fail.
	

Actual Results:  Error level results:
$ createdb phil
ERROR:  CREATE DATABASE: source database "template1" is being accessed by
other users
createdb: database creation failed


Expected Results:  No user should be able to impair database creation for
users authorized to create databases.

Additional info:

Comment 1 Patrick Macdonald 2001-11-29 19:57:58 UTC

Yes, this is the current situation.  We will defer this bug until kernel
database
work starts on the next release.  I will bring this matter to the attention of
the
community in the interim.  Thank you and have a pleasant day.