Matt every body i speak to in the "real world "says there internet is real slow at moment could this be anything that could cause the site problems this week just a thought as im having real probs with mine too !
Nealy I'm not having any problems, at the moment, touch wood. My computer speed is as quick as it should be, altho the colour box A (when you post in the forum) keeps disappearing and the numbers 1 to 6 appear.
aparently all the peeps ive talked to are on you guessed it talk talk like me ive reverted back to mobile because its quicker than land line conection
and yes some of the icons keeps diserpearing from my screen too
must be conected some where ?
RustyKnight In: Newton Aycliffe
Posts: 2462
Karma:
Neal I don't really understand how the internet works between different providers but our work connection has been crap all week and the provider has told us there have been some 'major outages' whatever that means
it can happen, and used to happen often when i hired servers in America. Sometimes ships would drag anchors over cables, which doesn't take the net down but it sends all the signals around the houses, choking up connections.
Same thing can happen even now, though normally never, because I'm in Holland with the servers. If the main cable, say from Amsterdam > London is down, then anyone going over it might have to go from London > Paris > Amsterdam. You get the point.
There are some websites where you can check the internet's "Backbones", of which there are many (on different levels/tiers, which different providers use).
So talk-talk might be using one backbone and Virgin/BT might be using another one.
Hopefully this is why people keep complaining this week about the site being slow - cos I can assure you it's not (I've hoped via proxy servers in Australia to test it!).
RustyKnight In: Newton Aycliffe
Posts: 2462
Karma:
Microsoft OLE DB Provider for SQL Server error �' Transaction (Process ID 63) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /sites/bm/forum/posts.asp, line 252Got this trying to post a post Matt
Thanks RK.
Just to let you all know that I've made some drastic improvements to the site's infrastructure (SQL Database) following advice from qualified experts.
This change should all but elliminate deadlock errors and even dramatically improve the site performance (specifically during peak hours).
The change made could have some unwanted effects, and I desperately need you to give me any feedback you have.
If you get ANY error message (That mentions SQL or Database) then post here. If you find pages are hanging then post here. If you think the site is faster during the evening hours then again please post here.
Many thanks
Error message
Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
/sites/bm/forum/posts.asp, line 248
At 23:36:56
The following error message
Microsoft OLE DB Provider for SQL Server error �'
Transaction (Process ID 102) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
/sites/bm/forum/chat.asp, line 11
Just had this as I tried to edit an event in the calendar.
Where it says 'no work was done' that's not right cos I've been working all evening lol
Microsoft OLE DB Provider for SQL Server error ?e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/sites/bm/events/event_mod.asp, line 53
sorry but there were 300 deadlock errors last night. There's some fundamental infrastructure design problems with the system (yes it's my fault). Unfortunately it's VERY complicated and I need to rethink a lot of the underlying site structure. I promise I'm working on it as the highest priority.
Kwak, your error is different. It means that something you entered wasn't accepted. When is says "no work was done" it means that your update wasn't applied (even though the script instructs it to, it couldn't do so).
Possible fix implemented to the USERS table which is what's causing all the locks at the moment. Everytime you login, refresh a page, etc it updates your account to say when you last logged in (so I can program the Online Users page to show who's online now). Well each time this update occurs it locks the data which crashes/deadlocks other people (like those in the chatroom).
Should be fixed now, so I'm gonna also look at the forum topics and posts which also cause a lot of trouble (lots of data and updates)
Forums should be good now too. Please monitor the site and let me know about anymore SQL errors.
Note: I'm tracking it from the server side and I can see deadlock errors, I just don't know who's getting them or when (I only see the clash/deadlock).
![Weird SQL errors and peformance issues this week (4) - Forums [Biker Match]](/images/backgrounds/strips/8mobileLQ.jpg)
![Weird SQL errors and peformance issues this week (4) - Forums [Biker Match]](/images/backgrounds/strips/8desktopLQ.jpg)
