Can no longer load blog

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
donniev

Can no longer load blog

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Can no longer load blog

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

more info

Post 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
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

phpmyadmin output

Post 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:
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: phpmyadmin output

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

session_start

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: session_start

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

check tables

Post 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
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

disk space seems ok

Post 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.
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

Working but very very slowly

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Working but very very slowly

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

Cookie setting issue maybe?

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Cookie setting issue maybe?

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

phpmyadmin was a red herring

Post by donniev »

I had corrupt cookies. phpmyadmin is working fine. Horrendous load times for blog however.
donniev
Regular
Posts: 11
Joined: Mon Apr 11, 2005 6:36 pm

export/reimport db no help

Post by donniev »

I exported the database, dropped all the tables and reimported them. made absolutely no difference.
Post Reply