Hi Rahul
Obviously these errors aren't ideal, but it shouldn't have too much of an
effect on performance - it will only happen when you index and generate the
Sphinx config file.
Cheers
--
Pat
On 29/09/2010, at 10:32 PM, rahul100885 wrote:
> 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.
>
--
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.
