LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Other *NIX Forums > *BSD
User Name
Password
*BSD This forum is for the discussion of all BSD variants.
FreeBSD, OpenBSD, NetBSD, etc.

Notices



Reply
 
Search this Thread
Old 07-06-2004, 05:47 AM   #1
apache
Member
 
Registered: Jun 2004
Posts: 37

Rep: Reputation: 15
Mysql problems keeps coming on FreeBSD server!!


Hello all,
We are having very strage problem on FreeBSD server( version 5.1 ) which uses mysql 4.0.18 on it.Since yesterday we are getting so many errors of mysql_num_rows () function which says that the argument is invaild.
The problem is more severe .We have repaired the error but it keeps coming on and on .This happens Coz anything is added or deleted from table gives rise to error.
Here is whatb my /var/lib/mysql/server.err file says:
**************************************************************************
040705 06:56:47 mysqld started
040705 6:56:48 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43952
InnoDB: Doing recovery: scanned up to log sequence number 0 43952
040705 6:56:48 InnoDB: Flushing modified pages from the buffer pool...
040705 6:56:48 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.
Version: '4.0.13' socket: '/tmp/mysql.sock' port: 3306
040706 2:55:32 Note: Found 212 of 213 rows when repairing './trafficg_trafficq/trafficg_login'
040706 4:13:41 /usr/local/libexec/mysqld: Normal shutdown

040706 4:13:42 InnoDB: Starting shutdown...
040706 4:13:43 InnoDB: Shutdown completed
040706 4:13:43 /usr/local/libexec/mysqld: Shutdown Complete

040706 04:13:43 mysqld ended
***********
And this my error_log says:
[Fri Jul 2 16:43:34 2004] [error] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/trafficq/public_html/topbar.php on line 155
[Fri Jul 2 16:43:34 2004] [error] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/autosurf/public_html/member.php on line 118
[Fri Jul 2 16:43:39 2004] [error] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/autosurf/public_html/topbar.php on line 16
AND SO ON....
there are at least 10000 lines of same type...
What is problem?
CAn anybody help!!
 
Old 07-06-2004, 08:57 PM   #2
chort
Senior Member
 
Registered: Jul 2003
Location: Silicon Valley, USA
Distribution: OpenBSD 4.6, OS X 10.6.2, CentOS 4 & 5
Posts: 3,660

Rep: Reputation: 69
It seems like the DB thinks there are actually more rows than it can find. If the automatic DB check doesn't work, you might have to do more drastic check/repair work. I believe there are some tools that ship with MySQL for this, but I do not have experience using them. Basically your DB seems to be corrupt.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Trying to start mysql on freebsd 4.8 dedicated server NoS Sr50 *BSD 1 12-08-2004 12:46 AM
MySQL server start up problems spectrumver1 Linux - Software 2 12-09-2003 08:56 PM
need help urgently!!! display not coming and error mesage coming when user is logging rddreamz Linux - Newbie 0 08-14-2003 12:11 PM
FreeBSD x server problems razod *BSD 5 07-20-2003 09:16 PM


All times are GMT -5. The time now is 06:03 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration