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 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
