Author Topic: Database error  (Read 4250 times)

0 Members and 1 Guest are viewing this topic.

Offline Fr. George

  • formerly "Cleveland"
  • Administrator
  • Stratopedarches
  • *******
  • Posts: 20,221
  • May the Lord bless you and keep you always!
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Orthodox Metropolis of Pittsburgh
Database error
« on: October 07, 2008, 04:39:54 PM »
Frequently I'm getting "database errors" when I attempt to post.  I'll copy and paste it here the next time I see it.  Says something about needing an upgrade on the forum software...
"O Cross of Christ, all-holy, thrice-blessed, and life-giving, instrument of the mystical rites of Zion, the holy Altar for the service of our Great Archpriest, the blessing - the weapon - the strength of priests, our pride, our consolation, the light in our hearts, our mind, and our steps"
Met. Meletios of Nikopolis & Preveza, from his ordination.

Offline Anastasios

  • Webdespota
  • Administrator
  • Merarches
  • *******
  • Posts: 10,497
  • Metropolitan Chrysostomos of Florina
    • AnastasiosHudson.com
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Old Calendarist
Re: Database error
« Reply #1 on: October 07, 2008, 04:59:43 PM »
Thanks. I know what error you are talking about. It's part of the same issue that causes the occasional outage we think.
« Last Edit: October 07, 2008, 04:59:55 PM by Fr. Anastasios »
Please Buy My Book!

Past posts reflect stages of my life before my baptism and may not be accurate expositions of Orthodox teaching. Also, I served as an Orthodox priest from 2008-2013, before resigning.

Offline Fr. George

  • formerly "Cleveland"
  • Administrator
  • Stratopedarches
  • *******
  • Posts: 20,221
  • May the Lord bless you and keep you always!
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Orthodox Metropolis of Pittsburgh
Re: Database error
« Reply #2 on: October 08, 2008, 05:13:12 PM »
Quote from: Stupid Error Box
Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY mem.lngfile
LIMIT 0' at line 8
File: /var/www/html/forum/Sources/Subs-Post.php
Line: 774

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.6, while your database is at version 1.1.5. The above error might possibly go away if you execute the latest version of upgrade.php.
"O Cross of Christ, all-holy, thrice-blessed, and life-giving, instrument of the mystical rites of Zion, the holy Altar for the service of our Great Archpriest, the blessing - the weapon - the strength of priests, our pride, our consolation, the light in our hearts, our mind, and our steps"
Met. Meletios of Nikopolis & Preveza, from his ordination.

Offline SolEX01

  • Toumarches
  • ************
  • Posts: 12,303
    • Greek Orthodox Archdiocese of America
  • Faith: Orthodox
  • Jurisdiction: Metropolis of New Jersey
Re: Database error
« Reply #3 on: October 08, 2008, 06:23:24 PM »
At 256,000 posts, this board is approaching the "Big Board" status as evident by the "Big Board" Newsgroup (for those with over 500,000 posts) although access is by invitation only.

One suggestion would be to upgrade everything to 2.0b4?  I always used beta software in my past lives ... ... ...  ;)


Offline Anastasios

  • Webdespota
  • Administrator
  • Merarches
  • *******
  • Posts: 10,497
  • Metropolitan Chrysostomos of Florina
    • AnastasiosHudson.com
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Old Calendarist
Re: Database error
« Reply #4 on: October 08, 2008, 08:12:23 PM »
At 256,000 posts, this board is approaching the "Big Board" status as evident by the "Big Board" Newsgroup (for those with over 500,000 posts) although access is by invitation only.

One suggestion would be to upgrade everything to 2.0b4?  I always used beta software in my past lives ... ... ...  ;)



The last time we tried to upgrade it had disastrous results. We need to find the problem, not just try to upgrade.
Please Buy My Book!

Past posts reflect stages of my life before my baptism and may not be accurate expositions of Orthodox teaching. Also, I served as an Orthodox priest from 2008-2013, before resigning.

Offline Fr. George

  • formerly "Cleveland"
  • Administrator
  • Stratopedarches
  • *******
  • Posts: 20,221
  • May the Lord bless you and keep you always!
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Orthodox Metropolis of Pittsburgh
Re: Database error
« Reply #5 on: October 08, 2008, 09:43:08 PM »
At 256,000 posts, this board is approaching the "Big Board" status as evident by the "Big Board" Newsgroup (for those with over 500,000 posts) although access is by invitation only.

One suggestion would be to upgrade everything to 2.0b4?  I always used beta software in my past lives ... ... ...  ;)

The last time we tried to upgrade it had disastrous results. We need to find the problem, not just try to upgrade.

Our board is Orthodox - afraid of new technology ;)
"O Cross of Christ, all-holy, thrice-blessed, and life-giving, instrument of the mystical rites of Zion, the holy Altar for the service of our Great Archpriest, the blessing - the weapon - the strength of priests, our pride, our consolation, the light in our hearts, our mind, and our steps"
Met. Meletios of Nikopolis & Preveza, from his ordination.

Offline SolEX01

  • Toumarches
  • ************
  • Posts: 12,303
    • Greek Orthodox Archdiocese of America
  • Faith: Orthodox
  • Jurisdiction: Metropolis of New Jersey
Re: Database error
« Reply #6 on: October 08, 2008, 10:52:05 PM »
If it's OK to ask - upgrading the database to version 1.1.6 is a major issue?

Could the server(s) hosting this forum be underpowered in terms of disk/network/memory access resulting in "lapses?"

Offline Anastasios

  • Webdespota
  • Administrator
  • Merarches
  • *******
  • Posts: 10,497
  • Metropolitan Chrysostomos of Florina
    • AnastasiosHudson.com
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Old Calendarist
Re: Database error
« Reply #7 on: October 08, 2008, 11:00:00 PM »
If it's OK to ask - upgrading the database to version 1.1.6 is a major issue?

Yes. Not because it's difficult. But because of who we are dealing with.

Quote
Could the server(s) hosting this forum be underpowered in terms of disk/network/memory access resulting in "lapses?"

It wouldn't surprise me. But the company denies it.

We need to check the error logs and see if there is a problem that can be corrected before trying to upgrade anything. Just because it says the database files are at 1.1.5 does not mean they actually are (learned that one an upgrade or two ago...)
« Last Edit: October 08, 2008, 11:02:48 PM by Fr. Anastasios »
Please Buy My Book!

Past posts reflect stages of my life before my baptism and may not be accurate expositions of Orthodox teaching. Also, I served as an Orthodox priest from 2008-2013, before resigning.

Offline SolEX01

  • Toumarches
  • ************
  • Posts: 12,303
    • Greek Orthodox Archdiocese of America
  • Faith: Orthodox
  • Jurisdiction: Metropolis of New Jersey
Re: Database error
« Reply #8 on: October 08, 2008, 11:22:53 PM »
Yes. Not because it's difficult. But because of who we are dealing with.

I imagined that the OC.net server was in some server farm facility where someone can walk in and "tweak" with the server as necessary.  Remote access, via SSH, would be second best, if available.

It wouldn't surprise me. But the company denies it.

Good questions to ask the Server provider:
Recommended Requirements:

However, for best performance and use, a bit more is suggested. This includes the following:
Linux or another Unix based operating system.
The GNU Aspell and its dictionaries for spell checking support.
Apache with AcceptPathInfo set to On (Apache 2 and later only) for queryless URL support.
PHP 4.3.0 or higher, with the following set in php.ini:
     the max_input_time directive is set to a value of at least 30.
     the post_max_size and upload_max_filesize directives are set to the size of the largest attachments you wish to be able to upload.
     the session.use_trans_sid directive set to Off.
     the memory_limit directive is set to at least 8M.
     the max_execution_time directive is set to at least 15.
     the register_globals directive is set to Off.
MySQL 4.0.15 or higher with query caching enabled.
GD Graphics Library 2.0 or higher.


We need to check the error logs and see if there is a problem that can be corrected before trying to upgrade anything. Just because it says the database files are at 1.1.5 does not mean they actually are (learned that one an upgrade or two ago...)

If the host admins don't know, only remote access can answer that question.   :)

Offline Anastasios

  • Webdespota
  • Administrator
  • Merarches
  • *******
  • Posts: 10,497
  • Metropolitan Chrysostomos of Florina
    • AnastasiosHudson.com
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Old Calendarist
Re: Database error
« Reply #9 on: October 08, 2008, 11:37:32 PM »
We have SSH access and are on a VPS.  I had the host company reprovision the server and then I reinstalled MYSQL and reimported the DB the last time we had any problem.  Like I said, we are going to need to check the logs the next time the error happens to see if there is any indication of what is going on.
Please Buy My Book!

Past posts reflect stages of my life before my baptism and may not be accurate expositions of Orthodox teaching. Also, I served as an Orthodox priest from 2008-2013, before resigning.

Offline SolEX01

  • Toumarches
  • ************
  • Posts: 12,303
    • Greek Orthodox Archdiocese of America
  • Faith: Orthodox
  • Jurisdiction: Metropolis of New Jersey
Re: Database error
« Reply #10 on: October 08, 2008, 11:45:45 PM »
We have SSH access and are on a VPS.

I'm sure you meant VPN? 

I had the host company reprovision the server and then I reinstalled MYSQL and reimported the DB the last time we had any problem.  Like I said, we are going to need to check the logs the next time the error happens to see if there is any indication of what is going on.

So, the log files go as far back to the last issue in early September?

Maybe the smileys are breaking the upgrade, according to the link attached in-line:

Offline Anastasios

  • Webdespota
  • Administrator
  • Merarches
  • *******
  • Posts: 10,497
  • Metropolitan Chrysostomos of Florina
    • AnastasiosHudson.com
  • Faith: Orthodox Christian
  • Jurisdiction: Greek Old Calendarist
Re: Database error
« Reply #11 on: October 08, 2008, 11:56:43 PM »
I'm sure you meant VPN? 

No, I meant VPS:
http://en.wikipedia.org/wiki/Virtual_private_server



Quote
So, the log files go as far back to the last issue in early September?

The mysqld log seems to go back to then. The httpd log only dates from today. Cleveland has seen the error he posted above, but we also have experienced errors which cause the httpd process to abruptly stop and it has to be restarted. Are the two things related? Maybe. Too early to say.

Quote
Maybe the smileys are breaking the upgrade, according to the link attached in-line:


Thank you for the reference and I will have a look.
Please Buy My Book!

Past posts reflect stages of my life before my baptism and may not be accurate expositions of Orthodox teaching. Also, I served as an Orthodox priest from 2008-2013, before resigning.

Offline SolEX01

  • Toumarches
  • ************
  • Posts: 12,303
    • Greek Orthodox Archdiocese of America
  • Faith: Orthodox
  • Jurisdiction: Metropolis of New Jersey
Re: Database error
« Reply #12 on: October 09, 2008, 12:13:21 AM »
No, I meant VPS:
http://en.wikipedia.org/wiki/Virtual_private_server

Forgive me, Father A., for I hadn't seen a VPS until today.  I'm familiar with emulators and virtual Operating Systems, but not Virtual Servers.  Clearly, a VPS doesn't give this application full access to CPU, RAM and Disk as it lives basically in a chunk of disk space somewhere on a bigger server.  If the database starts approaching the disk limits, it will act funny and crash; That's been my experience in the past with tape backup databases when they grow large and crash without warning in a middle of  backup job.   ::)

The mysqld log seems to go back to then. The httpd log only dates from today.

That's odd - the VPS probably restarts the httpd daemon every day, clearing the log files to conserve on disk space unless the log files are moved elsewhere?   ???

Cleveland has seen the error he posted above, but we also have experienced errors which cause the httpd process to abruptly stop and it has to be restarted. Are the two things related? Maybe. Too early to say.

httpd hangs.  I've never seen httpd restarted daily on a LINUX server.  Most LINUX servers I dealt with stayed up for months.

Thank you for the reference and I will have a look.

You're welcome.  The link helped many people resolve upgrade problems due to changing one word in a SQL script file.   :)

Offline SolEX01

  • Toumarches
  • ************
  • Posts: 12,303
    • Greek Orthodox Archdiocese of America
  • Faith: Orthodox
  • Jurisdiction: Metropolis of New Jersey
Re: Database error
« Reply #13 on: October 24, 2008, 12:14:47 AM »
A few minutes ago, I received another database error and I noticed that there was a simultaneous post at 12:10:42 AM along with my post.  My post went through, so did the other poster's.  In computer speak, the behavior is called a race condition where two processes compete simultaneously for disk, memory and other resources.