Mon Oct 23 11:55:26 PDT 2006
- Previous message: [Slony1-general] Master CPU with more than 30%
- Next message: [Slony1-general] Strange notices with 1.2.0
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello, I just recently upgraded to 1.2.0, and when I drop sets or do a switchover, slonik produces strange notices about missing indices (see below). I didn't see these with 1.1.5. Should I be worried (even though they are just notices)? MP After drop set: <stdin>:4: NOTICE: Consider adding partial index PartInd_lit_sl_log_2-node-1 on sl_log_2 CONTEXT: SQL statement "SELECT "_lit".addPartialLogIndices()" PL/pgSQL function "dropset_int" line 40 at perform SQL statement "SELECT "_lit".dropSet_int( $1 )" PL/pgSQL function "dropset" line 26 at perform <stdin>:4: NOTICE: schema: [_lit] tablename:[sl_log_2] CONTEXT: SQL statement "SELECT "_lit".addPartialLogIndices()" PL/pgSQL function "dropset_int" line 40 at perform SQL statement "SELECT "_lit".dropSet_int( $1 )" PL/pgSQL function "dropset" line 26 at perform <stdin>:4: NOTICE: index was not found - add it! CONTEXT: SQL statement "SELECT "_lit".addPartialLogIndices()" PL/pgSQL function "dropset_int" line 40 at perform SQL statement "SELECT "_lit".dropSet_int( $1 )" PL/pgSQL function "dropset" line 26 at perform After switchover: <stdin>:6: NOTICE: Consider adding partial index PartInd_lit_sl_log_2-node-2 on sl_log_2 CONTEXT: SQL statement "SELECT "_lit".addPartialLogIndices()" PL/pgSQL function "moveset_int" line 169 at perform SQL statement "SELECT "_lit".moveSet_int( $1 , $2 , $3 , 0)" PL/pgSQL function "moveset" line 61 at perform <stdin>:6: NOTICE: schema: [_lit] tablename:[sl_log_2] CONTEXT: SQL statement "SELECT "_lit".addPartialLogIndices()" PL/pgSQL function "moveset_int" line 169 at perform SQL statement "SELECT "_lit".moveSet_int( $1 , $2 , $3 , 0)" PL/pgSQL function "moveset" line 61 at perform <stdin>:6: NOTICE: index was not found - add it! CONTEXT: SQL statement "SELECT "_lit".addPartialLogIndices()" PL/pgSQL function "moveset_int" line 169 at perform SQL statement "SELECT "_lit".moveSet_int( $1 , $2 , $3 , 0)" PL/pgSQL function "moveset" line 61 at perform
- Previous message: [Slony1-general] Master CPU with more than 30%
- Next message: [Slony1-general] Strange notices with 1.2.0
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list