[NXP-15978] Better debugging of database-level connections - Nuxeo Issue Tracker

XML

Word

Printable

Tags:
- nxRepoTeam
Upgrade notes:

Hide

Property "org.nuxeo.vcs.setClientInfo" can now be set to "true" to pass an "Application Name" to the database for each connection.

The application name is "nuxeo" when idle, or "nuxeo m=123" when in use, where 123 is the mapper instance id (also visible as (123) SQL: ... in TRACE logs).

Show
Property "org.nuxeo.vcs.setClientInfo" can now be set to "true" to pass an "Application Name" to the database for each connection. The application name is "nuxeo" when idle, or "nuxeo m=123" when in use, where 123 is the mapper instance id (also visible as (123) SQL: ... in TRACE logs).
Sprint:
Sprint RepoTeam 7.1-1

A SQL database connection can pass an "ApplicationName" that is visible when debugging the active connections server-side.

For instance on PostgreSQL, you can see it in the application_name column of pg_stat_activity.

-> Use this to pass info about what nuxeo mapper is using the connection