Login or Register to Ask a Question and Join Our Community


Solaris

solaris 10 mysql no longer able to restart

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris solaris 10 mysql no longer able to restart
# 1  
Old 01-10-2010
solaris 10 mysql no longer able to restart
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. Smilie

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


SmilieSmilieSmilie
# 2  
Old 01-10-2010
a) Stop mysql server

# /etc/init.d/mysql stop
OR

# /etc/init.d/mysqld stop
b) Check filesystem and /tmp directories:

$ df -h
$ cd /tmp
$ df -h /tmp
c) Remove files from /tmp to free up space:

# cd /tmp
# rm -rf *
d) Look into /var/log directory and remove or compress logs file.

e) Use myisamchk command to check and repair of ISAM table:

# cd /var/lib/mysql
# myisamchk
f) Increase disk space (add new hard disk or remove unwanted software(s) )

g) Start the mysql server:

# /etc/init.d/mysql start
OR

# /etc/init.d/mysqld start
# 3  
Old 01-20-2010
incredible is right here....

but please dont do this 'rm -rf *' under /tmp...this may again cause some other unforeseen issues...

/tmp is critically used by processes and removing files may cause them to abort or non-responding.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

Solaris can not boot and restart

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

2. Shell Programming and Scripting

Solaris: New files in a directory for longer than 1h

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)
Discussion started by: twinion
7 Replies

3. Solaris

Copy via samba on vmware workstation with Solaris taking much longer than usual

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)
Discussion started by: rehantayyab82
7 Replies

4. Solaris

Doubt, sshd restart kills the session on Solaris 8,9,10

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)
Discussion started by: bobby320
2 Replies

5. Solaris

Graphical program no longer works after Solaris 10 upgrade

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)
Discussion started by: Leion
0 Replies

6. Solaris

Autostart MySQL db on restart or startup

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)
Discussion started by: ippy98
2 Replies

7. Solaris

Restart/Shutdown the Solaris from SC>

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)
Discussion started by: thepurple
6 Replies

8. UNIX for Advanced & Expert Users

scripts no longer running (solaris 8)

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)
Discussion started by: smcadoo
3 Replies

9. Solaris

shutting down/restarting oracle with the solaris server restart

How can I make sure that all the database instances are shut down and brought up when the server is restarted. Krishan (3 Replies)
Discussion started by: krishan
3 Replies
Login or Register to Ask a Question