Minecraft Forums

Version b1.1.1 Released
This release brings improvements mainly for automating Multicraft using its extensive API.
Besides the API changes, Multicraft now also has a server suspend/resume function, allowing admins to temporarily disable server access.

Detailed Changelog:
- Implemented suspend/resume functionality
- Implemented new API calls
- Implemented array support for "update" and "find" API calls
- Added new variables for Minecraft start command
- Improved API functions (retaining backward compatibility)
- Improved logging for some rare exceptions
- Improved config file comments
- Improved default welcome text
- Support page will only show when admin email is set
- Replaced xhost.ch with multicraft.org in copyright notice
- Log stream encodings to assist debugging encoding issues
- Fixed some PHP 5.3 issues
- Fixed placeholder expansion when calling builtin commands


Also, WHMCS and Ubersmith modules will be available soon, it will be announced here as well.

WHMCS and Ubersmith modules as well as installation services for Linux and Windows are now available:
http://www.multicraft.org/site/page?view=services

I'm currently compiling a list of hosting providers using Multicraft. If you know of one or if you are using Multicraft yourself please post it here or contact me at [email protected]
Thanks!

Thank you for the feedback, Dorkslayz!

Unfortunately I did not receive support.
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

@angrof: When and to which address did you send your messages? Every support request gets answered independently of license.

When exactly does this error occur? Did you maybe start the daemon twice?

Messages through this address: http://www.multicraft.org/site/report

Manual installation of 2 bases MySql (daemon + panel)

Manual installation daemon

========================================================
|    id    |   name   |    ip    |   port   |  token   |  - token ???
========================================================
|    1     |          |192.168.  |  25465   |          |
|          |          |    10.12 |          |          |
--------------------------------------------------------

Start ./multicraft -nv start

Ah, wow. Thanks for bringing that to my attention, there was a problem with the support form. It should work again now.
I'm sorry for the inconvenience caused, if you want we can continue this conversation by mail, I'll post the solution here for others to see.

I suspect this is a problem with MySQL as Multicraft doesn't use transactions. If there is no valuable data currently in the database you can just try dropping it and recreating it. Otherwise you can try the MySQL repair functions and if all else fails, backup the data, recreate the DB and restore the data.
I've read that increasing the "innodb_lock_wait_timeout" in your my.cnf can help but Multicraft doesn't execute any long running queries so I don't think this will help in this case.

Panel to another server - OK (Not enough processing power)
Base from the beginning on a separate server.
-------------
player create - Error 500 :sad.gif:

What a token should be ???

Hm, does it say anything else? If not you can uncomment line 15 in your "index.php" to get a more detailed error message.

The first two entries of the troubleshooting guide could also be helpful in this case:
http://multicraft.org/site/page?view=troubleshooting

Quote from zpin

Hm, does it say anything else? If not you can uncomment line 15 in your "index.php" to get a more detailed error message.

The first two entries of the troubleshooting guide could also be helpful in this case:
http://multicraft.org/site/page?view=troubleshooting

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.6 

Ok, still the same problem as before. What version of MySQL are you using?

Try changing the database engine from InnoDB to MyISAM.

Otherwise there are some resources that might help troubleshoot this issue.
http://stackoverflow.com/questions/6000336/how-to-debug-lock-wait-timeout-exceeded
http://forums.mysql.com/read.php?25,163152,166574#msg-166574

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:           [email protected]
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>

Ok, seems there is a deadlock in your DB for some reason. Please switch your database engine to MyISAM, this should fix the problem.

MYISAM OK

CREATE TABLE table (
---\\-----
)
ENGINE = MYISAM;

:smile.gif:

Glad to hear that it works now :smile.gif: I'll see that MyISAM gets explicitly set in the schema files for future versions.

I will need to know the exact definition of your task and command in order to be able to help you. Can you please send this information to me by mail or PM?
Mail: [email protected]

Hey Dragoshi,

Thank you :smile.gif: The latest Craftbukkit should work fine with Multicraft.

Some plugins do not respect the console output format of Minecraft which can cause unexpected behavior. If you disable one plugin at a time you should be able to find out which one causes the issue. We can then look into this and see if we can add support for this particular plugin to the default .conf file.

Could it be that the plugin also changes other things beside the player name? Changing the player name should be fine, but just to make sure you can try leaving out the [].

You get the "CONSOLE" message because you are in the ops.txt file, you can remove yourself from that ("Edit Config Files"->"Operators") as either Multicraft or some of the plugins can give you access to special commands.

Permissions 3.X support SQL add Multicraft