Here are 3 other sessions using the database. The table shows summarized data about each open session.

Here are 3 other sessions using the database To rectify this error and to drop the database, follow the steps given below. DETAIL: There are 3 other sessions using the database. Find the sessions connected to database using db link 3965 views Less than a minute 0 How To Resolve/Fix Error Database Is Being Accessed By Other Users Other Session Using The Database Knowledge 360 5. user property is then set to the yielded information. If you’re a developer working with Dockerized PostgreSQL, you’ve probably seen this error more times than you’d like to admit. These sessions are provided to thin clients as requested. Result: Session is killed (status = 'KILLED') but does not disappear from v$session for a very long time (until restarting the database). Dec 1, 2020 · Most three-tier applications today use connection pools—groups of sessions connected to the database. Depending on your application, you may need to use more advanced features such as session middleware or custom May 16, 2019 · Thanks John, Yes the application is 3-tier , uses connection pool OS version: Linux Release: Oracle Linux Server release 6. postgres=# In this blog post you will see step by step explanation hoe to Monitor SQL Server with Dynamic Management Objects – Sessions and connections. Oct 4, 2024 · Explore Laravel sessions in-depth with this guide on session management, configuration options, drivers, and best practices to securely store and retrieve session data in your web applications. Error "source database "template1" is being accessed by other users" while activating Mattermost on Gitlab CE 9. 或者使用 Navicat 等第三方数据库连接工具，删除指定数据库的时候报错，说明此时有两个客户 Sep 5, 2023 · I am trying to kill a session using the alter system kill session 'sid,serial#' immediate -command. Nov 16, 2022 · While I was writing the Async test code for FASTAPI there is a problem that cannot be solved. The database conversion cannot continue because there are other SQL Server sessions using the database. Sep 14, 2023 · An in-depth review of the Flask-Session extension for the Flask Python web application framework. The table shows summarized data about each open session. Apr 10, 2024 · ERROR: database 'xXx' is being accessed by other users DETAIL: There are 5 other sessions using the database. Nov 22, 2024 · Explore Laravel Sessions for efficient user data management, secure storage, and optimized performance. It’s important to remember that each session is tied to the specific engine it was created from, meaning you cannot use a PostgreSQL session to interact with the SQLite database and vice versa. DROP DATABASE throws error: postgres (at)template1 ERROR: database "mydb" is being accessed by other users postgres (at)template1 DETAIL: There is 1 other session using the database. Sep 5, 2023 · ERROR: source database "DB_NAME" is being accessed by other users DETAIL: There is 1 other session using the database. Here, PostgreSQL reports an error: The database test_db is being accessed by another user. In Hibernate there is a concept called a session. 翻译如下： 错误：数据库“appbuilder_001”正在被其他用户连接。 细节：有3个地方在使用这个数据库。 解决方法： 断开连接到这个数据库上的所有链接，再删除数据库。 Oct 4, 2021 · エラー内容 $ DROP DATABASE samples ERROR: database "samples" is being accessed by other users DETAIL: There are 4 other session(s) using the database. Improve database efficiency—read the article here! With in your script when you are validating your session, check the expire date when the session data is found. When the client is done with the session, the client releases it to the pool. 8 Monitoring the Database As an administrator, you can monitor the activities of the database and its users. We also see one user’s session is locking out another user’s sessions I wondered if anyone on here has experienced this and if it is possible to manage it We’re on Apps 9 SP11 - 2 X Windows App Servers with 3 X Linux Oracle Database servers. Speaking of the rename operation, check out our guide on how to rename a table in MySQL. The figure shows applications creating application sessions in the database. What is the use of a session? When should database access happen in two sessions rather than in the same session? Oct 22, 2025 · Sometimes a systemstate cannot be taken and uploaded to support, and it is desirable to manually find what sessions are blocking other sessions. utils. argv) Oct 12, 2019 · ERROR: database “appbuilder_001” is being accessed by other users DETAIL: There are 3 other sessions using the database. I test using the local file system, SQLAlchemy with a PostgeSQL database, and a Redis database to provide the sessions' backend data storage. Edit Sep 22, 2020 · This is expected and by design, so closing the issue. Figure 3-1 also shows other components of Real Application Security such as ACLs, application privileges Mar 14, 2024 · 错误信息 查询出错 (7): ERROR: database "test" is being accessed by other users DETAIL: There are 10 other sessions using the database. 0: schem Im rather confused at the database session's graph, it seems like total and idle sessions tend to jump around like that while active sessions remain at a constant 1. You've even tried shutting down the processes you see using the ps -ef | grep postgres command, but it spits out another frustrating error: kill: kill 2358 failed: operation not permitted Jun 19, 2025 · 针对RDS PostgreSQL删除数据库时“There are 2 other sessions using the database”报错，本文提供`pg_terminate_backend`命令的代码示例，助您强制断开连接并成功删除数据库。 Jul 17, 2014 · ActiveRecord::StatementInvalid: PG::ObjectInUse: ERROR: database "app_test" is being accessed by other users DETAIL: There is 1 other session using the database. Learn best practices, advanced techniques, and explore practical examples for effective session management. You can also connect to the command line without selecting a specific database, and drop your database. Review your application code and make sure all connections are properly closed or terminated. Aug 8, 2021 · Many times DBA need to look at the session details for analysis. 翻译如下： 错误：数据库“appbuilder_001”正在被其他用户连接。 细节：有3个地方在使用这个数据库。 解决方法： 断开连接到这个数据库上的所有链接，再删除数据库 Mar 30, 2021 · Session Basics ¶ What does the Session do ? ¶ In the most general sense, the Session establishes all conversations with the database and represents a “holding zone” for all the objects which you’ve loaded or associated with it during its lifespan. Close the previous session, and come back to this session and try renaming again: Nov 13, 2019 · One of the most popular blogs I’ve written about PostgreSQL was about the three databases that PostgreSQL creates by default (well, actually it is initdb that creates the databases). There is an inherent tradeoff between the amount of data stored in a session and database load incurred when authenticating a session. Introduction SQL Server sessions are a way to establish a connection between a client and a database. The problem is related to using threads that access the database inside a TransactionTestCase Explicitly closing database connections before the threads exit seems to resolve the issue We are using the following decorator: def close_db_connections(func, *args, **kwargs): """ Decorator to close db connections during threaded execution There is 1 other session using the database. SQL Server 2016 introduced a new built-in-function SESSION_CONTEXT () as improvement over the existing CONTEXT_INFO function. It provides the entrypoint to acquire a Query object, which sends queries to the database using the Session object’s current database 6 days ago · Use sys. I've tried to lock down the number of conns to the db with these two three: Sep 8, 2015 · ERROR: source database "database_name" is being accessed by other users DETAIL: There are 5 other sessions using the database. If you want, you can drop the test database manually, using pg_terminate_backend(. g. Unlock seamless functionality for your web apps today! Oct 2, 2008 · What's the best way, using SQL, to check the maximum number of connections that is allowed for an Oracle database? In the end, I would like to show the current number of sessions and the total number Dec 27, 2023 · As an experienced Oracle DBA, one of my most critical tasks is monitoring database sessions to optimize performance and security. 翻译如下： 错误：数据库“appbuilder_001”正在被其他用户连接。 细节：有3个地方在使用这个数据库。 解决方法： 断开连接到这个数据库上的所有链接，再删除数据库。 Sep 2, 2021 · When using multiple branches that have slightly different db schemas - I have found myself needing to recreate my local development and test db fairly often. Jun 8, 2023 · Hi, session cookies - when used with an adapter - are tied to the session row in the database. Did anyone experience similar issues? How can I fix this? ERROR: source database "database_name" is being accessed by other users DETAIL: There are 5 other sessions using the database. 対応方法 DBへの接続を遮断するコマンド select pg_terminate_backend(pid) from pg_stat_activity where datname = 'データベース名'; pg_stat_activity テーブル デフォルトで存在するビューテーブルで Aug 29, 2023 · Renaming a database: Similar to dropping a database, renaming a PostgreSQL database with an ALTER DATABASE query requires terminating all active sessions related to it. Feb 15, 2025 · Copy PostgreSQL: psql:RemoveSQL. I'm using postgres and in order to user db as a test, I created is_testing fu Sep 2, 2023 · ERROR: database "database_name" is being accessed by other users DETAIL: There are 1 other session(s) using the database. Possible Causes 1 2 Cause of the error: There are currently other connections using the database Solution: Execute the following command to disconnect all connections to the Qinghua database. ERROR: database "testdb" is being accessed by other users DETAIL: There are 3 other sessions using the database. Oct 12, 2025 · 删除，都会报错提示 ERROR: database "mydb" is being accessed by other users DETAIL: There are 3 other sessions using the database. You use KILL command or you can change database mode from Multi User to Single User which close all your running sessions of SQL Server. Dec 27, 2024 · The use command is used when there are multiple databases in the SQL and the user or programmer specifically wants to use a particular database. One of the points mentioned in that post was, that you can not drop a database as long as there are sessions against the database you […] Apr 25, 2024 · ERROR: database is being accessed by other users DETAIL: There are 4 other sessions using the database. Whether you‘re a new DBA or seasoned Oracle guru, you‘ll learn insider […] The session will be a hands-on workshop combining interactive demos, guided exercises, and real-world case studies, where attendees will learn to automate database deployments, leverage CoPilot for SQL development, and implement CI/CD best practices using GitHub, Azure DevOps, and SQL Projects. IntroductionIn the realm of web development, managing user interactions efficiently is paramount. DETAIL: There is 1 other session using the database. See Is it possible to open two psql sessions that use the same database connection? My goal is to show that a second user on the same connection can see uncommitted INSERT s, wherease a user on a different connection can't see INSERT s until the first connection runs COMMIT on its transaction. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "manage. Feb 18, 2022 · The force option is your friend if other sessions are open on the database, where you would manually use SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='db_name'. object_name). Jan 28, 2024 · Bug description Error: ERROR: database "prisma_migrate_shadow_db_e7e7be05-85c7-4aa1-9bd6-60f43e7514d7" is being accessed by other users DETAIL: There is 1 other session using the database. One of the points mentioned in that post was, that you can not drop a database as long as there are sessions against the database you […] Jan 31, 2024 · To resolve the 55006 error, you need to ensure that the object is not being accessed by any other sessions when you perform the operation. . trueYou disconnect the other users and then rename it. Feb 2, 2023 · ERROR: database "mydb" is being accessed by other users DETAIL: There are 1 other sessions using the database. During a session, a client can execute SQL commands and retrieve data from the database. This guide enables the 'blocking' session to be ascertained manually. USE DATABASE Specifies the active/current database for the session: If a database is not specified for a session, any objects referenced in queries and other SQL statements executed in the session must be fully qualified with the database and schema, also known as the namespace, for the object (in the form of db_name. Oct 23, 2025 · Idle sessions are even more problematic when the session is processing a query that returns a large number of rows and partway through, the session becomes idle, waiting for the client to issue a call to fetch the next set of rows. I suspect that this is caused by the Ruby on Rails app maintaining a persistent connection to the database. It acts as a higher-level abstraction over the connection, providing a more convenient and Mar 12, 2021 · ERROR: database "testdb" is being accessed by other users DETAIL: There are 3 other sessions using the database. Nov 29, 2018 · ERROR: database "testdb" is being accessed by other users DETAIL: There are 3 other sessions using the database. Understand session management, commit, and rollback mechanisms. All of the following examples use DatabaseSession. Here are some examples of how to fix it: Oct 28, 2025 · The table shows summarized data about each open session. Is there a way to force disconnect every connection to template1 that logged in now? In this case, Postges tries to protect other sessions from data losses, so it cannot drop/rename the database before they all disconnect. Here I am giving Query to get session details in oracle database, how to get the sql text from sid in oracle, how to check inactive sessions in oracle, how to check active sessions in oracle and other queries which will help in troubleshooting Figure 3-1 shows a Real Application Security architecture diagram and indicates how application sessions fit into it. Feb 11, 2025 · Django provides a robust session framework that allows you to store and retrieve arbitrary data on a per-visitor basis. OperationalError: database "test_mydbname" is being accessed by other users Sqlite error: sqlite3. 22K subscribers Subscribed Warning You should only use cache-based sessions if you’re using the Memcached or Redis cache backend. The local-memory cache backend doesn’t retain data long enough to be a good choice, and it’ll be faster to use file or database sessions directly instead of sending everything through the file or database cache backends. This section contains the following topics: Monitoring Sessions Monitoring the Top SQL Statements Monitoring Long Operations But I cannot import the same exported file using psql -U root postgres backup. If you do it this way, you won't have to run into too many problems of ID collision or lots of queries slowing down your server. Jan 14, 2025 · Learn about Oracle read by other session wait events and how to address them. postgres (at)template1 STATEMENT: DROP DATABASE "mydb" How to disconnect all users from database 16 Quick fix in PgAdmin: just create another empty database. Voila. You can see the sessions from select * from pg_stat_activity; and then you can use select pg_terminate_backend(xxx); to terminate a particular session. The problem here is not that other users are connected to the database, but that you are. I review how well it can be used to manage ephemeral, anonymous user sessions. The details include sql_id, stats, locking, wait events. It works with the SQL Azure database as well. If no sessions are available, a new one may be created. 5 I thought the same as Inactive session should not effect, but it was evident that ETL batch was running significantly slow when we had 600+ inactive sessions when there were no such sessions ETL running fine. Dec 24, 2019 · I want to delete a Postgresq database. Oct 24, 2025 · You can specify conditions and filters to obtain data about the current sessions in your Managed Database. Oct 8, 2020 · ERROR: database "hoge_development" is being accessed by other users DETAIL: There are 1 other sessions using the database. Whether you're building a simple website or a complex web application, understanding how to use sessions Session pooling means that the application creates and maintains a group of stateless sessions to the database. Jun 29, 2015 · I am using postgres and was consistently receiving PG::ObjectInUse when running rake parallel:prepare. Thus, in simple terms, the use statement selects a specific database and then performs operations on it using the inbuilt commands of SQL. OperationalError: database table is locked: test_mydbname I've tried swapping sync_to_async with database_sync_to_async from django-channels, but this didn't change anything. Replace catalog with your database name. Dec 16, 2021 · Postgresql数据库不能删除成功，并提示 ERROR: database “appbuilder_001” is being accessed by other users DETAIL: There are 3 other sessions using the database. Whether you‘re a new DBA or seasoned Oracle guru, you‘ll learn insider […] Dec 8, 2017 · It’s possible to use the sys. OperationalError: database "test_postgres" is being accessed by other users DETAIL: There is 1 other session using the database. But the DROP DATABASE command fails with: ERROR: database "testdb" is being accessed by other users DETAIL: There are 4 other sessions using the database. You can use the Column, Operator and Value fields to search for the required sessions. Optimize database transactions with SQLAlchemy Sessions for effective data manipulation. py", line 15, in <module> execute_from_command_line(sys. This situation can be frustrating, especially when you are the only user of the database. Oct 12, 2019 · ERROR: database “appbuilder_001” is being accessed by other users DETAIL: There are 3 other sessions using the database. psql:RemoveSQL. Our current database configuration allows up to 16 sessions per user, and unfortunately, increasing this limit is not an option for us. I want to drop all the active connections on demand, they should be dropped forcefully and for N minutes. Aug 8, 2021 · On one server I have a Postgresql database and there're many clients on other servers accross the internet that connect to it. One of the most effective ways to achieve this is through the use of sessions. Jan 21, 2019 · You can use the sp_who stored procedure. TopLink provides several different session objects that all implement the same Session interface. sql:2: ERROR: database "cdfidmdb" is being accessed by other users DETAIL: There are 9 other sessions using the database. There are 2 other sessions using the database, Programmer Sought, the best programmer technical posts sharing site. You can use this information for tuning, troubleshooting, and more. Aug 25, 2022 · In PostgreSQL, if you have active connection to the database and if you try to DROP the database, you will get the following error. Master PHP session handling with this comprehensive guide. Sessions enable web applications to maintain state and store user-specific data across multiple requests. Unlock seamless functionality for your web apps today! Dec 27, 2023 · As an experienced Oracle DBA, one of my most critical tasks is monitoring database sessions to optimize performance and security. Grafana uses an embedded sqlite3 database to store users, dashboards, and other persistent data by default. Jul 3, 2013 · In my case, it seems the database cluster is still doing some processing on the database, and while there are no other external/user connections, the database is still internally in use. Sep 2, 2023 · DETAIL: There is 1 other session using the database. Use a Job Profiles work well if you want to affect all sessions connected to a specific user, but sometimes you may need a finer level of control. sql because of this error: DROP DATABASE ERROR: database "exfi" is being accessed by other users DETAIL: There are 1 other session(s) using the database. So the … ActiveRecord::StatementInvalid: PGError: ERROR: database <database_name> is being accessed by other users DROP DATABASE IF EXISTS <database_name> This happens if someone has accessed the application via web recently (postgres keeps a "session" opened) Is there any way that I can terminate the sessions on the postgres DB? Thank you. Apr 25, 2024 · ERROR: database is being accessed by other users DETAIL: There are 4 other sessions using the database. Surprise thing here is that this is not happening daily, what Jan 20, 2024 · A session represents a logical context within the application for interacting with the database. It will terminate all active connections on the specified database. I do this: REVOKE CONNECT ON DATABASE db1 FROM public; SELECT pid, pg_terminate_backe Sep 5, 2023 · ERROR: source database "DB_NAME" is being accessed by other users DETAIL: There is 1 other session using the database. Although you have terminated the connection using the pg_terminate_backend() function, someone or something keeps automatically connecting to the database, preventing you from dropping it. Retrieve the associated user’s session data, including their name. Select a session in the table to see more detailed data in the Session Details table below, such as the last SQL statement, explain plan, waits, contention, and so on. Provides information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine. OperationalError: database "test_axpress" is being accessed by other users 2024-01-18 19:05:03 DETAIL: There is 1 other session using the database. At 1st attempt I get: There are 15 other sessions using the database. It uses key-value pairs for storing the session data. The information can be filtered to return only those processes that are not idle, that belong to a specific user, or that belong to a specific session. May 9, 2012 · 30 I understand a general understanding of the concept of a database transaction. Then if want to duplicate or drop a database I have to run this query to terminate all the connections before: Feb 19, 2024 · In this tutorial, you will learn how to use the DROP DATABASE statement to drop a database from a PostgreSQL server. I am trying to drop a database, but when I try to drop it, I get this error: ERROR: database "mydb" is being accessed by other users DETAIL: There are 24 other sessions using the database. We access a database within transaction to ensure ACID properties. schema_name. May 2, 2018 · The other session can come from stellar itself (=same process), or from some other process (=stuck? stellar background process). A session represents the connection between an application and the relational database that stores its persistent objects. Oct 16, 2022 · postgres15删除数据库时报以下错误： postgres=# drop database jw_admin ; ERROR: database "jw_admin" is being accessed by other users DETAIL: There are 3 other sessions using the database. db. In this case, the session cookie only contains a random token to look up the session. If we detect that the session expired when accessed, it gets deleted from the database, and the cookie is cleared. Thus, the number of sessions in the pool can increase dynamically. dm_exec_sessions Dynamic Management View to identify all user sessions for a specific database – or all databases if the change being implemented is server-scoped – and create a dynamic KILL statement for each applicable session that is returned from the following query: /* For a specific database */ Feb 28, 2024 · These are basic examples to get you started with session management in Laravel. Apr 10, 2019 · psycopg2. In this comprehensive 2500+ word guide, I‘ll demystify exactly how to check for active and inactive sessions using Oracle‘s powerful data dictionary views. Sep 2, 2023 · Sometimes, even if you are not actively using the database, there may be applications or scripts that are still connected to it. All load balanced Dec 23, 2016 · Database Research & Development: Shared scripts to kill running sessions or processes of the SQL Server. The use of database sessions has security implications, because part of the database session is the ID of a database user, which usually cannot be changed after the session is created. We set these key-value pairs using the stored procedure sp_set_session_context. select pg_terminate_backend(pid) from (select pid from pg_stat_activity where datname = 'Database_Name' ) a; Session Validation and User Information Retrieval: Using the session ID, validate its existence and authenticity in your secure session database or cache. Here I am giving Query to get session details in oracle database, how to get the sql text from sid in oracle, how to check inactive sessions in oracle, how to check active sessions in oracle and other queries which will help in troubleshooting PostgreSQL Locks help us with concurrent access or modifications of the database objects by issuing a lock as soon as the command is executed. Can you try to check if there was some sql process going before running the stellar command? So run psql -c "select * from pg_stat_activity where datname='stellar_data'". 这个意思是说，删除数据库失败，因为这里还有3个链接连接到该数据库上，PostgreSQL在有进程连接到数据库时，对应的数据库是不运行被删除的。 那么怎么办呢？ Apr 10, 2020 · Hi! Postgres 12 does not allow to drop database if it is in use. To stop other users from accessing the database without cleaning the pool use pg_terminate_backend from the script. To address this issue, we have tried adjusting the connector settings with the following custom properties: Max Pool Size Aug 8, 2021 · Many times DBA need to look at the session details for analysis. Sep 17, 2018 · django. Running the steps separately by switching to rake parallel:drop parallel:create parallel:load_schema seems to have resolved it. Aug 29, 2023 · Renaming a database: Similar to dropping a database, renaming a PostgreSQL database with an ALTER DATABASE query requires terminating all active sessions related to it. This shared database can be either MySQL or Postgres. Note: PostgreSQL When a process is connected to a database, the corresponding database is not running deleted. Jun 26, 2014 · "The database on the server must be converted before you can use it with this version of the Microsoft Dynamics NAV Development Environment. dm_exec_sessions to first view the current system load and to identify a session of interest, and then learn more information about that session by using other dynamic management views or dynamic management functions. The req. For high availability, you must use a shared database to store this data. postgre With the session factories created, you can now instantiate sessions to perform operations on each database. if the ID is found, but the session is expired, delete the session and start a new one. This tradeoff is particularly pertinent when session data is stored on the client, rather than the server, using a package such as cookie-session. Nov 6, 2024 · Explore the implications of using SQLAlchemy sessions and learn best practices for session management in your web applications. Delete the first one. Every time I login to template1, I use 'exit' command to logout, but as you can see it does not logout and number of sessions increases everytime I login. I just Jan 17, 2013 · OperationalError: source database "template1" is being accessed by other users DETAIL: There are 5 other session(s) using the database. The simplest session is the DatabaseSession, which can be used for single user/single database applications. OperationalError: database "test_default_db" is being accessed by other users DETAIL: There are 2 other sessions using the database. Jan 18, 2024 · 2024-01-18 19:05:03 django. Additionally, the local-memory cache backend is NOT multi-process Jan 19, 2023 · This article describes a new feature in PostgreSQL that allows the DROP DATABASE command to be executed even if active sessions are connected to the database. Here’s how to create and use sessions for both databases: django. Select it. If you can identify the problem sessions using SQL and/or PL/SQL, you can easily write a procedure to kill the problem sessions and call that procedure from a database job. Is there a way to ensure that all connections are closed before tearing down the database? Mar 12, 2021 · ERROR: database "testdb" is being accessed by other users DETAIL: There are 3 other sessions using the database. sql:1: ERROR: database "bvd" is being accessed by other users DETAIL: There are 5 other sessions using the database. May 27, 2025 · Hello, We have recently encountered the ORA-02391 error, which indicates that the simultaneous SESSIONS_PER_USER limit has been exceeded. If those sessions will automatically come back again, you may need to either stop them or temporary change e. ) function and pg_stat_activity view you already used: Nov 13, 2019 · PostgreSQL DROP Database DETAIL: There is 1 other session using the database I recently wanted to drop a database in Postgresql and i went haywire when i couldn’t drop the database. Solution: Disconnect all links to this database, then delete the database. Mar 28, 2024 · Step-by-Step Instructions Using PGAdmin, right-click on a Database other than the one you would like to drop, then select Query tool Paste the command below. Our testing environment attempts to drop databases before recreating them. Dec 9, 2010 · Microsoft SQL Server articles, forums and blogs for database administrators (DBA) and developers. 0 Nov 13, 2019 · One of the most popular blogs I’ve written about PostgreSQL was about the three databases that PostgreSQL creates by default (well, actually it is initdb that creates the databases). Some of the sessions in Jul 6, 2018 · Useful SQL queries for Oracle to explore database schema. An application uses any available session from this pool when it needs database interaction, and it releases the session when the interaction is done. the credentials or permissions so that they won't be able to. Some of these application sessions are associated with traditional database (DB) sessions. How can I stop this session, I need to delete the database, can't find any answers on Google Jul 10, 2018 · ERROR: database "my_db" is being accessed by other users DETAIL: There are 3 other sessions using the database. A session is created when a client logs in to a database and remains active until the client logs out or the session is terminated for some other reason. Oct 19, 2021 · 遇到的问题在PostgreSQL 9. 2 及以上版本，执行下面的语句：postgres=# drop database dbtest;# 执行删除指定数据库的时候，报以下错误ERROR: database "dbtest" is being accessed by other usersDETAIL: There is 2 other session using the database. this code is for test db. mmwsdyn txexx fksv htjm yfp jesfl alqebsn arc fmhfrgzjt fwzcda cvlejl qqyyq yvcg guubdz iuezlmn