Displaying 20 results from an estimated 3000 matches similar to: "MySQL fails with tablespace on OCFS2"
2009 Jan 20
3
Re : problem with running mysql on glusterfs
Hello. I would like to ask about having mysql data hosted on glusterfs.
Please see my issue below. I have posted DEBUG log information on pastebin.
I am using
GlusterFS version: glusterfs 1.4.0rc7
FUSE Version :fuse-2.7.3glfs10
my ISSUE is:
When hosting mysql data on glusterfs I have an issue:
The first time I start the glusterfsd server using
[root at mohan ~]#
2008 Sep 03
23
error connecting to mysql
i was trying to setup an application checked out from svnin my local
machine. i managed to do all that is required except when it came to
the step of creating databases for the application, when i tried to
connect to mysql i got this error
ERROR 2002 (HY000): Can''t connect to local MySQL server through socket
''/var/lib/mysql/mysql.sock'' (2)
i have spent more than 5
2013 Sep 13
2
MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?
Hello,
I've only had experience with PostgreSQL sofar,
but have now to install MySQL (and WordPress)
on a CentOS 6.4 /64 bit server.
I have installed the mysql-5.1.69-1.el6_4.x86_64
package and executed the following commands:
# chkconfig mysqld on
# service mysqld start
# /usr/bin/mysqladmin -u root password 'xxxxx'
# /usr/bin/mysql_secure_installation
Then I've noticed that
2011 Feb 04
1
GlusterFS and MySQL Innodb Locking Issue
I'm having some problems getting two nodes to mount a shared gluster
volume where I have the MySQL data files stored. The databases are
Innodb. Creating the volume on the master server works fine and it
mounts, and when I mount that on the first mysql node it works fine,
too. However, when I try to mount it with the second node I get this
error:
InnoDB: Unable to lock ./ibdata1, error: 11
2012 Feb 07
1
MySQL on CentOS 6 broken? No 'mysql' database?
Hi Guys,
I installed CentOS 6 and installed 'yum install mysql mysql-devel mysql-server'
When I try and start MySQL I get:
120206 16:42:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120206 16:42:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120206
2005 May 24
8
mysql & xen - is anyone using this combination successfully?
Hi,
I''ve tried running the mysql daemon on a few different servers running Xen,
and seen two different sorts of problems.
In one case, on two identically configured systems, the mysql daemon segv''s
but restarts immediately. This happened with Xen 2.0.5, I haven''t yet seen it
with 2.0.6. It seems to be the same problem as this one:
2015 Mar 30
5
mysql can't connect from localhost -strange behavior
Hey all,
I've been having some trouble creating a mysql user that can connect to
the database from localhost. It's always been a straight forward thing to
do in the past, so its time for a sanity check, if you guys don't mind.
Ok, so here's the actual command with actual simplified password that I'm
using. It's on localhost so I don't think it's a security threat
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
Hi,all
I did some test about MySQL''s Insert performance on ZFS, and met a big
performance problem,*i''m not sure what''s the point*.
Environment
2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel).
A Java client run 8 threads concurrency insert into one Innodb table:
*~600 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=1
~600 qps when sync_binlog=10
2006 Jun 18
0
Out of Memory xenU
Hi,
i''ve a big problem in a xenU (256M RAM, 2.6.11.12-xenU, in 3 LVM partition
(/, swap and /home)
This xenU freeze and crash with this messages in syslog.
This xenU work very fine since 2005 september.
Is it serious ? What could be the solution ?
Regards
Franck
############ SYSLOG
......................
Jun 18 08:45:21 lemodev kernel: oom-killer: gfp_mask=0x1d2
Jun 18 08:45:21
2015 May 31
1
Using Mariadb databases from old server
------------ Original Message ------------
> Date: Saturday, May 30, 2015 12:27:26 AM -0400
> From: Ted Miller <tedlists at sbcglobal.net>
>
> On 05/29/2015 07:00 AM, Timothy Murphy wrote:
>> Todor Petkov wrote:
>>
>>>> I'm running CentOS-7, but I left some MySQL databases
>>>> on my old CentOS-6.5 partition which I'd like to retrieve.
2015 May 29
3
Using Mariadb databases from old server
Todor Petkov wrote:
>> I'm running CentOS-7, but I left some MySQL databases
>> on my old CentOS-6.5 partition which I'd like to retrieve.
>> I assume they are contained in the file /var/lib/mysql/ibdata1 ?
>>
>> Could I just copy this file to /var/lib/mysql in CentOS-7?
>> Or is there some way Mariadb or phpMyAdmin can import mysql databases
>>
2011 Oct 11
3
/etc/init.d/mysql =fail mysqld=success
Hello.
This is my mysql-server.pp file, both master and client are runing
ubuntu.
--------------------
class mysql-server {
package { "mysql-server": ensure => installed }
package { "mysql-client": ensure => installed }
service { "mysql":
enable => true,
ensure => running,
require => Package["mysql-server"],
}
file
2012 Aug 03
2
ot: mysql auth worker failure ?
looking through logs I noticed this today:
grep mysql /var/log/maillog | grep fail
Aug 3 17:35:25 dovecot: auth-worker(28335): Error: mysql: Query failed,
retrying: Table 'postfix.users' doesn't exist
Aug 3 17:35:57 dovecot: auth-worker(28335): Error: mysql: Query failed,
retrying: Table 'postfix.users' doesn't exist
Aug 3 17:36:02 dovecot: auth-worker(28335): Error:
2009 Nov 12
1
kernel error
Hi,
yesterday there was obviously a problem in one virtual server.
Host centos
uname -rm: 2.6.18-128.1.6.el5 x86_64
Guest: centos
uname -rm: 2.6.18-128.4.1.el5 x86_64
Vmware server : VMware-server-2.0.1-156745.x86_64.rpm
Logwatch in guest:
--------------------- Kernel Begin ------------------------
WARNING: Kernel Errors Present
[<ffffffff8005dde9>]
2009 Mar 23
0
MySQL ISAM can't start from OCFS2 filesystem
Hello friends,
I've got a strange problem with my cluster-setup.
I've got two nodes called www1 and www2 running Ubuntu Linux 8.10.
The have a 50G volume which is replicated in primary/primary mode with
DRBD.
On this volume there is an OCSF2 filesystem with this two nodes.
Everything is working really fine, files are perfectly mirrored, really
nice.
On one of the
2007 Jun 26
2
NFS, nested ZFS filesystems and ownership
Hello,
I''m sure there is a simple solution, but I am unable to figure this one out.
Assuming I have tank/fs, tank/fs/fs1, tank/fs/fs2, and I set sharenfs=on for
tank/fs (child filesystems are inheriting it as well), and I chown
user:group /tank/fs, /tank/fs/fs1 and /tank/fs/fs2, I see:
ls -la /tank/fs
user:group .
user:group fs1
user:group fs2
user:group some_other_file
If I mount
2009 Mar 18
2
Crash!!! -- Permission Error
I'm currently re-installing db41 port. Earlier using 'innodb_force_recovery = 6' seemed to fix that PANIC error. But I don't understand this permission error. I've tried various permissions as well 777, 766, 666, 760, etc etc. I've also ran mysqld_safe as root user, but with same permission error. Also tried different directories without luck.
When I log in to the
2010 Jan 12
1
Unable to map the group
Hi All,
I am using Samba 3.2.11 on sles 10. I have create a Unix group 'grp1' and
mapped it to a ntgroup "Group One". Unix group 'grp1' has one user i.e
'usr1'. 'net groupmap' command show the mapping with correct SID and gid
value. Please, have a look here.
# cat /etc/group | grep grp1
grp1:!:12613:usr1,raj1,raj2
#
# net groupmap list
Group One
2015 Mar 12
2
mysql replication - problems
>
> No: /etc/pki/CA should NOT be group writeable. Ditto for
> /etc/pki/tls/cernts and private
Ok, yeah I can understand that. I'll correct it. Still need a way to get
SSL enabled however. Any suggestions there?
Thanks
Tim
On Thu, Mar 12, 2015 at 11:40 AM, <m.roth at 5-cent.us> wrote:
> Tim Dunphy wrote:
> >>
> >> The mysqld process runs as the mysql
2009 Jan 14
3
stack overflow
Hi,
I've got a fileserver that runs Centos 5.2. It's been stable
otherwise stable for maybe a year or more, and now it's crashed three
times since Saturday. The first two times the computer was completely
unresponsive, and there was nothing on the console, and nothing in the
logs. I was beginning to suspect hardware, (esp. RAM, PSU, or maybe a
failed fan)
Last night it