{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31766","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31766/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31766/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31766/events","html_url":"https://github.com/cockroachdb/cockroach/issues/31766","id":373183699,"node_id":"MDU6SXNzdWUzNzMxODM2OTk=","number":31766,"title":"pgwire: application_name in connection URL only partially works","user":{"login":"bdarnell","id":160562,"node_id":"MDQ6VXNlcjE2MDU2Mg==","avatar_url":"https://avatars1.githubusercontent.com/u/160562?v=4","gravatar_id":"","url":"https://api.github.com/users/bdarnell","html_url":"https://github.com/bdarnell","followers_url":"https://api.github.com/users/bdarnell/followers","following_url":"https://api.github.com/users/bdarnell/following{/other_user}","gists_url":"https://api.github.com/users/bdarnell/gists{/gist_id}","starred_url":"https://api.github.com/users/bdarnell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bdarnell/subscriptions","organizations_url":"https://api.github.com/users/bdarnell/orgs","repos_url":"https://api.github.com/users/bdarnell/repos","events_url":"https://api.github.com/users/bdarnell/events{/privacy}","received_events_url":"https://api.github.com/users/bdarnell/received_events","type":"User","site_admin":false},"labels":[{"id":915886178,"node_id":"MDU6TGFiZWw5MTU4ODYxNzg=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/A-sql-pgwire","name":"A-sql-pgwire","color":"22aa88","default":false},{"id":912424518,"node_id":"MDU6TGFiZWw5MTI0MjQ1MTg=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/A-telemetry","name":"A-telemetry","color":"3da823","default":false},{"id":78928345,"node_id":"MDU6TGFiZWw3ODkyODM0NQ==","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/C-bug","name":"C-bug","color":"c5def5","default":false},{"id":331442906,"node_id":"MDU6TGFiZWwzMzE0NDI5MDY=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/docs-done","name":"docs-done","color":"f7c6c7","default":false},{"id":571388139,"node_id":"MDU6TGFiZWw1NzEzODgxMzk=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/docs-known-limitation","name":"docs-known-limitation","color":"f7c6c7","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/18","html_url":"https://github.com/cockroachdb/cockroach/milestone/18","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/18/labels","id":3731318,"node_id":"MDk6TWlsZXN0b25lMzczMTMxOA==","number":18,"title":"2.1.x","description":"Things that need to get cherry-picked into the 2.1.x series.","creator":{"login":"knz","id":642886,"node_id":"MDQ6VXNlcjY0Mjg4Ng==","avatar_url":"https://avatars3.githubusercontent.com/u/642886?v=4","gravatar_id":"","url":"https://api.github.com/users/knz","html_url":"https://github.com/knz","followers_url":"https://api.github.com/users/knz/followers","following_url":"https://api.github.com/users/knz/following{/other_user}","gists_url":"https://api.github.com/users/knz/gists{/gist_id}","starred_url":"https://api.github.com/users/knz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/knz/subscriptions","organizations_url":"https://api.github.com/users/knz/orgs","repos_url":"https://api.github.com/users/knz/repos","events_url":"https://api.github.com/users/knz/events{/privacy}","received_events_url":"https://api.github.com/users/knz/received_events","type":"User","site_admin":false},"open_issues":15,"closed_issues":6,"state":"open","created_at":"2018-10-11T18:50:12Z","updated_at":"2018-10-30T18:35:28Z","due_on":"2018-12-01T08:00:00Z","closed_at":null},"comments":3,"created_at":"2018-10-23T20:20:16Z","updated_at":"2018-10-31T19:37:24Z","closed_at":null,"author_association":"MEMBER","body":"Connect to a server with an application_name URL parameter, such as `cockroach sql --url=\"postgresql://root@localhost:26257?sslmode=disable&application_name=foo\"`\r\n\r\nInside the session, `SHOW application_name` will show the value from the URL, but all statements run by the session will be recorded in `crdb_internal.node_statement_stats` (and therefore in the web UI) with an empty `application_name`. If the application name is set during the session with `SET application_name=`, everything works as expected. It appears that there's some hook that is run when the SET command executes that's not present when the setting is changed at connection init time.\r\n\r\nFrom https://forum.cockroachlabs.com/t/application-name-query-parameter-is-not-affecting-statements-ui-page/2102"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/434820151","html_url":"https://github.com/cockroachdb/cockroach/issues/31766#issuecomment-434820151","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31766","id":434820151,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNDgyMDE1MQ==","user":{"login":"mjibson","id":41181,"node_id":"MDQ6VXNlcjQxMTgx","avatar_url":"https://avatars1.githubusercontent.com/u/41181?v=4","gravatar_id":"","url":"https://api.github.com/users/mjibson","html_url":"https://github.com/mjibson","followers_url":"https://api.github.com/users/mjibson/followers","following_url":"https://api.github.com/users/mjibson/following{/other_user}","gists_url":"https://api.github.com/users/mjibson/gists{/gist_id}","starred_url":"https://api.github.com/users/mjibson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjibson/subscriptions","organizations_url":"https://api.github.com/users/mjibson/orgs","repos_url":"https://api.github.com/users/mjibson/repos","events_url":"https://api.github.com/users/mjibson/events{/privacy}","received_events_url":"https://api.github.com/users/mjibson/received_events","type":"User","site_admin":false},"created_at":"2018-10-31T19:37:24Z","updated_at":"2018-10-31T19:37:24Z","author_association":"MEMBER","body":"Ah yes. I didn't know we only supported it via `SET`, so what I told you was probably wrong. It appears we just do the wrong thing and maybe the driver is fine."}}
{"actor":{"display_login":"mjibson"}}