Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
SP 5.3.3 upgrade is killing my server
Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 2, 2013 - 3:15 pm

I just logged in mysql command line tool using the same db account that is configured on WP and ran:

mysql> SHOW TABLES LIKE 'wp_sferrorlog';
+---------------------------------------+
| Tables_in_xxxxxxx (wp_sferrorlog) |
+---------------------------------------+
| wp_sferrorlog |
+---------------------------------------+
1 row in set (0.00 sec)

It seems the problem is somewhere else confused

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 2, 2013 - 4:30 pm

just need to know the error that started it...  as mentioned, should be in the php error log... ;)

did you try uncommenting those two lines?  curious to see if it was just an upgrade issue...

Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 3, 2013 - 4:54 am

I just tried removing the comments on the 2 lines, my forum gets locked in the next second.

I'm adding again the comments and leave it like this for the moment, will later try to get more details about a php error when there is less traffic on my forum.

Cheers.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 3, 2013 - 9:33 am

okay, thanks for the test. still a unique issue so would love to know what is causing the initial error to get the log spinning away - as I am sure you would too...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 3, 2013 - 10:27 am

well, good news and bad news...  good news, another user is having what appears to be same user... so two now (out of thousands of upgrades) but means its non unique... bad news, we still have no idea what's going on...

So at this point, to troubleshoot further, we really need to be able to debug on the actual server where its occurring...  if this is a live server, that may not be possible without some disruption (have to turn error logging back on)...  is that possible here?  or do you have a staging server with the same issue?

Avatar
sptab
Member
sp_UserOfflineSmall Offline
Oct 3, 2013 - 11:47 am

Well that's good news for me, sort of confused I really feel less alone with that issue.

I've already brought you some pointers on the problem, that should help you to backtrack the cause checking the changed source code between current SP update and previous version.

I currently don't have a staging server, but a few members not happy about my forum being inaccessible half a day yesterday so I'll give some time to check again on the issue, I just can't take my forum down too often.

Cheers.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 3, 2013 - 11:49 am

understand...  the other user has provided credentials so will be able to debug over there...  unfortunately, none of the provided info has been useful in understanding the problem....  just need to get access to the problem and chase it down which we should be able to do now...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 3, 2013 - 7:38 pm

just an update, but the other user's issue is solved... he disabled the error logging to get site back... but re-enabling the error logging worked just fine with no repeat of errors...  we tried that on yours but the errors came back...  so we are still back at square zero as we have no real leads as to the initial problem...

of course, still investigating...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625