Re: pg11.1: dsa_area could not attach to segment

Hi

> I think this is tentatively confirmed..I ran 20 loops for over 90 minutes with
> no crash when parallel_leader_participation=off.
>
> On enabling parallel_leader_participation, crash within 10min.
>
> Sergei, could you confirm ?

I still have error with parallel_leader_participation = off. One difference is time: with parallel_leader_participation
=on i have error after minute-two, with off - error was after 20 min.
 

My desktop is 
- debian testing with actual updates, 4.19.0-2-amd64 #1 SMP Debian 4.19.16-1 (2019-01-17) x86_64 GNU/Linux
- gcc version 8.2.0 (Debian 8.2.0-16)
- i build fresh REL_11_STABLE postgresql with  ./configure --enable-cassert --enable-debug CFLAGS="-ggdb -Og -g3
-fno-omit-frame-pointer"--enable-tap-tests --prefix=/...
 

Can't provide dsa_dump(area) due recursion. With such dirty hack:

             fprintf(stderr,
-                    "    segment bin %zu (at least %d contiguous pages free):\n",
-                    i, 1 << (i - 1));
-            segment_index = area->control->segment_bins[i];
-            while (segment_index != DSA_SEGMENT_INDEX_NONE)
-            {
-                dsa_segment_map *segment_map;
-
-                segment_map =
-                    get_segment_by_index(area, segment_index);
-
-                fprintf(stderr,
-                        "      segment index %zu, usable_pages = %zu, "
-                        "contiguous_pages = %zu, mapped at %p\n",
-                        segment_index,
-                        segment_map->header->usable_pages,
-                        fpm_largest(segment_map->fpm),
-                        segment_map->mapped_address);
-                segment_index = segment_map->header->next;
-            }
+                    "    segment bin %zu (at least %d contiguous pages free), segment_index=%zu\n",
+                    i, 1 << (i - 1), area->control->segment_bins[i]);

i have result:

dsa_area handle 0:
  max_total_segment_size: 18446744073709551615
  total_segment_size: 2105344
  refcnt: 2
  pinned: f
  segment bins:
    segment bin 0 (at least -2147483648 contiguous pages free), segment_index=0
    segment bin 3 (at least 4 contiguous pages free), segment_index=1
    segment bin 8 (at least 128 contiguous pages free), segment_index=2
  pools:
    pool for blocks of span objects:
      fullness class 0 is empty
      fullness class 1:
        span descriptor at 0000010000001000, superblock at 0000010000001000, pages = 1, objects free = 54/72
      fullness class 2 is empty
      fullness class 3 is empty
    pool for large object spans:
      fullness class 0 is empty
      fullness class 1:
        span descriptor at 00000100000013b8, superblock at 0000020000009000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001380, superblock at 0000020000001000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001348, superblock at 00000100000f2000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001310, superblock at 00000100000ea000, pages = 8, objects free = 0/0
        span descriptor at 00000100000012d8, superblock at 00000100000e2000, pages = 8, objects free = 0/0
        span descriptor at 00000100000012a0, superblock at 00000100000da000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001268, superblock at 00000100000d2000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001230, superblock at 00000100000ca000, pages = 8, objects free = 0/0
        span descriptor at 00000100000011f8, superblock at 00000100000c2000, pages = 8, objects free = 0/0
        span descriptor at 00000100000011c0, superblock at 00000100000ba000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001188, superblock at 00000100000b2000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001150, superblock at 00000100000aa000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001118, superblock at 00000100000a2000, pages = 8, objects free = 0/0
        span descriptor at 00000100000010e0, superblock at 000001000009a000, pages = 8, objects free = 0/0
        span descriptor at 00000100000010a8, superblock at 0000010000092000, pages = 8, objects free = 0/0
        span descriptor at 0000010000001070, superblock at 0000010000012000, pages = 128, objects free = 0/0
      fullness class 2 is empty
      fullness class 3 is empty
    pool for size class 32 (object size 3640 bytes):
      fullness class 0 is empty
      fullness class 1:
        span descriptor at 0000010000001038, superblock at 0000010000002000, pages = 16, objects free = 17/18
      fullness class 2 is empty
      fullness class 3 is empty

"at least -2147483648" seems surprise.


melkij@melkij:~$ LANG=C ls -lt /dev/shm
total 0
-rw------- 1 melkij melkij 4194304 Feb 12 11:56 PostgreSQL.1822959854

only one segment, restart_after_crash = off and no more postgresql instances running.

regards, Sergei