HTTP ERROR 500

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

HTTP ERROR 500

Post by goldencoin5 »

after sudden power failure restart of my server, getting HTTP ERROR 500
forum was working perfectly before power failure restart of the system.
phpbb 3.3.8
PHP Version 8.1.10 FPM/FastCGI

Code: Select all

[Wed Sep 21 11:54:35.456669 2022] [proxy_fcgi:error] [pid 16757] [client 173.231.60.194:61566] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /var/www/phpbb/db/driver/mysqli.php:200\nStack trace:\n#0 /var/www/phpbb/db/driver/mysqli.php(200): mysqli_query()\n#1 /var/www/phpbb/db/driver/factory.php(345): phpbb\\db\\driver\\mysqli->sql_query()\n#2 /var/www/phpbb/config/db.php(72): phpbb\\db\\driver\\factory->sql_query()\n#3 /var/www/phpbb/config/db.php(55): phpbb\\config\\db->initialise()\n#4 [internal function]: phpbb\\config\\db->__construct()\n#5 /var/www/vendor/symfony/dependency-injection/ContainerBuilder.php(1176): ReflectionClass->newInstanceArgs()\n#6 /var/www/vendor/symfony/dependency-injection/ContainerBuilder.php(634): Symfony\\Component\\DependencyInjection\\ContainerBuilder->createService()\n#7 /var/www/vendor/symfony/dependency-injection/ContainerBuilder.php(1281): Symfony\\Component\\DependencyInjection\\ContainerBuilder->doGet()\n#8 /var/www/vendor/symfony/dependency-injection/ContainerBuilder.php(1238): Symfony\\Component\\DependencyInjection\\ContainerBuilder->do...', referer: https://www.
what could be the reason ?
Last edited by Mick on Fri Sep 23, 2022 8:02 pm, edited 2 times in total.
Reason: Solved.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: HTTP ERROR 500

Post by goldencoin5 »

when accessing database using phpmyadmin getting error:

Code: Select all

mysqli::real_connect(): (HY000/2002): No such file or directory
Last edited by goldencoin5 on Wed Sep 21, 2022 10:42 am, edited 1 time in total.
User avatar
david63
Registered User
Posts: 20614
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: HTTP ERROR 500

Post by david63 »

My first thought is that if you have had a power failure and then start getting errors that you have a corruption somewhere - could be a file, could be the database or even a hardware corruption.

My first thing to try would be to restore to the last backup.

I'm surprised that your server does not have power failure protection - if I were you I would be asking my hosts why there is no such protection.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 27927
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: HTTP ERROR 500

Post by Paul »

Check if your mysql server is actually running. That error might be caused because mysql isn't properly started.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: HTTP ERROR 500

Post by goldencoin5 »

david63 wrote: Wed Sep 21, 2022 8:02 am My first thought is that if you have had a power failure and then start getting errors that you have a corruption somewhere - could be a file, could be the database or even a hardware corruption.
i have two databases, one is main forum in root directory /var/www with database named "phpbb3"
another test environment is in /var/www/new directory with separate database name "phpbb31"
both are not working after power failure that's mean that some service is not running.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: HTTP ERROR 500

Post by goldencoin5 »

Paul wrote: Wed Sep 21, 2022 9:15 am Check if your mysql server is actually running. That error might be caused because mysql isn't properly started.

Code: Select all

root@debian:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.15 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: signal) since Wed 2022-09-21 12:52:08 ; 2s ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 15179 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 15180 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 15182 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$>
    Process: 15229 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
   Main PID: 15229 (code=killed, signal=ABRT)
        CPU: 299ms
MariaDB.png
Last edited by goldencoin5 on Wed Sep 21, 2022 10:24 am, edited 2 times in total.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: HTTP ERROR 500

Post by goldencoin5 »

Paul wrote: Wed Sep 21, 2022 9:15 am Check if your mysql server is actually running. That error might be caused because mysql isn't properly started.

Code: Select all

root@debian:~# systemctl restart mariadb
Job for mariadb.service failed because a fatal signal was delivered to the control process.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: HTTP ERROR 500

Post by goldencoin5 »

Code: Select all

journalctl -xe
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(+0xd69eb0)[0x561d0e2b7eb0]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(+0xd27bbf)[0x561d0e275bbf]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(+0xd2e194)[0x561d0e27c194]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(+0x6335d7)[0x561d0db815d7]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(+0xc40bc9)[0x561d0e18ebc9]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(_Z24ha_initialize_handlertonP13st_plugin_int+0x7e)[0x561d0dea8efe]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(+0x76e8fa)[0x561d0dcbc8fa]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(_Z11plugin_initPiPPci+0x887)[0x561d0dcbd9e7]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(+0x698db7)[0x561d0dbe6db7]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(_Z11mysqld_mainiPPc+0x3f4)[0x561d0dbecbc4]
Sep 21 15:27:05 debian mariadbd[55667]: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7fb62fed7d0a]
Sep 21 15:27:05 debian mariadbd[55667]: /usr/sbin/mariadbd(_start+0x2a)[0x561d0dbe1b3a]
Sep 21 15:27:05 debian mariadbd[55667]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Sep 21 15:27:05 debian mariadbd[55667]: information that should help you find out what is causing the crash.
Sep 21 15:27:05 debian mariadbd[55667]: Writing a core file...
Sep 21 15:27:05 debian mariadbd[55667]: Working directory at /var/lib/mysql
Sep 21 15:27:05 debian mariadbd[55667]: Resource Limits:
Sep 21 15:27:05 debian mariadbd[55667]: Limit                     Soft Limit           Hard Limit           Units
Sep 21 15:27:05 debian mariadbd[55667]: Max cpu time              unlimited            unlimited            seconds
Sep 21 15:27:05 debian mariadbd[55667]: Max file size             unlimited            unlimited            bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max data size             unlimited            unlimited            bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max stack size            8388608              unlimited            bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max core file size        0                    unlimited            bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max resident set          unlimited            unlimited            bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max processes             30980                30980                processes
Sep 21 15:27:05 debian mariadbd[55667]: Max open files            32768                32768                files
Sep 21 15:27:05 debian mariadbd[55667]: Max locked memory         65536                65536                bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max address space         unlimited            unlimited            bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max file locks            unlimited            unlimited            locks
Sep 21 15:27:05 debian mariadbd[55667]: Max pending signals       30980                30980                signals
Sep 21 15:27:05 debian mariadbd[55667]: Max msgqueue size         819200               819200               bytes
Sep 21 15:27:05 debian mariadbd[55667]: Max nice priority         0                    0
Sep 21 15:27:05 debian mariadbd[55667]: Max realtime priority     0                    0
Sep 21 15:27:05 debian mariadbd[55667]: Max realtime timeout      unlimited            unlimited            us
Sep 21 15:27:05 debian mariadbd[55667]: Core pattern: core
Sep 21 15:27:05 debian systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'killed' and its exit status is 6.
Sep 21 15:27:05 debian systemd[1]: mariadb.service: Failed with result 'signal'.
░░ Subject: Unit failed
░░ Defined-By: systemd
User avatar
Mick
Support Team Member
Support Team Member
Posts: 24571
Joined: Fri Aug 29, 2008 9:49 am
Contact:

Re: HTTP ERROR 500

Post by Mick »

If I were you, as well as this topic I think you should also be enquiring on a support site for your server software.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: HTTP ERROR 500

Post by goldencoin5 »

my site is self hosted
User avatar
Mick
Support Team Member
Support Team Member
Posts: 24571
Joined: Fri Aug 29, 2008 9:49 am
Contact:

Re: HTTP ERROR 500

Post by Mick »

That’s exactly why you should be enquiring somewhere your server is supported as well as here. Two heads are better than one ;)
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
MarkDHamill
Registered User
Posts: 4713
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: HTTP ERROR 500

Post by MarkDHamill »

Check to see if your /cache/production folder has 777 permissions. If not add it. You might want to purge the cache afterward.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. Covers through phpBB 3.3.7. eBook and paper versions available.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: HTTP ERROR 500

Post by goldencoin5 »

MarkDHamill wrote: Wed Sep 21, 2022 9:56 pm Check to see if your /cache/production folder has 777 permissions. If not add it. You might want to purge the cache afterward.
Due to power failure, I had corruption somewhere which caused damage in running sql server properly.
Tried both mariadb and mysql but ended up in log entry with abort message.
Couldn't be able to sort it out so install fresh OS which solve the issue. Last backup of the board was done 10 days ago.
Restore that backup and good to go.
Post Reply

Return to “[3.3.x] Support Forum”