View previous topic :: View next topic |
Author |
Topic : "problem connecting to sijun" |
matter member
Member # Joined: 10 Aug 2004 Posts: 82 Location: ny
|
Posted: Sat Aug 21, 2004 1:17 pm |
|
 |
Quote: |
Warning: mysql_connect(): Too many connections in /home/sijun/public_html/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/sijun/public_html/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/sijun/public_html/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database |
anybody else getting this page? looks like there's only 12 people on the site, and i've only been seeing it lately.. iunno.
-matt |
|
Back to top |
|
Matthew member
Member # Joined: 05 Oct 2002 Posts: 3784 Location: I am out of here for good
|
Posted: Sat Aug 21, 2004 2:36 pm |
|
 |
yea me too, maybe they have cut down the bandwidth or something.
I saw a message too when they were switching servers to gfxartist.com aswell, saying something that the gfxartist team are making the switch.
I wish they would inform us more here and letting us know what kind of changes they are making and when.
later |
|
Back to top |
|
Chruser member
Member # Joined: 06 Dec 2003 Posts: 206 Location: Sweden
|
Posted: Sat Aug 21, 2004 4:37 pm |
|
 |
Strange. Mysql_connect() doesn't usually suffer from too many connections, unless there would be a DDoS attempt or something. The connections are dropped as soon as the page loads. There's another similar function, mysql_pconnect() (persistant connection), which, just as the name implies, keeps the connections active after the page loads, so the user won't have to log into the DB every time he wants to browse into a new page.
The good thing about this is clearly that the boards will load faster for that user, but the downside is that too many connections can simultaneously be made, causing problems that look a lot like this one. _________________ What doesn't kill you makes you stronger.
Free image hosting: http://www.picaroni.com |
|
Back to top |
|
Sumaleth Administrator
Member # Joined: 30 Oct 1999 Posts: 2898 Location: Australia
|
Posted: Sat Aug 21, 2004 5:04 pm |
|
 |
I'm guessing that there's a limit on how many people can connect to the database at any one time, and we've started to tip over that limit lately.
About the gfxartist thing -- Sijun forums and the gfxartist site has been hosted on the same server for the last year or so, and I'm guessing they wanted to move everything to a new server but couldn't contact Dhabih or something. Kinda interesting that they had access though. _________________ Art Links Archive -- Artists and Tutorials |
|
Back to top |
|
ceenda member
Member # Joined: 27 Jun 2000 Posts: 2030
|
Posted: Wed Aug 25, 2004 7:42 am |
|
 |
This is happenening almost constantly now. |
|
Back to top |
|
watmough member
Member # Joined: 22 Sep 2003 Posts: 779 Location: Rockland, ME
|
Posted: Wed Aug 25, 2004 8:01 am |
|
 |
yup me too |
|
Back to top |
|
Matthew member
Member # Joined: 05 Oct 2002 Posts: 3784 Location: I am out of here for good
|
Posted: Wed Aug 25, 2004 8:25 am |
|
 |
Sumaleth, I know you are not admin nowadays but since all the other mods has abandoned I ask u, can it be the speedy causing problems? I know there was some error way back when the 1500 posts was exceeded, maybe we have reached the posting limit for Speed IV? or have they cut down bandwidth for Sijun?
Anyway it is getting really annoying when that screen pop-ups all the time.
For me it is not always that mysql problem though, seems to be some kind of id problem aswell with a lot of syntax stuff.
check it:
see you |
|
Back to top |
|
merlyns member
Member # Joined: 30 May 2002 Posts: 524 Location: the netherlands -_-
|
Posted: Wed Aug 25, 2004 8:53 am |
|
 |
Sadly this is coming to an point that its annoying. its very frequent _________________
 |
|
Back to top |
|
blehblehbleh junior member
Member # Joined: 10 Mar 2004 Posts: 40
|
Posted: Wed Aug 25, 2004 10:53 am |
|
 |
It doesn't happen when you use the Firefox browser. |
|
Back to top |
|
eyewoo member
Member # Joined: 23 Jun 2001 Posts: 2662 Location: Carbondale, CO
|
|
Back to top |
|
spyroteknik member
Member # Joined: 29 Apr 2003 Posts: 376 Location: north east uk
|
Posted: Wed Aug 25, 2004 11:18 am |
|
 |
happens to me with firefox, it's not browser specific
it's the debug mode for me too, hit refresh and the code changes |
|
Back to top |
|
Matthew member
Member # Joined: 05 Oct 2002 Posts: 3784 Location: I am out of here for good
|
Posted: Wed Aug 25, 2004 11:42 am |
|
 |
yes it is totally getting worse and it can't be due to the amount connected cause I was refreshing and saw 10 guests and all of a sudden this same message appeared again.
btw I heard lots of good stuff about mozilla so I downloaded it but as spyro says the same problem appeared there too. I like the firefox pop-up killer though, nice feature.
*back to batcave |
|
Back to top |
|
Bandados member
Member # Joined: 02 Aug 2004 Posts: 97 Location: Spain
|
Posted: Wed Aug 25, 2004 12:13 pm |
|
 |
it happens constantly with me, even while trying to post this message...
strange |
|
Back to top |
|
Matthew member
Member # Joined: 05 Oct 2002 Posts: 3784 Location: I am out of here for good
|
Posted: Wed Aug 25, 2004 12:46 pm |
|
 |
ok I have contacted the creationstorm guys, I hope I will get an answer.
If I get an answer I can post it in here, otherwise I will try to contact gfxartist.com crew aswell.
we will see what happens |
|
Back to top |
|
ceenda member
Member # Joined: 27 Jun 2000 Posts: 2030
|
Posted: Wed Aug 25, 2004 1:34 pm |
|
 |
Matthew: They are one and the same. The ring and the dark lord...  |
|
Back to top |
|
Matthew member
Member # Joined: 05 Oct 2002 Posts: 3784 Location: I am out of here for good
|
Posted: Thu Aug 26, 2004 7:53 am |
|
 |
yea hehe ceenda.
ok I got a reply back from the creative director Arno and he made some changes.
Seems to be working fine at the moment, let me know guys if it works for you too.
Also this guy seem to be in contact with Dhabib so Dhabib is still in the shadows. I asked about some future questions about the forum and future mod concerns. He said he was gonna chat with Dhabib about it and get back to me, so, hopefully we will get some clarity in these questions and then I can get back to you here.
keep it up everyone.  |
|
Back to top |
|
watmough member
Member # Joined: 22 Sep 2003 Posts: 779 Location: Rockland, ME
|
Posted: Thu Aug 26, 2004 8:10 am |
|
 |
still happening........... |
|
Back to top |
|
Matthew member
Member # Joined: 05 Oct 2002 Posts: 3784 Location: I am out of here for good
|
Posted: Thu Aug 26, 2004 10:01 am |
|
 |
yea I noticed. I contacted the same guy again so we will see what he says.
thanks for the quick reply watmough
Matthew |
|
Back to top |
|
CalicoRabbit junior member
Member # Joined: 04 Jul 2003 Posts: 21 Location: Depends
|
Posted: Thu Aug 26, 2004 1:08 pm |
|
 |
It's happening more and more often, it's quite irritating.
-CalicoRabbit |
|
Back to top |
|
Arno[bia] Administrator
Member # Joined: 07 Jun 2003 Posts: 7 Location: Amsterdam, Netherlands
|
Posted: Fri Aug 27, 2004 12:43 am |
|
 |
Arno from GFX/Cstorm/BIA here.
The recent server move was indeed unannounced as we had to move quickly.
To comment on Sumaleth's "Kinda interesting that they had access though". Yes we have full access as Sijun is hosted on our servers.
We do not intend to limit the sijun forums in any way. We were unaware of problems untill matthew contacted me. I've upped the maximum connections for Sijun and hope that the problems are solved now.
I'll monitor the forums a bit from now to see if the problem still occurs. If the problems continue feel free to drop me a line at [email protected]
cheers,
Arno Drost MA
Creative Director
Brothers in art
http://www.brothersinart.net/
Creationstorm
http://www.creationstorm.com/
GFXartist
http://www.gfxartist.com/
Last edited by Arno[bia] on Fri Aug 27, 2004 3:30 am; edited 1 time in total |
|
Back to top |
|
Sumaleth Administrator
Member # Joined: 30 Oct 1999 Posts: 2898 Location: Australia
|
Posted: Fri Aug 27, 2004 12:54 am |
|
 |
Oh, I didn't realize Creationstorm was your own hosting biz, thought you were just hosted there like we are.
Thanks for upping the limit. _________________ Art Links Archive -- Artists and Tutorials |
|
Back to top |
|
Bandados member
Member # Joined: 02 Aug 2004 Posts: 97 Location: Spain
|
Posted: Fri Aug 27, 2004 1:13 am |
|
 |
it seems to have fixed the poblem so far... |
|
Back to top |
|
Matthew member
Member # Joined: 05 Oct 2002 Posts: 3784 Location: I am out of here for good
|
Posted: Fri Aug 27, 2004 5:37 am |
|
 |
Arno, as I said in the mail I really appreciate for taking your time here and fix the problem, also for contributing to the discussion here.
The forum works like a charm now.
Many thanks again Arno
have a nice day
Matthew |
|
Back to top |
|
watmough member
Member # Joined: 22 Sep 2003 Posts: 779 Location: Rockland, ME
|
Posted: Fri Aug 27, 2004 6:56 am |
|
 |
thanks for taking the initiative and doing something about the problem,matthew......its appreciated. |
|
Back to top |
|
spyroteknik member
Member # Joined: 29 Apr 2003 Posts: 376 Location: north east uk
|
Posted: Mon Aug 30, 2004 1:03 pm |
|
 |
seems to have been going nuts again today, 4 occasions, 5 or 6 refreshes usually makes it bite, but, tonight, f5 key had one hell of a hammering before it let me in
Quote: |
phpBB : Critical Error
Error creating new session
DEBUG MODE
SQL Error : 1114 The table 'phpbb_sessions' is full
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('38c655d6f7c035aa08818adae70f1a3d', 9821, 1093899374, 1093899374, '5156b582', 0, 1)
Line : 152
File : /home/sijun/public_html/includes/sessions.php |
the first block of values change every refresh, it's starting to bug me now |
|
Back to top |
|
CalicoRabbit junior member
Member # Joined: 04 Jul 2003 Posts: 21 Location: Depends
|
Posted: Mon Aug 30, 2004 2:50 pm |
|
 |
Yeah, I'm getting that as well. Lost a post because of it. Happened about an hour ago. |
|
Back to top |
|
Arno[bia] Administrator
Member # Joined: 07 Jun 2003 Posts: 7 Location: Amsterdam, Netherlands
|
Posted: Mon Aug 30, 2004 2:55 pm |
|
 |
Ok. as the problems did not seem to be resolved, I had to dig some deeper. And it was actually quite simple.
The data type of the sessions table was set to HEAP, which filled up the memory from time to time.
Setting it to MyISAM should now have fixed the problem.
Sorry for the trouble.
cheers,
Arno Drost MA
Creative Director
Brothers in art
http://www.brothersinart.net/
Creationstorm
http://www.creationstorm.com/
GFXartist
http://www.gfxartist.com/ _________________ "Dip me in chocolate and throw me at the lesbians" |
|
Back to top |
|
|