On 01/02/2025 4:56 pm, Tom Lane wrote:
Larry Rosenman writes:
Would it make sense for ONLY drop database to have the above loop?
Not really. We'd just be papering over the most-easily-observable
consequence of readdir's malfeasance. There'd still be problems
like basebackups
On 01/02/2025 3:42 pm, Thomas Munro wrote:
On Fri, Jan 3, 2025 at 10:16 AM Larry Rosenman wrote:
What about doing what Rick suggests?
do {
dir = opendir("X");
dp = readdir(dir);
if (dp != NULL)
unlink(dp->d_name);
close(dir);
} whil
On 01/02/2025 2:50 pm, Bruce Momjian wrote:
On Thu, Jan 2, 2025 at 03:48:53PM -0500, Tom Lane wrote:
Larry Rosenman writes:
> @Tom Lane: This is what Rick Macklem (NFS dev on FreeBSD) has to say on
> my issue.
Thanks for reaching out to him. So if I'm reading this correctly,
the
@Tom Lane: This is what Rick Macklem (NFS dev on FreeBSD) has to say on
my issue.
Original Message
Subject: Re: A new look at old NFS readdir() problems?
Date: 01/02/2025 10:08 am
From: Rick Macklem
To: Thomas Munro
Cc: Rick Macklem , Larry Rosenman
On Thu, Jan 2, 2025 at
On 12/31/2024 5:37 pm, Tom Lane wrote:
Larry Rosenman writes:
On 12/31/2024 5:24 pm, Thomas Munro wrote:
The implementation-specific cookie scheme for encoding a sort of
cursor position across readdir() calls has various different problems
on various different OSes, NFS implementations and
On 12/31/2024 5:24 pm, Thomas Munro wrote:
On Wed, Jan 1, 2025 at 11:44 AM Tom Lane wrote:
Larry Rosenman writes:
> On 12/31/2024 12:22 pm, Larry Rosenman wrote:
>> When I try to drop a database, PostgreSQL leaves files in the directory
>> and does not even try to delete them
On 12/31/2024 12:22 pm, Larry Rosenman wrote:
When I try to drop a database, PostgreSQL leaves files in the directory
and does not even try to delete them.
PostgreSQL 16.6, FreeBSD 14.2, PGDATA mounted NFS from UGreen NAS.
Truss of the create/delete attached.
It does NOT seem to happen PG
❯ /usr/local/opt/krb5/bin/krb5-config --prefix
/usr/local/Cellar/krb5/1.20
wf-corporate-chef on master +6 -420 [✘!] on ☁️ (us-east-1) on ﴃ
WhereTo - Prod
❯
Same on my M1 iMac (migrated from an Intel iMac however)
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642
WhereTo - Prod
❯ krb5-config --prefix
/
~ via 💎 v3.1.2 on ☁️ (us-east-1) on ﴃ WhereTo - Prod
❯
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
All of a sudden I'm getting repo not found for
Ubuntu 16.04 LTS on the APT repo. Why?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
I can spin up a VM on SLES 12 assuming someone can point me to the right
place to get
an ISO, etc, and I don't need a payfor license.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round
erts=>1, # --enable-cassert
integer_datetimes=>1, # --enable-integer-datetimes
nls=>undef, # --enable-nls=
tcl=>'c:\tcl', # --with-tcl=
perl=>'c:\perl',#
On 12/23/2021 11:23 am, Andrew Dunstan wrote:
On 12/23/21 11:27, Larry Rosenman wrote:
For the 9.2 error, try setting this in the config_env stanza:
CFLAGS => '-O2 -fPIC',
That got us further, but it dies on startdb:
$ cat startdb-C-1.log
waiting for server to star
On 12/23/2021 10:13 am, Andrew Dunstan wrote:
On 12/23/21 08:50, Andrew Dunstan wrote:
On 12/22/21 23:20, Larry Rosenman wrote:
On 12/22/2021 10:15 pm, Tom Lane wrote:
Larry Rosenman writes:
On 12/22/2021 9:59 pm, Tom Lane wrote:
Does it work if you drop --enable-nls? (It'd likely be
On 12/22/2021 10:15 pm, Tom Lane wrote:
Larry Rosenman writes:
On 12/22/2021 9:59 pm, Tom Lane wrote:
Does it work if you drop --enable-nls? (It'd likely be worth fixing
if so, but I'm trying to narrow the possible causes.)
Nope...
OK. Since 9.3 succeeds, it seems like i
On 12/22/2021 9:59 pm, Tom Lane wrote:
Larry Rosenman writes:
On 12/22/2021 9:34 pm, Tom Lane wrote:
What configure options did you use?
config_opts =>[
qw(
--enable-cassert
--enable-debug
--enable-nls
--enable-tap-te
On 12/22/2021 9:34 pm, Tom Lane wrote:
Larry Rosenman writes:
REL9_2_STABLE make dies on:
ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC
[etc]
What configure options did you use?
regards, tom lane
On 12/22/2021 7:16 pm, Larry Rosenman wrote:
On 12/22/2021 7:20 am, Andrew Dunstan wrote:
On 12/21/21 15:06, Larry Rosenman wrote:
I filled out that form on the 16th, and haven't gotten a new animal
assignment. Is there
a problem with my data?
It's a manual process, done
On 12/22/2021 7:20 am, Andrew Dunstan wrote:
On 12/21/21 15:06, Larry Rosenman wrote:
I filled out that form on the 16th, and haven't gotten a new animal
assignment. Is there
a problem with my data?
It's a manual process, done when your friendly admins have time. I have
appro
On 12/16/2021 3:23 pm, Andrew Dunstan wrote:
On 12/16/21 15:53, Larry Rosenman wrote:
I get:
ERROR for site owner:
Invalid domain for site key
on https://pgbuildfarm.org/cgi-bin/register-form.pl
try https://buildfarm.postgresql.org/cgi-bin/register-form.pl
cheers
andrew
I filled out
On 12/16/2021 2:47 pm, Andrew Dunstan wrote:
On 12/16/21 12:26, Larry Rosenman wrote:
On 12/16/2021 11:17 am, Andrew Dunstan wrote:
On 12/16/21 11:11, Larry Rosenman wrote:
A new animal, because we're not supporting every build option. On
the
non-live branches you really only
On 12/16/2021 11:17 am, Andrew Dunstan wrote:
On 12/16/21 11:11, Larry Rosenman wrote:
A new animal, because we're not supporting every build option. On the
non-live branches you really only want:
--enable-debug --enable-cassert --enable-nls
--enable-tap-tests --with-perl
Yo
On 12/16/2021 10:02 am, Andrew Dunstan wrote:
On 12/15/21 21:36, Larry Rosenman wrote:
On 12/15/2021 11:15 am, Andrew Dunstan wrote:
OK, old_branches_of_interest.txt now exists on the buildfarm server,
and
the code has been modified to take notice of it (i.e. to accept
builds
for branches
//www.enterprisedb.com
Would a FreeBSD head (peripatus or a new animal) help?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
user of macos and I would not buy
it
just for this purpose.
Is it possible to get some remote ssh access?
You can request a GCC Compile Farm account
(https://cfarm.tetaneutral.net/users/new/).
AWS also has macos instances:
https://aws.amazon.com/pm/ec2-mac/
--
Larry Rosenman
On 10/01/2019 8:33 pm, Thomas Munro wrote:
On Wed, Oct 2, 2019 at 4:49 AM Larry Rosenman wrote:
On 10/01/2019 10:46 am, Tom Lane wrote:
> Larry Rosenman writes:
>> My Buildfarm animal (peripatus) has been failing check since
>> yesterday.
>> Can someone look at it?
>
&
On 10/01/2019 8:27 pm, Larry Rosenman wrote:
FreeBSD SVN rev:
r352600 - - 1.69G 2019-09-22 13:13
r352873 NR / 43.1G 2019-09-29 16:36
I went from r352600 to r352873 and now I'm getting PostgreSQL
permission denied
errors on the check phase of the build.
Fr
: FYI.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
On 10/01/2019 10:46 am, Tom Lane wrote:
Larry Rosenman writes:
My Buildfarm animal (peripatus) has been failing check since
yesterday.
Can someone look at it?
It's been doing this in parallel queries, in v11 and up:
2019-09-29 19:00:15.534 CDT [49513:1] ERROR: could not open shared
m
My Buildfarm animal (peripatus) has been failing check since yesterday.
Can someone look at it?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
On 08/06/2019 1:16 pm, Peter Geoghegan wrote:
On Tue, Aug 6, 2019 at 11:11 AM Larry Rosenman wrote:
As a followup, btcheck found another index that had issues, and a
toast
table was missing a chunk.
I have ALL the data I used to create this table still around so I just
dropped it and am
On 08/06/2019 12:45 pm, Larry Rosenman wrote:
On 08/06/2019 12:35 pm, Peter Geoghegan wrote:
On Tue, Aug 6, 2019 at 10:34 AM Larry Rosenman wrote:
ERROR: function bt_index_check(index => oid) does not exist
LINE 1: SELECT bt_index_check(index => c.oid),
^
HINT: No fu
On 08/06/2019 12:35 pm, Peter Geoghegan wrote:
On Tue, Aug 6, 2019 at 10:34 AM Larry Rosenman wrote:
ERROR: function bt_index_check(index => oid) does not exist
LINE 1: SELECT bt_index_check(index => c.oid),
^
HINT: No function matches the given name and argument type
index => c.oid),
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
ler=#
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
-
PostgreSQL 11.4 on amd64-portbld-freebsd12.0, compiled by FreeBSD clang
version 8.0.0 (tags/RELEASE_800/final 356365) (based on LLVM 8.0.0),
64-bit
(1 row)
ler=#
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
l that David Rowley has joined the ranks of PostgreSQL
> committers.
>
> Congratulations to David, may the buildfarm be gentle to him, and his first
> revert far away!
Congrats!
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640
On Wed, Oct 17, 2018 at 08:19:52PM -0500, Larry Rosenman wrote:
> On Thu, Oct 18, 2018 at 02:17:14PM +1300, Thomas Munro wrote:
> > On Thu, Oct 18, 2018 at 1:10 PM Tom Lane wrote:
> > > ... However, I'm still slightly interested in how it
> > > was t
er than trying to
> open all 2^32 random paths we're capable of generating).
It has *NOT* been rebooted. I can give y'all id's if you want to go
poking around.
>
> --
> Thomas Munro
> http://www.enterprisedb.com
--
Larry Rosenman http://ww
On Wed, Oct 17, 2018 at 08:55:09PM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > On Wed, Oct 17, 2018 at 08:10:28PM -0400, Tom Lane wrote:
> >> However, I'm still slightly interested in how it
> >> was that that broke DSM so thoroughly ... I pulled down yo
On Wed, Oct 17, 2018 at 08:10:28PM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > On Wed, Oct 17, 2018 at 07:07:09PM -0400, Tom Lane wrote:
> >> ... Was your Python install built
> >> with any special switches? I just used what came from "pkg install".
&
On Wed, Oct 17, 2018 at 07:07:09PM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > On the original failure, I recompiled and reinstalled the 2 Python's I
> > have on this box, and at least 9.3 went back to OK.
>
> Hmm. I'd just finished pulling down FreeB
e but to leak the
> referenced segments, but we can free the control segment. See
> comments in the attached patch for rationale.
>
On the original failure, I recompiled and reinstalled the 2 Python's I
have on this box, and at least 9.3 went back to OK.
> --
> Thoma
On Wed, Oct 17, 2018 at 01:41:59PM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > It looks like my upgrade to the current head of FreeBSD 12-to-be, which
> > includes OpenSSL 1.1.1 broke a bunch of our stuff.
> > In at least the 9.x branches. Just a heads up.
>
&
It looks like my upgrade to the current head of FreeBSD 12-to-be, which
includes OpenSSL 1.1.1 broke a bunch of our stuff.
In at least the 9.x branches. Just a heads up.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l
gt;
as a former S3[79]x assembler programmer, they probably do it in
registers or using TRT. All of which could be word wise.
> regards, tom lane
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
signature.asc
Description: PGP signature
It was never put into the build, and I have a PR open to remove the LLD_UNSAFE
flag for 10.5 and the rest of today's releases.
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=229523
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640
> Done. Hopefully I didn't break anything; a lot of this code has mutated
> to some extent since 9.3. But I expect the buildfarm will point out any
> problems.
The reason you might not have seen it on FreeBSD before is that FreeBSD
12 now uses lld (llvm's LD) to link, and
On Sat, Jul 07, 2018 at 01:33:26PM -0500, Larry Rosenman wrote:
> On Sat, Jul 07, 2018 at 02:28:17PM -0400, Tom Lane wrote:
> > Larry Rosenman writes:
> > > And the winner is:
> >
> > > dddfc4cb2edcfa5497f5d50190a7fb046c51da16 is
On Sat, Jul 07, 2018 at 02:28:17PM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > And the winner is:
>
> > dddfc4cb2edcfa5497f5d50190a7fb046c51da16 is the first bad commit
> > commit dddfc4cb2edcfa5497f5d50190a7fb046c51da16
> > Author: Tom Lane
> > D
On Sat, Jul 07, 2018 at 11:24:48AM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > On Sat, Jul 07, 2018 at 11:11:24AM -0400, Tom Lane wrote:
> >> Larry Rosenman writes:
> >>> f044d71e331d77a0039cec0a11859b5a3c72bc95 fixed it.
>
> >> Don
On Sat, Jul 07, 2018 at 11:11:24AM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > f044d71e331d77a0039cec0a11859b5a3c72bc95 fixed it.
>
> Don't think I believe that conclusion; that patch shouldn't
> have affected anything at all for non-ARM architectures.
>
On Fri, Jul 06, 2018 at 07:18:46PM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > On Fri, Jul 06, 2018 at 06:40:49PM -0400, Tom Lane wrote:
> >> I do not like the "-Wl,-z,notext" thing at all. It fails to explain
> >> why things are working OK in v11
On Fri, Jul 06, 2018 at 06:05:36PM -0500, Larry Rosenman wrote:
> On Fri, Jul 06, 2018 at 06:40:49PM -0400, Tom Lane wrote:
> > Larry Rosenman writes:
> > > anyone want to look at this, or at least give me a clue on how to add
> > > this to 10 & below?
> >
On Fri, Jul 06, 2018 at 06:40:49PM -0400, Tom Lane wrote:
> Larry Rosenman writes:
> > anyone want to look at this, or at least give me a clue on how to add
> > this to 10 & below?
>
> I do not like the "-Wl,-z,notext" thing at all. It fails to explain
>
On Thu, Jul 05, 2018 at 07:47:39AM -0500, Larry Rosenman wrote:
> On Wed, Jul 04, 2018 at 08:37:40PM -0500, Larry Rosenman wrote:
> > On Wed, Jul 04, 2018 at 08:19:48PM -0500, Larry Rosenman wrote:
> > > On Thu, Jul 05, 2018 at 12:56:49PM +1200, Thomas Munro wrote:
> > &g
On Fri, Jul 06, 2018 at 11:35:41AM -0700, Joshua D. Drake wrote:
> On 07/06/2018 11:27 AM, Larry Rosenman wrote:
> > when I pg_dump -Fc the database and then try to restore it after a
> > create database, I get errors. To get a clean restare I need to do:
>
> Knowing the er
schema postgis;
Is the need to do this expected?
This is 10.4 on FreeBSD.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
signature.asc
Description: PGP
On Wed, Jul 04, 2018 at 08:37:40PM -0500, Larry Rosenman wrote:
> On Wed, Jul 04, 2018 at 08:19:48PM -0500, Larry Rosenman wrote:
> > On Thu, Jul 05, 2018 at 12:56:49PM +1200, Thomas Munro wrote:
> > > On Thu, Jul 5, 2018 at 12:35 PM, Larry Rosenman wrote:
> > > > I
On Wed, Jul 04, 2018 at 08:19:48PM -0500, Larry Rosenman wrote:
> On Thu, Jul 05, 2018 at 12:56:49PM +1200, Thomas Munro wrote:
> > On Thu, Jul 5, 2018 at 12:35 PM, Larry Rosenman wrote:
> > > I agree. Is there an easy way I can add this work around to peripatus&
On Thu, Jul 05, 2018 at 12:56:49PM +1200, Thomas Munro wrote:
> On Thu, Jul 5, 2018 at 12:35 PM, Larry Rosenman wrote:
> > I agree. Is there an easy way I can add this work around to peripatus'
> > source tree:
> >
> > It may be that adding "LDFLAGS+= -W
On Wed, Jul 04, 2018 at 07:35:28PM -0500, Larry Rosenman wrote:
> On Thu, Jul 05, 2018 at 12:30:37PM +1200, Thomas Munro wrote:
> > On Thu, Jul 5, 2018 at 11:43 AM, Larry Rosenman wrote:
> > > I noticed my buildfarm member peripatus hadn't been building due to me
>
On Thu, Jul 05, 2018 at 12:30:37PM +1200, Thomas Munro wrote:
> On Thu, Jul 5, 2018 at 11:43 AM, Larry Rosenman wrote:
> > I noticed my buildfarm member peripatus hadn't been building due to me
> > missing a perl library. After I fixed that I get failures on:
> >
>
today, clang 6.0.1, lld as the linker.
Can someone take a look at these?
I've tried making sure all the cache's are clear, etc, same results.
Thanks.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Ma
63 matches
Mail list logo
