|
You last visited: Today at 01:12
Advertisement
[HELP] Errors Mysql
Discussion on [HELP] Errors Mysql within the Metin2 Private Server forum part of the Metin2 category.
05/01/2014, 12:51
|
#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
|
|
|
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
|
|
|
 |
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.
|
|