Welcome to Dream.In.Code
Getting Help is Easy!

Join 132,660 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,186 people online right now. Registration is fast and FREE... Join Now!




Server Problem?

 
Reply to this topicStart new topic

Server Problem?

AdamSpeight2008
post 5 Aug, 2008 - 06:21 PM
Post #1


LINQ D.I.C.

Group Icon
Joined: 29 May, 2008
Posts: 756



Thanked 48 times

Dream Kudos: 2125
My Contributions


Are you also experiencing problems with the sql server reporting the there is a shutdown in progress?
Example error code
CODE

mySQL query error: SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view_img, auto_track,
                                                                  mod_posts, language, skin, new_msg, show_popup, msg_total, time_offset, posts, joined, last_post, subs_pkg_chosen,
                                                                  ignored_users, login_anonymous, last_visit, last_activity, dst_in_use, view_prefs, org_perm_id, mgroup_others, temp_ban, sub_end,
                                                                  has_blog, members_markers, members_editor_choice, members_auto_dst, members_display_name, members_created_remote,
                                                                  members_cache, members_disable_pm FROM ibf_members WHERE id=88833

SQL error: Server shutdown in progress
SQL error code:
Date: Tuesday 05th 2008f August 2008 08:21:07 PM


This post has been edited by AdamSpeight2008: 5 Aug, 2008 - 06:28 PM
User is offlineProfile CardPM

Go to the top of the page

KYA
post 5 Aug, 2008 - 06:25 PM
Post #2


#include <nerd.h>

Group Icon
Joined: 14 Sep, 2007
Posts: 4,211



Thanked 50 times

Dream Kudos: 1150
My Contributions


I had that for a while as well, back up now though smile.gif
User is offlineProfile CardPM

Go to the top of the page

skyhawk133
post 5 Aug, 2008 - 06:42 PM
Post #3


Head DIC Head

Group Icon
Joined: 17 Mar, 2001
Posts: 14,846



Thanked 45 times

Dream Kudos: 1650

Expert In: Web Development

My Contributions


Yeh, I'm trying to run a query to unsubscribe all the people that bounced from the last newsletter but I can't figure out the most optimal query to do it so it's taking like 5 minutes to run and killing the server in the process.

I'll leave it for a while wink2.gif
User is offlineProfile CardPM

Go to the top of the page

no2pencil
post 5 Aug, 2008 - 06:44 PM
Post #4


My fridge be runnin OH NOEZ!

Group Icon
Joined: 10 May, 2007
Posts: 6,354



Thanked 58 times

Dream Kudos: 2375

Expert In: Goofing Off

My Contributions


Could you dump the database, move it to another machine, perform the query & then update only the desired results?

Just wondering...
User is offlineProfile CardPM

Go to the top of the page

skyhawk133
post 5 Aug, 2008 - 06:48 PM
Post #5


Head DIC Head

Group Icon
Joined: 17 Mar, 2001
Posts: 14,846



Thanked 45 times

Dream Kudos: 1650

Expert In: Web Development

My Contributions


Don't have another server to do it on.

I think the problem is I'm trying to do an UPDATE ibf_members SET allow_admin_mails = '0' WHERE email IN (SELECT addy FROM bounces)

110,000 rows in IBF_Members
8,000 rows in bounces

means it's running millions of querys to do the update.

email isn't an index in ibf_members which is why I think it's running really slow.

User is offlineProfile CardPM

Go to the top of the page

AdamSpeight2008
post 5 Aug, 2008 - 07:52 PM
Post #6


LINQ D.I.C.

Group Icon
Joined: 29 May, 2008
Posts: 756



Thanked 48 times

Dream Kudos: 2125
My Contributions


Have you tried?
sql

UPDATE bounces LEFT JOIN ibf_members ON bounces.email=ibf_members.email SET ibf_members.allow_admin_mail = 0
WHERE ((bounces!email=ibf_members!email));
User is offlineProfile CardPM

Go to the top of the page

skyhawk133
post 5 Aug, 2008 - 08:14 PM
Post #7


Head DIC Head

Group Icon
Joined: 17 Mar, 2001
Posts: 14,846



Thanked 45 times

Dream Kudos: 1650

Expert In: Web Development

My Contributions


No. I haven't, but will give it a shot the next time I'm downstairs on my desktop.
User is offlineProfile CardPM

Go to the top of the page

AdamSpeight2008
post 5 Aug, 2008 - 08:20 PM
Post #8


LINQ D.I.C.

Group Icon
Joined: 29 May, 2008
Posts: 756



Thanked 48 times

Dream Kudos: 2125
My Contributions


QUOTE(skyhawk133 @ 6 Aug, 2008 - 05:14 AM) *

No. I haven't, but will give it a shot the next time I'm downstairs on my desktop.


Remove the where clause.
sql

UPDATE bounces LEFT JOIN ibf_members ON bounces.email=ibf_members.email SET ibf_members.allow_admin_mail = 0
User is offlineProfile CardPM

Go to the top of the page

AdamSpeight2008
post 7 Aug, 2008 - 02:59 PM
Post #9


LINQ D.I.C.

Group Icon
Joined: 29 May, 2008
Posts: 756



Thanked 48 times

Dream Kudos: 2125
My Contributions


Did you find an efficient solution?
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/23/08 05:36AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month