| Bug #988 | crash(restart) with FLUSH QUERY CACHE | ||
|---|---|---|---|
| Submitted: | 4 Aug 2003 1:00 | Modified: | 16 Oct 2003 13:18 |
| Reporter: | thomas herzog | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 4.0 | OS: | Any (any) |
| Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[4 Aug 2003 1:00]
thomas herzog
[4 Aug 2003 4:45]
MySQL Verification Team
I have run cron job each 5 minutes and after one hour still everything runs smoothly.
[4 Aug 2003 4:58]
thomas herzog
it crashes average once a day, and the server is clean and new i have changed the cronjob time setting from */20 -> 20 * to now -> 20 */2 i will add the whole errorlog, i hope it helps ;O)
[4 Aug 2003 4:59]
thomas herzog
the errorlog
Attachment: early.err (application/octet-stream, text), 51.70 KiB.
[12 Aug 2003 20:55]
Boyd Gerber
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL. I have had a cron job run it every 10 minutes for 18 hours and I have not been able to get a failure. Is there any thing else you can add to duplicate this problem?
[18 Aug 2003 0:13]
thomas herzog
i have changed my cronjob setting to */20 and set query_cache_type = 0 to our high loaded forum the other websites have query_cache_type = 1 for now its run smoothly for 4 days sorry
[18 Aug 2003 0:26]
thomas herzog
addition: also changed php.ini -> mysql.max_persistent = 5 (before -1) -> typo3 use persistent connections /etc/my.cnf now: skip-locking key_buffer = 256M max_allowed_packet = 15M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 query_cache_type = 0 max_connections=150 server-id = 1 log-bin
[15 Sep 2003 3:55]
Oleksandr Byelkin
Thnks to "Jocelyn Fournier" <joc@presence-pc.com> (who provided me core dump
and mysql binary file, Now I am able to repet this crash, and I hope problem
will be solved in short time.
set GLOBAL query_cache_size=1048576;
flush query cache;
reset query cache;
flush status;
--disable_warnings
drop table if exists t1,t2,t3,t4;
--enable_warnings
create table t1 (a int not null);
insert into t1 values (1),(2),(3);
create table t2 (a text not null);
create table t3 (a text not null);
insert into t3 values("1111111111111111111111111111111111111111111111111111");
insert into t2 select * from t3;
insert into t3 select * from t2;
insert into t2 select * from t3;
insert into t3 select * from t2;
insert into t2 select * from t3;
insert into t3 select * from t2;
insert into t2 select * from t3;
insert into t3 select * from t2;
insert into t2 select * from t3;
insert into t3 select * from t2;
drop table t2;
create table t2 (a int not null);
insert into t2 values (1),(2),(3);
create table t4 (a int not null);
insert into t4 values (1),(2),(3);
select * from t4;
select * from t2;
select * from t1 as tt, t1 as ttt where tt.a=1 and ttt.a=2;
select * from t2;
select * from t4;
select * from t1 as tt, t1 as ttt where tt.a=1 and ttt.a=2;
select * from t2;
select * from t4;
select * from t1 as tt, t1 as ttt where tt.a=1 and ttt.a=2;
delete from t2 where a=1;
flush query cache;
select * from t3;
delete from t4 where a=1;
flush query cache;
drop tables t1,t2,t3,t4;
[15 Sep 2003 6:14]
Oleksandr Byelkin
ChangeSet 1.1570 03/09/15 15:16:13 bell@sanja.is.com.ua +4 -0 fixed server crash on moving query block with pointers to same table in it (BUG#988) removed server options
[16 Oct 2003 13:18]
Oleksandr Byelkin
Patch is pushed in current 4.0 sources repository and will be present in next releases of 4.0 and 4.1
