Re: [Firebird-net-provider] fbstreambackup: free disk space exhausted
Hello, the database is at the moment on the same pc. When I have mastered the art of local backup I will move to the remote servers as well. Niko Von: Геннадий Забула [mailto:zabulu...@gmail.com] Gesendet: Samstag, 29. August 2015 17:04 An: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] fbstreambackup: free disk space exhausted I'm not sure, but can you check disk space on the remote server where database is placed? On Saturday, 29 August 2015, Parzival parzival1...@gmx.at mailto:parzival1...@gmx.at wrote: Hallo, I try to move from calling gbak as an external tool for backup and use fbstreambackup instead. Unfortunatly I get an error message free disk space exhausted, which is confusing. The disk has enough space to store the backup file. For that reason I am guessing that there is something wrong with the way I call the backup. This is the code (in vulcan.net http://vulcan.net ): // declare variables LOCAL fsb AS FbStreamingBackup LOCAL fs AS System.IO.FileStream // create new backup fsb := FbStreamingBackup{ sb:ToString() } fs := System.IO.FileStream{D:\temp\test.gbk, FileMode.Create } fsb:OutputStream := fs fsb:Execute() // It fails here Can please somebody point out what I am missing here? Maybe the filestream is not correct assign to FbStreamingBackup… Thanks Niko -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
Can it be merged to master and released as Beta so this won't be used by everybody? On Saturday, 29 August 2015, Jiří Činčura j...@cincura.net wrote: I do. I’m still waiting for EF 6.2 as it contains some fixes we need for proper error reporting. It’s already fixed in sources, but not yet released. It works but people would complain and given how much stupid questions I get about DDEX, I’m not going to do that. -- Mgr. Jiří Činčura Independent IT Specialist *From:* Геннадий Забула [mailto:zabulu...@gmail.com javascript:_e(%7B%7D,'cvml','zabulu...@gmail.com');] *Sent:* Saturday, August 29, 2015 5:18 PM *To:* For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net javascript:_e(%7B%7D,'cvml','firebird-net-provider@lists.sourceforge.net'); *Subject:* [Firebird-net-provider] Migrations What is the current status of migrations? Last change was 8 month. Do you plan to merge it to master? We are using branch for almost half year in our project and can give some feedback/fixes. And want to port them to upstream. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbstreambackup: free disk space exhausted
Hello Jiri, thanks - that explains the message. I will update the FB Servers on the customers site to 2.5.4 over the next weeks/months. Then the feature is ready to go. Niko -Ursprüngliche Nachricht- Von: Jiří Činčura [mailto:j...@cincura.net] Gesendet: Samstag, 29. August 2015 18:17 An: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] fbstreambackup: free disk space exhausted This error you'll get when the server version you're using does not support this feature. It was introduced in 2.5.3 I think and 2.5.2 would not cut it. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
Ok. For now we had such issues: 1. Long names of tables causes foreign key script creation fail with error Name exceeded implementation limitation. This caused by 31 characters limitation to almost anything not only FK. We crutched this with hashing names with base64 convert. Ugly but works. 2. Second it is drop from support databases with pages less than 16384 because of another impl. limitation for max string field length. This breaks creating MigrationHistory table. We didn't fixed this, because started using separate database. But in near future our previous database would also need to have migrations. I think this can be crutched to use blob field only for Model field of this table. 3. Issue with sequence generators. Maybe you remember discussion about this on github. Looks like I've found good place to configurate particular field. It is in OnModelCreating Properties().Configure(x=x.AddAnotation()) for property. There user can specify what sequence behavior does he need or provide custom. Today I tried to add tests for all this to repo but found out that we need to add separate test infrastructure for EF tests. -Original Message- From: Jiří Činčura j...@cincura.net Sent: 8/29/2015 7:29 PM To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Migrations Also if you have some feedback you can discuss it here ahead of time. No problem with that. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
Can it be merged to master and released as Beta so this won't be used by everybody? Probably. It would be nice to know when EF6.2 will go out, so we know how long is going to be in beta state. For me it doesn't make much sense to have it in beta for say 5+ months. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
Also if you have some feedback you can discuss it here ahead of time. No problem with that. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbstreambackup: free disk space exhausted
I'm not sure, but can you check disk space on the remote server where database is placed? On Saturday, 29 August 2015, Parzival parzival1...@gmx.at wrote: Hallo, I try to move from calling gbak as an external tool for backup and use fbstreambackup instead. Unfortunatly I get an error message free disk space exhausted, which is confusing. The disk has enough space to store the backup file. For that reason I am guessing that there is something wrong with the way I call the backup. This is the code (in vulcan.net): // declare variables LOCAL fsb AS FbStreamingBackup LOCAL fs AS System.IO.FileStream // create new backup fsb := FbStreamingBackup{ sb:ToString() } fs := System.IO.FileStream{D:\temp\test.gbk, FileMode.Create } fsb:OutputStream := fs fsb:Execute() // It fails here Can please somebody point out what I am missing here? Maybe the filestream is not correct assign to FbStreamingBackup… Thanks Niko -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Migrations
What is the current status of migrations? Last change was 8 month. Do you plan to merge it to master? We are using branch for almost half year in our project and can give some feedback/fixes. And want to port them to upstream. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
I do. I’m still waiting for EF 6.2 as it contains some fixes we need for proper error reporting. It’s already fixed in sources, but not yet released. It works but people would complain and given how much stupid questions I get about DDEX, I’m not going to do that. -- Mgr. Jiří Činčura Independent IT Specialist From: Геннадий Забула [mailto:zabulu...@gmail.com] Sent: Saturday, August 29, 2015 5:18 PM To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Migrations What is the current status of migrations? Last change was 8 month. Do you plan to merge it to master? We are using branch for almost half year in our project and can give some feedback/fixes. And want to port them to upstream. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
1. Long names of tables causes foreign key script creation fail with error Name exceeded implementation limitation. This caused by 31 characters limitation to almost anything not only FK. We crutched this with hashing names with base64 convert. Ugly but works. Maybe we can, in case it's longer than 31 characters, simply use GUID. Not nice either, though. 2. Second it is drop from support databases with pages less than 16384 because of another impl. limitation for max string field length. This breaks creating MigrationHistory table. We didn't fixed this, because started using separate database. But in near future our previous database would also need to have migrations. I think this can be crutched to use blob field only for Model field of this table. You mean the PK on MigrationHistory? We can specify 16k page size as a requirement. There's not much to invent on the PK. 3. Issue with sequence generators. Maybe you remember discussion about this on github. Looks like I've found good place to configurate particular field. It is in OnModelCreating Properties().Configure(x=x.AddAnotation()) for property. There user can specify what sequence behavior does he need or provide custom. True. And with custom convention it's not even needed to specify it explicitly for every column. Today I tried to add tests for all this to repo but found out that we need to add separate test infrastructure for EF tests. There's few tests I wrote. Using CF as that's easy to set up. But maybe the migrations would need deeper setup. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
1. I've used hashes from names to avoid dictionaries for mapping name-guid. 2. I think it was about Model field. More precise error I'll tell tomorrow when PC will be available. I don't want to constraint page size, because changing page size for existing databases is done only via backup-restore AFAIK. In case of several GB dbs it's not an option. 3. Yes. Default behavior maybe several pre defined and possibility to provide custom. 4. One more issue I remembered. Dbs created with Initial migration and via CreateDatabaseIfNotExists have different underlying scheme in part of names. I think this should be also fixed. -Original Message- From: Jiří Činčura j...@cincura.net Sent: 8/29/2015 10:08 PM To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Migrations 1. Long names of tables causes foreign key script creation fail with error Name exceeded implementation limitation. This caused by 31 characters limitation to almost anything not only FK. We crutched this with hashing names with base64 convert. Ugly but works. Maybe we can, in case it's longer than 31 characters, simply use GUID. Not nice either, though. 2. Second it is drop from support databases with pages less than 16384 because of another impl. limitation for max string field length. This breaks creating MigrationHistory table. We didn't fixed this, because started using separate database. But in near future our previous database would also need to have migrations. I think this can be crutched to use blob field only for Model field of this table. You mean the PK on MigrationHistory? We can specify 16k page size as a requirement. There's not much to invent on the PK. 3. Issue with sequence generators. Maybe you remember discussion about this on github. Looks like I've found good place to configurate particular field. It is in OnModelCreating Properties().Configure(x=x.AddAnotation()) for property. There user can specify what sequence behavior does he need or provide custom. True. And with custom convention it's not even needed to specify it explicitly for every column. Today I tried to add tests for all this to repo but found out that we need to add separate test infrastructure for EF tests. There's few tests I wrote. Using CF as that's easy to set up. But maybe the migrations would need deeper setup. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DNET-532
Fresh PR for this issue: https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/35 On 27 August 2015 at 07:58, Jiří Činčura j...@cincura.net wrote: One more question about string.Equals. Comparison type used in IndexOf calls is StringComparison.CurrentCultureIgnoreCase. My question why this used instead of OrdinalIgnoreCase? My current optimization, including StringComparison change decreased timings to 22 (names) vs 6 (indexes) seconds. Because of national characters. Somebody might use these in parameter name. Although it's pretty weird, I had similar issue in DDEX. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider