| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | andreas-postgresql(at)creative-memory(dot)de |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #13633: ERROR: invalid memory alloc request size |
| Date: | 2015-09-22 16:48:40 |
| Message-ID: | 9088.1442940520@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
andreas-postgresql(at)creative-memory(dot)de writes:
> SELECT G.MarkerID,G.Allel1,G.Allel2, count (G.TierLIDint) as nH
> FROM GenotypHD as G, TiereInSets as TS, Marker as M
> WHERE TS.TierSetID='HD.09.15' and TS.TierLIDint=G.TierLIDint and
> M.Version='3' and M.MarkerID=G.MarkerID and G.Allel1<>G.Allel2
> GROUP BY G.MarkerID,G.Allel1,G.Allel2;
> ERROR: invalid memory alloc request size 1073741824
FWIW, I could not reproduce this on the basis of the supplied information,
ie just creating the tables and running this query does not do anything
surprising. It looks like possibly a corrupt-data issue --- can you do
"select * from" each table without problems?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Hauser | 2015-09-22 18:09:31 | Re: BUG #13633: ERROR: invalid memory alloc request size |
| Previous Message | David G. Johnston | 2015-09-22 15:56:53 | Re: [BUGS] BUG #13632: violation de l'intégrité référentielle |