Latest docker image

[pavanfhw]

Has anyone been able to build a docker image with the latest version?
The dockerfile in ops/docker is not up to date right?
Why was only one image built 2 years ago?
As I understand the image quay.io/iris/iris:latest is not by far the latest.

[diegocepedaw]

I'll try to take a look at the docker build this week. It's not something we use internally so our support for it hasn't been all it should be. I imagine the reason for the issues might be due to problems between UWSGI and Gevent==1.5.0 issue. For our production deployment which uses UWSGI, we saw issues before we pinned gevent back down to 1.4.0. I recently set up a new Oncall docker repo that builds automatically with each new release so I will try to do the same for Iris soon.

[pavanfhw]

@diegocepedaw that would be very helpful. It would be very good to have the latest image. Thank you

[tehpopes]

Wanted to also comment on this issue because I've been having issues getting the latest docker image for iris to run properly with mysql.

In order to get the latest docker image to build without errors I had to make changes to the packages installed through apt to ensure they all support python3. According to the following link, uwsgi-plugin-gevent-python 3 is only available for Ubuntu 20.04 (focal) or later, so I had to update the version of ubuntu

I also changed the install requirements in setup.py to remove the version specification for gevent and pyfcm, so that they now use the latest version of those libraries.

Updated Dockerfile

The image builds properly, but when I deploy it with a mysql 5.7 db, I get the following error. The tables are generated and populated based off the schema and dummy data. I’m not sure if there this error is due to the application image or the mysql configuration. Below are logs from the mysql container.
2021-05-10T20:10:45.607453822Z 2021-05-10T20:10:45.607174Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-05-10T20:10:45.607515928Z 2021-05-10T20:10:45.607223Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-05-10T20:10:45.607578888Z 2021-05-10T20:10:45.607377Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-05-10T20:10:45.657907296Z 2021-05-10T20:10:45.657674Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-05-10T20:10:45.660175517Z 2021-05-10T20:10:45.659963Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-05-10T20:10:45.660221737Z 2021-05-10T20:10:45.660000Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-05-10T20:10:45.661082991Z 2021-05-10T20:10:45.660833Z 0 [Note] InnoDB: Waiting for purge to start 2021-05-10T20:10:45.711568557Z 2021-05-10T20:10:45.711145Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 13007739 2021-05-10T20:10:45.711769905Z 2021-05-10T20:10:45.711526Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-05-10T20:10:45.712263178Z 2021-05-10T20:10:45.712019Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-05-10T20:10:45.715618326Z 2021-05-10T20:10:45.715369Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 20:10:45 2021-05-10T20:10:45.729108118Z 2021-05-10T20:10:45.728839Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-05-10T20:10:45.729158924Z 2021-05-10T20:10:45.728874Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-05-10T20:10:45.731199932Z 2021-05-10T20:10:45.730962Z 0 [Warning] CA certificate ca.pem is self signed. 2021-05-10T20:10:45.731242279Z 2021-05-10T20:10:45.731050Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-05-10T20:10:45.732519902Z 2021-05-10T20:10:45.732273Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-05-10T20:10:45.732647352Z 2021-05-10T20:10:45.732508Z 0 [Note] IPv6 is available. 2021-05-10T20:10:45.732682490Z 2021-05-10T20:10:45.732542Z 0 [Note] - '::' resolves to '::'; 2021-05-10T20:10:45.732694412Z 2021-05-10T20:10:45.732588Z 0 [Note] Server socket created on IP: '::'. 2021-05-10T20:10:45.736391118Z 2021-05-10T20:10:45.736128Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2021-05-10T20:10:45.762132826Z 2021-05-10T20:10:45.761901Z 0 [Note] Event Scheduler: Loaded 0 events 2021-05-10T20:10:45.762656973Z 2021-05-10T20:10:45.762446Z 0 [Note] mysqld: ready for connections. 2021-05-10T20:10:45.762693133Z Version: '5.7.34' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2021-05-10T20:10:46.062262766Z 2021-05-10T20:10:46.062210Z 2 [Note] Got an error reading communication packets 2021-05-10T20:10:47.761320776Z 2021-05-10T20:10:47.761193Z 3 [Note] Aborted connection 3 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:10:51.713881070Z 2021-05-10T20:10:51.713762Z 4 [Note] Aborted connection 4 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:10:54.368575356Z 2021-05-10T20:10:54.368417Z 5 [Note] Aborted connection 5 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:10:59.112991645Z 2021-05-10T20:10:59.112855Z 6 [Note] Aborted connection 6 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:01.773545960Z 2021-05-10T20:11:01.773404Z 7 [Note] Aborted connection 7 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:08.255272149Z 2021-05-10T20:11:08.255148Z 8 [Note] Aborted connection 8 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:12.735456100Z 2021-05-10T20:11:12.735311Z 9 [Note] Aborted connection 9 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:15.338032424Z 2021-05-10T20:11:15.337884Z 10 [Note] Aborted connection 10 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:26.140522041Z 2021-05-10T20:11:26.140425Z 11 [Note] Aborted connection 11 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:28.984369505Z 2021-05-10T20:11:28.984228Z 12 [Note] Aborted connection 12 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:40.507802641Z 2021-05-10T20:11:40.507641Z 13 [Note] Aborted connection 13 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:42.592986518Z 2021-05-10T20:11:42.592870Z 14 [Note] Aborted connection 14 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:56.355364158Z 2021-05-10T20:11:56.355258Z 15 [Note] Aborted connection 15 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:11:59.029432184Z 2021-05-10T20:11:59.029311Z 16 [Note] Aborted connection 16 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:12:14.927665923Z 2021-05-10T20:12:14.927572Z 17 [Note] Aborted connection 17 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:12:18.087093483Z 2021-05-10T20:12:18.086984Z 18 [Note] Aborted connection 18 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:12:35.651300865Z 2021-05-10T20:12:35.651186Z 19 [Note] Aborted connection 19 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:12:37.072516667Z 2021-05-10T20:12:37.072420Z 20 [Note] Aborted connection 20 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:12:56.660760119Z 2021-05-10T20:12:56.660610Z 21 [Note] Aborted connection 21 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:12:58.955170984Z 2021-05-10T20:12:58.954990Z 22 [Note] Aborted connection 22 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:13:20.526111164Z 2021-05-10T20:13:20.525999Z 23 [Note] Aborted connection 23 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:13:23.417990134Z 2021-05-10T20:13:23.417873Z 24 [Note] Aborted connection 24 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:13:47.911050884Z 2021-05-10T20:13:47.910885Z 25 [Note] Aborted connection 25 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:13:50.556750097Z 2021-05-10T20:13:50.556610Z 26 [Note] Aborted connection 26 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:14:17.446042498Z 2021-05-10T20:14:17.445943Z 27 [Note] Aborted connection 27 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets) 2021-05-10T20:14:20.538434818Z 2021-05-10T20:14:20.538257Z 28 [Note] Aborted connection 28 to db: 'iris' user: 'iris' host: '172.28.0.3' (Got an error reading communication packets)

Iris container logs
2021-05-10T20:10:46.064972517Z [uWSGI] getting YAML configuration from /home/iris/daemons/uwsgi.yaml

What would you recommend would be the best course of action from here? Were the changes I made to the Dockerfile and the setup.py file heading in the right direction or should I have taken a different approach?

[allwyn-pradip]

try with mysql 5.5 version.. downgrading works.

[mighq]

See #573 issue, which seems to be related/duplicate and is more alive.