Hi All, I am trying to perform an update:
UPDATE helpdesk_tickets ht, helpdesk_status_master hsm SET ht.status_id = (SELECT status_id FROM helpdesk_status_master WHERE is_closed = 'y') WHERE ht.submit_date < DATE_ADD(curdate(), INTERVAL -7 day) AND ht.status_id = hsm.status_id AND hsm.is_closed = 'y' AND hsm.final_closed = 'n' When I get the above error. Is the above query allowed? Has it perhaps been fixed? This is the sequence of events 1) Ran the above query 2) The server shutdown 3) Started the server again 4) I get the out of memory error Running Mysql 4.1 1Gig Ram (2 Gig SWAP) 2X 2.4GhZ Xeon RH9 Here's the log: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=72 max_connections=150 threads_connected=22 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1007014 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x5fbf7ea0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfabeed8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x807e89b 0x829e7f8 0x80a0d7c 0x80a111a 0x804c3bc 0x80a1565 0x80a547e 0x806c970 0x806abc8 0x80a1565 0x80bbadc 0x80a5914 0x80a7b62 0x80bb95f 0x808b3a2 0x808dd99 0x8088c91 0x808847d 0x8087c39 0x829bfac 0x82d187a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x88b9cc8 = UPDATE helpdesk_tickets ht, helpdesk_status_master hsm SET ht.status_id = (SELECT status_id FROM helpdesk_status_master WHERE is_closed = 'y') WHERE ht.submit_date < DATE_ADD(curdate(), INTERVAL -7 day) AND ht.status_id = hsm.status_id AND hsm.is_closed = 'y' AND hsm.final_closed = 'n' thd->thread_id=237423 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 237423 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 040414 13:34:27 mysqld restarted 040414 13:34:27 Can't start server: Bind on TCP/IP port: Address already in use 040414 13:34:27 Do you already have another mysqld server running on port: 3306 ? 040414 13:34:27 Aborting 040414 13:34:27 /usr/local/mysql/bin/mysqld: Shutdown Complete 040414 13:34:27 mysqld ended 040414 13:35:13 mysqld started 040414 13:35:14 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 157493553 InnoDB: Doing recovery: scanned up to log sequence number 0 157493553 040414 13:35:14 InnoDB: Flushing modified pages from the buffer pool... 040414 13:35:14 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.1.0-alpha-standard-log' socket: '/tmp/mysql.sock' port: 1111 040414 13:36:07 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space Any help is appreciated. Thanks Terence -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
