From mike@fuhr.org Thu Jun 4 00:03:11 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DE7879DC8DC for ; Fri, 20 Jan 2006 18:19:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89658-07 for ; Fri, 20 Jan 2006 18:19:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id D2CB39DC83F for ; Fri, 20 Jan 2006 18:19:11 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k0KMJAVG021783 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Fri, 20 Jan 2006 15:19:13 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k0KMJAj3086196 for ; Fri, 20 Jan 2006 15:19:10 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k0KMJApd086195 for pgsql-www@postgresql.org; Fri, 20 Jan 2006 15:19:10 -0700 (MST) (envelope-from mfuhr) Date: Fri, 20 Jan 2006 15:19:10 -0700 From: Michael Fuhr To: pgsql-www@postgresql.org Subject: Searches resulting in 414 Request URI too long Message-ID: <20060120221910.GA86040@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.106 required=5 tests=[AWL=0.106] X-Spam-Score: 0.106 X-Spam-Level: X-Archive-Number: 200601/221 X-Sequence-Number: 9409 A few times in the past day I've gotten 414 (Request URI too long) errors while searching through the mailing list archives. I haven't figured out a 100% repeatable test case yet, but you can eventually see what's happening by doing the following: 1. Go to http://archives.postgresql.org/ 2. Search for something (e.g., "foo"). 3. Move between result pages by clicking Next, Previous, or one of the page numbers. Do this several times and eventually the URI gets excessively long. Sometimes it happens right away but sometimes it requires numerous clicks. The A tags for the result pages' links go from something like to and then they get longer, with numerous instances of "ul=...". Eventually they get too long and the web server responds with 414 Request URI too long. -- Michael Fuhr From john@geeknet.com.au Thu Jun 4 00:03:11 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5DC289DC802 for ; Sat, 21 Jan 2006 04:44:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17470-02 for ; Sat, 21 Jan 2006 04:44:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pdc.geeknet.com.au (ns1.geeknet.com.au [220.244.63.182]) by postgresql.org (Postfix) with ESMTP id BD4F09DC80E for ; Sat, 21 Jan 2006 04:44:30 -0400 (AST) Subject: Re: Searches resulting in 414 Request URI too long MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Date: Sat, 21 Jan 2006 19:42:52 +1100 Message-ID: <34F8F335525CB14C95CF92BE2194858E012864@pdc.geeknet.com.au> Content-class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Searches resulting in 414 Request URI too long Thread-Index: AcYeD5zZ3FKScWHGR1O04QkYMeSeBAAVuGSg From: "John Hansen" To: "Michael Fuhr" , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.103 required=5 tests=[AWL=0.103] X-Spam-Score: 0.103 X-Spam-Level: X-Archive-Number: 200601/224 X-Sequence-Number: 9412 U2hvdWxkIGJlIGZpeGVkIG5vdywuLi4uIA0KDQouLi4gSm9obg0KDQo+IC0tLS0tT3JpZ2luYWwg TWVzc2FnZS0tLS0tDQo+IEZyb206IHBnc3FsLXd3dy1vd25lckBwb3N0Z3Jlc3FsLm9yZyANCj4g W21haWx0bzpwZ3NxbC13d3ctb3duZXJAcG9zdGdyZXNxbC5vcmddIE9uIEJlaGFsZiBPZiBNaWNo YWVsIEZ1aHINCj4gU2VudDogU2F0dXJkYXksIEphbnVhcnkgMjEsIDIwMDYgOToxOSBBTQ0KPiBU bzogcGdzcWwtd3d3QHBvc3RncmVzcWwub3JnDQo+IFN1YmplY3Q6IFtwZ3NxbC13d3ddIFNlYXJj aGVzIHJlc3VsdGluZyBpbiA0MTQgUmVxdWVzdCBVUkkgdG9vIGxvbmcNCj4gDQo+IEEgZmV3IHRp bWVzIGluIHRoZSBwYXN0IGRheSBJJ3ZlIGdvdHRlbiA0MTQgKFJlcXVlc3QgVVJJIHRvbyANCj4g bG9uZykgZXJyb3JzIHdoaWxlIHNlYXJjaGluZyB0aHJvdWdoIHRoZSBtYWlsaW5nIGxpc3QgDQo+ IGFyY2hpdmVzLiAgSSBoYXZlbid0IGZpZ3VyZWQgb3V0IGEgMTAwJSByZXBlYXRhYmxlIHRlc3Qg Y2FzZSANCj4geWV0LCBidXQgeW91IGNhbiBldmVudHVhbGx5IHNlZSB3aGF0J3MgaGFwcGVuaW5n IGJ5IGRvaW5nIHRoZSANCj4gZm9sbG93aW5nOg0KPiANCj4gMS4gR28gdG8gaHR0cDovL2FyY2hp dmVzLnBvc3RncmVzcWwub3JnLw0KPiANCj4gMi4gU2VhcmNoIGZvciBzb21ldGhpbmcgKGUuZy4s ICJmb28iKS4NCj4gDQo+IDMuIE1vdmUgYmV0d2VlbiByZXN1bHQgcGFnZXMgYnkgY2xpY2tpbmcg TmV4dCwgUHJldmlvdXMsIG9yIG9uZSBvZg0KPiAgICB0aGUgcGFnZSBudW1iZXJzLiAgRG8gdGhp cyBzZXZlcmFsIHRpbWVzIGFuZCBldmVudHVhbGx5IHRoZSBVUkkNCj4gICAgZ2V0cyBleGNlc3Np dmVseSBsb25nLiAgU29tZXRpbWVzIGl0IGhhcHBlbnMgcmlnaHQgYXdheSBidXQNCj4gICAgc29t ZXRpbWVzIGl0IHJlcXVpcmVzIG51bWVyb3VzIGNsaWNrcy4NCj4gDQo+IFRoZSBBIHRhZ3MgZm9y IHRoZSByZXN1bHQgcGFnZXMnIGxpbmtzIGdvIGZyb20gc29tZXRoaW5nIGxpa2UNCj4gDQo+IDxh IGhyZWY9Ij9xPWZvbyZjcz11dGYtOCZmbT1vbiZncj1vZmYmc3Q9MjAmbnA9MSI+DQo+IA0KPiB0 bw0KPiANCj4gPGEgDQo+IGhyZWY9Ij9xPWZvbyZ1bD1odHRwJTNBJTJGJTJGYXJjaGl2ZXMucG9z dGdyZXNxbC5vcmclMkZwZ3NxbC1iDQp1Z3MlMkYlMjUmY3M9dXRmLTgmZm09b24mZ3I9b2ZmJnN0 PTIwJm5wPTIiPg0KPiANCj4gYW5kIHRoZW4gdGhleSBnZXQgbG9uZ2VyLCB3aXRoIG51bWVyb3Vz IGluc3RhbmNlcyBvZiAidWw9Li4uIi4NCj4gRXZlbnR1YWxseSB0aGV5IGdldCB0b28gbG9uZyBh bmQgdGhlIHdlYiBzZXJ2ZXIgcmVzcG9uZHMgd2l0aA0KPiA0MTQgUmVxdWVzdCBVUkkgdG9vIGxv bmcuDQo+IA0KPiAtLQ0KPiBNaWNoYWVsIEZ1aHINCj4gDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLShlbmQgb2YgDQo+IGJyb2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N Cj4gVElQIDY6IGV4cGxhaW4gYW5hbHl6ZSBpcyB5b3VyIGZyaWVuZA0KPiANCj4gDQo= From mike@fuhr.org Thu Jun 4 00:03:12 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 294B09DCCA4 for ; Sun, 22 Jan 2006 00:40:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27920-06 for ; Sun, 22 Jan 2006 00:40:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 0CC6C9DCC8D for ; Sun, 22 Jan 2006 00:40:25 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k0M4eGQm023534 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sat, 21 Jan 2006 21:40:20 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k0M4eFVh025478; Sat, 21 Jan 2006 21:40:15 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k0M4eE6B025477; Sat, 21 Jan 2006 21:40:14 -0700 (MST) (envelope-from mfuhr) Date: Sat, 21 Jan 2006 21:40:14 -0700 From: Michael Fuhr To: John Hansen Cc: pgsql-www@postgresql.org Subject: Re: Searches resulting in 414 Request URI too long Message-ID: <20060122044014.GA25379@winnie.fuhr.org> References: <34F8F335525CB14C95CF92BE2194858E012864@pdc.geeknet.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <34F8F335525CB14C95CF92BE2194858E012864@pdc.geeknet.com.au> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.107 required=5 tests=[AWL=0.107] X-Spam-Score: 0.107 X-Spam-Level: X-Archive-Number: 200601/237 X-Sequence-Number: 9425 On Sat, Jan 21, 2006 at 07:42:52PM +1100, John Hansen wrote: > Should be fixed now,.... Nope -- I'm still seeing the behavior I reported. Sometimes it takes a while, but eventually the links' query strings contain several ul variables. All I'm doing is clicking on Previous, Next, and the page numbers. -- Michael Fuhr From john@geeknet.com.au Thu Jun 4 00:03:12 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9D0239DC851 for ; Sun, 22 Jan 2006 07:33:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92450-06 for ; Sun, 22 Jan 2006 07:33:46 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pdc.geeknet.com.au (ns1.geeknet.com.au [220.244.63.182]) by postgresql.org (Postfix) with ESMTP id 1F0449DC810 for ; Sun, 22 Jan 2006 07:33:38 -0400 (AST) Subject: Re: Searches resulting in 414 Request URI too long Date: Sun, 22 Jan 2006 22:33:34 +1100 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Message-ID: <34F8F335525CB14C95CF92BE2194858E012867@pdc.geeknet.com.au> Content-class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Searches resulting in 414 Request URI too long Thread-Index: AcYfDfXhkY4PkbGYQEi7bXC+fNiX3QAOUbpg From: "John Hansen" To: "Michael Fuhr" Cc: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.105 required=5 tests=[AWL=0.105] X-Spam-Score: 0.105 X-Spam-Level: X-Archive-Number: 200601/239 X-Sequence-Number: 9427 T2theSwuLi4NCg0KU2VlbXMgdGhlIGFwYWNoZSBtb2R1bGUgaXMgZmF1bHR5Li4uIDooDQpTd2l0 Y2hlZCB0byBjZ2kgd2hpbGUgSSBodW50IGZvciB0aGUgYnVnLi4uDQoNCkxldCBtZSBrbm93IGlm IHRoZSBjZ2kgaGFzIHRoZSBzYW1lIGZhdWx0LC4gVGhvIGl0IGRvZXNuJ3QgbG9vayBsaWtlIGl0 Li4uDQoNCi4uLiBKb2huDQoNCj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4gRnJvbTog TWljaGFlbCBGdWhyIFttYWlsdG86bWlrZUBmdWhyLm9yZ10gDQo+IFNlbnQ6IFN1bmRheSwgSmFu dWFyeSAyMiwgMjAwNiAzOjQwIFBNDQo+IFRvOiBKb2huIEhhbnNlbg0KPiBDYzogcGdzcWwtd3d3 QHBvc3RncmVzcWwub3JnDQo+IFN1YmplY3Q6IFJlOiBbcGdzcWwtd3d3XSBTZWFyY2hlcyByZXN1 bHRpbmcgaW4gNDE0IFJlcXVlc3QgDQo+IFVSSSB0b28gbG9uZw0KPiANCj4gT24gU2F0LCBKYW4g MjEsIDIwMDYgYXQgMDc6NDI6NTJQTSArMTEwMCwgSm9obiBIYW5zZW4gd3JvdGU6DQo+ID4gU2hv dWxkIGJlIGZpeGVkIG5vdywuLi4uIA0KPiANCj4gTm9wZSAtLSBJJ20gc3RpbGwgc2VlaW5nIHRo ZSBiZWhhdmlvciBJIHJlcG9ydGVkLiAgU29tZXRpbWVzIA0KPiBpdCB0YWtlcyBhIHdoaWxlLCBi dXQgZXZlbnR1YWxseSB0aGUgbGlua3MnIHF1ZXJ5IHN0cmluZ3MgDQo+IGNvbnRhaW4gc2V2ZXJh bCB1bCB2YXJpYWJsZXMuICBBbGwgSSdtIGRvaW5nIGlzIGNsaWNraW5nIG9uIA0KPiBQcmV2aW91 cywgTmV4dCwgYW5kIHRoZSBwYWdlIG51bWJlcnMuDQo+IA0KPiAtLQ0KPiBNaWNoYWVsIEZ1aHIN Cj4gDQo+IA0K