Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 22764 invoked from network); 22 Jun 2005 06:51:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 22 Jun 2005 06:51:42 -0000 Received: (qmail 15894 invoked by uid 500); 22 Jun 2005 06:51:34 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 15848 invoked by uid 500); 22 Jun 2005 06:51:32 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 15827 invoked by uid 99); 22 Jun 2005 06:51:32 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Jun 2005 23:51:32 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [194.175.229.106] (HELO mail.seitenbau.net) (194.175.229.106) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Jun 2005 23:51:33 -0700 Received: from [195.127.188.18] (helo=www.seitenbau.net) by router1.seitenbau.net with esmtp (Exim 4.43) id 1Dkz59-0002g6-6P for torque-user@db.apache.org; Wed, 22 Jun 2005 08:51:31 +0200 In-Reply-To: <001a01c576c0$9cafea20$6201a8c0@win98> Subject: RE: MySql InnoDB question To: "Apache Torque Users List" X-Mailer: Lotus Notes Release 6.0 September 26, 2002 Message-ID: From: Thomas Fischer Date: Wed, 22 Jun 2005 08:51:30 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21, 2004) at 22.06.2005 08:51:30 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, this message is usually the sign that something else is wrong. Most probably, Torque will not work correctly if you see this message. There is at least one unresolved issue with InnoDB tables, it should be in scarab (the issue tracker) with a ticket id between TRQS250 and TRQS300. Please have a look. Thomas "Youngho Cho" schrieb am 22.06.2005 02:23:27: > Hello, > > I am tring to use MySQL 4.1 InnoDB table type. > I install MySQL 4.1.12 (using InnoDB engine mode ) in Window XP and Torque 3.1 > After create db with torque and changed the all table type to innoDB > type with mysql admin client > > But when I start the torque, > I got the following warn message > > 2005-06-21 18:38:48,936 [Torque - ID Broker thread] DEBUG org. > apache.torque.oid.IDBroker - IDBroker thread was started. > 2005-06-21 18:38:48,941 [main] WARN org.apache.torque.oid.IDBroker > - IDBroker is being used with db 'easydesk', which does not support > transactions. IDBroker attempts to use transactions to limit the > possibility of duplicate key generation. Without transactions, > duplicate key generation is possible if multiple JVMs are used or > other means are used to write to the database. > > I notice that when this message show, torque doesn't use transaction. > How do I set the torque use transaction with MySQL InnoDB type ?? > > Thanks. > > Youngho --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org