ycherkes / orcasql Goto Github PK

System.ArgumentOutOfRangeException:The specified argument is out of range.

Parameter name:File with ID 4 is not part of this database.

in OrcaSql.Core.Engine.BufferManager.GetPageBytes(Int16 fileID, Int64 pageID, Boolean putResultToCache) BufferManager.cs:string 36
in OrcaSql.Core.Engine.Database.GetPageBytes(PagePointer pagePointer, Boolean putResultsToCache) Database.cs:string 138
in OrcaSql.Core.Engine.Database.GetPfsPage(PagePointer loc) Database.cs:string 236
in OrcaSql.Core.Engine.DataScanner.d__8.MoveNext() DataScanner.cs:string 164
in OrcaSql.Core.Engine.DataScanner.d__7.MoveNext() DataScanner.cs:string 149
in System.Linq.Enumerable.d__172.MoveNext() in System.Linq.Enumerable.<TakeIterator>d__251.MoveNext()
in OrcaSql.OSMS.Main.ShowRows(IEnumerable1 rows, Row schemaRow, String tableName, Int64 rowCount) Main.cs:string 514 in OrcaSql.OSMS.Main.LoadTable(String table, Nullable1 schemaId, Int64 rowCount) Main.cs:string 450

sql server 2014 i open mdf file

here it crashes for me:
rows = scanner.ScanTable(table, schemaId, false).Take(takeRowCount)

I also have a LogCur.ndf file for this project

Violated "PK_CodesDictionaryTable" PRIMARY KEY constraint. Cannot insert duplicate key into object 'dbo.CodesDictionaryTable'. Duplicate key value: (1).

Is it possible to skip duplicate values ​​and create a table if it doesn't exist, and if it does, skip and go to filling?

Unable to select top 1000 rows

   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.BitConverter.ToInt16(Byte[] value, Int32 startIndex)
   at OrcaSql.Core.Engine.Pages.RecordPage.parseSlotArray() in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\Pages\RecordPage.cs:line 21
   at OrcaSql.Core.Engine.Pages.RecordPage..ctor(Byte[] bytes, Database database) in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\Pages\RecordPage.cs:line 13
   at OrcaSql.Core.Engine.Pages.TextMixPage..ctor(Byte[] bytes, Database database) in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\Pages\TextMixPage.cs:line 12
   at OrcaSql.Core.Engine.Database.GetTextMixPage(PagePointer loc) in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\Database.cs:line 189
   at OrcaSql.Core.Engine.Records.VariableLengthDataProxies.BlobInlineRootProxy.GetBytes() in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\Records\VariableLengthDataProxies\BlobInlineRootProxy.cs:line 45
   at OrcaSql.Core.Engine.Records.Parsers.PrimaryRecordEntityParser.<GetEntities>d__5.MoveNext() in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\Records\Parsers\PrimaryRecordEntityParser.cs:line 73
   at OrcaSql.Core.Engine.DataScanner.<ScanLinkedDataPages>d__5.MoveNext() in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\DataScanner.cs:line 62
   at OrcaSql.Core.Engine.DataScanner.<ScanPartition>d__7.MoveNext() in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\DataScanner.cs:line 143
   at System.Linq.Enumerable.<SelectManyIterator>d__17`2.MoveNext()
   at System.Linq.Enumerable.<CastIterator>d__97`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at OrcaSql.Core.MetaData.BaseTableData.get_SysObjValues() in C:\Projects\OrcaSql\src\OrcaSql.Core\MetaData\BaseTableData.cs:line 39
   at OrcaSql.Core.MetaData.DMVs.SqlModule.<>c__DisplayClass31_0.<GetDmvData>b__1(sysschobj o) in C:\Projects\OrcaSql\src\OrcaSql.Core\MetaData\DMVs\SqlModule.cs:line 53
   at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at OrcaSql.Core.MetaData.DMVs.SqlModule.GetDmvData(Database db) in C:\Projects\OrcaSql\src\OrcaSql.Core\MetaData\DMVs\SqlModule.cs:line 51
   at OrcaSql.Core.MetaData.DmvGenerator.get_SqlModules() in C:\Projects\OrcaSql\src\OrcaSql.Core\MetaData\DmvGenerator.cs:line 44
   at OrcaSql.Core.MetaData.DMVs.SysDefaultConstraint.GetDmvData(Database db) in C:\Projects\OrcaSql\src\OrcaSql.Core\MetaData\DMVs\SysDefaultConstraint.cs:line 132
   at OrcaSql.Core.MetaData.DmvGenerator.get_SysDefaultConstraints() in C:\Projects\OrcaSql\src\OrcaSql.Core\MetaData\DmvGenerator.cs:line 38
   at OrcaSql.Core.Engine.DataScanner.<ScanPartition>d__7.MoveNext() in C:\Projects\OrcaSql\src\OrcaSql.Core\Engine\DataScanner.cs:line 118
   at System.Linq.Enumerable.<SelectManyIterator>d__17`2.MoveNext()
   at System.Linq.Enumerable.<TakeIterator>d__25`1.MoveNext()
   at OrcaSql.OSMS.Main.ShowRows(IEnumerable`1 rows, Row schemaRow, String tableName, Int64 rowCount) in C:\Projects\OrcaSql\src\OrcaSql.OSMS\Main.cs:line 514
   at OrcaSql.OSMS.Main.LoadTable(String table, Nullable`1 schemaId, Int64 rowCount) in C:\Projects\OrcaSql\src\OrcaSql.OSMS\Main.cs:line 450

This is the error:

Loading Primary Record Page (1:844429225416932)
Exception thrown: 'System.IndexOutOfRangeException' in OrcaSql.Core.dll
System.IndexOutOfRangeException: O índice estava fora dos limites da matriz.
em OrcaSql.Core.Engine.Records.PrimaryRecord..ctor(Byte[] bytes, Page page) na C:\Users\jlmac\source\repos\OrcaSQL\src\OrcaSql.Core\Engine\Records\PrimaryRecord.cs:linha 32
em OrcaSql.Core.Engine.Pages.PrimaryRecordPage.parseRecords() na C:\Users\jlmac\source\repos\OrcaSQL\src\OrcaSql.Core\Engine\Pages\PrimaryRecordPage.cs:linha 30

System.ArgumentException: Unsupported type: POST(numeric(16, 0)), null
at OrcaSql.Core.MetaData.DataColumn..ctor(String name, String type, Boolean nullable)
at OrcaSql.Core.MetaData.DataColumn..ctor(String name, String type)
at OrcaSql.Core.MetaData.DatabaseMetaData.GetEmptyDataRow(String tableName, Nullable1 schemaId) at OrcaSql.Core.Engine.DataScanner.ScanTable(String tableName, Nullable1 schemaId, Boolean isSysTable)
at OrcaSql.OSMS.Main.LoadTable(String table, Nullable`1 schemaId, Int64 rowCount) in
.\OrcaSql\src\OrcaSql.OSMS\Main.cs:line 448

8/2/2023 6:04:55 PM

System.ArgumentException: Invalid value length: 12
at OrcaSql.Core.Engine.SqlTypes.SqlUniqueIdentifier.GetValue(Byte[] value) in C:\Plays\OrcaSql\src\OrcaSql.Core\Engine\SqlTypes\SqlUniqueIdentifier.cs:line 26
at OrcaSql.Core.Engine.Records.Parsers.PrimaryRecordEntityParser.d__5.MoveNext() in C:\Plays\OrcaSql\src\OrcaSql.Core\Engine\Records\Parsers\PrimaryRecordEntityParser.cs:line 96
at OrcaSql.Core.Engine.DataScanner.d__5.MoveNext() in C:\Plays\OrcaSql\src\OrcaSql.Core\Engine\DataScanner.cs:line 62
at OrcaSql.Core.Engine.DataScanner.d__7.MoveNext() in C:\Plays\OrcaSql\src\OrcaSql.Core\Engine\DataScanner.cs:line 143
at System.Linq.Enumerable.d__172.MoveNext() at System.Linq.Enumerable.<TakeIterator>d__251.MoveNext()
at OrcaSql.OSMS.Main.ShowRows(IEnumerable1 rows, Row schemaRow, String tableName, Int64 rowCount) in C:\Plays\OrcaSql\src\OrcaSql.OSMS\Main.cs:line 514 at OrcaSql.OSMS.Main.LoadTable(String table, Nullable1 schemaId, Int64 rowCount) in C:\Plays\OrcaSql\src\OrcaSql.OSMS\Main.cs:line 450