willadamskeane

29 minutes ago, Jim M said:

I'm afraid, I am not quite sure what you mean, this is an official support request and I am an official Invision support technician (hi! 🙂 ). 

My colleague and I have pointed out errors which are pointing to a server-related error with your MySQL server. Unfortunately, we only provide support for our software and any underlying server resources are outside our scope of support. If you are continuing to receive these errors, you may wish to hire a server administrator to aid your investigation.

The problem I'm facing is that the application is reporting an error, which were it my own code I could fairly easily debug with inserted log statements or breakpoints. There are no errors being reported on the database server that would indicate a config issue, and MySQL errors can only be captured at the point of execution, usually in the application itself (in this case, IP.Board). Based on the errors being reported in the IP.Board system log, my best guess is that there is a database schema issue with a table, or a data integrity issue with one or more rows in a table, related to the CMS app (which I have a few custom databases setup in). I was just hoping that someone more familiar with that area of the code that the error is being reported in could point me the right direction.

On 9/15/2022 at 4:19 PM, Jim M said:

Unfortunately, that also points to a database connection error when the language cannot be loaded from the database. 

Is there any way I can escalate this to an official support request? I have exhausted every resource I'm aware of in search of an answer.

On 9/14/2022 at 12:18 PM, Jim M said:

They are not safe to ignore, it is an error connecting to your database which would need to be resolved. If these only come up with tasks, you may wish to ensure that there isn't some issue where CRON is running under a different PHP instance which is having some restriction. My suggestion would be to work with a server administrator, if you are unsure how to troubleshoot this.

It seems the MySQL "Connection refused" error is only being logged to the file-log, which is used when the database is inaccessible - makes sense. However, looking at these logs, the connection refused was last logged days ago, while I'm seeing very frequent errors running tasks, the last one happening today. If I look at the System logs in the Support section of the Admin CP, which are being logged to the database, I can see the error that is being reported - unrelated to the connection refused:

Quote

Error: Call to a member function language() on null (0)
#0 /var/www/html/system/Patterns/ActiveRecord.php(335): IPS\cms\_Databases->get__title()
#1 /var/www/html/applications/cms/Application.php(150): IPS\Patterns\_ActiveRecord->__get('_title')
#2 /var/www/html/system/Content/Item.php(1375): IPS\_Application::IPS\cms\{closure}('IPS\\cms\\Categor...')
#3 /var/www/html/applications/cms/sources/Records/Records.php(1822): IPS\Content\_Item->container()
#4 /var/www/html/system/Patterns/ActiveRecord.php(335): IPS\cms\_Records->get__forum_record()
#5 /var/www/html/applications/cms/sources/Records/Records.php(1681): IPS\Patterns\_ActiveRecord->__get('_forum_record')
#6 /var/www/html/applications/cms/sources/Records/Records.php(2180): IPS\cms\_Records->__get('_forum_record')
#7 /var/www/html/applications/cms/sources/Records/Records.php(231): IPS\cms\_Records->useForumComments()
#8 /var/www/html/system/Patterns/ActiveRecordIterator.php(76): IPS\cms\_Records::constructFromData(Array)
#9 /var/www/html/applications/core/extensions/core/Queue/MemberContent.php(93): IPS\Patterns\_ActiveRecordIterator->current()
#10 /var/www/html/system/Task/Task.php(47): IPS\core\extensions\core\Queue\_MemberContent->run(Array, 0)
#11 /var/www/html/applications/core/tasks/queue.php(43): IPS\_Task::runQueue()
#12 /var/www/html/system/Task/Task.php(367): IPS\core\tasks\_queue->IPS\core\tasks\{closure}()
#13 /var/www/html/applications/core/tasks/queue.php(55): IPS\_Task->runUntilTimeout(Object(Closure))
#14 /var/www/html/system/Task/Task.php(266): IPS\core\tasks\_queue->execute()
#15 /var/www/html/system/Task/Task.php(229): IPS\_Task->run()
#16 /var/www/html/applications/core/interface/task/task.php(58): IPS\_Task->runAndLog()
#17 {main}

This is the most frequent error, and it is occurring multiple times per day. It seems to clearly be a PHP execution error within the IP.Board application source files.

On 9/8/2022 at 2:28 AM, Marc Stridgen said:

I did indeed. Each of those comes up directly after a connection refused message.

To explain, the reason my colleague asked about the database, is that we see the error you mentioned, only when there is an error with the database itself. Essentially its trying to get information from the database and for whatever reason, its failing. Generally this tends to be crashed tables, limited connections, or indeed connection refused as you are getting in this case.

I'm just trying to understand how I should go about resolving this issue. Are the warnings that appear in the dashboard safe to ignore, and if so is there any way to turn them off? I'm not sure why there would randomly be a connection refused error on the SQL server, as the forum otherwise runs fine and there haven't been any issues other than the occasional task that fails to run.

18 hours ago, Marc Stridgen said:

You would need to look further into this with your hosting company. The underlying error for this is indeed a mysql issue

IPS\Db\Exception::2002
Connection refused

I run self-managed dedicated servers, one for the frontend and one for the SQL database. I don't think the connection refused error is the root cause here, I think that's relatively uncommon compared to the frequency of the tasks failing. Did you get a chance to look at the other error messages appearing commonly in the logs?

3 hours ago, Jim M said:

Were you having any MySQL issues recently? After running through your queue, the rest of these tasks were able to run successfully without issue. If you continue to see these, please let us know.

No SQL issues recently, as far as I know. The errors are continuing.

Hey there,

I've been having trouble with the tasks set to run automatically on my board. This happens pretty much every time they run:

Looking at the support log, I see the following error occurring repeatedly in the logs:

Thanks for your help!

Hey there,

I'm stuck upgrading to the latest version of IP.Board. I'm getting the following error during upgrade:

Column 'word_key' cannot be null
/var/www/html/system/Db/Db.php::659

Thanks for your help!

I'm seeing 

crond[2285]: (/usr/bin/php) ERROR (getpwnam() failed)

From a brief google search, it looks like I need to prefix a username to the cron command being executed. In my case, located in /etc/crontab.

I'm going to try this, and will update here if successful in case someone else runs into this problem.

Edit: So far seems to be working. For reference, in my crontab file I originally had:

  *  *  *  *  * /usr/bin/php -d memory_limit=-1...

I changed this to:

  *  *  *  *  * root /usr/bin/php -d memory_limit=-1...

4 minutes ago, Jim M said:

"MySQL server could not be found" were being returned. This is pretty much a generic connection issue that MySQL is returning. If the software cannot connect to the database, it cannot perform the task at hand but I do not see anything evident that it is from a task, no.

So there's no way to know specifically why these tasks are locking up?

9 minutes ago, Jim M said:

I was seeing quite a few database errors in your System Log where the system was having inability to connect. I am unsure if this was a temporary issue or more prolonging but I was able to run through the background tasks without error. If you continue to run into this, you may wish to contact your hosting provider for assistance in tracing down why you are unable to connect to your MySQL database during this period.

I recently converted a number of old MyISAM tables to InnoDB, perhaps that had something to do with it. Though the issue with the tasks failing to run was happening well before I did the conversion. I'm self-hosted, so any MySQL issues I'll need to debug myself. Can you share with me the error you saw? And do you believe it to be the cause of the tasks failing to run?

Hi there,

Many of the routine maintenance tasks running on my forum are failing, without any errors appearing in their respective logs. When I run them manually, they run successfully (except for the queue task, which states that it cannot be run because it is already running, though it still complains that it fails to run).

They are setup to execute through a cron job, which had been working fine in the past.

Let me know what other info I can give to help debug.

Thanks!

On 8/24/2021 at 9:37 PM, Michael.J said:

Just released a new update that fixes pagination and the profile pictures.

Has the update been pushed to the marketplace? I'm seeing the last update was pushed July 14th.

On 8/8/2021 at 6:16 PM, Michael.J said:

Are these historically old replies or ones that were made within a few minutes?

Historically old replies.

I'm hitting an issue where clicking "Show previous replies" is loading the same replies that have already been loaded, rather than the previous ones.