GZip头文件中的魔数不正确。请确保传递的是GZip流。

Question

我正在使用Mysql数据库开发WinForm应用程序，当我在MySql Workbench上运行数据库脚本时，会显示如下消息： 我点击“确定”后，会显示脚本内容： 在运行脚本并创建数据库后，当我在WinForm应用程序中进行第一次查询时，会出现以下异常：

var permissions_in_db = db.Permissions
                            .Where(a => a.Name == s)
                            .Count();

无法控制 System.IO.InvalidDataException 错误 : "GZip 标头中的魔数不正确。请确保您正在传递 GZip 流。"

以下是追踪信息:

System.IO.InvalidDataException not be controlled
  HResult = -2146233087
  Message = The magic number in GZip header is not correct. Make sure you are passing a GZip stream.
  Source = System
  StackTrace :
       in System.IO.Compression.GZipDecoder.ReadHeader ( InputBuffer input)
       in System.IO.Compression.Inflater.Decode ( )
       in System.IO.Compression.Inflater.Inflate ( Byte [ ] bytes , Int32 offset , Int32 length)
       in System.IO.Compression.DeflateStream.Read ( Byte [ ] array , Int32 offset , Int32 count)
       in System.IO.Compression.GZipStream.Read ( Byte [ ] array , Int32 offset , Int32 count)
       in System.Xml.XmlTextReaderImpl.InitStreamInput ( baseUri Uri , String baseUriStr , Stream stream , Byte [ ] bytes , Int32 byteCount , Encoding encoding)
       in System.Xml.XmlTextReaderImpl.FinishInitStream ( )
       in System.Xml.XmlReaderSettings.CreateReader (Stream input , baseUri Uri , String baseUriString , XmlParserContext inputContext )
       in System.Xml.XmlReader.Create (Stream input , XmlReaderSettings settings , String baseUri )
       in System.Xml.Linq.XDocument.Load (Stream stream, LoadOptions options)
       in System.Data.Entity.Migrations.Edm.ModelCompressor.Decompress ( Byte [ ] bytes )
       in System.Data.Entity.Migrations.History.HistoryRepository.GetLastModel (String & migrationId )
       in System.Data.Entity.Migrations.History.HistoryRepository.GetLastModel ( )
       in System.Data.Entity.Internal.InternalContext.QueryForModel ( )
       in System.Data.Entity.Internal.ModelCompatibilityChecker.CompatibleWithModel ( InternalContext internalContext , ModelHashCalculator modelHashCalculator , Boolean throwIfNoMetadata )
       in System.Data.Entity.Internal.InternalContext.CompatibleWithModel (Boolean throwIfNoMetadata )
       in System.Data.Entity.Database.CompatibleWithModel (Boolean throwIfNoMetadata )
       in System.Data.Entity.DropCreateDatabaseIfModelChanges ` 1.InitializeDatabase ( tcontext context)
       in System.Data.Entity.Database . < > c__DisplayClass2 ` 1. <SetInitializerInternal> b__0 ( DbContext c )
       in System.Data.Entity.Internal.InternalContext . < > c__DisplayClass8 . <PerformDatabaseInitialization> b__6 ( )
       in System.Data.Entity.Internal.InternalContext.PerformInitializationAction ( Action action)
       in System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization ( )
       in System.Data.Entity.Internal.LazyInternalContext . <InitializeDatabase> b__4 ( InternalContext c )
       in System.Data.Entity.Internal.RetryAction ` 1.PerformAction ( TInput input)
       in System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction ( Action ` 1 action )
       in System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase ( )
       in System.Data.Entity.Internal.InternalContext.Initialize ( )
       in System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType (Type entityType )
       in System.Data.Entity.Internal.Linq.InternalSet 1.Initialize ` ( )
       in System.Data.Entity.Internal.Linq.InternalSet 1.get_InternalContext ` ( )
       in System.Data.Entity.Infrastructure.DbQuery 1.System.Linq.IQueryable.get_Provider ` ( )
       in System.Linq.Queryable.Where [ TSource ] (IQueryable ` 1 source , Expression ` 1 predicate )
       in RoleCreatorV5_net4.Login.button1_Click (Object sender, EventArgs e) in c: \ Users \ Rafa \ Downloads \ 1 \ final versions \ RoleCreatorV5_net4 \ Login.cs : line 30
       in System.Windows.Forms.Button.OnMouseUp ( MouseEventArgs mevent )
       at System.Windows.Forms.Control.WmMouseUp (Message & m , MouseButtons button , Int32 clicks)
       at System.Windows.Forms.Control.WndProc (Message & m )
       in System.Windows.Forms.ButtonBase.WndProc (Message & m )
       in System.Windows.Forms.Button.WndProc (Message & m )
       in System.Windows.Forms.NativeWindow.DebuggableCallback (IntPtr hWnd , Int32 msg , IntPtr wparam , IntPtr lparam )
       in System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW (MSG & msg)
       in System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID , Int32 reason , Int32 pvLoopData )
       in System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner (Int32 reason , ApplicationContext context)
       in System.Windows.Forms.Application.ThreadContext.RunMessageLoop (Int32 reason , ApplicationContext context)
       in RoleCreatorV5_net4.Program.Main () in c: \ Users \ Rafa \ Downloads \ 1 \ final versions \ RoleCreatorV5_net4 \ Program.cs : line 70
       in System.AppDomain._nExecuteAssembly ( RuntimeAssembly assembly, String [ ] args)
       in System.Runtime.Hosting.ApplicationActivator.CreateInstance ( ActivationContext activationContext , String [ ] activationCustomData )
       in Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssemblyDebugInZone ( )
       in System.Threading.ExecutionContext.RunInternal ( ExecutionContext executionContext , ContextCallback callback , Object state , Boolean preserveSyncCtx )
       at System.Threading.ExecutionContext.Run ( ExecutionContext executionContext , ContextCallback callback , Object state , Boolean preserveSyncCtx )
       at System.Threading.ExecutionContext.Run ( ExecutionContext executionContext , ContextCallback callback , Object state )
       in System.Threading.ThreadHelper.ThreadStart ( )
  InnerException :

这是来自Program.cs的代码。

[STAThread]
        static void Main()
        {

            Database.SetInitializer<MySqlContext>(new DropCreateDatabaseIfModelChanges<MySqlContext>());


            var connString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ToString();

            using (var db = new MySqlContext())
            {

                #region Load CheckedList1

                const string f = "/Users/Rafa/Documents/Proyecto NS/SavedList.txt";
                List<string> lines = new List<string>();
                using (StreamReader r = new StreamReader(f))
                {
                    string line;
                    while ((line = r.ReadLine()) != null)
                    {
                        lines.Add(line);
                    }
                }

                foreach (string s in lines)
                {

                    var permissions_in_db = db.Permissions
                        .Where(a => a.Name == s)
                        .Count();
                    if (permissions_in_db < 1)
                    {
                        if (s!="")
                        {
                            db.Permissions.AddOrUpdate(new Permission
                            {
                                Name = s
                            });
                            db.SaveChanges();    
                        }

                    }
                }
                #endregion

                db.SaveChanges();
            }

            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new Login());
        }
    }

我真的希望有人能帮助我！

- Rafael Reyes

---

你尝试过在运行脚本之前将SQL文件的编码更改为兼容版本吗？ - merp

const string f = "/Downloads/SavedList.txt"; 你的斜杠方向不对。 - merp

另外……如果你改变了反斜杠的方向\Downloads\SavedList.txt，那么这甚至不是一个有效的路径。 - merp

你的路径仍然无效/Users/Rafa/Documents/Proyecto NS/SavedList.txt不正确，你需要这样做@"C:\Users\Rafa\Documents\Proyecto NS\SavedList.txt"。你是否调试过以查看你的lines对象是否被填充？ - merp

我会重新创建数据库 @OhaxNuv - Rafael Reyes

Answer 1

是的，__migrationhistory模型列中有一些数据，拉丁编码会破坏数据。为了修复，请在不打开文件的情况下运行脚本。使用新的MySql Workbench，有一个“运行SQL脚本”按钮，可以让您在不指定编码的情况下运行。

- Lee Song