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.
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!
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:
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>
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]
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.
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.
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
http://www.multicraft.org/site/page?view=services
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
Thanks!
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
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
When exactly does this error occur? Did you maybe start the daemon twice?
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
Manual installation of 2 bases MySql (daemon + panel)
Manual installation daemon
Start ./multicraft -nv start
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.
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
Base from the beginning on a separate server.
-------------
player create - Error 500 :sad.gif:
What a token should be ???
The first two entries of the troubleshooting guide could also be helpful in this case:
http://multicraft.org/site/page?view=troubleshooting
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
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
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
CREATE TABLE table (
---\\-----
)
ENGINE = MYISAM;
:smile.gif:
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
Mail: [email protected]
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
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.
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube
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.
http://www.multicraft.org
Multicraft on Facebook, Twitter and YouTube