*** grantc has joined #ingres | 00:22 | |
*** ChanServ sets mode: +o grantc | 00:22 | |
Vroomfondle | any known problems with Ingres on ZFS? | 01:17 |
---|---|---|
*** PaulM05 has joined #ingres | 01:37 | |
pboro | Vroomfondle, should work ok, it is supported | 01:37 |
Vroomfondle | k | 01:37 |
Vroomfondle | just grasping at straws really | 01:37 |
Vroomfondle | our upgrade from 2.6 -> 9.2 is not going well ;) | 01:38 |
pboro | hehe :D | 01:38 |
pboro | our upgrade from 2.6 -> 9.2 went fine, but I spent quite a lot of time beforehand in testing etc. | 01:38 |
Vroomfondle | Yeah. Well, I wasn't in charge of the project so... no comment on that aspect. | 01:39 |
pboro | hehe | 01:40 |
Vroomfondle | Suffice to say I was not asked to provide a test-sheet for my part of the software. | 01:40 |
pboro | :D | 01:40 |
pboro | sounds like preordered fail | 01:40 |
Vroomfondle | this is one of those times when I'm glad I've never had DBA/systems training. Officially 's not my problem, guv! ;) | 01:40 |
PaulM05 | Vroomfondle: saw your question about ZFS on the IRC log - there's no problem with regular files but there is a known problem with trying to create a raw log on a ZFS raw volume | 01:54 |
pboro | PaulM05, it would be good to mention that on the kbdoc about zfs support | 01:54 |
PaulM05 | there is a kbdoc about that problem - let me find the number | 01:55 |
Vroomfondle | basically we're having performance problems and also have had some dates get corrupted when copying the database out of 2.6 and then into 9.2 | 01:56 |
Vroomfondle | I presume the latter is due to some difference in date handling between the two versions of course, rather than anything system-level | 01:56 |
PaulM05 | well it's not that then - with this problem you wouldn't get past creating the logfile | 01:57 |
PaulM05 | binary unload? | 01:57 |
Vroomfondle | copydb | 01:57 |
PaulM05 | with or without -c? | 01:57 |
Vroomfondle | without | 01:58 |
pboro | PaulM05, ah, thanks! | 01:58 |
pboro | Vroomfondle, do it without -c | 01:58 |
Vroomfondle | apparently we just did "copydb <dbname>" | 01:58 |
pboro | there's differences in data format in storing dates and times between 2.6 and 9.2 | 01:58 |
pboro | which can be worked around by not using binary copy | 01:58 |
PaulM05 | the ingresdate date type should be compatible - what's date_alias set to in config.dat? | 01:59 |
Vroomfondle | on the target or the source? Target is ingresdate | 02:00 |
PaulM05 | target and source as same OS? | 02:00 |
pboro | PaulM05, it's not completely compatible either :( if the time zone used is not gmt, there will be problems with for example keys based on ingresdates | 02:01 |
Vroomfondle | PaulM05: same OS, yes | 02:01 |
Vroomfondle | source is ingresdate too - just checked | 02:01 |
Vroomfondle | oh, wait | 02:01 |
Vroomfondle | bit of confusion cos another machine was involved in the middle | 02:02 |
Vroomfondle | source did not have date_alias set. | 02:02 |
PaulM05 | pboro: I think you've hit problems with denormalised dates - which should be fixed now - but unloading/reloading with -c would fix it anyway | 02:03 |
Vroomfondle | I'm a bit confused - should we use -c or not? Manual says -c avoids binary copying. Is that what we want to do? Non-binary copy? | 02:03 |
PaulM05 | 2.6 didn't have date_alias | 02:03 |
pboro | PaulM05, yeah, that's true | 02:03 |
*** withdefault has joined #ingres | 02:06 | |
*** ChanServ sets mode: +o withdefault | 02:06 | |
Vroomfondle | II 9.2.0 (su9.us5/143) | 02:07 |
Vroomfondle | 13396 | 02:07 |
Vroomfondle | how recent's that? | 02:07 |
PaulM05 | -c is a more portable format - but can be bigger | 02:07 |
PaulM05 | it's not the latest but it's pretty recent | 02:07 |
* Vroomfondle notes that teething troubles seem to have settled down a bit now, and turns his attention to finally getting a local working environment set up | 03:10 | |
Vroomfondle | this is a longshot, but I don't suppose there's an easy way of setting up a 4GL/ABF cross-compilation environment for Intel -> SPARC... | 03:10 |
PaulM05 | I don't think ABF is set up for cross-compiling - theoretically it's possible but it would take some hacking | 03:11 |
Vroomfondle | yeah, I figure it might be easier to just write some scripts to copy everything across to our dev server and compile the code on that | 03:12 |
*** gerhard has joined #ingres | 04:03 | |
gerhard | Hi all | 04:03 |
PaulM05 | hi | 04:16 |
*** PaulM05 is now known as PaulM05_lunch | 04:45 | |
*** zxiiro has quit IRC | 05:05 | |
*** toumi01 has joined #ingres | 05:45 | |
*** [1]gerhard has joined #ingres | 05:46 | |
*** gerhard has quit IRC | 05:49 | |
*** [1]gerhard is now known as gerhard | 05:49 | |
*** zxiiro has joined #ingres | 05:56 | |
*** ChanServ sets mode: +v zxiiro | 05:56 | |
*** grantc has quit IRC | 06:02 | |
*** grantc has joined #ingres | 06:02 | |
*** ChanServ sets mode: +o grantc | 06:02 | |
*** grantc has quit IRC | 06:03 | |
*** grantc has joined #ingres | 06:04 | |
*** ChanServ sets mode: +o grantc | 06:04 | |
*** cthibert has joined #ingres | 06:05 | |
*** atrofast has joined #ingres | 06:10 | |
*** grantc has quit IRC | 06:25 | |
*** rossand has joined #ingres | 06:29 | |
*** ChanServ sets mode: +o rossand | 06:29 | |
*** zxiiro has quit IRC | 06:53 | |
*** zxiiro has joined #ingres | 06:57 | |
*** ChanServ sets mode: +v zxiiro | 06:57 | |
*** Vroomfondle has quit IRC | 06:58 | |
*** FrankW has joined #ingres | 07:00 | |
rossand | Good day all. Does anyone know if we have a search-able index of IRC logs? | 07:02 |
gerhard | Hi, http://irc.planetingres.org/ | 07:04 |
gerhard | no search function in it, but maybe with google... | 07:04 |
gerhard | searchphrase + site:irc.planetinger.org | 07:05 |
gerhard | haven't tried it... | 07:05 |
gerhard | searchphrase + site:irc.planetingres.org | 07:06 |
*** Vroomfondle has joined #ingres | 07:07 | |
rossand | Thanks for the idea gerhard, I'll give it a try. Much appreciated. | 07:12 |
gerhard | Seems to work basically. I tried in Google | 07:19 |
gerhard | unloaddb + site:irc.planetingres.org | 07:19 |
gerhard | and got some results. | 07:19 |
rossand | yep, thanks. It's working for what I need to do. | 07:21 |
rossand | Great idea | 07:21 |
Vroomfondle | hrm... is there any way to tell the sql monitor to ignore errors? | 07:23 |
Vroomfondle | I just want it to continue with the next statement | 07:23 |
gerhard | \continue | 07:26 |
*** mull has joined #ingres | 07:27 | |
Vroomfondle | aha, cheers | 07:27 |
*** Vroomfondle has quit IRC | 07:39 | |
*** Vroomfondle has joined #ingres | 07:45 | |
*** withdefault1 has joined #ingres | 07:50 | |
*** mull has quit IRC | 07:51 | |
*** toumi01 has quit IRC | 07:52 | |
*** withdefault has quit IRC | 07:52 | |
*** FrankW has quit IRC | 07:54 | |
*** zxiiro has quit IRC | 07:54 | |
*** cytrinox has quit IRC | 07:54 | |
*** DarylM has quit IRC | 07:54 | |
*** cytrinox has joined #ingres | 07:54 | |
*** mull has joined #ingres | 07:59 | |
*** toumi01 has joined #ingres | 07:59 | |
*** zxiiro_ has joined #ingres | 07:59 | |
*** DarylM has joined #ingres | 08:00 | |
*** gerhard has quit IRC | 08:07 | |
*** mull has quit IRC | 08:11 | |
*** toumi01 has quit IRC | 08:11 | |
*** toumi01 has joined #ingres | 08:14 | |
*** monda07 has joined #ingres | 08:17 | |
*** mull has joined #ingres | 08:18 | |
*** Vroomfondle has quit IRC | 08:18 | |
*** Vroomfondle has joined #ingres | 08:19 | |
*** Vroomfondle has quit IRC | 08:22 | |
*** Vroomfondle has joined #ingres | 08:23 | |
*** Mud has joined #ingres | 08:27 | |
*** Mud is now known as Mud|lunch | 08:29 | |
*** PaulM05_lunch is now known as PaulM05 | 08:30 | |
*** toumi01 has quit IRC | 08:33 | |
*** toumi01 has joined #ingres | 08:39 | |
*** DarylM has quit IRC | 08:43 | |
*** monda07 is now known as DarylM | 08:43 | |
*** DarylM has quit IRC | 08:46 | |
*** DarylM has joined #ingres | 08:46 | |
*** Vroomfondle has quit IRC | 08:50 | |
*** Vroomfondle has joined #ingres | 08:56 | |
*** Vroomfondle has quit IRC | 09:08 | |
*** mull has quit IRC | 09:09 | |
*** toumi01 has quit IRC | 09:09 | |
*** toumi011 has joined #ingres | 09:09 | |
*** Mud|lunch is now known as Mud | 09:14 | |
*** Vroomfondle has joined #ingres | 09:15 | |
*** FrankW has joined #ingres | 09:16 | |
*** mull has joined #ingres | 09:17 | |
*** Alex____ has joined #ingres | 09:21 | |
*** Alex____ is now known as Alex| | 09:22 | |
*** ChanServ sets mode: +o Alex| | 09:22 | |
*** toumi011 has left #ingres | 10:19 | |
*** toumi01 has joined #ingres | 10:19 | |
*** rossand has quit IRC | 10:26 | |
*** Mud is now known as Mud|afk | 10:35 | |
*** zxiiro_ has quit IRC | 11:27 | |
*** Mud|afk has quit IRC | 11:33 | |
*** DerMeister has joined #ingres | 11:33 | |
*** PaulM05 has quit IRC | 11:48 | |
*** mull has quit IRC | 12:23 | |
*** mull has joined #ingres | 12:32 | |
*** Vroomfondle has quit IRC | 12:36 | |
*** Vroomfondle has joined #ingres | 12:44 | |
*** Vroomfondle has joined #ingres | 12:47 | |
*** DerMeister has quit IRC | 13:01 | |
*** mull has quit IRC | 13:24 | |
*** toumi01 has quit IRC | 13:27 | |
*** Alex| has quit IRC | 13:29 | |
*** cthibert has left #ingres | 13:33 | |
*** mull has joined #ingres | 13:33 | |
*** Vroomfondle has quit IRC | 13:38 | |
*** toumi01 has joined #ingres | 13:38 | |
*** Vroomfondle has joined #ingres | 13:46 | |
*** rossand has joined #ingres | 13:56 | |
*** ChanServ sets mode: +o rossand | 13:56 | |
*** zxiiro has joined #ingres | 14:27 | |
*** ChanServ sets mode: +v zxiiro | 14:27 | |
*** FrankW has quit IRC | 15:03 | |
*** Vroomfondle has quit IRC | 15:14 | |
*** Vroomfondle has joined #ingres | 15:17 | |
*** Vroomfondle has quit IRC | 15:20 | |
*** Vroomfondle has joined #ingres | 15:21 | |
*** Vroomfondle has quit IRC | 15:31 | |
*** Vroomfondle has joined #ingres | 15:31 | |
*** zxiiro has quit IRC | 15:45 | |
*** mull has quit IRC | 15:59 | |
*** FrankW has joined #ingres | 17:53 | |
*** atrofast has quit IRC | 18:12 | |
*** atrofast has joined #ingres | 18:13 | |
*** atrofast has quit IRC | 18:15 | |
*** rossand has quit IRC | 19:19 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:37 | |
*** cytrinox_ is now known as cytrinox | 19:37 | |
*** toumi01 has quit IRC | 21:15 | |
*** toumi01 has joined #ingres | 21:34 | |
*** Alex| has joined #ingres | 22:35 | |
*** ChanServ sets mode: +o Alex| | 22:35 | |
*** Alex| has quit IRC | 23:06 | |
*** Alex| has joined #ingres | 23:23 | |
*** ChanServ sets mode: +o Alex| | 23:23 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!