Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:102927 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 63377 invoked from network); 21 Jul 2018 01:13:02 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 21 Jul 2018 01:13:02 -0000 Authentication-Results: pb1.pair.com header.from=rasmus@lerdorf.com; sender-id=pass Authentication-Results: pb1.pair.com smtp.mail=rasmus@lerdorf.com; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain lerdorf.com designates 209.85.218.51 as permitted sender) X-PHP-List-Original-Sender: rasmus@lerdorf.com X-Host-Fingerprint: 209.85.218.51 mail-oi0-f51.google.com Received: from [209.85.218.51] ([209.85.218.51:37341] helo=mail-oi0-f51.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 0E/21-47674-D98825B5 for ; Fri, 20 Jul 2018 21:13:01 -0400 Received: by mail-oi0-f51.google.com with SMTP id k81-v6so24355727oib.4 for ; Fri, 20 Jul 2018 18:13:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lerdorf-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=8DQwC6BpdaUkmEp1Wi+njgR43eZj+A02jlpQ4A3T7d0=; b=1b4urZ9lMaIh90VHZOnUzGQF/V1qPUs4Wov+d3GFLpox5CwueQb70sE5s2qWMgBEVl QGJkSztMvBVyEr5SFGYkTAeni3gh2nCQ7QxxZ8FKO1c8ulGS5gSgmaavsj5qVBeTWLee GG+2QxyKkQTGkgtjUf84OuDul3ewXh2XDL/SHPbJujoOVZzI0bQNLkVX3eSVyIDCoM0b HPmcfV/V9xpJIIPjDlwJy9Gsc88MxcgOcQNSQRPiZcxpK/KFK5hmDdJYZM0Z5rjHkQta gJW8FwaJ2EbW70N5L3iotrrpQD+TjANh/H+5wFg1J4gzhG09c94PQFDgCZbqvQ+CyJT/ bp8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=8DQwC6BpdaUkmEp1Wi+njgR43eZj+A02jlpQ4A3T7d0=; b=mNtf7d4UsVjJ5w/LNIiKW2AgudhQqkDcQZTwTfYCqo1YwE8mnFBkRstHsqDVp0ZYyh Wr+S8gMxgwQ0YU+rtePB1zQHN0isy+oiPV7AujJ+UIquWN6mRlVjRduqqZBjwZ2vz8vs wlDNyQWCAmD+2JvNja3rVDa8PWh+ozmi+2xDXyHSM4EDkCU0TBff5cCWsHEJfF2UZlHz iY3fhD8UWO8pjOpxv1Cs+jBKV7ipuCwoXoON9eNjbMz3WblzZ4bpYMmgu/vXS2Q5vkP1 WCJxa+/tsGOtx2LfGhhvd/XGENObUTZtfv3Uw1yAMh48hb8wjO93Mvsu6EnReH8dMhWe omWQ== X-Gm-Message-State: AOUpUlH6BluDUQNfQyud8wgeo9c23seynykvntyLsRzm/vSUdNe7z8lG ryzchqjQJQNA8CcTgz6W5MPRxKRiYWEE1OLldthTag== X-Google-Smtp-Source: AAOMgpdaNkrt4kq+UUtdJ7xeRhRjF7jcujuX7K2FJnMgGzjQ/asT3iN/vP3P1Yuq17Her8MjnrjkBTNrhg6m+6/p5d0= X-Received: by 2002:aca:c1d6:: with SMTP id r205-v6mr8657oif.20.1532135577666; Fri, 20 Jul 2018 18:12:57 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a4a:4786:0:0:0:0:0 with HTTP; Fri, 20 Jul 2018 18:12:17 -0700 (PDT) In-Reply-To: <3ce44a21a935f3d458bd4fea99db89a4fd2c9603.camel@ku.edu> References: <3ce44a21a935f3d458bd4fea99db89a4fd2c9603.camel@ku.edu> Date: Fri, 20 Jul 2018 21:12:17 -0400 Message-ID: To: "Hoffman, Zachary Robert" Cc: "mapopa@gmail.com" , "me@kelunik.com" , "internals@lists.php.net" Content-Type: multipart/alternative; boundary="000000000000dadb860571781c07" Subject: Re: [PHP-DEV] bugs.php.net downtime From: rasmus@lerdorf.com (Rasmus Lerdorf) --000000000000dadb860571781c07 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Jul 19, 2018 at 4:45 PM, Hoffman, Zachary Robert wrote: > On Thu, 2018-07-19 at 22:35 +0200, Niklas Keller wrote: > > Hey Rasmus > > > > I just found this bug: https://bugs.php.net/bug.php?id=3D76553 > > > > Has this bug been like that before the migration, too? Or did > > something go wrong? > > No, those used to be Unicode characters from the cyrillic block. This appears to be database-related. Something got messed up with encodings on the mysql dump/import from MySQL 5.1.73 into MariaDB 10.1.26: mysql> select sdesc from bugdb where id=3D76553; +--------------------------------------------------------------------------= --------+ | sdesc | +--------------------------------------------------------------------------= --------+ | =D0=98=D0=BC=D1=8F =D0=BF=D0=B5=D1=80=D0=B5=D0=BC=D0=B5=D0=BD=D0=BD=D0=BE= =D0=B9 =D0=BC=D0=BE=D0=B6=D0=B5=D1=82 =D1=81=D0=BE=D0=B4=D0=B5=D1=80=D0=B6= =D0=B0=D1=82=D1=8C =D1=83=D0=BF=D1=80=D0=B0=D0=B2=D0=BB=D1=8F=D1=8E=D1=89= =D0=B8=D0=B5 | +--------------------------------------------------------------------------= --------+ 1 row in set (0.00 sec) MariaDB [phpbugsdb]> select sdesc from bugdb where id=3D76553; +--------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------+ | sdesc | +--------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------+ | =C3=90=CB=9C=C3=90=C2=BC=C3=91 =C3=90=C2=BF=C3=90=C2=B5=C3=91=E2=82=AC=C3= =90=C2=B5=C3=90=C2=BC=C3=90=C2=B5=C3=90=C2=BD=C3=90=C2=BD=C3=90=C2=BE=C3=90= =C2=B9 =C3=90=C2=BC=C3=90=C2=BE=C3=90=C2=B6=C3=90=C2=B5=C3=91=E2=80=9A =C3= =91 =C3=90=C2=BE=C3=90=C2=B4=C3=90=C2=B5=C3=91=E2=82=AC=C3=90=C2=B6=C3=90= =C2=B0=C3=91=E2=80=9A=C3=91=C5=92 =C3=91=C6=92=C3=90=C2=BF=C3=91=E2=82=AC= =C3=90=C2=B0=C3=90=C2=B2=C3=90=C2=BB=C3=91 =C3=91=C5=BD=C3=91=E2=80=B0=C3=90=C2=B8=C3=90=C2=B5 | +--------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------+ 1 row in set (0.00 sec) The dumped table schema from MySQL has: DROP TABLE IF EXISTS `bugdb`; /*!40101 SET @saved_cs_client =3D @@character_set_client */; /*!40101 SET character_set_client =3D utf8 */; CREATE TABLE `bugdb` ( `id` int(8) NOT NULL AUTO_INCREMENT, `package_name` varchar(80) CHARACTER SET latin1 DEFAULT NULL, `bug_type` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT 'Bug', `email` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '', `reporter_name` varchar(80) CHARACTER SET latin1 DEFAULT '', `sdesc` varchar(80) CHARACTER SET latin1 NOT NULL DEFAULT '', `ldesc` text CHARACTER SET latin1 NOT NULL, `php_version` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `php_os` varchar(32) CHARACTER SET latin1 DEFAULT NULL, `status` varchar(16) CHARACTER SET latin1 DEFAULT NULL, `ts1` datetime DEFAULT NULL, `ts2` datetime DEFAULT NULL, `assign` varchar(20) CHARACTER SET latin1 DEFAULT NULL, `passwd` varchar(64) CHARACTER SET latin1 DEFAULT NULL, `registered` tinyint(1) NOT NULL DEFAULT '0', `block_user_comment` char(1) DEFAULT 'N', `cve_id` varchar(15) DEFAULT NULL, `private` char(1) DEFAULT 'N', `visitor_ip` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `php_version` (`php_version`(1)), KEY `status` (`status`), KEY `package_name` (`package_name`), FULLTEXT KEY `email` (`email`,`sdesc`,`ldesc`) ) ENGINE=3DMyISAM AUTO_INCREMENT=3D76637 DEFAULT CHARSET=3Dutf8 PACK_KEYS= =3D1; /*!40101 SET character_set_client =3D @saved_cs_client */; When I dump it from MariaDB I see: DROP TABLE IF EXISTS `bugdb`; /*!40101 SET @saved_cs_client =3D @@character_set_client */; /*!40101 SET character_set_client =3D utf8 */; CREATE TABLE `bugdb` ( `id` int(8) NOT NULL AUTO_INCREMENT, `package_name` varchar(80) CHARACTER SET latin1 DEFAULT NULL, `bug_type` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT 'Bug', `email` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '', `reporter_name` varchar(80) CHARACTER SET latin1 DEFAULT '', `sdesc` varchar(80) CHARACTER SET latin1 NOT NULL DEFAULT '', `ldesc` text CHARACTER SET latin1 NOT NULL, `php_version` varchar(100) CHARACTER SET latin1 DEFAULT NULL, `php_os` varchar(32) CHARACTER SET latin1 DEFAULT NULL, `status` varchar(16) CHARACTER SET latin1 DEFAULT NULL, `ts1` datetime DEFAULT NULL, `ts2` datetime DEFAULT NULL, `assign` varchar(20) CHARACTER SET latin1 DEFAULT NULL, `passwd` varchar(64) CHARACTER SET latin1 DEFAULT NULL, `registered` tinyint(1) NOT NULL DEFAULT '0', `block_user_comment` char(1) DEFAULT 'N', `cve_id` varchar(15) DEFAULT NULL, `private` char(1) DEFAULT 'N', `visitor_ip` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `php_version` (`php_version`(1)), KEY `status` (`status`), KEY `package_name` (`package_name`), FULLTEXT KEY `email` (`email`,`sdesc`,`ldesc`) ) ENGINE=3DMyISAM AUTO_INCREMENT=3D76650 DEFAULT CHARSET=3Dutf8 PACK_KEYS= =3D1; /*!40101 SET character_set_client =3D @saved_cs_client */; Other than the autoincrement they are identical. I normally use utf8mb4, but I figured I would play it safe and copy it over verbatim. I guess it wasn't safe. I'll do some research, but ideas welcome. -Rasmus --000000000000dadb860571781c07--