Problems with some time formats

What steps will reproduce the problem?
1. Doing some queries including this date format "2012-09-12" fails.
2.
3.

What is the expected output? What do you see instead?

What version of the product are you using? On what operating system?
CentOS 6.3 x86_64

Please provide any additional information below.

* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (448)
Query::_parse_query_string 17423 [undef]
Permissions grant access to any host_id
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (448)
Query::_parse_query_string 17423 [undef]
Permissions grant access to any program_id
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (448)
Query::_parse_query_string 17423 [undef]
Permissions grant access to any node_id
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (552)
Query::_parse_query_string 17423 [undef]
field_terms: $VAR1 = {
          'or' => {},
          'not' => {},
          'and' => {
                     '1002' => {
                                 's2' => [
                                           '"2012-09-18"'
                                         ]
                               }
                   }
        };
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (553)
Query::_parse_query_string 17423 [undef]
any_field_terms: $VAR1 = {
          'or' => {
                    '(@host 180618242)' => 1
                  },
          'not' => {},
          'and' => {}
        };
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (566)
Query::_parse_query_string 17423 [undef]
Using host as a filter because there were 1 query terms.
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (570)
Query::_parse_query_string 17423 [undef]
Deleted term (@host 180618242)
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (601)
Query::_parse_query_string 17423 [undef]
terms: $VAR1 = {
          'field_terms' => {
                             'or' => {},
                             'not' => {},
                             'and' => {
                                        '1002' => {
                                                    's2' => [
                                                              '"2012-09-18"'
                                                            ]
                                                  }
                                      }
                           },
          'any_field_terms' => {
                                 'or' => {},
                                 'not' => {},
                                 'and' => {}
                               },
          'attr_terms' => {
                            'or' => {
                                      '=' => {
                                               'host' => {
                                                           '0' => {

'host_id' => [

            180618242

          ]
                                                                  }
                                                         }
                                             }
                                    },
                            'not' => {},
                            'and' => {}
                          }
        };
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (602)
Query::_parse_query_string 17423 [undef]
classes: $VAR1 = {
          'partially_permitted' => {},
          'given' => {},
          'excluded' => {},
          'distinct' => {
                          '1002' => 1
                        },
          'groupby' => {},
          'permitted' => {
                           '1001' => 'JUNOS',
                           '1002' => 'JUNSA',
                           '1' => 'NONE',
                           '0' => 'ANY',
                           '1000' => 'CHKP',
                           '1006' => 'IRONPORT'
                         }
        };
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (618)
Query::_parse_query_string 17423 [undef]
query_term_count: 1, num_added_terms: 0
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (630)
Query::_parse_query_string 17423 [undef]
META_PARAMS: $VAR1 = {};
* WARN [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (674)
Query::_parse_query_string 17423 [undef]
Adjusted end_int 1347966935 to 1347966861
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (683)
Query::_parse_query_string 17423 [undef]
going with times start: Thu Jan  1 00:00:00 1970 (0) and end: Tue Sep
18 11:14:21 2012 (1347966861)
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/Query.pm (143)
Query::BUILD 17423 [undef]
Received query with qid 244 at 1347966935
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (2478)
API::_build_sphinx_match_str 17423 [undef]
match str:  ( ((@s2 "2012-09-18")))
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (768)
API::_get_sphinx_nodes 17423 [undef]
connecting to sphinx on node 10.196.129.26
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (1982)
API::_sphinx_query 17423 [undef]
sphinx_query: SELECT *, ((class_id=?))  AND ((host_id=?)) AS
positive_qualifier, 0 AS negative_qualifier, 1 AS
permissions_qualifier FROM distributed_local WHERE MATCH(' ( ((@s2
"2012-09-18")))') AND po
sitive_qualifier=1 AND negative_qualifier=0 AND
permissions_qualifier=1 LIMIT ?,? OPTION ranker=none, values: $VAR1 =
[
          '1002',
          180618242
        ];
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (1987)
API::_sphinx_query 17423 [undef]
multiquery: SELECT *, ((class_id=?))  AND ((host_id=?)) AS
positive_qualifier, 0 AS negative_qualifier, 1 AS
permissions_qualifier FROM distributed_local WHERE MATCH(' ( ((@s2
"2012-09-18")))') AND posi
tive_qualifier=1 AND negative_qualifier=0 AND permissions_qualifier=1
LIMIT ?,? OPTION ranker=none
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (1988)
API::_sphinx_query 17423 [undef]
values: 1002,180618242,0,100
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/AsyncMysql.pm (166)
AsyncMysql::sphinx 17423 [undef]
Executing query SELECT *, ((class_id=?))  AND ((host_id=?)) AS
positive_qualifier, 0 AS negative_qualifier, 1 AS
permissions_qualifier FROM distributed_local WHERE MATCH(' ( ((@s2
"2012-09-18")))') AND
positive_qualifier=1 AND negative_qualifier=0 AND
permissions_qualifier=1 LIMIT ?,? OPTION ranker=none;SHOW META with id
2
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (1991)
API::__ANON__ 17423 [undef]
Sphinx query for node 10.196.129.26 finished in 0.404855966567993
* TRACE [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (2001)
API::__ANON__ 17423 [undef]
node 10.196.129.26 got sphinx result: $VAR1 = {
          'rows' => [],
          'meta' => {
                      'keyword[1]' => '-09-18',
                      'time' => '0.401',
                      'hits[1]' => 0,
                      'total' => 0,
                      'total_found' => 0,
                      'hits[0]' => 1309,
                      'keyword[0]' => 2012,
                      'docs[0]' => 756,
                      'docs[1]' => 0
                    }
        };
* DEBUG [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (2235)
API::_sphinx_query 17423 [undef]
completed query in 0.405636072158813 with 0 rows
* INFO [2012/09/18 11:15:35] /data/elsa/www/lib/API.pm (1751)
API::query 17423 [undef]
Query 244 returned 0 rows
Original issue reported on code.google.com by carlopm...@gmail.com on 18 Sep 2012 at 1:11
MHMDhub / enterprise-log-search-and-archive

Problems with some time formats #75
