*** clach04 has quit IRC | 02:03 | |
*** atrofast1 has joined #ingres | 02:22 | |
atrofast1 | Anyone still awake? Is there any way to check in Ingres how much size a table takes on the disk? | 02:23 |
---|---|---|
atrofast1 | I guess #pages x page size would tell me? | 02:24 |
*** atrofast1 has quit IRC | 05:23 | |
*** Alex|off is now known as Alex| | 06:16 | |
*** janschi has joined #ingres | 06:54 | |
*** withdefault has quit IRC | 06:58 | |
*** Alex| is now known as Alex|off | 06:58 | |
*** janschi has quit IRC | 06:59 | |
*** Alex|off is now known as Alex| | 07:12 | |
*** grantc_offline has quit IRC | 07:33 | |
*** grantc has joined #ingres | 07:34 | |
*** withdefault has joined #ingres | 07:35 | |
*** ChanServ sets mode: +o grantc | 07:35 | |
*** ChanServ sets mode: +o withdefault | 07:35 | |
*** eriksnoeijs has joined #ingres | 08:03 | |
*** Alex| is now known as Alex|off | 08:32 | |
*** Alex|off is now known as Alex| | 08:41 | |
*** MagnusG| has joined #ingres | 09:04 | |
*** Alex| is now known as Alex|off | 09:14 | |
*** Alex|off is now known as Alex| | 09:17 | |
withdefault | Hi All, Anyone here planning to attend the UK IUA on June 9? | 09:17 |
MagnusG| | Our company will be represented by my colleague Kenneth who will give a presentation about OpenROAD and XML. Looking at the agenda I'd love to be there but no chance. | 09:29 |
MagnusG| | The good thing is that I wan't have to choose between listening to Peter Gale on trace point sc930 and the Ingres Roadmap discussion :-) | 09:31 |
grantc | perhaps someone can give us a live feed of the roadmap discussion | 09:35 |
grantc | :) | 09:35 |
* withdefault wonders if I can type that fast | 09:55 | |
* grantc knows that withdefault is good at taking notes :) | 09:57 | |
grantc | or setup a twitter account ? | 09:57 |
*** PaulM05 has joined #ingres | 10:20 | |
eriksnoeijs | sorry for the beginners question, but i've just got ingres running and wanted to do some queries on the demodb. So i fired up isql and had no idea what to do next. I tried SHOW TABLES; But i guess that's a mysql only thing perhaps. | 10:25 |
eriksnoeijs | ah, nevermind. I should have googled some more. | 10:26 |
eriksnoeijs | or just have listened to my instincts and typed in HELP :) | 10:27 |
grantc | hi eriksnoeijs - glad you got ingres working in the end :) | 10:28 |
eriksnoeijs | yeah. your help was very much appriciated. | 10:29 |
grantc | np | 10:29 |
*** atrofast has quit IRC | 10:43 | |
Alex| | is there a list of reserved keywords in Ingres? | 12:05 |
Alex| | customer tried to create table test (tid integer) - which did not work because of tid... now he's asking what other keywords he needs to know of | 12:06 |
grantc | Alex|, i think tid is the only one... | 12:06 |
grantc | you can have "create table table (integer integer not null...) | 12:07 |
Alex| | yeah, context sensitve parser... but are there other cases like the one above? | 12:07 |
grantc | tid is the only exception since it is an actual column, hidden as you probably know | 12:07 |
grantc | not that i am aware of | 12:08 |
Alex| | I guess as long as he doesn't try to create ii_ tables... | 12:08 |
grantc | E_US13FC CREATE TABLE: Illegal tablename 'ii_table'. 'ii' is reserved for system catalogs. | 12:08 |
Alex| | yup | 12:08 |
grantc | create table tid (integer integer not null)\g is valid | 12:08 |
PaulM05 | is that on the forums - I just responded to that | 12:15 |
grantc | Alex|, is that your sock puppet? ;) | 12:16 |
Alex| | link? | 12:16 |
grantc | http://community.ingres.com/forum/migration-forum/2613-how-escape-reserved-words-column-names.html#post10121 | 12:17 |
Alex| | ah hehe... yeah, that's the one :) | 12:17 |
Alex| | impatient guy... | 12:17 |
PaulM05 | kicker is the customer? | 12:18 |
Alex| | yes | 12:18 |
PaulM05 | there are lists of reserved words in the back of the SQL Guide IIRC | 12:18 |
PaulM05 | yep - Appendix A Keywords | 12:19 |
grantc | PaulM05, with the syntax sensitive parser it should be less of an issue now, with the exception of "tid" right? | 12:19 |
Alex| | well, he don't really needs it... he's got an existing schema and fears that half of his column and table names are reserved | 12:19 |
PaulM05 | yes it should | 12:19 |
PaulM05 | there used to be a script that checked for reserved words | 12:20 |
eriksnoeijs | hmm. I was toying around a bit and got caught by the following. I'm using the PHP module to talk to ingres and was getting some errors because of that the close function never got called. Then after some mucking about i could no longer connect because the user limit was exceeded. | 12:25 |
PaulM05 | KB doc 265156 for those with ServiceDesk access - but shouldn't be needed now for reasons given by Grant | 12:25 |
eriksnoeijs | So am i correct to assume that ingres session don't close by themselves? | 12:25 |
grantc | eriksnoeijs, ingres_connect() or ingres_pconnect() ? | 12:25 |
eriksnoeijs | ingres_connect() | 12:26 |
grantc | they should be closed at the end of the request | 12:26 |
eriksnoeijs | hmmm, well apparently it doesnt. It was however spouting warnings about not being able to close because of active queries. | 12:27 |
grantc | in fact when the connect resource is freed | 12:27 |
eriksnoeijs | Was trying inserts. | 12:27 |
grantc | hmm - which release of the driver do you have? | 12:27 |
grantc | the driver forces a close at the end of a page request unless the connection is persistent | 12:27 |
eriksnoeijs | ingres extension version: 2.1.0 revision 1.14 openAPI version 6 | 12:28 |
grantc | hmmm | 12:28 |
grantc | apache2-prefork or mpm? | 12:29 |
grantc | not that it should make much difference... | 12:29 |
grantc | ok - can you paste some code into http://ingres.pastebin.com ? | 12:33 |
grantc | using http://ingres.pastebin.com/f7565ff1f i cannot see the sessions stick around | 12:34 |
eriksnoeijs | I think preform, not sure just installed the default ubuntu LAMP stack. didn't pay much attention. I'll try the code, just a moment. | 12:37 |
grantc | prefork is what i used, partly because mpm is not recommended | 12:38 |
*** PaulM05 has quit IRC | 12:39 | |
*** atrofast has joined #ingres | 12:39 | |
*** PaulM05 has joined #ingres | 12:40 | |
grantc | hello atrofast | 12:40 |
eriksnoeijs | this was my code. http://ingres.pastebin.com/d50cec3b4 It failed on the insert because of the missing ID. | 12:41 |
eriksnoeijs | Your code worked. (after restarting ingres to get some new/free sessions) | 12:42 |
*** toumi01 has joined #ingres | 12:44 | |
atrofast | Morning grantc | 12:47 |
atrofast | Just on for a couple of minutes, then I gotta jet again | 12:47 |
grantc | no problem - good news/bad news re drupal | 12:48 |
grantc | which one do you want first :) | 12:48 |
atrofast | Good news | 12:49 |
grantc | i think i know what the problem is | 12:49 |
atrofast | That's great :) so what's the bad news? | 12:49 |
grantc | its going to be a real b1tch to fix | 12:49 |
atrofast | Ouch! | 12:49 |
atrofast | Will you need some assistance? | 12:49 |
grantc | perhaps... | 12:50 |
grantc | i can get the installer to complete when i run apache through valgrind | 12:50 |
grantc | but i get some interesting messages - writing to memory that was freed | 12:50 |
grantc | it has to do with the result resources and how they are cleared up.. obviously not very well :( | 12:52 |
atrofast | Interesting | 12:53 |
atrofast | I love those errors :P | 12:53 |
atrofast | Can Valgrind pinpoint which pointer it is? | 12:53 |
grantc | eriksnoeijs, i get http://ingres.pastebin.com/d62bc597 | 12:53 |
atrofast | Can I modified Drupal to work around it somehow you thin? | 12:54 |
grantc | its the result resource in general | 12:54 |
grantc | not sure you can | 12:54 |
grantc | eriksnoeijs, my output is a bit more verbose since i have xdebug installed but i see the error you get | 12:55 |
atrofast | Okay thanks grantc. I've gotta run, drop me an email if you want me to look at something in code to help you out | 12:56 |
eriksnoeijs | Well my problem is not in so much that my code is faulty. Heck most of the time i expect my code to be faulty :) However the fact that ingres did not release the user session could be a bit of a bad point. | 12:56 |
*** atrofast has left #ingres | 12:56 | |
grantc | eriksnoeijs, good point - there are two bugs there, the non-freeing of the session and the way describe input failed. | 12:56 |
grantc | am going to try out head revs... | 12:57 |
grantc | not much better | 12:58 |
grantc | can you log a bug http://pecl.php.net/bugs/report.php?package=ingres | 12:58 |
eriksnoeijs | sure. | 12:59 |
PaulM05 | lunchtime - see you later :) | 13:14 |
*** PaulM05 has quit IRC | 13:14 | |
eriksnoeijs | grantc: don't take this the wrong way. But how ready for production systems is the php ingres module? Because i can attribute a lot to the fact i've only been toying with this for a day and utterly incompetent but how stable is it? | 13:18 |
grantc | eriksnoeijs, sorry for not responding I was in the kitchen preparing lunch. | 14:21 |
grantc | the driver is used in production by ingres on a number of websites along with a number of clients one of which is internet facing | 14:21 |
eriksnoeijs | Ok. so for the most part it's just me and my supernatural ability to break stuff. Good to know. | 14:23 |
grantc | i agree that there are some issues that need resolving, in particular these came about with 2.1.0 and I am working my way through them now. One problem I have is that I don't have an extensive test suite. Problems like yours only come about by people using the driver. | 14:23 |
eriksnoeijs | fair enough, i'm going to assume you have a day job as well :) | 14:24 |
grantc | it is my day job :) | 14:24 |
grantc | that along with general ingres community activities and maintaining the ruby driver | 14:25 |
grantc | each of which can be a full time job on its own | 14:25 |
eriksnoeijs | ah, lol. well that's also good to know. For one thing ingres has really shown its good side with a active community. | 14:25 |
grantc | http://community.ingres.com/wiki/User:Grant - my "official" bio ... | 14:26 |
grantc | anyways - I will take a look at that problem with the sessions not disconnecting. It should be relatively "easy" to fix | 14:30 |
grantc | right after i have lunch ... | 14:30 |
*** DarylM has joined #ingres | 14:39 | |
*** eriksnoeijs has quit IRC | 14:44 | |
*** PaulM05 has joined #ingres | 14:58 | |
*** Alex| is now known as Alex|off | 15:15 | |
*** Alex|off is now known as Alex| | 15:40 | |
*** Alex| is now known as Alex|off | 15:48 | |
*** DerMeister has joined #ingres | 16:09 | |
*** clach04 has joined #ingres | 16:41 | |
*** eriksnoeijs has joined #ingres | 17:21 | |
*** yoeljacobsen1 has joined #ingres | 17:26 | |
yoeljacobsen1 | Hello | 17:26 |
yoeljacobsen1 | Is there a way to script user creation inside an SQL script as I can in other DBMS? CONNECT isn't available in interactive SQL and I must be connected to iidbdb in order to CREATE USER ... | 17:27 |
grantc | that's correct you need to be connected to iidbdb to create a user... | 17:28 |
yoeljacobsen1 | Can I switch databases within a single sql session? Otherwise | 17:34 |
yoeljacobsen1 | I'll need to use two scripts.. | 17:34 |
*** Alex|off is now known as Alex| | 17:35 | |
PaulM05 | not in terminal monitor | 17:36 |
PaulM05 | so yes you need two scripts | 17:37 |
yoeljacobsen1 | Ok. Thanks. (this is pity as Oracle, MySQL, DB2, MS-SQL ... doesn't require it..). | 17:50 |
PaulM05 | your welcome - I'm off now - good night | 17:54 |
*** PaulM05 has quit IRC | 17:54 | |
grantc | yoeljacobsen1, sure it would be good if we could connect in to a shell like the dbms engines you mention | 17:56 |
yoeljacobsen1 | What do you mean by "connect to a shell"? in other dbms I just can "CONNECT 'iidbdb';" from a script. Such a feature is simple and will do.. | 18:01 |
grantc | it is in effect a shell | 18:02 |
*** eriksnoeijs has quit IRC | 18:02 | |
grantc | yoeljacobsen1, you connect to the "shell" and that in turn connects you through to the database you want with "use dbname" in the case of MySQL. Then all your commands to the shell are passed into that database. When you issue again "use dbname2" it terminates your connection to the first db then you are connected to the second db | 18:04 |
yoeljacobsen1 | ok. I see what you mean by shell. | 18:18 |
yoeljacobsen1 | ESQL in ingress allow you to EXEC SQL CONNECT and DISCONNECT though. | 18:18 |
*** withdefault has left #ingres | 19:06 | |
*** MagnusG| has left #ingres | 20:27 | |
*** NoeJeko has joined #ingres | 20:54 | |
*** DerMeister has quit IRC | 22:15 | |
*** toumi01 has left #ingres | 22:38 | |
*** NoeJeko has quit IRC | 22:51 | |
*** bonro011 has left #ingres | 23:30 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!