Thread: BUG #14096: run pgbench, db crash
The following bug has been logged on the website: Bug reference: 14096 Logged by: zpzhao Email address: zhaozp@uxsino.com PostgreSQL version: 9.5.1 Operating system: centos7 Description: PageAddItemä¸ï¼phdr->pd_lower,pd_upper为0
zhaozp@uxsino.com wrote: > The following bug has been logged on the website: > > Bug reference: 14096 > Logged by: zpzhao > Email address: zhaozp@uxsino.com > PostgreSQL version: 9.5.1 > Operating system: centos7 > Description: > > PageAddItemä¸ï¼phdr->pd_lower,pd_upper为0 Please provide more details on the crash you see. This description is not enough. Thanks, -- Ãlvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Y29yZSBmaWxlIDoNCg0KIzAgIDB4MDAwMDAwM2U2MWUzMjYyNSBpbiByYWlzZSAoKSBmcm9tIC9s aWI2NC9saWJjLnNvLjYNCiMxICAweDAwMDAwMDNlNjFlMzNlMDUgaW4gYWJvcnQgKCkgZnJvbSAv bGliNjQvbGliYy5zby42DQojMiAgMHgwMDAwMDAwMDAwYTU2ODBjIGluIGVycmZpbmlzaCAoZHVt bXk9PHZhbHVlIG9wdGltaXplZCBvdXQ+KSBhdCBlbG9nLmM6NTUxDQojMyAgMHgwMDAwMDAwMDAw OTY0ZmM3IGluIFBhZ2VBZGRJdGVtIChwYWdlPTx2YWx1ZSBvcHRpbWl6ZWQgb3V0PiwgaXRlbT0w eDI2MWU5MDAgIngnIiwgc2l6ZT0xMjEsIG9mZnNldE51bWJlcj0wLCBvdmVyd3JpdGU9PHZhbHVl IG9wdGltaXplZCBvdXQ+LCBpc19oZWFwPTx2YWx1ZSBvcHRpbWl6ZWQgb3V0PikgYXQgYnVmcGFn ZS5jOjE5OA0KIzQgIDB4MDAwMDAwMDAwMDc1MGFjYSBpbiBSZWxhdGlvblB1dEhlYXBUdXBsZSAo cmVsYXRpb249PHZhbHVlIG9wdGltaXplZCBvdXQ+LCBidWZmZXI9MzcxLCB0dXBsZT0weDI2MWU4 ZTgsIHRva2VuPTAgJ1wwMDAnKSBhdCBoaW8uYzo1Mw0KIzUgIDB4MDAwMDAwMDAwMDc0YjNhNyBp biBoZWFwX3VwZGF0ZSAocmVsYXRpb249MHg3ZjEwMzAwODU3MzgsIG90aWQ9PHZhbHVlIG9wdGlt aXplZCBvdXQ+LCBuZXd0dXA9MHgyNjFlOGU4LCBjaWQ9MCwgY3Jvc3NjaGVjaz0weDAsIHdhaXQ9 MSAnXDAwMScsIGh1ZmQ9MHg3ZmZmMDJkMjJiNDAsIGxvY2ttb2RlPTB4N2ZmZjAyZDIyYjVjKSBh dCBoZWFwYW0uYzozODcwDQojNiAgMHgwMDAwMDAwMDAwODg4YTBmIGluIEV4ZWNVcGRhdGUgKHR1 cGxlaWQ9MHg3ZmZmMDJkMjJjYTAsIG9sZHR1cGxlPTB4MCwgc2xvdD0weDI2MWUyNjgsIHBsYW5T bG90PTB4MjYxNjE2MCwgZXV4c3Fsc3RhdGU9MHgyNjE0ODAwLCBlc3RhdGU9MHgyNjE0NTEwLCBj YW5TZXRUYWc9MSAnXDAwMScpIGF0IG5vZGVNb2RpZnlUYWJsZS5jOjg4NA0KIzcgIDB4MDAwMDAw MDAwMDg4OTM4YSBpbiBFeGVjTW9kaWZ5VGFibGUgKG5vZGU9MHgyNjE0NzYwKSBhdCBub2RlTW9k aWZ5VGFibGUuYzoxNDQ0DQojOCAgMHgwMDAwMDAwMDAwODcxMGE4IGluIEV4ZWNQcm9jTm9kZSAo bm9kZT0weDI2MTQ3NjApIGF0IGV4ZWNQcm9jbm9kZS5jOjM4OQ0KIzkgIDB4MDAwMDAwMDAwMDg2 Zjg0MiBpbiBFeGVjdXRlUGxhbiAocXVlcnlEZXNjPTB4MjYwYjg0MCwgZGlyZWN0aW9uPTx2YWx1 ZSBvcHRpbWl6ZWQgb3V0PiwgY291bnQ9MCkgYXQgZXhlY01haW4uYzoxNTQ5DQoNCiMzICAweDAw MDAwMDAwMDA5NjRmYzcgaW4gUGFnZUFkZEl0ZW0gKHBhZ2U9PHZhbHVlIG9wdGltaXplZCBvdXQ+ LCBpdGVtPTB4MjYxZTkwMCAieCciLCBzaXplPTEyMSwgb2Zmc2V0TnVtYmVyPTAsIG92ZXJ3cml0 ZT08dmFsdWUgb3B0aW1pemVkIG91dD4sIGlzX2hlYXA9PHZhbHVlIG9wdGltaXplZCBvdXQ+KSBh dCBidWZwYWdlLmM6MTk4DQppZiAocGhkci0+cGRfbG93ZXIgPCBTaXplT2ZQYWdlSGVhZGVyRGF0 YSB8fA0KcGhkci0+cGRfbG93ZXIgPiBwaGRyLT5wZF91cHBlciB8fA0KcGhkci0+cGRfdXBwZXIg PiBwaGRyLT5wZF9zcGVjaWFsIHx8DQpwaGRyLT5wZF9zcGVjaWFsID4gQkxDS1NaKQ0KIHBkX2xv d2VyIHBkX3VwcGVyIHBkX3NwZWNpYWwgbWVtYmVycyA9IDANCg0KDQoNCkZyb206IEFsdmFybyBI ZXJyZXJhDQpEYXRlOiAyMDE2LTA0LTE5IDAzOjA5DQpUbzogemhhb3pwDQpDQzogcGdzcWwtYnVn cw0KU3ViamVjdDogUmU6IFtCVUdTXSBCVUcgIzE0MDk2OiBydW4gcGdiZW5jaCwgZGIgY3Jhc2gN CnpoYW96cEB1eHNpbm8uY29tIHdyb3RlOg0KPiBUaGUgZm9sbG93aW5nIGJ1ZyBoYXMgYmVlbiBs b2dnZWQgb24gdGhlIHdlYnNpdGU6DQo+IA0KPiBCdWcgcmVmZXJlbmNlOiAgICAgIDE0MDk2DQo+ IExvZ2dlZCBieTogICAgICAgICAgenB6aGFvDQo+IEVtYWlsIGFkZHJlc3M6ICAgICAgemhhb3pw QHV4c2luby5jb20NCj4gUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMQ0KPiBPcGVyYXRpbmcgc3lz dGVtOiAgIGNlbnRvczcNCj4gRGVzY3JpcHRpb246ICAgICAgICANCj4gDQo+IFBhZ2VBZGRJdGVt 5Lit77yMcGhkci0+cGRfbG93ZXIscGRfdXBwZXLkuLowDQogDQpQbGVhc2UgcHJvdmlkZSBtb3Jl IGRldGFpbHMgb24gdGhlIGNyYXNoIHlvdSBzZWUuICBUaGlzIGRlc2NyaXB0aW9uIGlzDQpub3Qg ZW5vdWdoLg0KIA0KVGhhbmtzLA0KIA0KLS0gDQrDgWx2YXJvIEhlcnJlcmEgICAgICAgICAgICAg ICAgaHR0cDovL3d3dy4ybmRRdWFkcmFudC5jb20vDQpQb3N0Z3JlU1FMIERldmVsb3BtZW50LCAy NHg3IFN1cHBvcnQsIFJlbW90ZSBEQkEsIFRyYWluaW5nICYgU2VydmljZXMNCg==
static void
4071 BackendInitialize(Port *port)
4072 {
4073 int status;
4074 int ret;
4075 char remote_host[NI_MAXHOST];
4076 char remote_port[NI_MAXSERV];
4077 char remote_ps_data[NI_MAXHOST];
4130 /*
4131 * Get the remote host name and port for logging and status display.
4132 */
4133 remote_host[0] = '\0';
4134 remote_port[0] = '\0';
4135 if ((ret = pg_getnameinfo_all(&port->raddr.addr, port->raddr.salen,
4136 remote_host, sizeof(remote_host),
4137 remote_port, sizeof(remote_port),
4138 (log_hostname ? 0 : NI_NUMERICHOST) | NI_NUMERICSERV)) != 0)
4139 ereport(WARNING,
4140 (errmsg_internal("pg_getnameinfo_all() failed: %s",
4141 gai_strerror(ret))));
Modified below, correct?
"zhaozp@uxsino.com" <zhaozp@uxsino.com> writes:
> 4075 char remote_host[NI_MAXHOST];
> 4076 char remote_port[NI_MAXSERV];
> ...
> 4135 if ((ret = pg_getnameinfo_all(&port->raddr.addr, port->raddr.salen,
> 4136 remote_host, sizeof(remote_host),
> 4137 remote_port, sizeof(remote_port),
> 4138 (log_hostname ? 0 : NI_NUMERICHOST) | NI_NUMERICSERV)) != 0)
> Modified below, correct?
> 4136 remote_host, NI_MAXHOST,
> 4137 remote_port, NI_MAXSERV,
Why do you think that's an improvement? The values should be the same,
but the existing code doesn't have a hazard of changing the array size
in one place and failing to change the other.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs