Hi Emmanuel, thanks for your reply. Yes you are right, I forgot to mention that I have sequoia running against one back end, we just wanted to check if the copy command would work....
Ok, I will check the client side batch. Thanks again. > Date: Thu, 9 Jul 2009 15:01:48 -0400 > From: [email protected] > To: [email protected] > CC: [email protected] > Subject: Re: [Sequoia] Running copy statement > > 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
_______________________________________________ Sequoia mailing list [email protected] http://forge.continuent.org/mailman/listinfo/sequoia
