5.2.12. Operations with the list of connections

<< Prev   Next >>

5.2.12.1. General information

The list of connections can be displayed:

• For the entire cluster
• For a working process of a cluster
• For an infobase
• For a working process of a cluster server

To display the list of connections for the entire cluster, select a main server in the main server tree and a cluster registered on this server. After that, select and expand the Connections branch.

To display the list of connections for a working process of a cluster, select a main server, a cluster, and the Working processes branch. After that, select a working process and expand the Connections branch.

To display the list of connections for an infobase, select a main server in the main server tree, a cluster, and an infobase. After that, select and expand the Connections branch.

To display the list of connections for a working process of a cluster server, select a main server in the main server tree, a cluster, a cluster server, and a working process. After that, select and expand the Connections branch.

Connections are not displayed in the main server tree. The properties field displays a list of connections that contains the following information:

Name of the connected infobase. This field is empty for service connections.

Connection number. Number of each new infobase connection is incremented by 1. A new connection can only have number 1 assigned if no connections were established to the infobase previously. Number 0 is only assigned to service connections not associated with any infobase. Therefore, both in file and client/server modes, connections are numbered starting from 1 only after all clients, including scheduled and background jobs, disconnect from the infobase.

Session number associated with the connection.

Network name of the computer that established the connection.

Identifier of the application using this connection.

Name of the connected cluster server.

Number of the network port of the working process servicing this connection.

Time when this connection was established.

If the list of connections is open for an infobase, additional columns are displayed in the properties field, allowing you to quickly analyze database locks. These properties are described in the next section.

5.2.12.2. Viewing connection properties

To view connection properties, select a connection in the connection list and execute the Properties context menu command or the same main menu command of the utility.

This will open the dialog box of connection properties.

The dialog box of connection properties contains the following information (all connection properties are not editable):

User on whose behalf this connection is established.

Name of the computer that established the connection.

Name of the application that established the connection to the infobase.

Indicates that an exclusive infobase lock has been enabled.

Indicates that the connection is established with a database.

Indicates that an exclusive infobase mode is enabled.

Name of the server to which you are connected.

Network port of the server used for the connection.

Time when the connection was established.

ID of the current connection.

ID of the database server process. It is displayed if the connection currently performs a database call.

Duration of database server access at the moment of opening the properties dialog box. It is displayed if the connection currently performs a database call.

Total duration of DBMS calls since the beginning of the first call (in seconds).

Total duration of DBMS calls in the last 5 minutes (in seconds).

Duration of the current DBMS call since its start (in seconds).

Amount of data sent over this client connection between 1C:Enterprise server and the database server since the beginning of this session (in bytes).

Amount of data sent over this client connection between 1C:Enterprise server and the database server in the last 5 minutes (in bytes).

ID of the process that locked the process.

User name (connection number), which is displayed if a process is waiting for a transaction lock to be released.

Total duration of server calls since the client connection was established (in seconds).

Duration of server calls by this connection in the last 5 minutes.

Current execution time of the latest incomplete server call.

Total number of server calls made by this connection since it was established.

Total number of server calls made by this connection in the last five minutes.

Amount of data sent and received since the connection was established (in bytes).

Amount of data sent and received in the last five minutes (in bytes).

Amount of RAM used for calls since this connection was established (in bytes).

Amount of RAM used for calls in the last 5 minutes (in bytes).

Amount of RAM used since the current call was initiated (in bytes).

Amount of data read from a hard drive since the current call was initiated (in bytes).

Amount of data read by this session from a hard drive since the connection was established (in bytes).

Amount of data read by this connection from a hard drive in the last 5 minutes (in bytes).

Amount of data written by this connection to a hard drive since the session start (in bytes).

Amount of data written by this session to a hard drive in the last 5 minutes (in bytes).

Amount of data written to a hard drive since the beginning of the current call (in bytes).

The following properties are available only in the connection list of an infobase and are not displayed in the connection properties.

Current running time of the cluster service. Name of the service is specified in the Current service property.

Name of the service that is currently running. If the column is empty, it means that no cluster services are running currently.

Total running time of all cluster services in the last 5 minutes.

Total running time of all cluster services since the beginning of the session.

5.2.12.3. Terminating a connection

To terminate a connection, select the connection in the connection list and execute the Delete context menu command or the same main menu command of the utility.

If a large query to a Microsoft SQL Server database, IBM DB2, or Oracle Database is in progress, 1C:Enterprise server attempts to terminate the connection. The attempt succeeds if the user who is connecting to the database server has the appropriate rights. For more information about the required database user rights, see the documentation for the DBMS you are using. If the connection is terminated successfully, the user will receive the following message: The session is terminated by the administrator. PostgreSQL database connections cannot be terminated. Any termination attempts will have no effect.

If the client runs code on 1C:Enterprise server, 1C:Enterprise server will attempt to disconnect the client application from the server. To terminate a connection, you need the access rights of a server cluster administrator and infobase administrator. If the connection is terminated successfully, the user will receive the following message: The session is terminated by the administrator.

Connection cannot be terminated while 1C:Enterprise server is performing a client call and only one 1C:Enterprise language code line is being executed (except for DBMS calls). For example, a connection cannot be terminated when a long call to a COM object method or an HTTP call is made from code in 1C:Enterprise language.

<< Prev   Next >>