Hey Domino, Thanks for testing the RC. For versions 1.19.0 and later we need to run a pg_ctl/gpstop command to update a GUC value as part of the install process (part of a database upgrade requirement). Could you check your path to make sure you have it in your path?
Thanks, Orhan ________________________________ From: Domino Valdano <domino@valdano.email> Sent: Tuesday, August 2, 2022 10:13 PM To: dev@madlib.apache.org <dev@madlib.apache.org> Subject: Re: Apache MADlib 1.20.0 Release (RC2) ⚠ External Email I tried installing it on Centos7, using the centos7/postgresql-12-centos7 docker image. Ran into a few issues: - First one was easily fixable and seems fine (missing m4 dependency). - Second problem is it prompts for a password when there is no password. That seems like a bug to me, since on the command line you can connect to the database fine with no password, and create and read tables without any problem. But this behavior feels familiar, anyone remember if there was an easy workaround for this odd madlib quirk? - Third problem (possibly a weird side-effect of second problem?) is that if I press enter at that password prompt, I get the error "No such file or directory". I'm not sure whether it accepted the empty string as the correct password, and the third one is an unrelated error... or if it's just a case of it misreporting an intermediate "Authentication Denied" error to the user as a "No such file or directory". Holding off on voting, until I figure out if there's a simple workaround for #2, as that might make the difference between a +1 and a -1 Domino bash-4.2$ cat /etc/*release* CentOS Linux release 7.8.2003 (Core) Derived from Red Hat Enterprise Linux 7.8 (Source) NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL="https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.centos.org%2F&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Tyqsol9%2BxowPhTmiXZlayp8869CgZs0d0zDXuZg1wrY%3D&reserved=0"; BUG_REPORT_URL="https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.centos.org%2F&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mzd3eTLrju1F6MN7Dz419q2BP9BiXgJCjNpvL0dFkOU%3D&reserved=0"; CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7" CentOS Linux release 7.8.2003 (Core) CentOS Linux release 7.8.2003 (Core) cpe:/o:centos:centos:7 bash-4.2$ rpm -i apache-madlib-1.20.0-CentOS7.rpm error: Failed dependencies: m4 >= 1.4 is needed by madlib-1.20.0-1.x86_64 bash-4.2$ yum install m4 ... Installed: m4.x86_64 0:1.4.16-10.el7 bash-4.2# rpm -i apache-madlib-1.20.0-CentOS7.rpm bash-4.2# rpm -qa |grep madlib madlib-1.20.0-1.x86_64 bash-4.2$ psql -l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+-----------+---------+-------+----------------------- madlib | postgres | SQL_ASCII | C | C | postgres | postgres | SQL_ASCII | C | C | template0 | postgres | SQL_ASCII | C | C | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | SQL_ASCII | C | C | =c/postgres + | | | | | postgres=CTc/postgres (4 rows) bash-4.2$ id uid=26(postgres) gid=26(postgres) groups=26(postgres),0(root) bash-4.2$ /usr/local/madlib/bin/madpack -c/madlib install -ppostgres Password for user postgres: Traceback (most recent call last): File "/usr/local/madlib/Versions/1.20.0/bin/../madpack/madpack.py", line 1537, in <module> main(sys.argv[1:]) File "/usr/local/madlib/Versions/1.20.0/bin/../madpack/madpack.py", line 1397, in main _internal_run_query("SELECT 1", False) File "/usr/local/madlib/Versions/1.20.0/bin/../madpack/madpack.py", line 99, in _internal_run_query return run_query(sql, con_args, show_error) File "/usr/local/madlib/Versions/1.20.0/madpack/utilities.py", line 90, in run_query stderr=subprocess.PIPE).communicate() File "/usr/lib64/python2.7/subprocess.py", line 711, in __init__ errread, errwrite) File "/usr/lib64/python2.7/subprocess.py", line 1327, in _execute_child raise child_exception OSError: [Errno 2] No such file or directory bash-4.2$ echo $PGDATA /var/lib/pgsql/data bash-4.2# psql madlib psql (12.7) Type "help" for help. madlib=# select version(); version ------------------------------------------------------------------------------------------------------------- PostgreSQL 12.7 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit (1 row) madlib=# create table hi (a int); CREATE TABLE madlib=# insert into hi (a) values (3); INSERT 0 1 madlib=# select * from hi; a --- 3 (1 row) madlib=# \q On Tue, Aug 2, 2022 at 12:22 AM Nikhil Kak <n...@vmware.com.invalid> wrote: > +1 binding > > Tested the rpm on centos 7 + pg12 > > All the install-check, dev-check and unit-test tests passed > > - Nikhil > ________________________________ > From: Orhan Kislal <okis...@vmware.com.INVALID> > Sent: Monday, August 1, 2022 5:53 PM > To: dev@madlib.apache.org <dev@madlib.apache.org> > Subject: Re: Apache MADlib 1.20.0 Release (RC2) > > ⚠ External Email > > +1 (binding) > > Best, > > Orhan Kislal > ________________________________ > From: Ekta Khanna <khannae...@apache.org> > Sent: Monday, August 1, 2022 11:37 AM > To: dev@madlib.apache.org <dev@madlib.apache.org> > Subject: Re: Apache MADlib 1.20.0 Release (RC2) > > ⚠ External Email > > +1 (binding) > > Build, installed the release rpm and ran dev-check, unit-test, > install-check on GP6(centos7). All passed. > > Best Regards, > Ekta > > On 2022/07/29 15:47:54 Venkatesh Raghavan wrote: > > Small correction. Deadline is August 3. > > > > Regards, > > > > Venky > > ________________________________ > > From: Venkatesh Raghavan <raghava...@vmware.com.INVALID> > > Sent: Friday, July 29, 2022 8:41 AM > > To: dev@madlib.apache.org <dev@madlib.apache.org>; > u...@madlib.apache.org <u...@madlib.apache.org> > > Subject: Apache MADlib 1.20.0 Release (RC2) > > > > > > ⚠ External Email > > > > Hello Apache MADlib Community, > > > > > > This is the vote for Apache MADlib 1.20.0 Release (RC2). It provides the > source release tarball and a convenience binary for CentOS7. > > > > > > The vote will run for at least 72 hours and close on August 2nd, 2022 > @20:00 UTC (15:00 EST). A minimum of 3 binding +1 votes and more binding +1 > than binding -1 are required to pass. > > > > > > The main goals of this release are: > > > > > > New features: > > > > - XGBoost: Python-based XGBoost with single and grid search > executions (MADLIB-1425, MADLIB-1490) > > > > - Graph: Add multicolumn support for WCC and Pagerank (MADLIB-1502, > MADLIB-1503) > > > > > > Improvements: > > > > - Utilities: Reuse update plan in GroupIterationController > > > > - Documentation: Update online examples for various modules > > > > > > Bug fixes: > > > > - Elastic Net - GLM - SVM: Adjust ORCA to reduce planning time > > > > > > 1.20.0 docs available here: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmadlib.apache.org%2Fdocs%2Frc%2Findex.html&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8Sy%2FVeq74TjAln7QlJTBeGESJqJQ8uHQ%2Fqs8BHxdPcE%3D&reserved=0 > > > > > > For additional information, please see: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FMADLIB%2FMADlib%2B1.20.0&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=NjjzHxIyaStSXQXLZYhlsArjeGiUBrxnNW8f6FPf204%3D&reserved=0 > > > > > > Here are the release artifact details: > > > > Source release tag to be voted on: rc/1.20.0-rc2, located here: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fmadlib%2Ftree%2Frc%2F1.20.0-rc2&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=hLadqh2sq9XA9tCdV44sNbiGPCjT%2B3haRkIKm0OiOiw%3D&reserved=0 > > > > > > Source release tarball can be retrieved from the following locations: > > > > Package: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-src.tar.gz&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=WjYXQsag0RMWTJxEqu3a5yzaJLz4b75Paq%2FSbG1W9BI%3D&reserved=0 > > > > PGP Signature: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-src.tar.gz.asc&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AWpF8WG9UwyUWkoAqp395owEpCMO5IOw02ELKIpOY9Y%3D&reserved=0 > > > > SHA512 Hash: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-src.tar.gz.sha512&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9xy5KohGdUXoQYEK5mvvhKpBhV2pRho0QUBQAhza2QI%3D&reserved=0 > > > > > > Convenience binary for CentOS7 (compiled with gcc 4.8) can be retrieved > from the following locations: > > > > Package: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-CentOS7.rpm&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=i8XRO%2FIo3kla79FkuV5fXd5Mo%2BjczkCfl0iFpZRZ4M0%3D&reserved=0 > > > > PGP Signature: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-CentOS7.rpm.asc&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=OeSAEG9Hz41hVYbyd5WVK9F57N5UyaBHVZPWyqeQ32U%3D&reserved=0 > > > > SHA512 Hash: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-CentOS7.rpm.sha512&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=QjCU02eToo3C4kdGVytNfr2NQtXlPx9BWhGX728HkMA%3D&reserved=0 > > > > > > The PGP KEYS file used to validate the signature of the release > artifacts is available here: > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2FKEYS&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=tak4GRKOhd0sks98n4R27acstzvu5XacD7SqtUsUgXI%3D&reserved=0 > > > > > > To help in tallying the vote, PMC members please be sure to indicate > “(binding)” with the vote. > > > > > > [ ] +1 approve > > > > [ ] +0 no opinion > > > > [ ] -1 disapprove (and the reason why) > > > > > > Best regards, > > > > Venkatesh Raghavan <raghava...@vmware.com> > > > > ------------------------------------------------------- > > Venkatesh Raghavan > > Sr. Manager of Product (Greenplum) > > raghava...@vmware.com > > +1 508-410-7296 > > > > [cid:1bdaf535-bb9f-4a2a-9249-974074993bf0] > > > > ________________________________ > > > > ⚠ External Email: This email originated from outside of the > organization. Do not click links or open attachments unless you recognize > the sender. > > > ________________________________ ⚠ External Email: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender.
