Yes the board has the embedded 68k architecture based Freescale Coldfire processor. The board has a custom built Linux based on the kernel 2.6.38 The database is stored on an SD card of 4GB capacity. This is the table we have. CREATE TABLE financialtransaction ( FINANCIALTRANSACTIONID BIGINT NOT NULL PRIMARY KEY, TIME_STAMP TIMESTAMP, ATTENDANT SMALLINT, RECEIPTPRINTED BOOLEAN DEFAULT FALSE, ODOMETER VARCHAR(20), ENGINEHOUR NUMERIC(9,2), CONSTRAINT financialtransaction_pkey PRIMARY KEY (FINANCIALTRANSACTIONID ) ) WITH ( OIDS=FALSE ); ALTER TABLE financialtransaction OWNER TO postgres; 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 records. Please let me know if you need any other information. Thanks and Regards Jayashankar -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John R Pierce Sent: 22 May 2012 PM 12:00 To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 this embedded system use for the database? telling us FINANCIALWHATEVERID > 1000 doesn't really do us much good since we have no idea what your database looks like, or what your code is doing. the log seems to indicate there was a constraint violation just before the exception hit. -- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Larsen & Toubro Limited www.larsentoubro.com This Email may contain confidential or privileged information for the intended recipient (s). If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. Earth Day. Every Day. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
