Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAxK1-0000pk-34 for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Apr 2019 13:49:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hAxJy-0007aM-Lp for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Apr 2019 13:49:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAxJx-0007aF-Kl for pgsql-bugs@lists.postgresql.org; Mon, 01 Apr 2019 13:49:54 +0000 Received: from sonic312-25.consmr.mail.ir2.yahoo.com ([77.238.178.96]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAxJu-0004Bs-A1 for pgsql-bugs@lists.postgresql.org; Mon, 01 Apr 2019 13:49:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.fr; s=s2048; t=1554126587; bh=pO/havoY2WvAIFJGRxO2XAGPAUw8tKZylTif4nEP+Vo=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject; b=YFO36cOQ8TqiavIfnQoVRG/y2ylgzK5cVWGkHZGDrh07MkdZOjQb8AOb+J5OZB8b7nuY7l63oTKKCD+t1v2l5Dxx4vZ5mCGeBRfn6r99mMr0jLcAW2ZZpiHAwzGsOPxmx6B1ZLclpnAMaYahwRLQYJsS2cBIUCL1vb9Y4Y0WCK000qZD88Hvpu2iKgBh/G1HjVmjIz302WLnfBYMC1Q7t/4GsD/2oTrzbb45SvPnwtP+RSHV/ppHyDA/jxacESYJ44f5IQ7CCCdAYf8fMHKENR0YR4oMUdsnTodegRSBkF7n7iAJZgJ8b06B4fuTfej4Lz9J5QJIxz4Wibe0YbA/HA== X-YMail-OSG: 5.5xkwAVM1n.90dEat1hH6H4nop3DJu75B6tZxiONfYqSPTd3V0jlPenSAQG5kq i3VCsAsyWxfBTcSmVuw.ZZeUuDkRf7pgfFZ_bGciOqtwpaCyITeUxlYOmI6FUVv2yq5qa8be1F26 Y9rI.MsbRO.lBQG6KiIgJytnnVoW0JKmh5N2xnzgsFTfA1UJfpzBRrw5If3caz6Xs.E2FQ8KvvaC X4iN_2kJCQ7iAJkM6L.S4Yjfq7T_HZZgkl5fOux5Q_7CRv63jJE2TDm3F.Pa9awEseYkS5mrBlgJ IjX.WeebBKn0JOgJLSiG1mh_SoPqQapRembARmGdcAv6bQp8UBTSe22ZghLE7b1iudMieOVvY_NP vQ_vFGvUiNtPt6906wO1yFOKeB5gozqe_nIfwV67Sb2_72mbhcoaBlLNES4zR_ZHLOQbyDzBsKJg edMPerdxCEVHDuvPBaM70RnTvz6Q7PTrVN3UJAHYcAQoQbsuTe8TvKZS9AccG5qjdLuxbDLu8SU_ KMI9362WY6Eiv_3bsBVWWq5qMDYV2gZDjh6t4TpoZdeuLz.wdyAwIWaE6A3XsgcQki5mQFfRLCqg hECgOQRz9g4ETHKUwtaYYkFEsv5ThU4W_40KYTM5A6k35aLjjVPMl96.hhv2sUl6gRKJ.CK_0saZ Ou1U55TgDt.tVn0JudZovmhnd0PTiCY6IqN570G1rkLYoE8YsN7hI6EJLSTT3r4tgwEg0267Vh79 64zweeJUKCGneCP0fsKXzmoCJFuR0I2D3LAiFD.v2hkUzP4tU6l7AHxVixTjgyFROISZ16TojdYT 0ONBqUsmY0RxkFOrzmMEo2M9eroCozRjfniuKmqo66Txmme083ZibiF.6F23JlMQgXVNPjpsbrlH h2VxEw1titjmHRHYCSp9vQrnDXkl9EyJyvfOsEPSpRyMguiDTRDIYTsYZcvEQsofFQh3ri1cXlLL vmaDNrgA4Jbbfvx_i6LpkWyAc6j7xhJ1XcSRHvWmHSf42LseJGlVrz83OivBPtONr3xSTz3s0oB8 DFRCw7esV1rS3MiiX55IRhFtaR9QWOSarv9.RCyDbVd5js9B3s6SZ7OR1LrcpeQjXHWWyIoY- Received: from sonic.gate.mail.ne1.yahoo.com by sonic312.consmr.mail.ir2.yahoo.com with HTTP; Mon, 1 Apr 2019 13:49:47 +0000 Date: Mon, 1 Apr 2019 13:49:44 +0000 (UTC) From: ANASTACIO Tiago To: pgsql-bugs@lists.postgresql.org, Michael Paquier Message-ID: <2034026638.15290913.1554126584507@mail.yahoo.com> In-Reply-To: <20190401132925.GE16093@paquier.xyz> References: <15726-6d67e4fa14f027b3@postgresql.org> <20190401132925.GE16093@paquier.xyz> Subject: Re: BUG #15726: parallel queries failed ERROR: invalid name syntax CONTEXT: parallel worker MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15290912_1168512994.1554126584505" X-Mailer: WebService/1.1.13212 YMailNorrin Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101 Firefox/60.0 Content-Length: 12132 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_15290912_1168512994.1554126584505 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Le lundi 1 avril 2019 =C3=A0 15:29:31 UTC+2, Michael Paquier a =C3=A9crit : =20 =20 On Mon, Apr 01, 2019 at 11:12:16AM +0000, PG Bug reporting form wrote: > appli3=3D# select count(*) from appli3adm.test1; > ERROR:=C2=A0 invalid name syntax > CONTEXT:=C2=A0 parallel worker I cannot reproduce your problem at hand on HEAD or REL_11_STABLE, though I can get the same place as you do.=C2=A0 The error message is very specific to varlena.c or regproc.c, so that's a clear hint, but I am wondering what's wrong. > include_if_exists =3D > '/home/appli3/appli/connexion/dbaappli3/custom/postgresql_custom.conf' Do you have anything specific in that? Thank you.=20 Actually I did not event create this file /home/appli3/appli/connexion/dbaa= ppli3/custom/postgresql_custom.conf=C2=A0=C2=A0=C2=A0 (just set the paramet= er in case of). I put the debug5 logs of potgres above (previous ones where INFO level) Also we use systemd so I launched PostgreSQL with pg_ctl directly : same be= havior (an error) 2019-04-01 15:44:51 CEST [1717]: [14-1] user=3Ddbaappli3,db=3Dappli3,app=3D= psql,xid=3D0,sqlstate=3D00000,client=3D[local] DEBUG:=C2=A0 StartTransactio= n(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: = 0/1/0 2019-04-01 15:44:51 CEST [14860]: [527-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 registering background worker "parallel= worker for PID 1717" 2019-04-01 15:44:51 CEST [14860]: [528-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 registering background worker "parallel= worker for PID 1717" 2019-04-01 15:44:51 CEST [14860]: [529-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 starting background worker process "par= allel worker for PID 1717" 2019-04-01 15:44:51 CEST [14860]: [530-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 starting background worker process "par= allel worker for PID 1717" 2019-04-01 15:44:51 CEST [1833]: [1-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 InitPostgres 2019-04-01 15:44:51 CEST [1833]: [2-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 my backend ID is 4 2019-04-01 15:44:51 CEST [1834]: [1-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 InitPostgres 2019-04-01 15:44:51 CEST [1834]: [2-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 my backend ID is 5 2019-04-01 15:44:51 CEST [1833]: [3-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 StartTransaction(1) name: unnamed; blockSt= ate: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0 2019-04-01 15:44:51 CEST [1834]: [3-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 StartTransaction(1) name: unnamed; blockSt= ate: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0 2019-04-01 15:44:51 CEST [1833]: [4-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 CommitTransaction(1) name: unnamed; blockS= tate: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0 2019-04-01 15:44:51 CEST [1833]: [5-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 StartTransaction(1) name: unnamed; blockSt= ate: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0 2019-04-01 15:44:51 CEST [1834]: [4-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 CommitTransaction(1) name: unnamed; blockS= tate: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0 2019-04-01 15:44:51 CEST [1834]: [5-1] user=3D,db=3D,app=3D,xid=3D0,sqlstat= e=3D00000,client=3D DEBUG:=C2=A0 StartTransaction(1) name: unnamed; blockSt= ate: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0 2019-04-01 13:44:51.603 GMT [1833] ERROR:=C2=A0 invalid name syntax 2019-04-01 15:44:51 CEST [1717]: [15-1] user=3Ddbaappli3,db=3Dappli3,app=3D= psql,xid=3D0,sqlstate=3D42602,client=3D[local] ERROR:=C2=A0 invalid name sy= ntax 2019-04-01 15:44:51 CEST [1717]: [16-1] user=3Ddbaappli3,db=3Dappli3,app=3D= psql,xid=3D0,sqlstate=3D42602,client=3D[local] CONTEXT:=C2=A0 parallel work= er 2019-04-01 15:44:51 CEST [1717]: [17-1] user=3Ddbaappli3,db=3Dappli3,app=3D= psql,xid=3D0,sqlstate=3D42602,client=3D[local] STATEMENT:=C2=A0 select coun= t(*) from appli3adm.test1; 2019-04-01 13:44:51.604 GMT [1834] ERROR:=C2=A0 invalid name syntax 2019-04-01 15:44:51 CEST [14860]: [531-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 reaping dead processes 2019-04-01 15:44:51 CEST [14860]: [532-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 unregistering background worker "parall= el worker for PID 1717" 2019-04-01 15:44:51 CEST [14860]: [533-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D LOG:=C2=A0 background worker "parallel worker" (PID = 1833) exited with exit code 1 2019-04-01 15:44:51 CEST [14860]: [534-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 reaping dead processes 2019-04-01 15:44:51 CEST [14860]: [535-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D DEBUG:=C2=A0 unregistering background worker "parall= el worker for PID 1717" 2019-04-01 15:44:51 CEST [14860]: [536-1] user=3D,db=3D,app=3D,xid=3D0,sqls= tate=3D00000,client=3D LOG:=C2=A0 background worker "parallel worker" (PID = 1834) exited with exit code 1 =20 ------=_Part_15290912_1168512994.1554126584505 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

=
=20
Le lundi 1 avril 2019 =C3=A0 15:29:31 UTC+2, Michael Pa= quier <michael@paquier.xyz> a =C3=A9crit :


On Mon, Apr 01, 2019 at 11:12:16AM +0000, PG Bug repor= ting form wrote:
> appli3=3D# select count(*) from appli3adm.test1;> ERROR:  invalid name syntax
> CONTEXT:  parallel wor= ker

I cannot reproduce your problem at hand on HEAD or REL_11_STABLE= ,
though I can get the same place as you do.  The error message is = very
specific to varlena.c or regproc.c, so that's a clear hint, but I a= m
wondering what's wrong.

> include_if_exists =3D
> '/ho= me/appli3/appli/connexion/dbaappli3/custom/postgresql_custom.conf'

D= o you have anything specific in that?



Thank you.

Actually I did not event create this fil= e /home/appli3/appli/connexion/dbaappli3/custom/postgresql_custom.con= f    (just set the parameter in case of).

I put the debug5 logs of potgres above (previous ones whe= re INFO level)

Also we use systemd so I launched P= ostgreSQL with pg_ctl directly : same behavior (an error)
2019-04-01 15:44:51 CEST [1717]: [14-1]=20 user=3Ddbaappli3,db=3Dappli3,app=3Dpsql,xid=3D0,sqlstate=3D00000,client=3D[= local]=20 DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state:= =20 INPROGRESS, xid/subid/cid: 0/1/0
2019-04-01 15:44:51 CEST [14860]:=20 [527-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG: = ; registering=20 background worker "parallel worker for PID 1717"
2019-04-01 15:44:51=20 CEST [14860]: [528-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client= =3D=20 DEBUG:  registering background worker "parallel worker for PID 1717"2019-04-01 15:44:51 CEST [14860]: [529-1]=20 user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG:  starti= ng background=20 worker process "parallel worker for PID 1717"
2019-04-01 15:44:51=20 CEST [14860]: [530-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client= =3D=20 DEBUG:  starting background worker process "parallel worker for PID=20 1717"
2019-04-01 15:44:51 CEST [1833]: [1-1] user=3D,db=3D,app=3D,xid=3D= 0,sqlstate=3D00000,client=3D DEBUG:  InitPostgres
2019-04-01 15:44:= 51 CEST [1833]: [2-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client= =3D DEBUG:  my backend ID is 4
2019-04-01 15:44:51 CEST [1834]: [1-= 1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG:  Ini= tPostgres
2019-04-01 15:44:51 CEST [1834]: [2-1] user=3D,db=3D,app=3D,xi= d=3D0,sqlstate=3D00000,client=3D DEBUG:  my backend ID is 5
2019-04= -01 15:44:51 CEST [1833]: [3-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,= client=3D DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state= :=20 INPROGRESS, xid/subid/cid: 0/1/0
2019-04-01 15:44:51 CEST [1834]:=20 [3-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG: = =20 StartTransaction(1) name: unnamed; blockState: DEFAULT; state:=20 INPROGRESS, xid/subid/cid: 0/1/0
2019-04-01 15:44:51 CEST [1833]:=20 [4-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG: = =20 CommitTransaction(1) name: unnamed; blockState: STARTED; state:=20 INPROGRESS, xid/subid/cid: 0/1/0
2019-04-01 15:44:51 CEST [1833]:=20 [5-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG: = =20 StartTransaction(1) name: unnamed; blockState: DEFAULT; state:=20 INPROGRESS, xid/subid/cid: 0/1/0
2019-04-01 15:44:51 CEST [1834]:=20 [4-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG: = =20 CommitTransaction(1) name: unnamed; blockState: STARTED; state:=20 INPROGRESS, xid/subid/cid: 0/1/0
2019-04-01 15:44:51 CEST [1834]:=20 [5-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG: = =20 StartTransaction(1) name: unnamed; blockState: DEFAULT; state:=20 INPROGRESS, xid/subid/cid: 0/1/0
2019-04-01 13:44:51.603 GMT [1833] ERRO= R:  invalid name syntax
2019-04-01 15:44:51 CEST [1717]: [15-1]=20 user=3Ddbaappli3,db=3Dappli3,app=3Dpsql,xid=3D0,sqlstate=3D42602,client=3D[= local]=20 ERROR:  invalid name syntax
2019-04-01 15:44:51 CEST [1717]: [16-1]= =20 user=3Ddbaappli3,db=3Dappli3,app=3Dpsql,xid=3D0,sqlstate=3D42602,client=3D[= local]=20 CONTEXT:  parallel worker
2019-04-01 15:44:51 CEST [1717]: [17-1]= =20 user=3Ddbaappli3,db=3Dappli3,app=3Dpsql,xid=3D0,sqlstate=3D42602,client=3D[= local]=20 STATEMENT:  select count(*) from appli3adm.test1;
2019-04-01 13:44:= 51.604 GMT [1834] ERROR:  invalid name syntax
2019-04-01 15:44:51 C= EST [14860]: [531-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client= =3D DEBUG:  reaping dead processes
2019-04-01 15:44:51 CEST [14860]: [532-1]=20 user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG:  unregi= stering=20 background worker "parallel worker for PID 1717"
2019-04-01 15:44:51=20 CEST [14860]: [533-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client= =3D LOG: =20 background worker "parallel worker" (PID 1833) exited with exit code 1
2= 019-04-01 15:44:51 CEST [14860]: [534-1] user=3D,db=3D,app=3D,xid=3D0,sqlst= ate=3D00000,client=3D DEBUG:  reaping dead processes
2019-04-01 15:44:51 CEST [14860]: [535-1]=20 user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client=3D DEBUG:  unregi= stering=20 background worker "parallel worker for PID 1717"
2019-04-01 15:44:51=20 CEST [14860]: [536-1] user=3D,db=3D,app=3D,xid=3D0,sqlstate=3D00000,client= =3D LOG: =20 background worker "parallel worker" (PID 1834) exited with exit code 1
------=_Part_15290912_1168512994.1554126584505--