Connection Error - Errno 4
I have a clients-server application that is using (the server) mysql.
Time to time, I'm getting the error :
Can't connect to MySQL server on 'x.x.x.x' (4) (mysql_errno = 2003).
Mysql is 4.0.18. It's on a debian with 2.4.20.
4 is so the errno, wich here is :
[color=blue]
>Error code 4: Interrupted system call[/color]
Is there a way to prevent mysql from beeing interrupted in its connection phase ?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
ERROR 1010 (HY000): Error Dropping Database (can't Rmdir '.a', Errno: 41)
I am using MySql 5.0.21-community Edition for widows XP. I can successfully connect to the MySql Server as a root and create a database 'a'. Which creates a directory 'a' under my mysqldata directory with a single file 'db.opt'. Now dropping the database 'a' gives the following error ERROR 1010 (HY000): Error dropping database (can't rmdir '.a', errno: 41) The directory mysqldataa does not have any other files or hidden files. The commands I have executed are: ------------ Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 6 to server version: 5.0.21-community-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> create database a; Query OK, 1 row affected (0.09 sec) mysql> drop database a; ERROR 1010 (HY000): Error dropping database (can't rmdir '.a', errno: 41) mysql> --------- I have searched web, lists, bugs and could not find any.
Error 1005 <errno: 121>
I am trying to create a table, i have already created the Member Table so there should be a problem with the Foreign key i take it ?? I keep getting this message though ( Error 1005 <errno: 121> ) ......
Error On Create - Errno:150
Does anyone see any reason why the following query would fail...I have tried several other ways to write this with varying syntax and they all fail...I am trying to port this table over from Oracle (to MySQL) and I am using the cluster version of the software. Thanks, Shain CREATE TABLE `dyn`.`type_audio_props_for_creatives` ( `tapfc_bitrate` DECIMAL(22, 0) NOT NULL, `tapfc_channel_mode_id` DECIMAL(22, 0) NOT NULL, `tapfc_media_format_id` DECIMAL(22, 0) NOT NULL, `tapfc_is_partner` DECIMAL(22, 0) NOT NULL DEFAULT 0, PRIMARY KEY (`tapfc_channel_mode_id`, `tapfc_is_partner`, `tapfc_bitrate`), CONSTRAINT `r_3` FOREIGN KEY (`tapfc_channel_mode_id`) REFERENCES `dyn`.`type_channel_mode` (`channel_mode_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `r_4` FOREIGN KEY `r_4` (`tapfc_media_format_id`) REFERENCES `dyn`.`type_media_format_creatives` (`creative_media_format_id`) ON DELETE SET NULL ON UPDATE NO ACTION ) ENGINE = INNODB;
ERROR 1006: Can't Create Database 'X'. (errno: 13)
I am working on Mac OSX 10.2.8 with mysql 4. I needed to change the data directory of MySQL from its original place (where the application have to be and not the databases because there is not enought room) to an other volume of my computer. I made a symlink from data to data in the other volume and not anymore as it was to var in the same volume before. I copied all files and directories of var in this new directory -data-. I changed with mysql mysql all this file and directories (group and owner). And I made : create database X; ERROR 1006: Can't create database 'X'. (errno: 13) I hope what I explain is clear! What did I forget ? Do I have to put also var in this new other directory? Do I have to reinstall completly MySQL because I corrupted to much this application?
ERROR 1135 (HY000): Can't Create A New Thread (errno 12);
I'm running MySQL 5.0.41 (Server version: 5.0.41-community-nt-log MySQL Community Edition (GPL)) on Windows Server 2003 Enterprise Edition (w/ PAE) with 16GB of RAM and I'm getting the following error when MySQL has been running for 12-24 hours (this is a productional enviroment). ERROR 1135 (HY000): Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug I have more then 11GB of available RAM whenever I see this error. Could it be that the Community Edition does not support 16GB of RAM ? If so then what are my options?
ERROR 1005: Can't Create Table './MRI/test.frm' (errno: 150
I am getting the above error. I have created 2 tables: categories: id, code varchar(50) not null, name, primary key (code)) type=InnoDB; quest: id, code varchar(50) not null, name, primary key (code), index (code), foreign key (code) references categories (code)) type=InnoDB; When I try n create ques table, it gives me an error.
ERROR 1017 (HY000): Can't Find File: './media_data/logfile.frm' (errno: 13)
I am having the problem of select data from tables in a database(s). The message we get is: ERROR 1017 (HY000): Can't find file: './media_data/logfile.frm' (errno: 13) We re-booted the machine (Suse Linux) and restarted the mysql server using: mysqld_safe & We verified that the file being pointed out in the error message actually exists. The directory and file has 777 as the permissions. We verified that the contents in my.cnf has not changed. We can do show tables, show databases after logging into mysql as follows: mysql -u root -p mysql> show databases; (** WORKS **) mysql> use pammi; (** WORKS **) mysql> select * from logfile; ERROR 1017 (HY000): Can't find file: './media_data/logfile.frm' (errno: 13)
ERROR 1005: Can't Create Table './db/table.frm' (errno: 150)
I found the key to solve this problem in: http://darkstar.ist.utl.pt/mysql/do...onstraints.html You'll probably need an INDEX for that new foreign key you are declaring in older versions this isn't neccesary but in latest ones it is a restriction. You can have more info about the error description if you have root access by typing mysql> show innodb status; LATEST FOREIGN KEY ERROR ------------------------ 030807 1:27:10 Error in foreign key constraint of table database/table: There is no index in the table database/table where the columns appear as the first columns. Constraint: foreign key (key) references database.table(key) on delete cascade) type=innodb also if you type: shell> perror 150 you obtain: 150 = Foreign key constraint is incorrectly formed I hope this to be enough...
Connection Error
I am currently running two servers one with Tomcat and the other with MySQL. They are both in different Windows domains and on different network segments. I have the following users on the MySQL server: user@localhost user@% I am getting a VERRRY SLOOOW connection between the two machines so I thought I'd add a user just for the Tomcat server. The IP address of the Tomcat server is 172.22.0.1 so naturally the user would be 'user@172.22.0.1' When I added this user I got the following error Access denied for user: 'user@172.22.0.1' (Using password: YES) Any ideas on what I can do to remedy the situation?
Error In Connection
2003 - Can't connect to MySQL server on 'localhost' (10061) I get this error
Connection Error
When I connect to the MySQL server (4.0.16 on Linux) using mysql and let the tool sit for a couple of minutes, I get the following error. mysql> use mysql; No connection. Trying to reconnect... Connection id: 50791 Current database: *** NONE *** Database changed mysql> use mysql; Database changed mysql> The Java programs are displaying a similar error --> "java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null" No errors in the MySQL logs. The max_connections are set to 1000. Why am I losing my connection to the database?
No Connection Error
When I connect to the MySQL server (4.0.16 on Linux) using mysql and let the tool sit for a couple of minutes, I get the following error. mysql> use mysql; No connection. Trying to reconnect... Connection id: 50791 Current database: *** NONE *** Database changed mysql> use mysql; Database changed mysql> The Java programs are displaying a similar error --> "java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null" No errors in the MySQL logs. The max_connections are set to 1000. Why am I losing my connection to the database? How can this be fixed?
Connection Error
I've a db named "controlloscatole" on my PC which has IP: 192.168.50.195 I've created a user which hasn't generic privileges but he has only SELECT privilege to "controlloscatole": GRANT USAGE ON * . * TO "rep_ammin"@ "%"IDENTIFIED BY "***************"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; REVOKE ALL PRIVILEGES ON `controlloscatole` . * FROM "rep_ammin"@ "%"; REVOKE GRANT OPTION ON `controlloscatole` . * FROM "rep_ammin"@ "%"; GRANT SELECT ON `controlloscatole` . * TO "rep_ammin"@ "%"; If i try to access to controlloscatole as rep_ammin: * via MysqlCC *host: localhostall is ok. *host: 192.168.50.195ERROR 2003: Can't connect on 192.168.50.195 (10061) * via phpmyadmin *http://localhost/mysql/all is ok *http://192.168.50.195/mysql/ALL IS OK!! * via ODBC *host: localhostall is ok. *host: 192.168.50.195ERROR 2003: Can't connect on 192.168.50.195 (10061) So if i try to connect to my db as rep_ammin from my PC i've no problem. On the contrary nobody in my office can do that... via Access (ODBC) or MysqlCC.
Connection Error
There seems to be a problem with the MySQL server, sorry for the inconvenience. So I start the MYSql server by the command: mysqld --skip-grant-tables and I can get in fine from the webside but once i get it out of this mode i can't hit it from the webside BUT i can hit it with MYSql GUI tools to setup users/db/grants/etc. All idea why and what i need to do?
Connection ERROR
I have been setting up a sever on one of my PC's using Apache and have installed MYSQL to work off it. Now i am getting error : CONNECTION FAILES: 2003 - Can't connect to MYSQL server on Localhost (10061) Now i have previously set this up and it has usually worked but i dont know what i have doen this time for it not to work? Has anyone got any ideas what i can do?
How To Solve This Connection Error?
I have this connection error in my windows application which is using .net connector. The error is "Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host" ? Can some one please help me on this?
MySQL Connection Error
I am trying to put together this PHP script using the database for IPB. I just can't get this one part of the script to work. It is supposed to access the members database, and it just can't find the members database. I get the error Quote: Unable to view external table, ipf_members. Table 'username_ipb.ipf_members' doesn't exist. username would be my MySQL username, but I won't post that. I know the username works, because all other MySQL connections using that same username work. I took the piece of code that wasn't working out of the file and tried putting it in its own little test file, and it still wouldn't work. PHP <?php$wgIPB_MySQL_Host = 'sql1.byethost7.com' // ipB MySQL Host Name.$wgIPB_MySQL_Username = 'username' // ipB MySQL Username.$wgIPB_MySQL_Password = 'k1tens' // ipB MySQL Password.$wgIPB_MySQL_Database = 'username_ipb' // ipB MySQL Database Name.$wgIPB_UserTB = 'ipf_members' // Name of your IPB user table. (i.e. ipb_members)$wgIPB_UserConvergeTB = 'ibf_members_converge' // Name of your IPB users converge table (i.e. ibp_members_converge)$wgIPB_GroupsTB = 'ibf_groups' // Name of your IPB groups table. (i.e. ipb_groups)$wgIPB_User_GroupTB = 'ibf_groups' // Name of your IPB user_group table. (i.e. ipb_groups)$username = "chris"; $connection = mysql_connect($GLOBALS['wgIPB_MySQL_Host'],$GLOBALS['wgIPB_MySQL_Username'],$GLOBALS['wgIPB_MySQL_Password']) or die ("Couldn't connect to server"); $db = mysql_select_db($GLOBALS['wgIPB_MySQL_Database'],$connection) or die ("Couldn't select database"); $getuserinfo = "SELECT `name` FROM " . $GLOBALS['wgIPB_UserTB'] . " WHERE `name` = "" . $username . """; // Query Database. $userResult = mysql_query($getuserinfo) or die("Unable to view external table " . $GLOBALS['wgIPB_UserTB'] . " " . mysql_error()); $userinfo = mysql_fetch_array($userResult); echo $userinfo['name'];?> I normally would use the $GLOBAL['variable'] if the variable was defined in the same file like the code above, but I just wanted to see if I could get this block of code to work. I know for a fact that ibf_members exists. Here is a screenshot from phpMyAdmin. I just don't know how to fix this problem! The table exists. I have tried repairing the table. I have tried reinstalling IPB. Nothing works!
Ado Connection String Error Through Vb
I'm using mysql-5.0.1-alpha-snapshot-win & VB 6.0 I'm having trouble connecting to the database server over a lan. When I use the following connection string from the server it works fine. - adoCon.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=MyDatabase;uid=root;" When I use the the following connection string from another computer I get this error - adoCon.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};SERVER=192.168.0.2;DATABASE=MyDatabase;uid=Tom;pwd=X12;" Run-time error '-2147467259(80004005)' [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '192.168.0.2' (10060) Also when I try the last connection from the database server and in vb (not compiled) I get the following error - Run-time error '-2147467259(80004005)' [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client In MySQL CC under users - Username = Tom Host = % Password=X12 Global privileges and MyDatabase are checked with All Privileges
MySQL Connection Error
I have my web server on a Linux machine. Apache 2.0, MySQL 5 and PHP 5 I have a utility (phpmaker) that helps me administer my databases. When I went to set it up I get this connection error. "Error on connect: Host 10.1.1.10 is not allowed to connect to this MySQL Server" Where do I enable so this ip (host) is allowed?
Connection Error Err Nr 1045
I am trying to set up MySQL 4.1 on windows 2003 web server. I have installed mysql and when configuring i get the Err Nr 1045 Access denied for user root@local host (using password: No) when trying to apply the security settings. I have running a linksys rooter. I have configured the rooter to allow access to port 3306 and forwarded to the web server.
Connection Error (2013) Using TCP/IP
When I try to connect to a remote MySQL server with following command: >mysql -h myhost.com -u mysql -p I'll occasionally get an error message saying: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 104 This is quite often when I using a remote client, but never happens if I use the local client on the MySQL server. Is this a known bug or anyone knows a solution to this problem? Code:
MySQL Connection Error
Using MySQL server config wizard, I created a database 'polls' and set passwd as 'admin'. I used the following PHP code to connect this db: $host = "localhost:3036"; $user = "polls"; $pass = "admin"; $conn = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); mysql_select_db($user) or die ("Unable to select database!"); and I got the following error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'polls'@'localhost' (using password: YES) in C:ServerApache2 htdocsPollsuser.php on line 17 Unable to connect! and BTW, what is the difference between the user name and db name? when I try to connect the db from DOS, it just prompted for password only, not username.
Dreamweaver Connection Error
I have set ODBC connection up through the data source administrator and get a connection just fine. However, in Dreamweaver I now get the 400 bad request error.
ODBC Connection Error
I am trying to configure an ODBC connection to a MySQL database, 5.0.12 Beta-nt. We testing the connection I get the following error; [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query If I try to connect via cmd prompt the following message is displayed; ERROR 2013 (HY000) : Lost connection to MySQL server during query The strange thing is if I disable Norton Internet Security all works fine. The Windows Xp firewall is turned off and Norton has been configured to allow MySQL.
Host Connection Error
I am getting an error, when I try to connect to the MySQL Administrator, I put in the computer IP and my username/password, but when I try to connect I get an error. The error reads... Error: Host "X.X.X.X" is not allowed to connect to... and then the rest of the error i can't read, it's been cut off. I did ping the host and it was fine, so there is not a network problem, or so i think... If someone could please tell me what is going on that wold be great.
Mysql Tcp Connection Error
The configuration of MySQL on my linux box is somehow set that I cannot use TCP to connect to it When I try to logon from the CLi/telnet, it says: Quote: [root@chrislinux chris]# mysql ERROR 1045 (00000): Access denied for user: 'root@localhost' (Using password: NO) If I try to use a connection within a program like Zend IDE, it says: Quote: Server connection failure during transaction. Due to underlying exception: 'null, message from server: "Host chris.linux is not allowed to connect to this MySQL server". I did have skip-networking uncommented but that just produced a pipe error. I have restarted mysql everytime I have made a change to my.cnf as well. Can anyone point me where to look to possibly find the cause of this? Thanks for any help anyone can give.
Remote Connection Error
I have been using a database on localhost for a while succesfuly. I am now, however going to be using this same database remotely. Whenever I attempt to connect to the database remotley I am given the error message: Warning: mysql_connect(): Can't connect to MySQL server on 'my ip' (10060) in C:OpenSAApache2htdocsindex.php on line 9 I have removed the bind-address line from the my.ini file in C:Windows as I read in a previous post you should do, and restarted mysql, but the error still remains. Does anyone know what i'm doing wrong?
MySQL Connection Error
I am new to remote mySQL connections. I am getting an error when I know the hostname for the connection is correct... please help ERROR Warning: Host 'oltws002.gaa.aro.allied.com' is not allowed to connect to this MySQL server in d:platformheader.php on line 231 Warning: MySQL Connection Failed: Host 'hoster.com' is not allowed to connect to this MySQL server in d:platformheader.php on line 231 Connection with MySQL server could not be made! Host 'hoster.com' is not allowed to connect to this MySQL server Contact Matt at matt@hoster.com if this problem persists.
Error 2003 On Remote Connection
I have a WinXP Home Edition where I have installed MySQL 4.x I can use MySQL Administrator on my server, but when I try to connect to my server by entering my WAN-IP, I get the error: "Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on xx.xx.xx.xx (10061)".
MySQL Start Up And Connection Error
I m new to mysql and recently installed 5.0.24a on my XP SP2 machine. Server ran fine for a coupla days.I then noticed that mysql admin client can't connect (error 10061). MySQL windows service has stopped for some reason, can't restart from windows services. Restart fails with the following error (from Windows event viewer) Event ID - 100 Description - listen() on TCP/IP failed with error 6
Error Establishing A Database Connection
I'm trying to use MySQL on my computer to design and test a WordPress blog locally, but I keep getting the message, "Error establishing a database connection." This isn't limited to WordPress; if I run a simple MySQL test script I get the same problem. I'm using MySQL 4.0.21 (I installed this old version after getting the same results with a couple of newer versions, so I don't think this is the problem). I'm on OS X 10.4.8. Using MySQL Administrator, I'm able to connect to the server as root. I created my wordpress schema and assigned all available connection privileges to root on localhost, [computername].local, and %. I'm used to creating a database and assigning a user to it using cPanel. I suspect the solution is simple and I'm overlooking something obvious because of my newbie status when it comes to MySQL.
Client Side Connection Error
I'm getting this error message: "Cannot connect to database. Client does not support authentication protocol requested by server; consider upgrading MySQL client" When attempting to connect with: $mysql = mysql_connect( 'localhost', 'root', 'password' ); MySQL Version: 4.1.8-nt via TCP/IP Client: 5.0.11 OS: Windows XP I believe that I have the latest client. What should I do and how should I ensure that none of the visitors to my site has the same problem?
UNION Causes Lost Connection ERROR 2013
I wrote a for loop to build several select statements that are combined with a UNION. When I execute one of the queries separately, it works, but when I execute the query with a UNION it returns: ERROR 2013 (HY000): Lost connection to MySQL server during query I am able to run additional queries after I get the error, so the connection is not lost. I have tried running the query with the union on MySQL Query Browser and also on the command prompt and I get the same results. Here is my query:
MYSql Windows 2003 - Connection Error
I installed MYSql/PHP/Apache on my Windows 2003 server. I created my database, added users and granted FULL perrmissions to all my uses but when i go to connect i get: There seems to be a problem with the MySQL server, sorry for the inconvenience. So I start the MYSql server by the command: mysqld --skip-grant-tables and I can get in fine from the webside but once i get it out of this mode i can't hit it from the webside BUT i can hit it with MYSql GUI tools to setup users/db/grants/etc.
ERROR 2013: Lost Connection To MySQL Server During Query
I have recently installed suse 9.0 linux which has MySQL 4.0.15 as part of the distribution. After I set up my users I was able to use mysqldump and pipe it into mysql on my windows machine running 4.0.16 to dump a database to the linux box. However, now when I try to login to the linux box from another machine on the network I get a query timed out error immediately after I enter the command line to start the mysql client. mysql -h 192.168.1.2 -u cdw -pxxxxxx ERROR 2013: Lost connection to MySQL server during query The error happens with in a small fraction of a second after I type in the command. I can login from the linux machine just fine though.
Error 2013: Lost Connection To MySQL Server During Query
I have MySQL 4.1.10 running successfully on an office XP machine, but when I try to set up similar XP box at home I continually get this error: "Error 2013: Lost connection to MySQL server during query". The install went fine, and Windows XP is recognizing it as a running service. But whenever I try to connect via one of my GUI applications (e.g., MySQLFront), the error appears. I have scoured this forum and Google looking for this error, but haven't found anything helpful so far. This post ... (http://forums.mysql.com/read.php?11,10684,10684) seemed similar, but my service does not stop when I hit the error. I've lost a couple days to this problem, and I've uninstalled and reinstalled the app several times. I don't know where to go next. I need to have 4.1 running because we need the Unions and Subqueries.
Network Problem - ERROR 2013 (HY000): Lost Connection ....
I'm having problems with my MySQL server when I do queries that return a lot of data over the network. It's fine if I connect via the local UNIX socket > mysql -u root -p > SELECT * FROM users limit 100; returns 100 rows in a few seconds >SELECT * FROM users limit 1000; returns 1000 rows in a few seconds But when I try the same thing but connecting to the network port I get > mysql -u root -p -h 127.0.0.1 -P 3306 > SELECT * FROM users limit 100; returns 100 rows in a few seconds > SELECT * FROM users limit 1000; sits there for about 15 minutes and then I get the following message ERROR 2013 (HY000): Lost connection to MySQL server during query If I watch the traffic with tcpdump it sends a few packets right at the start and then doesn't appear to be sending anything for the next 15 minutes until the error appears. I'm using 5.0.27-standard-log community edition.
Error 2013: Lost Connection To MySQL Server During Query
I have MySQL 4.1.10 running successfully on an office XP machine, but when I try to set up similar XP box at home I continually get this error: "Error 2013: Lost connection to MySQL server during query". The install went fine, and Windows XP says it has started and is running as a service. But whenever I try to connect via one of my GUI applications (e.g., MySQLFront), the error appears. I have scoured this forum and Google looking for this error, but haven't found anything helpful so far. I've lost a couple days to this problem, and I've uninstalled and reinstalled the app several times. I don't know where to go next. I need to have 4.1 running because we need the Unions and Subqueries.
Error 2013: Lost Connection To MySQL Server During Query
I get this message instantly (< 1 second) when I try to connect to the MySQL server from a remote host. I am using "mysql" at the remote client. Does not matter where the remote client is: on Solaris, on RH 7.2, on Fedora. Same thing every time. I am using the the mysqld as it comes out of the box on Red Hat Linux 8.0. I tried a google search on Error 2013, and there are a lot of responses:
SQL Execution Error # 2013. Response From Database: Lost Connection To MySQL Server
I'm upgrading to v4.1 from v3.2 on a Windows XP box; I did an uninstall on the previous version, but Windows services did not remove it as a service (v4.1 was logged as a new service, MySQL4). I breezed through the install process, but I get an error when I try to launch the .exe file from the command line. It says ... "ERROR 2013 (HY000): Lost connection to MySQL server during query." MySQL4 is now an automatically started service under Windows and mysqld-nt is operating in the Task Manager as a process. When I try to connect via MySQLFront, I get the following error message: "SQL execution error # 2013. Response from database: Lost connection to MySQL server during query."
User-defined Function: ERROR 2013 (HY000): Lost Connection To MySQL Server During Query
With mysql-4.1.1-alpha, using any User Defined Function ( UDF) at the query execution stage, on Linux 2.6, gave me the following error: "ERROR 2013 (HY000): Lost connection to MySQL server during query" However, upgrading to mysql-4.1.2-alpha seemed to solve the problem. Both versions were configured exactly as follows ../configure --with-openssl --enable-thread-safe-client --with-mysqld-ldflags =-rdynamic The only way I could solve this was by upgrading to 4.1.2-alpha-log. Then, recompiling the functions, drop the old UDF functions, then, recreate. So far so good. Anyway, if you run into this problem, or just want more detail on the sample User Defined Functions that come with MySQL ( /sql/udf_example.cc), I've put my notes in the following link ( TIP 27 )
Lost Connection To MySQL Server During Query Socket Error On Read. WSAGetLastError Return 10054($2746)
We just migrated our MySQL database from a NetWare server running version 5.0.21 to a openSUSE box running version 5.0.45. Everything ran fine for a couple of days, then clients began losing their connections and creating new ones without the old threads being terminated. This behavior is the same for the Delphi client we use to access our database as well as the MySQL Administrator tool. I've tried adjusting connection_timeout, but overall the settings for this server are the same as the previous one that ran without issues for a year.
Errno:145
This is the fifth time I can not access my tables because of this error. In the past I recreated the tables and moved forward. Is there anything I can do to retreive the data I can not get to because of this error.
|