Hi all, I'm testing TPCW on sequoia 2.10.2. For the test, I'm using one controller + one backend server for debugging puprpose.. Originally, I was testing with 4 backends. There are two tomcat servers connected to sequoia.
I encouters some erros about duplicate key problems when request rates are high. If the request rate is low, then it's okay. I guess the problem is that most of the tables in the TPCW implementation doesn't use auto incremented primary key. So before inserting a new record, it reads the max id value in the table and increases it by one for the new id. After insertion opertaion, TPCW commits transaction. MySQL server works correctly with the operation. But with Sequoia, it looks like the operation deosn't perform automicly and the read operatation sometimes is stale. Does anybody have the same problem? Anybody successed in testing TPCW with RAID1b-1? Thanks, Jin ============================================================ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.2//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.2.dtd";> <SEQUOIA> <VirtualDatabase name="tpcw"> <AuthenticationManager> <Admin> <User username="admin" password=""/> </Admin> <VirtualUsers> <VirtualLogin vLogin="user" vPassword=""/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="tareka08" driver="org.gjt.mm.mysql.Driver" url="jdbc:mysql://tareka08/tpcw" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="jinheo" rPassword="xxxx"> <SimpleConnectionManager/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <RAIDb-1Scheduler level="passThrough"/> </RequestScheduler> <!-- <RequestCache> <MetadataCache/> <ParsingCache/> </RequestCache> --> <LoadBalancer> <RAIDb-1> <WaitForCompletion policy="first"/> <RAIDb-1-RoundRobin/> </RAIDb-1> </LoadBalancer> </RequestManager> </VirtualDatabase> </SEQUOIA> ========================================================== 2006-11-07 18:19:22,906 WARN controller.loadbalancer.RAIDb1 Active transactions after backend tareka08 is disabled: [24, 40, 118, 63, 80, 81, 84] 2006-11-07 18:19:22,906 ERROR backend.DatabaseBackend.tareka08 Request 'INSERT INTO shopping_cart (sc_id, sc_tim...' failed on backend tareka08 but 1 succeeded (java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '384' for key 1") 2006-11-07 18:19:22,907 WARN backend.DatabaseBackend.tareka08 Task execution failed (java.sql.SQLException: Request 'INSERT INTO shopping_cart (sc_id, sc_tim...' failed on backend tareka08 but 1 succeeded (java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '384' for key 1")) 2006-11-07 18:19:22,907 WARN backend.DatabaseBackend.tareka08 Unable to remove task StatementExecuteUpdateTask from transaction 63 (INSERT INTO shopping_cart (sc_id, sc_time) VALUES ( ? , {ts '2006-11-07 18:19:22.0'})/<!%I|384|!%>) from pending request queue 2006-11-07 18:19:22,907 ERROR backend.DatabaseBackend.tareka08 Failed to remove task StatementExecuteUpdateTask from transaction 63 (INSERT INTO shopping_cart (sc_id, sc_time) VALUES ( ? , {ts '2006-11-07 18:19:22.0'})/<!%I|384|!%>) from [] 2006-11-07 18:19:22,921 WARN backend.DatabaseBackend.tareka09 Unable to find table $tmp_bs19 in database schema, scheduling query DROP TABLE $tmp_bs19/ in conflicting queue. 2006-11-07 18:19:22,921 WARN backend.DatabaseBackend.tareka09 Unable to find table $tmp_bs19 in database schema, when getting next entry to execute : DROP TABLE $tmp_bs19/ 2006-11-07 18:19:22,922 WARN backend.DatabaseBackend.tareka09 Unable to find table $tmp_bs19 in database schema, when getting next entry to execute : DROP TABLE $tmp_bs19/ 2006-11-07 18:19:22,924 WARN backend.DatabaseBackend.tareka09 Unable to find table $tmp_bs19 in database schema, when getting next entry to execute : DROP TABLE $tmp_bs19/ -- 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
