Register for your free account! | Forgot your password?

You last visited: Today at 01:12

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[HELP] Errors Mysql

Discussion on [HELP] Errors Mysql within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2012
Posts: 32
Received Thanks: 0
[HELP] Errors Mysql

Hello,
please help.

Quote:
140501 11:01:48 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2014-05-01 11:01:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-05-01 11:01:48 11832 [Note] Plugin 'FEDERATED' is disabled.
2014-05-01 11:01:48 11832 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-01 11:01:48 11832 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-01 11:01:48 11832 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-05-01 11:01:48 11832 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-05-01 11:01:48 11832 [Note] InnoDB: Using CPU crc32 instructions
2014-05-01 11:01:49 11832 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-05-01 11:01:49 11832 [Note] InnoDB: Completed initialization of buffer pool
2014-05-01 11:01:49 11832 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-01 11:01:49 11832 [Note] InnoDB: Log scan progressed past the checkpoint lsn 49463
2014-05-01 11:01:49 11832 [Note] InnoDB: Database was not shutdown normally!
2014-05-01 11:01:49 11832 [Note] InnoDB: Starting crash recovery.
2014-05-01 11:01:49 11832 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-05-01 11:01:49 802807400 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: Error: could not open single-table tablespace file ./mysql/innodb_index_stats.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
140501 11:01:49 mysqld_safe mysqld from pid file /var/db/mysql/freya.pid ended
PS: I speak Czech
geron552 is offline  
Old 05/01/2014, 13:22   #2
 
elite*gold: 11
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
Quote:
2014-05-01 11:01:49 802807400 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
chown -R mysql /var/db/mysql
.Shōgun is offline  
Reply


Similar Threads Similar Threads
MySQL Errors
02/08/2014 - EO PServer Hosting - 18 Replies
Does anyone know how to fix these MySQL Errors? Warning: mysql_connect(): Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 4.0.18-max-debug in C:\xampp\htdocs\page\config.php on line 16 Warning: mysql_connect(): Connecting to 3.22, 3.23 & 4.0 servers is not supported in C:\xampp\htdocs\page\config.php on line 16 Warning: mysql_select_db(): Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 4.0.18-max-debug in C:\xampp\htdocs\page\config.php on line 17 Warning:...
[Help]Albetros MYSQL execute errors
12/22/2012 - CO2 Private Server - 11 Replies
I have some errors on that source can some1 help me please? 1064 - 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 'skip,1; END ; -- ---------------------------- -- Procedure structure for' at line 5 INSERT INTO spellinfo VALUES ('10359', '30010', 'IceBolt', '0036', '0', '0', '0', '0004', '0000', '0000', '120', '0000', '0100', '0000', '0008', '0020', '0000', '0000', '0', '0000', '0', '0000',...
[Guide] 2 Fixes on Sro-Errors (no bot-errors)
03/04/2011 - SRO Guides & Templates - 5 Replies
Hey guys, here are 2 fixes for silkroad-errors (not bot-errors!). I know they dont appear for many people but some guys have problems with it. 1st Fix: "Server is undergoing inspection..." Why does this error appear? Because Joymax has some problems with the Login-Servers. Fix: Step1): Click on "Start" then on "Run"
mysql errors.. 2010 files..;(
01/11/2011 - Metin2 Private Server - 8 Replies
Hi Leute, ich krieg nochmal nen Anfall wegen dem Scheiß.. Also entweder is das wirklich voll die verbuggte Scheiße oder ich bin einfach zu dämlich. Ich folgende errors stehn: DB-syserr:YSERR: Jan 5 16:33:55 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jan 5 16:33:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id SYSERR: Jan 5...



All times are GMT +1. The time now is 01:13.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.