Hello Miguel,
Wednesday, February 07, 2001, 5:52:50 AM, you wrote:
MAS> I have made the following table on Win2000 machine:
C:\mysql\bin>>mysql
MAS> Welcome to the MySQL monitor. Commands end with ; or \g.
MAS> Your MySQL connection id is 3 to server version: 3.23.30-gamma
MAS> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql>> use test;
MAS> Database changed
mysql>> create table layers (
MAS> -> updated timestamp,
MAS> -> counter_id int,
MAS> -> stat_id int not null primary key,
MAS> -> lasthit_ts timestamp,
MAS> -> lasthit_id int) type=BDB;
MAS> Query OK, 0 rows affected (0.61 sec)
MAS> I have inserted 50 rows with the data you sent. I wasn't able to
MAS> repeat your result, see below. I am using 3.23.30 version, but
MAS> before I build a server with your same version, Can you send me
MAS> your table definition ?. Notice also that I change the name of
MAS> the table, because Windows doesn't permit the syntax that you
MAS> have used.
Well. If this bug would appear every time I would of couse send you a
working examble. If this would be at least table dammage problem I
would upload the table to apropirate directory. But as I wrote in my
previous email this has nothing to do with this - after I have
restarted mysql the problem dissapeared so this looks like mysql
memory internal structures went wron. Also I've reported some process
got looped - and I think this might be the source of the problem.
This was the first problem of this type with BDB tables I saw during a
2weeks of pre production testing of them.
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php