Mysql Sqlstate Hy000 General Error 5 Out Of Memory
Contents |
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: mysql error 5 (hy000) out of memory General :: ERROR 5 (HY000): Out of memory
Mysql Errcode 5
New Topic Advanced Search ERROR 5 (HY000): Out of memory Posted by: Julien mysql out of memory error Lamarche () Date: August 05, 2011 02:29PM Running a CiviCRM query at http://pastebin.com/6M1emH14, I get ERROR 5 (HY000): Out of memory (Needed 1640964 bytes) Though I can submit a query change recommendation to CiviCRM, I'm hoping this can be fixed by adding an index or changing a parameter in the my.cnf file. Should I increase key_buffer_size or table_cache or is it another parameter? An InnoDB parameter perhaps (CiviCRM tables are all InnoDB)? +----+--------------------+-----------------------------------------+-----------------+------------------------------------------------------------------------------------+------------------+---------+---------------------------+--------+------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+--------------------+-----------------------------------------+-----------------+------------------------------------------------------------------------------------+------------------+---------+---------------------------+--------+------------------------------+ | 1 | PRIMARY | contact_a | index | NULL | index_is_deleted | 1 | NULL | 149732 | Using index; Using temporary | | 1 | PRIMARY | civicrm_group_contact-605 | ref | UI_contact_group | UI_contact_group | 4 | step2_crm_db.contact_a.id | 1 | Distinct | | 1 | PRIMARY | civicrm_group_contact-608 | ref | UI_contact_group | UI_contact_group | 4 | step2_crm_db.contact_a.id | 1 | Distinct | | 1 | PRIMARY | civicrm_group_contact-612 | ref | UI_contact_group | UI_contact_group | 4 | step2_crm_db.contact_a.id | 1 | Using where; Distinct | | 7 | DEPENDENT SUBQUERY | civicrm_group_co
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes http://forums.mysql.com/read.php?20,429609,429609 a minute: Sign up out of memory error from mysql up vote 1 down vote favorite 1 we have a web application (racktables) that's giving us grief on our production box. whenever users try to run a search, it gives the following error: Pdo exception: PDOException SQLSTATE[HY000]: General error: 5 Out of memory (Needed 2057328 bytes) (HY000) I cannot recreate the http://stackoverflow.com/questions/22203192/out-of-memory-error-from-mysql issue on our backup server. The servers match except for the fact that in production we have 16GB RAM and our backup we have 8GB. It's a moot point though because both are running 32 bit os's and so are only using 4GB of RAM. we also have set up a swap partition... Here's what i get back from the "free -m" command in production: prod:/etc# free -m total used free shared buffers Mem: 3294 1958 1335 0 118 -/+ buffers: 1839 1454 Swap: 3817 109 3707 prod:/etc# I've checked to make sure that my.cnf on both boxes match. The database from production was replicated onto the backup server... so the data matches as well. I guess our options are to: A) convert the o/s to 64 bit so we can use more RAM. B) start tweaking some of the innodb settings in my.cnf. But before I try either A or B, I wanted to know if there's anything else I should compare between the two servers... seeing how the backup is working just fine. There must be a difference somewhere
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://serverfault.com/questions/580027/troubleshooting-out-of-memory-error-messages-from-mysql Learn more about Stack Overflow the company Business Learn more about hiring developers https://developers.oxwall.com/forum/topic/3069 or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted out of up and rise to the top troubleshooting out of memory error messages from mysql up vote 1 down vote favorite we have a web application (racktables) that's giving us grief on our production box. whenever users try to run a search, it gives the following error: Pdo exception: PDOException SQLSTATE[HY000]: General error: 5 Out of memory (Needed 2057328 bytes) (HY000) I cannot recreate the issue on our backup out of memory server. The servers match except for the fact that in production we have 16GB RAM and our backup we have 8GB. It's a moot point though because both are running 32 bit os's and so are only using 4GB of RAM. we also have set up a swap partition... Here's what i get back from the "free -m" command in production: prod:/etc# free -m total used free shared buffers Mem: 3294 1958 1335 0 118 -/+ buffers: 1839 1454 Swap: 3817 109 3707 prod:/etc# I've checked to make sure that my.cnf on both boxes match. The database from production was replicated onto the backup server... so the data matches as well. I guess our options are to: A) convert the o/s to 64 bit so we can use more RAM. B) start tweaking some of the innodb settings in my.cnf. But before I try either A or B, I wanted to know if there's anything else I should compare between the two servers... seeing how the backup is working just fine. There must be a difference somewhere that we are not accounting for. One thing I'm thinking of trying is just rebooting the server to see if that fixes it. If i
member. Join Sign In Sign up Main Download Store Forum Premium Support Hosting Market Docs Blog We build. You grow. Get best community software here Start a social network, a fan-site, an education project with oxwall - free opensource community software Get started General error: 5 Out of memory | Forum Topic location: Forum home » Support » Installation Troubleshooter and Server setup Filter by username (optional) Advanced search Adam Dec 30 '11 Hi, I have a problem. Here it is: SQLSTATE[HY000]: General error: 5 Out of memory (Needed 16777188 bytes). Please help. Attachments: bladsql5.JPG (304.08Kb) #1 Mark Jan 2 '12 this usually happens when on a share host that give you a low amount of memory resources. your options are to upgrade to a VPS that gives you a dedicated amount of ram, optimise your site or disable some plugins to make it less resource hungry #2 - SupportGeneral QuestionsBug reports and troubleshootingOxwall Store- Community ExchangeGeneral ChatCustom Oxwall ProjectsLanguage packs- Oxwall InternationalEspañolFrançaiseDeutschРусскийفارسیالعربية- DevelopmentCustom Code ModificationsThemes Start | Demo | About | Policies & Licenses | Blog | Contact Us | Oxwall Foundation | Roadmap | Developer Central | Oxwall hosting | Contribute | Partners | Donation | Community software © Copyright Oxwall Software