DROP TABLE IF EXISTS pbx_app_dial; CREATE TABLE pbx_app_dial ( sbsc_Username varchar(16) NOT NULL, purt_Sequence int(11) default NULL, purt_Options varchar(8) not null default 'tr', padi_Host varchar(16) NOT NULL, padi_Context varchar(16), padi_Timeout int(2) not null default 20, padi_Url varchar(64) NOT NULL, padi_Who varchar(16) NOT NULL, padi_Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, padi_Create datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (sbsc_Username,purt_Sequence,purt_Options) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS pbx_user_route; CREATE TABLE pbx_user_route ( sbsc_Username varchar(16) NOT NULL, purt_Sequence int(11) default NULL, purt_Cidnum varchar(16) default NULL, purt_Command varchar(8) NOT NULL, purt_Options varchar(16) NOT NULL, purt_Enabled enum('Yes','No') NOT NULL default 'Yes', purt_Domain varchar(16) NOT NULL, purt_Who varchar(16) NOT NULL, purt_Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, purt_Create datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (sbsc_Username,purt_Sequence) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into pbx_user_route values ('3254101',0,555,'Dial','20|tr','Yes','','GB1',now(),now()); insert into pbx_user_route values ('3254101',1,5551,'Dial','10|tr','Yes','','GB1',now(),now()); insert into pbx_user_route values ('3254101',2,556,'Dial','10|tr','Yes','','GB1',now(),now()); DROP TABLE IF EXISTS pbx_user_route_number; CREATE TABLE pbx_user_route_number ( sbsc_Username varchar(16) NOT NULL, purt_Sequence int(11) default NULL, purn_Seq tinyint(3) NOT NULL, purn_Protocol varchar(4) not null, purn_Number varchar(16) NOT NULL, purn_Who varchar(16) NOT NULL, purn_Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, purn_Create datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (sbsc_Username,purt_Sequence,purn_Seq) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into pbx_user_route_number values ('3254101',0,0,'SIP','3254102','GB1',now(),now()); insert into pbx_user_route_number values ('3254101',0,1,'SIP','3254123','GB1',now(),now()); insert into pbx_user_route_number values ('3254101',0,2,'SIP','3254127','GB1',now(),now()); insert into pbx_user_route_number values ('3254101',1,0,'SIP','3254103','GB1',now(),now()); insert into pbx_user_route_number values ('3254101',1,1,'SIP','3254122','GB1',now(),now()); insert into pbx_user_route_number values ('3254101',2,0,'SIP','3254104','GB1',now(),now()); 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=268435456 read_buffer_size=258048 max_used_connections=2 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 312943 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x890c6b0 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=0xbeffe2e8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x81b7e08 0xb7eaaf32 0xb7d8df8d 0xb7d8ce3a 0x85a2dab 0x85a3636 0x860a133 0x8210731 0x820a678 0x8205d48 0x8208faf 0x8204ce1 0x81cd551 0x82d8bda 0x82d88d9 0x82d8a64 0x82d63e4 0x82d7293 0x81d277c 0x81d5834 0x81cb874 0x81cb186 0x81ca469 0xb7ea4ed8 0xb7ddd7ea New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/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 0x895c9d0 = SELECT purt.sbsc_Username AS username, purt.purt_Sequence AS sequence, IF(purt_Command='dial', CASE WHEN NAME_CONST('Caller_ID',_latin1'5552') IS NULL THEN CONCAT(IF(ISNULL(prn1.purn_Number),'',CONCAT(prn1.purn_Protocol,'/',prn1.purn_Number)), IF(ISNULL(prn2.purn_Number),'',CONCAT(', ',prn2.purn_Protocol,'/',prn2.purn_Number)), IF(ISNULL(prn3.purn_Number),'',CONCAT(', ',prn3.purn_Protocol,'/',prn3.purn_Number)), IF(ISNULL(prn4.purn_Number),'',CONCAT(', ',prn4.purn_Protocol,'/',prn4.purn_Number)), IF(ISNULL(prn5.purn_Number),'',CONCAT(', ',prn5.purn_Protocol,'/',prn5.purn_Number)) ) WHEN NAME_CONST('Caller_ID',_latin1'5552') = '' THEN CONCAT(IF(ISNULL(prn1.purn_Number),'',CONCAT(prn1.purn_Protocol,'/',prn1.purn_Number)), IF(ISNULL(prn2.purn_Number),' thd->thread_id=7 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 4 mysqld-max process hanging, pid 22147 - killed 060314 16:40:58 mysqld restarted 060314 16:40:58 [ERROR] InnoDB: syntax error in innodb_data_file_path 060314 16:40:58 [Note] /usr/local/mysql/bin/mysqld-max: ready for connections. Version: '5.1.7-beta-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - Experimental (GPL)