Thanks a lot for the thorough answer. I will follow your suggestions
tomorrow. And I will report back under any circumstances. I have full root
access, so I guess this could be the way to go.
Thanks again!
Best regards,
Jon Theil Nielsen
ons. 1. nov. 2017 kl. 18.36 skrev Greg Rundlett (freephile) <
greg(a)freephile.com>gt;:
Go ahead and stop Apache, and if you haven't
already, make a disk copy of
your mysql data directory for backups. Then start MySQL alone. See if you
get any errors from starting MySQL (find logs at /var/log/mysql/error_log
or similar). Post any errors. If the db server is running, do some checks
on the mediawiki schema like mentioned here [1].
# assuming your 'root' system user has a /root/.my.cnf file that allows you
to login to the database server.
sudo su -
mysql -e 'SHOW VARIABLES LIKE "general_log%";'
mysql
SET @DB = 'mediawiki';
show create table @DB.l10n_cache;
[1]
https://www.percona.com/blog/2008/07/04/recovering-innodb-table-corruption/
Greg Rundlett
https://eQuality-Tech.com
https://freephile.org
On Wed, Nov 1, 2017 at 12:59 PM, Jon Theil Nielsen <jontheil(a)gmail.com>
wrote:
Actually, I don't think i stopped the web
server. I don't think it is a
memory problem. I have 16 GB in total and this very moment about 0.5 GB
completely free.
Regards,
Jon Theil Nielsen
ons. 1. nov. 2017 kl. 17.55 skrev G Rundlett <greg.rundlett(a)gmail.com>om>:
> Did you stop Apache, and start MySQL alone? How much free memory is
> reported?
>
> On Nov 1, 2017 12:51 PM, "Jon Theil Nielsen" <jontheil(a)gmail.com>
wrote:
>
> > Dear List Users,
> >
> > I have mediawiki 1.29-Release running on FreeBSD-11.1-Release and
have
> had
> > a crash of my MySQL database. At first, I couldn't start it at all.
But
>
after deleting ib_logfile* and ibdata*, it came back alive. In the
sense
> > that I can start the server and use many of the databases. But not
the
one
> holding my mediawiki installation.
>
> The error log says
> "[Warning] InnoDB: InnoDB: Cannot open table
mediawiki_something_dk/user
> > from the
> > internal data dictionary of InnoDB though the .frm file for the
table
> > exists.."
> > The debug log is quite full but has the message
> > "Error: 1146 Table 'mediawiki_something_dk.l10n_cache' doesn't
exist
> > (localhost)"
> >
> > Does anyone know how to solve this? Or maybe have somehere, I can
look
for
a solution.
Best regards,
Jon Theil Nielsen
--
Jon Theil Nielsen
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
--
Jon Theil Nielsen
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l