Re: [HACKERS] Deadlock in XLogInsert at AIX
Noah Misch <noah@leadboat.com>
From: Noah Misch <noah@leadboat.com>
To: "REIX, Tony" <tony.reix@atos.net>
Cc: Michael Paquier <michael.paquier@gmail.com>, Heikki Linnakangas <hlinnaka@iki.fi>, Konstantin Knizhnik <k.knizhnik@postgrespro.ru>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Bernd Helmle <mailings@oopsware.de>, "OLIVA, PASCAL" <pascal.oliva@atos.net>, "EMPEREUR-MOT, SYLVIE" <sylvie.empereur-mot@atos.net>
Date: 2018-01-16T16:19:39Z
Lists: pgsql-hackers
On Tue, Jan 16, 2018 at 01:50:29PM +0000, REIX, Tony wrote: > And, on BuildFarm, I do not see any details about the logical/physical configuration of the AIX VMs, like hornet. > Being able to run real concurrent parallel stress programs, thus required multi-physical-CPU VM, would help. It has 48 virtual CPUs. Here's the prtconf output: System Model: IBM,8231-E2C Machine Serial Number: 104C0CT Processor Type: PowerPC_POWER7 Processor Implementation Mode: POWER 7 Processor Version: PV_7_Compat Number Of Processors: 12 Processor Clock Speed: 3720 MHz CPU Type: 64-bit Kernel Type: 64-bit LPAR Info: 1 10-4C0CT Memory Size: 127488 MB Good Memory Size: 127488 MB Platform Firmware level: AL740_100 Firmware Version: IBM,AL740_100 Console Login: enable Auto Restart: true Full Core: false NX Crypto Acceleration: Not Capable Network Information Host Name: power-aix IP Address: 140.211.15.154 Sub Netmask: 255.255.255.0 Gateway: 140.211.15.1 Name Server: 140.211.166.130 Domain Name: osuosl.org Paging Space Information Total Paging Space: 12288MB Percent Used: 1% Volume Groups Information ============================================================================== Active VGs ============================================================================== homevg: PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION hdisk1 active 558 183 00..00..00..71..112 hdisk2 active 558 0 00..00..00..00..00 hdisk3 active 558 0 00..00..00..00..00 hdisk4 active 558 0 00..00..00..00..00 ============================================================================== rootvg: PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION hdisk0 active 558 510 111..93..83..111..112 hdisk5 active 558 514 111..97..83..111..112 ============================================================================== INSTALLED RESOURCE LIST The following resources are installed on the machine. +/- = Added or deleted from Resource List. * = Diagnostic support not available. Model Architecture: chrp Model Implementation: Multiple Processor, PCI bus + sys0 System Object + sysplanar0 System Planar * vio0 Virtual I/O Bus * vsa2 U78AB.001.WZSHZY0-P1-T2 LPAR Virtual Serial Adapter * vty2 U78AB.001.WZSHZY0-P1-T2-L0 Asynchronous Terminal * vsa1 U78AB.001.WZSHZY0-P1-T1 LPAR Virtual Serial Adapter * vty1 U78AB.001.WZSHZY0-P1-T1-L0 Asynchronous Terminal * vsa0 U8231.E2C.104C0CT-V1-C0 LPAR Virtual Serial Adapter * vty0 U8231.E2C.104C0CT-V1-C0-L0 Asynchronous Terminal * pci8 U78AB.001.WZSHZY0-P1 PCI Express Bus * pci7 U78AB.001.WZSHZY0-P1 PCI Express Bus * pci6 U78AB.001.WZSHZY0-P1 PCI Express Bus * pci5 U78AB.001.WZSHZY0-P1 PCI Express Bus * pci4 U78AB.001.WZSHZY0-P1 PCI Express Bus * pci10 U78AB.001.WZSHZY0-P1-C2 PCI Bus + cor0 U78AB.001.WZSHZY0-P1-C2-T1 GXT145 Graphics Adapter * pci3 U78AB.001.WZSHZY0-P1 PCI Express Bus + ent0 U78AB.001.WZSHZY0-P1-C7-T1 4-Port Gigabit Ethernet PCI-Express Adapter (e414571614102004) + ent1 U78AB.001.WZSHZY0-P1-C7-T2 4-Port Gigabit Ethernet PCI-Express Adapter (e414571614102004) + ent2 U78AB.001.WZSHZY0-P1-C7-T3 4-Port Gigabit Ethernet PCI-Express Adapter (e414571614102004) + ent3 U78AB.001.WZSHZY0-P1-C7-T4 4-Port Gigabit Ethernet PCI-Express Adapter (e414571614102004) * pci2 U78AB.001.WZSHZY0-P1 PCI Express Bus * pci1 U78AB.001.WZSHZY0-P1 PCI Express Bus * pci9 U78AB.001.WZSHZY0-P1 PCI Bus + usbhc0 U78AB.001.WZSHZY0-P1 USB Host Controller (33103500) + usbhc1 U78AB.001.WZSHZY0-P1 USB Host Controller (33103500) + usbhc2 U78AB.001.WZSHZY0-P1 USB Enhanced Host Controller (3310e000) * pci0 U78AB.001.WZSHZY0-P1 PCI Express Bus + sissas0 U78AB.001.WZSHZY0-P1-T9 PCIe x4 Planar 3Gb SAS Adapter * sas0 U78AB.001.WZSHZY0-P1-T9 Controller SAS Protocol * sfwcomm0 SAS Storage Framework Comm + hdisk0 U78AB.001.WZSHZY0-P3-D1 SAS Disk Drive (600000 MB) + hdisk1 U78AB.001.WZSHZY0-P3-D2 SAS Disk Drive (600000 MB) + hdisk2 U78AB.001.WZSHZY0-P3-D3 SAS Disk Drive (600000 MB) + hdisk3 U78AB.001.WZSHZY0-P3-D4 SAS Disk Drive (600000 MB) + hdisk4 U78AB.001.WZSHZY0-P3-D5 SAS Disk Drive (600000 MB) + hdisk5 U78AB.001.WZSHZY0-P3-D6 SAS Disk Drive (600000 MB) + ses0 U78AB.001.WZSHZY0-P2-Y1 SAS Enclosure Services Device + ses1 U78AB.001.WZSHZY0-P2-Y1 SAS Enclosure Services Device * sata0 U78AB.001.WZSHZY0-P1-T9 Controller SATA Protocol + cd0 U78AB.001.WZSHZY0-P3-D7 SATA DVD-RAM Drive + L2cache0 L2 Cache + mem0 Memory + proc0 Processor + proc4 Processor + proc8 Processor + proc12 Processor + proc16 Processor + proc20 Processor + proc24 Processor + proc28 Processor + proc32 Processor + proc36 Processor + proc40 Processor + proc44 Processor
Commits
-
For all ppc compilers, implement compare_exchange and fetch_add with asm.
- 30ee5d17c20d 13.0 landed
-
For PowerPC instruction "addi", use constraint "b".
- 930787c7fab9 9.4.25 landed
- af4477b00cf9 11.6 landed
- 62e881946c4d 9.5.20 landed
- 09d74aef33de 9.6.16 landed
- 083929372e04 10.11 landed
- ef13f914e6c2 12.1 landed
- 89b4d7744c80 13.0 landed
-
For all ppc compilers, implement pg_atomic_fetch_add_ with inline asm.
- e7ff59686eac 13.0 landed
-
Replace xlc __fetch_and_add() with inline asm.
- a1df9a015dac 9.6.16 landed
- 8972ac696665 10.11 landed
- 75941f257aac 9.5.20 landed
- 40ad4202513c 11.6 landed
- 1c6b62a7d0e5 12.0 landed
- dd50f1a43290 13.0 landed
-
Test pg_atomic_fetch_add_ with variable addend and 16-bit edge cases.
- e6a90ded5a6c 10.11 landed
- 8d32f82cbbbb 9.6.16 landed
- 4737d3a75b72 9.5.20 landed
- 5b5b0f721d9c 12.0 landed
- 585fc561f824 11.6 landed
- f380c5190134 13.0 landed