Search
Notices
Forum Suggestions & User Assistance Have a suggestion for the forums? Need help with the Forums? Post here.

Database error.

Thread Tools
 
Search this Thread
 
Old 01-26-25 | 09:06 PM
  #76  
Ron Damon's Avatar
Senior Member
Community Builder
 
Joined: Jun 2022
Posts: 2,309
Likes: 1,241
From: The Ring of Fire, the Global South, Asia-Pacific, the Tropics...

Bikes: Several, all affordably priced, none exalted cult artifacts or hype jobs

Unresolved still.
Ron Damon is offline  
Reply
Old 01-26-25 | 10:35 PM
  #77  
Highly Enriched Driftium
5 Anniversary
Community Builder
Community Influencer
 
Joined: Apr 2017
Posts: 6,667
Likes: 2,156
Still occurance here, but much faster resolution, under 10 minutes from time down to back up.
Duragrouch is offline  
Reply
Old 01-26-25 | 11:24 PM
  #78  
Full Member
5 Anniversary
 
Joined: Aug 2020
Posts: 324
Likes: 681
From: SF Bay Area
Database Error still happened a few times today. It comes back online after about 5-10 minutes for me.Safari browser.
letrebici is offline  
Reply
Old 01-27-25 | 01:28 PM
  #79  
Administrator
 
Joined: Mar 2023
Posts: 162
Likes: 182
Tech made another change this morning. If there are any other instances of the db error, please let me know.
IBkatherine is offline  
Reply
Old 01-27-25 | 03:08 PM
  #80  
badger1's Avatar
Senior Member
20 Anniversary
 
Joined: Oct 2005
Posts: 5,549
Likes: 1,812
From: Southwestern Ontario
Originally Posted by IBkatherine
Tech made another change this morning. If there are any other instances of the db error, please let me know.
Just now (4 p.m. EST); lasted about 5 minutes.
badger1 is offline  
Reply
Old 01-27-25 | 03:16 PM
  #81  
...
Titanium Club Membership
 
Joined: Oct 2021
Posts: 2,528
Likes: 3,471
From: Whitestone and Rensselaerville, New York

Bikes: '23 Canyon Endurace, '87 Bottecchia Equipe Professional

Still getting DB error about 50% of my tries.
BTinNYC is offline  
Reply
Old 01-27-25 | 03:18 PM
  #82  
Trav1s's Avatar
Not lost, just exploring
5 Anniversary
 
Joined: Jun 2019
Posts: 1,607
Likes: 1,757
From: Near the Heart of OH

Bikes: '25 Jamis Renegade S1, '18 Quick 1,'04 Trek 2300, '97 730 Multitrack, '95 750 Multitrack, and a few others

I can't find a pattern but it's been hit or miss all day and device does not matter.
Trav1s is online now  
Reply
Old 01-27-25 | 04:26 PM
  #83  
Amateur Member
5 Anniversary
 
Joined: Mar 2021
Posts: 5,116
Likes: 8,493
From: SoCal

Bikes: Cuevas & Cimmaron are my full time riders, small MB-3 and large Competition GS are my sometimers

Originally Posted by IBkatherine
Tech made another change this morning. If there are any other instances of the db error, please let me know.
Thanks for chasing this, but still getting the db error through the weekend and on and off all day today
SoCaled is online now  
Reply
Old 01-27-25 | 06:15 PM
  #84  
Shadco's Avatar
Old and in the way
Titanium Club Membership
20 Anniversary
Community Builder
 
Joined: Jul 2004
Posts: 1,467
Likes: 1,041
From: City of Oaks, NC

Bikes: Look 765 Optimum, Spesh Aethos

Originally Posted by IBkatherine
Tech made another change this morning. If there are any other instances of the db error, please let me know.
Been happening all day as late as 7pm est.

.
__________________
--
Shad, Kitted up half wavin m’fer.
Shadco is offline  
Reply
Old 01-27-25 | 06:40 PM
  #85  
joesch's Avatar
Senior Member
5 Anniversary
 
Joined: Sep 2017
Posts: 2,380
Likes: 1,266
From: Hotel CA / DFW

Bikes: 80s Colnago Super/NMx, 50th Daccordi, Pinarello's, Guerciotti's, Masi NS, 90s DB/GT Mtn Bikes, 90s Colnago Master, 96 Serotta Colorado TG, 95/05 Colnago C40/C50, 06 LS TI, 08 Lemond Filmore FG SS, 12 Cervelo R3, 20/15 Surly Stragler & Steamroller

Originally Posted by Duragrouch
Is It Down Right Now website is an easy way to independently verify that the site is down, it's not you or your computer or software. It pings the site and will give a red or green message about the site, and also time it has been down (I don't know how it knows that, or if just based on the last time it was requested to ping the site):

https://www.isitdownrightnow.com/

You can pull it up fast in your browser by just searching for iidrn, it will come right up in results.

I'm still getting the error, but it seems to be corrected MUCH faster than at the beginning of recent events. I sense some corrective coding by the techs to combat aggressive web crawlers.
The BF server will ping but still fail to resolve references, ie DB errors. I verified this 15 minutes ago when I could not get to any BF links via two diff browsers. Its a code error, hopefully they can isolate and fix ...
joesch is offline  
Reply
Old 01-27-25 | 06:44 PM
  #86  
joesch's Avatar
Senior Member
5 Anniversary
 
Joined: Sep 2017
Posts: 2,380
Likes: 1,266
From: Hotel CA / DFW

Bikes: 80s Colnago Super/NMx, 50th Daccordi, Pinarello's, Guerciotti's, Masi NS, 90s DB/GT Mtn Bikes, 90s Colnago Master, 96 Serotta Colorado TG, 95/05 Colnago C40/C50, 06 LS TI, 08 Lemond Filmore FG SS, 12 Cervelo R3, 20/15 Surly Stragler & Steamroller

Originally Posted by IBkatherine
Tech made another change this morning. If there are any other instances of the db error, please let me know.
The BF server will ping but still fail to resolve references, ie DB errors. I verified this 15 minutes ago when I could not get to any BF links via two diff browsers. Its a code error, hopefully they can isolate and fix ...
joesch is offline  
Reply
Old 01-27-25 | 07:05 PM
  #87  
RCMoeur's Avatar
Cantilever believer
Titanium Club Membership
Community Builder
Community Influencer
 
Joined: Nov 2021
Posts: 3,084
Likes: 4,727
From: Phoenix, AZ
Just returned a bunch of database errors, but then a few minutes later I am able to enter & browse.
__________________
Richard C. Moeur, PE - Phoenix AZ, USA
https://www.richardcmoeur.com/bikestuf.html
RCMoeur is offline  
Reply
Old 01-27-25 | 09:22 PM
  #88  
Highly Enriched Driftium
5 Anniversary
Community Builder
Community Influencer
 
Joined: Apr 2017
Posts: 6,667
Likes: 2,156
Originally Posted by joesch
The BF server will ping but still fail to resolve references, ie DB errors. I verified this 15 minutes ago when I could not get to any BF links via two diff browsers. Its a code error, hopefully they can isolate and fix ...
I trust ya. For me at least, there has been perfect correlation between status at iidrn and my ability to use the forum. I don't think user browser and system matters, but for ref, I'm Firefox on an Android device.

I'd be curious to know if the BF servers can sense a web crawler and disengage with or block only that, or needs to reboot to restore function.

Last edited by Duragrouch; 01-27-25 at 09:25 PM.
Duragrouch is offline  
Reply
Old 01-28-25 | 08:07 AM
  #89  
Senior Member
Titanium Club Membership
15 Anniversary
 
Joined: Aug 2007
Posts: 5,958
Likes: 2,138
From: Evanston, IL

Bikes: many

Originally Posted by Duragrouch
I'd be curious to know if the BF servers can sense a web crawler and disengage with or block...
I imagine that would turn into a game of whack-a-mole. Any web crawler large enough to effectively execute a denial-of-service attack on the BF server(s) would likely be coming from multiple places at once (or nearly at once).

The BF admins should be able to identify the culprits and threaten their ISPs with total blockage. Whatever it is, it certainly seems not to be well-behaved. OTOH, the BF robots.txt file is pretty skimpy, disallowing the ChatGPT bot, a few specific pages, some Google thing I don't recognize as a typical search engine crawler, and imposing a one-second delay only on Bing's crawler. If clients are ignoring the specific disallow entries (which mostly look like they would cause database activity), they should definitely be blocked strenuously. If more than Bing might hit the server too hard, I'd add a larger crawl delay and apply it to all crawlers, something like

User-agent: *
Crawl-delay: 100
Another step might be to beef up the hardware. I don't know what Internet Brands uses, but in this day and age, it seems their servers should be hosted in the cloud with near real-time expansion of capacity as needed.

Last edited by smontanaro; 01-29-25 at 05:52 AM.
smontanaro is offline  
Reply
Old 01-28-25 | 01:41 PM
  #90  
Administrator
 
Joined: Mar 2023
Posts: 162
Likes: 182
Originally Posted by smontanaro
I imagine that would turn into a game of whack-a-mole. Any web crawler large enough to effectively execute a denial-of-service attack on the BF server(s) would likely be coming from multiple places at once (or nearly at once).

The BF admins should be able to identify the culprits and threaten their ISPs with total blockage. Whatever it is, it certainly seems not to be well-behaved. OTOH, the BF robots.txt file is pretty skimpy, disallowing the ChatGPT bot, a few specific pages, some Google thing I don't recognize as a typical search engine crawler, and imposing a one-second delay only on Bing's crawler. If clients are ignoring the specific disallow entries (which mostly look like they would cause database activity), they should definitely be blocked strenuously. If more than Bing might hit the server too hard, I'd add a larger crawl delay and apply it to all crawlers, something like
Tech did add a 5 second delay over the weekend (which looked like it did not do much, as a lot of you were still experiencing the error). It was then changed back to a one second delay yesterday. An IP was banned, but the errors still persisted. There's nothing starkly out there that points towards why we were experiencing the db errors. But it seems to have died down today- I at least have not come across any errors...
IBkatherine is offline  
Reply
Old 01-28-25 | 01:47 PM
  #91  
Senior Member
Titanium Club Membership
15 Anniversary
 
Joined: Aug 2007
Posts: 5,958
Likes: 2,138
From: Evanston, IL

Bikes: many

Originally Posted by IBkatherine
Tech did add a 5 second delay over the weekend (which looked like it did not do much, as a lot of you were still experiencing the error). It was then changed back to a one second delay yesterday. An IP was banned, but the errors still persisted. There's nothing starkly out there that points towards why we were experiencing the db errors. But it seems to have died down today- I at least have not come across any errors...
The server logs must give you an idea which domains are hitting the server the hardest. Also, the robots.txt file is advisory. Clients agree to adhere to its dictates, but there's no enforcement. It's possible someone is either ignoring the crawler delay or hitting one or more of the disallowed URLs. In either case, that would warrant a block. If you banned a single IP, might it have just been a poorly behaved homegrown crawler? If it was a larger crawler, they would likely have hit you from multiple IP addresses, so you might have to block a larger block of addresses.

Also, sticking a modern web server like nginx in front of your actual web server (if you haven't already) could give you more knobs to turn regarding blocks, pauses, blacklists, etc.
__________________
My bikes
smontanaro is offline  
Reply
Old 01-29-25 | 10:11 AM
  #92  
Administrator
 
Joined: Mar 2023
Posts: 162
Likes: 182
Originally Posted by smontanaro
The server logs must give you an idea which domains are hitting the server the hardest. Also, the robots.txt file is advisory. Clients agree to adhere to its dictates, but there's no enforcement. It's possible someone is either ignoring the crawler delay or hitting one or more of the disallowed URLs. In either case, that would warrant a block. If you banned a single IP, might it have just been a poorly behaved homegrown crawler? If it was a larger crawler, they would likely have hit you from multiple IP addresses, so you might have to block a larger block of addresses.

Also, sticking a modern web server like nginx in front of your actual web server (if you haven't already) could give you more knobs to turn regarding blocks, pauses, blacklists, etc.
I am not tech so I do not know exactly what they did. They easily could have done more than what I relayed as it was pushed to different teams. Regardless, whatever it is that they did or did not do specifically, seems to have worked as there were no reports yesterday about any database errors.
IBkatherine is offline  
Reply
Old 01-29-25 | 11:22 AM
  #93  
Senior Member
Titanium Club Membership
15 Anniversary
 
Joined: Aug 2007
Posts: 5,958
Likes: 2,138
From: Evanston, IL

Bikes: many

Thanks IBkatherine. Since this is/was such a pervasive problem, it would be nice to get an after action report from the tech team.
__________________
My bikes
smontanaro is offline  
Reply
Old 01-29-25 | 07:25 PM
  #94  
Trav1s's Avatar
Not lost, just exploring
5 Anniversary
 
Joined: Jun 2019
Posts: 1,607
Likes: 1,757
From: Near the Heart of OH

Bikes: '25 Jamis Renegade S1, '18 Quick 1,'04 Trek 2300, '97 730 Multitrack, '95 750 Multitrack, and a few others

I've been good after 12:00 PM Eastern today (mobile and computer browser.)
Trav1s is online now  
Reply
Old 01-30-25 | 04:25 AM
  #95  
Highly Enriched Driftium
5 Anniversary
Community Builder
Community Influencer
 
Joined: Apr 2017
Posts: 6,667
Likes: 2,156
Originally Posted by IBkatherine
I am not tech so I do not know exactly what they did. They easily could have done more than what I relayed as it was pushed to different teams. Regardless, whatever it is that they did or did not do specifically, seems to have worked as there were no reports yesterday about any database errors.
All quiet on this front.

It's nice these days to not be alone in problem solving; If you can't find an answer online, you can find someone online who has answers. Unless you can't get online.
Duragrouch is offline  
Reply
Old 01-30-25 | 04:57 AM
  #96  
...
Titanium Club Membership
 
Joined: Oct 2021
Posts: 2,528
Likes: 3,471
From: Whitestone and Rensselaerville, New York

Bikes: '23 Canyon Endurace, '87 Bottecchia Equipe Professional

Fixed for me.
Thanks Mods!
BTinNYC is offline  
Reply
Old 03-14-25 | 01:47 PM
  #97  
Amateur Member
5 Anniversary
 
Joined: Mar 2021
Posts: 5,116
Likes: 8,493
From: SoCal

Bikes: Cuevas & Cimmaron are my full time riders, small MB-3 and large Competition GS are my sometimers

It's back . . .
SoCaled is online now  
Reply
Old 03-14-25 | 05:12 PM
  #98  
Administrator
 
Joined: Mar 2023
Posts: 162
Likes: 182
I just got a db error too. There's not much we can do as my work day is almost over, but if it continues and worsens over the weekend we will investigate on Monday.
IBkatherine is offline  
Reply
Old 03-14-25 | 06:11 PM
  #99  
datlas's Avatar
Should Be More Popular
Titanium Club Membership
15 Anniversary
Community Builder
Community Influencer
 
Joined: Dec 2007
Posts: 46,115
Likes: 11,718
From: Malvern, PA (20 miles West of Philly)

Bikes: 1986 Alpine (steel road bike), 2009 Ti Habenero, 2013 Specialized Roubaix

Agree it has been on again/off again the past hour or two.
__________________
Originally Posted by rjones28
Addiction is all about class.
datlas is offline  
Reply
Old 03-15-25 | 05:36 AM
  #100  
Highly Enriched Driftium
5 Anniversary
Community Builder
Community Influencer
 
Joined: Apr 2017
Posts: 6,667
Likes: 2,156
Me too, but not down long (time it took to do a system update), perhaps indicating a good fault recovery.
Duragrouch is offline  
Reply


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.