payload: {"action":"created","issue":{"url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/1921","repository_url":"https://api.github.com/repos/YugaByte/yugabyte-db","labels_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/1921/labels{/name}","comments_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/1921/comments","events_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/1921/events","html_url":"https://github.com/YugaByte/yugabyte-db/issues/1921","id":473894521,"node_id":"MDU6SXNzdWU0NzM4OTQ1MjE=","number":1921,"title":"FATAL:  sorry, too many clients already; where can I change the properties about maxconnections?","user":{"login":"halleyshx","id":24284940,"node_id":"MDQ6VXNlcjI0Mjg0OTQw","avatar_url":"https://avatars3.githubusercontent.com/u/24284940?v=4","gravatar_id":"","url":"https://api.github.com/users/halleyshx","html_url":"https://github.com/halleyshx","followers_url":"https://api.github.com/users/halleyshx/followers","following_url":"https://api.github.com/users/halleyshx/following{/other_user}","gists_url":"https://api.github.com/users/halleyshx/gists{/gist_id}","starred_url":"https://api.github.com/users/halleyshx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/halleyshx/subscriptions","organizations_url":"https://api.github.com/users/halleyshx/orgs","repos_url":"https://api.github.com/users/halleyshx/repos","events_url":"https://api.github.com/users/halleyshx/events{/privacy}","received_events_url":"https://api.github.com/users/halleyshx/received_events","type":"User","site_admin":false},"labels":[{"id":1454132133,"node_id":"MDU6TGFiZWwxNDU0MTMyMTMz","url":"https://api.github.com/repos/YugaByte/yugabyte-db/labels/community/request","name":"community/request","color":"dabbf7","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2019-07-29T07:30:00Z","updated_at":"2019-07-29T09:19:03Z","closed_at":null,"author_association":"NONE","body":"I test the performance by sqlinsert (312 threads) of yb-sample-apps. When I run the test command,there are some error like this and incessancy:\r\n\r\n> Jul 29, 2019 3:15:34 PM org.postgresql.Driver connect\r\n> SEVERE: Connection error:\r\n> org.postgresql.util.PSQLException: FATAL: sorry, too many clients already\r\n> \tat org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:473)\r\n> \tat org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205)\r\n> \tat org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)\r\n> \tat org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)\r\n> \tat org.postgresql.Driver.makeConnection(Driver.java:452)\r\n> \tat org.postgresql.Driver.connect(Driver.java:254)\r\n> \tat java.sql.DriverManager.getConnection(DriverManager.java:664)\r\n> \tat java.sql.DriverManager.getConnection(DriverManager.java:208)\r\n> \tat com.yugabyte.sample.apps.AppBase.getPostgresConnection(AppBase.java:139)\r\n> \tat com.yugabyte.sample.apps.AppBase.getPostgresConnection(AppBase.java:127)\r\n> \tat com.yugabyte.sample.apps.SqlInserts.getPreparedInsert(SqlInserts.java:137)\r\n> \tat com.yugabyte.sample.apps.SqlInserts.doWrite(SqlInserts.java:152)\r\n> \tat com.yugabyte.sample.apps.AppBase.performWrite(AppBase.java:626)\r\n> \tat com.yugabyte.sample.common.IOPSThread.run(IOPSThread.java:87)\r\n> \r\n> 3372901 [Thread-342] FATAL com.yugabyte.sample.apps.SqlInserts  - Failed writing key: key:12840905\r\n> org.postgresql.util.PSQLException: FATAL: sorry, too many clients already\r\n> \tat org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:473)\r\n> \tat org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205)\r\n> \tat org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)\r\n> \tat org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)\r\n> \tat org.postgresql.Driver.makeConnection(Driver.java:452)\r\n> \tat org.postgresql.Driver.connect(Driver.java:254)\r\n> \tat java.sql.DriverManager.getConnection(DriverManager.java:664)\r\n> \tat java.sql.DriverManager.getConnection(DriverManager.java:208)\r\n> \tat com.yugabyte.sample.apps.AppBase.getPostgresConnection(AppBase.java:139)\r\n> \tat com.yugabyte.sample.apps.AppBase.getPostgresConnection(AppBase.java:127)\r\n> \tat com.yugabyte.sample.apps.SqlInserts.getPreparedInsert(SqlInserts.java:137)\r\n> \tat com.yugabyte.sample.apps.SqlInserts.doWrite(SqlInserts.java:152)\r\n> \tat com.yugabyte.sample.apps.AppBase.performWrite(AppBase.java:626)\r\n> \tat com.yugabyte.sample.common.IOPSThread.run(IOPSThread.java:87)\r\n> 3365454 [Thread-73] FATAL com.yugabyte.sample.apps.SqlInserts  - Failed writing key: key:7868995\r\n> org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"postgresqlkeyvalue_pkey\"\r\n> \tat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)\r\n> \tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)\r\n> \tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)\r\n> \tat org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)\r\n> \tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)\r\n> \tat org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)\r\n> \tat org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)\r\n> \tat com.yugabyte.sample.apps.SqlInserts.doWrite(SqlInserts.java:156)\r\n> \tat com.yugabyte.sample.apps.AppBase.performWrite(AppBase.java:626)\r\n> \tat com.yugabyte.sample.common.IOPSThread.run(IOPSThread.java:87)\r\n> Jul 29, 2019 3:15:34 PM org.postgresql.core.v3.ConnectionFactoryImpl log\r\n> WARNING: SQLException occurred while connecting to 10.xxx.xxx.9:5433\r\n> org.postgresql.util.PSQLException: FATAL: sorry, too many clients already\r\n> \tat org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:473)\r\n> \tat org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205)\r\n> \tat org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)\r\n> \tat org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)\r\n> \tat org.postgresql.Driver.makeConnection(Driver.java:452)\r\n> \tat org.postgresql.Driver.connect(Driver.java:254)\r\n> \tat java.sql.DriverManager.getConnection(DriverManager.java:664)\r\n> \tat java.sql.DriverManager.getConnection(DriverManager.java:208)\r\n> \tat com.yugabyte.sample.apps.AppBase.getPostgresConnection(AppBase.java:139)\r\n> \tat com.yugabyte.sample.apps.AppBase.getPostgresConnection(AppBase.java:127)\r\n> \tat com.yugabyte.sample.apps.SqlInserts.getPreparedInsert(SqlInserts.java:137)\r\n> \tat com.yugabyte.sample.apps.SqlInserts.doWrite(SqlInserts.java:152)\r\n> \tat com.yugabyte.sample.apps.AppBase.performWrite(AppBase.java:626)\r\n> \tat com.yugabyte.sample.common.IOPSThread.run(IOPSThread.java:87)\r\n\r\nThen I run ysqlsh,the same error like this:\r\n`# /export/App/yugabyte-1.3.0.0/bin/ysqlsh -h 10.xxx.xxx.9 -e`\r\n\r\n> ysqlsh: FATAL:  sorry, too many clients already"},"comment":{"url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/comments/515914538","html_url":"https://github.com/YugaByte/yugabyte-db/issues/1921#issuecomment-515914538","issue_url":"https://api.github.com/repos/YugaByte/yugabyte-db/issues/1921","id":515914538,"node_id":"MDEyOklzc3VlQ29tbWVudDUxNTkxNDUzOA==","user":{"login":"d-uspenskiy","id":47734295,"node_id":"MDQ6VXNlcjQ3NzM0Mjk1","avatar_url":"https://avatars3.githubusercontent.com/u/47734295?v=4","gravatar_id":"","url":"https://api.github.com/users/d-uspenskiy","html_url":"https://github.com/d-uspenskiy","followers_url":"https://api.github.com/users/d-uspenskiy/followers","following_url":"https://api.github.com/users/d-uspenskiy/following{/other_user}","gists_url":"https://api.github.com/users/d-uspenskiy/gists{/gist_id}","starred_url":"https://api.github.com/users/d-uspenskiy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/d-uspenskiy/subscriptions","organizations_url":"https://api.github.com/users/d-uspenskiy/orgs","repos_url":"https://api.github.com/users/d-uspenskiy/repos","events_url":"https://api.github.com/users/d-uspenskiy/events{/privacy}","received_events_url":"https://api.github.com/users/d-uspenskiy/received_events","type":"User","site_admin":false},"created_at":"2019-07-29T09:19:03Z","updated_at":"2019-07-29T09:19:03Z","author_association":"CONTRIBUTOR","body":"@halleyshx "}}
other: {"actor":{"display_login":"d-uspenskiy"}}