Page 1 of 2
Can no longer load blog
Posted: Mon Apr 11, 2005 6:31 pm
by donniev
As of this morning blog will not load. There is nothing in the log files indicating a problem.
Another instance of serendipity on the same server loads fine so it doesnt appear to be a mysql, apache, or php issue.
I have no idea where to go next.
Re: Can no longer load blog
Posted: Mon Apr 11, 2005 6:44 pm
by garvinhicking
And we don't have an idea if we can't look at it. So tell us the URL to your blog
Did you check via phpMyAdmin if your database is still in place? IF your serendipity_config_local.inc.php is still in place? If your .htaccess is still in place?
What has changed on your server since it worked the last time?
Regards,
Garvin
more info
Posted: Mon Apr 11, 2005 7:13 pm
by donniev
http://blog.vawter.com is the url but since it wont load I am not sure what help that is.
The blog was working when I went to bed last night but looks like it stopped working about 6 this morning (I have a curl script monitor it and thats when it started failing)
sudo cat serendipity_config_local.inc.php
<?php
/*
Serendipity configuration file
Written on Tue, 8 Mar 2005 13:16:54 -0700
*/
$serendipity['versionInstalled'] = '0.7.1';
$serendipity['dbName'] = 'serend';
$serendipity['dbPrefix'] = 'ser_';
$serendipity['dbHost'] = 'localhost';
$serendipity['dbUser'] = 'xxxxx';
$serendipity['dbPass'] = 'xxxxxx';
$serendipity['dbType'] = 'mysql';
?>
phpmyadmin shows 12 tables and all entries. The latest entry (yesterday) is there.
$ cat .htaccess
# BEGIN s9y
ErrorDocument 404 /index.php
DirectoryIndex /index.php
php_value session.use_trans_sid 0
php_value register_globals off
RewriteEngine On
RewriteBase /
RewriteRule ^static/(.*) index.php?serendipity[subpage]=$1
<Files *.tpl>
deny from all
</Files>
<Files *.sql>
deny from all
</Files>
<Files *.inc.php>
deny from all
</Files>
<Files *.db>
deny from all
</Files>
# END s9y
phpmyadmin output
Posted: Mon Apr 11, 2005 7:15 pm
by donniev
Table Action RecordsMay be approximate. See FAQ 3.11 Type Collation Size Overhead
ser_authors Browse Search Insert Structure Empty Drop 1 MyISAM latin1_swedish_ci 2.1 KB -
ser_category Browse Search Insert Structure Empty Drop 10 MyISAM latin1_swedish_ci 2.6 KB -
ser_comments Browse Search Insert Structure Empty Drop 3 MyISAM latin1_swedish_ci 4.0 KB -
ser_config Browse Search Insert Structure Empty Drop 68 MyISAM latin1_swedish_ci 28.5 KB 556 Bytes
ser_entries Browse Search Insert Structure Empty Drop 33 MyISAM latin1_swedish_ci 26.9 KB -
ser_entrycat Browse Search Insert Structure Empty Drop 33 MyISAM latin1_swedish_ci 2.3 KB -
ser_exits Browse Search Insert Structure Empty Drop 33 MyISAM latin1_swedish_ci 4.1 KB -
ser_images Browse Search Insert Structure Empty Drop 55 MyISAM latin1_swedish_ci 7.4 KB -
ser_plugins Browse Search Insert Structure Empty Drop 19 MyISAM latin1_swedish_ci 5.5 KB -
ser_references Browse Search Insert Structure Empty Drop 10 MyISAM latin1_swedish_ci 2.9 KB -
ser_referrers Browse Search Insert Structure Empty Drop 33 MyISAM latin1_swedish_ci 5.4 KB -
ser_suppress Browse Search Insert Structure Empty Drop 31 MyISAM latin1_swedish_ci 20.9 KB 10,828 Bytes
12 table(s) Sum 329 -- latin1_swedish_ci 112.7 KB 11.1 KB
With selected:
Re: phpmyadmin output
Posted: Mon Apr 11, 2005 7:40 pm
by garvinhicking
Strange, this seems to be a timeout or Webserver issue.
Make sure your php has display_errors set to On and that you check your apache ErrorLog.
Also do a "Check Tables" using phpMyAdmin on all your s9y tables.
It seems to me that this is not a Serendipity issue, but more a crashed webserver or some missing PHP thread or something like that.
Regards,
Garvin
session_start
Posted: Mon Apr 11, 2005 7:49 pm
by donniev
i have copied index.php to index2.php and added a print statement and exit b4 the call to session start. prints as expected. moving the print and exit statement after the call to session_start causes the page to hang. My ASSumption is that something in session start is hanging.
If I comment the call to session start the scripts gets through login but hangs after that.
Re: session_start
Posted: Mon Apr 11, 2005 8:00 pm
by garvinhicking
This looks to me as if your Harddisk space is used up and the sesion data cannot be written.
Check your /tmp usage and permissions and HD disk space.
Regards,
Garvin
check tables
Posted: Mon Apr 11, 2005 8:12 pm
by donniev
tables ok and another instance of serendipity works fine.
Table Op Msg_type Msg_text
serend.ser_authors check status OK
serend.ser_category check status OK
serend.ser_comments check status OK
serend.ser_config check status OK
serend.ser_entries check status OK
serend.ser_entrycat check status OK
serend.ser_exits check status OK
serend.ser_images check status OK
serend.ser_plugins check status OK
serend.ser_references check status OK
serend.ser_referrers check status OK
serend.ser_suppress check status OK
disk space seems ok
Posted: Mon Apr 11, 2005 8:17 pm
by donniev
$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/ubda 2.0G 1.5G 503M 75% /
tmpfs 61M 0 61M 0% /dev/shm
/dev/ubdc 2.3G 1.4G 905M 60% /home
If that were the issue, why would the other instance of serendipity not also fail.
Working but very very slowly
Posted: Mon Apr 11, 2005 11:53 pm
by donniev
On this instance page loads are in minutes not seconds. On the other blog on the same machine (hence same apache, php , mysql configuration) everything works instantaneously. I am at a loss as to what the cause is.
Re: Working but very very slowly
Posted: Tue Apr 12, 2005 10:13 am
by garvinhicking
That sounds weird. Have you made sure that the misbheaving blog has unmodified, original Serendipity .php files?
If that'S the case, maybe some plugin you installed is causing trouble. Could you check your serendipity_plugins table and post which entries are contained there? So I can tell you if/which plugins you could (temporarily) remove.
I still don't see why the session_start() causes the trouble for you. Never ever seen that anywhere... :-/
Regards,
Garvin
Cookie setting issue maybe?
Posted: Tue Apr 12, 2005 4:11 pm
by donniev
I think this problem is wider than S9y. Now my phpMyAdmin won't leave the login screen. I think something is foobar in the fs and cookies cannot be written. If nothing worked I would be less confused, but another instance of S9y works fine. I have diffed the two apps and the only differences are to be expected (some media uploads in one app but not the other)
Since the pages eventually load it seems to me that php is waithing for something to timeout.
I am really at a loss at this point. I have verified that php.ini and apache2.conf and htaccess from phpmyadmin are unchanged.
I guess this really isn't your issue but I sure would welcome any ideas you have. I didnt post plugins because it is hanging way before it gets there so I doubt disabling them will help.
Re: Cookie setting issue maybe?
Posted: Tue Apr 12, 2005 4:31 pm
by garvinhicking
Hm, okay - I think you're on the right track about being suspicious about the server.
Did you run the usual - fsck, maybe reboot the server, check syslog, ...?
Regards,
Garvin
phpmyadmin was a red herring
Posted: Tue Apr 12, 2005 6:43 pm
by donniev
I had corrupt cookies. phpmyadmin is working fine. Horrendous load times for blog however.
export/reimport db no help
Posted: Tue Apr 12, 2005 7:34 pm
by donniev
I exported the database, dropped all the tables and reimported them. made absolutely no difference.