]> granicus.if.org Git - pgbouncer/log
pgbouncer
17 years agotodo update
Marko Kreen [Fri, 7 Sep 2007 13:07:13 +0000 (13:07 +0000)]
todo update

17 years agohack to use [,] in regex
Marko Kreen [Fri, 7 Sep 2007 12:40:15 +0000 (12:40 +0000)]
hack to use [,] in regex

17 years agodont close logfile on first load
Marko Kreen [Fri, 7 Sep 2007 12:25:26 +0000 (12:25 +0000)]
dont close logfile on first load

17 years agocode still tried to close fd, fix and clean up
Marko Kreen [Fri, 7 Sep 2007 12:23:47 +0000 (12:23 +0000)]
code still tried to close fd, fix and clean up

17 years agonew libevent wants clock_gettime() in -lrt
Marko Kreen [Fri, 7 Sep 2007 10:51:59 +0000 (10:51 +0000)]
new libevent wants clock_gettime() in -lrt

17 years agomention loglived logfd
Marko Kreen [Fri, 7 Sep 2007 08:20:59 +0000 (08:20 +0000)]
mention loglived logfd

17 years agoremove track_parameters knob, no good usage scenario
Marko Kreen [Fri, 7 Sep 2007 08:20:04 +0000 (08:20 +0000)]
remove track_parameters knob, no good usage scenario

17 years agoolder asciidoc prints ver into stderr
Marko Kreen [Fri, 7 Sep 2007 08:14:41 +0000 (08:14 +0000)]
older asciidoc prints ver into stderr

17 years agolong-lived logfile fd
Marko Kreen [Thu, 6 Sep 2007 20:19:47 +0000 (20:19 +0000)]
long-lived logfile fd

17 years agorename disable_varcache to track_parameters
Marko Kreen [Thu, 6 Sep 2007 19:53:10 +0000 (19:53 +0000)]
rename disable_varcache to track_parameters

17 years agodoc updates
Marko Kreen [Thu, 6 Sep 2007 19:29:25 +0000 (19:29 +0000)]
doc updates

- check if asciidoc & xmlto
- accept only asciidoc >= 8.2
- include generated mapages in cvs
- disable generation rules if tools are not available
- add </variablelist> hack to fixman

17 years agosmall cleanups
Marko Kreen [Fri, 31 Aug 2007 11:32:59 +0000 (11:32 +0000)]
small cleanups

17 years agoChange some defaults:
Marko Kreen [Tue, 28 Aug 2007 20:54:17 +0000 (20:54 +0000)]
Change some defaults:

max_client_conn = 100
default_pool_size = 20
client_login_timeout = 60

17 years agomore doc updates
Marko Kreen [Tue, 28 Aug 2007 20:50:22 +0000 (20:50 +0000)]
more doc updates

17 years agodoc update
Marko Kreen [Tue, 28 Aug 2007 09:33:38 +0000 (09:33 +0000)]
doc update

17 years agoadd timezone to db parms
Marko Kreen [Mon, 27 Aug 2007 21:48:12 +0000 (21:48 +0000)]
add timezone to db parms

17 years agoasciidoc manpages from Dimitri Fontaine.
Marko Kreen [Mon, 27 Aug 2007 21:45:00 +0000 (21:45 +0000)]
asciidoc manpages from Dimitri Fontaine.

17 years ago-q switch to turn off stdout usage
Marko Kreen [Fri, 17 Aug 2007 21:04:20 +0000 (21:04 +0000)]
-q switch to turn off stdout usage

17 years agodont Assert() on query_start=0
Marko Kreen [Fri, 17 Aug 2007 20:29:40 +0000 (20:29 +0000)]
dont Assert() on query_start=0

17 years agoserver->setting_vars should be checked in SBUF_EV_FLUSH instead
Marko Kreen [Thu, 16 Aug 2007 20:37:31 +0000 (20:37 +0000)]
server->setting_vars should be checked in SBUF_EV_FLUSH instead

17 years agofix comments
Marko Kreen [Thu, 16 Aug 2007 07:57:00 +0000 (07:57 +0000)]
fix comments

17 years agono need to use disconnect_client() as disconnect_server also notifies client
Marko Kreen [Thu, 16 Aug 2007 07:54:57 +0000 (07:54 +0000)]
no need to use disconnect_client() as disconnect_server also notifies client

17 years agomake fatal_perror() really fatal
Marko Kreen [Thu, 16 Aug 2007 07:54:20 +0000 (07:54 +0000)]
make fatal_perror() really fatal

17 years agocorrect check in incomplete_pkt()
Marko Kreen [Thu, 16 Aug 2007 07:52:25 +0000 (07:52 +0000)]
correct check in incomplete_pkt()

17 years agotodo for 1.0.9
Marko Kreen [Wed, 15 Aug 2007 13:50:06 +0000 (13:50 +0000)]
todo for 1.0.9

17 years agotodo for 1.1
Marko Kreen [Wed, 15 Aug 2007 13:45:51 +0000 (13:45 +0000)]
todo for 1.1

17 years agohack targets: asm, pg
Marko Kreen [Wed, 15 Aug 2007 13:44:07 +0000 (13:44 +0000)]
hack targets: asm, pg

17 years agotarget HEAD as 1.1, update NEWS
Marko Kreen [Wed, 15 Aug 2007 13:40:13 +0000 (13:40 +0000)]
target HEAD as 1.1, update NEWS

17 years agobig pkt code reorg.
Marko Kreen [Wed, 15 Aug 2007 13:20:48 +0000 (13:20 +0000)]
big pkt code reorg.

in old code the 'pkt' contained whateved data was available
from SBuf, which made sanity checks complex.

this patch creates wrapper structure for passing current packet
info around.

17 years agoMore magic cleanup, found even couple potential bugs.
Marko Kreen [Mon, 13 Aug 2007 20:37:11 +0000 (20:37 +0000)]
More magic cleanup, found even couple potential bugs.

- get_header() allowed < 5 length, which could trigger unsigned overflow.
- error from server when setting parameters did not do "return false"
- broken ParameterStatus should close connection.

Again, thanks to David Fetter who pushed for cleaner code.

17 years agoMagic number and error message cleanup.
Marko Kreen [Mon, 13 Aug 2007 19:24:02 +0000 (19:24 +0000)]
Magic number and error message cleanup.

Thanks to David Fetter

17 years agotabify functions, remove unnecessary and buggy memset
Marko Kreen [Mon, 13 Aug 2007 15:17:43 +0000 (15:17 +0000)]
tabify functions, remove unnecessary and buggy memset

17 years agodisable users before loading.
Marko Kreen [Sun, 12 Aug 2007 22:33:55 +0000 (22:33 +0000)]
disable users before loading.

otherwise removing users wont work.

17 years agowrap check order in quote_literal
Marko Kreen [Sun, 12 Aug 2007 22:14:42 +0000 (22:14 +0000)]
wrap check order in quote_literal

17 years agovarcache: remove overwrite arg, some logging cleanup
Marko Kreen [Sun, 12 Aug 2007 21:19:12 +0000 (21:19 +0000)]
varcache: remove overwrite arg, some logging cleanup

17 years agolist.h: remove max_count as it was unused, disable list name tracking
Marko Kreen [Sun, 12 Aug 2007 21:15:50 +0000 (21:15 +0000)]
list.h: remove max_count as it was unused, disable list name tracking

17 years agoadd server vars to SHOW FDS, relax result parsing
Marko Kreen [Sun, 12 Aug 2007 13:32:20 +0000 (13:32 +0000)]
add server vars to SHOW FDS, relax result parsing

17 years agomore robust quote_literal()
Marko Kreen [Sat, 11 Aug 2007 12:29:53 +0000 (12:29 +0000)]
more robust quote_literal()

17 years agocomment out the recv() avoidance logic
Marko Kreen [Sat, 11 Aug 2007 07:01:13 +0000 (07:01 +0000)]
comment out the recv() avoidance logic

17 years agouse goto instead break because of 2 loops
Marko Kreen [Sat, 4 Aug 2007 21:29:24 +0000 (21:29 +0000)]
use goto instead break because of 2 loops

17 years agokick client if startup pkt contains unknown params
Marko Kreen [Sat, 4 Aug 2007 19:53:43 +0000 (19:53 +0000)]
kick client if startup pkt contains unknown params

17 years agocorrect quoting for SET values
Marko Kreen [Fri, 3 Aug 2007 22:04:56 +0000 (22:04 +0000)]
correct quoting for SET values

17 years agoadd varcache.c to makefile also
Marko Kreen [Fri, 3 Aug 2007 12:43:32 +0000 (12:43 +0000)]
add varcache.c to makefile also

17 years agoServer parameter tracking.
Marko Kreen [Thu, 2 Aug 2007 11:59:19 +0000 (11:59 +0000)]
Server parameter tracking.

17 years agoavoid recv() if buffer has data
Marko Kreen [Thu, 2 Aug 2007 11:56:28 +0000 (11:56 +0000)]
avoid recv() if buffer has data

17 years agocancel of pause/resume, dont drop idle clients
Marko Kreen [Wed, 1 Aug 2007 22:00:47 +0000 (22:00 +0000)]
cancel of pause/resume, dont drop idle clients

17 years agosmall stuff
Marko Kreen [Wed, 1 Aug 2007 21:29:53 +0000 (21:29 +0000)]
small stuff

17 years agoserver_reset_query
Marko Kreen [Wed, 1 Aug 2007 21:28:46 +0000 (21:28 +0000)]
server_reset_query

17 years agoupdate docs with current status
Marko Kreen [Wed, 1 Aug 2007 20:45:11 +0000 (20:45 +0000)]
update docs with current status

17 years agoWhen suspending, try to hit packet boundary ASAP
Marko Kreen [Wed, 1 Aug 2007 20:42:19 +0000 (20:42 +0000)]
When suspending, try to hit packet boundary ASAP

17 years agodont force --enable-debug to be -O1
Marko Kreen [Wed, 1 Aug 2007 20:11:38 +0000 (20:11 +0000)]
dont force --enable-debug to be -O1

17 years agoremove if() before Assert(), some comment tuning
Marko Kreen [Wed, 1 Aug 2007 20:06:37 +0000 (20:06 +0000)]
remove if() before Assert(), some comment tuning

17 years agolog fd limits on startup
Marko Kreen [Wed, 1 Aug 2007 20:01:03 +0000 (20:01 +0000)]
log fd limits on startup

17 years agoreplace remaining log_* calls with slog_* where appropriate
Marko Kreen [Wed, 1 Aug 2007 19:54:17 +0000 (19:54 +0000)]
replace remaining log_* calls with slog_* where appropriate

17 years agouse memchr() in mbuf_get_string
Marko Kreen [Wed, 1 Aug 2007 19:43:42 +0000 (19:43 +0000)]
use memchr() in mbuf_get_string

17 years agoFix sloppy english in the comments.
Marko Kreen [Mon, 23 Jul 2007 08:53:52 +0000 (08:53 +0000)]
Fix sloppy english in the comments.

Patch by Robert Gogolok.

17 years agoconnstr enhanchements
Marko Kreen [Fri, 29 Jun 2007 15:55:34 +0000 (15:55 +0000)]
connstr enhanchements

* allow to specify hosts by name - gethostbyname()
* allow to specify custom unix socket location for db
* allow quoted values

17 years agocomment typo
Marko Kreen [Fri, 29 Jun 2007 15:52:35 +0000 (15:52 +0000)]
comment typo

17 years agoremove internal hacks from debian/packages pgbouncer_1_0_8
Marko Kreen [Mon, 18 Jun 2007 12:43:30 +0000 (12:43 +0000)]
remove internal hacks from debian/packages

17 years agoforgot to update configure
Marko Kreen [Mon, 18 Jun 2007 12:41:06 +0000 (12:41 +0000)]
forgot to update configure

17 years agoversion 1.0.8
Marko Kreen [Mon, 18 Jun 2007 12:33:54 +0000 (12:33 +0000)]
version 1.0.8

17 years agoupdate todo list
Marko Kreen [Mon, 18 Jun 2007 12:01:27 +0000 (12:01 +0000)]
update todo list

17 years agopause/resume specific database
Marko Kreen [Wed, 13 Jun 2007 21:08:29 +0000 (21:08 +0000)]
pause/resume specific database

17 years agosimplify console command parsing
Marko Kreen [Wed, 13 Jun 2007 21:05:26 +0000 (21:05 +0000)]
simplify console command parsing

17 years agocancel pkt handler forgot to set pool, thus crashed later
Marko Kreen [Wed, 23 May 2007 08:41:48 +0000 (08:41 +0000)]
cancel pkt handler forgot to set pool, thus crashed later

17 years agodisable expensive in-list assert check
Marko Kreen [Mon, 7 May 2007 11:16:03 +0000 (11:16 +0000)]
disable expensive in-list assert check

17 years agoupdate todo list
Marko Kreen [Wed, 25 Apr 2007 11:05:14 +0000 (11:05 +0000)]
update todo list

17 years agover 1.0.7 pgbouncer_1_0_7
Marko Kreen [Thu, 19 Apr 2007 14:56:28 +0000 (14:56 +0000)]
ver 1.0.7

17 years agoRemove concept of 'flushing' from code as bouncer does not actively buffer anything.
Marko Kreen [Thu, 19 Apr 2007 14:03:55 +0000 (14:03 +0000)]
Remove concept of 'flushing' from code as bouncer does not actively buffer anything.

The flushing logic was remnant from the time when buffering was
pushed to kernel with MSG_MORE.  Now it only complicates code.

17 years agosrc/sbuf.c
Marko Kreen [Wed, 18 Apr 2007 13:46:21 +0000 (13:46 +0000)]
src/sbuf.c

17 years agodont call proto if must-flush packet is pending
Marko Kreen [Wed, 18 Apr 2007 13:03:04 +0000 (13:03 +0000)]
dont call proto if must-flush packet is pending

17 years agodont flush error and notice packets, as there may be several of them
Marko Kreen [Wed, 18 Apr 2007 13:00:17 +0000 (13:00 +0000)]
dont flush error and notice packets, as there may be several of them

17 years agoMove OS compat functions to src/system.c to keep the ifdef mess separately.
Marko Kreen [Wed, 18 Apr 2007 08:42:31 +0000 (08:42 +0000)]
Move OS compat functions to src/system.c to keep the ifdef mess separately.

Also remove crypt() wrapper, pointless.

17 years agoStandardise UNIX socket UID lookup to getpeeruid()
Marko Kreen [Fri, 13 Apr 2007 12:45:54 +0000 (12:45 +0000)]
Standardise UNIX socket UID lookup to getpeeruid()

Where it does not exists use SO_PEERCRED or getpeerucred().

17 years agoremote bloat from strlcat
Marko Kreen [Fri, 13 Apr 2007 11:32:43 +0000 (11:32 +0000)]
remote bloat from strlcat

17 years agostrlist_contains should loop on failed compare, not exit
Marko Kreen [Fri, 13 Apr 2007 11:30:24 +0000 (11:30 +0000)]
strlist_contains should loop on failed compare, not exit

17 years agoversion 1.0.6 pgbouncer_1_0_6
Marko Kreen [Thu, 12 Apr 2007 10:55:41 +0000 (10:55 +0000)]
version 1.0.6

17 years agomaintenance func needs always evtimer_add
Marko Kreen [Thu, 12 Apr 2007 10:49:59 +0000 (10:49 +0000)]
maintenance func needs always evtimer_add

17 years agoon FreeBSD (some others too) the ucred.h has sys/param.h as prereq
Marko Kreen [Wed, 11 Apr 2007 12:44:26 +0000 (12:44 +0000)]
on FreeBSD (some others too) the ucred.h has sys/param.h as prereq

17 years agoversion 1.0.5 - "enough for today" pgbouncer_1_0_5
Marko Kreen [Wed, 11 Apr 2007 11:15:14 +0000 (11:15 +0000)]
version 1.0.5  -  "enough for today"

  * Fix online-restart bugs:
    - Set ->ready for idle servers.
    - Remove obsolete code from use_client_socket()
    - Disable maintenance during the takeover.

17 years agoVersion 1.0.4 pgbouncer_1_0_4
Marko Kreen [Wed, 11 Apr 2007 09:24:48 +0000 (09:24 +0000)]
Version 1.0.4

  * Notice from idle server tagged server dirty.
    release_server() did not expect it.  Fix it
    by dropping them.

17 years agoversion 1.0.3 pgbouncer_1_0_3
Marko Kreen [Wed, 11 Apr 2007 07:39:49 +0000 (07:39 +0000)]
version 1.0.3

  = Fixes =

  * Some error handling was missing in login path, so dying
    connection there could trigger asserts.
  * Cleanup of asserts in sbuf.c to catch problems earlier.
  * Create core when Assert() triggers.

  = New stuff =

  * New config vars: log_connections, log_disconnections,
    log_pooler_errors to turn on/off noise.
  * Config var: client_login_timeout to kill dead connections
    in login phase that could stall SUSPEND and thus online restart.

17 years agomore brutal testing
Marko Kreen [Wed, 11 Apr 2007 07:37:15 +0000 (07:37 +0000)]
more brutal testing

17 years agoremove old todo item pgbouncer_1_0_2
Marko Kreen [Wed, 28 Mar 2007 09:22:39 +0000 (09:22 +0000)]
remove old todo item

17 years agoRename sbuf_has_no_state() to sbuf_is_empty()
Marko Kreen [Wed, 28 Mar 2007 09:21:26 +0000 (09:21 +0000)]
Rename sbuf_has_no_state() to sbuf_is_empty()

As its used now for more than just suspending, the old does not fit anymore.

17 years agolet DBGVER depend on --enable-debug
Marko Kreen [Wed, 28 Mar 2007 09:13:33 +0000 (09:13 +0000)]
let DBGVER depend on --enable-debug

17 years agover 1.0.2 - fix 2 corner-case bugs
Marko Kreen [Wed, 28 Mar 2007 09:07:34 +0000 (09:07 +0000)]
ver 1.0.2 - fix 2 corner-case bugs

  * libevent may report a deleted event inside same loop.
    Avoid socket reuse for one loop.
  * release_server() from disconnect_client() didnt look
    it the packet was actually sent.

17 years agoupdate relnotes pgbouncer_1_0_1
Marko Kreen [Thu, 15 Mar 2007 14:50:03 +0000 (14:50 +0000)]
update relnotes

17 years agoimmidiate suspend of logged in clients should be done bit differently
Marko Kreen [Thu, 15 Mar 2007 14:48:48 +0000 (14:48 +0000)]
immidiate suspend of logged in clients should be done bit differently

17 years agoallow SELECT in place of SHOW
Marko Kreen [Thu, 15 Mar 2007 14:48:10 +0000 (14:48 +0000)]
allow SELECT in place of SHOW

17 years agocouple more bugs survived
Marko Kreen [Thu, 15 Mar 2007 13:41:50 +0000 (13:41 +0000)]
couple more bugs survived

* server connection was released too early, there were unsent data.
* put logged in clients immidiately to pause if SUSPEND.
* pause_mode cleanup

17 years agoversion 1.0.1
Marko Kreen [Wed, 14 Mar 2007 23:01:13 +0000 (23:01 +0000)]
version 1.0.1

17 years agofix bug where socket could stall
Marko Kreen [Wed, 14 Mar 2007 22:48:29 +0000 (22:48 +0000)]
fix bug where socket could stall

17 years agoSHOW POOLS displays how long clients have waited
Marko Kreen [Wed, 14 Mar 2007 22:47:24 +0000 (22:47 +0000)]
SHOW POOLS displays how long clients have waited

17 years agoCouple hotfixes.
Marko Kreen [Wed, 14 Mar 2007 19:29:37 +0000 (19:29 +0000)]
Couple hotfixes.

* More debugging in console, new command SHOW SOCKETS.
* unsigned usec_t + cached vs. uncached time created spurious
  query_timeout errors.
* Fair queueing by giving a released server immidiately to waiting server.
* slog_*() print also socket pointer to make tracking possible.
* Sync test.sh with released code.

17 years agoInitial revision
Marko Kreen [Tue, 13 Mar 2007 15:31:43 +0000 (15:31 +0000)]
Initial revision