291931 - Number of bugs is not match with the bugs which are stored in MySQL database

Status: RESOLVED WORKSFORME

(Bugzilla :: Bugzilla-General, defect)

Description

[Ramu]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; rv:1.7.3) Gecko/20041020 Firefox/0.10.1
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; rv:1.7.3) Gecko/20041020 Firefox/0.10.1

When i list all the bug it gives 1020 bugs,but in database if i use sql
statement "select * from bugs" it select only 1000 bugs.So missmatch exist
between database and bugzilla.

Reproducible: Always

Steps to Reproduce:
1.Click search hyperlink
2.List all bugs using option product="all" and status="all"
3.Count the total number of bugs from list
4.To use MySQL data base follow these statements:
a.mysql -u root -p(enter password)
b.use <database name>
c.type SQL query"Select * from bugs"
d.count the number of bugs from the result.
Actual Results:  
Number of bugs from MySQL database is not equal to the number bugs from the list.

Expected Results:  
Number of bugs from MySQL database is  equal to the number bugs from the list.

Comment 1

[Joel Peshkin]

Removing security group -- no security problem here.

You need to be more specific.  First, what version are you using?
Next, are some bugs listed twice or are there bug numbers on the buglist that do
not appear in the DB?

Comment 2

[Frédéric Buclin]

> d.count the number of bugs from the result.

What does "count the number of bugs" mean? Could you please try this SQL request:
SELECT COUNT(*) FROM bugs;

Comment 3

[Ramu]

Bugzilla version :2.18rc2
when i use select count(*) from bugs;
it gives 1045.But when i list through bugzilla it gives 1035 number of bugs.Here
difference exist between Front end and the backend.

One more required additional comment is iam using MySQLCC to check database and
modifie MySQL data base when ever it requires.It might be the one reason is that
MySQLCC can only list first 1000 bugs.Please make it clear for me .

Comment 4

[Dave Miller [:justdave]]

Here's a good place to start:

http://dev.mysql.com/doc/mysql/

or specifically:
http://dev.mysql.com/doc/mysql/en/mysqlcc.html

"mysqlcc is deprecated and it is recommended that users choose the new MySQL
Administrator and MySQL Query Browser, found at http://dev.mysql.com/downloads/."

Comment 5

[Frédéric Buclin]

Ramu, what does sanitycheck.cgi say? A corrupted DB could explain why you don't
see some bugs.