Re: [SQL] Insane behaviour in 8.3.3

2012-06-19 Thread Achilleas Mantzios
On Τετ 20 Ιουν 2012 07:08:09 Craig Ringer wrote: > On 06/19/2012 05:17 PM, Achilleas Mantzios wrote: > > We had another corruption incident on the very same machine, this time in > > the jboss subsystem (a "jar cvf" produced corrupted .jar). IMHO this > > means faulty RAM/disk. > > If that is true,

Re: [SQL] Insane behaviour in 8.3.3

2012-06-19 Thread Craig Ringer
On 06/19/2012 05:17 PM, Achilleas Mantzios wrote: We had another corruption incident on the very same machine, this time in the jboss subsystem (a "jar cvf" produced corrupted .jar). IMHO this means faulty RAM/disk. If that is true, then i guess HW sanity checks are even more important than SW

Re: [SQL] Insane behaviour in 8.3.3

2012-06-19 Thread Achilleas Mantzios
We had another corruption incident on the very same machine, this time in the jboss subsystem (a "jar cvf" produced corrupted .jar). IMHO this means faulty RAM/disk. If that is true, then i guess HW sanity checks are even more important than SW upgrades. On Δευ 18 Ιουν 2012 11:36:14 you wrote: >

Re: [SQL] Insane behaviour in 8.3.3

2012-06-18 Thread Jasen Betts
On 2012-06-15, Richard Huxton wrote: > On 15/06/12 16:32, Achilleas Mantzios wrote: >> On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: >>> Not talking about going to something after 8.3.19, just updating to >>> the latest 8.3 version. On most systems it's a simple: >>> >>> sudo apt-get upgrade

Re: [SQL] Insane behaviour in 8.3.3

2012-06-18 Thread Jasen Betts
On 2012-06-15, Achilleas Mantzios wrote: > On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: >> Not talking about going to something after 8.3.19, just updating to >> the latest 8.3 version. On most systems it's a simple: >> >> sudo apt-get upgrade >> >> or similar and sit back and watch. > > T

Re: [SQL] Insane behaviour in 8.3.3

2012-06-18 Thread Karsten Hilbert
On Mon, Jun 18, 2012 at 11:36:14AM +0300, Achilleas Mantzios wrote: > > >> Not talking about going to something after 8.3.19, just updating to > > >> the latest 8.3 version. On most systems it's a simple: > > >> > > >> sudo apt-get upgrade > > >> > > >> or similar and sit back and watch. > > >

Re: [SQL] Insane behaviour in 8.3.3

2012-06-18 Thread Achilleas Mantzios
On Σαβ 16 Ιουν 2012 03:22:16 you wrote: > On Fri, Jun 15, 2012 at 3:06 AM, Achilleas Mantzios < > > ach...@matrix.gatewaynet.com> wrote: > > On Παρ 15 Ιουν 2012 12:29:38 Samuel Gendler wrote: > > > On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler > > > > > > wrote: > > > > On Fri, Jun 15, 2012 at

Re: [SQL] Insane behaviour in 8.3.3

2012-06-18 Thread Achilleas Mantzios
Thanx, well said, and especially after this incident we should very well consider seriously an upgrade. On Παρ 15 Ιουν 2012 19:59:05 Scott Marlowe wrote: > Well, I'd see about finding a way to upgrade to 8.3.19. 8.3.3 has > know data eating bugs. > > On Fri, Jun 15, 2012 at 9:32 AM, Achilleas

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Raj Mathur (राज माथुर)
On Friday 15 Jun 2012, Samuel Gendler wrote: > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > > ach...@matrix.gatewaynet.com> wrote: > > And i forgot to mention, minicom term emulation quality sucks, even > > giving simple > > shell commands is a PITA, upgrading the whole fleet would mean

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Scott Marlowe
Well, I'd see about finding a way to upgrade to 8.3.19. 8.3.3 has know data eating bugs. On Fri, Jun 15, 2012 at 9:32 AM, Achilleas Mantzios wrote: > On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: >> Not talking about going to something after 8.3.19, just updating to >> the latest 8.3 version

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Richard Huxton
On 15/06/12 16:32, Achilleas Mantzios wrote: On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: Not talking about going to something after 8.3.19, just updating to the latest 8.3 version. On most systems it's a simple: sudo apt-get upgrade or similar and sit back and watch. Thanx, unfortunat

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: > Not talking about going to something after 8.3.19, just updating to > the latest 8.3 version. On most systems it's a simple: > > sudo apt-get upgrade > > or similar and sit back and watch. Thanx, unfortunately we dont have TCP/IP connectivity

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Scott Marlowe
Not talking about going to something after 8.3.19, just updating to the latest 8.3 version. On most systems it's a simple: sudo apt-get upgrade or similar and sit back and watch. On Fri, Jun 15, 2012 at 2:24 AM, Achilleas Mantzios wrote: > On Παρ 15 Ιουν 2012 10:28:20 Scott Marlowe wrote: >> Y

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 12:29:38 Samuel Gendler wrote: > On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler > > wrote: > > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > > > > ach...@matrix.gatewaynet.com> wrote: > >> And i forgot to mention, minicom term emulation quality sucks, even > >> givi

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 12:28:21 Samuel Gendler wrote: > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > > ach...@matrix.gatewaynet.com> wrote: > > And i forgot to mention, minicom term emulation quality sucks, even > > giving simple > > shell commands is a PITA, upgrading the whole fleet woul

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Samuel Gendler
On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler wrote: > > > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > ach...@matrix.gatewaynet.com> wrote: > >> >> And i forgot to mention, minicom term emulation quality sucks, even >> giving simple >> shell commands is a PITA, upgrading the whole fl

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Samuel Gendler
On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > > And i forgot to mention, minicom term emulation quality sucks, even giving > simple > shell commands is a PITA, upgrading the whole fleet would mean bast case > scenario > minimum 21K USD for the whole f

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 10:28:20 Scott Marlowe wrote: > You do realize you're missing four years of bug fixes right? On Πεμ 14 Ιουν 2012 11:39:35 Achilleas Mantzios wrote: > Unfortunately the remote installations are neither physically accessible > nor by TCP/IP accesible (comms are done via UUCP and

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Scott Marlowe
You do realize you're missing four years of bug fixes right? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 09:34:16 Richard Huxton wrote: > On 14/06/12 09:39, Achilleas Mantzios wrote: > > dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=61972; > > > > id > > > > - > > > > 1261319 > > > > (1 row) > > dynacom=# -- ok this is how it should be > > dynacom=#

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Robert Edwards
On 14/06/12 18:39, Achilleas Mantzios wrote: dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=currval('xadmin_xid_seq'); id (0 rows) dynacom=# -- THIS IS INSANE Have you tried: SELECT id from items_tmp WHERE id=1261319 AND xid=currval('xadmin_xid_seq'::text) or even: SE

Re: [SQL] Insane behaviour in 8.3.3

2012-06-14 Thread Richard Huxton
On 14/06/12 09:39, Achilleas Mantzios wrote: dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=61972; id - 1261319 (1 row) dynacom=# -- ok this is how it should be dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=currval('xadmin_xid_seq'); id (0 rows) dy

Re: [SQL] Insane behaviour in 8.3.3

2012-06-14 Thread Adrian Klaver
On 06/14/2012 01:39 AM, Achilleas Mantzios wrote: > Hello,one remote user reported a problem and i was surprised to witness the > following behaviour. > It is on postgresql 8.3.3 > > dynacom=# BEGIN; > BEGIN > dynacom=# > dynacom=# > dynacom=# insert into xadmin(appname,apptbl_tmp,gao,id,comment)

[SQL] Insane behaviour in 8.3.3

2012-06-14 Thread Achilleas Mantzios
Hello,one remote user reported a problem and i was surprised to witness the following behaviour. It is on postgresql 8.3.3 dynacom=# BEGIN; BEGIN dynacom=# dynacom=# dynacom=# insert into xadmin(appname,apptbl_tmp,gao,id,comment) dynacom-# values('PMS','overhaul_report_tmp','INSERT',nextval('o