Uaseco 0.9.6 from github fatal error

[undef.de]

i can now confirm that lagging still exist with minimal Plugin set. What should we try next?

Does the slowdown feel the same as with default plugins enabled?

Just updated github, with that you can try this setting:

Code: Select all

<?xml version="1.0" encoding="utf-8" standalone="yes" ?>
<plugins>
	<!-- Minimal required plugins -->
	<plugin>plugin.modescript_handler.php</plugin>
	<plugin>chat.help.php</plugin>
</plugins>

and

Code: Select all

<?xml version="1.0" encoding="utf-8" standalone="yes" ?>
<plugins>
	<!-- Minimal required plugins -->
	<plugin>chat.help.php</plugin>
</plugins>

should also run, but I had not the time to test it today...

EDIT: It works, please test this too.

[undef.de]

Did some overall performance gain changes and hopefully found the slowdown bug and could optimize it. If someone could test the current 0.9.6 from github it would be very helpful.

[hackie]

Did some overall performance gain changes and hopefully found the slowdown bug and could optimize it. If someone could test the current 0.9.6 from github it would be very helpful.

Gonna try it

[hackie]

Database changed ? I send you mail of the log.


Edit :

Code: Select all

[2018-05-07 19:55:16] [Map] Running on Map [basic hunt #2] made by [triple_shoot] [Env: Stadium, Uid: s1x5TZocaFaFyY3lixDJEIa6Ige, Id: 1]
[2018-05-07 19:55:16] [Event] Loading Map
[2018-05-07 19:55:16] [LocalRecords] Currently no record on [basic hunt #2]
[2018-05-07 19:55:28] [Player] Connection from Player [me] from Netherlands [Nick: »ρнαηтσм «™, IP: 192.168.1.26, Rank: 2261, Id: 1]
[2018-05-07 19:55:57] [LocalRecords] Player [me] finished with [0:22.418] and took the 1. Local Record!
[UASECO Warning] [Rasp] ERROR: Could not insert time! ((1452) Cannot add or update a child row: a foreign key constraint fails (`uaseco_johnwick`.`uaseco_times`, CONSTRAINT `uaseco_times_ibfk_2` FOREIGN KEY (`PlayerId`) REFERENCES `uaseco_players` (`PlayerId`) ON DELETE CASCADE ON UPDATE CASCADE))
sql = 
			INSERT INTO `%prefix%times` (
				`MapId`,
				`PlayerId`,
				`GamemodeId`,
				`Date`,
				`Score`,
				`Checkpoints`
			)
			VALUES (
				1,
				237,
				2,
				'2018-05-07 18:55:57',
				22418,
				'13866,18705,22418'
			)
			ON DUPLICATE KEY UPDATE
				`Date` = VALUES(`Date`),
				`Score` = VALUES(`Score`),
				`Checkpoints` = VALUES(`Checkpoints`);
			
[2018-05-07 19:55:57] [Event] Player Ranking Updated (Players)

After update uaseco today , before it was fine.

[hacki65]

ATTENTION: Dont use this new github version, because it is possible that all local records will be deleted if the prune function will be used !!!

[endbase]

ATTENTION: Dont use this new github version, because it is possible that all local records will be deleted if the prune function will be used !!!

Nice to know but is it realy neccesery to warn like this ?

[undef.de]

ATTENTION: Dont use this new github version, because it is possible that all local records will be deleted if the prune function will be used !!!

The <prune_records_times> function was made exact for deleting records and times from maps that aren't used in the server to keep the database clean.

A detailed report what happened would be helpful.

[bern]

Did some overall performance gain changes and hopefully found the slowdown bug and could optimize it. If someone could test the current 0.9.6 from github it would be very helpful.

I would like to help, but I think it is better to create a test server ,,,
in my house the speed is adsl, bad bad and I can not mount server for + of 6 players.
The other serer where I have the league, would be fine, they connect every day 70 to 100 people, but it is risky for fear of losing records or data of the players who play monthly. (there I receive many complaints from lag)
I hope someone can temporarily build a home server with good speed (fiber) and be able to do the tests.

[undef.de]

Database changed ? I send you mail of the log.

Edit :

Code: Select all

[2018-05-07 19:55:57] [LocalRecords] Player [me] finished with [0:22.418] and took the 1. Local Record!
[UASECO Warning] [Rasp] ERROR: Could not insert time! ((1452) Cannot add or update a child row: a foreign key constraint fails (`uaseco_johnwick`.`uaseco_times`, CONSTRAINT `uaseco_times_ibfk_2` FOREIGN KEY (`PlayerId`) REFERENCES `uaseco_players` (`PlayerId`) ON DELETE CASCADE ON UPDATE CASCADE))
sql = 
			INSERT INTO `%prefix%times` (
				`MapId`,
				`PlayerId`,
				`GamemodeId`,
				`Date`,
				`Score`,
				`Checkpoints`
			)
			VALUES (
				1,
				237,
				2,
				'2018-05-07 18:55:57',
				22418,
				'13866,18705,22418'
			)
			ON DUPLICATE KEY UPDATE
				`Date` = VALUES(`Date`),
				`Score` = VALUES(`Score`),
				`Checkpoints` = VALUES(`Checkpoints`);
			
[2018-05-07 19:55:57] [Event] Player Ranking Updated (Players)

After update uaseco today , before it was fine.

As already written in the mail:
That's strange, I downloaded the file from github and installed them separately (to do not override my development base) and started it at Linux and Windows without any problems on new times/records:

LINUX

Code: Select all

[2018-05-08 16:21:58] [Player] Connection from Player [undef] from Germany [Nick: ぎтяα¢кєяѕ|ρнαѕє ''', IP: 0.0.0.0, Rank: 64149, Id: 6931]
[2018-05-08 16:21:59] [Map] Running on Map [Short Distance 24 2K17] made by [undef.de] [Env: Stadium, Uid: kW_ZeqIiaNcBZ894nu0tSKMpH_j, Id: 893]
[2018-05-08 16:21:59] [Event] Loading Map
[2018-05-08 16:21:59] [LocalRecords] Current record on Map [Short Distance 24 2K17] is [0:15.882] and held by Player [undef.de]
[2018-05-08 16:22:52] [LocalRecords] Player [undef] finished with [0:15.763] and took the 1. Local Record!
[2018-05-08 16:22:52] [Dedimania] Player [undef] finished with [0:15.763] and took the 10. Dedimania Record!
[2018-05-08 16:22:52] [Event] Player Ranking Updated (Players)

WINDOWS

Code: Select all

[2018-05-08 15:41:35] [Player] Connection from Player [undef] from Germany [Nick: ぎтяα¢кєяѕ|ρнαѕє ''', IP: 0.0.0.0, Rank: 64149, Id: 6931]
[2018-05-08 15:41:35] [Map] Running on Map [Short Distance 06 2K17] made by [undef.de] [Env: Stadium, Uid: 1roMoKrWtk2EljU3zbdf9hx3CYk, Id: 827]
[2018-05-08 15:41:35] [Event] Loading Map
[2018-05-08 15:41:35] [LocalRecords] Current record on Map [Short Distance 06 2K17] is [3:44.319] and held by Player [undef.de]
[2018-05-08 15:42:10] [LocalRecords] Player [undef] finished with [0:18.591] and took the 1. Local Record!
[2018-05-08 15:42:10] [Dedimania] Player [undef] finished with [0:18.591] and took the 2. Dedimania Record!
[2018-05-08 15:42:11] [Event] Player Ranking Updated (Players)

It seems you messed up the files or something.

[hackie]

Database changed ? I send you mail of the log.

Edit :

Code: Select all

[2018-05-07 19:55:57] [LocalRecords] Player [me] finished with [0:22.418] and took the 1. Local Record!
[UASECO Warning] [Rasp] ERROR: Could not insert time! ((1452) Cannot add or update a child row: a foreign key constraint fails (`uaseco_johnwick`.`uaseco_times`, CONSTRAINT `uaseco_times_ibfk_2` FOREIGN KEY (`PlayerId`) REFERENCES `uaseco_players` (`PlayerId`) ON DELETE CASCADE ON UPDATE CASCADE))
sql = 
			INSERT INTO `%prefix%times` (
				`MapId`,
				`PlayerId`,
				`GamemodeId`,
				`Date`,
				`Score`,
				`Checkpoints`
			)
			VALUES (
				1,
				237,
				2,
				'2018-05-07 18:55:57',
				22418,
				'13866,18705,22418'
			)
			ON DUPLICATE KEY UPDATE
				`Date` = VALUES(`Date`),
				`Score` = VALUES(`Score`),
				`Checkpoints` = VALUES(`Checkpoints`);
			
[2018-05-07 19:55:57] [Event] Player Ranking Updated (Players)

After update uaseco today , before it was fine.

As already written in the mail:
That's strange, I downloaded the file from github and installed them separately (to do not override my development base) and started it at Linux and Windows without any problems on new times/records:

LINUX

Code: Select all

[2018-05-08 16:21:58] [Player] Connection from Player [undef] from Germany [Nick: ぎтяα¢кєяѕ|ρнαѕє ''', IP: 0.0.0.0, Rank: 64149, Id: 6931]
[2018-05-08 16:21:59] [Map] Running on Map [Short Distance 24 2K17] made by [undef.de] [Env: Stadium, Uid: kW_ZeqIiaNcBZ894nu0tSKMpH_j, Id: 893]
[2018-05-08 16:21:59] [Event] Loading Map
[2018-05-08 16:21:59] [LocalRecords] Current record on Map [Short Distance 24 2K17] is [0:15.882] and held by Player [undef.de]
[2018-05-08 16:22:52] [LocalRecords] Player [undef] finished with [0:15.763] and took the 1. Local Record!
[2018-05-08 16:22:52] [Dedimania] Player [undef] finished with [0:15.763] and took the 10. Dedimania Record!
[2018-05-08 16:22:52] [Event] Player Ranking Updated (Players)

WINDOWS

Code: Select all

[2018-05-08 15:41:35] [Player] Connection from Player [undef] from Germany [Nick: ぎтяα¢кєяѕ|ρнαѕє ''', IP: 0.0.0.0, Rank: 64149, Id: 6931]
[2018-05-08 15:41:35] [Map] Running on Map [Short Distance 06 2K17] made by [undef.de] [Env: Stadium, Uid: 1roMoKrWtk2EljU3zbdf9hx3CYk, Id: 827]
[2018-05-08 15:41:35] [Event] Loading Map
[2018-05-08 15:41:35] [LocalRecords] Current record on Map [Short Distance 06 2K17] is [3:44.319] and held by Player [undef.de]
[2018-05-08 15:42:10] [LocalRecords] Player [undef] finished with [0:18.591] and took the 1. Local Record!
[2018-05-08 15:42:10] [Dedimania] Player [undef] finished with [0:18.591] and took the 2. Dedimania Record!
[2018-05-08 15:42:11] [Event] Player Ranking Updated (Players)

It seems you messed up the files or something.

strange , cause I did a clean install ( not overwriting anything ).
I try again. Thanks anyway Undef ^^