| Bug #10704 | Memory: Information Scheme table inaccessible if resident memory is full. | ||
|---|---|---|---|
| Submitted: | 18 May 2005 9:53 | Modified: | 1 Jul 2005 7:19 |
| Reporter: | Disha | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.0.5 Beta | OS: | Windows (Windows) |
| Assigned to: | CPU Architecture: | Any | |
[22 May 2005 10:25]
Vasily Kishkin
Could you explane me how you filled 2G into memory table ?
[30 May 2005 15:38]
Disha
We created a text file, aFile.txt, with 2 gb of data. Also, the following global variable needs to be set as follows: set @@max_heap_table_size=4294967295;
[1 Jun 2005 7:19]
Vasily Kishkin
I could't reproduce this bug. information_schema tables were showed without problem. Could you please test it on 5.0.7 beta mysql ?
[1 Jul 2005 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: Memory: Information Scheme table is inaccessible if resident memory is utilized completely by a memory table, regardless of the utilization of swap memory Consider that resident memory is 2 gb and 8 gb of swap memory. Create a memory table and upload it with data which consumes 2 gb of memory. Once this is done, none of the information_schema tables ca be queried. How to repeat: 1. Create table t_memory( f236 char(95) unicode, f241 char(255) unicode, f237 char(130) binary, f238 varchar(2500) binary, f239 varbinary(0), f240 varchar(120) unicode ) engine = Memory; 2. Select * from Information_Schema.tables// 3. Load Data local infile "aFile.txt" into table t_memory// 4. Select * from Information_Schema.tables// ACTUAL RESULT: 1. Step 2 returns result set correctly. 2. On step 4, following error is displayed. error 1017: Cant find file: 'Information_Schema.tables' (Errno:2) EXPECTED RESULT: User should always be able to query the information_schem table correctly.