Hi All,
I am using Thinking sphinx version 1.3.18. And it is working fine
but I found that it record following error in log file ( development
or production )
SQL (0.3ms) SET client_min_messages TO 'panic'
SQL (0.3ms) SET client_min_messages TO 'notice'
SQL (0.3ms) begin
SQL (0.2ms) savepoint ts
SQL (0.0ms) PGError: ERROR: Function/Procedure "array_accum"
already exists with same argument types
: CREATE AGGREGATE array_accum (anyelement)
(
sfunc = array_append,
stype = anyarray,
initcond = '{}'
);
SQL (0.2ms) rollback to savepoint ts
SQL (0.2ms) release savepoint ts
SQL (0.2ms) commit
SQL (0.2ms) begin
SQL (0.2ms) savepoint ts
SQL (0.0ms) PGError: ERROR: language "plpgsql" already exists
: CREATE LANGUAGE 'plpgsql';
SQL (0.2ms) rollback to savepoint ts
SQL (0.3ms) release savepoint ts
SQL (0.2ms) commit
SQL (0.2ms) begin
SQL (0.2ms) savepoint ts
SQL (2.1ms) CREATE OR REPLACE FUNCTION crc32(word text)
RETURNS bigint AS $$
DECLARE tmp bigint;
DECLARE i int;
DECLARE j int;
DECLARE word_array bytea;
BEGIN
i = 0;
tmp = 4294967295;
word_array = decode(replace(word, E'\\', E'\\\\'), 'escape');
LOOP
tmp = (tmp # get_byte(word_array, i))::bigint;
i = i + 1;
j = 0;
LOOP
tmp = ((tmp >> 1) # (3988292384 * (tmp & 1)))::bigint;
j = j + 1;
IF j >= 8 THEN
EXIT;
END IF;
END LOOP;
IF i >= char_length(word) THEN
EXIT;
END IF;
END LOOP;
return (tmp # 4294967295);
END
$$ IMMUTABLE STRICT LANGUAGE plpgsql;
SQL (0.2ms) release savepoint ts
SQL (18.6ms) commit
SQL (0.3ms) begin
SQL (0.3ms) savepoint ts
SQL (0.0ms) PGError: ERROR: Function/Procedure "array_accum"
already exists with same argument types
: CREATE AGGREGATE array_accum (anyelement)
(
sfunc = array_append,
stype = anyarray,
initcond = '{}'
);
04]: SQL (0.2ms) commit
Sep 29 16:02:28 userver01 rails[16004]: SQL (0.2ms) begin
Sep 29 16:02:28 userver01 rails[16004]: SQL (0.1ms) savepoint ts
Sep 29 16:02:28 userver01 rails[16004]: SQL (207.4ms) CREATE OR
REPLACE FUNCTION crc32(word text) RETURNS bigint AS $$ DECLARE tmp
bigint; DECLARE i int; DECLARE j int; DECLARE word_array bytea; BEGIN
i = 0; tmp = 4294967295; word_array = decode(replace(word, E'\\', E'\\\
\'), 'escape'); LOOP tmp = (tmp # get_byte(word_array, i))::bigint; i
= i + 1; j = 0; LOOP tmp = ((tmp >> 1) # (3988292384 * (tmp &
1)))::bigint; j = j + 1; IF j >= 8 THEN EXIT; END IF; END LOOP; IF i
>= char_length(word) THEN EXIT; END IF; END LOOP; return (tmp #
4294967295); END $$ IMMUTABLE STRICT LANGUAGE plpgsql;
Will this create a problem for me in server performance?
Thanks & Regards,
Rahul P. Chaudhari
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
