*** Alex| has quit IRC | 00:00 | |
*** Alex| has joined #ingres | 00:19 | |
*** ChanServ sets mode: +o Alex| | 00:19 | |
*** withdefault has joined #ingres | 01:01 | |
*** ChanServ sets mode: +o withdefault | 01:01 | |
Dejan | hello everybody | 01:15 |
---|---|---|
* Dejan will be in Slough next week! Woohooo! | 01:16 | |
Dejan | guys, do you know how much does it cost to pay for the Ingres support ? | 01:53 |
Dejan | (per year) | 01:53 |
Dejan | I may be able to persuade my managers to pay for it ;) | 01:54 |
*** KermitTheFragger has joined #ingres | 02:21 | |
*** PaulM05 has joined #ingres | 02:30 | |
Dejan | hi PaulM05 & KermitTheFragger | 02:31 |
KermitTheFragger | hello Dejan | 02:31 |
PaulM05 | morning | 02:31 |
Dejan | I wonder if Ingres has some sort of ... timer or something so i can call a procedure at a certain time of day | 02:36 |
Dejan | like a crontab basically | 02:36 |
Dejan | so far i do it via a BASH script | 02:36 |
KermitTheFragger | Dejan: hmm to be honest that sounds more like a job for middleware | 02:36 |
Dejan | KermitTheFragger: i have a table with employees | 02:36 |
Vroomfondle | I think that's normally achieved via a crontab... | 02:36 |
Dejan | and some of them work only at certain days | 02:37 |
Dejan | and at some days they are off | 02:37 |
Dejan | i need to update status of a certain table | 02:37 |
Dejan | for those who actually WORK today | 02:37 |
PaulM05 | no - there's no Ingres scheduler - although I think there is one in the new tools framework that's under development | 02:37 |
Dejan | :) | 02:37 |
Dejan | i do this via a simple BASH, atm, but I think it might be a good thing to have a simple scheduler in Ingres itself | 02:38 |
KermitTheFragger | would be a nice addition, could also be used for some maintenance tasks | 02:39 |
Vroomfondle | I don't think there'd be a huge amount of advantage over crontab for most tasks | 02:39 |
Vroomfondle | though maybe it would aid portability | 02:39 |
KermitTheFragger | Vroomfondle: yeah thats the biggest advantage probably | 02:40 |
KermitTheFragger | other then that all i schedule all my stuff with quartz in the middleware | 02:41 |
KermitTheFragger | I know Oracle has it btw (if thats worth anything ;-) | 02:41 |
Vroomfondle | as does MSSQL | 02:42 |
KermitTheFragger | so personally I wouldn't use it, but I can see why people would. | 02:43 |
Dejan | Vroomfondle: exactly | 02:52 |
Dejan | because one can write solution to some problem that will work on every machine, including Winblows | 02:52 |
Dejan | s/machine/OS/ | 02:52 |
KermitTheFragger | sort of write once, run anywhere ? ;-) | 02:52 |
*** Mud has joined #ingres | 02:52 | |
Dejan | yeppers | 02:52 |
Dejan | PaulM05: next week I am in Slough | 02:53 |
Dejan | wanna have a cofee/luch? :) | 02:53 |
PaulM05 | sure :) | 02:54 |
*** grantc has joined #ingres | 03:18 | |
Dejan | PaulM05: great :) | 03:25 |
Dejan | grantc: hello :) | 03:25 |
*** grantc has quit IRC | 03:37 | |
*** atrofast has joined #ingres | 04:14 | |
Dejan | is there any way to prevent 9.3.0 server from crashing due to many abrupt session terminations? | 04:20 |
Dejan | :) | 04:20 |
Dejan | i keep getting that SIGSEGV i talked about last week | 04:20 |
Dejan | Yay! I got E_DMA460_LGREAD_EOF_REACHED | 04:22 |
Dejan | it is basically impossible that i reached the end of the log file... | 04:27 |
Dejan | it is 16GB big | 04:27 |
Dejan | as large as the database | 04:27 |
Dejan | question: is log file purged after restart of the server? | 04:33 |
Dejan | or it will fill up with data until the end of file? | 04:33 |
Dejan | (transaction log) | 04:33 |
PaulM05 | it's "Purged" by the archiver process - which removes committed transactions and (if appropriate) writes them to the journal files | 04:34 |
PaulM05 | start up is one of the times the archiver "wakes up" | 04:34 |
PaulM05 | one way to fill your log file is someone starts a transaction and never commits | 04:35 |
*** Mud has quit IRC | 04:52 | |
*** Mud has joined #ingres | 04:57 | |
*** zxiiro has quit IRC | 04:59 | |
Dejan | for some reason our ODBC is borked... | 05:03 |
Dejan | Error type: [Ingres][Ingres ODBC Driver]Ingres API failure probably to due to transaction already abnormally terminated (0x80004005)[Ingres][Ingres ODBC Driver]Ingres API failure probably to due to transaction already abnormally terminated# | 05:04 |
Dejan | internet information server says this | 05:04 |
Dejan | actually ODBC driver | 05:04 |
Dejan | how to inform ODBC tehre that server has been restarted | 05:04 |
Dejan | and it should refresh | 05:04 |
Alex| | Hi FrankW | 05:06 |
FrankW | Hi Alex| | 05:08 |
Alex| | Hi - maybe you can help me. I'm trying to set up the gis demo but ogr2ogr isn't working for me | 05:09 |
FrankW | Were you successful building GDAL/OGR against ingres? | 05:10 |
Alex| | I am following http://community.ingres.com/wiki/GeoDemoLinuxSetup but when I run ogr2ogr on an shp file it tells me "unable to open existing output datasource @driver=ingres,dbname=geo" | 05:10 |
Alex| | yes, it was built with ingres support | 05:10 |
*** gerhard has joined #ingres | 05:10 | |
FrankW | Does the output of "ogrinfo --formats" include: | 05:11 |
FrankW | -> "Ingres" (read/write) | 05:11 |
Alex| | hm, no... but it did compile the ingres parts | 05:12 |
*** mull has quit IRC | 05:12 | |
FrankW | any chance you aren't really running the version you built? | 05:12 |
Alex| | I'm doing another clean build to be sure everything is correct | 05:12 |
FrankW | good idea. | 05:12 |
Alex| | configure says Ingres Support: yes - let's see what happens | 05:13 |
Dejan | http://community.ingres.com/forum/database-drivers-apis/11771-odbc-problem-database-working-but-odbc-shouts-error.html | 05:19 |
Dejan | Alex|: how much is the support contract? (per year) | 05:20 |
Alex| | you'd better ask your sales representative but it's somewhere near $8000/socket/year | 05:20 |
Alex| | list price | 05:21 |
Dejan | do I have to pay for the ODBC driver? | 05:30 |
Dejan | i could not find the place to actually download just what is needed to deploy client on Windows... | 05:31 |
*** rossand has joined #ingres | 05:31 | |
*** ChanServ sets mode: +o rossand | 05:31 | |
Dejan | does anyone know if there is a package with everything needed for a simple client (ODBC) on Windows? | 05:32 |
Dejan | and is it free of charge? | 05:32 |
Alex| | ODBC comes with Ingres - you need to install at least the client | 05:33 |
gerhard | I think you could just download any Ingres 9.x or 10.x community release for Windows, do a "typical client" setup, add the vnode entries in VDBA, create DSNs with odbcad32.exe | 05:33 |
Dejan | gerhard: excellent | 05:34 |
Dejan | because we still use Ingres 2.6 ODBC driver... | 05:34 |
gerhard | and the server side is newer...? | 05:34 |
Dejan | yes | 05:34 |
Dejan | server side is 9.3.0.151 | 05:35 |
Dejan | and i had a headache today | 05:35 |
Dejan | because odbc driver on windows got confused little bit :D | 05:35 |
Dejan | more about: http://community.ingres.com/forum/database-drivers-apis/11771-odbc-problem-database-working-but-odbc-shouts-error.html | 05:35 |
*** PaulM05 is now known as PaulM05_lunch | 05:36 | |
gerhard | that ODBC 2.6 used to work fine against 9.3 DBMS, but now makes troubles after you restarted the 9.3 DBMS? | 05:37 |
Alex| | FrankW, still no Ingres in the list :( | 05:38 |
gerhard | what does the server-side errlog.log say? Maybe a full transaction log... | 05:38 |
FrankW | Alex|: and you are sure you are running the version you built? | 05:38 |
Alex| | I even tried the one directly in the build folder | 05:39 |
FrankW | Trying it in the build folder does not ensure that the right shared library will be used. | 05:39 |
FrankW | Is there more than one libgdal.so* on the system? | 05:39 |
Dejan | gerhard: yes | 05:40 |
Alex| | hmhm, there was indeed something in /usr/local whereas I have installed it to /use... | 05:40 |
Dejan | gerhard: no errors on the server-side | 05:40 |
Dejan | because ODBC did not make a connection at all | 05:41 |
FrankW | Alex|: I'd suggest removing all libgdal.so* files anywhere on the system and then doing the install again. | 05:41 |
FrankW | You likely have a shared library mixup. | 05:41 |
Alex| | yup, am about | 05:41 |
*** zxiiro has joined #ingres | 05:41 | |
*** ChanServ sets mode: +v zxiiro | 05:41 | |
Alex| | ah, got it | 05:44 |
*** mull has joined #ingres | 06:00 | |
Dejan | is there a way to see how "full" the transaction log file is? | 06:06 |
Dejan | :) | 06:06 |
pboro | sure, using ipm | 06:06 |
Dejan | pboro is that in the "Header" section? | 06:08 |
pboro | hmm yes iirc | 06:08 |
Dejan | that star is the indicator? | 06:08 |
Dejan | weird... "% in use or reserved: 0", but star is located in the middle of that diagram... | 06:09 |
PaulM05_lunch | Those stars are a histogram of usage of log buffers | 06:10 |
PaulM05_lunch | oh wait - you're looking at ipm | 06:10 |
Dejan | yep | 06:10 |
Dejan | i am looking for a simple: [########### ] | 06:11 |
Dejan | so i know how full is the transaction log | 06:11 |
Dejan | :) | 06:11 |
PaulM05_lunch | conceptually the logfile is circular | 06:11 |
PaulM05_lunch | so the * represents the start and end | 06:11 |
Dejan | ahammmmm | 06:12 |
PaulM05_lunch | if it was more in use you might see something like [ *>---> ] | 06:12 |
Dejan | so when it is full, it starts overwriting the start of file | 06:12 |
PaulM05_lunch | (think I've got the symbols right) | 06:12 |
PaulM05_lunch | no - it hits a limit first and starts rolling back transactions | 06:12 |
Dejan | thanks PaulM05_lunch for clarification | 06:12 |
PaulM05_lunch | this is a preview of next week ;) | 06:13 |
Dejan | WOOOHOOOOOO! | 06:13 |
*** PaulM05_lunch is now known as PaulM05 | 06:13 | |
* Dejan goes to lunch now :D | 06:13 | |
*** cthibert has joined #ingres | 06:17 | |
*** cthibert1 has joined #ingres | 06:20 | |
Alex| | grr, my Fedora 9 apache won't eat neither PassEnv nor SetEnv... | 06:22 |
*** cthibert has quit IRC | 06:22 | |
*** bonro01 has quit IRC | 06:30 | |
*** bonro01 has joined #ingres | 06:30 | |
*** cthibert has joined #ingres | 06:32 | |
*** cthibert1 has quit IRC | 06:33 | |
Dejan | i stopped using Apache some ... 6-7 years ago | 06:35 |
Dejan | i stumbled upon Lighttpd by accident | 06:36 |
Dejan | and stopped using Apache after that | 06:36 |
bonsaikitten | they aren't equivalent ... | 06:38 |
Alex| | ok, FrankW - one step further... can you tell me what causes "msEvalRegex(): String failed expression test"? | 06:51 |
Alex| | I found something about qy and qry files... where are they? | 06:52 |
* Dejan really, really needs to get the IP of the connection when E_GC2205_RMT_ABORT happens :( | 06:53 | |
Dejan | i cannot find the source of this error | 06:53 |
*** gerhard has quit IRC | 07:09 | |
*** bonsaikitten has quit IRC | 07:12 | |
*** zxiiro has quit IRC | 07:20 | |
*** zxiiro has joined #ingres | 07:21 | |
*** ChanServ sets mode: +v zxiiro | 07:21 | |
FrankW | Alex|: This often means that a file does not have thee expected extension. As a security measure the filenames are tested against regular expressions. | 07:24 |
FrankW | For instance, a map that does not end in .map. | 07:25 |
Alex| | hm, ok... I simply unpacked the demo_package | 07:32 |
FrankW | many of these security restrictions are quite new and the demo does not always keep up to date. | 07:35 |
Dejan | guys, how can i enable some more information in the stack trace ? | 07:35 |
FrankW | this is pretty lame. | 07:35 |
Dejan | i keep ketting this annoying sivsegv | 07:35 |
Dejan | sigsegv, sorry | 07:36 |
Dejan | and always the same stack trace in the errorlog.log | 07:36 |
Dejan | i want to find out what is causing it... | 07:36 |
Dejan | :( | 07:36 |
Alex| | FrankW, unfortunately the log doesn't tell me what file it complains about | 07:37 |
FrankW | that's pretty frustrating. Perhaps you could try "shp2img -m your.map -all_debug 1 -o out.png" on the map and see if you get any more information. | 07:37 |
Alex| | I'm not even sure what map it uses... there is the gmap-ms46 folder which contains a few gmap*.map files | 07:38 |
PaulM05 | Dejan: I take it you don't get any other message before hand? | 07:38 |
Alex| | ah the demo xml says gmap75.map | 07:39 |
Alex| | ah, failed OGR connection in layer land_fn. File not found or unsupported format | 07:42 |
Dejan | PaulM05: there is a pattern, i have explained it on forum | 07:45 |
FrankW | Alex|: I think you are getting closer now. | 07:45 |
Dejan | prior to SIGSEGV i get few E_GC2205_RMT_ABORT and E_GC0001_ASSOC_FAIL errors | 07:45 |
Dejan | always like that | 07:45 |
Dejan | first dozen those, then PAF! SIGSEGV | 07:46 |
PaulM05 | do you get any errors from the DBMS itself? | 07:46 |
Dejan | and IIDBMS goes down | 07:46 |
Dejan | yes, i do, max errors | 07:46 |
PaulM05 | cos there are diags we can trigger off that | 07:46 |
PaulM05 | hmm max errors is not very helpful | 07:46 |
Dejan | E_SC0234_SESSION_END too | 07:47 |
Dejan | bunch of those | 07:47 |
*** cthibert1 has joined #ingres | 07:47 | |
PaulM05 | can you put a bit of the errlog.log leading up to a SIGSEGV onto pastebin? | 07:48 |
*** cthibert has quit IRC | 07:48 | |
*** cthibert has joined #ingres | 07:48 | |
Dejan | sure | 07:49 |
Alex| | FrankW, closer but not yet there :) | 07:50 |
Dejan | PaulM05: i will do it in a minute | 07:50 |
PaulM05 | cheers | 07:50 |
Alex| | does it try to get the data directly from the land_fn.shp file or from the db? | 07:51 |
Alex| | when runninf shp2img | 07:51 |
Alex| | running | 07:51 |
Alex| | argh, my ii_system was set wrong.... | 07:52 |
*** cthibert1 has quit IRC | 07:52 | |
*** cthibert1 has joined #ingres | 07:53 | |
*** cthibert has quit IRC | 07:55 | |
Alex| | shp2img works now, mapserver still says string failed expression test | 07:55 |
FrankW | What is the mapserver url? | 07:55 |
Alex| | /demo | 07:55 |
FrankW | That's the whole url? | 07:55 |
Alex| | localhost/demo, yes | 07:56 |
Alex| | I get an empty mapserver page with no map in it | 07:56 |
FrankW | Is there an index.html in that directory? | 07:56 |
Alex| | yes. It's all in /var/www as the howto says. Fusion, gmap | 07:57 |
Alex| | I get the frame of mapserver with the zoom icons but no map | 07:57 |
FrankW | Can you establish the url it is trying to evaluate for the map? Perhaps right clicking in the map area to get the url of the failed load? | 07:58 |
Alex| | the frame where the map would show keeps loading forever... which keeps firefox from allowing a right click, yeah... I'll add something to the php code | 08:00 |
FrankW | I'm not really familiar with the demo setup. | 08:00 |
*** PaulM05 is now known as PaulM05_meeting | 08:02 | |
Alex| | problem is, the actual error happens in the php_mapserver.so | 08:03 |
FrankW | Alex|: I'm out of ideas. | 08:04 |
Alex| | dito :) | 08:04 |
Alex| | only that I need to present it on a workshop :) | 08:05 |
Alex| | I'd say this whole fusion thing doesn't work with my version of mapserver... | 08:11 |
Alex| | I commented out the piece with the error (was only for loading the map to the session folder) | 08:11 |
*** cthibert has joined #ingres | 08:11 | |
Alex| | now I get errors about non-existing methods in the mapserver object | 08:11 |
FrankW | Alex|: can you be more specific? | 08:12 |
Alex| | Property imagetype does not exist in this object | 08:13 |
FrankW | Well, I doubt I could help anyways. But yes, perhaps you have version matching issues. | 08:13 |
FrankW | I'm not aware of changes with regard to imagetype. | 08:13 |
Alex| | it's all about this ms_newMapObj which is defined in the mapscript extension | 08:13 |
*** cthibert1 has quit IRC | 08:13 | |
FrankW | If you could get ahold of him, Paul Spencer might be a good person to ask. | 08:14 |
Alex| | ok. I also sent Andrew a mail. Many thanks for your help so far. | 08:23 |
*** Alex| has quit IRC | 08:24 | |
*** cthibert1 has joined #ingres | 08:35 | |
*** cthibert has quit IRC | 08:37 | |
*** cthibert has joined #ingres | 08:43 | |
*** cthibert2 has joined #ingres | 08:45 | |
*** cthibert1 has quit IRC | 08:46 | |
*** cthibert has quit IRC | 08:47 | |
*** Mud has quit IRC | 08:52 | |
*** Mud has joined #ingres | 08:57 | |
*** cthibert has joined #ingres | 08:59 | |
*** cthibert2 has quit IRC | 09:01 | |
*** DarylM has joined #ingres | 09:31 | |
Dejan | guys, is there a way to increase timeout in IIGCC so it waits more for remote connections | 09:36 |
Dejan | our network is heavily loaded and sometimes we get timeouts | 09:37 |
Dejan | when i ping the server for an example | 09:37 |
*** withdefault has quit IRC | 09:41 | |
*** rossand1 has joined #ingres | 10:28 | |
*** rossand has quit IRC | 10:29 | |
*** rossand1 is now known as rossand | 10:29 | |
*** KermitTheFragger has quit IRC | 10:36 | |
*** Alex| has joined #ingres | 10:41 | |
*** ChanServ sets mode: +o Alex| | 10:41 | |
*** PaulM05_meeting is now known as PaulM05 | 10:42 | |
PaulM05 | Dejan: sent you an email with some debugging stuff for your SIGSEGV problem | 10:42 |
PaulM05 | anyway - good night all | 10:43 |
*** PaulM05 has quit IRC | 10:43 | |
*** Dejan has quit IRC | 11:12 | |
*** clach04 has quit IRC | 11:53 | |
*** clach04 has joined #ingres | 12:03 | |
*** Mud has quit IRC | 12:52 | |
*** Mud has joined #ingres | 12:57 | |
*** zxiiro has quit IRC | 13:20 | |
*** cthibert has left #ingres | 13:27 | |
*** zxiiro has joined #ingres | 14:11 | |
*** ChanServ sets mode: +v zxiiro | 14:11 | |
*** Mud has quit IRC | 14:25 | |
*** rossand has quit IRC | 14:46 | |
*** rossand has joined #ingres | 14:48 | |
*** ChanServ sets mode: +o rossand | 14:48 | |
*** Alex| has quit IRC | 14:51 | |
*** mull has quit IRC | 15:18 | |
*** atrofast has quit IRC | 15:38 | |
*** atrofast has joined #ingres | 15:41 | |
*** cthibert has joined #ingres | 16:18 | |
*** cthibert has left #ingres | 16:18 | |
*** toumi01 has left #ingres | 17:13 | |
*** toumi01 has joined #ingres | 17:14 | |
*** atrofast has quit IRC | 18:27 | |
*** cytrinox_ has joined #ingres | 20:20 | |
*** cytrinox has quit IRC | 20:23 | |
*** cytrinox_ is now known as cytrinox | 20:23 | |
*** rossand has quit IRC | 21:12 | |
*** Alex| has joined #ingres | 23:38 | |
*** ChanServ sets mode: +o Alex| | 23:38 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!