Index was outside the bounds of the array.

[micro9000]

I'm getting Index was outside the bounds of the array error

System.IndexOutOfRangeException: Index was outside the bounds of the array. at Hangfire.MySql.MySqlStorage.<>c.b__14_1(String[] x) at System.Linq.Enumerable.WhereSelectArrayIterator2.MoveNext() at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable1 source, Func2 keySelector, Func2 elementSelector, IEqualityComparer`1 comparer) at Hangfire.MySql.MySqlStorage.ToString()

I'm using ASP.NET MVC .NET Framework, below is my code in Global.asax.cs

public class MvcApplication : System.Web.HttpApplication
    {
        private IEnumerable<IDisposable> GetHangfireServers ()
        {
            GlobalConfiguration.Configuration.UseStorage(
                new MySqlStorage(
                    ConfigurationManager.ConnectionStrings["hangfireDBConnString"].ToString(),
                    new MySqlStorageOptions
                    {
                        TransactionIsolationLevel = IsolationLevel.ReadCommitted,
                        QueuePollInterval = TimeSpan.FromSeconds(15),
                        JobExpirationCheckInterval = TimeSpan.FromHours(1),
                        CountersAggregateInterval = TimeSpan.FromMinutes(5),
                        PrepareSchemaIfNecessary = true,
                        DashboardJobListLimit = 50000,
                        TransactionTimeout = TimeSpan.FromMinutes(1),
                        TablesPrefix = "hangfire"
                    }));

            yield return new BackgroundJobServer();
        }

        protected void Application_Start ()
        {
            AreaRegistration.RegisterAllAreas();
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);

            HangfireAspNet.Use(GetHangfireServers);

            UnityConfig.RegisterComponents();
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            // Let's also create a sample background job
            //BackgroundJob.Enqueue(() => Debug.WriteLine("Hello world from Hangfire!"));
        }
    }

    public class HangFireBackgroundService
    {
        private BackgroundJobServer server;

        public bool Start ()
        {

            this.server = new BackgroundJobServer();
            return true;
        }

        public bool Stop ()
        {
            this.server.Dispose();
            return true;
        }
    }

[praadit]

Did you solved this problem? @micro9000

[micro9000]

Did you solved this problem? @micro9000

No, I decided not to use Hangfire on my ASP.NET MVC project, I have no idea why I'm getting this error, but even I have this error, it works for simple task But I'm using Unity for DI, I can't use Hangfire properly.

[praadit]

I got this error

 fail: Hangfire.MySql.MySqlStorage[0] 
 Index was outside the bounds of the array.
 System.IndexOutOfRangeException: Index was outside the bounds of the array.
         at Hangfire.MySql.MySqlStorage.<>c.<ToString>b__14_1(String[] x)
         at System.Linq.Utilities.<>c__DisplayClass2_0'3.<CombineSelectors>b__0(TSource x)
         at System.Linq.Enumerable.SelectArrayIterator'2.MoveNext()
         at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable'1 source, Func'2 keySelector, Func'2 elementSelector, IEqualityComparer'1 comparer)
         at Hangfire.MySql.MySqlStorage.ToString()

It because you have semicolon (;) in your password or your password is empty but you include it in Connection String

[samcov]

I get the same error, and my password is NOT empty and doesn't have a semicolon in it.

I do further get the error: "Connection string can not be parsed".

Oddly, it works as expected, but these errors bother me.

[lukasan]

@samcov I had this problem as well, everything works but throws these errors. I got it fixed simply by editing the connection string's password from password= to password='', notice two single quotation marks. So similarly people should probably use password='hunter2' instead of password=hunter2. Doesn't matter if the password is at the end of the string or in the middle somewhere. So the whole string that works for me is: "HangfireConnection": "Server=localhost;Database=hangdb;Allow User Variables=true;user=root;password='';port=3306"

I believe that connection string gets parsed somewhere without all variations.

Hope this helps for anyone else searching for the answer too!

[wnttmk]

I get the same error,Later on, I found out that there was a space at the end of my connection statement "Database=hncore;Data Source=localhost;Port=3306;User Id=root;Password=123456;Charset=utf8;TreatTinyAsBoolean=false;AllowLoadLocalInfile=true;Allow User Variables=True; " yes, I Modify to "Database=hncore;Data Source=localhost;Port=3306;User Id=root;Password=123456;Charset=utf8;TreatTinyAsBoolean=false;AllowLoadLocalInfile=true;Allow User Variables=True;"

Pay attention to the last blank space, you can't see it

all fine