From commits-return-29735-archive-asf-public=cust-asf.ponee.io@airflow.incubator.apache.org Wed Dec 5 15:30:06 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id D278A18062B for ; Wed, 5 Dec 2018 15:30:05 +0100 (CET) Received: (qmail 89472 invoked by uid 500); 5 Dec 2018 14:30:05 -0000 Mailing-List: contact commits-help@airflow.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@airflow.incubator.apache.org Delivered-To: mailing list commits@airflow.incubator.apache.org Received: (qmail 89460 invoked by uid 99); 5 Dec 2018 14:30:04 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Dec 2018 14:30:04 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5C6B1180CB1 for ; Wed, 5 Dec 2018 14:30:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.501 X-Spam-Level: X-Spam-Status: No, score=-109.501 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id D8BKxe5YAQyQ for ; Wed, 5 Dec 2018 14:30:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 14BF35F565 for ; Wed, 5 Dec 2018 14:30:02 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id D867BE13DA for ; Wed, 5 Dec 2018 14:30:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 3F7BB27773 for ; Wed, 5 Dec 2018 14:30:00 +0000 (UTC) Date: Wed, 5 Dec 2018 14:30:00 +0000 (UTC) From: "Roger Kaufmann (JIRA)" To: commits@airflow.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (AIRFLOW-3445) MariaDB explicit_defaults_for_timestamp = 1 Does not work. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/AIRFLOW-3445?page=3Dcom.atlassi= an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D16= 710126#comment-16710126 ]=20 Roger Kaufmann commented on AIRFLOW-3445: ----------------------------------------- You are correct, the per-session workaround wouldn't work, but the patch pr= oposed by Feng Lu should (see link below). At least on our cloudfoundry ins= tance of mariadb it created the tables successfully (so far it works, take = it with a grain of salt...). I guess it depends on how its gonna be solved.= .. [https://www.mail-archive.com/dev@airflow.incubator.apache.org/msg06640.htm= l] =C2=A0 > MariaDB explicit_defaults_for_timestamp =3D 1 Does not work. > ---------------------------------------------------------- > > Key: AIRFLOW-3445 > URL: https://issues.apache.org/jira/browse/AIRFLOW-3445 > Project: Apache Airflow > Issue Type: Bug > Components: database > Affects Versions: 1.10.1 > Environment: Hosted VM on the Google Cloud Platform, Compute Engi= ne: > Machine type: n1-standard-2 (2 vCPUs, 7.5 GB memory) > Operating System =09CentOS > Reporter: Conor Molloy > Priority: Blocker > Fix For: 1.10.2 > > > {{Running into an issue when running }} > {{`airflow upgradedb`}} > {{ going from `1.9` -> `1.10.1`}} > {{}} > {code:java} > `sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1= 193, "Unknown system variable 'explicit_defaults_for_timestamp'") [SQL: 'SE= LECT @@explicit_defaults_for_timestamp']`{code} > {{I saw this link on the airflow website.}} > {{[https://airflow.readthedocs.io/en/stable/faq.html#how-to-fix-exception= -global-variable-explicit-defaults-for-timestamp-needs-to-be-on-1|http://ex= ample.com]}} > {{Here it says you can set}} > {code:java} > `explicit_defaults_for_timestamp =3D 1`{code} > {{in the _my.cnf_ file. However I am using Mariadb and when I add this to= the _my.cnf_ file the}} > {noformat} > mariadb.service{noformat} > {{fails to start up. Has anyone else come across this issue?}} > =C2=A0 > The output from > {code:java} > `SHOW VARIABLES like '%version%'`{code} > was > {code:java} > `+-------------------------+----------------------+` > `| Variable_name | Value |` > `+-------------------------+----------------------+` > `| innodb_version | 5.5.59-MariaDB-38.11 |` > `| protocol_version | 10 |` > `| slave_type_conversions | |` > `| version | 5.5.60-MariaDB |` > `| version_comment | MariaDB Server |` > `| version_compile_machine | x86_64 |` > `| version_compile_os | Linux |` > `+-------------------------+----------------------+`{code} > The MariaDB does not have the argument as it is a MySQL only feature. > [https://mariadb.com/kb/en/library/system-variable-differences-between-ma= riadb-100-and-mysql-56/|http://example.com] > There may need to be a check for MariaDB before upgrading, as mentioned b= y Ash in this Slack thread.=C2=A0 > [https://apache-airflow.slack.com/archives/CCQB40SQJ/p1543918149008100|ht= tp://example.com] -- This message was sent by Atlassian JIRA (v7.6.3#76005)