6.0.0-beta1
7/18/25

[#12353] NoSQL creates indexes for collections not used
Summary NoSQL creates indexes for collections not used
Queue Horde Framework Packages
Queue Version Git master
Type Bug
State Resolved
Priority 2. Medium
Owners slusarz (at) horde (dot) org
Requester michael (at) bigmichi1 (dot) de
Created 06/13/2013 (4418 days ago)
Due
Updated 06/13/2013 (4418 days ago)
Assigned 06/13/2013 (4418 days ago)
Resolved 06/13/2013 (4418 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
06/13/2013 11:55:16 PM Michael Slusarz Comment #4
State ⇒ Resolved
Reply to this comment
Horde_Mongo 1.0.1.
06/13/2013 11:55:04 PM Git Commit Comment #3 Reply to this comment
Changes have been made in Git (master):

commit ac622ac94118d6d12ee9c8afea756030191b8535
Author: Michael M Slusarz <slusarz@horde.org>
Date:   Thu Jun 13 17:43:06 2013 -0600

     [mms] Fix checking/creating indices when a MongoCollection object 
is passed to checkIndices()/createIndices() (Bug #12353).

  framework/Mongo/lib/Horde/Mongo/Client.php |   25 ++++++++++++++++---------
  framework/Mongo/package.xml                |    4 ++--
  2 files changed, 18 insertions(+), 11 deletions(-)

http://git.horde.org/horde-git/-/commit/ac622ac94118d6d12ee9c8afea756030191b8535
06/13/2013 01:13:36 PM Jan Schneider Assigned to Michael Slusarz
State ⇒ Assigned
 
06/13/2013 12:28:57 PM michael (at) bigmichi1 (dot) de Comment #2 Reply to this comment
configuration is:

Web Server
Web server        nginx/1.4.1
PHP version        PHP 5.4.15-1~raring+1
PHP extension        mongo/1.3.4

Directives
Directive        Global Value        Local Value
mongo.allow_empty_keys        0        0
mongo.chunk_size        262144        262144
mongo.cmd        $        $
mongo.default_host        localhost        localhost
mongo.default_port        27017        27017
mongo.is_master_interval        15        15
mongo.long_as_object        0        1
mongo.native_long        0        1
mongo.ping_interval        5        5
mongo.utf8        1        1

Build Information ({buildinfo:1})
version        2.2.4
gitVersion        nogitversion
sysInfo        Linux batsu 3.2.0-37-generic #58-Ubuntu SMP Thu Jan 24 
15:28:10 UTC 2013 x86_64 BOOST_LIB_VERSION=1_49
versionArray        [2,2,4,0]
bits        64
debug        FALSE
maxBsonObjectSize        16777216


$conf['nosql']['hostspec'] = 
'mongodb://horde:xxx@/tmp/mongodb-27017.sock/horde';
$conf['nosql']['phptype'] = 'mongo';

06/13/2013 12:27:10 PM michael (at) bigmichi1 (dot) de Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ NoSQL creates indexes for collections not used
Queue ⇒ Horde Framework Packages
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
i configures horde to use mongodb as storage for cache, prefs and 
sessions. the configurationpage shows me that i need to create indices 
so i have done it. after a while i looked in the db and i saw that now 
  i have this:

  horde (7)
  - horde.horde_prefs (0)
  - horde.horde_sessionhandler (0)
  - horde_cache (5)
  - horde_prefs (3)
  - horde_sessionhandler (1)
  - system.indexes (9)
  - system.users (1)

the first two entries are created while creating the indices through 
the configuration screen and the others are created automatically by 
using horde. so the collections with indices are not filled or the 
other way around the collections that are used by horde didn't have 
the indices.

i also notices that if i set a dbname in the nosql configuration this 
value isn't shown after a saving the settings

Saved Queries