| From: | Jakub Glapa <jakub(dot)glapa(at)gmail(dot)com> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Rick Otten <rottenwindfish(at)gmail(dot)com>, Sand Stone <sand(dot)m(dot)stone(at)gmail(dot)com>, Fabio Isabettini <fisabettini(at)voipfuture(dot)com>, Arne Roland <A(dot)Roland(at)index(dot)de>, Maksim Milyutin <milyutinmagmailcom(at)telsasoft(dot)com>, Sergei Kornilov <sk(at)zsrv(dot)org> |
| Subject: | Re: pg11.1: dsa_area could not attach to segment |
| Date: | 2019-02-06 17:37:16 |
| Message-ID: | CAJk1zg37feGXNxid8fNGQ5C6G-Xz0UtCTNV_6UiZnAvEEMRNvQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Justin
I'm seeing dsa_allocate on two different servers.
One is virtualized with VMWare the other is bare metal.
ubuntu(at)db1:~$ grep dsa_allocate /var/log/postgresql/postgresql-11-main.log
2019-02-03 17:03:03 CET:192.168.10.83(48336):foo(at)bar:[27979]: FATAL:
dsa_allocate could not find 7 free pages
2019-02-05 17:05:12 CET:192.168.10.83(38138):foo(at)bar:[2725]: FATAL:
dsa_allocate could not find 49 free pages
2019-02-06 09:04:18 CET::@:[22120]: FATAL: dsa_allocate could not find 13
free pages
2019-02-06 09:04:18 CET:192.168.10.83(55740):foo(at)bar:[21725]: ERROR:
dsa_allocate could not find 13 free pages
ubuntu(at)db1:~$ sudo dmidecode -s system-product-name
VMware Virtual Platform
----------------------------------
ubuntu(at)db2:~$ grep dsa_allocate /var/log/postgresql/postgresql-11-main2.log
2019-02-03 07:45:45 CET::@:[28592]: FATAL: dsa_allocate could not find 25
free pages
2019-02-03 07:45:45 CET:127.0.0.1(41920):foo1(at)bar:[27320]: ERROR:
dsa_allocate could not find 25 free pages
2019-02-03 07:46:03 CET:127.0.0.1(41920):foo1(at)bar:[27320]: FATAL:
dsa_allocate could not find 25 free pages
2019-02-04 11:56:28 CET::@:[31713]: FATAL: dsa_allocate could not find 7
free pages
2019-02-04 11:56:28 CET:127.0.0.1(41950):foo1(at)bar:[30465]: ERROR:
dsa_allocate could not find 7 free pages
2019-02-04 11:57:59 CET::@:[31899]: FATAL: dsa_allocate could not find 7
free pages
2019-02-04 11:57:59 CET:127.0.0.1(44096):foo1(at)bar:[31839]: ERROR:
dsa_allocate could not find 7 free pages
ubuntu(at)db2:~$ sudo dmidecode -s system-product-name
ProLiant DL380 Gen9
--
regards,
pozdrawiam,
Jakub Glapa
On Wed, Feb 6, 2019 at 6:19 PM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> On Wed, Feb 06, 2019 at 04:22:12PM +1100, Thomas Munro wrote:
> > Can anyone else who has hit this comment on any virtualisation they
> > might be using?
>
> I don't think most of these people are on -hackers (one of the original
> reports
> was on -performance) so I'm copying them now.
>
> Could you let us know which dsa_* error you were seeing, whether or not you
> were running postgres under virtual environment, and (if so) which VM
> hypervisor?
>
> Thanks,
> Justin
>
>
> https://www.postgresql.org/message-id/flat/CAMAYy4%2Bw3NTBM5JLWFi8twhWK4%3Dk_5L4nV5%2BbYDSPu8r4b97Zg%40mail.gmail.com
>
> https://www.postgresql.org/message-id/flat/CAEepm%3D0aPq2yEy39gEqVK2m_Qi6jJdy96ysHGJ6VSHOZFz%2Bxbg%40mail.gmail.com#e02bee0220b422fe91a3383916107504
>
> https://www.postgresql.org/message-id/20181231221734.GB25379%40telsasoft.com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergei Kornilov | 2019-02-06 17:52:48 | Re: pg11.1: dsa_area could not attach to segment |
| Previous Message | Alvaro Herrera | 2019-02-06 17:32:12 | Re: ALTER INDEX fails on partitioned index |