1. Janos SUTO Avatar Janos SUTO
  2. Piler
  3. piler
  4. Issues

Auditor Login Message Count showing Wrong

Issue #357 resolved
Venkateswarlu Dadagopu created an issue

Auditor Login Message Count showing Wrong Compare to Admin Panel.

Please find the attached screen shots.

Comments (8)

  1. Janos SUTO repo owner

    Show me the following outputs:

    $ ls -la /var/piler/sphinx
$ mysql -h 127.0.0.1 -P 9306
mysql> select * from main1,dailydelta1,delta1;
mysql> show meta;
  2. Janos SUTO repo owner

    Is is possible to edit your copy paste and put data into code sections? See the formatting options. You comment is pretty unreadable. Don't expect me to torture my eyes to find what I need...

  3. Venkateswarlu Dadagopu reporter

    [root@archive ~]# ls -la /var/piler/sphinx total 6956 drwxr-xr-x 2 piler piler 4096 Jul 30 14:15 . drwxr-xr-x 9 piler piler 4096 May 24 10:36 .. -rw-r--r-- 1 piler piler 0 Jul 30 14:05 dailydelta1.spa -rw-r--r-- 1 piler piler 1 Jul 30 14:05 dailydelta1.spd -rw-r--r-- 1 piler piler 582 Jul 30 14:05 dailydelta1.sph -rw-r--r-- 1 piler piler 1 Jul 30 14:05 dailydelta1.spi -rw-r--r-- 1 piler piler 0 Jul 30 14:05 dailydelta1.spk -rw------- 1 piler piler 0 Jul 30 14:05 dailydelta1.spl -rw-r--r-- 1 piler piler 0 Jul 30 14:05 dailydelta1.spm -rw-r--r-- 1 piler piler 1 Jul 30 14:05 dailydelta1.spp -rw-r--r-- 1 piler piler 1 Jul 30 14:05 dailydelta1.sps -rw-r--r-- 1 piler piler 0 Jul 30 14:05 delta1.spa -rw-r--r-- 1 piler piler 1 Jul 30 14:05 delta1.spd -rw-r--r-- 1 piler piler 582 Jul 30 14:05 delta1.sph -rw-r--r-- 1 piler piler 1 Jul 30 14:05 delta1.spi -rw-r--r-- 1 piler piler 0 Jul 30 14:05 delta1.spk -rw------- 1 piler piler 0 Jul 30 14:05 delta1.spl -rw-r--r-- 1 piler piler 0 Jul 30 14:05 delta1.spm -rw-r--r-- 1 piler piler 1 Jul 30 14:05 delta1.spp -rw-r--r-- 1 piler piler 1 Jul 30 14:05 delta1.sps -rw-r--r-- 1 piler piler 14060 Jul 30 02:30 main1.spa -rw-r--r-- 1 piler piler 2816174 Jul 30 02:30 main1.spd -rw-r--r-- 1 piler piler 582 Jul 30 02:30 main1.sph -rw-r--r-- 1 piler piler 1709923 Jul 30 02:30 main1.spi -rw-r--r-- 1 piler piler 0 Jul 30 02:30 main1.spk -rw------- 1 piler piler 0 Jul 30 12:54 main1.spl -rw-r--r-- 1 piler piler 0 Jul 30 02:30 main1.spm -rw-r--r-- 1 piler piler 2412657 Jul 30 02:30 main1.spp -rw-r--r-- 1 piler piler 1 Jul 30 02:30 main1.sps -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main2.spa -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main2.spd -rw-r--r-- 1 piler piler 582 Jul 26 14:00 main2.sph -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main2.spi -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main2.spk -rw------- 1 piler piler 0 Jul 30 12:54 main2.spl -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main2.spm -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main2.spp -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main2.sps -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main3.spa -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main3.spd -rw-r--r-- 1 piler piler 582 Jul 26 14:00 main3.sph -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main3.spi -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main3.spk -rw------- 1 piler piler 0 Jul 30 12:54 main3.spl -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main3.spm -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main3.spp -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main3.sps -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main4.spa -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main4.spd -rw-r--r-- 1 piler piler 582 Jul 26 14:00 main4.sph -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main4.spi -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main4.spk -rw------- 1 piler piler 0 Jul 30 12:54 main4.spl -rw-r--r-- 1 piler piler 0 Jul 26 14:00 main4.spm -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main4.spp -rw-r--r-- 1 piler piler 1 Jul 26 14:00 main4.sps -rw-r--r-- 1 piler piler 0 Jul 30 14:15 note1.spa -rw-r--r-- 1 piler piler 1 Jul 30 14:15 note1.spd -rw-r--r-- 1 piler piler 289 Jul 30 14:15 note1.sph -rw-r--r-- 1 piler piler 1 Jul 30 14:15 note1.spi -rw-r--r-- 1 piler piler 0 Jul 30 14:15 note1.spk -rw------- 1 piler piler 0 Jul 30 14:15 note1.spl -rw-r--r-- 1 piler piler 0 Jul 30 14:15 note1.spm -rw-r--r-- 1 piler piler 1 Jul 30 14:15 note1.spp -rw-r--r-- 1 piler piler 1 Jul 30 14:15 note1.sps -rw-r--r-- 1 piler piler 0 Jul 30 14:15 tag1.spa -rw-r--r-- 1 piler piler 1 Jul 30 14:15 tag1.spd -rw-r--r-- 1 piler piler 288 Jul 30 14:15 tag1.sph -rw-r--r-- 1 piler piler 1 Jul 30 14:15 tag1.spi -rw-r--r-- 1 piler piler 0 Jul 30 14:15 tag1.spk -rw------- 1 piler piler 0 Jul 30 14:15 tag1.spl -rw-r--r-- 1 piler piler 0 Jul 30 14:15 tag1.spm -rw-r--r-- 1 piler piler 1 Jul 30 14:15 tag1.spp -rw-r--r-- 1 piler piler 1 Jul 30 14:15 tag1.sps

    [root@archive ~]# mysql -h 127.0.0.1 -P 9306 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 2.0.8-id64-release (r3831)

    Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql> select * from main1,dailydelta1,delta1; +--------+------------+--------+-------------+ | id | sent | size | attachments | +--------+------------+--------+-------------+ | 469043 | 1406361896 | 7212 | 0 | | 469044 | 1406361989 | 13202 | 0 | | 469045 | 1406361898 | 15439 | 0 | | 469046 | 1406361909 | 7286 | 0 | | 469047 | 1406310971 | 6691 | 0 | | 469048 | 1406340901 | 20984 | 1 | | 469049 | 1406299572 | 6515 | 0 | | 469050 | 1406361930 | 168407 | 1 | | 469051 | 1406361931 | 11605 | 0 | | 469052 | 1406361937 | 12404 | 0 | | 469053 | 1406361939 | 7287 | 0 | | 469054 | 1406362506 | 6554 | 0 | | 469055 | 1406358141 | 5836 | 0 | | 469056 | 1406285537 | 8995 | 0 | | 469057 | 1406282475 | 6900 | 0 | | 469058 | 1406361956 | 58199 | 0 | | 469059 | 1406361454 | 6089 | 0 | | 469060 | 1406361966 | 2366 | 0 | | 469061 | 1406361622 | 190463 | 2 | | 469062 | 1406288176 | 6548 | 0 | +--------+------------+--------+-------------+ 20 rows in set (0.05 sec)

    mysql> show meta; +---------------+--------------------------------------------------------------------------------+ | Variable_name | Value | +---------------+--------------------------------------------------------------------------------+ | error | sphinxql: syntax error, unexpected IDENT, expecting VARIABLES near 'databases' | | total | 0 | | total_found | 0 | | time | 0.000 | +---------------+--------------------------------------------------------------------------------+ 4 rows in set (0.00 sec)

  6. Venkateswarlu Dadagopu reporter 
    [root@archive ~]# ls -la /var/piler/sphinx
total 6956
drwxr-xr-x 2 piler piler    4096 Jul 30 14:15 .
drwxr-xr-x 9 piler piler    4096 May 24 10:36 ..
-rw-r--r-- 1 piler piler       0 Jul 30 14:05 dailydelta1.spa
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 dailydelta1.spd
-rw-r--r-- 1 piler piler     582 Jul 30 14:05 dailydelta1.sph
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 dailydelta1.spi
-rw-r--r-- 1 piler piler       0 Jul 30 14:05 dailydelta1.spk
-rw------- 1 piler piler       0 Jul 30 14:05 dailydelta1.spl
-rw-r--r-- 1 piler piler       0 Jul 30 14:05 dailydelta1.spm
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 dailydelta1.spp
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 dailydelta1.sps
-rw-r--r-- 1 piler piler       0 Jul 30 14:05 delta1.spa
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 delta1.spd
-rw-r--r-- 1 piler piler     582 Jul 30 14:05 delta1.sph
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 delta1.spi
-rw-r--r-- 1 piler piler       0 Jul 30 14:05 delta1.spk
-rw------- 1 piler piler       0 Jul 30 14:05 delta1.spl
-rw-r--r-- 1 piler piler       0 Jul 30 14:05 delta1.spm
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 delta1.spp
-rw-r--r-- 1 piler piler       1 Jul 30 14:05 delta1.sps
-rw-r--r-- 1 piler piler   14060 Jul 30 02:30 main1.spa
-rw-r--r-- 1 piler piler 2816174 Jul 30 02:30 main1.spd
-rw-r--r-- 1 piler piler     582 Jul 30 02:30 main1.sph
-rw-r--r-- 1 piler piler 1709923 Jul 30 02:30 main1.spi
-rw-r--r-- 1 piler piler       0 Jul 30 02:30 main1.spk
-rw------- 1 piler piler       0 Jul 30 12:54 main1.spl
-rw-r--r-- 1 piler piler       0 Jul 30 02:30 main1.spm
-rw-r--r-- 1 piler piler 2412657 Jul 30 02:30 main1.spp
-rw-r--r-- 1 piler piler       1 Jul 30 02:30 main1.sps
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main2.spa
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main2.spd
-rw-r--r-- 1 piler piler     582 Jul 26 14:00 main2.sph
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main2.spi
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main2.spk
-rw------- 1 piler piler       0 Jul 30 12:54 main2.spl
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main2.spm
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main2.spp
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main2.sps
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main3.spa
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main3.spd
-rw-r--r-- 1 piler piler     582 Jul 26 14:00 main3.sph
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main3.spi
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main3.spk
-rw------- 1 piler piler       0 Jul 30 12:54 main3.spl
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main3.spm
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main3.spp
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main3.sps
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main4.spa
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main4.spd
-rw-r--r-- 1 piler piler     582 Jul 26 14:00 main4.sph
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main4.spi
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main4.spk
-rw------- 1 piler piler       0 Jul 30 12:54 main4.spl
-rw-r--r-- 1 piler piler       0 Jul 26 14:00 main4.spm
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main4.spp
-rw-r--r-- 1 piler piler       1 Jul 26 14:00 main4.sps
-rw-r--r-- 1 piler piler       0 Jul 30 14:15 note1.spa
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 note1.spd
-rw-r--r-- 1 piler piler     289 Jul 30 14:15 note1.sph
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 note1.spi
-rw-r--r-- 1 piler piler       0 Jul 30 14:15 note1.spk
-rw------- 1 piler piler       0 Jul 30 14:15 note1.spl
-rw-r--r-- 1 piler piler       0 Jul 30 14:15 note1.spm
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 note1.spp
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 note1.sps
-rw-r--r-- 1 piler piler       0 Jul 30 14:15 tag1.spa
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 tag1.spd
-rw-r--r-- 1 piler piler     288 Jul 30 14:15 tag1.sph
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 tag1.spi
-rw-r--r-- 1 piler piler       0 Jul 30 14:15 tag1.spk
-rw------- 1 piler piler       0 Jul 30 14:15 tag1.spl
-rw-r--r-- 1 piler piler       0 Jul 30 14:15 tag1.spm
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 tag1.spp
-rw-r--r-- 1 piler piler       1 Jul 30 14:15 tag1.sps



[root@archive ~]# mysql -h 127.0.0.1 -P 9306
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 2.0.8-id64-release (r3831)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.



mysql> select * from main1,dailydelta1,delta1;
+--------+------------+--------+-------------+
| id     | sent       | size   | attachments |
+--------+------------+--------+-------------+
| 469043 | 1406361896 |   7212 |           0 |
| 469044 | 1406361989 |  13202 |           0 |
| 469045 | 1406361898 |  15439 |           0 |
| 469046 | 1406361909 |   7286 |           0 |
| 469047 | 1406310971 |   6691 |           0 |
| 469048 | 1406340901 |  20984 |           1 |
| 469049 | 1406299572 |   6515 |           0 |
| 469050 | 1406361930 | 168407 |           1 |
| 469051 | 1406361931 |  11605 |           0 |
| 469052 | 1406361937 |  12404 |           0 |
| 469053 | 1406361939 |   7287 |           0 |
| 469054 | 1406362506 |   6554 |           0 |
| 469055 | 1406358141 |   5836 |           0 |
| 469056 | 1406285537 |   8995 |           0 |
| 469057 | 1406282475 |   6900 |           0 |
| 469058 | 1406361956 |  58199 |           0 |
| 469059 | 1406361454 |   6089 |           0 |
| 469060 | 1406361966 |   2366 |           0 |
| 469061 | 1406361622 | 190463 |           2 |
| 469062 | 1406288176 |   6548 |           0 |
+--------+------------+--------+-------------+
20 rows in set (0.05 sec)

mysql> show meta;
+---------------+--------------------------------------------------------------------------------+
| Variable_name | Value                                                                          |
+---------------+--------------------------------------------------------------------------------+
| error         | sphinxql: syntax error, unexpected IDENT, expecting VARIABLES near 'databases' |
| total         | 0                                                                              |
| total_found   | 0                                                                              |
| time          | 0.000                                                                          |
+---------------+--------------------------------------------------------------------------------+
4 rows in set (0.00 sec)
  7. Janos SUTO repo owner

    It seems that sphinx contains only the last few hundreds of emails indexed. Notice that the sphinx files are too small to have data from ~half million emails.

    The solution is to run (from /tmp directory) reindex -f 1 -t 100000, and check if the sphinx files (main1., dailydelta1. and delta1.*) are significantly larger. If it helps, then run reindex -f 100001 -t 469000

  9. Log in to comment
Assignee
Type
bug
Priority
major
Status
resolved
Votes
0
Watchers
2
Jira: the preferred issue tracker for Bitbucket. Join the team!