Mikko Partio dun
Mon Oct 23 11:55:26 PDT 2006
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



More information about the Slony1-general mailing list