Good to hear - so everything's working smoothly? -- Pat
On 17/08/2011, at 10:33 PM, surbhi gupta wrote: > Hi, > > I got the answer in the thread > http://groups.google.com/group/thinking-sphinx/browse_thread/thread/1f83c5e62d7445c7/0e0fc174be5f2928?lnk=gst&q=nobody#0e0fc174be5f2928 > > The issue I had was > that passenger was spawning processes as "nobody" and "nobody" did not > have access to the sphinx commands, which is a different user. The way > to fix that is set nginx.conf passenger config as following, under the > passenger_root and passenger_ruby settings: > passenger_root /usr/local/ruby-enterprise-1.8.6-20090610/lib/ruby/ > gems/1.8/gems/passenger-2.2.4; > passenger_ruby /usr/local/ruby-enterprise-1.8.6-20090610/bin/ruby; > passenger_user_switching off; > passenger_default_user <your default user to spawn off rails > processes>; > > The permission error is not there now.. > > Thank you, > Surbhi > > On Wed, Aug 17, 2011 at 4:46 PM, surbhi gupta <[email protected]> wrote: > Hi Pat, > > The rails application has been executed as user "root" only > > root 10551 0.0 0.0 7288 808 ? Ss 16:39 0:00 nginx: > master process /opt/nginx/sbin/nginx > root 10641 0.0 0.2 8180 2444 ? S 16:39 0:00 nginx: > worker process > root 10642 0.0 0.1 8084 1900 ? S 16:39 0:00 nginx: > worker process > root 10643 0.0 0.1 8084 1900 ? S 16:39 0:00 nginx: > worker process > root 10644 0.0 0.1 8084 1900 ? S 16:39 0:00 nginx: > worker process > > -Surbhi > > > On Wed, Aug 17, 2011 at 4:32 PM, Pat Allan <[email protected]> wrote: > Hi Surbhi > > This is happening because you're running searchd as root, but your Rails app > files seem to be owned as nobody/nogroup - hence why the delta indexing is > happening as that user. You'll want to make sure everything is the same user, > and then it should work (and ideally it shouldn't be the root user, but > that's up to you). > > -- > Pat > > On 17/08/2011, at 8:37 PM, Surbhi wrote: > > > Hi, > > > > I am facing an issue with delta indexing. When ever I add a new > > object, the newly created record is not getting searched. The error > > which I can see in nginx log files is as follows: > > > > using config file '/var/www/TestMate-Training/releases/20110817095300/ > > config/staging.sphinx.conf'... > > indexing index 'question_delta'... > > FATAL: failed to open sphinx/question_delta.tmp.spl: Permission > > denied, will not index. Try --rotate option > > > > I have started nginx, searchd and rails as user "root" > > > > The files in db/sphinx/staging are as follows: > > ... > > ... > > -rwxrwxrwx 1 root root 0 2011-08-17 15:09 question_core.spk > > -rwxrwxrwx 1 root root 0 2011-08-17 15:09 question_core.spm > > -rwxrwxrwx 1 root root 322 2011-08-17 15:09 question_core.spp > > -rw-r--r-- 1 nobody nogroup 120 2011-08-17 15:16 > > question_delta.new.spa > > -rw-r--r-- 1 nobody nogroup 49 2011-08-17 15:16 > > question_delta.new.spd > > -rw-r--r-- 1 nobody nogroup 530 2011-08-17 15:16 > > question_delta.new.sph > > -rw-r--r-- 1 nobody nogroup 80 2011-08-17 15:16 > > question_delta.new.spi > > -rw-r--r-- 1 nobody nogroup 0 2011-08-17 15:16 > > question_delta.new.spk > > -rw-r--r-- 1 nobody nogroup 0 2011-08-17 15:16 > > question_delta.new.spm > > -rw-r--r-- 1 nobody nogroup 51 2011-08-17 15:16 > > question_delta.new.spp > > -rwxrwxrwx 1 root root 0 2011-08-17 15:09 question_delta.spa > > -rwxrwxrwx 1 root root 1 2011-08-17 15:09 question_delta.spd > > ... > > ... > > > > Searchd: > > root 25290 0.0 0.0 8620 672 pts/3 S 15:58 0:00 /usr/ > > local/bin/searchd --pidfile --config /var/www/TestMate-Training/ > > releases/20110817095300/config/staging.sphinx.conf > > > > > > Configuration: > > config/sphinx.yml file > > staging: > > port: 3313 > > address: localhost > > searchd_file_path: "sphinx" > > bin_path: '/usr/local/bin/' > > enable_star: 1 > > min_infix_len: 1 > > > > Thinking sphinx version: 2.0.3 > > Sphinx server: Sphinx 0.9.9-release (r2117) > > Rails version: 3.0.3 > > OS: Ubuntu 10.10 > > > > Could you please let me know where I am going wrong? > > > > > > Reference: > > The conf file being generated > > > > indexer > > { > > } > > > > searchd > > { > > listen = localhost:3313 > > log = /var/www/TestMate-Training/releases/20110817095300/log/ > > searchd.log > > query_log = /var/www/TestMate-Training/releases/20110817095300/log/ > > searchd.query.log > > pid_file = /var/www/TestMate-Training/releases/20110817095300/log/ > > searchd.staging.pid > > } > > > > source event_core_0 > > { > > type = mysql > > sql_host = localhost > > sql_user = root > > sql_pass = > > sql_db = testmate > > sql_port = 3306 > > sql_query_pre = UPDATE `events` SET `delta` = 0 WHERE `delta` = 1 > > sql_query_pre = SET NAMES utf8 > > sql_query_pre = SET TIME_ZONE = '+0:00' > > sql_query = SELECT SQL_NO_CACHE `events`.`id` * 2 + 0 AS `id` , > > `events`.`name` AS `name`, `events`.`city` AS `city`, > > `events`.`status` AS `status`, `event_types`.`name` AS > > `event_type_name`, `events`.`id` AS `sphinx_internal_id`, 4201588131 > > AS `class_crc`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`events`.`date`) > > AS `event`, UNIX_TIMESTAMP(`events`.`created_at`) AS `created_at` FROM > > `events` LEFT OUTER JOIN `event_types` ON `event_types`.`id` = > > `events`.`event_type_id` WHERE (`events`.`id` >= $start AND > > `events`.`id` <= $end AND `events`.`delta` = 0) GROUP BY > > `events`.`id`, `events`.`name`, `events`.`city`, `events`.`status`, > > `event_types`.`name`, `events`.`id`, `events`.`date`, > > `events`.`created_at` ORDER BY NULL > > sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) > > FROM `events` WHERE `events`.`delta` = 0 > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_timestamp = event > > sql_attr_timestamp = created_at > > sql_query_info = SELECT * FROM `events` WHERE `id` = (($id - 0) / 2) > > } > > > > index event_core > > { > > source = event_core_0 > > path = sphinx/event_core > > charset_type = utf-8 > > charset_table = 0..9, a..z, _, A..Z->a..z, U+00C0->a, U+00C1->a, U > > +00C2->a, U+00C3->a, U+00C4->a, U+00C5->a, U+00C7->c, U+00C8->e,U+00C9- > >> e, U+00CA->e, U+00CB->e, U+00CC->i, U+00CD->i, U+00CE->i,U+00CF->i, U > > +00D1->n, U+00D2->o, U+00D3->o, U+00D4->o, U+00D5->o, U+00D6->o, U > > +00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00DD->y, U+00E0->a, U > > +00E1->a, U+00E2->a, U+00E3->a, U+00E4->a, U+00E5->a, U+00E7->c, U > > +00E8->e, U+00E9->e, U+00EA->e, U+00EB->e, U+00EC->i, U+00ED->i, U > > +00EE->i, U+00EF->i, U+00F1->n, U+00F2->o, U+00F3->o, U+00F4->o, U > > +00F5->o, U+00F6->o, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U > > +00FD->y, U+00FF->y, U+0100->a, U+0101->a, U+0102->a, U+0103->a, U > > +0104->a, U+0105->a, U+0106->c, U+0107->c, U+0108->c, U+0109->c, U > > +010A->c, U+010B->c, U+010C->c, U+010D->c, U+010E->d, U+010F->d, U > > +0112->e, U+0113->e, U+0114->e, U+0115->e, U+0116->e, U+0117->e, U > > +0118->e, U+0119->e, U+011A->e, U+011B->e, U+011C->g, U+011D->g, U > > +011E->g, U+011F->g, U+0120->g, U+0121->g, U+0122->g,U+0123->g, U+0124- > >> h, U+0125->h, U+0128->i, U+0129->i, U+012A->i,U+012B->i, U+012C->i, U > > +012D->i, U+012E->i, U+012F->i, U+0130->i,U+0134->j, U+0135->j, U+0136- > >> k, U+0137->k, U+0139->l, U+013A->l,U+013B->l, U+013C->l, U+013D->l, U > > +013E->l, U+0142->l, U+0143->n,U+0144->n, U+0145->n, U+0146->n, U+0147- > >> n, U+0148->n, U+014C->o,U+014D->o, U+014E->o, U+014F->o, U+0150->o, U > > +0151->o, U+0154->r,U+0155->r, U+0156->r, U+0157->r, U+0158->r, U+0159- > >> r, U+015A->s,U+015B->s, U+015C->s, U+015D->s, U+015E->s, U+015F->s, U > > +0160->s,U+0161->s, U+0162->t, U+0163->t, U+0164->t, U+0165->t, U+0168- > >> u,U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u,U > > +016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+0174->w,U+0175- > >> w, U+0176->y, U+0177->y, U+0178->y, U+0179->z, U+017A->z,U+017B->z, U > > +017C->z, U+017D->z, U+017E->z, U+01A0->o, U+01A1->o,U+01AF->u, U+01B0- > >> u, U+01CD->a, U+01CE->a, U+01CF->i, U+01D0->i,U+01D1->o, U+01D2->o, U > > +01D3->u, U+01D4->u, U+01D5->u, U+01D6->u,U+01D7->u, U+01D8->u, U+01D9- > >> u, U+01DA->u, U+01DB->u, U+01DC->u,U+01DE->a, U+01DF->a, U+01E0->a, U > > +01E1->a, U+01E6->g, U+01E7->g,U+01E8->k, U+01E9->k, U+01EA->o, U+01EB- > >> o, U+01EC->o, U+01ED->o,U+01F0->j, U+01F4->g, U+01F5->g, U+01F8->n, U > > +01F9->n, U+01FA->a,U+01FB->a, U+0200->a, U+0201->a, U+0202->a, U+0203- > >> a, U+0204->e,U+0205->e, U+0206->e, U+0207->e, U+0208->i, U+0209->i, U > > +020A->i,U+020B->i, U+020C->o, U+020D->o, U+020E->o, U+020F->o, U+0210- > >> r,U+0211->r, U+0212->r, U+0213->r, U+0214->u, U+0215->u, U+0216->u,U > > +0217->u, U+0218->s, U+0219->s, U+021A->t, U+021B->t, U+021E->h,U+021F- > >> h, U+0226->a, U+0227->a, U+0228->e, U+0229->e, U+022A->o,U+022B->o, U > > +022C->o, U+022D->o, U+022E->o, U+022F->o, U+0230->o,U+0231->o, U+0232- > >> y, U+0233->y, U+1E00->a, U+1E01->a, U+1E02->b,U+1E03->b, U+1E04->b, U > > +1E05->b, U+1E06->b, U+1E07->b, U+1E08->c,U+1E09->c, U+1E0A->d, U+1E0B- > >> d, U+1E0C->d, U+1E0D->d, U+1E0E->d,U+1E0F->d, U+1E10->d, U+1E11->d, U > > +1E12->d, U+1E13->d, U+1E14->e,U+1E15->e, U+1E16->e, U+1E17->e, U+1E18- > >> e, U+1E19->e, U+1E1A->e,U+1E1B->e, U+1E1C->e, U+1E1D->e, U+1E1E->f, U > > +1E1F->f, U+1E20->g,U+1E21->g, U+1E22->h, U+1E23->h, U+1E24->h, U+1E25- > >> h, U+1E26->h,U+1E27->h, U+1E28->h, U+1E29->h, U+1E2A->h, U+1E2B->h, U > > +1E2C->i,U+1E2D->i, U+1E2E->i, U+1E2F->i, U+1E30->k, U+1E31->k, U+1E32- > >> k,U+1E33->k, U+1E34->k, U+1E35->k, U+1E36->l, U+1E37->l, U+1E38->l,U > > +1E39->l, U+1E3A->l, U+1E3B->l, U+1E3C->l, U+1E3D->l, U+1E3E->m,U+1E3F- > >> m, U+1E40->m, U+1E41->m, U+1E42->m, U+1E43->m, U+1E44->n,U+1E45->n, U > > +1E46->n, U+1E47->n, U+1E48->n, U+1E49->n, U+1E4A->n,U+1E4B->n, U+1E4C- > >> o, U+1E4D->o, U+1E4E->o, U+1E4F->o, U+1E50->o,U+1E51->o, U+1E52->o, U > > +1E53->o, U+1E54->p, U+1E55->p, U+1E56->p,U+1E57->p, U+1E58->r, U+1E59- > >> r, U+1E5A->r, U+1E5B->r, U+1E5C->r,U+1E5D->r, U+1E5E->r, U+1E5F->r, U > > +1E60->s, U+1E61->s, U+1E62->s,U+1E63->s, U+1E64->s, U+1E65->s, U+1E66- > >> s, U+1E67->s, U+1E68->s,U+1E69->s, U+1E6A->t, U+1E6B->t, U+1E6C->t, U > > +1E6D->t, U+1E6E->t,U+1E6F->t, U+1E70->t, U+1E71->t, U+1E72->u, U+1E73- > >> u, U+1E74->u,U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U > > +1E7A->u,U+1E7B->u, U+1E7C->v, U+1E7D->v, U+1E7E->v, U+1E7F->v, U+1E80- > >> w,U+1E81->w, U+1E82->w, U+1E83->w, U+1E84->w, U+1E85->w, U+1E86->w,U > > +1E87->w, U+1E88->w, U+1E89->w, U+1E8A->x, U+1E8B->x, U+1E8C->x,U+1E8D- > >> x, U+1E8E->y, U+1E8F->y, U+1E96->h, U+1E97->t, U+1E98->w,U+1E99->y, U > > +1EA0->a, U+1EA1->a, U+1EA2->a, U+1EA3->a, U+1EA4->a,U+1EA5->a, U+1EA6- > >> a, U+1EA7->a, U+1EA8->a, U+1EA9->a, U+1EAA->a,U+1EAB->a, U+1EAC->a, U > > +1EAD->a, U+1EAE->a, U+1EAF->a, U+1EB0->a,U+1EB1->a, U+1EB2->a, U+1EB3- > >> a, U+1EB4->a, U+1EB5->a, U+1EB6->a,U+1EB7->a, U+1EB8->e, U+1EB9->e, U > > +1EBA->e, U+1EBB->e, U+1EBC->e,U+1EBD->e, U+1EBE->e, U+1EBF->e, U+1EC0- > >> e, U+1EC1->e, U+1EC2->e,U+1EC3->e, U+1EC4->e, U+1EC5->e, U+1EC6->e, U > > +1EC7->e, U+1EC8->i,U+1EC9->i, U+1ECA->i, U+1ECB->i, U+1ECC->o, U+1ECD- > >> o, U+1ECE->o,U+1ECF->o, U+1ED0->o, U+1ED1->o, U+1ED2->o, U+1ED3->o, U > > +1ED4->o,U+1ED5->o, U+1ED6->o, U+1ED7->o, U+1ED8->o, U+1ED9->o, U+1EDA- > >> o,U+1EDB->o, U+1EDC->o, U+1EDD->o, U+1EDE->o, U+1EDF->o, U+1EE0->o,U > > +1EE1->o, U+1EE2->o, U+1EE3->o, U+1EE4->u, U+1EE5->u, U+1EE6->u,U+1EE7- > >> u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u,U+1EED->u, U > > +1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, U+1EF2->y,U+1EF3->y, U+1EF4- > >> y, U+1EF5->y, U+1EF6->y, U+1EF7->y, U+1EF8->y,U+1EF9->y,U+0900..U > > +090F,U+0910..U+091F,U+0920..U+092F,U+0930..U+093F,U+0940..U+094F,U > > +0950..U+095F,U+0960..U+096F,U+0970..U+097F > > min_infix_len = 1 > > enable_star = 1 > > } > > > > source event_delta_0 : event_core_0 > > { > > type = mysql > > sql_host = localhost > > sql_user = root > > sql_pass = > > sql_db = testmate > > sql_port = 3306 > > sql_query_pre = > > sql_query_pre = SET NAMES utf8 > > sql_query_pre = SET TIME_ZONE = '+0:00' > > sql_query = SELECT SQL_NO_CACHE `events`.`id` * 2 + 0 AS `id` , > > `events`.`name` AS `name`, `events`.`city` AS `city`, > > `events`.`status` AS `status`, `event_types`.`name` AS > > `event_type_name`, `events`.`id` AS `sphinx_internal_id`, 4201588131 > > AS `class_crc`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`events`.`date`) > > AS `event`, UNIX_TIMESTAMP(`events`.`created_at`) AS `created_at` FROM > > `events` LEFT OUTER JOIN `event_types` ON `event_types`.`id` = > > `events`.`event_type_id` WHERE (`events`.`id` >= $start AND > > `events`.`id` <= $end AND `events`.`delta` = 1) GROUP BY > > `events`.`id`, `events`.`name`, `events`.`city`, `events`.`status`, > > `event_types`.`name`, `events`.`id`, `events`.`date`, > > `events`.`created_at` ORDER BY NULL > > sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) > > FROM `events` WHERE `events`.`delta` = 1 > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_timestamp = event > > sql_attr_timestamp = created_at > > sql_query_info = SELECT * FROM `events` WHERE `id` = (($id - 0) / 2) > > } > > > > index event_delta : event_core > > { > > source = event_delta_0 > > path = sphinx/event_delta > > } > > > > index event > > { > > type = distributed > > local = event_delta > > local = event_core > > } > > > > source question_core_0 > > { > > type = mysql > > sql_host = localhost > > sql_user = root > > sql_pass = > > sql_db = testmate > > sql_port = 3306 > > sql_query_pre = UPDATE `questions` SET `delta` = 0 WHERE `delta` = 1 > > sql_query_pre = SET NAMES utf8 > > sql_query_pre = SET TIME_ZONE = '+0:00' > > sql_query = SELECT SQL_NO_CACHE `questions`.`id` * 2 + 1 AS `id` , > > `questions`.`is_deleted` AS `is_deleted`, `questions`.`statement` AS > > `statement`, `questions`.`id` AS `sphinx_internal_id`, 1333865240 AS > > `class_crc`, 0 AS `sphinx_deleted`, `question_categories`.`id` AS > > `difficulty_level`, `grades`.`id` AS `grade_id`, > > `question_attributes`.`id` AS `subtopic`, `questions`.`moderator_id` > > AS `moderator_id`, `questions`.`id` AS `question_id`, > > `questions`.`submitter_id` AS `submitter_id` FROM `questions` LEFT > > OUTER JOIN `question_categories` ON `question_categories`.`id` = > > `questions`.`question_category_id` LEFT OUTER JOIN `grades` ON > > `grades`.`id` = `questions`.`grade_id` LEFT OUTER JOIN > > `question_attributes` ON `question_attributes`.`id` = > > `questions`.`question_attribute_id` WHERE (`questions`.`id` >= $start > > AND `questions`.`id` <= $end AND `questions`.`delta` = 0) GROUP BY > > `questions`.`id`, `questions`.`is_deleted`, `questions`.`statement`, > > `questions`.`id`, `question_categories`.`id`, `grades`.`id`, > > `question_attributes`.`id`, `questions`.`moderator_id`, > > `questions`.`id`, `questions`.`submitter_id` ORDER BY NULL > > sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) > > FROM `questions` WHERE `questions`.`delta` = 0 > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_uint = difficulty_level > > sql_attr_uint = grade_id > > sql_attr_uint = subtopic > > sql_attr_uint = moderator_id > > sql_attr_uint = question_id > > sql_attr_uint = submitter_id > > sql_query_info = SELECT * FROM `questions` WHERE `id` = (($id - 1) / > > 2) > > } > > > > index question_core > > { > > source = question_core_0 > > path = sphinx/question_core > > charset_type = utf-8 > > charset_table = 0..9, a..z, _, A..Z->a..z, U+00C0->a, U+00C1->a, U > > +00C2->a, U+00C3->a, U+00C4->a, U+00C5->a, U+00C7->c, U+00C8->e,U+00C9- > >> e, U+00CA->e, U+00CB->e, U+00CC->i, U+00CD->i, U+00CE->i,U+00CF->i, U > > +00D1->n, U+00D2->o, U+00D3->o, U+00D4->o, U+00D5->o, U+00D6->o, U > > +00D9->u, U+00DA->u, U+00DB->u, U+00DC->u, U+00DD->y, U+00E0->a, U > > +00E1->a, U+00E2->a, U+00E3->a, U+00E4->a, U+00E5->a, U+00E7->c, U > > +00E8->e, U+00E9->e, U+00EA->e, U+00EB->e, U+00EC->i, U+00ED->i, U > > +00EE->i, U+00EF->i, U+00F1->n, U+00F2->o, U+00F3->o, U+00F4->o, U > > +00F5->o, U+00F6->o, U+00F9->u, U+00FA->u, U+00FB->u, U+00FC->u, U > > +00FD->y, U+00FF->y, U+0100->a, U+0101->a, U+0102->a, U+0103->a, U > > +0104->a, U+0105->a, U+0106->c, U+0107->c, U+0108->c, U+0109->c, U > > +010A->c, U+010B->c, U+010C->c, U+010D->c, U+010E->d, U+010F->d, U > > +0112->e, U+0113->e, U+0114->e, U+0115->e, U+0116->e, U+0117->e, U > > +0118->e, U+0119->e, U+011A->e, U+011B->e, U+011C->g, U+011D->g, U > > +011E->g, U+011F->g, U+0120->g, U+0121->g, U+0122->g,U+0123->g, U+0124- > >> h, U+0125->h, U+0128->i, U+0129->i, U+012A->i,U+012B->i, U+012C->i, U > > +012D->i, U+012E->i, U+012F->i, U+0130->i,U+0134->j, U+0135->j, U+0136- > >> k, U+0137->k, U+0139->l, U+013A->l,U+013B->l, U+013C->l, U+013D->l, U > > +013E->l, U+0142->l, U+0143->n,U+0144->n, U+0145->n, U+0146->n, U+0147- > >> n, U+0148->n, U+014C->o,U+014D->o, U+014E->o, U+014F->o, U+0150->o, U > > +0151->o, U+0154->r,U+0155->r, U+0156->r, U+0157->r, U+0158->r, U+0159- > >> r, U+015A->s,U+015B->s, U+015C->s, U+015D->s, U+015E->s, U+015F->s, U > > +0160->s,U+0161->s, U+0162->t, U+0163->t, U+0164->t, U+0165->t, U+0168- > >> u,U+0169->u, U+016A->u, U+016B->u, U+016C->u, U+016D->u, U+016E->u,U > > +016F->u, U+0170->u, U+0171->u, U+0172->u, U+0173->u, U+0174->w,U+0175- > >> w, U+0176->y, U+0177->y, U+0178->y, U+0179->z, U+017A->z,U+017B->z, U > > +017C->z, U+017D->z, U+017E->z, U+01A0->o, U+01A1->o,U+01AF->u, U+01B0- > >> u, U+01CD->a, U+01CE->a, U+01CF->i, U+01D0->i,U+01D1->o, U+01D2->o, U > > +01D3->u, U+01D4->u, U+01D5->u, U+01D6->u,U+01D7->u, U+01D8->u, U+01D9- > >> u, U+01DA->u, U+01DB->u, U+01DC->u,U+01DE->a, U+01DF->a, U+01E0->a, U > > +01E1->a, U+01E6->g, U+01E7->g,U+01E8->k, U+01E9->k, U+01EA->o, U+01EB- > >> o, U+01EC->o, U+01ED->o,U+01F0->j, U+01F4->g, U+01F5->g, U+01F8->n, U > > +01F9->n, U+01FA->a,U+01FB->a, U+0200->a, U+0201->a, U+0202->a, U+0203- > >> a, U+0204->e,U+0205->e, U+0206->e, U+0207->e, U+0208->i, U+0209->i, U > > +020A->i,U+020B->i, U+020C->o, U+020D->o, U+020E->o, U+020F->o, U+0210- > >> r,U+0211->r, U+0212->r, U+0213->r, U+0214->u, U+0215->u, U+0216->u,U > > +0217->u, U+0218->s, U+0219->s, U+021A->t, U+021B->t, U+021E->h,U+021F- > >> h, U+0226->a, U+0227->a, U+0228->e, U+0229->e, U+022A->o,U+022B->o, U > > +022C->o, U+022D->o, U+022E->o, U+022F->o, U+0230->o,U+0231->o, U+0232- > >> y, U+0233->y, U+1E00->a, U+1E01->a, U+1E02->b,U+1E03->b, U+1E04->b, U > > +1E05->b, U+1E06->b, U+1E07->b, U+1E08->c,U+1E09->c, U+1E0A->d, U+1E0B- > >> d, U+1E0C->d, U+1E0D->d, U+1E0E->d,U+1E0F->d, U+1E10->d, U+1E11->d, U > > +1E12->d, U+1E13->d, U+1E14->e,U+1E15->e, U+1E16->e, U+1E17->e, U+1E18- > >> e, U+1E19->e, U+1E1A->e,U+1E1B->e, U+1E1C->e, U+1E1D->e, U+1E1E->f, U > > +1E1F->f, U+1E20->g,U+1E21->g, U+1E22->h, U+1E23->h, U+1E24->h, U+1E25- > >> h, U+1E26->h,U+1E27->h, U+1E28->h, U+1E29->h, U+1E2A->h, U+1E2B->h, U > > +1E2C->i,U+1E2D->i, U+1E2E->i, U+1E2F->i, U+1E30->k, U+1E31->k, U+1E32- > >> k,U+1E33->k, U+1E34->k, U+1E35->k, U+1E36->l, U+1E37->l, U+1E38->l,U > > +1E39->l, U+1E3A->l, U+1E3B->l, U+1E3C->l, U+1E3D->l, U+1E3E->m,U+1E3F- > >> m, U+1E40->m, U+1E41->m, U+1E42->m, U+1E43->m, U+1E44->n,U+1E45->n, U > > +1E46->n, U+1E47->n, U+1E48->n, U+1E49->n, U+1E4A->n,U+1E4B->n, U+1E4C- > >> o, U+1E4D->o, U+1E4E->o, U+1E4F->o, U+1E50->o,U+1E51->o, U+1E52->o, U > > +1E53->o, U+1E54->p, U+1E55->p, U+1E56->p,U+1E57->p, U+1E58->r, U+1E59- > >> r, U+1E5A->r, U+1E5B->r, U+1E5C->r,U+1E5D->r, U+1E5E->r, U+1E5F->r, U > > +1E60->s, U+1E61->s, U+1E62->s,U+1E63->s, U+1E64->s, U+1E65->s, U+1E66- > >> s, U+1E67->s, U+1E68->s,U+1E69->s, U+1E6A->t, U+1E6B->t, U+1E6C->t, U > > +1E6D->t, U+1E6E->t,U+1E6F->t, U+1E70->t, U+1E71->t, U+1E72->u, U+1E73- > >> u, U+1E74->u,U+1E75->u, U+1E76->u, U+1E77->u, U+1E78->u, U+1E79->u, U > > +1E7A->u,U+1E7B->u, U+1E7C->v, U+1E7D->v, U+1E7E->v, U+1E7F->v, U+1E80- > >> w,U+1E81->w, U+1E82->w, U+1E83->w, U+1E84->w, U+1E85->w, U+1E86->w,U > > +1E87->w, U+1E88->w, U+1E89->w, U+1E8A->x, U+1E8B->x, U+1E8C->x,U+1E8D- > >> x, U+1E8E->y, U+1E8F->y, U+1E96->h, U+1E97->t, U+1E98->w,U+1E99->y, U > > +1EA0->a, U+1EA1->a, U+1EA2->a, U+1EA3->a, U+1EA4->a,U+1EA5->a, U+1EA6- > >> a, U+1EA7->a, U+1EA8->a, U+1EA9->a, U+1EAA->a,U+1EAB->a, U+1EAC->a, U > > +1EAD->a, U+1EAE->a, U+1EAF->a, U+1EB0->a,U+1EB1->a, U+1EB2->a, U+1EB3- > >> a, U+1EB4->a, U+1EB5->a, U+1EB6->a,U+1EB7->a, U+1EB8->e, U+1EB9->e, U > > +1EBA->e, U+1EBB->e, U+1EBC->e,U+1EBD->e, U+1EBE->e, U+1EBF->e, U+1EC0- > >> e, U+1EC1->e, U+1EC2->e,U+1EC3->e, U+1EC4->e, U+1EC5->e, U+1EC6->e, U > > +1EC7->e, U+1EC8->i,U+1EC9->i, U+1ECA->i, U+1ECB->i, U+1ECC->o, U+1ECD- > >> o, U+1ECE->o,U+1ECF->o, U+1ED0->o, U+1ED1->o, U+1ED2->o, U+1ED3->o, U > > +1ED4->o,U+1ED5->o, U+1ED6->o, U+1ED7->o, U+1ED8->o, U+1ED9->o, U+1EDA- > >> o,U+1EDB->o, U+1EDC->o, U+1EDD->o, U+1EDE->o, U+1EDF->o, U+1EE0->o,U > > +1EE1->o, U+1EE2->o, U+1EE3->o, U+1EE4->u, U+1EE5->u, U+1EE6->u,U+1EE7- > >> u, U+1EE8->u, U+1EE9->u, U+1EEA->u, U+1EEB->u, U+1EEC->u,U+1EED->u, U > > +1EEE->u, U+1EEF->u, U+1EF0->u, U+1EF1->u, U+1EF2->y,U+1EF3->y, U+1EF4- > >> y, U+1EF5->y, U+1EF6->y, U+1EF7->y, U+1EF8->y,U+1EF9->y,U+0900..U > > +090F,U+0910..U+091F,U+0920..U+092F,U+0930..U+093F,U+0940..U+094F,U > > +0950..U+095F,U+0960..U+096F,U+0970..U+097F > > min_infix_len = 1 > > enable_star = 1 > > } > > > > source question_delta_0 : question_core_0 > > { > > type = mysql > > sql_host = localhost > > sql_user = root > > sql_pass = > > sql_db = testmate > > sql_port = 3306 > > sql_query_pre = > > sql_query_pre = SET NAMES utf8 > > sql_query_pre = SET TIME_ZONE = '+0:00' > > sql_query = SELECT SQL_NO_CACHE `questions`.`id` * 2 + 1 AS `id` , > > `questions`.`is_deleted` AS `is_deleted`, `questions`.`statement` AS > > `statement`, `questions`.`id` AS `sphinx_internal_id`, 1333865240 AS > > `class_crc`, 0 AS `sphinx_deleted`, `question_categories`.`id` AS > > `difficulty_level`, `grades`.`id` AS `grade_id`, > > `question_attributes`.`id` AS `subtopic`, `questions`.`moderator_id` > > AS `moderator_id`, `questions`.`id` AS `question_id`, > > `questions`.`submitter_id` AS `submitter_id` FROM `questions` LEFT > > OUTER JOIN `question_categories` ON `question_categories`.`id` = > > `questions`.`question_category_id` LEFT OUTER JOIN `grades` ON > > `grades`.`id` = `questions`.`grade_id` LEFT OUTER JOIN > > `question_attributes` ON `question_attributes`.`id` = > > `questions`.`question_attribute_id` WHERE (`questions`.`id` >= $start > > AND `questions`.`id` <= $end AND `questions`.`delta` = 1) GROUP BY > > `questions`.`id`, `questions`.`is_deleted`, `questions`.`statement`, > > `questions`.`id`, `question_categories`.`id`, `grades`.`id`, > > `question_attributes`.`id`, `questions`.`moderator_id`, > > `questions`.`id`, `questions`.`submitter_id` ORDER BY NULL > > sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) > > FROM `questions` WHERE `questions`.`delta` = 1 > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_uint = difficulty_level > > sql_attr_uint = grade_id > > sql_attr_uint = subtopic > > sql_attr_uint = moderator_id > > sql_attr_uint = question_id > > sql_attr_uint = submitter_id > > sql_query_info = SELECT * FROM `questions` WHERE `id` = (($id - 1) / > > 2) > > } > > > > index question_delta : question_core > > { > > source = question_delta_0 > > path = sphinx/question_delta > > } > > > > index question > > { > > type = distributed > > local = question_delta > > local = question_core > > } > > > > Regards, > > Surbhi > > > > -- > > You received this message because you are subscribed to the Google Groups > > "Thinking Sphinx" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > > http://groups.google.com/group/thinking-sphinx?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
