Re: [HACKERS] Deadlock in XLogInsert at AIX

From: Noah Misch <noah(at)leadboat(dot)com>
To: "REIX, Tony" <tony(dot)reix(at)atos(dot)net>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Bernd Helmle <mailings(at)oopsware(dot)de>, "OLIVA, PASCAL" <pascal(dot)oliva(at)atos(dot)net>, "EMPEREUR-MOT, SYLVIE" <sylvie(dot)empereur-mot(at)atos(dot)net>
Subject: Re: [HACKERS] Deadlock in XLogInsert at AIX
Date: 2018-01-16 16:19:39
Message-ID: 20180116161939.GA3872798@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2018-01-16 16:42:51 Re: New gist vacuum.
Previous Message Adam Brightwell 2018-01-16 15:54:36 Re: PATCH: Exclude unlogged tables from base backups