Thursday, 2009-03-26

*** IngBot has quit IRC05:21
*** rossand has quit IRC06:13
*** jmbp has joined #ingres06:37
*** grantc_offline is now known as grantc07:42
*** withdefault has joined #ingres07:43
*** ChanServ sets mode: +o withdefault07:43
*** jmbp has quit IRC08:05
*** Gerhard has joined #ingres08:13
*** jmbp has joined #ingres08:49
*** Gerhard has left #ingres09:07
pborohrr... we still have Tier 2 / 3 based subscriptions09:09
pboroI guess it's time to update :D09:09
satanmalintime to update what ?09:11
satanmalini was through a torpor LOL09:12
satanmalinim waking up09:12
satanmalinpboro do we have to disconnect ? if you need to update the chan ?09:12
pborotime to upgrade my organizations Ingres subscriptions09:13
satanmalinoki LOL09:13
satanmalinsorry09:13
pboronothing to do with the chan :)09:13
satanmalinLOL oki09:13
pborono prob :)09:13
*** frima01 has joined #ingres09:17
*** frima01 has quit IRC09:18
*** grantc is now known as grantc_offline10:22
*** grantc_offline is now known as grantc10:23
*** toumi01 has joined #ingres10:28
thiagomzmoning all10:41
thiagomzguys, when i do a rollforwarddb, that information of the process  is storaged in some log file ?10:42
thiagomzi left a rollforwarddb running last night but my connection goes down...10:43
pboroI suggest you use screen from now on :)10:54
satanmalinhi again everyone11:00
*** Gerhard has joined #ingres11:00
*** strk_away has joined #ingres11:17
troal01Okay so my verifydb didn't help me repair any corruption, is there any way to write a script that can pull out data from the actual files Ingres stores them in? in data/default/dbname/11:34
*** rossand has joined #ingres11:58
*** ChanServ sets mode: +o rossand11:58
satanmalingrantc sorry for disturbin you , is what i sent you yesterday is good ? shall i continue or shall i Stop ?12:00
grantchi satanmalin, i have not read it yet, when i finish what i am working on I will take a look at it12:01
satanmalinoki thabks its just to know if i can cpontinue or must stop it LOL12:02
*** Alex|off is now known as Alex|12:10
*** jmbp has quit IRC12:26
*** strk_away is now known as strk12:36
pborograntc, do you know if any sales guy from ingres uses irc?12:49
Alex|never saw one here12:49
pboroI guess they are the guys in suits who never use irc or even chats ;)12:50
Alex|IR what.... :)12:50
satanmalinLOL12:50
Alex|it's hard enough to get them into company internal jabber12:50
satanmalinpboro do ya think they know that this irc chan exists ?12:52
satanmalinif grant didn't told me about this chan , iwon't be here (diont blame grant to gave the adress chan to a b*ll breaker like me ROFL)12:55
*** jmbp has joined #ingres13:05
Alex|Hi jmbp13:06
*** strk has left #ingres13:07
pborosatanmalin, no idea :D13:08
*** mull has joined #ingres13:09
pboroany university ppl around who uses ingres?13:09
pboroanyone know list price / cpu for Ingres?13:34
Alex|$800013:34
pborowhy don't they publish any prices online :(13:34
pborooh, wow, that's a lot13:34
grantc$7995 per socket13:34
pboroYeah. Just comparing to PostgreSQL... :)13:35
Alex|http://www.ingres.com/tco/13:35
pborothanks, didn't find that page earlier13:35
pborobefore13:35
grantcpboro, have you emailed sales@ingres.com regarding education support13:36
pboronope...13:36
grantceither that or info@ingres.com13:37
Alex|education support?13:37
grantcnot sure which is best?13:37
grantctrying not to use the word license13:37
pborosubscription :)13:37
grantcit used to be that universities got a good deal on software13:37
grantcit may still be the case...13:38
grantcpboro, oops :)13:38
Alex|in theory there is a university program that Deb once started13:38
Alex|not sure how that worked out13:38
*** DarylM has joined #ingres13:47
grantchas anyone here tried windows powershell?13:55
thiagomzgrantc: try cygwin ;)14:07
grantccute but not the answer i was looking for :)14:07
thiagomz:D14:08
*** satanmalin has quit IRC14:20
*** thiagomz has quit IRC14:20
*** Nornagest has quit IRC14:20
*** DarylM has quit IRC14:20
*** Gerhard has quit IRC14:20
*** jmbp has quit IRC14:20
*** troal01 has quit IRC14:20
*** Alex| has quit IRC14:20
*** SlimeyPete has quit IRC14:20
*** Alex| has joined #ingres14:20
*** troal01 has joined #ingres14:20
*** SlimeyPete has joined #ingres14:20
*** irc.freenode.net sets mode: +o Alex|14:20
*** thiagomz has joined #ingres14:22
*** satanmalin has joined #ingres14:22
satanmalinis still someone alive ?14:24
grantcyip14:24
*** Nornagest has joined #ingres14:29
*** Gerhard has joined #ingres14:30
*** [1]Gerhard has joined #ingres14:35
*** DarylM has joined #ingres14:35
*** jmbp has joined #ingres14:35
*** DarylM has quit IRC14:36
*** jmbp has quit IRC14:36
*** [1]Gerhard has quit IRC14:36
satanmalinoki14:38
*** [1]Gerhard has joined #ingres14:41
*** DarylM has joined #ingres14:41
*** jmbp has joined #ingres14:41
satanmalinlol have you tested grant ?? sorry for insisting14:41
grantcno not yet14:43
rossandHi Everyone. If you're interested in voting up/down or suggesting questions for next week's open source leaders panel (with Roger Burkhardt) please visit: http://www.fosslc.org/drupal/node/359 Thanks.14:45
rossandNext week's event has a handful of senior leaders from open source companies talking about business & government use of open source. Should be a great discussion.14:46
*** DarylM has quit IRC14:47
*** [1]Gerhard has quit IRC14:47
*** jmbp has quit IRC14:47
*** jmbp has joined #ingres14:56
troal01Let's make this bug grantc to do stuff day, did you ever find the root cause of the PHP driver crashing on me? :)15:04
*** toumi01 has quit IRC15:15
*** Gerhard has quit IRC15:17
*** frima01 has joined #ingres15:20
*** toumi01 has joined #ingres15:26
grantctroal01, no15:29
grantc:)15:29
grantcsee that was easy enough15:29
troal01Heh15:29
grantcdid you log a bug?15:29
troal01Okay here comes an even more annoying question, any ETA?15:29
troal01No because I could never track down where it was occuring15:29
grantca coredump would be nice/useful15:30
troal01Didn't I e-mail it to you?15:31
troal01Ah I didn't15:32
troal01Just the api log15:32
troal01Okay let's see if I can create a new coredump using 2.1.015:32
pborotroal01, remember to set ulimit correctly so that you actually get the dump15:43
pboroalso, apache may need some additional tuning for it...15:43
grantcpboro, apache needs to be setup to generate core files IIRC15:44
grantcyet another brick wall i banged my head against15:44
troal01Hehe yeah I remember having to fight with that too15:44
pborograntc, pretty many programs disable core dumping by default15:45
grantcpboro, really?15:46
grantci assumed that the base line control was via ulimit/limit15:46
pboroyeah, relying on the systems' ulimits was the way in the 90s, but by my experience most common server software nowadays set ulimit by themselves to prevent core dumping by default :/15:48
grantcnot sure ingres does that..15:48
pborosince core dumps don't usually make sense with software compiled without debugging etc. optimizations15:48
grantcwith the PC and a debug copy of the software / map files you can see where things go wrong15:49
* grantc used to do this on VMS :(15:49
pboroyeah, but in the world where everybody compile their programs by themselves or the distro compiled it, it's becoming pretty unuseful :/15:50
grantcfair comment15:50
*** toumi01 has left #ingres15:50
troal01So much joy is had from setting up apache +php +ingres all over again15:58
pboro:D15:58
troal01Stupid thing isn't recognizing my PassEnv II_SYSTEM15:58
pborouse envvars for that?15:58
grantcperhaps you are not passing it15:58
grantc.g apache ingres debian15:59
grantchmm ingbot is dead15:59
pboroalthough I'm not sure whether it gets passed through, at least you could try that15:59
*** toumi01 has joined #ingres15:59
pboroits /etc/apache2/envvars in Debian15:59
grantc@g apache ingres debian15:59
ii_loggrantc: Error: "g" is not a valid command.15:59
grantc@google apache ingres debian15:59
ii_loggrantc: Search took 0.29 seconds: Ingres with Apache on Debian Etch - Ingres Community Wiki: <http://community.ingres.com/wiki/Ingres_with_Apache_on_Debian_Etch>; PHP & Ingres II_SYSTEM not defined - Ingres Community Forums: <http://community.ingres.com/forum/database-drivers-apis/1997-php-ingres-ii_system-not-defined.html>; CA executive steers Ingres on open source waters :: OSDir.com ...: (3 more messages)15:59
pboroNo instructions for Lenny?-)15:59
grantchas it changed?16:00
*** toumi01 has left #ingres16:00
*** satanmalin has quit IRC16:00
pboroLenny was release couple months ago16:00
grantcsure, has apache changed?16:00
pboroIt could be good idea to rename the page "Ingres with Apache on Debian Etch" to "It could be good idea to rename the page "Ingres with Apache on Debian" and make Etch and Lenny just subsections or similar16:00
pboroah, no no16:00
troal01I'm running Arch Linux16:00
pborolol :)16:01
grantcpboro, good idea16:01
pborotroal01, well you can prolly use the same info anyway16:01
pborooops I repeated my self, copy&pasting error...16:01
pboroanyways :) now to home, 10 hours of work has passed... ->16:01
*** Alex| is now known as Alex|off16:05
*** toumi01 has joined #ingres16:07
troal01grantc: Okay I have a fresh core, it's again php 5.2.9, ingres-php 2.1.0 and apache 2.2.1116:13
grantcdid you build the driver in debug?16:13
grantc>)16:14
troal01Of course :)16:14
troal01Got nice line numbers and everything ion thar16:14
grantcpurty16:15
grantczip it up and put it somewhere useful for me to download16:15
grantcand I will add it to the Q16:15
troal01I emailed it heh16:15
troal01And didn't zip16:15
troal01:(16:15
troal01It's not that big16:15
grantcgrr16:16
troal01Okay let me redo that sorry16:16
grantcnot to worry16:16
grantccan you zip up the httpd binary as well16:17
troal01Sure16:17
troal01The httpd binary is only like 407k, is that right?16:18
grantci guess16:18
troal01Okay you can find it here: http://atrofast.dyndns.org/php-debug.tgz16:20
troal01Want me to email that addy?16:20
grantcno that's fine16:21
troal01Thanks!16:21
grantcthere's no functions in that core dump16:23
grantccan you make available /usr/lib/php/20060613/ingres.so16:24
troal01Oh okay16:24
troal01http://atrofast.dyndns.org/ingres.so16:25
troal01Didn't know core dumps where that tricky to transport :P16:26
grantcyou need all the symbols or at least the ones you care about...16:27
grantcis php in debug too?16:27
grantcalso what is the version number of ingres.c?16:27
troal012.1.0 off the website16:27
grantcnot from cvs?16:28
troal01Nope16:28
troal01ingres.so should have teh symbols we care about i.e. where in the driver the crash happens16:28
troal01I can share libphp5.so if you weant me to16:28
grantccrash happens 7 statements on from the driver16:29
troal01This is what it looks like to me: http://ingres.pastebin.com/m35a0c2f916:30
grantcthe driver is trying to free memory ..16:31
grantchttp://ingres.pastebin.com/mbf123f0 is what I see16:31
grantcyour box is 64bit?16:32
troal01Yep16:32
troal01I guess we're not compatible :)16:33
troal01I don't run any 32 bit machines anymore16:33
troal01Except Windows16:33
grantcwhat a n00b i am16:33
troal01LOL!16:33
grantctake http://ingres.pastebin.com/m109e3917 out for a spin16:34
*** Alex|off is now known as Alex|16:40
troal01grantc: still crashes16:41
troal01same backtrace16:41
grantcmd5sum of the library?16:50
troal01ingres.so?16:50
grantcyp16:50
troal01493fc133f2cefe620297e4dc7d2e74d8  /usr/lib/php/20060613/ingres.so16:51
troal01That's 2.1.0 with only that patch applied16:52
grantcyeah...16:52
grantcthe patch is based on 2.1.016:52
troal01It applied fine etc16:52
grantcfor some reason it believes that ii_result->dataBuffer is allocated or it gets corrupted16:53
grantcis this with drupal?16:54
grantcwhat line number do you have for frame #1?16:55
troal01grantc:     at /home/troal01/ingres-2.1.0/ingres.c:645517:02
troal01That's frame #117:02
troal01And yes it's with drupal17:02
troal01I might have part of my code wrong, but I'd like a proper error message so I can debug :D17:02
grantcsure - can you log a bug with http://pecl.php.net/ingres17:03
*** satanmalin has joined #ingres17:03
satanmalinback again17:03
satanmalini have a problem on the wiki page of ingres17:04
satanmalindoes someone know who is in charge of the wiki17:04
satanmalin?17:04
grantcme17:04
grantcor rather i know :)17:04
grantcemail community-admin@ingres.com17:05
satanmalinoki17:06
satanmalinits not a big probleme17:06
satanmalinits just when I loggin the css is half charged or stuff like that17:06
grantcit could be your connection - reload the page, do you see the same?17:07
*** Alex| is now known as Alex|off17:07
grantcit seems to load for me17:08
satanmalinyep17:08
satanmalineven if either i reload the page or i empty the cache17:09
satanmalini have a print scren if you want17:10
satanmalini have just sent it you17:11
satanmalinit is strange17:11
troal01grantc: Okay filed a bug17:12
grantcwhat firefox extensions do you have?17:12
grantcthanks troal0117:12
satanmalin budistrust17:16
satanmalinhtml validator17:16
satanmalindistrust / html validator/ firebug17:16
satanmalinand thats all folks17:17
grantcif you disable them all ?17:17
grantcfirebug should be ok, I use that17:17
pborograntc, valgrind can be useful for debugging memory management problems17:20
grantcpboro, thanks, i use it for standalone test cases17:20
pboroI thought you do, but just making sure :)17:21
grantcnot sure how well it works with apache...17:21
satanmalinnoone17:21
satanmalinnone17:21
satanmalinare disabled17:21
satanmalinall are enabled17:21
grantccan you disable them all and then retest17:21
pborograntc, http://bugs.php.net/bugs-getting-valgrind-log.php17:21
satanmalinstill the same17:22
grantccleared your caché?17:23
grantcpboro, thanks17:23
satanmalinyep17:23
pboroapache can even be left out by using cli/cgi version to run just the problematic PHP file (if no GET/POST input is needed)17:23
grantci guess i need to install the debug symbols for apache17:23
grantcyeah17:23
pboroit's not too easy but hey, it's debugging... :)17:24
grantcwas not aware of the USE_ZEND_ALLOC flag17:24
grantcyeah17:24
pboroA bit of warning... PHP leaks all over :D17:26
pboroso it may be hard17:26
pborodon't know about the latest 5.2 but at least 5.1 did17:26
grantcvalgrind is good enough to comment on my code, the rest i don't care about :)17:26
pborohehe :)17:26
satanmalinill i dont know if its normal or not just to help17:27
grantcsatanmalin, it's not normal17:27
grantcdoes internet explorer show the same?17:27
satanmalinbut what is strange17:27
satanmalinInter what ?????? LOL17:27
satanmalini have something very strange17:27
satanmalinif im not logged the page is super17:28
satanmalinonce logged in I have what i sent you17:28
grantci know what the problem is ....17:29
satanmalinit is ...17:29
grantcyou need to change the skin in your preferences17:30
grantci guess it has been a long time since you logged in?17:30
grantchttp://community.ingres.com/wiki/Special:Preferences - choose monobook17:31
satanmalinyep17:31
satanmalinLOl oki17:32
satanmalinthanks17:32
satanmalinthought it was a prob it was just to help17:33
satanmalinreally sorry grant18:04
satanmalinLOL18:04
satanmalinbut there still something that disapear within the page18:05
*** stephen1 has joined #ingres18:15
*** stephenb has quit IRC18:30
*** grantc is now known as grantc_offline18:32
*** jmbp has quit IRC18:34
*** jmbp has joined #ingres18:42
*** Alex|off is now known as Alex|18:53
satanmalinill be off for about 1 week due to Solution linux c ya all19:14
*** satanmalin has quit IRC19:15
SlimeyPetehe seems helpful, but he's an odd fellow O.o19:15
Alex|:) grantc's padawan19:16
pboro:D19:16
troal01Hehe19:17
troal01Very talkative :)19:17
troal01Where is he from anyway?19:17
Alex|France19:17
troal01Cool :)19:17
*** satanmalin has joined #ingres19:26
satanmalinback until my departure19:27
*** jmbp has quit IRC19:29
satanmalinjust here to stay thanks for all your supports19:34
satanmalinill be back bye c ya in 1 week19:39
*** satanmalin has quit IRC19:39
troal01Ingres can't handle a SELECT COUNT(*) FROM (subselect) if subselect has ORDER BY in it?19:41
pborowhy use order by on that? :-o19:41
troal01Well you wouldn't normally19:42
troal01But Trac takes the easy way out since it has a pre-built statement19:42
troal01And it wants to know how many rows it would return19:42
pboroahh19:42
troal01so it just takes SELECT COUNT(*) FROM (subselect)19:42
troal01Just happens that the subselect has order by in it19:42
* troal01 is making an Ingres patch for 0.11.319:43
pboronice :)19:44
troal01Everything works except the pre-defined reports :(19:45
pboroyup19:45
pborofixing ingres would be great but it will delay the ingres support a bit...19:45
troal01Yeah, seems this kind of query is supported by sqlite, postgres and mysql19:46
troal01Trac officially supports those three19:46
pboroYup, I use Trac at work for simple project management. On sqlite tho' :)19:47
troal01sqlite is easiest for sure19:48
pboroit works, so why bother trying something else :>19:50
troal01For smaller projects sure... I think you'd probably hit the wall if you had a lot of activity though19:51
pboroyeah, most likely19:52
pborofor such MySQL works best... I hate Ingres since it still lacks MVCC, which is very good for web applications19:52
troal01I do believe we're working on MVCC support19:53
pboroyes I've seen some mentions about it, I really hope they make it well19:54
*** rossand1 has joined #ingres20:37
*** rossand1 has quit IRC20:42
*** troal01 has quit IRC21:01
*** rossand has quit IRC21:04
*** troal01 has joined #ingres21:35
*** Alex| is now known as Alex|off21:36
*** mull has quit IRC23:26

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!