slony1-bugs at lists.slony.info slony1-bugs at lists.slony.info
Sun May 18 19:06:15 PDT 2008
http://www.slony.info/bugzilla/show_bug.cgi?id=51

           Summary: Error while uninstalling and installing slony on running
                    database
           Product: Slony-I
           Version: 1.2
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: medium
         Component: altperl
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: hof at hofcom.nl
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


when doing the following steps: 

./slon_kill --config ../etc/slon_tools.conf
./slonik_uninstall_nodes --config ../etc/slon_tools.getfx1.conf | slonik

<drop replicated db; recreate db; load structures> 
<update slon_tools.conf with new tables> 

./slonik_init_cluster --config ../etc/slon_tools.conf  | slonik 
./slon_start --config ../etc/slon_tools.conf 1
./slon_start --config ../etc/slon_tools.conf 2
./slonik_create_set --config ../etc/slon_tools.conf 1 | slonik 
./slonik_subscribe_set --config ../etc/slon_tools.conf 1 2 | slonik

on my running application, that does some inserts every 30 seconds, i get the
following error: 

org.postgresql.util.PSQLException: ERROR: cache lookup failed for type 34730
       at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
       at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
       at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
       at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
       at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
       at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
       at
snaq.db.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:80)


Is my sequence of operations supported? and perhaps its a problem because i am
using a database connection pool? 


slon -v
slon version 1.2.13

PostgreSQL 8.3.1 on both servers.


-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.


More information about the Slony1-bugs mailing list