]>
granicus.if.org Git - pgbouncer/log
Marko Kreen [Mon, 11 Jan 2010 05:50:20 +0000 (07:50 +0200)]
<usual/lookup3.h>
Marko Kreen [Mon, 11 Jan 2010 05:47:58 +0000 (07:47 +0200)]
<usual/aatree.h>
Marko Kreen [Mon, 11 Jan 2010 05:45:07 +0000 (07:45 +0200)]
<usual/string.h>
Marko Kreen [Mon, 11 Jan 2010 05:44:16 +0000 (07:44 +0200)]
<usual/logging.h>
Marko Kreen [Mon, 11 Jan 2010 05:37:05 +0000 (07:37 +0200)]
<usual/string.h>
Marko Kreen [Mon, 11 Jan 2010 05:27:09 +0000 (07:27 +0200)]
<usual/list.h>, <usual/statlist.h>
Marko Kreen [Mon, 11 Jan 2010 05:01:41 +0000 (07:01 +0200)]
<usual/time.h>
Marko Kreen [Mon, 11 Jan 2010 04:55:44 +0000 (06:55 +0200)]
libusual: include into build system
Marko Kreen [Tue, 4 May 2010 10:33:12 +0000 (10:33 +0000)]
Forgot to change second listen() call also to cf_listen_backlog.
Marko Kreen [Fri, 23 Apr 2010 14:44:54 +0000 (14:44 +0000)]
v1.3.3rc1
Marko Kreen [Fri, 23 Apr 2010 13:51:48 +0000 (13:51 +0000)]
Now actually improve few disconnect messages.
Marko Kreen [Fri, 23 Apr 2010 13:50:49 +0000 (13:50 +0000)]
Let disconnect_server/client() take printf style args.
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
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.
Marko Kreen [Wed, 21 Apr 2010 10:08:57 +0000 (10:08 +0000)]
Make listen(2) backlog argument configurable.
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.
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.
Marko Kreen [Wed, 14 Apr 2010 08:09:47 +0000 (08:09 +0000)]
Explicitly detect V2 protocol request and close it with proper msg.
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.
Marko Kreen [Mon, 15 Mar 2010 14:44:28 +0000 (14:44 +0000)]
v1.3.2
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.
Marko Kreen [Fri, 12 Feb 2010 19:13:07 +0000 (19:13 +0000)]
log message: statement timeout -> query timeout, to match config var
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.
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
Marko Kreen [Fri, 15 Jan 2010 16:39:25 +0000 (16:39 +0000)]
doc/confix.txt: uncoonfuse newer asciidoc
Marko Kreen [Wed, 13 Jan 2010 07:24:00 +0000 (07:24 +0000)]
Check error from event_init() to eliminate warning on strict build
Marko Kreen [Tue, 12 Jan 2010 10:24:18 +0000 (10:24 +0000)]
Add new patches to NEWS
Marko Kreen [Tue, 12 Jan 2010 10:19:31 +0000 (10:19 +0000)]
sbuf: track exact wait state to avoid double event_del()
Marko Kreen [Tue, 12 Jan 2010 10:17:46 +0000 (10:17 +0000)]
In case of invalid state, show value in error msg
Marko Kreen [Tue, 12 Jan 2010 10:16:36 +0000 (10:16 +0000)]
test/test.ini: turn off query_timeout by default
Marko Kreen [Fri, 4 Dec 2009 11:19:34 +0000 (11:19 +0000)]
prepare for 1.3.2rc1
Marko Kreen [Fri, 4 Dec 2009 11:15:18 +0000 (11:15 +0000)]
todo update
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.
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.
Marko Kreen [Fri, 13 Nov 2009 13:57:04 +0000 (13:57 +0000)]
Clarify few login-related log messages
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;
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.
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.
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.
Marko Kreen [Mon, 6 Jul 2009 13:27:08 +0000 (13:27 +0000)]
v1.3.1
Marko Kreen [Mon, 6 Jul 2009 13:26:40 +0000 (13:26 +0000)]
docs: mention console behavious when auth_mode=any
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.
Marko Kreen [Fri, 26 Jun 2009 15:03:12 +0000 (15:03 +0000)]
todo: clarify
Marko Kreen [Fri, 26 Jun 2009 15:00:31 +0000 (15:00 +0000)]
faq/ssl: pgsql protocol patch was applied to stunnel 4.27
Marko Kreen [Fri, 26 Jun 2009 11:28:14 +0000 (11:28 +0000)]
v1.3.1rc1
Marko Kreen [Fri, 26 Jun 2009 10:25:52 +0000 (10:25 +0000)]
todo update
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.
Marko Kreen [Thu, 25 Jun 2009 14:14:29 +0000 (14:14 +0000)]
usage.txt: Time units are microseconds, not milliseconds
Marko Kreen [Thu, 25 Jun 2009 14:12:44 +0000 (14:12 +0000)]
admin.c: mention SHOW STATS in help msg
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()
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.
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.
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?
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.
Marko Kreen [Wed, 18 Feb 2009 13:50:09 +0000 (13:50 +0000)]
update docs and default config
Marko Kreen [Wed, 18 Feb 2009 13:17:56 +0000 (13:17 +0000)]
release 1.3
Marko Kreen [Fri, 30 Jan 2009 19:42:03 +0000 (19:42 +0000)]
win32: improve service description
Hiroshi Saito
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
Marko Kreen [Wed, 28 Jan 2009 10:59:26 +0000 (10:59 +0000)]
duh, seems we did not include COPYRIGHT file in tgz
Marko Kreen [Fri, 16 Jan 2009 13:52:44 +0000 (13:52 +0000)]
README: mention reserve_pool feature
Marko Kreen [Fri, 16 Jan 2009 13:37:08 +0000 (13:37 +0000)]
add missing win32 files to tgz
Marko Kreen [Fri, 16 Jan 2009 13:36:21 +0000 (13:36 +0000)]
event_loopbreak compat for libevent 1.3
Marko Kreen [Fri, 16 Jan 2009 13:30:08 +0000 (13:30 +0000)]
tag 1.3rc1
Marko Kreen [Fri, 16 Jan 2009 13:28:29 +0000 (13:28 +0000)]
README: win32 info
Marko Kreen [Fri, 16 Jan 2009 13:28:12 +0000 (13:28 +0000)]
doc/Makefile: build also html for README
Marko Kreen [Fri, 16 Jan 2009 13:08:07 +0000 (13:08 +0000)]
NEWS: expand autodb and win32 items
Marko Kreen [Fri, 16 Jan 2009 13:02:32 +0000 (13:02 +0000)]
win32: make service_name alias for job_name
Marko Kreen [Fri, 16 Jan 2009 13:01:33 +0000 (13:01 +0000)]
win32 todo
Marko Kreen [Fri, 16 Jan 2009 12:39:25 +0000 (12:39 +0000)]
NEWS: mention event_del problem
Marko Kreen [Fri, 16 Jan 2009 12:37:56 +0000 (12:37 +0000)]
add few overlooked contributors
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.
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
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
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
Marko Kreen [Fri, 2 Jan 2009 12:40:29 +0000 (12:40 +0000)]
draft news for 1.3
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.)
Marko Kreen [Fri, 2 Jan 2009 10:45:36 +0000 (10:45 +0000)]
check if connection was accepted before logging
Marko Kreen [Mon, 29 Dec 2008 15:57:55 +0000 (15:57 +0000)]
win32: make asynctest compile again
By Hiroshi Saito
Marko Kreen [Mon, 29 Dec 2008 14:33:57 +0000 (14:33 +0000)]
win32: add -A to def generation
Marko Kreen [Fri, 19 Dec 2008 12:18:29 +0000 (12:18 +0000)]
win32: no need for -subservice switch, instead use -q
Marko Kreen [Thu, 18 Dec 2008 00:21:56 +0000 (00:21 +0000)]
dlltool seems to need --export-all-symbols to make .def file
Marko Kreen [Thu, 18 Dec 2008 00:16:14 +0000 (00:16 +0000)]
pgbevent: make g_module static var
Marko Kreen [Sun, 7 Dec 2008 09:15:37 +0000 (09:15 +0000)]
win32: more fixes
- proper message id
- fix bugs in cmdline validation
Marko Kreen [Sat, 6 Dec 2008 23:33:27 +0000 (23:33 +0000)]
locatime weirdness wasnt windows specific...
Marko Kreen [Thu, 4 Dec 2008 16:27:05 +0000 (16:27 +0000)]
win32: tm_mon fix for localtime() (Hiroshi Saito)
Marko Kreen [Thu, 4 Dec 2008 16:07:08 +0000 (16:07 +0000)]
win32: rename support files
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
Marko Kreen [Thu, 4 Dec 2008 10:57:38 +0000 (10:57 +0000)]
win32: implement kill()
Patch by Hiroshi Saito, applied with some modifications.
Marko Kreen [Thu, 4 Dec 2008 10:06:09 +0000 (10:06 +0000)]
win32: implement sendmsg, move cmdline handling away from main.c
Marko Kreen [Wed, 3 Dec 2008 11:41:44 +0000 (11:41 +0000)]
win32: fix locatime
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()
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
Marko Kreen [Wed, 3 Dec 2008 11:02:20 +0000 (11:02 +0000)]
win32: change name of eventmsg
Marko Kreen [Fri, 28 Nov 2008 08:31:21 +0000 (08:31 +0000)]
remove the mc.exe detection, it not available anyway
Marko Kreen [Wed, 26 Nov 2008 23:09:06 +0000 (23:09 +0000)]
Quick win32 fixes.
It not only compiles now, but even boots..
Marko Kreen [Mon, 24 Nov 2008 11:45:25 +0000 (11:45 +0000)]
remove unnecessary CVS ids, update AUTHORS
Marko Kreen [Mon, 24 Nov 2008 11:31:46 +0000 (11:31 +0000)]
win32 support (wip)
Original patch by Hiroshi Saito, applied with some cleanup
Marko Kreen [Sat, 22 Nov 2008 09:41:32 +0000 (09:41 +0000)]
Make crypt authentication optional.
It was removed from PostgreSQL 8.4 sources.
Marko Kreen [Wed, 19 Nov 2008 12:50:05 +0000 (12:50 +0000)]
Dynamic database creation for non-defined databases.
Activated by "*" entry in [databases] section.
Patch by David Galoyan
Marko Kreen [Wed, 19 Nov 2008 12:16:15 +0000 (12:16 +0000)]
asynctest improvements
- add $(LIBS) to link line
- allow custom query
- define fatal_noexit() for CASSERT builds