Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #231  
Old 11-15-2006, 10:48 AM
orban orban is offline
 
Join Date: Jan 2005
Posts: 445
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Why can't you have the counter table you run REPLACE INTO on the slave server?

Master: vB
Slave: Replicated vB + counter table + sphinx

Should work fine :O
Reply With Quote
  #232  
Old 11-15-2006, 10:54 AM
amcd amcd is offline
 
Join Date: Oct 2004
Posts: 218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

orban, any suggestions for my problem?
Reply With Quote
  #233  
Old 11-15-2006, 11:01 AM
orban orban is offline
 
Join Date: Jan 2005
Posts: 445
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you can reproduce the error with "search" I'd try the sphinx forums....or does it only happen when using sphinxapi.php?
Reply With Quote
  #234  
Old 11-15-2006, 11:31 AM
Neil Lock Neil Lock is offline
 
Join Date: Sep 2005
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The slave server as far as i know(and im pretty sure) has only read permissions hence the replace will have to be run on the master (which is then obv replicated across) so i cannot write to the slave db at all.

Neil
Reply With Quote
  #235  
Old 11-15-2006, 01:46 PM
kmike kmike is offline
 
Join Date: Oct 2002
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nothing can prevent you from creating a new table in the replicated db on the slave - granted your db user has the create/update privileges on that db. So your assertion that the slave is read-only isn't true.

(Actually nothing prevents you from messing with replicated tables on the slave, too - which obviously will break the replication integrity)
Reply With Quote
  #236  
Old 11-16-2006, 08:53 AM
amcd amcd is offline
 
Join Date: Oct 2004
Posts: 218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by orban View Post
If you can reproduce the error with "search" I'd try the sphinx forums....or does it only happen when using sphinxapi.php?
as far as i can tell, it happens only when using the API

Code:
Warning: assert() [function.assert]: Assertion failed in /sphinxapi.php on line 284
Query '' retrieved 0 of 0 matches in 0.000 sec.
Query stats:
'barnacles' found 11 times in 11 documents
it does say that it got 11 results, so probably the error is not in the searchd portion

looks like i may have solved the problem by using the array_walk and intval approach as discussed by orban and alanjay. strange thing is that my forums are running vb 3.6.1, not 3.0.x for which the discussion was originally intended.
Reply With Quote
  #237  
Old 11-20-2006, 10:06 PM
mute mute is offline
 
Join Date: Dec 2002
Location: Phoenixville, PA
Posts: 152
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hm. We're running into that "search results are out of order" bug again, even if a user has the sort set to by date, rather than relevancy.

Has anyone else using this run into it?
Reply With Quote
  #238  
Old 11-21-2006, 06:29 AM
ALanJay ALanJay is offline
 
Join Date: Jun 2002
Location: London
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by amcd View Post
looks like i may have solved the problem by using the array_walk and intval approach as discussed by orban and alanjay. strange thing is that my forums are running vb 3.6.1, not 3.0.x for which the discussion was originally intended.
I viewed it as a bit of a belt and braces issue

the values are numerals but sometimes they seem to be stored as strings no idea why but array_walk and intval seem to resolve the issue simply enough.

By the way for anyone interested I have now used Sphix to create a search interface to both our news and forums databases outside of vBulletin. Next step to implement the sort order (which jsut needs to be made pretty).

You can see the tool at http://www.digitalspy.co.uk/search/ds-search.php
Reply With Quote
  #239  
Old 11-25-2006, 02:19 AM
DaiTengu DaiTengu is offline
 
Join Date: Nov 2005
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kmike View Post
Nothing can prevent you from creating a new table in the replicated db on the slave - granted your db user has the create/update privileges on that db. So your assertion that the slave is read-only isn't true.

(Actually nothing prevents you from messing with replicated tables on the slave, too - which obviously will break the replication integrity)
Sure there is, you can put a read-only option in my.cnf to prevent users from writing data to the database (except for the replication user & the root user)


Anyway, I am also running into the results out of order bug. I haven't changed anything, and it just seemed to start cropping up one day.
Reply With Quote
  #240  
Old 11-25-2006, 03:03 AM
mute mute is offline
 
Join Date: Dec 2002
Location: Phoenixville, PA
Posts: 152
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah, my users are complaining about the out of order results, but I haven't had the time lately to delve into it. I swear at one point it was working, but now.. not so much.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:07 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05185 seconds
  • Memory Usage 2,276KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete