vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > > "Medora Schauer" <mschauer@fairfield.com> writes: > > I looked in the log again and sure enough I missed this immediately > > before the WARNINGS: > > > PANIC: link from /data/database/pg_xlog/00000001000000D9 to > > /data/database/pg_xlog/00000001000000E1 (initialization of log file 1, > > segment 225) failed: No such file or directory > > > Looks like a file system problem right? > > Definitely seems like a can't-happen case. What file system are you > running Postgres on? I found this in /var/log/messages: Dec 1 09:23:40 Qc kernel: __alloc_pages: 0-order allocation failed (gfp=0x1d2/0) Dec 1 09:23:40 Qc kernel: VM: killing process postmaster Is this because we are running out of memory? Our file system is ext3. Medora ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
| ||||
| On Thu, Dec 01, 2005 at 11:18:14AM -0600, Medora Schauer wrote: > I found this in /var/log/messages: > > Dec 1 09:23:40 Qc kernel: __alloc_pages: 0-order allocation failed > (gfp=0x1d2/0) > Dec 1 09:23:40 Qc kernel: VM: killing process postmaster > > Is this because we are running out of memory? > > Our file system is ext3. Umm, yeah. Looks like you totally ran out of free memory. Do you have sufficient swap setup? Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQFDj14rIB7bNG8LQkwRAjanAJ9aJZgRFzH7KUfucJhKqg +Ba+idUgCfWiHO aO1bXjUcT+N37jUHF1Q6Ezk= =e1LK -----END PGP SIGNATURE----- |