Now it looks good.. The problem was with the TPCW implementation from Wisconsin. They unecessarily drop tempory tables even though the tables are automatically deleted after session is closed in MySQL.
Thank you for the helps and answers! Jin On 11/13/06, Jin Heo <[EMAIL PROTECTED]> wrote:
Emmanuel, Thanks..I'll check with what you suggedsted.. I guess the reason for multiple warnings is I'm using two backend database servers.. Jin On 11/13/06, Emmanuel Cecchet <[EMAIL PROTECTED]> wrote: > Jin, > > > I tested again using one tomcat server and two MySQL backends and > > looks working fine but I get a lot of warning messages, though. What > > are those warnings about and how I can remove those warnings? > > > > 15:51:10,066 WARN backend.DatabaseBackend.tareka09 Unable to find > > table $tmp_bs1301 in database schema, when getting next entry to > > execute : DROP TABLE $tmp_bs1301/ > > 15:51:10,067 WARN backend.DatabaseBackend.tareka08 Unable to find > > table $tmp_bs1301 in database schema, when getting next entry to > > execute : DROP TABLE $tmp_bs1301/ > It is strange that you always get the warning multiple times on the same > table. There are 2 possible causes: > - the temporary table is not reported by MySQL when we fetch the schema > because its scope is only visible in the connection where it was > created. In that case, you should use persistent connections (add > ?persistentConnections=true at the end of your Sequoia JDBC URL) > - there is a bug in the application that does not allocate unique > temporary table names (that are visible for all connections) and tries > to drop multiple times the same table (the database usually does not > complain but only the first drop will succeed) > > Keep us posted with your findings, > Emmanuel > > -- > Emmanuel Cecchet > Chief Scientific Officer, Continuent > > Blog: http://emanux.blogspot.com/ > Open source: http://www.continuent.org > Corporate: http://www.continuent.com > Skype: emmanuel_cecchet > Cell: +33 687 342 685 > > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia > -- Jin Heo Ph.D. Candidate Computer Science University of Illinois at Urbana-Champaign e-mail: [EMAIL PROTECTED] http://www.cs.uiuc.edu/homes/jinheo
-- Jin Heo Ph.D. Candidate Computer Science University of Illinois at Urbana-Champaign e-mail: [EMAIL PROTECTED] http://www.cs.uiuc.edu/homes/jinheo _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
