]> granicus.if.org Git - pgbouncer/log
pgbouncer
14 years ago<usual/signal.h>
Marko Kreen [Mon, 11 Jan 2010 17:10:19 +0000 (19:10 +0200)]
<usual/signal.h>

14 years ago<usual/event.h>
Marko Kreen [Mon, 11 Jan 2010 17:05:14 +0000 (19:05 +0200)]
<usual/event.h>

14 years ago<usual/mbuf.h>
Marko Kreen [Mon, 11 Jan 2010 16:50:39 +0000 (18:50 +0200)]
<usual/mbuf.h>

14 years ago<usual/fileutil.h>
Marko Kreen [Mon, 11 Jan 2010 06:11:02 +0000 (08:11 +0200)]
<usual/fileutil.h>

14 years ago<usual/safeio.h>
Marko Kreen [Mon, 11 Jan 2010 06:08:30 +0000 (08:08 +0200)]
<usual/safeio.h>

14 years ago<usual/socket.h>
Marko Kreen [Mon, 11 Jan 2010 06:07:30 +0000 (08:07 +0200)]
<usual/socket.h>

14 years ago<usual/slab.h>
Marko Kreen [Mon, 11 Jan 2010 05:59:41 +0000 (07:59 +0200)]
<usual/slab.h>

14 years ago<usual/lookup3.h>
Marko Kreen [Mon, 11 Jan 2010 05:50:20 +0000 (07:50 +0200)]
<usual/lookup3.h>

14 years ago<usual/aatree.h>
Marko Kreen [Mon, 11 Jan 2010 05:47:58 +0000 (07:47 +0200)]
<usual/aatree.h>

14 years ago<usual/string.h>
Marko Kreen [Mon, 11 Jan 2010 05:45:07 +0000 (07:45 +0200)]
<usual/string.h>

14 years ago<usual/logging.h>
Marko Kreen [Mon, 11 Jan 2010 05:44:16 +0000 (07:44 +0200)]
<usual/logging.h>

14 years ago<usual/string.h>
Marko Kreen [Mon, 11 Jan 2010 05:37:05 +0000 (07:37 +0200)]
<usual/string.h>

14 years ago<usual/list.h>, <usual/statlist.h>
Marko Kreen [Mon, 11 Jan 2010 05:27:09 +0000 (07:27 +0200)]
<usual/list.h>, <usual/statlist.h>

14 years ago<usual/time.h>
Marko Kreen [Mon, 11 Jan 2010 05:01:41 +0000 (07:01 +0200)]
<usual/time.h>

14 years agolibusual: include into build system
Marko Kreen [Mon, 11 Jan 2010 04:55:44 +0000 (06:55 +0200)]
libusual: include into build system

14 years agoForgot to change second listen() call also to cf_listen_backlog.
Marko Kreen [Tue, 4 May 2010 10:33:12 +0000 (10:33 +0000)]
Forgot to change second listen() call also to cf_listen_backlog.

14 years agov1.3.3rc1
Marko Kreen [Fri, 23 Apr 2010 14:44:54 +0000 (14:44 +0000)]
v1.3.3rc1

14 years agoNow actually improve few disconnect messages.
Marko Kreen [Fri, 23 Apr 2010 13:51:48 +0000 (13:51 +0000)]
Now actually improve few disconnect messages.

14 years agoLet disconnect_server/client() take printf style args.
Marko Kreen [Fri, 23 Apr 2010 13:50:49 +0000 (13:50 +0000)]
Let disconnect_server/client() take printf style args.

14 years agogcc braindamage: -Wformat-security is not turned on by -Wall -Wextra -Wformat
Marko Kreen [Fri, 23 Apr 2010 13:49:43 +0000 (13:49 +0000)]
gcc braindamage: -Wformat-security is not turned on by -Wall -Wextra -Wformat

14 years agoIncrease size of various startup-related buffers.
Marko Kreen [Fri, 23 Apr 2010 13:48:13 +0000 (13:48 +0000)]
Increase size of various startup-related buffers.

Also bring them under single define.

14 years agoMake listen(2) backlog argument configurable.
Marko Kreen [Wed, 21 Apr 2010 10:08:57 +0000 (10:08 +0000)]
Make listen(2) backlog argument configurable.

14 years agoDont let logging change errno.
Marko Kreen [Mon, 19 Apr 2010 07:08:31 +0000 (07:08 +0000)]
Dont let logging change errno.

With badly configured logging and higher logging levels, the code can
see wrong errno from syscalls.  So always retore original errno when logging.

14 years agoIncrease room for DateStyle storage.
Marko Kreen [Mon, 19 Apr 2010 07:05:45 +0000 (07:05 +0000)]
Increase room for DateStyle storage.

If value is larger than buffer, it stays empty and libpq will drop connection.

14 years agoExplicitly detect V2 protocol request and close it with proper msg.
Marko Kreen [Wed, 14 Apr 2010 08:09:47 +0000 (08:09 +0000)]
Explicitly detect V2 protocol request and close it with proper msg.

14 years agoMove fast-fail relaunch logic around.
Marko Kreen [Wed, 14 Apr 2010 08:08:27 +0000 (08:08 +0000)]
Move fast-fail relaunch logic around.

Do it together with fast-fail disconnect.  When kept separately
it can launch even if there are no new clients coming.
This causes problem with permanently dead dbs/users, as the
retry will not stop if all clients are gone.

14 years agov1.3.2 pgbouncer_1_3_2
Marko Kreen [Mon, 15 Mar 2010 14:44:28 +0000 (14:44 +0000)]
v1.3.2

14 years agoLog pooler-sent errors as warnings not plain info, as they signify problems.
Marko Kreen [Mon, 15 Mar 2010 13:53:58 +0000 (13:53 +0000)]
Log pooler-sent errors as warnings not plain info, as they signify problems.

14 years agolog message: statement timeout -> query timeout, to match config var
Marko Kreen [Fri, 12 Feb 2010 19:13:07 +0000 (19:13 +0000)]
log message: statement timeout -> query timeout, to match config var

14 years agoDon't let clients queue in case no servers and connections fail.
Marko Kreen [Fri, 12 Feb 2010 19:09:02 +0000 (19:09 +0000)]
Don't let clients queue in case no servers and connections fail.

That allows to avoid unnecessary delays in hopeless situations.

14 years agoIntroduce a new configuration setting: query_wait_timeout
Marko Kreen [Fri, 12 Feb 2010 19:05:04 +0000 (19:05 +0000)]
Introduce a new configuration setting: query_wait_timeout

If a query spends more than query_wait_timeout seconds waiting
it is disconnected. This prevents unresponsive servers from
wasting resources.

Patch by Martin Pihlak

14 years agodoc/confix.txt: uncoonfuse newer asciidoc
Marko Kreen [Fri, 15 Jan 2010 16:39:25 +0000 (16:39 +0000)]
doc/confix.txt: uncoonfuse newer asciidoc

14 years agoCheck error from event_init() to eliminate warning on strict build
Marko Kreen [Wed, 13 Jan 2010 07:24:00 +0000 (07:24 +0000)]
Check error from event_init() to eliminate warning on strict build

14 years agoAdd new patches to NEWS
Marko Kreen [Tue, 12 Jan 2010 10:24:18 +0000 (10:24 +0000)]
Add new patches to NEWS

14 years agosbuf: track exact wait state to avoid double event_del()
Marko Kreen [Tue, 12 Jan 2010 10:19:31 +0000 (10:19 +0000)]
sbuf: track exact wait state to avoid double event_del()

14 years agoIn case of invalid state, show value in error msg
Marko Kreen [Tue, 12 Jan 2010 10:17:46 +0000 (10:17 +0000)]
In case of invalid state, show value in error msg

14 years agotest/test.ini: turn off query_timeout by default
Marko Kreen [Tue, 12 Jan 2010 10:16:36 +0000 (10:16 +0000)]
test/test.ini: turn off query_timeout by default

14 years agoprepare for 1.3.2rc1
Marko Kreen [Fri, 4 Dec 2009 11:19:34 +0000 (11:19 +0000)]
prepare for 1.3.2rc1

14 years agotodo update
Marko Kreen [Fri, 4 Dec 2009 11:15:18 +0000 (11:15 +0000)]
todo update

14 years agoApply client_login_timeout to clients waiting for welcome pkt
Marko Kreen [Fri, 4 Dec 2009 10:28:46 +0000 (10:28 +0000)]
Apply client_login_timeout to clients waiting for welcome pkt

Otherwise the clients stay waiting infinitely, unless there is query_timeout set.

This only applies for servers that have never been up.  If server has
been connected once, the query_timeout is only thing that kills clients,
as clients are let freely log in after first connect to server.

14 years agowin32: allow user to override service account
Marko Kreen [Fri, 13 Nov 2009 14:59:11 +0000 (14:59 +0000)]
win32: allow user to override service account

The automatic decision between Local System and Local Service
was not reliable enough.  And anyway, it's better to let user
pick proper account.

14 years agoClarify few login-related log messages
Marko Kreen [Fri, 13 Nov 2009 13:57:04 +0000 (13:57 +0000)]
Clarify few login-related log messages

14 years agoDisable maintenance during SUSPEND
Marko Kreen [Fri, 13 Nov 2009 13:55:59 +0000 (13:55 +0000)]
Disable maintenance during SUSPEND

Otherwise some timeout may activate and close connection
that is already reported to other side;

15 years agoconsole: fix string format in datarow packet
Marko Kreen [Mon, 28 Sep 2009 09:47:26 +0000 (09:47 +0000)]
console: fix string format in datarow packet

pgbouncer used to store strings with final '\0', which should not be there.

It was not noticed thus far as any C clients did not saw anything wrong.

Takeover code depends on them being zero-terminated, use a hack to make them so.

15 years agodoc/config.txt improvements
Marko Kreen [Tue, 21 Jul 2009 18:36:47 +0000 (18:36 +0000)]
doc/config.txt improvements

Patch by Greg Sabino Mullane, applied with minor modifications.

15 years agodoc/usage.txt improvements
Marko Kreen [Fri, 17 Jul 2009 15:47:50 +0000 (15:47 +0000)]
doc/usage.txt improvements

Patch by Greg Sabino Mullane, applied with minor modifications.

15 years agov1.3.1 pgbouncer_1_3_1
Marko Kreen [Mon, 6 Jul 2009 13:27:08 +0000 (13:27 +0000)]
v1.3.1

15 years agodocs: mention console behavious when auth_mode=any
Marko Kreen [Mon, 6 Jul 2009 13:26:40 +0000 (13:26 +0000)]
docs: mention console behavious when auth_mode=any

15 years agoWhen auth_mode=any, allow anybody in as admin.
Marko Kreen [Mon, 6 Jul 2009 13:10:11 +0000 (13:10 +0000)]
When auth_mode=any, allow anybody in as admin.

Because auth_mode=any does not store original username,
the usual username based checks (admin_users/stats_users)
do not work.

15 years agotodo: clarify
Marko Kreen [Fri, 26 Jun 2009 15:03:12 +0000 (15:03 +0000)]
todo: clarify

15 years agofaq/ssl: pgsql protocol patch was applied to stunnel 4.27
Marko Kreen [Fri, 26 Jun 2009 15:00:31 +0000 (15:00 +0000)]
faq/ssl: pgsql protocol patch was applied to stunnel 4.27

15 years agov1.3.1rc1 pgbouncer_1_3_1_rc1
Marko Kreen [Fri, 26 Jun 2009 11:28:14 +0000 (11:28 +0000)]
v1.3.1rc1

15 years agotodo update
Marko Kreen [Fri, 26 Jun 2009 10:25:52 +0000 (10:25 +0000)]
todo update

15 years agosbuf.c: Fix connection hang if sbuf_loopcnt is set.
Marko Kreen [Thu, 25 Jun 2009 14:18:56 +0000 (14:18 +0000)]
sbuf.c: Fix connection hang if sbuf_loopcnt is set.

If query or result length nearby of multiple of (pktlen*sbuf_loopcnt)
[10k by default], it could stay waiting for more data which will not
appear.

Fix it by resyncing and final processing before exiting loop.

15 years agousage.txt: Time units are microseconds, not milliseconds
Marko Kreen [Thu, 25 Jun 2009 14:14:29 +0000 (14:14 +0000)]
usage.txt: Time units are microseconds, not milliseconds

15 years agoadmin.c: mention SHOW STATS in help msg
Marko Kreen [Thu, 25 Jun 2009 14:12:44 +0000 (14:12 +0000)]
admin.c: mention SHOW STATS in help msg

15 years agoFix potential use of old connections after config change
Marko Kreen [Fri, 22 May 2009 14:39:09 +0000 (14:39 +0000)]
Fix potential use of old connections after config change

Despite detecting and tagging them for close on config change,
the closing happened only in long-term maintenance.  So there
was time where they could still be reused by clients.

Fix this by strict check in find_server()

15 years agoFixed adjustment of a WSAStartup position problem.
Hiroshi Saito [Wed, 6 May 2009 12:43:53 +0000 (12:43 +0000)]
Fixed adjustment of a WSAStartup position problem.
It happen the hostname problem in the service start.
Per report Sachin Srivastava. and, thanks suggestions of Marko.

15 years agoFixed the Service parameter path name problem.
Hiroshi Saito [Wed, 6 May 2009 07:41:13 +0000 (07:41 +0000)]
Fixed the Service parameter path name problem.
Per report from Sachin Srivastava.

15 years agoFix broken alignment in src/slab.c
Marko Kreen [Tue, 7 Apr 2009 09:31:41 +0000 (09:31 +0000)]
Fix broken alignment in src/slab.c

Alignment macro was buggy, thus resulting in bad alignment.
This means speed hit on x86, but may result in crashes
on arches which are strict on alignment, unless the macro
is pre-defined in OS headers.

No problems from the field have been reported, thus maybe
even the bad alignment happened to be aligned?

15 years agoSHOW DATABASES had wrong column count.
Marko Kreen [Thu, 12 Mar 2009 17:35:56 +0000 (17:35 +0000)]
SHOW DATABASES had wrong column count.

The new res_pool field was not mentioned in data rows.

15 years agoupdate docs and default config
Marko Kreen [Wed, 18 Feb 2009 13:50:09 +0000 (13:50 +0000)]
update docs and default config

15 years agorelease 1.3
Marko Kreen [Wed, 18 Feb 2009 13:17:56 +0000 (13:17 +0000)]
release 1.3

15 years agowin32: improve service description
Marko Kreen [Fri, 30 Jan 2009 19:42:03 +0000 (19:42 +0000)]
win32: improve service description

Hiroshi Saito

15 years agoApply ISC license clarification, bump copyright years.
Marko Kreen [Wed, 28 Jan 2009 11:37:45 +0000 (11:37 +0000)]
Apply ISC license clarification, bump copyright years.

Clarification:

  for f in */*.[ch]; do echo -e "%s;and distribute;and/or distribute;\nwq" | ed "$f"; done

Details at: http://en.wikipedia.org/wiki/ISC_licence

15 years agoduh, seems we did not include COPYRIGHT file in tgz
Marko Kreen [Wed, 28 Jan 2009 10:59:26 +0000 (10:59 +0000)]
duh, seems we did not include COPYRIGHT file in tgz

15 years agoREADME: mention reserve_pool feature pgbouncer_1_3_rc1
Marko Kreen [Fri, 16 Jan 2009 13:52:44 +0000 (13:52 +0000)]
README: mention reserve_pool feature

15 years agoadd missing win32 files to tgz
Marko Kreen [Fri, 16 Jan 2009 13:37:08 +0000 (13:37 +0000)]
add missing win32 files to tgz

15 years agoevent_loopbreak compat for libevent 1.3
Marko Kreen [Fri, 16 Jan 2009 13:36:21 +0000 (13:36 +0000)]
event_loopbreak compat for libevent 1.3

15 years agotag 1.3rc1
Marko Kreen [Fri, 16 Jan 2009 13:30:08 +0000 (13:30 +0000)]
tag 1.3rc1

15 years agoREADME: win32 info
Marko Kreen [Fri, 16 Jan 2009 13:28:29 +0000 (13:28 +0000)]
README: win32 info

15 years agodoc/Makefile: build also html for README
Marko Kreen [Fri, 16 Jan 2009 13:28:12 +0000 (13:28 +0000)]
doc/Makefile: build also html for README

15 years agoNEWS: expand autodb and win32 items
Marko Kreen [Fri, 16 Jan 2009 13:08:07 +0000 (13:08 +0000)]
NEWS: expand autodb and win32 items

15 years agowin32: make service_name alias for job_name
Marko Kreen [Fri, 16 Jan 2009 13:02:32 +0000 (13:02 +0000)]
win32: make service_name alias for job_name

15 years agowin32 todo
Marko Kreen [Fri, 16 Jan 2009 13:01:33 +0000 (13:01 +0000)]
win32 todo

15 years agoNEWS: mention event_del problem
Marko Kreen [Fri, 16 Jan 2009 12:39:25 +0000 (12:39 +0000)]
NEWS: mention event_del problem

15 years agoadd few overlooked contributors
Marko Kreen [Fri, 16 Jan 2009 12:37:56 +0000 (12:37 +0000)]
add few overlooked contributors

15 years agosbuf_close: dont retry event_del() if it fails, just proceed with cleanup.
Marko Kreen [Fri, 16 Jan 2009 12:18:24 +0000 (12:18 +0000)]
sbuf_close: dont retry event_del() if it fails, just proceed with cleanup.

The retry could have been bug in pgbouncer - although then the
question is that how to survive ENOMEM from event handlers that
may need allocation on event_del().

But this does not explain why it fails first time.  Seems there
is something funny going on in libevent.

15 years agowin32: simpler service handling, cleanups
Marko Kreen [Sat, 10 Jan 2009 18:54:16 +0000 (18:54 +0000)]
win32: simpler service handling, cleanups

- one pgbouncer instance per service, in-process
- read service name from config file

cleanups:

- use FormatMessage for strerror()
- error out on wide-char build
- tag stdout/err _IONBF, they seem fully buffered by default

15 years agosome more cleanups:
Marko Kreen [Sat, 10 Jan 2009 14:52:05 +0000 (14:52 +0000)]
some more cleanups:

- avoid NULL values for config variables
- cf_shutdown=2 means fast shutdown
- export cf_config_file

15 years agominor cleanups
Marko Kreen [Fri, 2 Jan 2009 13:23:56 +0000 (13:23 +0000)]
minor cleanups

- avoid use of non-const fmt string
- avoid duplicate def of sbuf_len

15 years agodraft news for 1.3
Marko Kreen [Fri, 2 Jan 2009 12:40:29 +0000 (12:40 +0000)]
draft news for 1.3

15 years agoReserve pool implementation.
Marko Kreen [Fri, 2 Jan 2009 10:54:47 +0000 (10:54 +0000)]
Reserve pool implementation.

Allow to increased pool size in case main pool size
cannot serve clients anymore.

This allows to continue use of small pool_size, which
smooths small peaks, while also handling large peaks.

(Eg, one bouncer server down, others need to handle load.)

15 years agocheck if connection was accepted before logging
Marko Kreen [Fri, 2 Jan 2009 10:45:36 +0000 (10:45 +0000)]
check if connection was accepted before logging

15 years agowin32: make asynctest compile again
Marko Kreen [Mon, 29 Dec 2008 15:57:55 +0000 (15:57 +0000)]
win32: make asynctest compile again

By Hiroshi Saito

15 years agowin32: add -A to def generation
Marko Kreen [Mon, 29 Dec 2008 14:33:57 +0000 (14:33 +0000)]
win32: add -A to def generation

15 years agowin32: no need for -subservice switch, instead use -q
Marko Kreen [Fri, 19 Dec 2008 12:18:29 +0000 (12:18 +0000)]
win32: no need for -subservice switch, instead use -q

15 years agodlltool seems to need --export-all-symbols to make .def file
Marko Kreen [Thu, 18 Dec 2008 00:21:56 +0000 (00:21 +0000)]
dlltool seems to need --export-all-symbols to make .def file

15 years agopgbevent: make g_module static var
Marko Kreen [Thu, 18 Dec 2008 00:16:14 +0000 (00:16 +0000)]
pgbevent: make g_module static var

15 years agowin32: more fixes
Marko Kreen [Sun, 7 Dec 2008 09:15:37 +0000 (09:15 +0000)]
win32: more fixes

- proper message id
- fix bugs in cmdline validation

15 years agolocatime weirdness wasnt windows specific...
Marko Kreen [Sat, 6 Dec 2008 23:33:27 +0000 (23:33 +0000)]
locatime weirdness wasnt windows specific...

15 years agowin32: tm_mon fix for localtime() (Hiroshi Saito)
Marko Kreen [Thu, 4 Dec 2008 16:27:05 +0000 (16:27 +0000)]
win32: tm_mon fix for localtime() (Hiroshi Saito)

15 years agowin32: rename support files
Marko Kreen [Thu, 4 Dec 2008 16:07:08 +0000 (16:07 +0000)]
win32: rename support files

15 years agowin32: more cleanups
Marko Kreen [Thu, 4 Dec 2008 15:34:23 +0000 (15:34 +0000)]
win32: more cleanups

- emulate fcntl instead using #ifdef
- getsockopt() and select() also need wrapping
- move syslog declarations into compat_win32.h

15 years agowin32: implement kill()
Marko Kreen [Thu, 4 Dec 2008 10:57:38 +0000 (10:57 +0000)]
win32: implement kill()

Patch by Hiroshi Saito, applied with some modifications.

15 years agowin32: implement sendmsg, move cmdline handling away from main.c
Marko Kreen [Thu, 4 Dec 2008 10:06:09 +0000 (10:06 +0000)]
win32: implement sendmsg, move cmdline handling away from main.c

15 years agowin32: fix locatime
Marko Kreen [Wed, 3 Dec 2008 11:41:44 +0000 (11:41 +0000)]
win32: fix locatime

15 years agowin32: errno fixes
Marko Kreen [Wed, 3 Dec 2008 11:34:28 +0000 (11:34 +0000)]
win32: errno fixes

- switch errors around to correspond to what gets returned
- somewhat working strerror()

15 years agowin32: more fixes
Marko Kreen [Wed, 3 Dec 2008 11:04:06 +0000 (11:04 +0000)]
win32: more fixes

- move socket errors back to errno
- don't call closesocket() on plain files

15 years agowin32: change name of eventmsg
Marko Kreen [Wed, 3 Dec 2008 11:02:20 +0000 (11:02 +0000)]
win32: change name of eventmsg