Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Jayashankar K B
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayashankar K B Sent: Tuesday, May 22, 2012 11:27 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Postgres process is crashing continously in 9.1.1 Hi, We are using Postgres 9.1.1 on a board with Coldfire controller. The postgres

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread John R Pierce
On 05/21/12 11:05 PM, Jayashankar K B wrote: board with Coldfire controller. what is this board? Coldfire is the embedded 68k-like Freescale processor? what operating system is this under? what sort of storage does this embedded system use for the database? telling us

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Jayashankar K B
: Re: [GENERAL] Postgres process is crashing continously in 9.1.1 On 05/21/12 11:05 PM, Jayashankar K B wrote: board with Coldfire controller. what is this board? Coldfire is the embedded 68k-like Freescale processor? what operating system is this under? what sort of storage does

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Craig Ringer
On 05/22/2012 01:57 PM, Jayashankar K B wrote: Please let us know why this crash is happening and how we can fix it. LOG: server process (PID 4016) was terminated by signal 11: Segmentation fault If you can't reproduce this crash on a more developer-friendly machine than your embedded

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Chris Angelico
On Tue, May 22, 2012 at 4:51 PM, Jayashankar K B jayashankar...@lnties.com wrote: On writing into this table, a stored procedure is triggered which inserts into another table. But crash is happening while writing into this financialtransaction table once this table has more than 1000

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Jayashankar K B
...@postgresql.org] On Behalf Of Chris Angelico Sent: Tuesday, May 22, 2012 3:10 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres process is crashing continously in 9.1.1 On Tue, May 22, 2012 at 4:51 PM, Jayashankar K B jayashankar...@lnties.com wrote: On writing into this table

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Chris Angelico
On Tue, May 22, 2012 at 8:23 PM, Jayashankar K B jayashankar...@lnties.com wrote: But here, the crash is happening right at the insert statement. That is insert itself is failing. Unless the insert is successful, stored procedure is not triggered. Hmm. I wonder is it possible that going past

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Merlin Moncure
On Tue, May 22, 2012 at 5:41 AM, Chris Angelico ros...@gmail.com wrote: On Tue, May 22, 2012 at 8:23 PM, Jayashankar K B jayashankar...@lnties.com wrote: But here, the crash is happening right at the insert statement. That is insert itself is failing. Unless the insert is successful,

[GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread Jayashankar K B
Hi, We are using Postgres 9.1.1 on a board with Coldfire controller. The postgres processes are crashing and restarting upon executing a particular instruction and it keeps repeating. Even when we tried with Postgres 9.1.3, same problem happens. It works fine until the FINANCIALTRANSACTIONID