RE: psql crashes found when executing slash commands - Mailing list pgsql-bugs

From K S, Sandhya (Nokia - IN/Bangalore)
Subject RE: psql crashes found when executing slash commands
Date
Msg-id VI1PR0702MB3693E6D94EB2E6C991891070D67E0@VI1PR0702MB3693.eurprd07.prod.outlook.com
Whole thread Raw
In response to RE: psql crashes found when executing slash commands  ("K S, Sandhya (Nokia - IN/Bangalore)" <sandhya.k_s@nokia.com>)
Responses Re: psql crashes found when executing slash commands  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi,

The issue was with the version of flex(not sure any issue with flex 2.5.37 version).
We were able to compile with flex version 2.6.4 and it is working without any psql crashes.

Thanks for all the help!

Sandhya

-----Original Message-----
From: K S, Sandhya (Nokia - IN/Bangalore)
Sent: Monday, June 11, 2018 11:14 AM
To: 'Tom Lane' <tgl@sss.pgh.pa.us>; Michael Paquier <michael@paquier.xyz>
Cc: Sergei Kornilov <sk@zsrv.org>; 'pgsql-bugs@postgresql.org' <pgsql-bugs@postgresql.org>
Subject: RE: psql crashes found when executing slash commands

Hi,

We are using a flavour of Linux internally developed. We are compiling for mips architecture.
We compile postgresql.

We tried compiling for different versions of flex apart from the what is installed and still we are not able to succeed
inthis. 
Currently we are using flex version 2.5.37.

Any further suggestion or known issue, please let us know.

Regards,
Sandhya

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, June 06, 2018 8:18 PM
To: Michael Paquier <michael@paquier.xyz>
Cc: Sergei Kornilov <sk@zsrv.org>; K S, Sandhya (Nokia - IN/Bangalore) <sandhya.k_s@nokia.com>;
'pgsql-bugs@postgresql.org'<pgsql-bugs@postgresql.org> 
Subject: Re: psql crashes found when executing slash commands

Michael Paquier <michael@paquier.xyz> writes:
> On Wed, Jun 06, 2018 at 10:42:41AM +0300, Sergei Kornilov wrote:
>> Hmm. What operating system are you using? Hardware architecture? Do
>> you compile postgresql yourself or install some precompiled packages?
>> We have tests for psql slash-commands and they are not broken.

> My bet is on an issue with the version of flex used for compilation, and
> that those binaries have been manually compiled.

psql does some, um, interesting stuff with sharing lexer state between
separately-built flex lexers.  I would not be too surprised if it crashes
if you build psqlscan.l and psqlscanslash.l with different versions of
flex, or perhaps even just different flex switches.  So that might be an
avenue to check into.

Another theory is that the OP is using something that's not flex at all,
or is some version we've never seen before, and this coding technique
doesn't work at all with it :-(

            regards, tom lane


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15240: JDBC driver sometimes hangs on copy out; suspect Json
Next
From: Amit Langote
Date:
Subject: Re: BUG #15212: Default values in partition tables don't work asexpected and allow NOT NULL violation