Thread: BUG #14168: ALTER TABLE SET LOGGED failing
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE2OApMb2dnZWQgYnk6ICAg ICAgICAgIEdhbmVzaCBLYW5uYW4KRW1haWwgYWRkcmVzczogICAgICBnYW5l c2gua2FubmFuQHdlYXRoZXJhbmFseXRpY3MuY29tClBvc3RncmVTUUwgdmVy c2lvbjogOS41LjMKT3BlcmF0aW5nIHN5c3RlbTogICBSZWQgSGF0IEVudGVy cHJpc2UgNy4yCkRlc2NyaXB0aW9uOiAgICAgICAgCgpXZSBoYXZlIGEgbGFy Z2UgbnVtYmVyIG9mIHVubG9nZ2VkIHRhYmxlcyBpbiBvdXIgZGF0YWJhc2Ug YW5kIEkgYW0gdHJ5aW5nIHRvCm1pZ3JhdGUgdGhlbSBvdmVyIHRvIHJlZ3Vs YXIgdGFibGVzLiBJIGRlY2lkZWQgdG8gdXNlIDkuNSBmZWF0dXJlIG9mIFNF VApMT0dHRUQgYXMgYSBxdWlja2VyIHdheSB0byBkbyB0aGlzIGpvYi4gSG93 ZXZlciB3ZSBhcmUgcnVubmluZyBpbiB0byBzcGFjZQpyZWxhdGVkIGlzc3Vl ICwgd2hlcmUgaXQgaXMgbm90IGNsZWFyIHdoeSB0aGlzIGlzIGhhcHBlbmlu ZywgYW5kIGdldHRpbmcKc29tZSBjcnlwdGljIGxhY2sgb2Ygc3BhY2UgZXJy b3JzLiAgQWxsIHRhYmxlcyB3ZXJlIGNyZWF0ZWQgdXNpbmcgIiBjcmVhdGUK dW5sb2dnZWQgdGFibGUgLi4uIiBjb21tYW5kLg0KZS5nLg0KcHNxbCAkIGFs dGVyIHRhYmxlIHNjaGVtYS50ZXN0X3kxOTk5IHNldCBsb2dnZWQgOw0KDQpw c3FsOm12VFMyLnNxbDo2OiBFUlJPUjogIGNvdWxkIG5vdCBleHRlbmQgZmls ZQoicGdfdGJsc3BjLzE2NDA0L1BHXzkuNV8yMDE1MTAwNTEvMTY0MDcvNjE3 NDAuMSI6IHdyb3RlIG9ubHkgNDA5NiBvZiA4MTkyCmJ5dGVzIGF0IGJsb2Nr IDE3NTQxMQ0KSElOVDogIENoZWNrIGZyZWUgZGlzayBzcGFjZS4NClRpbWU6 IDMzNTUzOS4wMzEgbXMNCg0KSG93ZXZlciwgdGhlcmUgaXMgZW5vdWdoIGZy ZWUgc3BhY2UgYXZhaWxhYmxlIG9uIHRoZSB2b2x1bWVzIHRvIGFjY29tbW9k YXRlCnNldmVyYWwgb2YgdGhlIHRhYmxlcywgYnV0IEFMVEVSIFRBQkxFIHNl dCBsb2dnZWQgY29tbWFuZCBjb25zaXN0ZW50bHkKZmFpbHMsICBkZiAtaCBz aG93cyB0aGlzOg0KDQo+PiBkZiAtaCAgfCBncmVwIGRhdGE1DQovZGV2L21h cHBlci92Z19wZ2RhdGE1LWx2X3BnZGF0YTUgIDkuOFQgIDkuNVQgIDM2M0cg IDk3JSAvcGdfbGFuZF9kYXRhNQ0KDQoodGFibGUgc2l6ZSBpcyB+MjRHQiwg ZnJlZSBzcGFjZSBhdmFpbGFibGUgfjM2M0cpDQoNCj4+IEkgZXZlbiB2YWxp ZGF0ZWQgdGhhdCB0aGlzIGlzIG5vdCBhIHNwYWNlIGlzc3VlIGJ5IHJ1bm5p bmcgdGhlCmZvbGxvd2luZzoNCg0KYWx0ZXIgdGFibGUgc2NoZW1hLnRlc3Rf eTE5OTkgc2V0IHRhYmxlc3BhY2UgdHNfZGF0YTUgOw0KPj4gc3VjY2VzZnVs eSBjb21wbGV0ZXMuDQoNCih0YWJsZXNwYWNlIHRzX2RhdGE1IGlzIG1vdW50 ZWQgb24gL3BnX2RhdGE1KSANCkFzIHlvdSBjYW4gc2VlICIgU0VUIFRBQkxF U1BBQ0UiIGJlaGF2aW9yIGlzIHZlcnkgZGlmZmVyZW50IHRoYW4gIiAuLi4g U0VUCkxPR0dFRCIgd2hpY2ggZmFpbHMgZWFjaCB0aW1lLiANCg0KQ2FuIHNv bWVvbmUgaGVscCB0cm91Ymxlc2hvb3RpbmcgdGhpcyBpc3N1ZT8gSSBhbSBu b3Qgc3VyZSB3aGF0ICIgLi4uU0VUCkxPR0dFRCIgaXMgY2hlY2tpbmcuDQoN CkFueSBoZWxwIG9yIHBvaW50ZXJzIHdvdWxkIGJlIGdyZWF0bHkgYXBwcmVj aWF0ZWQuIA0KDQp+R2FuZXNoIEthbm5hbg0KDQoNCg0KCgo=
On Wed, 01 Jun 2016 04:57:41 +0000 ganesh.kannan@weatheranalytics.com wrote: > The following bug has been logged on the website: > > Bug reference: 14168 > > psql:mvTS2.sql:6: ERROR: could not extend file > "pg_tblspc/16404/PG_9.5_201510051/16407/61740.1": wrote only 4096 of 8192 > bytes at block 175411 > HINT: Check free disk space. > Time: 335539.031 ms > > However, there is enough free space available on the volumes to accommodate > several of the tables, but ALTER TABLE set logged command consistently > fails, df -h shows this: > > >> df -h | grep data5 > /dev/mapper/vg_pgdata5-lv_pgdata5 9.8T 9.5T 363G 97% /pg_land_data5 Sometimes the unix error ENOSPC covers more than disk space. For example you could be out of inodes. What does df -i show? -dg -- David Gould 510 282 0869 daveg@sonic.net If simplicity worked, the world would be overrun with insects.
This is a false alarm . The free space error that I get from " alter table = .. set logged" was not because of lack of space in the volumed used by the = tablespace, but from the volumes used by the indexes of that table. Given t= he table was an "unlogged" table, indexes were also "unlogged", and it look= s like " alter table ...set logged" also implicitly converts the indexes f= rom "unlogged" to regular indexes.=20 After clearing enough space " alter table ...set logged" worked fine. It w= ould help to mention the implicit index migration in the documentation.=20 Thanks David for the response. I did run the "df -i" command, and this is t= he result.=20 /dev/mapper/vg_data5-lv_data5 1521588112 9897 1521578215 1% /pg_data5 Thanks Ganesh Kannan ________________________________________ From: David Gould <daveg@sonic.net> Sent: Wednesday, June 1, 2016 3:06 AM To: Ganesh Kannan Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #14168: ALTER TABLE SET LOGGED failing On Wed, 01 Jun 2016 04:57:41 +0000 ganesh.kannan@weatheranalytics.com wrote: > The following bug has been logged on the website: > > Bug reference: 14168 > > psql:mvTS2.sql:6: ERROR: could not extend file > "pg_tblspc/16404/PG_9.5_201510051/16407/61740.1": wrote only 4096 of 8192 > bytes at block 175411 > HINT: Check free disk space. > Time: 335539.031 ms > > However, there is enough free space available on the volumes to accommoda= te > several of the tables, but ALTER TABLE set logged command consistently > fails, df -h shows this: > > >> df -h | grep data5 > /dev/mapper/vg_pgdata5-lv_pgdata5 9.8T 9.5T 363G 97% /pg_data5 Sometimes the unix error ENOSPC covers more than disk space. For example you could be out of inodes. What does df -i show? -dg -- David Gould 510 282 0869 daveg@sonic.net If simplicity worked, the world would be overrun with insects.