tag:blogger.com,1999:blog-2356137376934964551.post3002171409958824142..comments2023-06-14T06:01:24.499-04:00Comments on Andrew Dunstan's PostgreSQL and Technical blog: Fun with Raspberry Pi 2 and the buildfarmAndrew Dunstanhttp://www.blogger.com/profile/04684286585449188201noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-2356137376934964551.post-76768056739581388592015-04-10T15:21:39.392-04:002015-04-10T15:21:39.392-04:00Yeah, I did exactly that this morning - replaced i...Yeah, I did exactly that this morning - replaced it with a 32GB class 10 SanDisk card, and magically the problem has disappeared. Thanks for testing.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-22405611963851930352015-04-10T13:19:38.290-04:002015-04-10T13:19:38.290-04:00FWIW, I did >100 runs of 'make check' o...FWIW, I did >100 runs of 'make check' on the RPi2 I have since last week and I see no such issues. In all cases I get "All 152 tests passed".<br /><br />I'd guess your SDHC card is pretty bad - can you do a simple "dd" test with it, for example? I'm using quite good "class 10" card from SanDisk.Tomáš Vondrahttps://www.blogger.com/profile/07867471096738581957noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-83201867653610955902015-04-08T12:01:33.345-04:002015-04-08T12:01:33.345-04:00And just after I posted that comment HEAD failed o...And just after I posted that comment HEAD failed on the Raspbian box with this:<br /><br />FATAL: could not create lock file "/tmp/pg_upgrade_check-oT6vZk/.s.PGSQL.57732.lock": No such file or directory<br /><br />Something weird seems to be happening.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-12952516383197959352015-04-08T10:37:13.415-04:002015-04-08T10:37:13.415-04:00ntp is enabled, still seeing issues on the Fidora ...ntp is enabled, still seeing issues on the Fidora box. At this stage I'm inclined to suspect that the microSDHC card I'm using in it is just horribly slow. I have a SanDisk 32gb card available that I'm going to try instead. The Raspbian box is behaving now, I've really only seen one failure on it, and that was before I enabled ntp.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-34723903544515497232015-04-07T21:11:58.843-04:002015-04-07T21:11:58.843-04:00Possible, you may need to enable ntpd. That's ...Possible, you may need to enable ntpd. That's what I do.michaelpqhttps://www.blogger.com/profile/09843399942627408556noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-32867769350635312992015-04-07T20:52:24.515-04:002015-04-07T20:52:24.515-04:00That's a raspberry PI 2 as well, with ARMv7 an...That's a raspberry PI 2 as well, with ARMv7 and ArchLinux ARM.michaelpqhttps://www.blogger.com/profile/09843399942627408556noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-14627752750155479672015-04-07T10:23:10.036-04:002015-04-07T10:23:10.036-04:00Assuming you are talking about stats.sql I see it ...Assuming you are talking about stats.sql I see it uses clock_timestamp() in combination with sleep(). I also see that none of the other SQL in the regress directory do. Wonder if what you are seeing is due to the fact that RPI does not have a real system clock?Adrian Klaverhttps://www.blogger.com/profile/09632095365606250299noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-73014267298482980962015-04-07T09:09:40.324-04:002015-04-07T09:09:40.324-04:00michaelpq, is that on an RPi, or some other ARM pl...michaelpq, is that on an RPi, or some other ARM platform? Which ARM processor is it? Mine have armv7l.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-17504321727781589882015-04-07T03:20:31.757-04:002015-04-07T03:20:31.757-04:00Just tested with ArchLinux ARM 3/4 times and thing...Just tested with ArchLinux ARM 3/4 times and things are working fine.michaelpqhttps://www.blogger.com/profile/09843399942627408556noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-54087317024315823812015-04-06T22:31:50.122-04:002015-04-06T22:31:50.122-04:00Seeing this sort of thing:
[55231754.498e:1] LOG: ...Seeing this sort of thing:<br />[55231754.498e:1] LOG: using stale statistics instead of current ones because stats collector is not responding<br />[5523163b.4987:72] LOG: wait_for_stats delayed 153.721611 seconds<br />Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-1880990859223113282015-04-06T22:21:53.005-04:002015-04-06T22:21:53.005-04:00If memory serves me well, the Make Check had paral...If memory serves me well, the Make Check had parallel routines / tests, which didn't work too well with the Pi (so it intermittently failed), but I'd let Andrew confirm his recent findings as well.Robins Tharakanhttps://www.blogger.com/profile/02748267202194708735noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-12309799713600623742015-04-06T22:09:09.491-04:002015-04-06T22:09:09.491-04:00hamster is (one of) the slowest machine(s), and ev...hamster is (one of) the slowest machine(s), and even these days builds are pretty stable:<br />http://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=hamster&br=HEAD<br />What is the failure you are seeing?michaelpqhttps://www.blogger.com/profile/09843399942627408556noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-40596964956681327242015-04-06T20:58:55.870-04:002015-04-06T20:58:55.870-04:00A faint memory says that when I did the same test ...A faint memory says that when I did the same test on my Pis a few months (year) back, it was about the Make scripts assuming basic timeouts that the Pi's weren't able to keep up with (basically it was seriously low powered). And yes, the failures were intermittent and spread out at different places at different times (but most were using a component where the timeout was insufficient). All the best.Anonymoushttps://www.blogger.com/profile/09660517959593093018noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-30472749617885104692015-04-06T20:53:41.426-04:002015-04-06T20:53:41.426-04:00Damn it! The possibility that there might be a bug...Damn it! The possibility that there might be a bug in my code (due to the pgstat reworks in 9.2), and that someone else might find it, is unbearable. I just ordered a Raspberry Pi 2 to check what's happening ...Tomáš Vondrahttps://www.blogger.com/profile/07867471096738581957noreply@blogger.com