Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13561: "could not write to log file, Bad file descriptor" error when working with huge table - Mailing list pgsql-bugs

From Pallier, Manuel / BEKO Graz
Subject Re: BUG #13561: "could not write to log file, Bad file descriptor" error when working with huge table
Date
Msg-id 6AAA19FB3874DA43A53E151C03F40D0B06FEC3A4@EAMSGBEK003.bekoag.local
Whole thread Raw
In response to BUG #13561: "could not write to log file, Bad file descriptor" error when working with huge table  (manuel.pallier@beko.at)
List pgsql-bugs
Tree view 
SGksDQoNCj4gQ291bGQgeW91IGhlbHAgdXMga25vdyB0aGUgc2l6ZSBvZiB0aGUgZGF0YWJhc2Ug
eW91IGFyZSBkdW1waW5nID8NClRoZSBzaXplIG9mIHRoZSBkYXRhIGRpcmVjdG9yeSBpcyAzLjM3
IEdCLiBUaGUgc2l6ZSBvZiB0aGUgZHVtcCBmaWxlIHdpdGggLS1jb21wcmVzcz05IGlzIDMwMCBN
Qi4NCg0KPiBUaGlzIHNob3VsZCBwcm9iYWJseSBiZSBhIFdpbmRvd3MgbWVtb3J5IGFsbG9jYXRp
b24gcHJvYmxlbS4gRG8geW91IHNlZSBhbnkgc3VjaCBpc3N1ZXMgbGlrZSBjb3JydXB0aW9uIHdp
dGggbWVtb3J5IG9yIGhhcmQtZGlzayA/DQpObywgYWxsIG90aGVyIG9wZXJhdGlvbnMgb24gdGhl
IG1hY2hpbmUgd29ya3MgZmluZSwgaW5jbHVkaW5nIGNvcHlpbmcgbGFyZ2UgZmlsZXMgYW5kIGlu
c3RhbGxhdGlvbiBvZiBzb2Z0d2FyZS4gQnV0IEkgY2Fu4oCZdCBkbyByZWFsIG1lbW9yeSBvciBo
YXJkLWRpc2sgdGVzdHMgYmVjYXVzZSB0aGlzIGlzIGp1c3QgYSB2aXJ0dWFsIG1hY2hpbmUgYW5k
IEkgZG9u4oCZdCBoYXZlIGFueSBhY2Nlc3MgdG8gdGhlIHBoeXNpY2FsIG1hY2hpbmUuDQoNCj4g
QXNzdW1pbmcgYWxsIGlzIHdlbGwgd2l0aCB0aGUgaGFyZHdhcmUsIElmIHlvdSBjYW4gdHJ5IGFu
ZCBpbmNyZWFzZSB0aGUgc2hhcmVkX2J1ZmZlcnMgYW5kIHNlZSBpZiB0aGF0IGltcHJvdmVzIHRo
ZSBzaXR1YXRpb24uDQpBcyB3cml0dGVuLCBJ4oCZdmUgYWxyZWFkeSBpbmNyZWFzZWQgc2hhcmVk
X2J1ZmZlcnMgdG8gMTI4TUIgYW5kIGl0IGluZGVlZCBpbXByb3ZlZCB0aGUgc2l0dWF0aW9uLiBC
dXQgaXQgaXNu4oCZdCByZXNvbHZlZC4gV2hhdCB2YWx1ZSB3b3VsZCB5b3Ugc3VnZ2VzdD8NCg0K
QmVzdCByZWdhcmRzLA0KTWFudWVsDQoNCg0KVm9uOiBWZW5rYXRhIEJhbGFqaSBOIFttYWlsdG86
bmFnMTAxMEBnbWFpbC5jb21dDQpHZXNlbmRldDogTWl0dHdvY2gsIDEyLiBBdWd1c3QgMjAxNSAw
Mjo0OA0KQW46IFBhbGxpZXIsIE1hbnVlbCAvIEJFS08gR3Jheg0KQmV0cmVmZjogUmU6IFtCVUdT
XSBCVUcgIzEzNTYxOiAiY291bGQgbm90IHdyaXRlIHRvIGxvZyBmaWxlLCBCYWQgZmlsZSBkZXNj
cmlwdG9yIiBlcnJvciB3aGVuIHdvcmtpbmcgd2l0aCBodWdlIHRhYmxlDQoNCg0KT24gVHVlLCBB
dWcgMTEsIDIwMTUgYXQgMzo0MSBQTSwgPG1hbnVlbC5wYWxsaWVyQGJla28uYXQ8bWFpbHRvOm1h
bnVlbC5wYWxsaWVyQGJla28uYXQ+PiB3cm90ZToNClRoZSBmb2xsb3dpbmcgYnVnIGhhcyBiZWVu
IGxvZ2dlZCBvbiB0aGUgd2Vic2l0ZToNCg0KQnVnIHJlZmVyZW5jZTogICAgICAxMzU2MQ0KTG9n
Z2VkIGJ5OiAgICAgICAgICBNYW51ZWwgUGFsbGllcg0KRW1haWwgYWRkcmVzczogICAgICBtYW51
ZWwucGFsbGllckBiZWtvLmF0PG1haWx0bzptYW51ZWwucGFsbGllckBiZWtvLmF0Pg0KUG9zdGdy
ZVNRTCB2ZXJzaW9uOiA5LjQuNA0KT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIFNlcnZlciAy
MDA4IFNQMiB4NjQNCkRlc2NyaXB0aW9uOg0KDQpJJ20gaGF2aW5nIGEgYmlnIHByb2JsZW0gd2l0
aCBhIFBvc3RyZVNRTCBkYXRhYmFzZSBvbiBhIHNwZWNpZmljIG1hY2hpbmUuDQpXaGVuZXZlciBJ
IGRvIHNvbWUgc3BlY2lmaWMgdGhpbmdzIHdpdGggYSBodWdlIHRhYmxlIChvdmVyIDkgbWlsbGlv
biByb3dzKQ0KdGhlIHdob2xlIHBvc3RncmVzIHByb2Nlc3MgY3Jhc2hlcyB3aXRoIHRoZSBmb2xs
b3dpbmcgZW50cmllcyBpbiB0aGUgbG9nDQpmaWxlOg0KDQpQQU5JQzogIGNvdWxkIG5vdCB3cml0
ZSB0byBsb2cgZmlsZSAwMDAwMDAwMTAwMDAwMDAwMDAwMDAwMjIgYXQgb2Zmc2V0DQoxMTY3MzYw
MCwgbGVuZ3RoIDkwOTMxMjogQmFkIGZpbGUgZGVzY3JpcHRvcg0KTE9HOiAgV0FMIHdyaXRlciBw
cm9jZXNzIChQSUQgMTcwNTYpIGV4aXRlZCB3aXRoIGV4aXQgY29kZSAzDQpMT0c6ICB0ZXJtaW5h
dGluZyBhbnkgb3RoZXIgYWN0aXZlIHNlcnZlciBwcm9jZXNzZXMNCldBUk5JTkc6ICB0ZXJtaW5h
dGluZyBjb25uZWN0aW9uIGJlY2F1c2Ugb2YgY3Jhc2ggb2YgYW5vdGhlciBzZXJ2ZXIgcHJvY2Vz
cw0KQ09OVEVYVDogIENPUFkgZnVuZF9yZWNvcmRzLCBsaW5lIDIwODg4ODU6ICIuLi4iDQpMT0c6
ICBQSUQgMzE4MjAgaW4gY2FuY2VsIHJlcXVlc3QgZGlkIG5vdCBtYXRjaCBhbnkgcHJvY2Vzcw0K
TE9HOiAgYWxsIHNlcnZlciBwcm9jZXNzZXMgdGVybWluYXRlZDsgcmVpbml0aWFsaXppbmcNCkZB
VEFMOiAgcHJlLWV4aXN0aW5nIHNoYXJlZCBtZW1vcnkgYmxvY2sgaXMgc3RpbGwgaW4gdXNlDQpI
SU5UOiAgQ2hlY2sgaWYgdGhlcmUgYXJlIGFueSBvbGQgc2VydmVyIHByb2Nlc3NlcyBzdGlsbCBy
dW5uaW5nLCBhbmQNCnRlcm1pbmF0ZSB0aGVtLg0KDQpUaGUgYENPTlRFWFRgIGlzIG9mIGNvdXJz
ZSBkaWZmZXJudCBkZXBlbmRpbmcgb24gd2hhdCBJIGRpZC4gVGhlIGFib3ZlDQpgQ09QWWAgY29t
bWFuZCB3YXMgbG9nZ2VkIHdoZW4gcmVzdG9yaW5nIGEgZHVtcCB3aXRoIHRoZSBiaWcgdGFibGUg
d2l0aA0KcGdfcmVzdG9yZS4gT3RoZXIgb2NjdXJyZW5jZXMgd2VyZSBgVkFDVVVNYCAod2hlbiBJ
IHJ1biB2YWN1dW0gb24gZWl0aGVyIHRoZQ0Kc2luZ2xlIGJpZyB0YWJsZSBvciB0aGUgd2hvbGUg
ZGF0YWJhc2UpIG9yIGV2ZW4gYFNFTEVDVGAgKHdoZW4gSSBydW4gYQ0Kc2ltcGxlIDEgcm93IHJl
c3VsdCBzZWxlY3Qgam9pbmluZyB0aGUgYmlnIHRhYmxlKS4NCg0KSSBjYW4gcmVwcm9kdWNlIHRo
aXMgY3Jhc2ggMTAwJSBieSBlaXRoZXIgcnVubmluZyB2YWN1dW0gb24gdGhlIHRhYmxlIG9yDQp0
cnlpbmcgdG8gcmVzdG9yZSB0aGUgdGFibGUgZGF0YSBmcm9tIGEgZHVtcC4gT3RoZXIgdGhpbmdz
LCBsaWtlIHNlbGVjdA0Kc3RhdGVtZW50cywgZG8gbm90IHJlcHJvZHVjZSBhbHdheXMsIGJ1dCBh
dCBsZWFzdCB0aGV5IGNyYXNoIG9mdGVuIGVub3VnaA0KdGhhdCBpdCBpcyB2ZXJ5IGFubm95aW5n
LiBJdCdzIGFsd2F5cyB0aGUgYGNvdWxkIG5vdCB3cml0ZSB0byBsb2cgZmlsZSB4IGF0DQpvZmZz
ZXQgeSwgbGVuZ3RoIHo6IEJhZCBmaWxlIGRlc2NyaXB0b3JgIGVycm9yLiBJJ3ZlIGFscmVhZHkg
dHJpZWQgZGlzYWJsaW5nDQphdXRvdmFjdXVtIGR1cmluZyBwZ19yZXNvdHJlIGJ1dCBpdCBzdGls
bCBmYWlscy4NCg0KVGhpcyBwcm9ibGVtIHNlZW1zIHRvIGJlIHNwZWNpZmljIHRvIG9uZSBzZXJ2
ZXIsIGJlY2F1c2UgdGhlIHNhbWUgdGFibGUvZHVtcA0Kd29ya3MgZmluZSB3aGVuIEkgaW1wb3J0
IGl0IG9uIG15IGxvY2FsIG1hY2hpbmUuIFRoZSBhZmZlY3RlZCBzZXJ2ZXIgaXMgYQ0KdmlydHVh
bCAob24gUGFyYWxsZWxzIFZpcnR1b3p6byBiYXNlKSBXaW5kb3dzIFNlcnZlciAyMDA4IFNQMiB4
NjQgd2l0aCAyIEdCDQpSQU0uIFRoZXJlIGlzIG9ubHkgYSBzaW5nbGUgSEREIHBhcnRpdGlvbiBh
bmQgbmVhcmx5IDQwIEdCIG9mIGZyZWUgc3BhY2Ugb24NCml0LiBOb3RoaW5nIG90aGVyIHRoYW4g
UG9zdGdyZVNRTCBpcyBydW5uaW5nIG9uIHRoZSBzZXJ2ZXIsIGFsc28gbm8gYW50aQ0KdmlydXMg
c29mdHdhcmUuIEJ1dCBQb3N0Z3JlU1FMIGlzIHRoZSBvbmx5IGFwcGxpY2F0aW9uIG9uIHRoaXMg
c2VydmVyIHRoYXQNCnNob3dzIHByb2JsZW1zLCBhbGwgb3RoZXIgb3BlcmF0aW9ucyBJJ3ZlIHRy
aWVkIHdvcmsgZmluZSwgc28gaXQgc2VlbXMgbGlrZQ0KaXQncyBub3QgYSBnZW5lcmFsIHByb2Js
ZW0gd2l0aCB0aGlzIG1hY2hpbmUuDQoNCkkndmUgdHJpZWQgUG9zdGdyZVNRTCBzZXJ2ZXIgdmVy
c2lvbnMgOC40LjQgKHRoaXMgd2FzIHJ1bm5pbmcgZm9yIHllYXJzDQp1bnRpbCBpdCBmaXJzdCBz
aG93ZWQgdGhlIGVycm9yKSwgOC40LjIyIGFuZCA5LjQuNCwgYWxsIHNob3cgdGhlIHNhbWUgZXJy
b3IuDQpJJ3ZlIHRyaWVkIGJvdGggdXBncmFkaW5nIGZyb20gOC40LjQgdG8gOC40LjIyIGFuZCBm
cmVzaCBpbnN0YWxscyBvZiA4LjQuMjINCmFuZCA5LjQuNCAodGhlcmUgSSd2ZSBhbHNvIGNvbXBs
ZXRlbHkgZGVsZXRlZCB0aGUgZGF0YSBmb2xkZXIpIG11bHRpcGxlDQp0aW1lcy4NCg0KU2luY2Ug
SSd2ZSBjaGFuZ2VkIHNvbWUgdmFsdWVzIGluIHBvc3RncmVzcWwuY29uZiBhd2F5IGZyb20gdGhl
aXIgZGVmYXVsdA0KdmFsdWVzLCB0aGUgdGhlIGNyYXNoIG5vdyBoYXBwZW5zIG11Y2ggcmFyZXIu
IFNpbXBsZSBTUUwgYW5kIERNTCBzdGF0ZW1lbnRzDQpvbmx5IGNyYXNoIHZlcnkgcmFyZWx5IChv
bmNlIGV2ZXJ5IGZldyBkYXlzKSwgYnV0IFZBQ1VVTSBzdGlsbCBjcmFzaGVzIDEwMCUuDQpIZXJl
IGFyZSB0aGUgdmFsdWVzIEkgY2hhbmdlZDoNCg0Kc2hhcmVkX2J1ZmZlcnMgPSAxMjhNQg0Kd29y
a19tZW0gPSAxNk1CDQptYWludGVuYW5jZV93b3JrX21lbSA9IDY0TUINCndhbF9idWZmZXJzID0g
NE1CDQoNCkNhbiBzb21lb25lIHBsZWFzZSBleHBsYWluIHdoYXQncyB3cm9uZyBoZXJlPw0KDQpD
b3VsZCB5b3UgaGVscCB1cyBrbm93IHRoZSBzaXplIG9mIHRoZSBkYXRhYmFzZSB5b3UgYXJlIGR1
bXBpbmcgPyBUaGlzIHNob3VsZCBwcm9iYWJseSBiZSBhIFdpbmRvd3MgbWVtb3J5IGFsbG9jYXRp
b24gcHJvYmxlbS4gRG8geW91IHNlZSBhbnkgc3VjaCBpc3N1ZXMgbGlrZSBjb3JydXB0aW9uIHdp
dGggbWVtb3J5IG9yIGhhcmQtZGlzayA/DQpBc3N1bWluZyBhbGwgaXMgd2VsbCB3aXRoIHRoZSBo
YXJkd2FyZSwgSWYgeW91IGNhbiB0cnkgYW5kIGluY3JlYXNlIHRoZSBzaGFyZWRfYnVmZmVycyBh
bmQgc2VlIGlmIHRoYXQgaW1wcm92ZXMgdGhlIHNpdHVhdGlvbi4NClJlZ2FyZHMsDQpWZW5rYXRh
IEJhbGFqaSBODQpGdWppdHN1IEF1c3RyYWxpYQ0KDQoNCg==

pgsql-bugs by date:

Previous
From: Noah Misch
Date:
Subject: Re: BUG #13427: postgres.exe fails to start on Korean Windows Server 2008: cannot perform encoding conversion outsid
Next
From: Greg Stark
Date:
Subject: Re: BUG #13559: WAL replay stuck after DROP VIEW