Came in tonight, and some people started getting this error message
Quote:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "MediaWikiBagOStuff::_doquery". MySQL returned error "1205: Lock wait timeout exceeded; try restarting transaction (localhost)".
Retrieved from "http://bender/wiki/index.php/Main_Page"
note: users were getting this error in IE6 and in firefox, pages seemed to process fine in Chrome.
anyway...
So I decided to restart the MySQL service, now it will not restart. First tried:
Code:
root@bender:/> /etc/init.d/mysqld start
Starting MySQL
... ERROR! Manager of pid-file quit without updating file.
Then I tried to start it without the script:
Code:
mysql@bender:/> 100110 0:42:47 [Warning] Can't create test file /usr/local/mysql/data/bender.lower-test
100110 0:42:47 [Warning] Can't create test file /usr/local/mysql/data/bender.lower-test
100110 0:42:48 InnoDB: Started; log sequence number 0 3748305
/usr/local/mysql/bin/mysqld: File './mysql-bin.000026' not found (Errcode: 28)
100110 0:42:48 [ERROR] Could not use mysql-bin for logging (error 28). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
100110 0:42:48 [ERROR] Aborting
100110 0:42:48 InnoDB: Starting shutdown...
100110 0:42:50 InnoDB: Shutdown completed; log sequence number 0 3748305
100110 0:42:50 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
hello:
I am a somewhat experienced unix user, but brand new to this forum. I am encountering a strange new problem.
I have a shell script called foo.ksh it has been running for years (literally) on my Sun (Solaris 8) machine.
Recently we put a version of samba on this machine to... (3 Replies)
Hi Experts,
I am running solris 9. Sun-Fire 880.
How do i shutdowon the whole server using ALOM i.e sc> console.
If the server is down or somehow hang How do i Restart from sc>
//purple (6 Replies)
Could not find a good explanation that was Solaris specified. Need to add MySQL to start up on system startup or restart. I was gone for a few days from work and someone decided to relocate the server. When it came back up, of course mysql was down.
On my previous linux systems I always just had... (2 Replies)
This is a fairly complex issue. I do not have a lot of knowledge on X11. But here are the things.
I am running a program called Synergy off a Solaris server. The server sits in a remote network and can be accessed via NAT. Using Putty, I will enable X11 forwarding and launch Synergy via Putty.... (0 Replies)
Hi Everyone,
I am just curious, if sshd service is restarted on these OS Solaris 8,9,10 remotely will the session expires?? . I knew we can restart sshd in solaris 10 that will no effect any current session please suggest for 8,9
Thanks, (2 Replies)
i have a vmware workstation with solaris 10 installed on this.
i copying 2 gb data via samba from windows to this vmware workstation.
copy speed is 24 kb/sec.
how i can speed up this copy process ? (7 Replies)
Hi guys,
I have an interesting problem. I have looked on the forums for simular solutions but i need a differnt approach.
On an evening i have files that are created and sit in a directory, then someone will send these files on. Sometimes they forget.....
I am trying to create something... (7 Replies)
Hello,
After a restart, solaris 10 can not boot. The attachment picture will show and after 15sec (approximatly) the system restart automatically.
If in GRUB i choose failsafe, the system only wants me update to boot, i press y and it shows:
updating /dev/dsk/c1d0s0...
#
after restarting... (8 Replies)
Discussion started by: mammut3d
8 Replies
LEARN ABOUT DEBIAN
cvm-mysql
cvm-mysql(8) System Manager's Manual cvm-mysql(8)NAME
cvm-mysql - MySQL module
SYNOPSIS
cvm-mysql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE
The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the
MySQL default).
CVM_MYSQL_DEFAULT_GROUP
If set, the module will read connection default options from the named group in the defaults file as above
CVM_MYSQL_HOST
The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed.
CVM_MYSQL_USER
The MySQL login ID to connect as. If not set, the invoking user is assumed.
CVM_MYSQL_PASS
The password for the above user.
CVM_MYSQL_DB
The database name, must be set.
CVM_MYSQL_PORT
The port number for the TCP/IP connection (only used if the server is not local).
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_MYSQL_PWCMP (optional)
The password comparison module to use.
CVM_MYSQL_SOCKET
The path to the socket that should be used for connections to a local server.
CVM_MYSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).
SEE ALSO cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-mysql(8)
01-10-2010
