mysql> status;
--------------
mysql Ver 14.14 Distrib 5.5.11, for Linux (x86_64) using readline 5.1
Connection id: 2014
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.11 MySQL Community Server (GPL) by Remi
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 20 hours 47 min 34 sec
Threads: 3 Questions: 74792 Slow queries: 0 Opens: 662 Flush tables: 1 Open tables: 57 Queries per second avg: 0.999
mysql> show engine innodb status \G;
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
110527 16:23:38 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 6 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 44587 1_second, 44587 sleeps, 4090 10_second, 3705 background, 3705 flush
srv_master_thread log flush and writes: 44600
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3469, signal count 3469
Mutex spin waits 350, rounds 7117, OS waits 19
RW-shared spins 3444, rounds 103320, OS waits 3444
RW-excl spins 0, rounds 150, OS waits 5
Spin rounds per wait: 20.33 mutex, 30.00 RW-shared, 150.00 RW-excl
------------------------
LATEST FOREIGN KEY ERROR
------------------------
110527 1:17:31 Transaction:
TRANSACTION 1EB04C, ACTIVE 0 sec, process no 11330, OS thread id 1243072832 updating or deleting
mysql tables in use 1, locked 1
4 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
MySQL thread id 1035, query id 19551 192.168.20.3 Multicraft updating
DELETE FROM `server` WHERE `server`.`id`=5
Foreign key constraint fails for table `Multicraft_D1`.`command`:
,
CONSTRAINT `command_ibfk_1` FOREIGN KEY (`server_id`) REFERENCES `server` (`id`)
Trying to delete or update in parent table, in index `PRIMARY` tuple:
DATA TUPLE: 18 fields;
0: len 4; hex 80000005; asc ;;
1: len 6; hex 0000001eb04c; asc L;;
2: len 7; hex 5300000285131d; asc S ;;
3: len 3; hex 313131; asc 111;;
4: len 0; hex ; asc ;;
5: len 4; hex 800063de; asc c ;;
6: len 3; hex 313131; asc 111;;
7: len 0; hex ; asc ;;
8: len 4; hex 80000008; asc ;;
9: len 4; hex 80000000; asc ;;
10: len 4; hex 80000000; asc ;;
11: len 0; hex ; asc ;;
12: len 1; hex 31; asc 1;;
13: len 4; hex 8000000a; asc ;;
14: len 4; hex 80000001; asc ;;
15: len 4; hex 80000001; asc ;;
16: len 4; hex 80000bb8; asc ;;
17: len 4; hex 80000000; asc ;;
But in child table `Multicraft_D1`.`command`, in index `server_id`, there is a record:
PHYSICAL RECORD: n_fields 3; compact format; info bits 0
0: len 4; hex 80000005; asc ;;
1: len 9; hex 41646d696e20536179; asc Admin Say;;
2: len 4; hex 80000049; asc I;;
------------
TRANSACTIONS
------------
Trx id counter 1F4E27
Purge done for trx's n:o < 1ECC67 undo n:o < 0
History list length 8476
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, process no 11330, OS thread id 1243871552
MySQL thread id 2014, query id 74744 localhost root
show engine innodb status
---TRANSACTION 1F4E20, not started, process no 11330, OS thread id 1242806592
MySQL thread id 1902, query id 74716 192.168.20.5 perm1
---TRANSACTION 1F4E26, ACTIVE 8 sec, process no 11330, OS thread id 1084176704 inserting
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
MySQL thread id 2023, query id 74740 192.168.20.3 Multicraft update
INSERT INTO `player` (`level`, `lastseen`, `banned`, `op`, `status`, `ip`, `previps`, `quitreason`, `server_id`, `name`) VALUES (10, '', '', '', '', '', '', '', 1, '565656')
------- TRX HAS BEEN WAITING 8 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 658 n bits 80 index `server_id` of table `Multicraft_D1`.`player` trx id 1F4E26 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 7 PHYSICAL RECORD: n_fields 3; compact format; info bits 0
0: len 4; hex 80000001; asc ;;
1: len 5; hex 736b6c6973; asc sklis;;
2: len 4; hex 80000007; asc ;;
------------------
---TRANSACTION 1ECC21, ACTIVE 48666 sec, process no 11330, OS thread id 1243072832
10 lock struct(s), heap size 1248, 6 row lock(s), undo log entries 2443
MySQL thread id 1892, query id 74743 192.168.20.5 Multicraft
Trx read view will not see trx with id >= 1ECC22, sees < 1ECC22
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
464 OS file reads, 54010 OS file writes, 25123 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.17 writes/s, 0.67 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276671, node heap has 2 buffer(s)
0.50 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 178498708
Log flushed up to 178498708
Last checkpoint at 178498708
0 pending log writes, 0 pending chkp writes
18207 log i/o's done, 0.33 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 172255
Buffer pool size 8191
Free buffers 7539
Database pages 650
Old database pages 219
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 453, created 197, written 32125
0.00 reads/s, 0.00 creates/s, 0.67 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s
LRU len: 650, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread process no. 11330, id 1242540352, state: waiting for server activity
Number of rows inserted 9326, updated 4697, deleted 9301, read 432663
0.00 inserts/s, 0.17 updates/s, 0.00 deletes/s, 0.33 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
Panel to another server - OK (Not enough processing power)
Base from the beginning on a separate server.
-------------
player create - Error 500 :sad.gif:
0
0
CREATE TABLE table (
---\\-----
)
ENGINE = MYISAM;
:smile.gif:
0
0
CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction /var/www/html/multicraft/protected/yii/db/CDbCommand.php(316) 304 if($this->_connection->enableProfiling) 305 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().')','system.db.CDbCommand.execute'); 306 307 return $n; 308 } 309 catch(Exception $e) 310 { 311 if($this->_connection->enableProfiling) 312 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().')','system.db.CDbCommand.execute'); 313 Yii::log('Error in executing SQL: '.$this->getText().$par,CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 314 $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; 315 316 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 317 array('{error}'=>$e->getMessage())),(int)$e->getCode(),$errorInfo); 318 } 319 } 320 321 /** 322 * Executes the SQL statement and returns query result. 323 * This method is for executing an SQL query that returns result set. 324 * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative 325 * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing 326 * them in this way can improve the performance. Note that if you pass parameters in this way, 327 * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa. 328 * binding methods and the input parameters this way can improve the performance. Stack Trace #0 /var/www/html/multicraft/protected/yii/db/ar/CActiveRecord.php(1000): CDbCommand->execute() #1 /var/www/html/multicraft/protected/yii/db/ar/CActiveRecord.php(764): CActiveRecord->insert(null) #2 /var/www/html/multicraft/protected/controllers/PlayerController.php(237): CActiveRecord->save() 232 $model->level = 0; //no permission 233 $user = (int)$_POST['user-assign']; 234 $userModel = User::model()->findByPk($user); 235 if ($userModel && array_search($userModel->getLevel($sv), array_keys($playerRoles)) === false) 236 $user = 0; 237 if($model->save()) 238 { 239 if ($model->user != $user) 240 $model->user = $user; 241 $this->redirect(array('view','id'=>$model->id)); 242 } #3 unknown(0): PlayerController->actionCreate("1") #4 /var/www/html/multicraft/protected/yii/web/actions/CInlineAction.php(71): ReflectionMethod->invokeArgs(PlayerController, array("1")) #5 /var/www/html/multicraft/protected/yii/web/CController.php(300): CInlineAction->run() #6 /var/www/html/multicraft/protected/yii/web/filters/CFilterChain.php(133): CController->runAction(CInlineAction) #7 /var/www/html/multicraft/protected/yii/web/filters/CFilter.php(41): CFilterChain->run() #8 /var/www/html/multicraft/protected/yii/web/CController.php(1088): CFilter->filter(CFilterChain) #9 /var/www/html/multicraft/protected/yii/web/filters/CInlineFilter.php(59): CController->filterAccessControl(CFilterChain) #10 /var/www/html/multicraft/protected/yii/web/filters/CFilterChain.php(130): CInlineFilter->filter(CFilterChain) #11 /var/www/html/multicraft/protected/yii/web/CController.php(283): CFilterChain->run() #12 /var/www/html/multicraft/protected/yii/web/CController.php(257): CController->runActionWithFilters(CInlineAction, array("accessControl")) #13 /var/www/html/multicraft/protected/yii/web/CWebApplication.php(328): CController->run("create") #14 /var/www/html/multicraft/protected/yii/web/CWebApplication.php(121): CWebApplication->runController("player/create") #15 /var/www/html/multicraft/protected/yii/base/CApplication.php(155): CWebApplication->processRequest() #16 /var/www/html/multicraft/index.php(19): CApplication->run() 14 defined('YII_DEBUG') or define('YII_DEBUG',true); 15 // how many levels of call stack should be shown in each log message 16 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3); 17 18 require_once($yii); 19 Yii::createWebApplication($config)->run(); 2011-05-27 16:46:46 Apache/2.2.17 (CentOS) Yii Framework/1.1.60
Base from the beginning on a separate server.
-------------
player create - Error 500 :sad.gif:
What a token should be ???
0
Manual installation of 2 bases MySql (daemon + panel)
Manual installation daemon
Start ./multicraft -nv start
0
2 letters + license did not help.
Daemon start, Server Permissions save:
Error 500
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
Daemon stop, Server Permissions save: OK
Used only MySQL InnoDB