Software :: MySQL Error: Writing File '/tmp/MYrZo6Qh' (Errcode: 28)?

Nov 15, 2010

No, the disk is not full and there are only a few files in tmp directory, but some MySQL queries return this error:

Error writing file '/tmp/MYrZo6Qh' (Errcode: 28)

Something strange:

PHP Code:

select from table where c1='1' and c2='1' and c3='1' 

returns Error 28 but

PHP Code:select from table where c1='1' and c2='1' and c3='0' 

View 6 Replies


Server :: NFS Large File Copies Fail - Error Writing To File: Input/output Error?

Jun 27, 2009

I recently upgraded my file/media server to Fedora 11. After doing so, I can no longer copy large files to the server. The files begin to transfer, but typically after about 1gb of the file has transferred, the transfer stalls and ultimately fails with the message:

"Error writing to file: Input/output error"

I've run out of ideas as to what could cause this problem. I have tried the following:

1. Different NFS versions: NFS3 and NFS4
2. Tried copying the files to different physical drives on the server.
3. Tried copying the files from different physical drives on the client.
4. Tried different rsize and wsize block sizes when mounting the NFS share
5. Tried copying the files via a different protocol. SSH in this case. The file transfers are always successful when I use SSH.

Regardless of what I do, the result is the same. The file transfers always fail after approximately 1gb.

Some other notes.

1. Both the client and the server are running Fedora 11 kernel

I am out of ideas. Has anyone else experienced something similar?

View 13 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/': No such file or directory


View 6 Replies View Related

Red Hat / Fedora :: Pipe MySQL Dump To FTP Without Writing To Disk

Aug 8, 2010

I've got a Centos 5 machine running with a raid 1 SSD hard drive combo, as I don't know how or even if it's possible yet to wipe the free disk space clean I need to be careful to not fill all the free disk space. As I don't want to fill the free disk space too quickly and was wandering if it is possible to pipe the result of a mysqldump to a FTP client only writing it to the ram and not writing it to this disk.

I've done a bit of research on the subject and have found the two following commands:
Code: mysqldump < mysqldump options> | gzip > outputfile.sql.gz
Code: tar cf - / | ncftpput -c /usr/local/backup.tar

I would like to combine the two to make something like this:
Code: mysqldump mysqldump_options > | ncftpput ncftpput_options -c SERVER_IP backup.sql

I haven't actually tried my code as it seems too easy and I'm sure I've got something wrong! If this command is even correct will it prevent the sql file from being written to the hard drive to my local machine?

View 4 Replies View Related

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

Jun 17, 2010

I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this

* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.

View 1 Replies View Related

OpenSUSE :: MySQL Error 2002 (HY000): Can't Connect To Local MySQL?

Dec 6, 2010

I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).

Error I receive is:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View 6 Replies View Related

Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?

Jan 14, 2011

i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :

/sbin/iptables -A INPUT -i eth0 -s -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address =" and nothing


View 4 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.

Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.

Howver, just been trying to again to fix the problems with downgrading mysql and get:-

Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14

View 7 Replies View Related

Fedora :: Mysql Error When Type Mysql Into The Command Line?

Jan 16, 2011

I have mysql downloaded and when I type mysql into the command line I get this:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

View 6 Replies View Related

Ubuntu :: Mysql 5.5.6-rc Error During 'make' Part Of Compilation Of Mysql V5.5.6rc?

Sep 26, 2010

getting foll error during 'make' part of compilation of mysql v5.5.6rc

libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.

View 9 Replies View Related

Software :: ERROR: Unable To Find Mysql Headers (mysql.h)

Apr 3, 2010

I'm trying to install snort- on centos5-i386 an I get this error from ./configure --with-mysql --enable-dynamicplugin command:

ERROR: unable to find mysql headers (mysql.h)
checked in the following places


I've read here it has to do with libmysqlclient12-dev. How can I install libmysqlclient12-dev on centOS?

Is it possible to install snort from repositories using yum?

View 3 Replies View Related

CentOS 5 :: Error: Mysql Conflicts With Mysql-server-community

Jun 4, 2009

I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says

mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community

View 16 Replies View Related

CentOS 5 Server :: MySQL On Cent OS 5.2, Error In MySQL

Mar 3, 2009

I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -

socket = /var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).


View 16 Replies View Related

Software :: Writing An ISO File For Cd Audio From A Cue And Wave File?

Nov 30, 2008

I am running Intrepid Ibex 64-bit, and I have recently ripped a cd with EAC on one of my windows boxes, and it produced a cue sheet and one single wave file for the entire cd. My question is this, is it possible to take the wave file, burn an ISO image that acts exactly like the original cd? In other words, take the single wave file, using the cue sheet splitting it back into it's individual tracks, and then reading the subsequent ISO image from a program like Sound Juicer, so it can write all the metadata and convert it with my own preferences. I know this is a very strange predicament, but it's one that would save me a world of hassle.

View 5 Replies View Related

OpenSUSE :: MySql Won't Start / No File Mysql.sock?

Feb 5, 2009

I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:

linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds

View 9 Replies View Related

Red Hat / Fedora :: Writing To Log File In C?

Apr 1, 2010

I am trying to write into a single log file from 3 different applications in C. In one of the applications I am forking out 5 instances. I would like to know what is the best way to open and close the log file in which i want to write from these applications. Should I open and close it at the start and end of each application or is it ok performance wise if i open and close it inside the log function which will be called for every write.

View 6 Replies View Related

General :: Writing To A File Using Sed?

Mar 3, 2011

i am having a the following line in a file

<property name="connection.password"></property>

i have to give password in this line, like this

<property name="connection.password">XXXXXX</property>

Is this possible to acheive this using sed command

Beause i have to do this for n number files. so if i have option in sed for this the i will be doing this using script.

View 7 Replies View Related

OpenSUSE Network :: CIFS Writing Error In 11.4?

Aug 23, 2011

I mount the share on my Windows server with following command:

mount -t cifs -o username=Administrator,password='mypassword',rw,dir_mode=0777,file_mode=0777,nobrl,uid=1000,gid=100 // /mnt/

In my 11.3 computer it works well. I opening, copying files like I do in local filesystem. At the same time it's not working well on my 11.4 computer: the share mounts without errors, I see all files, can copy them from server to local computer. But when I'm trying to make copies to server, sometimes I receive messages like "Error writing file ...". Not always, but in the most part of my attempts. find the part of my /var/log/messages file:

Aug 23 17:35:55 linux-393i kernel: [ 3522.419904] CIFS VFS: Unexpected SMB signature

I use following kernel:

View 9 Replies View Related

Ubuntu :: An Error Occurred While Writing To Disc

May 20, 2011

Trying to burn a DVD full of media and I keep getting errors on both above programs. Here is the error oupout I get from Brasero:


Checking session consistency (brasero_burn_check_session_consistency brasero-burn.c:1744)
BraseroBurnURI called brasero_job_get_action
BraseroBurnURI called brasero_job_get_action


Session error : An error occurred while writing to disc (brasero_burn_record brasero-burn.c:2862) Anyone know what I can do to fix this and get things up and running again? Would like to be burning to DVD's again. Running 11.04 and also had the same problem with 10.04.

View 9 Replies View Related

Software :: Error Writing Blu Ray Data Discs With K3b?

Dec 5, 2010

Does k3b require free hard drive space at the finalize media stage? I'm trying to write a 17.6 GB file to 25 GB media with 18 GB free space on the hard drive. My disc seems to write 100% then displays "Error". This is the debugging code:

Burned media
BD-R Sequential (SRM)


View 4 Replies View Related

General :: Writing Array Into File?

May 3, 2010

How can we write arrayValues in file? Lets say arrayName=(1 2 3 4 5) Now if i want to write these arrayValues into file

In first line in file :1
In second line in file :2
In third line in file :3
In fourth line in file :4
In fifth line in file :5

View 3 Replies View Related

General :: Writing Text To A File?

Mar 18, 2010

I am using Grass GIS

I have written a script which outputs a list of numbers to a file

code snippet:

r.stats -1 fs=, input=Bones_AVE > /home/gary/AVE_monte_carlo/rstats_AVE$i.csv

so this makes acsv file with one column. I want to run it again but rather than outputing to a new csv i want to add it to this one as the next column. For this example there will be 100 rows per column.

the 1st one will make the file

[grassGIS code]> /home/gary/AVE_monte_carlo/rstats_AVE.csv
add ',' after each value
the next one
[grassGIS code] open file /home/gary/AVE_monte_carlo/rstats_AVE.csv


View 1 Replies View Related

Programming :: Writing File In Perl/cgi?

Apr 10, 2010

I'm not able to write to a file using my perl cgi script which is as fallows:

#!/usr/bin/perl -w
use strict;
print "Content-type: text/html


View 4 Replies View Related

OpenSUSE :: Permission Error When Writing To NTFS In Dolphin / Get Rid Of It?

Mar 2, 2010

I'm fairly new to linux and I have a dual boot laptop with OpenSUSE 11.2 and Windows 7. I have ntfs-3g and have full read-write ability to my Windows drive through OpenSUSE thanks to NTFS - openSUSE. The only problem is whenever I write to the NTFS Windows drive via Dolphin it does the writing but I get an alert box saying:
"Could not change permissions for <path to new file>" with an OK button.
If I write more than one file I'll get one alert box for each file unless I don't press OK until after it finishes writing all the files in which case it will just give me that one that it was showing (once I press OK there aren't any more boxes).
Since I have full ability to read-write this isn't that big of a problem it's just annoying as hell an I'm sure it's pretty simple to get rid of. code...

View 3 Replies View Related

General :: RPM - Writing Script In Specific File

Apr 11, 2011

Is it possible to write ksh script in the spec file? The target is after I perform
rpm -i my_rpm.rpm
According to the spec file, ksh script will do some installation & configuration. For example run other script and edit some files.

View 1 Replies View Related

Ubuntu :: Avoid Users Writing On The Same File?

Feb 27, 2011

Is it possible to forbid that more then one user open the same file in rw mode? In windows when you open a file that another user is using, there's ad advise and you have to open it in read only mode

I installed ubuntu 10.04 desktop edition on 3 pc (there is not a server-client architecture). I installed samba.(and smbfs)

put the strings:
comment = ...
path = /...
guest ok = yes
read only = no
create mask = 0777
directory mask =0777

Computers that access to that directory do (on boot, with root privileges)
mount -t smbfs -o username="user",password="pass" // /mnt/cartelladimontaggio

But if two users access to the same file, both are authorized writing on it! So changes made by one are lost when the other save.

View 4 Replies View Related

General :: Detect If A Program Is Writing To A File?

Mar 3, 2009

I have custom software that writes to a sensitive large file when the user does something. I would like to make backup copies of The file that gets written to, but if I make a gzip of the file at the same time someone is changing something, it will corrupt the backup because some of the data will be missing, as its backed up during being written to.

a) Is there a way to detect if a file is currently being accessed/written to?
That way if its currently being accessed, I can just make the script wait until its done and then finally back it up.

b) Instead of backing up the large file while it has potential to get written to, would it be better to make a copy of the file first, then gzip the copy? This idea comes from the fact that gzipping the original takes 5-10 seconds, whereas making a copy only takes 1-2 seconds. The less time, the less chance of corruption.

c) Is there anyway to freeze a program or a file to stop it from being written to for an amount of time?

With a, b, and c together. The best solution I have to my problem would be a script that first detects rather the file is being accessed. If not, it would then freeze the file/program and then make a quick copy of it. Once the copy is created, it will unfreeze the original file/program and then go about gzipping the copy.

View 3 Replies View Related

SUSE :: Writing To Log File Affecting Performance

Apr 8, 2010

I have 3 c files(one of them forks out 5 instances) all writing to one log file. Now to avoid the confusion of opening and closing in each application or instance and running into a situation of not having closed a file I decided to open and close the log file inside the log function for each write.

So what I do currently is fopen, flock, fwrite, unlock, fclose for each write. All the log messages from all the files get written fine and there are no errors but I see a performance hit. The applications talk to each other using SHM(shared memory). So when I try to set a timer and check number of messages lets say I get X messages. Each time I remove or add a log call the number of messages changes. When it is a 1 sec or 5 sec timer it doesnt make a very big diff..few hundreds but when I check it over a longer period..every log call added decreases 1000 messages in count. So I want to know what is an efficient way of implementing the custom log across the application.

View 6 Replies View Related

Programming :: [C++] Writing Double Value To A Text File?

Jun 3, 2011

int main ()


View 9 Replies View Related

General :: RPM + Writing Script In The Spec File?

Feb 23, 2011

is it possible to write ksh script in the spec file? the target is after I perform rpm -i my_rpm.rpm according to the spec file , ksh script will do some installation & configuration for example run other script and edit some files

View 5 Replies View Related

Copyrights 2005-15, All rights reserved