Error 5 Hy000 At Line
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Error 1114 Hy000 At Line The Table Is Full
of this site About Us Learn more about Stack Overflow the company Business sqlstate hy000 general error 5 database is locked Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask
Mysql Errcode 5
Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign mysql error code 5 out of memory up What is SQL Error: 5, SQLState: HY000? and what can cause this error? up vote 0 down vote favorite The application I'm debugging writes randomly/occasionally this exception in its logs. org.hibernate.util.JDBCExceptionReporter - SQL Error: 5, SQLState: HY000 and an SQL out of memory error associated to this. While I found in mysql documentation what SQLState: HY000 is, I can't find anywhere mysql out of memory error what SQL Error 5 is, related to this state. Currently I know only that the db connection closes due to this out of memory error, and that the situation doesn't follow any pattern. Due to the nature of the program adding additional logging messages is not an option. (I can't do that as the application is huge and from what I've seen it happens randomly - different memory size needed for the queries to execute (in the messages) varying from 3 MB to 6 MB). Any help/information about this exception is appreciated. Additional information: It seems that the out of memory messages come in blocks of 6-50+ requests in an interval of 100-150 milliseconds. From a list of about 20-30 error messages, only 3 also appeared in mysql logs, the rest only in tomcat logs (printed the stacktrace). Thanks mysql sql hibernate out-of-memory share|improve this question edited Sep 20 '11 at 8:55 asked Sep 19 '11 at 14:55 Romeo 142217 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted HY000 means general error. SQL Error 5 is Out of memory
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 Learn more about Stack Overflow the company Business Learn more about hiring developers 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 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 http://stackoverflow.com/questions/7472884/what-is-sql-error-5-sqlstate-hy000-and-what-can-cause-this-error 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 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. http://serverfault.com/questions/580027/troubleshooting-out-of-memory-error-messages-from-mysql 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 it does, it may indicate issues with memory leaks. ?? Any suggestions would be appreciated. EDIT 1 These are the results from running ulimit command (both servers have the same results) prod:/etc# ulimit -a -f: file size (blocks) unlimited -t: cpu time (seconds) unlimited -d: data seg size (kb) unlimited -s: stack size (kb) 8192 -c: core file size (blocks) 0 -m: resident set size (kb) unlimited -l: locked memory (kb) 64 -p: processes 26303 -n: file descriptors 1024 -v: address space
Exchange Q+A siteThis forum is for general discussions, beta-testing, bug reporting, etc. Learn more.What to do if you think you've found a bug.Create an account on civicrm.org to use this forum. Home Help Search Login Register CiviCRM Community Forums » Old sections (read-only, deprecated) » Support » Using CiviCRM » Using Core CiviCRM Functions (Moderator: Yashodha Chaku) » ERROR 5 (HY000): Out of memory « previous next » Print Pages: [1] Author https://forum.civicrm.org/index.php?topic=21019.0 Topic: ERROR 5 (HY000): Out of memory (Read 2231 times) jlam I’m new here Posts: 8 Karma: 0 ERROR 5 (HY000): Out of memory « on: August 05, 2011, 01:31:41 pm » Running a CiviCRM query at http://pastebin.com/6M1emH14, I getERROR 5 (HY000): Out of memory (Needed 1640964 bytes) This query is run after attempting to save data for any contact for one user in particular, but not all.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?+----+--------------------+-----------------------------------------+-----------------+------------------------------------------------------------------------------------+------------------+---------+---------------------------+--------+------------------------------+| id | error 5 select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |+----+--------------------+-----------------------------------------+-----------------+------------------------------------------------------------------------------------+------------------+---------+---------------------------+--------+------------------------------+| 1 | PRIMARY | contact_a hy000 at line | 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_gro