RE:[HACKERS] Deadlock in XLogInsert at AIX
REIX, Tony <tony.reix@atos.net>
From: "REIX, Tony" <tony.reix@atos.net>
To: Noah Misch <noah@leadboat.com>
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:44:11Z
Lists: pgsql-hackers
Thanks Noah !
Hummm You have a big machine, more powerful than mine. However, it seems that you do not see the random failure I see.
Cordialement,
Tony Reix
ATOS / Bull SAS
ATOS Expert
IBM Coop Architect & Technical Leader
Office : +33 (0) 4 76 29 72 67
1 rue de Provence - 38432 Échirolles - France
www.atos.net
________________________________________
De : Noah Misch [noah@leadboat.com]
Envoyé : mardi 16 janvier 2018 17:19
À : REIX, Tony
Cc : Michael Paquier; Heikki Linnakangas; Konstantin Knizhnik; PostgreSQL Hackers; Bernd Helmle; OLIVA, PASCAL; EMPEREUR-MOT, SYLVIE
Objet : Re: [HACKERS] Deadlock in XLogInsert at AIX
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