Connect error : Database is probably already opened by another engine instance in another Windows session. ----------------------------------------------------------------------------------------------------------
Key: CORE-4751 URL: http://tracker.firebirdsql.org/browse/CORE-4751 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.4 Environment: 2.5.4, Classic Server, x32 Reporter: Attila Molnár Hi! I've started a long running process at 14 Apr 2015 07:34:38 +0200, which maintains the database schema and data by running a lot of DDL, DQL, DML commands. The process also does connect-disconnect many times. Error in client side : "Database is probably already opened by another engine instance in another Windows session." at 14 Apr 2015 07:37:53 +0200 This error is raised when I try to connect to the database. No concurrency in client side, calls are made from apps main thread. Looks like sweep connection / concurrency handling is flawed. Logs in server side (2.5.4 Classic Server) L3S-4 Tue Apr 14 07:35:45 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 227897, OST 227897, Next 227898 L3S-4 Tue Apr 14 07:36:03 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:36:03 2015 Error during sweep: connection shutdown L3S-4 Tue Apr 14 07:36:03 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 228222, OST 228222, Next 228227 L3S-4 Tue Apr 14 07:36:59 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:36:59 2015 Error during sweep: connection shutdown L3S-4 Tue Apr 14 07:36:59 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 228232, OST 228232, Next 229499 L3S-4 Tue Apr 14 07:37:01 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:37:01 2015 Error during sweep: connection shutdown L3S-4 Tue Apr 14 07:37:01 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 229502, OST 229502, Next 229504 L3S-4 Tue Apr 14 07:37:19 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:37:19 2015 Error during sweep: connection shutdown L3S-4 Tue Apr 14 07:37:19 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 229508, OST 229508, Next 229511 L3S-4 Tue Apr 14 07:37:20 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:37:20 2015 Error during sweep: connection shutdown L3S-4 Tue Apr 14 07:37:20 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 229537, OST 229537, Next 229539 L3S-4 Tue Apr 14 07:37:21 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:37:21 2015 Error during sweep: connection shutdown L3S-4 Tue Apr 14 07:37:21 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 229671, OST 229671, Next 229673 L3S-4 Tue Apr 14 07:37:25 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:37:25 2015 Error during sweep: connection shutdown L3S-4 Tue Apr 14 07:37:25 2015 Sweep is started by SWEEPER Database "D:\DATABASES\AMOLNAR_ELESKER.GDB3S" OIT 207896, OAT 229990, OST 229990, Next 229994 L3S-4 Tue Apr 14 07:37:53 2015 Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s) L3S-4 Tue Apr 14 07:37:53 2015 Error during sweep: connection shutdown -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel