Re: [Sequoiadb-discuss] [Sequoia] Running copy statement

[Emmanuel C. <ma...@fr...>]

Hi Julio,

Note that the Sequoia mailing list has moved to 
seq...@li....
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
> Se...@li...
> http://forge.continuent.org/mailman/listinfo/sequoia


-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: ma...@fr...
Skype: emmanuel_cecchet