Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]
Gleb Paharenko wrote: Hello. Check that MySQL doesn't die during the query. See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Gleb, I should mention that I get no log errors and I even have it set to warn does this mean mysql could die and not log the error? I have gone through this document for the last week rewritten code based on the suggestions and still get the error. Regards, Doug oug Dalton wrote: I am running mysql 4.1.13 on Suse 10 and I get an error on a simple select query, I have checked the threads on lost connection and my connection times as well as making sure my calls are all made from non forking processes etc... I cannot seem to resolve this error? can someone point me in the right direction? I notice if I remove the LIMIT statement I get fewer errors... but that cannot be the cause of the problem [14-Dec-2005 17:32:20] DB_Error Object ( [error_message_prefix] = [mode] = 1 [level] = 1024 [code] = -14 [message] = DB Error: no database selected [userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] = Array ( [0] = Array ( [file] = /usr/share/php5/PEAR/DB.php [line] = 888 [function] = PEAR_Error [class] = DB_Error [type] = - [args] = Array ( [0] = DB Error: no database selected [1] = -14 [2] = 1 [3] = 1024 [4] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativec ode=2013 ** Lost connection to MySQL server during query] ) ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]
Gleb, I watched the server during this error, the server continued to run... it didnt crash... and no warning or logged error? Regards, Doug Doug Dalton wrote: Gleb Paharenko wrote: Hello. Check that MySQL doesn't die during the query. See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Gleb, I should mention that I get no log errors and I even have it set to warn does this mean mysql could die and not log the error? I have gone through this document for the last week rewritten code based on the suggestions and still get the error. Regards, Doug oug Dalton wrote: I am running mysql 4.1.13 on Suse 10 and I get an error on a simple select query, I have checked the threads on lost connection and my connection times as well as making sure my calls are all made from non forking processes etc... I cannot seem to resolve this error? can someone point me in the right direction? I notice if I remove the LIMIT statement I get fewer errors... but that cannot be the cause of the problem [14-Dec-2005 17:32:20] DB_Error Object ( [error_message_prefix] = [mode] = 1 [level] = 1024 [code] = -14 [message] = DB Error: no database selected [userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] = Array ( [0] = Array ( [file] = /usr/share/php5/PEAR/DB.php [line] = 888 [function] = PEAR_Error [class] = DB_Error [type] = - [args] = Array ( [0] = DB Error: no database selected [1] = -14 [2] = 1 [3] = 1024 [4] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativec ode=2013 ** Lost connection to MySQL server during query] ) ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]
I found a log error after turning on warning running the server manually: 051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user: 'user' host: `client' (Got timeout reading communication packets) Any idea what this error is ? the interfaces show no errors from a network perspective: db machine eth0 Link encap:Ethernet HWaddr 00:30:48:2E:E1:F2 inet addr:10.0.0.10 Bcast:10.0.0.255 Mask:255.255.255.0 inet6 addr: fe80::230:48ff:fe2e:e1f2/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:7973410 errors:0 dropped:0 overruns:0 frame:0 TX packets:9299327 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:746369778 (711.7 Mb) TX bytes:8126772010 (7750.2 Mb) Base address:0x2000 Memory:da20-da22 client machine: eth1 Link encap:Ethernet HWaddr 00:30:48:55:92:4F inet addr:10.0.0.1 Bcast:10.0.0.255 Mask:255.255.255.0 inet6 addr: fe80::230:48ff:fe55:924f/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:19720381 errors:0 dropped:0 overruns:0 frame:0 TX packets:16126186 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:16315799815 (15559.9 Mb) TX bytes:1696496582 (1617.9 Mb) Base address:0xc400 Memory:fc9a-fc9c and the query runs fine a second time? so the query isnt malformed Regards, Doug Doug Dalton wrote: Gleb, I watched the server during this error, the server continued to run... it didnt crash... and no warning or logged error? Regards, Doug Doug Dalton wrote: Gleb Paharenko wrote: Hello. Check that MySQL doesn't die during the query. See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Gleb, I should mention that I get no log errors and I even have it set to warn does this mean mysql could die and not log the error? I have gone through this document for the last week rewritten code based on the suggestions and still get the error. Regards, Doug oug Dalton wrote: I am running mysql 4.1.13 on Suse 10 and I get an error on a simple select query, I have checked the threads on lost connection and my connection times as well as making sure my calls are all made from non forking processes etc... I cannot seem to resolve this error? can someone point me in the right direction? I notice if I remove the LIMIT statement I get fewer errors... but that cannot be the cause of the problem [14-Dec-2005 17:32:20] DB_Error Object ( [error_message_prefix] = [mode] = 1 [level] = 1024 [code] = -14 [message] = DB Error: no database selected [userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] = Array ( [0] = Array ( [file] = /usr/share/php5/PEAR/DB.php [line] = 888 [function] = PEAR_Error [class] = DB_Error [type] = - [args] = Array ( [0] = DB Error: no database selected [1] = -14 [2] = 1 [3] = 1024 [4] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativec ode=2013 ** Lost connection to MySQL server during query] ) ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
HELP [nativecode=2013 ** Lost connection to MySQL server during query]
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple select query, I have checked the threads on lost connection and my connection times as well as making sure my calls are all made from non forking processes etc... I cannot seem to resolve this error? can someone point me in the right direction? I notice if I remove the LIMIT statement I get fewer errors... but that cannot be the cause of the problem [14-Dec-2005 17:32:20] DB_Error Object ( [error_message_prefix] = [mode] = 1 [level] = 1024 [code] = -14 [message] = DB Error: no database selected [userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] = Array ( [0] = Array ( [file] = /usr/share/php5/PEAR/DB.php [line] = 888 [function] = PEAR_Error [class] = DB_Error [type] = - [args] = Array ( [0] = DB Error: no database selected [1] = -14 [2] = 1 [3] = 1024 [4] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativec ode=2013 ** Lost connection to MySQL server during query] ) ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FULLTEXT error?
Error SQL-query: CREATE TABLE quotes ( id int(9) NOT NULL auto_increment, author varchar(255), content text, PRIMARY KEY (id), UNIQUE KEY id (id), FULLTEXT KEY author (author,content) ) TYPE=MyISAM; MySQL said: You have an error in your SQL syntax near 'KEY author (author,content) ) TYPE=MyISAM;' at line 7 I have also tried to create the table and ALTER TABLE quotes ADD FULLTEXT author (author,contect) I get the same error, is this a function at is only in 3.23 Max or is it in the standard version as well? R/Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php