Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> mysql 3.23.32 + BDB 3.2.3h
mysql> select * from layers_la00.g03last_hit;
Peter> +----------------+------------+---------+----------------+------------+
Peter> | updated | counter_id | stat_id | lasthit_ts | lasthit_id |
Peter> +----------------+------------+---------+----------------+------------+
Peter> | 20010206162625 | 110912 | 1 | 20010103141348 | 25 |
Peter> | 20010206162624 | 110912 | 2 | 20010103141348 | 25 |
<cut>
Peter> 50 rows in set (0.00 sec)
mysql> select * from layers_la00.g03last_hit where counter_id=110912;
Peter> +----------------+------------+---------+----------------+------------+
Peter> | updated | counter_id | stat_id | lasthit_ts | lasthit_id |
Peter> +----------------+------------+---------+----------------+------------+
Peter> | 20010206155808 | 110912 | 35 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 36 | 20010103141348 | 25 |
Peter> | 20010206162624 | 110912 | 39 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 42 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 43 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 45 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 46 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 47 | 20010103141348 | 25 |
Peter> | 20010206162624 | 110912 | 49 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 101 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 102 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 103 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 104 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 105 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 106 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 107 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 108 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 109 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 110 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 111 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 112 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 113 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 114 | 20010103141348 | 25 |
Peter> | 20010206162625 | 110912 | 115 | 20010103141348 | 25 |
Peter> | 20010206155808 | 110912 | 116 | 20010103141348 | 25 |
Peter> +----------------+------------+---------+----------------+------------+
Peter> 25 rows in set (0.00 sec)
Peter> As you see "where clause" removes 25 records from result,there they
Peter> has to be there.
Peter> I've done mysqladmin "flush logs" and then copied the .frm and .db
Peter> files into other database directory - and the bug was unable to be
Peter> repaired.
I assume you mean 'unable to be repeated' ?
I haven't seen anything like this with BDB tables before :(
Peter> also I find one of mysql processes hanged - it took 100% of one of the
Peter> processors.
Peter> I've connected to the process and made BT several times:
Peter> 0x8137b17 in _mi_get_binary_pack_key (keyinfo=0x0, nod_flag=0, page_pos=0x0,
key=0x0) at mi_search.c:1035
Peter> 1035 *page_pos= page+length-tmp;
Do you think this is related ?
The above means that it was stuck in the MyISAM code, which is not
depending on the above.
I took a look a the backtraces, but they looked 'normal'
Did you do a 'mysqladmin proc' when this happened?
Peter> After I've restarted mysqld the problem removed itself
:(
It could have been the automatic repair that fixed this table.
Do you think this is possible?
Regards,
Monty
---------------------------------------------------------------------
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