Timestamps are in GMT/BST.
[0:00] <osl> anyway if stendhal can be adapted so can the others
[0:03] <osl> parallel connections would mean noticeably improved server performance?
[0:06] <osl> well, imho it seems an interesting feature.
[0:06] <hendrik> at the moment any write operation to gameEvents kills the server.
[0:07] <hendrik> any write operation that takes more than 2 seconds, and mysql is extremly slow on large tables.
[0:07] <postman-bot> Tibi rented a sign saying "Buy lich/vampire cloaks"
[0:08] <osl> btw in the logs, hendrik, I read you cursing mysql for not implementing a certain feature :)
[0:09] <osl> do you think it would be worth considering alternatives like postgre sql or the code is too dependent on mysql features?
[0:09] <hendrik> at the moment it depends on mysql "features".
[0:10] <osl> "features" meaning oddities? :)
[0:10] <hendrik> mysql has documented all the strange behaivour, so one cannot easily call it bugs.
[0:11] <osl> hehehe
[0:11] <hendrik> the problem is that all databases have more or less strange behaviour.
[0:11] <hendrik> just like browsers before netscape gave up.
[0:12] <osl> there's that saying: "It's better bad known than good unknown" :)
[0:15] * durkham_ is now known as durkham
[0:20] * osl (i=5812311d@gateway/web/ajax/mibbit.com/x-055e1c0a3c6365c0) has left #arianne
[0:53] * durkham (n=durkham@c181126.adsl.hansenet.de) Quit (Read error: 104 (Connection reset by peer))
[1:20] * Bluelads4 (n=Bluelads@p5084D2E2.dip.t-dialin.net) has joined #arianne
[1:45] * Bluelads4 (n=Bluelads@p5084D2E2.dip.t-dialin.net) Quit ("When two people dream the same dream, it ceases to be an illusion. KVIrc 3.4.2 Shiny http://www.kvirc.net")
[6:20] <postman-bot> jeffre rented a sign saying "hi all i'm now two play"
[7:39] <postman-bot> butler rented a sign saying "i buy golden legs"
[8:54] * DeusFigendi (n=Deus@77.134.44.28) has joined #arianne
[9:44] * durkham (n=durkham@c181126.adsl.hansenet.de) has joined #arianne
[9:46] * erdnuggel (n=erdnugge@p5DD42FBF.dip.t-dialin.net) has joined #arianne
[11:44] <kymara> hendrik how long would the work take, do you estimate?
[11:45] * durkham_ (n=durkham@c181126.adsl.hansenet.de) has joined #arianne
[11:46] <kymara> osl the idiom in english, if you're interested, is 'better the devil you know'
[12:03] * durkham (n=durkham@c181126.adsl.hansenet.de) Quit (Read error: 110 (Connection timed out))
[12:04] * erdnuggel (n=erdnugge@p5DD42FBF.dip.t-dialin.net) Quit ()
[12:15] <hendrik> kymara, that's hard to tell, i am still thinking about how it should be.
[12:16] <hendrik> a simple way would be to throw away a lot of code and replace it with the DBHandlerPool/DBHandler classes from webflag. But I am not too happy of "throwing away and replacing" because this has a high risk in most cases.
[12:19] <kymara> ok. it would certainly be worth trying to get in touch with javydreamer so if you need help with this let me know
[12:20] <kymara> he has an ohloh project page, if you look for users of marauroa i think it came up
[12:21] <kymara> i dont object to teh refactoring and if the code is cleaned at the same time that is good and the possible server improvement would be very good, as well as the flexibility to do db write operations without killing the live game
[12:21] <kymara> bbl for now though
[12:39] <CIA-30> arianne_rpg: nhnb * stendhal/src/games/stendhal/tools/loganalyser/util/ResultSetIterator.java: fixed remove() in case hasNext() was called and the database allows going backwards through the resultset
[12:39] * madmetzger (n=markus@p5B03D1AF.dip.t-dialin.net) has joined #arianne
[13:17] * Bluelads4 (n=Bluelads@p5084D4AD.dip.t-dialin.net) has joined #arianne
[13:20] * durkham_ is now known as durkham
[13:41] <hendrik> madmetzger, durkham please have a look at http://stendhal.game-host.org/wiki/index.php/Refactoring_Database_Access_in_Marauroa
[13:42] <hendrik> the next step would be to split StendhalPlayerDB / JDBCDatabase into multiple classes and write subclasses for the the ResultSetRowToObject converter.
[13:43] <hendrik> The main idea is to have a DBConnectionPool which manages multiple connections.
[13:43] <hendrik> DBConnection replaces the old JDBCTransaction and Accessor/JDBCAccess classes.
[13:44] <hendrik> the methods in DBConnection get an SQL statement with [variables] and a map to provide values for them, of course with sql escaping.
[13:45] <hendrik> any comments?
[13:53] <durkham> when i was starting to refactor the stendhal part of it , i thought of putting (practically ) all db stuff into its own thread, so game does not have to wait for db .
[13:53] <durkham> your approach looks good to me
[13:54] <durkham> totally unconnected to this: i am going to leave stendhal
[13:54] <durkham> i will for sure be around if someone needs my expertise. but i stop as a developer and admin.
[13:55] <durkham> it is up to you if you still want me to be able to restart the main server or not
[13:55] <durkham> as i would do so if called
[14:23] <hendrik> i would like to have logging to gameEvents/itemlog in its own thread, so that other database opertions like loading and storing a player or zone are not blocked.
[14:25] <durkham> that is prepared in stendhal with the concurrentqueue for Gameevent. so if the underlying marauroa thingy would be able to handle it , i thinkit would be a big step forward for marauroa
[14:25] <durkham> itemlog could follow the same scheme, i think
[14:26] <hendrik> yes, the GameEvent changes look very good.
[19:47] * jf812 (n=jf812@5ad3a5a4.bb.sky.com) has joined #arianne
[19:48] * jf812 (n=jf812@5ad3a5a4.bb.sky.com) has left #arianne
[20:05] * hendrik (n=hendrik@h1400878.stratoserver.net) Quit (hubbard.freenode.net irc.freenode.net)
[20:06] * hendrik (n=hendrik@h1400878.stratoserver.net) has joined #arianne
[20:15] * erdnuggel (n=erdnugge@p5DD42FBF.dip.t-dialin.net) has joined #arianne
[20:42] * Maisu (i=5554b540@gateway/web/ajax/mibbit.com/x-0220739f07038b73) has joined #arianne
[20:42] <Maisu> hi!
[20:43] <Maisu> I start session but I get a grey screen
[20:43] <Maisu> I'm in Linux
[20:43] <Maisu> what can i do?
[20:45] <durkham> use sun java
[20:45] <Maisu> I'm installing
[20:45] <Maisu> thanks
[20:45] <durkham> yw
[20:46] <Maisu> I found the forum
[20:56] <Maisu> thank you! bye!
[20:56] * Maisu (i=5554b540@gateway/web/ajax/mibbit.com/x-0220739f07038b73) Quit ("http://www.mibbit.com ajax IRC Client")
[22:03] * erdnuggel (n=erdnugge@p5DD42FBF.dip.t-dialin.net) Quit ()
[23:05] * Alberto (i=5554b540@gateway/web/ajax/mibbit.com/x-2b94a9273da80245) has joined #arianne
[23:05] <Alberto> Hi!
[23:05] <Alberto> I have a problem with Stendhal
[23:06] * Alberto is now known as Guest65866
[23:06] <Guest65866> when i change the screen (I enter in a house for example) the game hangs
[23:06] <Guest65866> is there a solution?
[23:10] <hendrik> does it hang just for a second or longer?
[23:11] <Guest65866> longer
[23:11] <Guest65866> i must quit the game
[23:15] -NickServ- This nickname is registered. Please choose a different nickname, or identify via /msg NickServ identify <password>.
[23:15] * _eye_fill_in (n=PircBot@c142071.adsl.hansenet.de) has joined #arianne
[23:15] * Topic is 'Stendhal 0.74 and Marauroa 2.6.2 released: http://arianne.sourceforge.net/?arianne_url=games/game_stendhal#downloadsection][ public server: http://stendhal.game-host.org ][ want to chat?: /join #arianne-chat ] [ ANY QUESTIONS?: Just ask them and stick around in the channel, maybe an answer will pop up later ]'
[23:15] * Set by kymara on Sun May 24 21:09:53 CEST 2009
[23:15] <Guest65866> java.io.FileNotFoundException: log/stendhal.txt (No such file or directory)
[23:15] <Guest65866> I have this error
[23:15] <hendrik> ok, you can ignore that one.
[23:15] <Guest65866> no more errors
[23:16] <hendrik> there is no "log" directory so it cannot create that file.
[23:16] [freenode-connect VERSION]
[23:16] <hendrik> that is strange.
[23:16] <hendrik> It should log some error when it crashes with a black screen.
[23:16] * Disconnected.
[23:16] <Guest65866> there is not black screen
[23:16] <hendrik> What happens exactly?
[23:17] <Guest65866> nothing
[23:17] <Guest65866> I can not move
[23:21] * Guest65866 (i=5554b540@gateway/web/ajax/mibbit.com/session) Quit ("http://www.mibbit.com ajax IRC Client")
These logs were automatically created by _eye_fill_in on irc.freenode.net using the Java IRC LogBot.