]> granicus.if.org Git - pgbouncer/log
pgbouncer
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

15 years agoremove the mc.exe detection, it not available anyway
Marko Kreen [Fri, 28 Nov 2008 08:31:21 +0000 (08:31 +0000)]
remove the mc.exe detection, it not available anyway

15 years agoQuick win32 fixes.
Marko Kreen [Wed, 26 Nov 2008 23:09:06 +0000 (23:09 +0000)]
Quick win32 fixes.

It not only compiles now, but even boots..

15 years agoremove unnecessary CVS ids, update AUTHORS
Marko Kreen [Mon, 24 Nov 2008 11:45:25 +0000 (11:45 +0000)]
remove unnecessary CVS ids, update AUTHORS

15 years agowin32 support (wip)
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

15 years agoMake crypt authentication optional.
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.

15 years agoDynamic database creation for non-defined databases.
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

15 years agoasynctest improvements
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

15 years agoadd milliseconds to log timestamps
Marko Kreen [Wed, 19 Nov 2008 12:10:50 +0000 (12:10 +0000)]
add milliseconds to log timestamps

15 years agoNew tunable 'sbuf_loopcnt' to limit time spent on one socket.
Marko Kreen [Wed, 19 Nov 2008 12:06:37 +0000 (12:06 +0000)]
New tunable 'sbuf_loopcnt' to limit time spent on one socket.

In some situations - eg SMP server, local Postgres and fast network -
pgbouncer can run recv()->send() loop many times without blocking
on either side.  But that means other connections will stall for
a long time.  To make processing more fair, limit the times
of doing recv()->send() one socket.  If count reaches limit,
just proceed processing other sockets.  The processing for
that socket will resume on next event loop.

Thanks to Alexander Schöcke for report and testing.

15 years agodebug: log connection endpoints
Marko Kreen [Wed, 19 Nov 2008 11:54:46 +0000 (11:54 +0000)]
debug: log connection endpoints

15 years agoChange default port number from 6000 to 6432.
Marko Kreen [Wed, 19 Nov 2008 11:51:23 +0000 (11:51 +0000)]
Change default port number from 6000 to 6432.

6000 is conflicts with X, 6432 seems free and is already used by Debian.

15 years agoquiet compiler warning about ptr->int conversion
Marko Kreen [Tue, 30 Sep 2008 10:17:13 +0000 (10:17 +0000)]
quiet compiler warning about ptr->int conversion

15 years agostop playing with -fomit-frame-pointer
Marko Kreen [Thu, 25 Sep 2008 10:25:59 +0000 (10:25 +0000)]
stop playing with -fomit-frame-pointer

15 years agoDefault to --enable-debug
Marko Kreen [Fri, 5 Sep 2008 11:02:08 +0000 (11:02 +0000)]
Default to --enable-debug

To get the old behaviour - stripped binary and -fomit-frame-pointer
in CFLAGS, --disable-debug must be used.

Allowing debugging by default seems saner.

15 years agoPut own includes at the startt of CPPFLAGS
Marko Kreen [Thu, 4 Sep 2008 13:02:13 +0000 (13:02 +0000)]
Put own includes at the startt of CPPFLAGS

Otherwise with --with-libevent=/usr wrong includes may be used.

Per report from Bjorn Munch

15 years agocompact md5 implementation
Marko Kreen [Fri, 22 Aug 2008 17:50:37 +0000 (17:50 +0000)]
compact md5 implementation

15 years agofull quoting for database names
Marko Kreen [Fri, 22 Aug 2008 17:22:30 +0000 (17:22 +0000)]
full quoting for database names

15 years agotag head as 1.3
Marko Kreen [Fri, 22 Aug 2008 14:28:02 +0000 (14:28 +0000)]
tag head as 1.3

16 years agoinclude userlist.txt in tgz pgbouncer_1_2_3
Marko Kreen [Fri, 8 Aug 2008 13:32:55 +0000 (13:32 +0000)]
include userlist.txt in tgz

16 years agodisable untested SO_ACCEPTFILTER code
Marko Kreen [Fri, 8 Aug 2008 13:26:43 +0000 (13:26 +0000)]
disable untested SO_ACCEPTFILTER code

16 years agov1.2.3
Marko Kreen [Fri, 8 Aug 2008 12:44:17 +0000 (12:44 +0000)]
v1.2.3

16 years agodetect stale pidfile
Marko Kreen [Fri, 8 Aug 2008 12:33:24 +0000 (12:33 +0000)]
detect stale pidfile

16 years agoadd Jørgen
Marko Kreen [Fri, 8 Aug 2008 11:28:16 +0000 (11:28 +0000)]
add Jørgen

16 years agoallow first libevent test pass on 1.1
Marko Kreen [Fri, 8 Aug 2008 11:16:20 +0000 (11:16 +0000)]
allow first libevent test pass on 1.1

16 years agoglibc requires use of _GNU_SOURCE
Marko Kreen [Fri, 8 Aug 2008 11:10:28 +0000 (11:10 +0000)]
glibc requires use of _GNU_SOURCE

16 years agoChange the makefile to use "$(MAKE)" instead of "make".
Marko Kreen [Fri, 8 Aug 2008 08:28:55 +0000 (08:28 +0000)]
Change the makefile to use "$(MAKE)" instead of "make".

Patch from Jørgen Austvik

16 years agoasynctest: remove note about splice() experiments pgbouncer_1_2_2
Marko Kreen [Wed, 6 Aug 2008 10:32:51 +0000 (10:32 +0000)]
asynctest: remove note about splice() experiments

16 years agotag 1.2.2
Marko Kreen [Wed, 6 Aug 2008 08:39:41 +0000 (08:39 +0000)]
tag 1.2.2

16 years agoRemove drop_on_error, it was a bad idea.
Marko Kreen [Wed, 6 Aug 2008 06:43:40 +0000 (06:43 +0000)]
Remove drop_on_error, it was a bad idea.

It was a workaround for broken plan-cache in Postgres,
but it's behviour for common case - some queries giving always errors -
is very nasty - it can drop all connections in pool.

16 years agoasynctest: check if result comes back ok
Marko Kreen [Wed, 6 Aug 2008 06:31:42 +0000 (06:31 +0000)]
asynctest: check if result comes back ok

16 years agomention log msg cleanup
Marko Kreen [Mon, 4 Aug 2008 11:55:52 +0000 (11:55 +0000)]
mention log msg cleanup

16 years agov1.2.1
Marko Kreen [Mon, 4 Aug 2008 11:46:38 +0000 (11:46 +0000)]
v1.2.1

16 years agowording cleanup for drop_on_error
Marko Kreen [Mon, 4 Aug 2008 11:45:44 +0000 (11:45 +0000)]
wording cleanup for drop_on_error

16 years agocancel shutdown on resume
Marko Kreen [Mon, 4 Aug 2008 11:08:23 +0000 (11:08 +0000)]
cancel shutdown on resume

otherwise admin gets bad surprise on next pause

16 years agoexit immediately on SIGINT if suspend was in progress
Marko Kreen [Mon, 4 Aug 2008 10:58:26 +0000 (10:58 +0000)]
exit immediately on SIGINT if suspend was in progress

16 years agosuspend_socket_list can drop sockets, so needs _safe
Marko Kreen [Mon, 4 Aug 2008 10:51:06 +0000 (10:51 +0000)]
suspend_socket_list can drop sockets, so needs _safe

16 years agoproper log message for console client cancel
Marko Kreen [Mon, 4 Aug 2008 08:56:53 +0000 (08:56 +0000)]
proper log message for console client cancel

16 years agocleaner socket_row()
Marko Kreen [Mon, 4 Aug 2008 08:44:48 +0000 (08:44 +0000)]
cleaner socket_row()

16 years agosys/uio.h is required for struct iover on some systems
Marko Kreen [Fri, 1 Aug 2008 17:25:32 +0000 (17:25 +0000)]
sys/uio.h is required for struct iover on some systems

(eg. DragonFly)

16 years agolog if drop_on_error triggers
Marko Kreen [Fri, 1 Aug 2008 17:20:24 +0000 (17:20 +0000)]
log if drop_on_error triggers

16 years agoadmin.c: dont crash if socket has no buffer
Marko Kreen [Fri, 1 Aug 2008 12:51:54 +0000 (12:51 +0000)]
admin.c: dont crash if socket has no buffer

16 years agochange ver to 1.2.1
Marko Kreen [Fri, 1 Aug 2008 10:10:48 +0000 (10:10 +0000)]
change ver to 1.2.1

16 years agonew drop_on_error param
Marko Kreen [Fri, 1 Aug 2008 10:10:11 +0000 (10:10 +0000)]
new drop_on_error param

16 years agorelease 1.2 pgbouncer_1_2
Marko Kreen [Tue, 29 Jul 2008 11:23:31 +0000 (11:23 +0000)]
release 1.2

16 years agotest/Makefile: add DEFS to cflags
Marko Kreen [Mon, 21 Jul 2008 11:33:13 +0000 (11:33 +0000)]
test/Makefile: add DEFS to cflags

16 years agotag 1.2rc2 pgbouncer_1_2_rc2
Marko Kreen [Wed, 16 Jul 2008 14:37:39 +0000 (14:37 +0000)]
tag 1.2rc2

16 years agotest: increase allowed conns, decrease buffer len
Marko Kreen [Wed, 16 Jul 2008 14:35:53 +0000 (14:35 +0000)]
test: increase allowed conns, decrease buffer len

16 years agofew doc cleanups
Marko Kreen [Wed, 16 Jul 2008 14:34:23 +0000 (14:34 +0000)]
few doc cleanups

16 years agoFurther memory conservation by making state bitfield :8.
Marko Kreen [Wed, 16 Jul 2008 14:26:47 +0000 (14:26 +0000)]
Further memory conservation by making state bitfield :8.

Does this need #ifdef __GCC__?

16 years agolog proper reason for disconnect
Marko Kreen [Wed, 9 Jul 2008 16:27:24 +0000 (16:27 +0000)]
log proper reason for disconnect

16 years agoremove extra argument for SBuf callback
Marko Kreen [Tue, 8 Jul 2008 20:01:56 +0000 (20:01 +0000)]
remove extra argument for SBuf callback

conserves memory and conforms more with general coding style.

plus few cleanups

16 years agodont waste room for storing login-time salt.
Marko Kreen [Thu, 3 Jul 2008 13:07:28 +0000 (13:07 +0000)]
dont waste room for storing login-time salt.

Instead store it in cancel_key[], as it is used
only once, before generating the cancel_key.

16 years agodecrease noise from bad connections
Marko Kreen [Thu, 3 Jul 2008 13:01:19 +0000 (13:01 +0000)]
decrease noise from bad connections

the accepting new connection does not need to stop if bad one appears.

16 years agokeep mtime in tgz
Marko Kreen [Fri, 27 Jun 2008 10:34:18 +0000 (10:34 +0000)]
keep mtime in tgz

16 years agoduplicate tagline
Marko Kreen [Fri, 27 Jun 2008 10:33:56 +0000 (10:33 +0000)]
duplicate tagline

16 years agorequire libevent >= 1.3b
Marko Kreen [Thu, 26 Jun 2008 14:51:03 +0000 (14:51 +0000)]
require libevent >= 1.3b