*** grantc has joined #ingres | 00:01 | |
*** ChanServ sets mode: +o grantc | 00:01 | |
*** Gerhard has joined #ingres | 00:19 | |
*** dyki has joined #ingres | 01:03 | |
*** Gerhard has quit IRC | 01:44 | |
* Vroomfondle wonders if he's going nuts | 02:09 | |
Vroomfondle | $results_handle = ingres_query($handle, $sql, $params, $types); | 02:09 |
---|---|---|
Vroomfondle | ingres_free_result($results_handle); | 02:09 |
Vroomfondle | [05-Nov-2009 10:06:34] PHP Fatal error: ingres_free_result() [<a href='function.ingres-free-result'>function.ingres-free-result</a>]: php_ii_result_remove : An unknown resource type was passed in /u1/www/php_include/ingres_functions_2.inc on line 81 | 02:09 |
Vroomfondle | grantc: we've been having trouble with the new Ingres driver, btw. It crashes immediately whenever we try to run a query. | 02:11 |
* Vroomfondle will attempt to replicate the fault at some point but for now we're back on 2.0.0 | 02:11 | |
grantc | Vroomfondle, what does "var_dump($results_handle)" give? | 02:12 |
Vroomfondle | resource(35) of type (ingres result) | 02:13 |
grantc | what sort of query? | 02:14 |
Vroomfondle | A select | 02:14 |
grantc | hmm | 02:14 |
Vroomfondle | I should point out that between the two rows above I'm using ingres_fetch_array | 02:14 |
Vroomfondle | dunno if that's important | 02:14 |
Vroomfondle | http://pastebin.com/m1d49b9f8 <-- full code | 02:15 |
Vroomfondle | well, minus the query, which as I say is just a SELECT - nothing fancy | 02:16 |
grantc | the "types" being passed? | 02:17 |
Vroomfondle | gimme a sec. I'll dump the array. | 02:17 |
Vroomfondle | sorry, string | 02:17 |
grantc | just string values? | 02:18 |
Vroomfondle | string(10) "cccccccccc" | 02:19 |
grantc | what happens if you change the c's to v? | 02:24 |
grantc | reading the paste, when you rollback you in effect "free" the result resources | 02:26 |
Vroomfondle | it shouldn't be rolling back, though - there's no ingres error occurring | 02:26 |
Vroomfondle | which should mean the SQLState is 0, unless I'm remembering wrong | 02:27 |
grantc | sorry i am talking rubbish... | 02:28 |
Vroomfondle | changing 'c' to 'v' doesn't seem to make much difference | 02:28 |
grantc | it seems you are trying to free a result that is not associated with a link | 02:30 |
grantc | or that is what the code thinks | 02:30 |
Vroomfondle | could it be an autocommit issue? does commit free the result? | 02:33 |
Vroomfondle | though... nah | 02:33 |
Vroomfondle | I'm turning autocommit off earlier on | 02:33 |
grantc | auto commit is switched off for selects due to the way cursors work or not with AC enabled | 02:34 |
grantc | can you try http://dl.getdropbox.com/u/2191213/ingres-2.2.2.tgz - i've put an E_NOTICE diag in php_ii_result_remove which prints the link_id for the result | 02:35 |
Vroomfondle | No, I can't. the 2.2.2 driver doesn't work for us. | 02:35 |
Vroomfondle | it seems to be segfaulting or something | 02:35 |
Vroomfondle | we've just had the dev box out of action for a few days while our pet admin struggled to get it to work, then gave up | 02:36 |
grantc | in that case i need a test case | 02:36 |
grantc | especially for the segv | 02:36 |
Vroomfondle | There is no test case. It was segfaulting immediately whenever we tried to do anything at all with it. | 02:37 |
Vroomfondle | it was causing the Apache child to exit | 02:38 |
Vroomfondle | I can give you a test-case for what I'm trying to do right now with the 2.0.0 driver though :) | 02:38 |
grantc | hmm | 02:39 |
Vroomfondle | this may all be down to the fact that we're running a slightly odd setup. The client system is a T-series Sun box (so it's coolthreads rather than standard USPARC) and we're still running against 2.6 databases | 02:41 |
Vroomfondle | the client ingres install is 2.6 on Sol10, which we've been informed has never actually been tested | 02:41 |
grantc | it's not a combination i test for certainly | 02:43 |
grantc | I'd like to get continuous integration testing setup but I don't find the time | 02:45 |
Vroomfondle | we're moving to 9.2 ASAP, but it's taking a while | 02:45 |
grantc | i'm going to test teh latest SVN code against a copy I have of ESD | 02:45 |
Vroomfondle | several systems to upgrade, one of which is running a rather large 4GL app | 02:45 |
grantc | ouch | 02:46 |
grantc | perhaps i can pop in on my way up in december from the chunnel | 02:46 |
grantc | although i am not sure the other-half will approve | 02:47 |
Vroomfondle | heh | 02:47 |
grantc | :) | 02:47 |
* Vroomfondle just got curious and did a 'wc -l' on the 4GL source code for the main app | 02:48 | |
Vroomfondle | 1308942 | 02:48 |
*** grantc has quit IRC | 02:48 | |
*** grantc has joined #ingres | 02:48 | |
*** ChanServ sets mode: +o grantc | 02:48 | |
grantc | a weekend job then | 02:50 |
Vroomfondle | yup | 02:51 |
Vroomfondle | plus 288588 lines of PHP in the main web app | 02:51 |
Vroomfondle | this is what 15 years of feature-creep does... | 02:52 |
*** grantc_ has joined #ingres | 02:53 | |
*** ChanServ sets mode: +o grantc_ | 02:53 | |
*** grantc_ has quit IRC | 02:53 | |
grantc | i can reproduce a segv but it happens in PHP not in the driver | 02:55 |
*** siman01 has joined #ingres | 03:15 | |
siman01 | anyone come accross the error mentioned here http://www.dbmonster.com/Uwe/Forum.aspx/ingres/3689/Info-Ingres-Dropping-a-table-before-the-cursor-read | 03:17 |
siman01 | its suggested that this is "E_US1265 Database reorganization activity has rendered the query plan invalid." | 03:17 |
grantc | siman01, i'm not sure dropping a table before you want to execute a query is a "good idea" | 03:21 |
siman01 | I'm not doing that :) | 03:22 |
siman01 | I was wondering if that error message always maps onto E_US1265 | 03:22 |
siman01 | I think it might have to do with using cursor.prepaired = 'y' in the python driver | 03:23 |
grantc | there might be similar errors for procedures and views that reference tables that no longer exist | 03:24 |
siman01 | I'm using our sqlalchemy dialect to save some object to the database its not doing anything complicated, when the error occurs its checking to see if the object has already been stored - the query looks fairly simple | 03:29 |
grantc | is the query being rolled back? | 03:29 |
*** raial01 has joined #ingres | 03:32 | |
siman01 | its a select so can't, it raises an exeception in python so any open transactions will be rolled back | 03:32 |
siman01 | s/so can't/so can't tell/ | 03:33 |
grantc | can you get an odbc/openapi trace to see what's going on? | 03:35 |
siman01 | yep good idea | 03:35 |
* Vroomfondle reads up | 03:37 | |
Vroomfondle | grantc: so... it's a PHP issue? | 03:37 |
grantc | perhaps/perhaps not | 03:37 |
grantc | Unfortunately I need a test case to confirm/deny one way or another | 03:38 |
Vroomfondle | well, what kind of info do you need? | 03:38 |
grantc | the steps to reproduce it - so table + data + a php app/script | 03:39 |
grantc | i assume UoK is an Ingres client? | 03:39 |
Vroomfondle | yup | 03:39 |
Vroomfondle | I can probably track down the first query the app tries to do, come to think of it | 03:41 |
grantc | logging an SD issue for either the SEGV or the php_ii_result_remove problem will get priority over non-client issues. I would prefer to be dealing with the former problem since it's in the current codeline | 03:42 |
grantc | i have a solaris 11 (opensolaris) machine setup in a VM at Ingres Towers which I can test your setup against. I'll need to know the PHP version and where it came from, i.e. is it a Solaris package or hand-rolled from source | 03:43 |
grantc | if it's a driver problem then the latter is less important but i would rather setup an environment which is as close as possible to your own | 03:44 |
Vroomfondle | it came from the tgz you sent me the other day :) | 03:44 |
grantc | errr and the PHP engine itself? | 03:44 |
grantc | also what web-server... | 03:44 |
Vroomfondle | oh right, I misread | 03:44 |
Vroomfondle | grantc: I have asked our Systems Manager to raise a report via SD | 03:59 |
grantc | ok | 03:59 |
Vroomfondle | I've sent her all the info I can find, including versions numbers, a sample query and relevant portions of our PHP code, with table dumps | 03:59 |
Vroomfondle | this is for the SEGV issue. I'll beaver away at the other problem myself for a bit. | 04:00 |
Vroomfondle | I think I | 04:00 |
Vroomfondle | might set up a local install and play around | 04:00 |
Vroomfondle | -= THIS MESSAGE NOT LOGGED =- | 04:03 |
grantc | i guess it will end up in my Q later today/tomorrow. I'm working on some rails stuff still so it will be next in my list off stuff to be looked at | 04:03 |
Vroomfondle | ok :) | 04:03 |
grantc | i should check to see if "[off]" still works :) | 04:04 |
Vroomfondle | hehe. I'm not too bothered really - I imagine my address has found some way to leak out, given the amount of spam I receive | 04:05 |
*** toumi01 has joined #ingres | 05:16 | |
*** Dejan has joined #ingres | 05:27 | |
Dejan | hi everybody | 05:27 |
grantc | morning | 05:32 |
*** mull has quit IRC | 05:36 | |
*** zxiiro has joined #ingres | 05:47 | |
*** ChanServ sets mode: +v zxiiro | 05:47 | |
*** cthibert has joined #ingres | 05:51 | |
*** siman01 has quit IRC | 06:11 | |
*** mull has joined #ingres | 06:16 | |
*** rossand has joined #ingres | 06:22 | |
*** ChanServ sets mode: +o rossand | 06:22 | |
*** dyki has quit IRC | 06:24 | |
*** atrofast has quit IRC | 07:23 | |
*** Hop has joined #ingres | 08:30 | |
*** Hop has quit IRC | 08:38 | |
*** grantc has quit IRC | 09:05 | |
*** rossand has quit IRC | 09:22 | |
*** raial01 has quit IRC | 09:36 | |
*** ccsidiot has joined #ingres | 09:42 | |
ccsidiot | Hey, guys I was trying to destroydb in Ingres, and receive this error "User does not have permission to destroy this database", is it okay to let me know what are the possible reasons causing this? | 09:47 |
Dejan | you do not have access right for that action | 09:49 |
ccsidiot | Dejan: I thought by default when the user created the database, it's public accessible, no? | 09:50 |
*** SaraDanaher has joined #ingres | 09:50 | |
Dejan | nope | 09:51 |
Dejan | the database is owned by that user | 09:51 |
*** SaraDanaher_ has joined #ingres | 09:51 | |
Dejan | (as far as i know) | 09:51 |
Dejan | if you want to give access to someone else, use accessdb | 09:52 |
SaraDanaher_ | hi | 09:52 |
Dejan | or grant access | 09:52 |
Dejan | hi Sara | 09:52 |
SaraDanaher_ | thanks for the tip.. | 09:54 |
*** Dejan has quit IRC | 09:54 | |
ccsidiot | Sara: Dejan was just answering my question XD | 09:54 |
ccsidiot | I'm Eva by then way | 09:54 |
ccsidiot | *the | 09:54 |
SaraDanaher_ | hi eva | 09:56 |
SaraDanaher_ | still have some problems with php not talking with ingres | 09:56 |
SaraDanaher_ | i checked your tutorial that you used but it looks that is good only for windwos .. | 09:57 |
SaraDanaher_ | no linux | 09:57 |
SaraDanaher_ | mmm | 09:57 |
*** SaraDanaher_ has quit IRC | 09:58 | |
ccsidiot | Hum, but the idea should be similar(someone corrects me if I'm wrong) | 09:59 |
ccsidiot | Hum, you made sure you have the right extension_dir, and extension? | 10:00 |
ccsidiot | and then have the php.ini in the correct path identified by the command php -i | 10:00 |
ccsidiot | ? | 10:00 |
* Vroomfondle just set up PHP+Ingres on Linux earlier today | 10:01 | |
ccsidiot | Hum, I used the accessdb command and then a few key strokes, it brings me to a page to change Access for certain user, I inputed my windows user name and yes, tried deleting again, still no | 10:04 |
ccsidiot | By the way, I checked: Default Access is public for a database | 10:04 |
Vroomfondle | indeed it is | 10:05 |
ccsidiot | So that does not explain why this message "User does not have permission" when I was destroydb | 10:07 |
Vroomfondle | I should think destroydb needs greater access than the default public permission | 10:08 |
ccsidiot | Oh, the access column of accessdb only has yes or no option | 10:09 |
ccsidiot | Or should I set that in somewhere else? | 10:09 |
Vroomfondle | I could've sworn accessdb was more fine-grained than that | 10:11 |
Vroomfondle | but I don't have an Ingres installation handy so can't check, sorry | 10:11 |
SaraDanaher | i used for the extension=php_ingres.so | 10:13 |
SaraDanaher | i have two files for php.ini | 10:14 |
ccsidiot | Oh, right, and the one under the path given by php -i will be read | 10:14 |
ccsidiot | so make sure that php.ini have the correct extension_dir and extension | 10:15 |
ccsidiot | Vroomfondle: I successfully deleted the database by having -usystem | 10:20 |
ccsidiot | :D | 10:20 |
Vroomfondle | heh | 10:21 |
ccsidiot | I just tried stuffs out and no clue why this works.. | 10:21 |
ccsidiot | Oh right, for windows' user model, system has more power than administrators | 10:25 |
*** SaraDanaher has quit IRC | 10:29 | |
ccsidiot | While I was installing Drupal on Ingres, at the stage of configure site, is there a way to skip the warnings here: http://ingres.pastebin.com/d5f18ee2, and finish up with the installation?? | 10:32 |
*** cthibert has left #ingres | 10:54 | |
*** cthibert has joined #ingres | 10:58 | |
*** ccsidiot has quit IRC | 11:37 | |
*** SaraDanaher has joined #ingres | 12:08 | |
SaraDanaher | hi | 12:09 |
SaraDanaher | can someone help me... | 12:10 |
SaraDanaher | i have problems with data table on ingres | 12:10 |
SaraDanaher | this the code that i found in one on the web sites createdb -udrupal drupal | 12:11 |
*** zxiiro has quit IRC | 12:11 | |
*** zxiiro has joined #ingres | 12:12 | |
*** ChanServ sets mode: +v zxiiro | 12:12 | |
*** SaraDanaher has quit IRC | 12:26 | |
*** rossand has joined #ingres | 12:49 | |
*** ChanServ sets mode: +o rossand | 12:49 | |
*** cthibert has left #ingres | 13:22 | |
*** zxiiro has quit IRC | 15:06 | |
*** mull has quit IRC | 15:24 | |
*** toumi01 has quit IRC | 15:31 | |
*** zxiiro has joined #ingres | 16:12 | |
*** ChanServ sets mode: +v zxiiro | 16:12 | |
*** FrankW has quit IRC | 16:18 | |
*** FrankW has joined #ingres | 19:19 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:21 | |
*** cytrinox_ is now known as cytrinox | 19:21 | |
*** rossand has quit IRC | 19:57 | |
*** ccsidiot has joined #ingres | 21:50 | |
*** ccsidiot has quit IRC | 22:18 | |
*** ccsidiot has joined #ingres | 22:19 | |
*** zxiiro has quit IRC | 23:19 | |
*** zxiiro has joined #ingres | 23:20 | |
*** ChanServ sets mode: +v zxiiro | 23:20 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!