MySQL Server crashing database corruption

2007-10-07 Thread Samuel Vogel
Hey guys, First of all: I have tried to post this Issue on forums.mysql.com, but the Topic doesn't appear in the Forum. When I try to post again, it tells me that it's a duplicate?!?! Now the real problem: I have MySQL set up on two Servers with 7000 Users each and about the same amount of

Re: MySQL Server crashing database corruption

2007-10-07 Thread Samuel Vogel
I did some more research: I ran xfs_check on the partition and it didn't report any errors at all, so I'm guessing, that the hard drives are ok. I also recompiled MySQL with --with-debug. How would I get some debug output about the crashes now? Thanks, Samy Samuel Vogel schrieb: Hey guys,

Re: access privileges

2007-10-07 Thread Shams Fantar
Ananda Kumar wrote: Hi All, Today I installed mysql for debian OS. After the installation, i started mysql using mysqld_safe . Now if i try to connect to mysql using mysql -uroot -p, it fails, but if i use -habc it works. Do i need to set some parameters or give privileges, please let me

My first trigger in MySQL

2007-10-07 Thread Steffan A. Cline
I am new to triggers and am trying to figure this out. The goal I have is to set it up so that after a row in the users table is updated it will check to see if the affected row has a username in the username field and if not to update that row with a concatenation of firstname + + lastname.

Re: My first trigger in MySQL

2007-10-07 Thread Steffan A. Cline
on 10/7/07 12:26 PM, Steffan A. Cline at [EMAIL PROTECTED] wrote: I am new to triggers and am trying to figure this out. The goal I have is to set it up so that after a row in the users table is updated it will check to see if the affected row has a username in the username field and if not to

Re: MySQL Server crashing database corruption

2007-10-07 Thread Samuel Vogel
Actually I have an somewhat reproducible test case. Problem is, it only works on my Server. When I start MySQL it crashes almost exactly after one minute. This happens every single time: Oct 7 21:41:04 h1314631 mysqld_safe[18591]: started Oct 7 21:41:04 h1314631 mysqld[18594]: 071007

Re: My first trigger in MySQL

2007-10-07 Thread Baron Schwartz
Hi, Steffan A. Cline wrote: on 10/7/07 12:26 PM, Steffan A. Cline at [EMAIL PROTECTED] wrote: I am new to triggers and am trying to figure this out. The goal I have is to set it up so that after a row in the users table is updated it will check to see if the affected row has a username in the

Re: SAN and ibdata files

2007-10-07 Thread Ace
Thanks Dan! We do know the permission problem. We tried chown but got Not a owner error. That is because of root squashing in which root becomes nobody when you cd to NFS directory. To overcome this we tried adding no_root_squash to export file. but still the error. I will overcome this