Hi Julio, Note that the Sequoia mailing list has moved to [email protected]. I am surprised that COPY works because it should not. If you broadcast the statement "copy test from '/var/lib/pgsql/test1.txt' csv" to all Postgres instances, that means that you should have a copy of /var/lib/pgsql/test1.txt in every machine running Postgres which is unlikely to be the case. You should use a client side batch update rather than the COPY command with Sequoia.
Hope this helps, Emmanuel > We run sequoia 2.10 postgresql 8.3.5 > > We are running this sql statement > > copy test from '/var/lib/pgsql/test1.txt' csv > > Affected rows: 0 > Query executed in 0 s 10 ms . > > If we run the same statement right away we got these messages > > > > java.lang.RuntimeException: Unable to clone the parsing of an unknown > request > at > org.continuent.sequoia.controller.requests.UnknownWriteRequest.cloneParsing(UnknownWriteRequest.java:182) > at > org.continuent.sequoia.controller.cache.parsing.ParsingCache.getParsingFromCacheAndParseIfMissing(ParsingCache.java:231) > at > org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:368) > at > org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) > at > org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteUpdate(RequestManager.java:657) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteUpdate(VirtualDatabase.java:609) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2359) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:445) > 2009-07-09 10:54:49,245 WARN > virtualdatabase.VirtualDatabaseWorkerThread.abrazo Runtime error > during command execution (Unable to clone the parsing of an unk > nown request) > > > If we wait for a minute or so the statement will run ok. > > > copy test from '/var/lib/pgsql/test1.txt' csv > > > > Affected rows: 0 > > Query executed in 0 s 10 ms . > > > Any ideas? > > Thanks in advance for ur help > Julio Leiva > DBA > ------------------------------------------------------------------------ > > _______________________________________________ > Sequoia mailing list > [email protected] > http://forge.continuent.org/mailman/listinfo/sequoia -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: [email protected] Skype: emmanuel_cecchet _______________________________________________ Sequoia mailing list [email protected] http://forge.continuent.org/mailman/listinfo/sequoia
