Source database "template1" is being accessed by other users

[mohamedanees6]

Am using postgres (PostgreSQL) 9.3.24 and installed(also, init) stellar.

I am getting this error whenever I try to take a snapshot

Traceback (most recent call last):
File "/usr/local/bin/stellar", line 9, in
load_entry_point('stellar==0.4.5', 'console_scripts', 'stellar')()
File "/Library/Python/2.7/site-packages/stellar/command.py", line 279, in main
stellar()
File "/Library/Python/2.7/site-packages/click/core.py", line 764, in call
return self.main(*args, **kwargs)
File "/Library/Python/2.7/site-packages/click/core.py", line 717, in main
rv = self.invoke(ctx)
File "/Library/Python/2.7/site-packages/click/core.py", line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/Library/Python/2.7/site-packages/click/core.py", line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/Library/Python/2.7/site-packages/click/core.py", line 555, in invoke
return callback(*args, **kwargs)
File "/Library/Python/2.7/site-packages/stellar/command.py", line 60, in snapshot
app = get_app()
File "/Library/Python/2.7/site-packages/stellar/command.py", line 28, in get_app
app = Stellar()
File "/Library/Python/2.7/site-packages/stellar/app.py", line 45, in init
self.init_database()
File "/Library/Python/2.7/site-packages/stellar/app.py", line 64, in init_database
tables_missing = self.create_stellar_database()
File "/Library/Python/2.7/site-packages/stellar/app.py", line 72, in create_stellar_database
self.operations.create_database('stellar_data')
File "/Library/Python/2.7/site-packages/stellar/operations.py", line 57, in create_database
get_engine_url(raw_conn, database)
File "/Library/Python/2.7/site-packages/sqlalchemy_utils/functions/database.py", line 570, in create_database
result_proxy = engine.execute(text)
File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 2166, in execute
return connection.execute(statement, *multiparams, **params)
File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
return self.execute_text(object, multiparams, params)
File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1155, in _execute_text
parameters,
File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
e, statement, parameters, cursor, context
File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/Library/Python/2.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "/Library/Python/2.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) source database "template1" is being accessed by other users
DETAIL: There is 1 other session using the database.

However, when I type in,

sudo ps aux | grep template1

mohamedanees 32492 0.0 0.0 4268020 788 s002 S+ 10:14AM 0:00.00 grep template1

I am unable to see any process using template1.

Any pointers to solve this? I tried restarting postgres, disabled pgAdmin. Still this problem exisits.

[joey999]

SQLAlchemy==1.2.5 and SQLAlchemy-Utils==0.33.1

[volkanunsal]

Same here.

@joey999 Does it work with those versions?

[catogonzalez]

I had the same issue and fixed by editing stellar.yaml and changing template1 in this line

url: 'postgresql://charlie@localhost:5432/template1'

for whatever db name you are using.

[leonelgalan]

Same here.

@joey999 Does it work with those versions?

It did for me after getting these errors.

[ramonakira]

SQLAlchemy==1.2.5 and SQLAlchemy-Utils==0.33.1

Thanks this works for me, but is actually a downgrade since I had the following versions installed:

SQLAlchemy==1.3.16
SQLAlchemy-Utils==0.36.5

Anyone have an idea why this works?