Twice now, I've ended up having problems starting up Sling and ended up having to delete all the tables in the database, to solve the problem.
I recognize that this is probably a jackrabbit problem and so perhaps not appropriate for this list, but given that the jackrabbit instance is part of the sling install, I'm going to start here first. The app was shut down, perhaps improperly, but I had to reboot my laptop. I had to delete glassfish and in doing so blasted the repository file system. On restart I get this message: 16.06.2010 20:49:00.906 *ERROR* [Repository Pinger] org.apache.jackrabbit.core.RepositoryImpl Failed to initialize workspace 'default' javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager Caused by: java.sql.SQLException: Schema generation error: Issuing statement: create table JCR_DEFAULT_REFS (NODE_ID_HI bigint not null, NODE_ID_LO bigint not null, REFS_DATA bytea not null, PRIMARY KEY (NODE_ID_HI, NODE_ID_LO)) Caused by: org.postgresql.util.PSQLException: ERROR: relation "jcr_default_refs" already exists Now I'm only using Postgres for the Persistence manager, and not also using the DbFileSystem. Is this possibly a problem with the FileSystem being out of synch with the Persistence manager? Is this a general tip in the direction that says, keep your file system in the database also? Tony Giaccone
