News for hackers. Stuff that matters.
Re:Open-source and the demise of proprietary software (2018) by 1996 on Tuesday December 24, 2019 @03:44PM (#21874778)
As timescaledb is now banned with all third party extensions, I don't have a server where I can reproduce that. But it was 100% reproducible on a very simple routine scenario (add many records to an existing timescale db)

Just try to do a massive '\copy from' into a table that is already a timescaledb, using a tsv source with at least a few million records, make sure the dates are well spread out. Then use windowing functions to count the records per time unit. Compare date_trunc to time_bucket and select. Unless the issue was silently fixed, I'm sure you will be laughting too - but I recommend you wait until after xmas to have that good hearthy laugh, as it may cause you to want to fix the issue ASAP :)

Once of the field was defaulting to NOW(), maybe that's what caused the funny bug but I didn't investigate much after that. It was the straw that broke the camel back. Thousand papercuts. Not worth the time investment.

Re:Open-source and the demise of proprietary software (2018) by akulkarni on Tuesday December 24, 2019 @04:00PM (#21874877)
Cool, we'll take a look. First we've heard of it so really curious what might be going on. Thanks!
Re:Open-source and the demise of proprietary software (2018) by 1996 on Thursday December 26, 2019 @06:02PM (#21887614)
So did you take a look?
Re:Open-source and the demise of proprietary software (2018) by Lockerman on Tuesday December 24, 2019 @04:05PM (#21874904)
Hi, Timescale engineer here, do you happen to remember around when/in what version you ran into this bug?