Hey VerticalScope, our database sucks - Page 2 - Xtratime Community
 37Likes
Reply
 
LinkBack Thread Tools Display Modes
post #21 of 231 (permalink) Old February 20th, 2014, 19:59
TTM
Forum Manager
Legend
 
TTM's Avatar
 
Join Date: 11 2011
Posts: 12,186
Ok, I'm not an IT guy, but, server upgrade maybe?

Ding ding ding da ding da ding ding ding
TTM is offline  
Sponsored Links
Advertisement
 
post #22 of 231 (permalink) Old February 20th, 2014, 20:26
Administrators
Legend
 
Reza's Avatar
 
Join Date: 08 2001
Location: Canada
Teams: Milan
Posts: 10,725
Those limits can be increased with one line (added to my.cnf) but the processor and server as a whole are important factors obviously
Reza is offline  
post #23 of 231 (permalink) Old February 20th, 2014, 21:02 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
When you get meaningful error messages, i.e., something is exceeded etc, it's more likely configuration.

Something like a 'cannot reach host', then the server is a piece of shit.
Zico 10 is offline  
 
post #24 of 231 (permalink) Old February 21st, 2014, 00:04
First Place winner, June 2010 Photo Contest
Xtratime Legend
 
Boyo's Avatar
 
Join Date: 05 2000
Posts: 36,660
Blog Entries: 7
Someone should apply for a job with VS and then say their name is DROP TABLE employees;

Woke AF!
Boyo is offline  
post #25 of 231 (permalink) Old February 21st, 2014, 01:10
Administrators
Xtratime Legend
 
JCamilo's Avatar
 
Join Date: 08 2002
Location: Brasil
Teams: Atletico-MG
Posts: 28,567
They are in Canada. They all drop tables.

Kat: "JCam, you may quote me now, but you are quite wise".

Kat: "JCam knows, we do not doubt in him".
JCamilo is offline  
post #26 of 231 (permalink) Old February 21st, 2014, 08:49
Forum Manager
Xtratime Legend
 
ToniSamp's Avatar
 
Join Date: 01 2002
Teams: Sampdoria, Italian NT
Posts: 44,686
They have vertigo and clarity.
ToniSamp is offline  
post #27 of 231 (permalink) Old February 22nd, 2014, 00:31 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
Just an example of what we deal with, folks ...

Quote:
Originally Posted by Zico 10
Quote:
Originally Posted by admin View Post
Thanks for the examples guys. When you report the issues can you please report them like this

Time (include time zone)
Thread URL
What type of error


Thanks

~ Danniella, Community Support
Are you trolling?

Please take a look at the reports a little closer. Here, I'll break it down for you;

Quote:
Originally Posted by Wally View Post
Database error in vBulletin 3.6.12:

Invalid SQL:

REPLACE INTO search (userid, showposts, ipaddress, personal, forumchoice, sortby, sortorder, searchtime, orderedids, announceids, dateline, displayterms, searchhash, completed)


MySQL Error : Duplicate entry '17905985' for key 'PRIMARY' (the type of error)
Error Number : 1062 (the type of error)
Date : Thursday, February 20th 2014 @ 05:14:50 PM (time reported in local server time)
Script : https://www.xtratime.org/forum/search.php?do=getnew
Referrer : https://www.xtratime.org/forum/search...rchid=17905937 (the URL that was being accessed)
IP Address :
Username : Wally
Classname : vB_Database_MySQLi
There you go, all the information you need is already being reported.
Zico 10 is offline  
post #28 of 231 (permalink) Old February 22nd, 2014, 00:40
Administrators
Legend
 
Reza's Avatar
 
Join Date: 08 2001
Location: Canada
Teams: Milan
Posts: 10,725
Reza is offline  
post #29 of 231 (permalink) Old February 22nd, 2014, 00:47
Lord of the Basement
Legend
 
Mrkela's Avatar
 
Join Date: 08 2008
Location: Basement
Teams: FC Basement
Posts: 15,331
Zico our fearless dictator does not back down with his foreign policy
Mrkela is offline  
post #30 of 231 (permalink) Old February 22nd, 2014, 01:40
TTM
Forum Manager
Legend
 
TTM's Avatar
 
Join Date: 11 2011
Posts: 12,186
What we really want to know is if Daniella is hawt or not.





Ding ding ding da ding da ding ding ding
TTM is offline  
post #31 of 231 (permalink) Old February 22nd, 2014, 13:36
Forum Manager
Legend
 
Friki's Avatar
 
Join Date: 11 2006
Teams: Team Samaras
Posts: 16,538
Database error in vBulletin :

mysqli_real_connect(): (08004/1040): Too many connections
/usr/sites/xtratime.org/www/htdocs/forum/includes/class_core.php on line 1040

MySQL Error :
Error Number :
Date : Saturday, February 22nd 2014 @ 08:34:30 AM
Script : https://www.xtratime.org/forum/showthread.php?t=328265
Referrer : https://www.xtratime.org/forum/index.php
Username :
Classname : vB_Database_MySQLi

Traitors of forum #73
EclipsE
King Kenny7
Famigerato19
Crazy4TheCrew (Loco4LosChe)
Friki is offline  
post #32 of 231 (permalink) Old February 22nd, 2014, 13:40
Administrators
Xtratime Legend
 
Firdaus's Avatar
 
Join Date: 10 1999
Teams: Inter, Memphis Tigers
Posts: 42,327
Crapperoni.

Quote:
Database error in vBulletin :

mysqli_real_connect(): (HY000/1040): Too many connections
/usr/sites/xtratime.org/www/htdocs/forum/includes/class_core.php on line 1040

MySQL Error :
Error Number :
Date : Saturday, February 22nd 2014 @ 08:37:33 AM
Script : https://www.xtratime.org/forum/showth...1&posted=1
Referrer : https://www.xtratime.org/forum/newrep...amp;p=13878089
IP Address :
Username :
Classname : vB_Database_MySQLi

Quote:
Originally Posted by Bob W The Bat View Post
These last years after the CL win I noticed when following the Inter online community that many fans have turned into cvcksuckers.
R.I.P: Tazzy, Flo.
Firdaus is offline  
post #33 of 231 (permalink) Old February 23rd, 2014, 03:40 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
Database error in vBulletin 3.6.12:

Invalid SQL:

REPLACE INTO search (userid, showposts, ipaddress, personal, forumchoice, sortby, sortorder, searchtime, orderedids, announceids, dateline, displayterms, searchhash, completed)
VALUES (2927, 0, '', 1, '', 'lastpost', 'DESC', 2.24320, '321297,300289,311329,298353,328369,327609,328337, 328161,256835,165266,265387,149309,328353,278321,2 41615,260669,328273,290530,325601,256108,328209', '321', 1393126792, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{} s:6:\"common\";a:0:{}s:5:\"users\";a:0:{}s:6:\"for ums\";N;s:7:\"options\";a:3:{s:11:\"starteronly\"; b:0;s:11:\"childforums\";b:1;s:6:\"action\";s:6:\" getnew\";}}', 'c6e5c5977a4f1e13f781fa2cea6bb604', 1);

MySQL Error : Duplicate entry '17942561' for key 'PRIMARY'
Error Number : 1062
Date : Saturday, February 22nd 2014 @ 10:39:54 PM
Script : https://www.xtratime.org/forum/search.php?do=getnew
Referrer : https://www.xtratime.org/forum/misc.php?do=cchatbox
IP Address :
Username : Zico 10
Classname : vB_Database_MySQLi
Zico 10 is offline  
post #34 of 231 (permalink) Old February 23rd, 2014, 03:45 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
Database error in vBulletin 3.6.12:

Invalid SQL:

REPLACE INTO search (userid, showposts, ipaddress, personal, forumchoice, sortby, sortorder, searchtime, orderedids, announceids, dateline, displayterms, searchhash, completed)
VALUES (2927, 0, '[IP Address]', 1, '', 'lastpost', 'DESC', 0.04087, '327553,298353,321297,300289,311329,328369,327609, 328337,328161,256835,165266,265387,149309,328353,2 78321,241615,260669,328273,290530,325601,256108,32 8209', '321', 1393127038, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{} s:6:\"common\";a:0:{}s:5:\"users\";a:0:{}s:6:\"for ums\";N;s:7:\"options\";a:3:{s:11:\"starteronly\"; b:0;s:11:\"childforums\";b:1;s:6:\"action\";s:6:\" getnew\";}}', 'c6e5c5977a4f1e13f781fa2cea6bb604', 1);

MySQL Error : Duplicate entry '17942593' for key 'PRIMARY'
Error Number : 1062
Date : Saturday, February 22nd 2014 @ 10:43:58 PM
Script : https://www.xtratime.org/forum/search.php?do=getnew
Referrer : https://www.xtratime.org/forum/showthread.php?t=328057
IP Address :
Username : Zico 10
Classname : vB_Database_MySQLi
Zico 10 is offline  
post #35 of 231 (permalink) Old February 23rd, 2014, 04:07
Administrators
Legend
 
Reza's Avatar
 
Join Date: 08 2001
Location: Canada
Teams: Milan
Posts: 10,725
This last one might be fixable from within the vBulletin Admin CP, maintenance/repair section.
(Standard disclaimers apply )
Reza is offline  
post #36 of 231 (permalink) Old February 23rd, 2014, 04:12 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
Only VS has full access to the AdminCP.
Zico 10 is offline  
post #37 of 231 (permalink) Old February 23rd, 2014, 04:23
Administrators
Legend
 
Reza's Avatar
 
Join Date: 08 2001
Location: Canada
Teams: Milan
Posts: 10,725
So restricted ... seriously though, the reasons for the errors are now pretty clear. Isn't the Search function offloaded to an external service? If the connections are still too many without search then that's not a good sign for the server as a whole.
Reza is offline  
post #38 of 231 (permalink) Old February 23rd, 2014, 10:27 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
I flicked the URLs of this and another related thread to the engineers at VS, and one of them got back to me to say that things "should be good now".

So, community of XT, I plead with you to report any errors you encounter as we must be sure.
Zico 10 is offline  
post #39 of 231 (permalink) Old February 23rd, 2014, 16:58
Forum Manager
Xtratime Legend
 
dabdob's Avatar
 
Join Date: 08 2004
Location: Jerusalem
Teams: AC Milan, Netherlands
Posts: 23,799
Whoever was the previous owner of XT, may you choke on VS money

My weekly rant!

27th May 1965: Over 16,000 days.

"For a moment there I returned to my youth, the early youth, when all nice illusions were gathered together. Then life came and, like a strong wind, blew them away, one by one. What we call happiness is sometimes the accordance between our life and circumstances, our biography and history, our personal aspirations and historical currents. If I look at things that way, I can say: I was born too early to be happy. But birth is one of the many things we do not get to choose. It is part of our destiny."
Alija Izetbegovic


"وما الحيله فقد اراد اعدائي ان يغطوا كل خدماتي بغطاء اسود وقد نجحوا في ذلك."

عبد الحميد الثاني
dabdob is offline  
post #40 of 231 (permalink) Old February 23rd, 2014, 17:59
TTM
Forum Manager
Legend
 
TTM's Avatar
 
Join Date: 11 2011
Posts: 12,186
I would like Danniella to post in the thread please.

Ding ding ding da ding da ding ding ding
TTM is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Xtratime Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive. Try to avoid choosing short (like '1'), simple (like 'abcd') and easy to guess passwords (like a name of your favorite team, player, etc)! Complex and long enough passwords, that consists of random string of alphabet and numerical characters, are almost impossible to be stolen and misused.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in











Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may 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
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome