Go Back   vb.org Archive > Community Central > Community Lounge
Reload this Page I have a sob-story and a cautionary tale to relate ...
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2004, 01:55 PM
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Location: Australia
Posts: 851
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default I have a sob-story and a cautionary tale to relate ...
The problem: Leave a maintenance problem for long enuff and BOOM!

350-odd emails arrive in my inbox with SQL errors (after a convenient 72 hours of intermittent net access due to my ISP having their collective heads up their collective orifices)

One or more of the tables in the database needed repairing - due to a bug in the version of MySQL that we have on the server ... [a good reminder for me to run maintenance on the database more often]

I research the SQL error, get advised by some site out there that I needed to run REPAIR on my SQL tables, but to be prepared to restore from a backup (good thing I had the cron-backup script ! thanks brad.loo!

The report on the REPAIR told me my user table had been reduced in total number of rows by one (1).

I return to the forum and find my cookied access had been lost ... (some of you are seeing the punchline...) so I tried to login, incorrect login or password (WTF?? checks caps-lock) .. then I decided to bite the butllet and check the database ... my user ID was the only missing record in the user table!

One look at our most recent forum backup gave me the Query to re-insert my account via the backend and I was back in again ...

Who woulda thought when it said that "The number of rows has reduced from 669 to 668" that the missing user would be ME !

Quote:
Backups are a good thing!
EOF
Reply With Quote
  #2  
Old 05-13-2004, 02:38 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Ouch! What version of MySQL are you running?
Reply With Quote
  #3  
Old 05-13-2004, 02:51 PM
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Location: Australia
Posts: 851
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
MySQL 4.0.18 - seems there's some sort of bug relating to large numbers of DELETE queries being run in close sequence ... or something like that ...
Reply With Quote
  #4  
Old 05-13-2004, 02:57 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Oh-Oh. That's what they're running on my server. They just upgraded to v4.0.18-standard. I hadn't heard of this bug. And patch or fix for it yet?
Reply With Quote
  #5  
Old 05-13-2004, 03:16 PM
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Location: Australia
Posts: 851
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Mate - I'm not sure ... I am actually assuming that the bug is in my version (as I had the problem) but I will take a browse thru my logs and see if I can find the place I got the info from ... see if I am giving u the right info ... before you go and bug your host about another upgrade ...
Reply With Quote
  #6  
Old 05-13-2004, 03:18 PM
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Location: Australia
Posts: 851
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You see there I go ... it was 4.0.14 that had the bug ...

4.0.18 is fine (afaik) ...

http://support.discusware.com/forum/...tml?1058121551 <- solution

and

http://lists.mysql.com/mysql/164250 <- this whole thread was useful
Reply With Quote
  #7  
Old 05-13-2004, 03:42 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Natch
You see there I go ... it was 4.0.14 that had the bug ...

4.0.18 is fine (afaik) ...

http://support.discusware.com/forum/...tml?1058121551 <- solution

and

http://lists.mysql.com/mysql/164250 <- this whole thread was useful
Thank for the heads up, Mr. working on WAR with Bob.
Reply With Quote
  #8  
Old 05-13-2004, 03:43 PM
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Location: Australia
Posts: 851
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Boofo
Thank for the heads up, Mr. working on WAR with Bob.
{ten chars}
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 06:05 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04117 seconds
  • Memory Usage 2,230KB
  • Queries Executed 13 (?)
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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete