sql/pgsql-hackers/1321h6dpv7/getoldestxmin-going-backwards-is-dangerous-after-all
The above thread does not state whether a fix was committed, can anyone
confirm/deny?
Have a great weekend (bank holiday for some!)
Best wishes,
Harry
Unfortunately we still see it frequently :(
On 9 August 2017 at 14:29, Achilleas Mantzios
wrote:
> On 09/08/2017 15:27, ADSJ (Adam Sjøgren) wrote:
>
>> On 2017-06-21 Adam Sjøgren wrote:
>>
>> Adam Sjøgren wrote:
>>>
Meanwhile, I can report that I have upgraded from 9.3.14 to 9.3.17 and
>>
dx++;
} // End while loop
elog(DEBUG5, "HARRYAMBROSE - Has failed is %d after loop", hasfailed);
if (hasfailed!=0)
{
elog(ERROR, "unexpected chunk number exception, please see DEBUG.");
}
Happy to provide further info if required. I have tried to pick only the
interesting changes above ^.
Thanks again for your help!
Have a great weekend :)
Harry
ing 0
Executing 4
Executing 8
Executing 12
Executing 16
Executing 20
Executing 24
Executing 28
(...)
Many thanks,
Harry
ying the jar.
Many thanks,
Harry
)
=
New attempt - number 2
Inserting the rows
Executing 0
Executing 4
Executing 8
Executing 12
Executing 16
Executing 20
Thank you for trying :)
Best wishes,
Harry
");
Thread.sleep(3);
System.out.println("Dropping the table");
c.createStatement().execute("drop table if exists x");
Thread.sleep(3);
Hope this helps!
Best wishes,
Harry
ou run memtest86+ and it reported that your memory is indeed
ECC and also that it is working properly?
Correct, there are no issues reported. The issue can also be reproduced on
multiple different environments making the likelihood of a bad memory slim.
Best wishes,
Harry
further
info.
Best wishes,
Harry
On 7 June 2017 at 17:46, Tom Lane wrote:
> Harry Ambrose writes:
> > Tom - I can provide a jar that I have been using to replicate the issue.
> Whats the best transport method to send it over?
>
> If it's not enormous, just send it
further
info.
Best wishes,
Harry
On 7 June 2017 at 17:46, Tom Lane wrote:
> Harry Ambrose writes:
> > Tom - I can provide a jar that I have been using to replicate the issue.
> Whats the best transport method to send it over?
>
> If it's not enormous, just send it
y is ECC. No error messages found.
> - is your CPU overheating ?
>
No overheating issues.
> - have you experienced any crashes/freezes ?
>
No crashes/freezes experienced.
Best wishes,
Harry
), 64-bit.
- 64GiB RAM.
- AMD Opteron(TM) Processor 6238.
- pg_default sat on 2 disk RAID-1 conifugration (ext3 filesystem).
- Custom tablespaces (where the errors occur) sat on 4 disk RAID-10 (ext3
filesystem).
- All disks are HP 600G SAS 6.0Gbps with P420(i) controllers and battery
backed cache enabled.
Please let me know if you require further info.
Best wishes,
Harry
on SSD’s. Something I had also considered.
Tom - I can provide a jar that I have been using to replicate the issue. Whats
the best transport method to send it over?
Best wishes,
Harry
> On 7 Jun 2017, at 16:27, Tom Lane wrote:
>
> Harry Ambrose writes:
>> I have been follo
161201165505.4360.28...@wrigleys.postgresql.org
Best wishes,
Harry
> On 7 Jun 2017, at 15:22, Achilleas Mantzios
> wrote:
>
> On 07/06/2017 16:33, ADSJ (Adam Sjøgren) wrote:
>> Our database has started reporting errors like this:
>>
>> 2017-05-31 13:48:10 CEST ERRO
Hi,
Kindly see the below attached statements related to Cursor Fetch Issue it's
still residing as a process.
500 20222 31036 79 Dec27 ?16:22:31 postgres: user1 sampledb
192.168.0.40[36022] FETCH
500 20829 31036 81 Dec27 ?16:18:48 postgres: user1 sampledb
192.168.0.40[5759
No any statements as u mentioned.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Cursor-fetch-Problem-tp5737915p5738120.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Below is the Linux ps -ef | grep postgres output :-
501 12163 5473 0 Dec19 ?00:00:00 postgres: enterprisedb
sampledb 192.168.0.231[53991] ?EDB-SPL Procedure successfully completed
501 12167 5473 0 Dec19 ?00:00:00 postgres: enterprisedb
sampledb 192.168.0.231[53995] ?E
Hi Amit,
Thanks for Reply.
Kindly see my below output.
16650;"sampledb";11965;10;"enterprisedb";"";"192.168.0.231";"";53897;"*2012-12-19
11:39:48.234799+05:30";"2012-12-19 11:39:53.288441+05:30";"2012-12-19
11:39:53.288441+05:30*";f;"DECLARE
BEGIN
EXEC
16650;"sampledb";12156;10;"enterprisedb";"";"
Hi All,
I am getting a problem i.e. in database while checking pg_stat_activity
faced issue statement is residing as process
for couple of days also, not able to kill them through pg_terminate_backend
function.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Cursor-
Hello All,
I need help to know how to get below things in Postgresql :-
1) No. of active connections?
2) No. of non-responding connections?
3) Queries which are running beyond time(i.e. time which 'll set in database
query)?
5) Dead Locked Queries?
4) Process ID's of dead-locked queries?
5) No. of
Chris Yes, i am logging in as Super User also, other side same user's
connection(Superuser) i am trying to kill.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PG-TERMINATE-BACKEND-not-working-tp5732379p5732694.html
Sent from the PostgreSQL - general mailing list archi
I am facing problem i.e. connections after execution completed are residing
in pg_stat_activity and pg_stat_database.
but when i am trying to kill them manually using pg_terminate_backend (All
IDLE connections are getting killed but, others like declare, select etc.)
are not getting killed getting
Hello im running Windows XP and removed an older version of Postgres using
windows software remover, now when i try to install the newest one it keeps
asking for a password from Superuser? Thanks
Something like this will be possible but your data sets are contradictory.
There is no
3 | Cat
Row in the original table..
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yan Cheng Cheok
Sent: 20 January 2010 18:23
To:
u.user_id ...
Still, this was quite a suprise to me and I would consider this a bug.
Thoughts?
--
Harry
http://www.uklug.co.uk
http://www.hjackson.org
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
CTED]
Sent: Tuesday, September 26, 2006 12:47 AM
To: Harry Hehl; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Timestamp with timezone query
I'm not at my dev station to check, but what about:
SELECT myTime AT TIME ZONE 'UTC' FROM theTable;
Then try:
SELECT myTime AT TI
results or syntax errors. Is there a way to
do the same thing with TIME columns?
-Original Message-
From: Brandon Aiken [mailto:[EMAIL PROTECTED]
Sent: Monday, September 25, 2006 11:39 AM
To: Harry Hehl; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Timestamp with timezone qu
Hello,
I have a table with TIMESTAMP WITH TIMEZONE column. I would like to
query for a timestamp using a different timezone.
For example if a column contains '2006-02-11 00:30:00-05'
select * from table where column='2006-02-10 19:30:00+00' would return
the column containing '2006-02-11 00:30:00
I am using the following commands to dump and then restore a database.
pg_dump -Fp "${PGDATABASE}" > "${BACKUPFILE}"
psql --variable ON_ERROR_STOP=1 -f "${BACKUPFILE}"
The restore fails with:
psql:x:384: ERROR: foreign key constraint "accepttaskevent" cannot be
implemented
DETAIL: Key colum
Harry Hehl
DiskStream Incorporated
v: 519.579.8166 x30
f: 519.579.9746
www.diskstream.com
This communication is intended to be received by the individual or entity to whom or to which it is addressed and may contain information that is confidential and/or subject to copyright or
Hello,
after a crash of my 64-bit server I have set up a new server (32 bit).
The harddsisk of the former server is now in my new server and I have access
to the partion where the data were stored.
I have tried the following:
I copied the contents of /var/lib/pgsql from the old installation into t
There seems to be many posts on this issue but I not yet found an answer to the
seq scan issue.
I am having an issue with a joins. I am using 8.0.3 on FC4
Query: select * from ommemberrelation where srcobj='somevalue' and dstobj in
(select objectid from omfilesysentry where name='dir15_file80'
7;re using
> pg_start/stop_backup so an md5 check is out of the question.
>
> pg version 8.0
I would doubt if it is a full test but in the past when I have had
corruptions in the database its been a full vacuum that has spotted
them.
--
Harry
http://www.hjackson.org
http://www.uklug.co.uk
on the dev database or missing
index's etc. Have you vacuum analyzed D2?
One other possible reason is that D1 is mostly in cache and D2 isn't.
If you run the query twice on D2 immediately after each other is the
second query much faster. If this is the case what you might be seeing
is D
their database although I could be wrong. The
other thing is that Oracle is supported by various platforms etc and
that support will include their replication or clustering offering.
Sun has offered to support PostgreSQL just recently but have they
offered to support any of the replication of
be compromised. I know
you can use "begin; commit;" from the application but when working
with other developers there are no guarantees that they will always be
using them or more likely a mistake will be made by me or someone else
and I want the database to handle it.
--
H
may yet need to use it again because I can find
nothing else that will do the job. For all its faults its most
certainly filling a gap in the market.
I don't want to use phpBB and I will need to be dragged kicking and
screaming to drink from that well again but were needs must, better
the
On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 30 Dec 2005 at 9:36, Harry Jackson wrote:
>
> > PHPBB. I don't want to use PHPBB due to its complete lack of anything
> > resembling security.
>
> Just curious - where do you get your inf
What would people recommendation be for Bulleting Board software. I am
after something that uses PostgreSQL and has similar features of
PHPBB. I don't want to use PHPBB due to its complete lack of anything
resembling security.
--
Harry
http://www.hjackson.org
http://www.uklug.
On 12/17/05, hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote:
> must have missed that one. thanks - we are moving to 8.1 anyway (50-150%
> increase in performance for some specific tasks!).
For which tasks in particular are you seeing this king of gain?
Harry
--
http://www.
upper to get case insensitive
ordering if I ever need it.
The bottom line seems to be: if you're planning to store data with languages
from across the world, initialise your database cluster with the C locale
and Unicode encoding.
Thanks again to everyone who replied!
Kind regards
Harry Mant
ing with C locale.
Okay, that's great, so I'm going to re-initialise my database cluster with
the C locale this week-end.
I'll report the results, for the record.
Thanks to everyone who replied!
Kind regards
Harry Mantheakis
London, UK
---(end of broa
d words.
I think I'll have to suck it and see, and then post my results - but that
won't be until after this next week-end.
Kind regards
Harry Mantheakis
London, UK
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
European names/words. (I've tried searching for
this topic, but failed to find an answer.)
Would specifying a locale for LC_COLLATE take care of this? Perhaps
something like this:
initdb --locale=C --lc-collate=en_GB.UTF-8 --encoding UNICODE
I'm sorry to drag this out. Perhaps I can
dora Core 3.
Meanwhile, am I correct in assuming that re-initialising my database cluster
with "--locale=C" will solve the problem?
What is more, am I correct in assuming that I can then restore my data with
pg_restore, as prescribed in the documentation?
Kind regards
Harry Manth
I wonder if someone might be kind enough to confirm that this is the right
approach to solving the problem.
Many thanks!
Harry Mantheakis
London, UK
---(end of broadcast)---
TIP 6: explain analyze is your friend
de are there any decent examples on using libpq online. The
ones in the docs are minimal at best and assume text parameters which
make things a bit too easy. I have also greped through the contrib
directories and most of the src in there seems to be using PQexec. I
would like to see a wor
This was posted in news.groups, but it was not posted to the list.
REQUEST FOR DISCUSSION (RFD)
unmoderated group comp.databases.postgresql.admin
unmoderated group comp.databases.postgresql.general
unmoderated group comp.databases.postgresql.hackers
David Teran wrote:
The real question was: are there open known bugs where a select
statement does not return a correct result, meaning a wrong number of
rows? Were there a lot of errors like this?
We are asking this because this makes trouble with the database we are
currently using. Of course w
Bruno Wolff III writes:
> On Wed, Oct 08, 2003 at 12:23:04 +0100,
> Harry Broomhall <[EMAIL PROTECTED]> wrote:
> >I wonder if anybody could give me a few pointers on a problem I face.
> >
> >I need to do an UPDATE on table A, from an effective left outer j
am currently
doing a left outer join into a temporary file, then the UPDATE, but this
involves two joins!
Is there a better way of doing this, or do I have to keep using the
temporary file?
Regards,
Harry.
---(end of broadcast)---
TI
ot exist
Firstly, is there anyway to find out which Schema I am working on, so I
could query the pg_tables with a specified schemaname??
I have tried to select current_schema. However, it always return
"public" to me.
Second, I am wondering how could I drop the automically crea
test
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
;
COMMIT;
However, when I try to call this function via ODBC ( namely in the
Borland DBExplorer ). It got none information for me! I am wondoring
is ODBC supporting RefCursor, since the FAQ of GBorg said the ODBC
only support simple data type. Therefore, does
>On Sat, Apr 28, 2001 at 09:46:44AM +0800, Harry Yau wrote:
>> Dear:
>> I wanna create a function that return a multiple rows in to a
single
>>
>> row.
>> example:
>> CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
>> TEST
ssible to make it to return something like
-
petersusanjohn
I have to use this result to print in quick report.
THANK YOU VERY MUCH
Harry Yau
---(end of broadcast)---
TIP 2: you can get off all lists at once with th
ssible to make it to return something like
-
petersusanjohn
I have to use this result to print in quick report.
THANK YOU VERY MUCH
Harry Yau
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Anyone know how to create auto incrementing fields?
--
Harry
[EMAIL PROTECTED]
http://www.doc.ic.ac.uk/~hw97/Nojer2
Nojer2 on chat.yahoo.com and zapidonia.com
ICQ number 18519769
Has anyone gotten Postgres 6.3.2 running on SCO UnixWare 2.1.2?
I can get it to compile and install but initdb fails.
postgres core dumps processing this line in initdb:
echo "CREATE RULE _RETpg_user AS ON SELECT TO pg_user DO INSTEAD \
SELECT usename, usesysid, usecreatedb, usetrace, \
u
59 matches
Mail list logo
