*** IngBot has quit IRC | 05:21 | |
*** rossand has quit IRC | 06:13 | |
*** jmbp has joined #ingres | 06:37 | |
*** grantc_offline is now known as grantc | 07:42 | |
*** withdefault has joined #ingres | 07:43 | |
*** ChanServ sets mode: +o withdefault | 07:43 | |
*** jmbp has quit IRC | 08:05 | |
*** Gerhard has joined #ingres | 08:13 | |
*** jmbp has joined #ingres | 08:49 | |
*** Gerhard has left #ingres | 09:07 | |
pboro | hrr... we still have Tier 2 / 3 based subscriptions | 09:09 |
---|---|---|
pboro | I guess it's time to update :D | 09:09 |
satanmalin | time to update what ? | 09:11 |
satanmalin | i was through a torpor LOL | 09:12 |
satanmalin | im waking up | 09:12 |
satanmalin | pboro do we have to disconnect ? if you need to update the chan ? | 09:12 |
pboro | time to upgrade my organizations Ingres subscriptions | 09:13 |
satanmalin | oki LOL | 09:13 |
satanmalin | sorry | 09:13 |
pboro | nothing to do with the chan :) | 09:13 |
satanmalin | LOL oki | 09:13 |
pboro | no prob :) | 09:13 |
*** frima01 has joined #ingres | 09:17 | |
*** frima01 has quit IRC | 09:18 | |
*** grantc is now known as grantc_offline | 10:22 | |
*** grantc_offline is now known as grantc | 10:23 | |
*** toumi01 has joined #ingres | 10:28 | |
thiagomz | moning all | 10:41 |
thiagomz | guys, when i do a rollforwarddb, that information of the process is storaged in some log file ? | 10:42 |
thiagomz | i left a rollforwarddb running last night but my connection goes down... | 10:43 |
pboro | I suggest you use screen from now on :) | 10:54 |
satanmalin | hi again everyone | 11:00 |
*** Gerhard has joined #ingres | 11:00 | |
*** strk_away has joined #ingres | 11:17 | |
troal01 | Okay 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 #ingres | 11:58 | |
*** ChanServ sets mode: +o rossand | 11:58 | |
satanmalin | grantc sorry for disturbin you , is what i sent you yesterday is good ? shall i continue or shall i Stop ? | 12:00 |
grantc | hi satanmalin, i have not read it yet, when i finish what i am working on I will take a look at it | 12:01 |
satanmalin | oki thabks its just to know if i can cpontinue or must stop it LOL | 12:02 |
*** Alex|off is now known as Alex| | 12:10 | |
*** jmbp has quit IRC | 12:26 | |
*** strk_away is now known as strk | 12:36 | |
pboro | grantc, do you know if any sales guy from ingres uses irc? | 12:49 |
Alex| | never saw one here | 12:49 |
pboro | I guess they are the guys in suits who never use irc or even chats ;) | 12:50 |
Alex| | IR what.... :) | 12:50 |
satanmalin | LOL | 12:50 |
Alex| | it's hard enough to get them into company internal jabber | 12:50 |
satanmalin | pboro do ya think they know that this irc chan exists ? | 12:52 |
satanmalin | if 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 #ingres | 13:05 | |
Alex| | Hi jmbp | 13:06 |
*** strk has left #ingres | 13:07 | |
pboro | satanmalin, no idea :D | 13:08 |
*** mull has joined #ingres | 13:09 | |
pboro | any university ppl around who uses ingres? | 13:09 |
pboro | anyone know list price / cpu for Ingres? | 13:34 |
Alex| | $8000 | 13:34 |
pboro | why don't they publish any prices online :( | 13:34 |
pboro | oh, wow, that's a lot | 13:34 |
grantc | $7995 per socket | 13:34 |
pboro | Yeah. Just comparing to PostgreSQL... :) | 13:35 |
Alex| | http://www.ingres.com/tco/ | 13:35 |
pboro | thanks, didn't find that page earlier | 13:35 |
pboro | before | 13:35 |
grantc | pboro, have you emailed sales@ingres.com regarding education support | 13:36 |
pboro | nope... | 13:36 |
grantc | either that or info@ingres.com | 13:37 |
Alex| | education support? | 13:37 |
grantc | not sure which is best? | 13:37 |
grantc | trying not to use the word license | 13:37 |
pboro | subscription :) | 13:37 |
grantc | it used to be that universities got a good deal on software | 13:37 |
grantc | it may still be the case... | 13:38 |
grantc | pboro, oops :) | 13:38 |
Alex| | in theory there is a university program that Deb once started | 13:38 |
Alex| | not sure how that worked out | 13:38 |
*** DarylM has joined #ingres | 13:47 | |
grantc | has anyone here tried windows powershell? | 13:55 |
thiagomz | grantc: try cygwin ;) | 14:07 |
grantc | cute but not the answer i was looking for :) | 14:07 |
thiagomz | :D | 14:08 |
*** satanmalin has quit IRC | 14:20 | |
*** thiagomz has quit IRC | 14:20 | |
*** Nornagest has quit IRC | 14:20 | |
*** DarylM has quit IRC | 14:20 | |
*** Gerhard has quit IRC | 14:20 | |
*** jmbp has quit IRC | 14:20 | |
*** troal01 has quit IRC | 14:20 | |
*** Alex| has quit IRC | 14:20 | |
*** SlimeyPete has quit IRC | 14:20 | |
*** Alex| has joined #ingres | 14:20 | |
*** troal01 has joined #ingres | 14:20 | |
*** SlimeyPete has joined #ingres | 14:20 | |
*** irc.freenode.net sets mode: +o Alex| | 14:20 | |
*** thiagomz has joined #ingres | 14:22 | |
*** satanmalin has joined #ingres | 14:22 | |
satanmalin | is still someone alive ? | 14:24 |
grantc | yip | 14:24 |
*** Nornagest has joined #ingres | 14:29 | |
*** Gerhard has joined #ingres | 14:30 | |
*** [1]Gerhard has joined #ingres | 14:35 | |
*** DarylM has joined #ingres | 14:35 | |
*** jmbp has joined #ingres | 14:35 | |
*** DarylM has quit IRC | 14:36 | |
*** jmbp has quit IRC | 14:36 | |
*** [1]Gerhard has quit IRC | 14:36 | |
satanmalin | oki | 14:38 |
*** [1]Gerhard has joined #ingres | 14:41 | |
*** DarylM has joined #ingres | 14:41 | |
*** jmbp has joined #ingres | 14:41 | |
satanmalin | lol have you tested grant ?? sorry for insisting | 14:41 |
grantc | no not yet | 14:43 |
rossand | Hi 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 |
rossand | Next 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 IRC | 14:47 | |
*** [1]Gerhard has quit IRC | 14:47 | |
*** jmbp has quit IRC | 14:47 | |
*** jmbp has joined #ingres | 14:56 | |
troal01 | Let'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 IRC | 15:15 | |
*** Gerhard has quit IRC | 15:17 | |
*** frima01 has joined #ingres | 15:20 | |
*** toumi01 has joined #ingres | 15:26 | |
grantc | troal01, no | 15:29 |
grantc | :) | 15:29 |
grantc | see that was easy enough | 15:29 |
troal01 | Heh | 15:29 |
grantc | did you log a bug? | 15:29 |
troal01 | Okay here comes an even more annoying question, any ETA? | 15:29 |
troal01 | No because I could never track down where it was occuring | 15:29 |
grantc | a coredump would be nice/useful | 15:30 |
troal01 | Didn't I e-mail it to you? | 15:31 |
troal01 | Ah I didn't | 15:32 |
troal01 | Just the api log | 15:32 |
troal01 | Okay let's see if I can create a new coredump using 2.1.0 | 15:32 |
pboro | troal01, remember to set ulimit correctly so that you actually get the dump | 15:43 |
pboro | also, apache may need some additional tuning for it... | 15:43 |
grantc | pboro, apache needs to be setup to generate core files IIRC | 15:44 |
grantc | yet another brick wall i banged my head against | 15:44 |
troal01 | Hehe yeah I remember having to fight with that too | 15:44 |
pboro | grantc, pretty many programs disable core dumping by default | 15:45 |
grantc | pboro, really? | 15:46 |
grantc | i assumed that the base line control was via ulimit/limit | 15:46 |
pboro | yeah, 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 |
grantc | not sure ingres does that.. | 15:48 |
pboro | since core dumps don't usually make sense with software compiled without debugging etc. optimizations | 15:48 |
grantc | with the PC and a debug copy of the software / map files you can see where things go wrong | 15:49 |
* grantc used to do this on VMS :( | 15:49 | |
pboro | yeah, but in the world where everybody compile their programs by themselves or the distro compiled it, it's becoming pretty unuseful :/ | 15:50 |
grantc | fair comment | 15:50 |
*** toumi01 has left #ingres | 15:50 | |
troal01 | So much joy is had from setting up apache +php +ingres all over again | 15:58 |
pboro | :D | 15:58 |
troal01 | Stupid thing isn't recognizing my PassEnv II_SYSTEM | 15:58 |
pboro | use envvars for that? | 15:58 |
grantc | perhaps you are not passing it | 15:58 |
grantc | .g apache ingres debian | 15:59 |
grantc | hmm ingbot is dead | 15:59 |
pboro | although I'm not sure whether it gets passed through, at least you could try that | 15:59 |
*** toumi01 has joined #ingres | 15:59 | |
pboro | its /etc/apache2/envvars in Debian | 15:59 |
grantc | @g apache ingres debian | 15:59 |
ii_log | grantc: Error: "g" is not a valid command. | 15:59 |
grantc | @google apache ingres debian | 15:59 |
ii_log | grantc: 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 |
pboro | No instructions for Lenny?-) | 15:59 |
grantc | has it changed? | 16:00 |
*** toumi01 has left #ingres | 16:00 | |
*** satanmalin has quit IRC | 16:00 | |
pboro | Lenny was release couple months ago | 16:00 |
grantc | sure, has apache changed? | 16:00 |
pboro | It 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 similar | 16:00 |
pboro | ah, no no | 16:00 |
troal01 | I'm running Arch Linux | 16:00 |
pboro | lol :) | 16:01 |
grantc | pboro, good idea | 16:01 |
pboro | troal01, well you can prolly use the same info anyway | 16:01 |
pboro | oops I repeated my self, copy&pasting error... | 16:01 |
pboro | anyways :) now to home, 10 hours of work has passed... -> | 16:01 |
*** Alex| is now known as Alex|off | 16:05 | |
*** toumi01 has joined #ingres | 16:07 | |
troal01 | grantc: Okay I have a fresh core, it's again php 5.2.9, ingres-php 2.1.0 and apache 2.2.11 | 16:13 |
grantc | did you build the driver in debug? | 16:13 |
grantc | >) | 16:14 |
troal01 | Of course :) | 16:14 |
troal01 | Got nice line numbers and everything ion thar | 16:14 |
grantc | purty | 16:15 |
grantc | zip it up and put it somewhere useful for me to download | 16:15 |
grantc | and I will add it to the Q | 16:15 |
troal01 | I emailed it heh | 16:15 |
troal01 | And didn't zip | 16:15 |
troal01 | :( | 16:15 |
troal01 | It's not that big | 16:15 |
grantc | grr | 16:16 |
troal01 | Okay let me redo that sorry | 16:16 |
grantc | not to worry | 16:16 |
grantc | can you zip up the httpd binary as well | 16:17 |
troal01 | Sure | 16:17 |
troal01 | The httpd binary is only like 407k, is that right? | 16:18 |
grantc | i guess | 16:18 |
troal01 | Okay you can find it here: http://atrofast.dyndns.org/php-debug.tgz | 16:20 |
troal01 | Want me to email that addy? | 16:20 |
grantc | no that's fine | 16:21 |
troal01 | Thanks! | 16:21 |
grantc | there's no functions in that core dump | 16:23 |
grantc | can you make available /usr/lib/php/20060613/ingres.so | 16:24 |
troal01 | Oh okay | 16:24 |
troal01 | http://atrofast.dyndns.org/ingres.so | 16:25 |
troal01 | Didn't know core dumps where that tricky to transport :P | 16:26 |
grantc | you need all the symbols or at least the ones you care about... | 16:27 |
grantc | is php in debug too? | 16:27 |
grantc | also what is the version number of ingres.c? | 16:27 |
troal01 | 2.1.0 off the website | 16:27 |
grantc | not from cvs? | 16:28 |
troal01 | Nope | 16:28 |
troal01 | ingres.so should have teh symbols we care about i.e. where in the driver the crash happens | 16:28 |
troal01 | I can share libphp5.so if you weant me to | 16:28 |
grantc | crash happens 7 statements on from the driver | 16:29 |
troal01 | This is what it looks like to me: http://ingres.pastebin.com/m35a0c2f9 | 16:30 |
grantc | the driver is trying to free memory .. | 16:31 |
grantc | http://ingres.pastebin.com/mbf123f0 is what I see | 16:31 |
grantc | your box is 64bit? | 16:32 |
troal01 | Yep | 16:32 |
troal01 | I guess we're not compatible :) | 16:33 |
troal01 | I don't run any 32 bit machines anymore | 16:33 |
troal01 | Except Windows | 16:33 |
grantc | what a n00b i am | 16:33 |
troal01 | LOL! | 16:33 |
grantc | take http://ingres.pastebin.com/m109e3917 out for a spin | 16:34 |
*** Alex|off is now known as Alex| | 16:40 | |
troal01 | grantc: still crashes | 16:41 |
troal01 | same backtrace | 16:41 |
grantc | md5sum of the library? | 16:50 |
troal01 | ingres.so? | 16:50 |
grantc | yp | 16:50 |
troal01 | 493fc133f2cefe620297e4dc7d2e74d8 /usr/lib/php/20060613/ingres.so | 16:51 |
troal01 | That's 2.1.0 with only that patch applied | 16:52 |
grantc | yeah... | 16:52 |
grantc | the patch is based on 2.1.0 | 16:52 |
troal01 | It applied fine etc | 16:52 |
grantc | for some reason it believes that ii_result->dataBuffer is allocated or it gets corrupted | 16:53 |
grantc | is this with drupal? | 16:54 |
grantc | what line number do you have for frame #1? | 16:55 |
troal01 | grantc: at /home/troal01/ingres-2.1.0/ingres.c:6455 | 17:02 |
troal01 | That's frame #1 | 17:02 |
troal01 | And yes it's with drupal | 17:02 |
troal01 | I might have part of my code wrong, but I'd like a proper error message so I can debug :D | 17:02 |
grantc | sure - can you log a bug with http://pecl.php.net/ingres | 17:03 |
*** satanmalin has joined #ingres | 17:03 | |
satanmalin | back again | 17:03 |
satanmalin | i have a problem on the wiki page of ingres | 17:04 |
satanmalin | does someone know who is in charge of the wiki | 17:04 |
satanmalin | ? | 17:04 |
grantc | me | 17:04 |
grantc | or rather i know :) | 17:04 |
grantc | email community-admin@ingres.com | 17:05 |
satanmalin | oki | 17:06 |
satanmalin | its not a big probleme | 17:06 |
satanmalin | its just when I loggin the css is half charged or stuff like that | 17:06 |
grantc | it could be your connection - reload the page, do you see the same? | 17:07 |
*** Alex| is now known as Alex|off | 17:07 | |
grantc | it seems to load for me | 17:08 |
satanmalin | yep | 17:08 |
satanmalin | even if either i reload the page or i empty the cache | 17:09 |
satanmalin | i have a print scren if you want | 17:10 |
satanmalin | i have just sent it you | 17:11 |
satanmalin | it is strange | 17:11 |
troal01 | grantc: Okay filed a bug | 17:12 |
grantc | what firefox extensions do you have? | 17:12 |
grantc | thanks troal01 | 17:12 |
satanmalin | budistrust | 17:16 |
satanmalin | html validator | 17:16 |
satanmalin | distrust / html validator/ firebug | 17:16 |
satanmalin | and thats all folks | 17:17 |
grantc | if you disable them all ? | 17:17 |
grantc | firebug should be ok, I use that | 17:17 |
pboro | grantc, valgrind can be useful for debugging memory management problems | 17:20 |
grantc | pboro, thanks, i use it for standalone test cases | 17:20 |
pboro | I thought you do, but just making sure :) | 17:21 |
grantc | not sure how well it works with apache... | 17:21 |
satanmalin | noone | 17:21 |
satanmalin | none | 17:21 |
satanmalin | are disabled | 17:21 |
satanmalin | all are enabled | 17:21 |
grantc | can you disable them all and then retest | 17:21 |
pboro | grantc, http://bugs.php.net/bugs-getting-valgrind-log.php | 17:21 |
satanmalin | still the same | 17:22 |
grantc | cleared your caché? | 17:23 |
grantc | pboro, thanks | 17:23 |
satanmalin | yep | 17:23 |
pboro | apache 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 |
grantc | i guess i need to install the debug symbols for apache | 17:23 |
grantc | yeah | 17:23 |
pboro | it's not too easy but hey, it's debugging... :) | 17:24 |
grantc | was not aware of the USE_ZEND_ALLOC flag | 17:24 |
grantc | yeah | 17:24 |
pboro | A bit of warning... PHP leaks all over :D | 17:26 |
pboro | so it may be hard | 17:26 |
pboro | don't know about the latest 5.2 but at least 5.1 did | 17:26 |
grantc | valgrind is good enough to comment on my code, the rest i don't care about :) | 17:26 |
pboro | hehe :) | 17:26 |
satanmalin | ill i dont know if its normal or not just to help | 17:27 |
grantc | satanmalin, it's not normal | 17:27 |
grantc | does internet explorer show the same? | 17:27 |
satanmalin | but what is strange | 17:27 |
satanmalin | Inter what ?????? LOL | 17:27 |
satanmalin | i have something very strange | 17:27 |
satanmalin | if im not logged the page is super | 17:28 |
satanmalin | once logged in I have what i sent you | 17:28 |
grantc | i know what the problem is .... | 17:29 |
satanmalin | it is ... | 17:29 |
grantc | you need to change the skin in your preferences | 17:30 |
grantc | i guess it has been a long time since you logged in? | 17:30 |
grantc | http://community.ingres.com/wiki/Special:Preferences - choose monobook | 17:31 |
satanmalin | yep | 17:31 |
satanmalin | LOl oki | 17:32 |
satanmalin | thanks | 17:32 |
satanmalin | thought it was a prob it was just to help | 17:33 |
satanmalin | really sorry grant | 18:04 |
satanmalin | LOL | 18:04 |
satanmalin | but there still something that disapear within the page | 18:05 |
*** stephen1 has joined #ingres | 18:15 | |
*** stephenb has quit IRC | 18:30 | |
*** grantc is now known as grantc_offline | 18:32 | |
*** jmbp has quit IRC | 18:34 | |
*** jmbp has joined #ingres | 18:42 | |
*** Alex|off is now known as Alex| | 18:53 | |
satanmalin | ill be off for about 1 week due to Solution linux c ya all | 19:14 |
*** satanmalin has quit IRC | 19:15 | |
SlimeyPete | he seems helpful, but he's an odd fellow O.o | 19:15 |
Alex| | :) grantc's padawan | 19:16 |
pboro | :D | 19:16 |
troal01 | Hehe | 19:17 |
troal01 | Very talkative :) | 19:17 |
troal01 | Where is he from anyway? | 19:17 |
Alex| | France | 19:17 |
troal01 | Cool :) | 19:17 |
*** satanmalin has joined #ingres | 19:26 | |
satanmalin | back until my departure | 19:27 |
*** jmbp has quit IRC | 19:29 | |
satanmalin | just here to stay thanks for all your supports | 19:34 |
satanmalin | ill be back bye c ya in 1 week | 19:39 |
*** satanmalin has quit IRC | 19:39 | |
troal01 | Ingres can't handle a SELECT COUNT(*) FROM (subselect) if subselect has ORDER BY in it? | 19:41 |
pboro | why use order by on that? :-o | 19:41 |
troal01 | Well you wouldn't normally | 19:42 |
troal01 | But Trac takes the easy way out since it has a pre-built statement | 19:42 |
troal01 | And it wants to know how many rows it would return | 19:42 |
pboro | ahh | 19:42 |
troal01 | so it just takes SELECT COUNT(*) FROM (subselect) | 19:42 |
troal01 | Just happens that the subselect has order by in it | 19:42 |
* troal01 is making an Ingres patch for 0.11.3 | 19:43 | |
pboro | nice :) | 19:44 |
troal01 | Everything works except the pre-defined reports :( | 19:45 |
pboro | yup | 19:45 |
pboro | fixing ingres would be great but it will delay the ingres support a bit... | 19:45 |
troal01 | Yeah, seems this kind of query is supported by sqlite, postgres and mysql | 19:46 |
troal01 | Trac officially supports those three | 19:46 |
pboro | Yup, I use Trac at work for simple project management. On sqlite tho' :) | 19:47 |
troal01 | sqlite is easiest for sure | 19:48 |
pboro | it works, so why bother trying something else :> | 19:50 |
troal01 | For smaller projects sure... I think you'd probably hit the wall if you had a lot of activity though | 19:51 |
pboro | yeah, most likely | 19:52 |
pboro | for such MySQL works best... I hate Ingres since it still lacks MVCC, which is very good for web applications | 19:52 |
troal01 | I do believe we're working on MVCC support | 19:53 |
pboro | yes I've seen some mentions about it, I really hope they make it well | 19:54 |
*** rossand1 has joined #ingres | 20:37 | |
*** rossand1 has quit IRC | 20:42 | |
*** troal01 has quit IRC | 21:01 | |
*** rossand has quit IRC | 21:04 | |
*** troal01 has joined #ingres | 21:35 | |
*** Alex| is now known as Alex|off | 21:36 | |
*** mull has quit IRC | 23:26 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!