Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data

On Mon, Nov 1, 2021 at 7:47 PM Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Mon, Nov 1, 2021 at 9:33 AM Sandeep Thakkar
> <sandeep(dot)thakkar(at)enterprisedb(dot)com> wrote:
> > (gdb) p tupdesc1->attrs[1]
> > No symbol "tupdesc1" in current context.
> > (gdb) p tupdesc1->attrs[2]
> > No symbol "tupdesc1" in current context.
> > (gdb) p tupdesc2->attrs[0]
> > No symbol "tupdesc2" in current context.
> > (gdb) p tupdesc2->attrs[1]
> > No symbol "tupdesc2" in current context.
> > (gdb)
>
> I think you need to select stack frame 1 before running these
> commands. I believe just running "frame 1" before you run these print
> commands should do the trick.
>
> Thanks Robert, that worked. Here is the output:

(gdb) frame 1

#1 0x40000000003fdc00:0 in equalTupleDescs (tupdesc1=0x60000000001f65e0,

tupdesc2=0x60000000001fba08)

(gdb) p tupdesc1->attrs[0]

$1 = {attrelid = 27272, attname = {

data = "initial", '\000' <repeats 56 times>}, atttypid = 23,

attstattarget = -1, attlen = 4, attnum = 1, attndims = 0, attcacheoff = 0,

atttypmod = -1, attbyval = true, attalign = 105 'i', attstorage = 112 'p',

attcompression = 0 '\000', attnotnull = false, atthasdef = false,

atthasmissing = false, attidentity = 0 '\000', attgenerated = 0 '\000',

attisdropped = false, attislocal = true, attinhcount = 0, attcollation =
0}

(gdb) p tupdesc1->attrs[1]

$2 = {attrelid = 27272, attname = {data = "a", '\000' <repeats 62 times>},

atttypid = 23, attstattarget = -1, attlen = 4, attnum = 2, attndims = 0,

attcacheoff = -1, atttypmod = -1, attbyval = true, attalign = 105 'i',

attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,

atthasdef = true, atthasmissing = true, attidentity = 0 '\000',

attgenerated = 0 '\000', attisdropped = false, attislocal = true,

attinhcount = 0, attcollation = 0}

(gdb) p tupdesc1->attrs[2]

$3 = {attrelid = 27272, attname = {data = "b", '\000' <repeats 62 times>},

atttypid = 19, attstattarget = -1, attlen = 64, attnum = 3, attndims = 0,

attcacheoff = -1, atttypmod = -1, attbyval = false, attalign = 99 'c',

attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,

atthasdef = false, atthasmissing = false, attidentity = 0 '\000',

attgenerated = 0 '\000', attisdropped = false, attislocal = true,

attinhcount = 0, attcollation = 950}

(gdb) p tupdesc2->attrs[0]

$4 = {attrelid = 27272, attname = {

data = "initial", '\000' <repeats 56 times>}, atttypid = 23,

attstattarget = -1, attlen = 4, attnum = 1, attndims = 0, attcacheoff = 0,

atttypmod = -1, attbyval = true, attalign = 105 'i', attstorage = 112 'p',

attcompression = 0 '\000', attnotnull = false, atthasdef = false,

atthasmissing = false, attidentity = 0 '\000', attgenerated = 0 '\000',

attisdropped = false, attislocal = true, attinhcount = 0, attcollation =
0}

(gdb) p tupdesc2->attrs[1]

$5 = {attrelid = 27272, attname = {data = "a", '\000' <repeats 62 times>},

atttypid = 23, attstattarget = -1, attlen = 4, attnum = 2, attndims = 0,

attcacheoff = -1, atttypmod = -1, attbyval = true, attalign = 105 'i',

attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,

atthasdef = true, atthasmissing = true, attidentity = 0 '\000',

attgenerated = 0 '\000', attisdropped = false, attislocal = true,

attinhcount = 0, attcollation = 0}

(gdb) p tupdesc2->attrs[2]

$6 = {attrelid = 27272, attname = {data = "b", '\000' <repeats 62 times>},

atttypid = 19, attstattarget = -1, attlen = 64, attnum = 3, attndims = 0,

attcacheoff = -1, atttypmod = -1, attbyval = false, attalign = 99 'c',

attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,

atthasdef = false, atthasmissing = false, attidentity = 0 '\000',

attgenerated = 0 '\000', attisdropped = false, attislocal = true,

attinhcount = 0, attcollation = 950}

> (gdb)

>

--
> Robert Haas
> EDB: http://www.enterprisedb.com
>

--
Sandeep Thakkar