Hi there,
i've several questions/problems to administer our test-cluster-environment.
First at all, i browsed the docs but i didn't find anything.
So here we are ;)
1. If a sql-statement is incorrect (Like in postgres using "" instead of
'') the cluster throws an exception in the log (which is correct) but
then the client program hang, so i've to kill the client program hardly.
How can i resolv something like this?
2. If a sql-statement is incorrect and creates a fault like the problem
above, i can't start creating a dump. The problem is that the controller
get the following state:
sequoia.controller.scheduler Waiting for 2 pending writes
sequoia.controller.scheduler Waiting for 2 pending writes
...
This state isn't changing for hours. It says that there are two pending
write requests but these to failures were select - statements (like the
problem above ... "" instead of '')
Exist a workaround how to resolv this? Maybe to set the Database in a
non-writable state? Or to kill the pending writes? ....
3. If a statement is processed by the controller (such as "select * from
xxxx") i got failures like this:
sequoia.controller.cache Unable to remove pending query postgresc,select
* from xxxx WHERE xxxx_id < 3000000 LIMIT 10000
Do you some problems like this?
I hope you can help me to solve these problems.
Thx for your help
chris
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
