Did you know LQ has a Linux Hardware Compatibility List?
Go Back > Forums > Other *NIX Forums > *BSD
User Name
*BSD This forum is for the discussion of all BSD variants.
FreeBSD, OpenBSD, NetBSD, etc.


  Search this Thread
Old 07-06-2004, 05:47 AM   #1
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
there are at least 10000 lines of same type...
What is problem?
CAn anybody help!!
Old 07-06-2004, 08:57 PM   #2
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.


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 05:00 AM.

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