|
Pgbouncer. Prepared statement already exists
|
|||
---|---|---|---|
#18+
Pgbouncer version 1.7.2 PostgreSQL version 9.5.6 авторcat pgbouncer.ini | grep -v ";" | grep -v "^$" [databases] *= host=127.0.0.1 port=5432 auth_user=postgres [pgbouncer] logfile = /var/log/pgbouncer/pgbouncer.log pidfile = /var/run/pgbouncer/pgbouncer.pid listen_addr = * listen_port = 6432 #auth_type = plain #auth_hba_file = /etc/pgbouncer/auth_file auth_query = SELECT usename, passwd FROM pg_shadow WHERE usename=$1 admin_users = postgres stats_users = stats, postgres pool_mode = transaction server_reset_query = ROLLBACK; SELECT pg_advisory_unlock_all(); DISCARD ALL; ignore_startup_parameters = extra_float_digits max_client_conn = 100 default_pool_size = 100 авторtail -fn10 /var/lib/pgsql/9.5/data/pg_log/postgresql-Thu.log ERROR: prepared statement "S_1" already exists STATEMENT: ROLLBACK ERROR: prepared statement "S_2" already exists STATEMENT: ROLLBACK FATAL: role "root" does not exist Application - Java в Tomcat. Скажите пожалуйста поправить конфиг чтобы PostgreSQL не ругался repared statement "S_1" already exists ? ... |
|||
:
Нравится:
Не нравится:
|
|||
20.04.2017, 14:00 |
|
Pgbouncer. Prepared statement already exists
|
|||
---|---|---|---|
#18+
Malatus, Вам JAVA (jdbc) настраивать надо а не базу или pgbouncer как написано в https://pgbouncer.github.io/faq.html (The proper way to do it for JDBC is adding prepareThreshold=0 parameter to connect string.) -- Maxim Boguk dataegret.ru ... |
|||
:
Нравится:
Не нравится:
|
|||
20.04.2017, 14:08 |
|
Pgbouncer. Prepared statement already exists
|
|||
---|---|---|---|
#18+
Malatus, авторpool_mode = transaction Не может использоваться с prepared statements. https://pgbouncer.github.io/faq.html в faq pgbouncer'а описано как их отключить в php/pdo и jdbc или что поправить для работы режима пула сессий. ... |
|||
:
Нравится:
Не нравится:
|
|||
20.04.2017, 14:09 |
|
|
start [/forum/topic.php?fid=53&fpage=75&tid=1996573]: |
0ms |
get settings: |
8ms |
get forum list: |
15ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
31ms |
get topic data: |
13ms |
get forum data: |
3ms |
get page messages: |
46ms |
get tp. blocked users: |
2ms |
others: | 16ms |
total: | 140ms |
0 / 0 |