On Fri, 28 Nov 2014 16:56:01 +0100 Misa Simic <misa.simic@xxxxxxxxx> wrote: > Hi all, Hello, on Debian Sid and all works fine. postgresql-9.4: Installed: 9.4~rc1-1.pgdg+1 from http://apt.postgresql.org/ plv8js from https://code.google.com/p/plv8js/ > > We have found a strange problem with plv8 functions in PG94RC1 > > PG 9.3 works fine. > > in PG94RC1 in plv8 functions regardless what function does i.e.nothing > > CREATE OR REPLACE FUNCTION test.test_text_length_plv8(in_param1 text) > RETURNS text > AS > $BODY$ > return 'OK' > $BODY$ LANGUAGE plv8; > > if length of in_param1 is higher then (or equal to) 200 characters > connection just brake... current connection and it brakes - other > connections as well... Not sure what it does - but all sessions just > says server disconnected and we need and can reconect again.... > > ie. > SELECT test.test_text_length_plv8('aaaa') works fine > > SELECT > test.test_text_length_plv8('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa') > > exactly 200 chars - just brake conncetion witout any message...but in > separate session when we run next command it says: > > WARNING: terminating connection because of crash of another server > process DETAIL: The postmaster has commanded this server process to > roll back the current transaction and exit, because another server > process exited abnormally and possibly corrupted shared memory. > HINT: In a moment you should be able to reconnect to the database and > repeat your command. > > We have tested using pgadmin and psql... > > Versions: > PostgreSQL 9.4rc1 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu > 4.9.1-16ubuntu6) 4.9.1, 64-bit > plv8: 1.5.0-dev1 > > The same version of plv8 on PG9.3 - works fine without problems... > > Any suggestions? > > Thanks, > > Misa > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
