Raised This Month: $ Target: $400
 0% 

AmxModX 1.8.0 + MySQL = CRASH


Post New Thread Reply   
 
Thread Tools Display Modes
alien
Senior Member
Join Date: Aug 2005
Location: London || Slovakia
Old 12-14-2007 , 02:27   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #11

If this is gonna fix my problem ...

UPDATE: It works. Omg I've spent few weeks trying to put this together ...
__________________

Last edited by alien; 12-14-2007 at 02:33.
alien is offline
Send a message via ICQ to alien
BAILOPAN
Join Date: Jan 2004
Old 12-14-2007 , 02:42   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #12

I regret not seeing this support post earlier. Indeed, this was a bug addressed in the 1.8.1 automated builds (which are beta but stable).
__________________
egg
BAILOPAN is offline
simas
Junior Member
Join Date: Dec 2007
Old 12-15-2007 , 08:03   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #13

I can use 1.8.0 or 1.7.6c it doesn`t matters , because when i try load mysql, i get this:

Illegal instruction (core dumped)
Cannot access memory at address 0xb7f90654
/root/hlds/debug.cmds: Error in sourced command file:
Cannot access memory at address 0xb7f90654
email debug.log to [email protected]
Sat Dec 15 14:55:13 EET 2007: Server restart in 10 seconds


and in debug.log:

----------------------------------------------
CRASH: Sat Dec 15 15:01:09 EET 2007
Start Line: ./hlds_i486 -game cstrike +map cs_assault +maxplayers 14 -insecure -debug -pidfile hlds.7183.pid
Using host libthread_db library "/lib/libthread_db.so.1".
#0 0xb4e6f2dd in ?? ()
No symbol table info available.
End of crash report
----------------------------------------------

how can i fix? plz help me ;)
simas is offline
vvg125
AMX Mod X Beta Tester
Join Date: Dec 2006
Location: Queens (Douglaston), New
Old 12-15-2007 , 10:59   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #14

Quote:
Originally Posted by simas View Post
I can use 1.8.0 or 1.7.6c it doesn`t matters
Did you read any of this thread?
__________________
vvg125 is offline
Send a message via AIM to vvg125 Send a message via MSN to vvg125 Send a message via Yahoo to vvg125
simas
Junior Member
Join Date: Dec 2007
Old 12-15-2007 , 11:26   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #15

yes i read, maybe this threads not help with my problem, and maybe my post must not be in this topic, but i need help.I try download bug fix and
http://www.tcwonline.org/~dvander/testing/mysql_amxx-20071029-1.tar.gz it not works. So i decide ask
simas is offline
TheEagle
Junior Member
Join Date: Oct 2005
Old 12-15-2007 , 16:42   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #16

Quote:
Originally Posted by BAILOPAN View Post
I regret not seeing this support post earlier. Indeed, this was a bug addressed in the 1.8.1 automated builds (which are beta but stable).
I get the same debug message error only on 1.8.0 (and higher) after mapchanges, and it happens pretty regularly every 5-6 maps. Is that the error should be fixed? Or was MySQL not starting up at all with the bug you fixed?

Cause for me it's still happening with a nightly build from 3-4 days ago.
TheEagle is offline
Send a message via ICQ to TheEagle
alien
Senior Member
Join Date: Aug 2005
Location: London || Slovakia
Old 12-15-2007 , 20:01   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #17

My plugin with high sql traffic (~ 30 queries / minute) used to crash almost instantly. I'm using AMXX 1.8.0. After applying this patch, there was no crash for 3 days.

The problem might be on your side. Debug. Fix.
__________________
alien is offline
Send a message via ICQ to alien
TheEagle
Junior Member
Join Date: Oct 2005
Old 12-16-2007 , 10:47   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #18

Doesn't seem to be on my side ... I switched back to mysql module from 1.76(1.76b it says in the console) and I'm going towards the 20th map without a crash, where 1.8.0, 1.8.1 build 3674 and the module linked here in this thread will crash exactly at the change to the 5th oth 6th map in a row (not map dependant, happens on standrs and customs). I know that's no proof, but ...
TheEagle is offline
Send a message via ICQ to TheEagle
TheEagle
Junior Member
Join Date: Oct 2005
Old 12-18-2007 , 03:59   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #19

I can say for sure now that the server is running stable with 1.8.x IF i use the MySQL module from 1.76, the 1.8.0 and the "fixed" 1.8.1 still crash my server at mapchange on a not-empty server (probably it's the ban and/or admin plugin checking all players on the server at once).
TheEagle is offline
Send a message via ICQ to TheEagle
Nedo
Member
Join Date: Jun 2008
Old 08-06-2008 , 06:48   Re: AmxModX 1.8.0 + MySQL = CRASH
Reply With Quote #20

I am using Amxmodx 1.8.0 amxbans so there was some problem with SQL and i found that to solve the problem need to take mysql_amxx_i386.so from version 1.8.1. I did it... butmy zombie server always crash any time he want with segmentation fault error... i turned amxbans off and no change... chars... chras... crash...
Now i have problem with my DeathMatch server... this is first time for 1 mounth... he never crashed... but now... BOOM. I didnt do anything... he just crashed... and such error

Cannot access memory at address 0xb7f4e658
.../hlds_dm1/debug.cmds: Error in sourced command file:
Cannot access memory at address 0xb7f4e658

Amxbans wount work correctly with mysql_amxx_i386.so from 1.8.0 only from 1.8.1
So... any ideas how to fix this? Maybe change system? i have Ubuntu right now... thinking about Fedora or FreeBSD with linux emulator...
Nedo is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:01.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode