Can't create table (errno: 604)
Hi, I get this error when trying to create newtables in a cluster. I just created about 27 tables using ndbcluster-engine without a problem. trying to create any more tables fails with this error. anybody knows? thx -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't create table (errno: 604) (occurs when trying to create a primary key)
I've now figured out that the error occurs when I try to create any table that has a primary key. creating tables without the primary key works. hmm.. is there any limitation in the mysql (ndb)-settings that I've to change? Its the standard-installation of 4.1.21-max... -- Sebastian Mork [EMAIL PROTECTED] -- On Wed, 11 Oct 2006 09:52:05 +0200 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, I get this error when trying to create newtables in a cluster. I just created about 27 tables using ndbcluster-engine without a problem. trying to create any more tables fails with this error. anybody knows? thx -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ndb_mgmd on windows?
Hi, I wanna create a mysql-cluster with two data-nodes running on linux-servers. so I've got two linux-servers available but for the management-node I'd need a third one.. I just wanna test my app first to see how it is running in a cluster, later in production there'll be three linux-servers. so is it possible to run the management-node on a windows-machine? here someone said he saw it running on win: http://forums.mysql.com/read.php?25,70539,79253#msg-79253 I tried using cygwin on my win-pc to run ndb_mgmd but it doesnt start there... -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ndb-storage engine in 5.0.24a-community-max?
Hi, is the ndb-storage-engine for creating clusters included in 5.0.24a-community-max (win)?? if it is, how can I enable it? Or is it still imposible to use clusters on windows-machines? Thx -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
updating federated table affects only one row per request, should update more rows ..
I try to update multiple rows in a federated table with one query, where field a=x and field b=x.. There are 4 rows that match these criteria (selecting returns 4 rows) but trying to update using the following query updates only one record. calling the same query 4 times, updates only one record per request. whats going wrong here, it's a simple basic query.. updates only 1 record (should update 4 records) --- update tbl_lager set fld_shopid=0 ,fld_orderid=0 where fld_orderid=10 and fld_shopid=3 repeating this query 4 times updates 1 record/update the 5th update updates no record (correct) a similar query (select instead of update) returns 4 records, as it should .. - select * from tbl_lager where fld_orderid=10 and fld_shopid=3 returns 4 records, correct e.g. this query runs correct ans updates 4 records: --- update tbl_lager set fld_shopid=0 ,fld_orderid=0 where fld_pid=1911 does anybody have a similar problem/ any tips? The queries are executed on mySql 5.0.18-max, the server containing the physical data is running 4.1.18-nt. (Both servers are running on the same machine (my notebook, running xp home, sp2, mysql 5 on port 3306 and mysql 4.1 on port 3307) heres the structure of the federated table: CREATE TABLE `tbl_lager` ( `fld_autoid` int(11) NOT NULL auto_increment, `fld_pid` int(11) NOT NULL default '0', `fld_hid` int(11) NOT NULL default '0', `fld_ekp` decimal(14,2) NOT NULL default '0.00', `fld_mwst` int(11) NOT NULL default '0', `fld_indatum` datetime NOT NULL default '-00-00 00:00:00', `fld_status` int(2) NOT NULL default '0', `fld_orderid` int(11) NOT NULL default '0', `fld_shopid` int(3) NOT NULL default '0', PRIMARY KEY (`fld_autoid`), UNIQUE KEY `fld_autoid` (`fld_autoid`), KEY `fld_pid` (`fld_pid`), KEY `fld_hid` (`fld_hid`), KEY `fld_mwst` (`fld_mwst`), KEY `fld_orderid` (`fld_orderid`), KEY `fld_status` (`fld_status`), KEY `fld_shopid` (`fld_shopid`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://user:[EMAIL PROTECTED]:3307/dbname/tbl_lager'; thx -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: locking federated table not possible?
no ideas? -- Sebastian Mork [EMAIL PROTECTED] -- On Mon, 06 Mar 2006 19:46:53 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, is it not possible to lock federated tables (creating a lock on the remote machine to lock the table on the machine containing the data?) I've a situation where I have some different databases on different servers but they share a small amount of tables that are physically stored on only one machine. the other (remote) servers use these table as federated tables. on the server where the data is stored physically in a myIsam-table I can lock the table, insert some data and unlock it. I've made some tests where I create a write lock, then call 1 queries to insert some data (when starting these queries I created a new request that tries to insert data) then the first request unlocks the table and the second request runs when the unlock is done. great. but when I try to run a lock on a federated table it has no effect, I try to lock the table, insert 1 rows and unlock the table again. but when I'm running a second request while the 1 rows are inserted the second request doesnt wait for the table to be unlocked, the data is inserted while the first request is made. here is my request thats starting first: (some pseudo-style code) --- lock tables tbl_lager write; do from 1 to 1 INSERT INTO `tbl_lager` (`fld_pid`) VALUES ('1'); end do unlock tables; unlocked at #now()# and heres the second that starts when the first is running: --- lock tables tbl_lager write; INSERT INTO `tbl_lager` (`fld_pid`) VALUES ('1'); unlock tables; unlocked at #now()# doing this local ob the server where the data is stored physically it works fine. but on the federated table it doesn't work. Any comments would be great. thx. -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
locking federated table not possible?
Hi, is it not possible to lock federated tables (creating a lock on the remote machine to lock the table on the machine containing the data?) I've a situation where I have some different databases on different servers but they share a small amount of tables that are physically stored on only one machine. the other (remote) servers use these table as federated tables. on the server where the data is stored physically in a myIsam-table I can lock the table, insert some data and unlock it. I've made some tests where I create a write lock, then call 1 queries to insert some data (when starting these queries I created a new request that tries to insert data) then the first request unlocks the table and the second request runs when the unlock is done. great. but when I try to run a lock on a federated table it has no effect, I try to lock the table, insert 1 rows and unlock the table again. but when I'm running a second request while the 1 rows are inserted the second request doesnt wait for the table to be unlocked, the data is inserted while the first request is made. here is my request thats starting first: (some pseudo-style code) --- lock tables tbl_lager write; do from 1 to 1 INSERT INTO `tbl_lager` (`fld_pid`) VALUES ('1'); end do unlock tables; unlocked at #now()# and heres the second that starts when the first is running: --- lock tables tbl_lager write; INSERT INTO `tbl_lager` (`fld_pid`) VALUES ('1'); unlock tables; unlocked at #now()# doing this local ob the server where the data is stored physically it works fine. but on the federated table it doesn't work. Any comments would be great. thx. -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]