Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId
On Wed, 2010-07-21 at 21:20 +0200, Andres Freund wrote: > > > > > > If want I can write a patch for that as well, seems to be trivial enough. > > Updated patch attached. > hm. I dont want to push - just to ask: Is any comitter looking either > at the patch or the bug? Patch looks OK, though IMHO wouldn't be looking to backpatch this. I'll look at this in more detail next week, unless others wish to. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #5567: will not install
The following bug has been logged online: Bug reference: 5567 Logged by: Denise Kanyuh Email address: kan...@us.ibm.com PostgreSQL version: 8.0.15 Operating system: AIX 7.1 Description:will not install Details: When trying to test our product which incorporates postgress on the newest release of AIX we get this error -- will AIX 7.1 be supported on any release of postgres? The installation failed at step: PostGreSOL Installation. For additional information, please review the log files stored in the archive: /opt/IBM/tivoli/tip/logs.zip logs.zip include the initDB.out file which found a message: # pwd /opt/IBM/tivoli/tip/logs/tbsm # more initDB.out Error: Unknown architecture for shared libraries # -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #5568: will not install
The following bug has been logged online: Bug reference: 5568 Logged by: Lowell Harris Email address: lhar...@goldstandardit.com PostgreSQL version: 8.4.4-1 Windows Operating system: Windows XP SP3 Description:will not install Details: I keep getting an error message: "An error occured executing the Microsoft VC++ runtime installer" This computer has MS Visual Studion 2005 and I also went ot Microsoft and updated the CV++ runtimes. I found an install string in your support forum adn it tried to install, but I received another error message near the end of hte installation process. The program itself won't connect to the local host server. On and on and on. I'm somewhat disapointed that the Best Database in the World won';t even install? Any thoughts? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5567: will not install
On Thu, Jul 22, 2010 at 06:13, Denise Kanyuh wrote: > PostgreSQL version: 8.0.15 [ BTW the latest version of 8.0 is 8.0.25, also note 8.0 is getting EOL'ed within the next month or so, see http://www.postgresql.org/about/news.1214 ] > When trying to test our product which incorporates postgress on the newest > release of AIX we get this error -- will AIX 7.1 be supported on any release > of postgres? Skimming http://www.postgresql.org/docs/8.4/interactive/installation-platform-notes.html-- while it does not say anything specific about AIX 7.1, the biggest problems seem to be with old gcc versions. I would think if 7.1 ships with a decent version of gcc it will 'just work'. In any event you may want to give that page a look. > The installation failed at step: PostGreSOL Installation. > For additional information, please review the log files stored in the > archive: /opt/IBM/tivoli/tip/logs.zip > logs.zip include the initDB.out file which found a message: > # pwd > /opt/IBM/tivoli/tip/logs/tbsm > # more initDB.out > Error: Unknown architecture for shared libraries This looks like its coming from a 3rd party installer, my hunch is they do not ship binaries for AIX (7.1). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5567: will not install
On Thu, Jul 22, 2010 at 11:51, Denise Kanyuh wrote: > > Alex, > Yes -- I am aware that we are on an old release -- > > when you say - my hunch is > > they do not ship binaries for AIX (7.1). > > > what binaries are you taking about --- we use the same installer and files > on AIX 6.1 and it works -- it appears that there is something different in > AIX 7.1 -- either something that is not longer in the AIX 7.1 OS base (is > that what you where thinking) or someing in posgres that need to change to > accomidate this new OS? > Its this bit: >> The installation failed at step: PostGreSOL Installation. >> For additional information, please review the log files stored in the >> archive: /opt/IBM/tivoli/tip/logs.zip Ive no idea what that the above is doing, it looks like some kind of installer... Given the error you seem to get "Unknown architecture for shared libraries", it sounds like its using precompiled binaries for a different architecture or older version of AIX. Again, Ive no idea as all that is hidden by the installer. I suspect if you can download the tarball and go through the ./configure && make dance and show us any errors you hit along the way, someone might be able to help... If you dont get any errors, then maybe showing us the output of: uname -a, gcc -v, (and on the resultant binaries) file initdb, ldd initdb. An strace (or ktrace, not sure what AIX has if any) of initdb may also be helpful. It might also be interesting to see what happens when you run initdb directly, the installers log file may be omitting something interesting. Im no AIX guy, but you have not provided nearly enough info for someone to help you :-(.
Re: [BUGS] BUG #5567: will not install
kan...@us.ibm.com ("Denise Kanyuh") writes:
> The following bug has been logged online:
>
> Bug reference: 5567
> Logged by: Denise Kanyuh
> Email address: kan...@us.ibm.com
> PostgreSQL version: 8.0.15
> Operating system: AIX 7.1
> Description:will not install
> Details:
>
> When trying to test our product which incorporates postgress on the newest
> release of AIX we get this error -- will AIX 7.1 be supported on any release
> of postgres?
A significant portion of the problem likely relates to using a mighty
ancient version of PostgreSQL. Version 8.0 was effectively obsolesced
by 8.1 in 2005, some five years ago.
That's pretty relevant in two ways you should be concerned about:
1. Version 8.0 has been declared officially obsolete
Issues with 8.0 are exceedingly unlikely to get fixed.
2. PostgreSQL Version 8.1 was the first version where AIX became
sufficiently supported to allow it to be tested on a regular
basis on the PostgreSQL Build Farm.
http://pgbuildfarm.org/cgi-bin/show_status.pl
There were material changes to the build process introduced in
version 8.1 to allow substantially all parts of PostgreSQL
including contrib modules to compile and run on AIX.
I would not recommend wasting *any* time trying to rectify issues with a
five-year-old version of PostgreSQL; you should test the build process
with a version of PostgreSQL that is still supported.
--
"cbbrowne","@","gmail.com"
"Heuristics (from the French heure, "hour") limit the amount of time
spent executing something. [When using heuristics] it shouldn't take
longer than an hour to do something."
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5568: will not install
"Lowell Harris" wrote: > I keep getting an error message: > "An error occured executing the Microsoft VC++ runtime installer" > This computer has MS Visual Studion 2005 and I also went ot > Microsoft and updated the CV++ runtimes. What was the URL of the download you're installing? Exactly what steps did you take to attempt installation? > I found an install string in your support forum Which was? > it tried to install, but I received another error message near the end of hte installation process. Which was? > The program itself won't connect to the local host server. So the server is running? > On and on and on. If you want useful suggestions, a bit more detail is needed. > I'm somewhat disapointed that the Best Database in the World > won';t even install? Well, it installs just fine for most users; so the question is: what's different in your case? You need to give us a lot more detail to be able to determine that. > Any thoughts? http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5567: will not install
On Thu, Jul 22, 2010 at 11:21, Chris Browne wrote: > 2. PostgreSQL Version 8.1 was the first version where AIX became > sufficiently supported to allow it to be tested on a regular > basis on the PostgreSQL Build Farm. > http://pgbuildfarm.org/cgi-bin/show_status.pl > > There were material changes to the build process introduced in > version 8.1 to allow substantially all parts of PostgreSQL > including contrib modules to compile and run on AIX. Yeah I'll note we dont have any coverage of AIX on 8.0 and below. Even then we only seem to have coverage of AIX 5.3. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId
On Mon, Jul 19, 2010 at 4:35 PM, Andres Freund wrote: >> Well. I got that far. But why is that something worthy of support? >> For one I have a hard time imaging a sensible use case, for another doing >> anything in that deeply nested transactions seems to gets really slow (the >> chain of transactions gets walked at some places for one thing, there seem >> to be others). >> >> If want I can write a patch for that as well, seems to be trivial enough. > Updated patch attached. Considering that this is a crasher, I think we'll need to back-patch this. The proposed patch applies only as far back as 8.3, due to the lazy XID assignment changes in that version, but it looks like the bug exists all the way back to 8.0. It looks like only minor adjustments are required for the older branches, though. 7.4 is not affected, as it does not have subtransactions. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId
On Thu, Jul 22, 2010 at 5:01 PM, Robert Haas wrote: > On Mon, Jul 19, 2010 at 4:35 PM, Andres Freund wrote: >>> Well. I got that far. But why is that something worthy of support? >>> For one I have a hard time imaging a sensible use case, for another doing >>> anything in that deeply nested transactions seems to gets really slow (the >>> chain of transactions gets walked at some places for one thing, there seem >>> to be others). >>> >>> If want I can write a patch for that as well, seems to be trivial enough. >> Updated patch attached. > > Considering that this is a crasher, I think we'll need to back-patch > this. The proposed patch applies only as far back as 8.3, due to the > lazy XID assignment changes in that version, but it looks like the bug > exists all the way back to 8.0. It looks like only minor adjustments > are required for the older branches, though. 7.4 is not affected, as > it does not have subtransactions. Can someone provide a reproducible test case for this bug? I wasn't easily able to reproduce it. Attached please find a cleaned-up version of the patch for CVS HEAD. I am having a bit of trouble compiling the 8.2 patch I hacked up, and I believe that's because the git respository is borked. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company subxact-xid-recurse.patch Description: Binary data -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId
On Thu, Jul 22, 2010 at 06:29:47PM -0400, Robert Haas wrote: > On Thu, Jul 22, 2010 at 5:01 PM, Robert Haas wrote: > > On Mon, Jul 19, 2010 at 4:35 PM, Andres Freund wrote: > >>> Well. I got that far. But why is that something worthy of support? > >>> For one I have a hard time imaging a sensible use case, for another doing > >>> anything in that deeply nested transactions seems to gets really slow (the > >>> chain of transactions gets walked at some places for one thing, there seem > >>> to be others). > >>> > >>> If want I can write a patch for that as well, seems to be trivial enough. > >> Updated patch attached. > > > > Considering that this is a crasher, I think we'll need to back-patch > > this. The proposed patch applies only as far back as 8.3, due to the > > lazy XID assignment changes in that version, but it looks like the bug > > exists all the way back to 8.0. It looks like only minor adjustments > > are required for the older branches, though. 7.4 is not affected, as > > it does not have subtransactions. > Can someone provide a reproducible test case for this bug? I wasn't > easily able to reproduce it. 201007191950.13856.and...@anarazel.de contains a test script. You need to actually do a action causing an xid to get calculated (heap_(insert|update|delete) basically) after youre deeply stacked. > Attached please find a cleaned-up version of the patch for CVS HEAD. > I am having a bit of trouble compiling the 8.2 patch I hacked up, and > I believe that's because the git respository is borked. Yes, the "old" git repo is borked. Either use Andrew's from github or the one from magnus... Andres -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId
On Thu, Jul 22, 2010 at 6:49 PM, Andres Freund wrote: >> Can someone provide a reproducible test case for this bug? I wasn't >> easily able to reproduce it. > 201007191950.13856.and...@anarazel.de contains a test script. You need > to actually do a action causing an xid to get calculated > (heap_(insert|update|delete) basically) after youre deeply stacked. Thanks, perfect. Committed and back-patched to 8.0. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5567: will not install
On Thu, Jul 22, 2010 at 2:08 PM, Alex Hunsaker wrote: > Its this bit: >>> The installation failed at step: PostGreSOL Installation. >>> For additional information, please review the log files stored in the >>> archive: /opt/IBM/tivoli/tip/logs.zip > Ive no idea what that the above is doing, it looks like some kind of > installer... The installer apparently isn't too smart, either, because the second-to-last name of our product is the 17th letter of the alphabet, not the 15th. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] DETAIL: Failed on request of size 8
Hi I am running a query on postgres and got the following error: ERROR: out of memory DETAIL: Failed on request of size 8 Can somebody help? Thanks
Re: [BUGS] DETAIL: Failed on request of size 8
On 23/07/10 14:34, vamsi krishna wrote: Hi I am running a query on postgres and got the following error: ERROR: out of memory DETAIL: Failed on request of size 8 Hmm - looks like your system needs more memory to complete the query (ahem - would help to see the query, plus EXPLAIN output thereof). To be of any more help, you need to supply more detail - see: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Data extraction via sql from postgres 8.2 to oracle9i.
On Wed, Jul 21, 2010 at 2:04 AM, wrote: > We look for Data extraction via sql from postgres 8.2 to oracle9i. > Postgres and oracle both are remote servers of solaries > Kindly suggest steps and drivers needed to perform the task. This doesn't sound like a bug to me, so you should probably choose a more appropriate mailing list on which to ask this question. You'll probably have better luck if you provide a few more details about what your setup is and what you're trying to do with it. http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5562: icon "terrestrial globe" much too big
On Fri, Jul 16, 2010 at 6:39 AM, Heinz Groote wrote: > > The following bug has been logged online: > > Bug reference: 5562 > Logged by: Heinz Groote > Email address: heinz.gro...@t-online.de > PostgreSQL version: 8.4 > Operating system: opensuse 11.2 > Description: icon "terrestrial globe" much too big > Details: > > The image size of the icons with the terrestrial globe is so big that it > destroys the main menu of gnome. > > (Idea: By reducing the image size to 31x31 with GIMP, the size compares to > all the other icons.) > > I hopefully may report this subject on this place, because it is an overall > problem with the installation of postgresql with all the modules using this > type of icon. > > Thank you > regards > *** heinz *** PostgreSQL itself doesn't have icons. Perhaps this is a pgadmin issue? http://www.pgadmin.org/support/list.php -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] page corruption after moving tablespace
I was investigating some strange page corruption today in which the page was completely zeroed except for the LSN and TLI. I found a sequence that can cause that problem even in 9.0: (wal_level must be set to "archive" or greater) 1. Create a tablespace "t1" 2. Create a table "foo" 3. Attach to the backend with gdb, and set a breakpoint at the START_CRITICAL_SECTION() line in heap_insert(). Continue in gdb. 4. Insert a tuple into foo. 5. gdb should break. At that time, send a SIGKILL. 6. restart the server (if it doesn't restart itself) 7. ALTER TABLE foo SET TABLESPACE t1; 8. SELECT * FROM foo; ERROR: invalid page header in block 0 of relation pg_tblspc/16384/PG_9.1_201007151/11876/24576 The SIGKILL is just a way to get an all-zero page to end up in a heap file. Any time any relation gets an all-zero page (which is generally treated as a valid situation in postgres), changing the tablespace is a problem. The code does a copy_relation_data, and that does a log_newpage, and that sets the LSN and TLI on the page and then writes it. But on an all-zero page, that leaves the page corrupt. I think the simple fix would be to have copy_relation_data call PageInit() if it's a new page. Are there other areas where a similar problem might exist? Regards, Jeff Davis -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
