On 01.03.2013 17:15, Jon Nelson wrote:
Using PostgreSQL 8.4.13 on ScientificLinux 6.3 (x86_64), I noticed
that a pg_dump ran out of (local) disk space.
However, the server was still using CPU and disk resources. An strace
clearly showed this pattern:
read() = 8192
sendto(...) = -1 EPIPE
--
The following bug has been logged on the website:
Bug reference: 7924
Logged by: Maria
Email address: mv.gonza...@cir.es
PostgreSQL version: Unsupported/Unknown
Operating system: RedHat
Description:
Hi!
I have a trigger that when you update a value on a table, makes
"mv.gonza...@cir.es" wrote:
> On table_B appears:
> id | situation | when
> +---+-
> 23 | Started | 2013-03-08 12:33:35
> 23 | Started | 2013-03-08 12:33:37
>
> I don't understand why after the second update, the insert done on table_B
> is inc
Just to let everyone know that I haven't forgotten this. I just don't have
any time to spend on it.
The problem still occurs.
2013/2/20 Peter Kroon
> I've migrated everything to Linux and I'm able to continue my work.
> I'll get back on this next week.
>
>
> 2013/2/19 Lou Picciano
>
>> Sorry,
select version();
version
--
PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.4.6 20120305 (Red Hat 4.4.6-4), 64-bit
Folks,
This is one I've never seen before:
=> select generate_master_tables();
WARNING: AbortTransaction while in COMMIT state
PANIC: cannot abort transaction 9387287, it was already committed
PANIC: cannot abort transaction 9387287, it was already committed
The connection to the server was lo
Do you have any non default procedural languages installed? I provoked
exactly that error with a similar script which used a PL/R procedure
(see BUGS thread "PL/R Median Busts Commit"...the cause is signal
hi-jacking in that case).
Regards
Mark
On 09/03/13 13:27, Josh Berkus wrote:
Folks,
Josh Berkus wrote:
> Folks,
>
> This is one I've never seen before:
>
> => select generate_master_tables();
> WARNING: AbortTransaction while in COMMIT state
> PANIC: cannot abort transaction 9387287, it was already committed
Anything that causes an ERROR in the final stages of a transaction
c
