Hi Peiwen, Are you using a firewall? The driver uses UDP pings to ensure the database is up. When the firewall is closed, you can connect for a while but after a while we note there are no ping responses and close the connection. Your symptoms match that perfectly.
If so, ensure that port 25322 is open for both TCP and UDP packets. Cheers, Robert On 9/26/08 11:48 AM, "Peiwen Zhu" <[EMAIL PROTECTED]> wrote: Hi all, I'm having the following problem: I've setup a Sequoia controller on my local machine, with 1 virtual database which has two backends pointing to 2 MySQL server. And it works fine. However, when I move the same configuration to a remote server, I got a problem. I can successfully connect to Sequoia, do some queries, but I'll lose the connection after about 30 seconds. And here's the message: org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Connection lost while executing statementExecute with request 'SELECT * FROM `person`' and automatic reconnect failed (org.continuent.sequoia.common.exceptions.driver.VirtualDatabaseUnavailableException: Virtual database rls-obizcore not found on any of the controllers) Any ideas of why this happen? And how can I fix this? Thanks in advance! Peiwen _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
