Received: from smtp2.dnb.com (smtp2.dnb.com [204.254.175.103]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA3M2Zs24114; Fri, 3 Nov 2000 17:02:35 -0500 (EST) (envelope-from SchlobohmJ@DNB.com) Received: from relay.us.dnb.com (relay.us.dnb.com [159.137.225.58]) by smtp2.dnb.com (8.9.3/8.9.3) with ESMTP id RAA15670; Fri, 3 Nov 2000 17:02:26 -0500 (EST) Received: from smtp-gw.us.dnb.com (smtp-gw.us.dnb.com [159.137.225.51]) by relay.us.dnb.com (8.9.3/8.9.3) with SMTP id RAA17820; Fri, 3 Nov 2000 17:02:36 -0500 (EST) Received: from 159.137.224.39 by smtp-gw.us.dnb.com with ESMTP ( WorldSecure Server SMTP Relay(WSS) v4.0.2); Fri, 03 Nov 00 16:54:10 -0500 X-Server-Uuid: 512bef52-27db-11d3-8937-0008c7cf307c Received: by exbhbhbh02.us.dbisna.com with Internet Mail Service ( 5.5.2650.21) id ; Fri, 3 Nov 2000 17:02:34 -0500 From: "Schlobohm, Jack" To: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org cc: "Jie Liang" Subject: RE: [SQL] really need help Date: Fri, 3 Nov 2000 16:45:07 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) X-WSS-ID: 161DEB881208673-02-01 Content-Type: multipart/mixed; boundary="----_=_NextPart_000_01C045DF.55596780" Message-ID: <161DEB881208673-02@WorldSecure_Server__smtp-gw.us.dnb.com_> X-Archive-Number: 200011/15 X-Sequence-Number: 24 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C045DF.55596780 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I would like to stop spending my work day deleting these messages. Is there anybody out there responsible for this? Make it stop! Now! Thanks > -----Original Message----- > From: Jie Liang [SMTP:jliang@ipinc.com] > Sent: Friday, November 03, 2000 1:35 PM > To: pgsql-admin@postgresql.org; pgsql-sql@postgresql.org > Subject: [SQL] need help urgent > > Hi, > > Is anybody have experience about core dump? > We have some scripts have been used for a long time, however, recently, > they seem to have some problems, > the message I got: > > SSELECT priority from priority where source=lower('questionable') > Total insert into preunchecked: 1 > Segmentation fault - core dumped > Segmentation fault - core dumped > > This script has been used for a few monthes, no problem. > > I checked my pgsql.log, I saw: > > Nov 3 00:58:45 wipeout postgres[1638]: query: INSERT INTO > source(id,source) SELECT id,'questionable' from > preunchecked WHERE insertdate>= '2000-11 > -03 00:58:45-08' > Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT version() > Nov 3 00:58:46 wipeout postgres[1642]: query: begin > Nov 3 00:58:46 wipeout postgres[1642]: ProcessUtility: begin > Nov 3 00:58:46 wipeout postgres[1642]: query: set transaction isolation > level serializable > Nov 3 00:58:46 wipeout postgres[1642]: ProcessUtility: set transaction > isolation level serializable > Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT oid from > pg_database where datname = 'template1' > Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT pg_type.oid, > typowner, typname, typlen, typprtlen, typinput, typoutput, typreceive, > typsend, typelem, typdeli > m, typdefault, typrelid, typbyval, usename from pg_type, pg_user where > typowner = usesysid > Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT pg_proc.oid, > proname, prolang, pronargs, prorettype, proretset, proargtypes, prosrc, > probin, usename from pg_ > proc, pg_user where pg_proc.oid > '17216'::oid and proowner = usesysid > Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT pg_aggregate.oid, > aggname, aggtransfn1, aggtransfn2, aggfinalfn, aggtranstype1, > aggbasetype, aggtranstype2, a > gginitval1, agginitval2, usename from pg_aggregate, pg_user where > aggowner = usesysid > > ................ > > We have no script to open a new session[1642], how this happen? how I > to prevent this?? > > > Thanks! > > > -- > Jie LIANG > > Internet Products Inc. > > 10350 Science Center Drive > Suite 100, San Diego, CA 92121 > Office:(858)320-4873 > > jliang@ipinc.com > www.ipinc.com > > > ------_=_NextPart_000_01C045DF.55596780 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IiMWAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAbAAAAUkU6IFtT UUxdIHJlYWxseSBuZWVkIGhlbHAAxwgBCYABACEAAAA1RDcxODI2MDk2QjFE NDExQjI4MTAwOTAyNzk4NkEyMADGBgEggAMADgAAANAHCwADABEAAgAhAAUA HgEBBYADAA4AAADQBwsAAwAQAC0ABwAFAC4BAQ2ABAACAAAAAgACAAEDkAYA LAsAACsAAAALAAIAAQAAAAMALgAAAAAAQAA5AIBnWVXfRcABHgBwAAEAAAAX AAAAW1NRTF0gbmVlZCBoZWxwIHVyZ2VudAAAAgFxAAEAAAAbAAAAAcBFzl6C tAgoxrG/EdSK3AAIx0w6bQAEHYAwAAIBCRABAAAAZQYAAGEGAAB9DAAATFpG dYQA+W8DAAoAcmNwZzEyNfIyAPszNgHoAqQD4wIABGNoCsBzZXQwIA8HEwKD AFAQRnBycTJvEUkOUAPVEVV9CoAIyCC2OwlvDjA1AoAKgXYIkKR3awuAZDQM YGMAUC0LA2MAQQtgbg4QMDPCMwumIEhpLAqiCoQRCoBJIHcIYGxkIABsaWtl IHRvIKpzG0BwG2BwCfBkC4AQZyBteRqBcmsgbGRhHGABAGwREBwSdI5oB5Ab IAeBc2FnB5C4LiBJBCAdoQlwIABw+nkG4GQcYAhgBUAe1Alw/xvAAiAAkAJg GyACEAXAHaDVBAA/BdBhGxFpBUAbcqIhB7BvdyEZulQQ0PxuaxCQGckK9Brw DzEYIVMBQBKQb3QFkHQR1DGoNiAtJrJPBRBnC4D/B0AF0B4UJrMZtiXEJZEL E8ElxmktMTQ0AUAa8DgxODABQAzQKlNiIKpGA2E6DINiETBKCJAMIEwHMBwh W1NNVNhQOmoa8BiBQAUgC4DkYy4FoG1dGbUrgAZgVwIwK+croGkc0SwigXb2 ZQbQBJAgGMAwQAHQKuAAIDE6MzUgUE0ZLodUbyvnDgBzcWzQLWFkbQuAQCCA G3DLCcEzUS4FsGc7MyUzUeMz7S6IdWJqJfEr5y0Q4FFMXSBuCeAa0B2w/mwb oAhwHlACMChfKWolFP8TcwwBGcMZjgQgHzYQ0DCA+CBleBvQCIEuEB8RBuAH H8EFoRsgZHVtcD/tGbRXGyA+A3MDcEDBBQP/BCA+AzCwCfA48BEAGtAhEr5h GuACIB2BB3EwQGgioHplMIByMEAJcD7QAjBs/zAwGbQdoRxgEQAwkBsyQJhz JbEg0W1zRMgd9h6QIA5nJdAr4BnJU1NFTOhFQ1RGkWkFsCIAHGB7A1JJ6Hce 40DgCHA+0D3DCQBD0HIoJ3EKUBtw50oQJ1Ag0ScpIzUl0CdhPwuAEQAAIE4x G0ESkGV1yy4QHbBjGxBkOjFwSRVsZWcHgAIwYUziIQBh+xqwBUAtP1gJgE// UQ9SGL8jNgQAQSU98QQgQg5mB9FvBGACMB2xMEBuTuJGwy6vGbxPVRxCMzMu CQBnMEAbGnAeMHdIqzBhICAzgTDgMDo1ODo0MbAvA/Ab0B+yM/ZbJoAzOCZd T8BMoXJ5T8BJTs1JgFJJ0F9AVE8ZtEvE6igwACxLxCkGAEmUYME/TJxKcxm0 TwpcgGRtV0gdX3BFTjUc0CXgPj0g7icxMipAT+UtGMBct2eAfDgnW/9dASaQ XV8mgDS+Ml6oSYVD8QCQAiAoTXX/aO9p/2sLMLAnMWzfbe9u+u5QA2A+0AQQ VR1QGvBKUL9wD3Efci9etxEBGzByAHH/ANBTMwQABvBTIxm0HTAwgOcDIE5h BzFpek0idK91v/9yn3Opd/0ZtHj3GuB5/3sPN3wfds9rt28wAGL6Z1//ZjEB oFZAGyBLZGYxJ1BBAc9mgSXgP9B5IWUxaH+C//+ED2uohpFKUBvQNJBgwUTV /40AIqA4YEQRjPGH4o5jHTC+bo5jEpBEkI9VC4BwH8DvjmMfsZCWREJpMICN eBEA9xdgjmMdIW2OYx0RAKAZwx+TllODkXUa8JMEYnl2/wdAMEBCUYfjSoSM 1DBAhpE/QlEFwEtjjYyIIUJRc3n/AJBSRYlvin+Lj4yUJbEuIP+NSCWxjrQl sRhyn9MnUDSw/1gRJbEJcAJAl9ShMxEBn9O3oMGM8qD0c0vwnvhiC4A9lq9f nwejsJgcnjogPo1mkDEBwCaAJzo6hbL/AHAa0CWxmY+an5uvnL+MSfseQAnB Z2ZBjTmuYY60rmHreDMC8DGwGjKwEyogJ1H/AvCwGIzysNCvR4cCl8Symv+x ohm0rnALgCIAlnGw1LYlf7Ghls6uZ5gPr2WpfxnJLv+8bRm6QGZYQQT1G0Eb kEIh/0LgOGAH4KoBbHKs1DBAQ6K/IUM98Y+wCfAhkMEiSUTVv07jMIACMCFE P/Ui33Miy4dnJShFLHNJQU5HGbv/AjAEkXgBc1E/sCYABCDIcJcuIBm6GLE1 ETBTYz6kdkMvITDBRAUQMIBJFXX3IgAbIBiwMDBABhHL0AiQw0hwMEBDQSA5 qGCoYA0ZtE8BIA3gZTooOAlc8CkzAdAtNDg3rxjgGcktfhm0d9IwLtFNFdMP ChSBANTAAAAAAwD9P1IDAAAeAEIQAQAAAB4AAAA8M0EwMzEzNzguRjZENUNB NjZAaXBpbmMuY29tPgAAAAsABIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAA AAAAAwAGgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAACACCAGAAAA AADAAAAAAAAARgAAAABShQAAdBAAAB4AAYAIIAYAAAAAAMAAAAAAAABGAAAA AFSFAAABAAAABQAAADguMDIAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAA AYUAAAAAAAALAAWACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAB4AI IAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAIgAggBgAAAAAAwAAAAAAA AEYAAAAAGIUAAAAAAAAeAAmACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA AAEAAAAAAAAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAA AAAAAB4AC4AIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAD ACYAAAAAAAMANgAAAAAAHgAxQAEAAAATAAAAU0NITE9CT0hNSjI2RDhBREMz AAADABpAAAAAAB4AMEABAAAAEwAAAFNDSExPQk9ITUoyNkQ4QURDMwAAAwAZ QAAAAAADAIAQ/////wIB+T8BAAAAUQAAAAAAAADcp0DIwEIQGrS5CAArL+GC AQAAAAYAAAAvTz1ETkIvT1U9VVNFQVNUL0NOPVJFQ0lQSUVOVFMvQ049U0NI TE9CT0hNSjI2RDhBREMzAAAAAB4A+D8BAAAAEAAAAFNjaGxvYm9obSwgSmFj awAeADhAAQAAABMAAABTQ0hMT0JPSE1KMjZEOEFEQzMAAAIB+z8BAAAAUQAA AAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1ETkIvT1U9VVNFQVNU L0NOPVJFQ0lQSUVOVFMvQ049U0NITE9CT0hNSjI2RDhBREMzAAAAAB4A+j8B AAAAEAAAAFNjaGxvYm9obSwgSmFjawAeADlAAQAAABMAAABTQ0hMT0JPSE1K MjZEOEFEQzMAAEAABzBgYHrU3kXAAUAACDAU4pLE4UXAAR4APQABAAAABQAA AFJFOiAAAAAAHgAdDgEAAAAXAAAAW1NRTF0gcmVhbGx5IG5lZWQgaGVscAAA CwApAAAAAAALACMAAAAAAAMABhAGiHPyAwAHENAHAAADABAQAAAAAAMAERAD AAAAHgAIEAEAAABlAAAASEksSVdPVUxETElLRVRPU1RPUFNQRU5ESU5HTVlX T1JLREFZREVMRVRJTkdUSEVTRU1FU1NBR0VTSVNUSEVSRUFOWUJPRFlPVVRU SEVSRVJFU1BPTlNJQkxFRk9SVEhJUz9NQQAAAADbFg== ------_=_NextPart_000_01C045DF.55596780--