text:
de-DE: Replace ASCII apostrophes

This replaces ASCII apostrophes in the German translation with U+2019.
See also: https://github.com/OpenRCT2/Localisation/issues/2121

Object translations are now also maintained in the Localisation repository. For German, you need to modify this file: https://github.com/OpenRCT2/Localisation/blob/master/objects/de-DE.json

Object translations are now also maintained in the Localisation repository. For German, you need to modify this file: https://github.com/OpenRCT2/Localisation/blob/master/objects/de-DE.json


text:
Maxwell Operators Spectral Form

At the current time this issue has been created, the way the TimeDependentOperator and Solver update the fields each time step involves the multiplication of individual matrices, for different field types, directions and flux types (centered, zero-normal flux (penalty), one-normal and two-normal flux).
It could be interesting to exploit the Discontinuous Galerkin method considering some of the created matrices have a diagonal in blocks shape, with each of those blocks being the same. This modification could save memory and improve calculation time, along with opening the door to study stability thanks to the eigenvalues extracted from the global matrix.

Renaming item to Spectral Form.
1D Spectral Form implemented and functional.

2D Spectral Form implemented and functional.

3D Spectral Form implemented and functional.

source: gharchive/issue

repo: OpenSEMBA/dgtd

license_type: permissive

license_source: github-api


text:
Blog: Bitcoin Grants 6th Wave

BUILD PREVIEW
PREVIEW IMAGE:
TODO

@dergigi Need your help to create the blog header image for this announcement 🙏

Will get on it on Monday 🤙

It's live!

https://opensats.org/blog/bitcoin-grants-july-2024-6th-wave
https://njump.me/nevent1qqs9nn8quv0cp9q6dq087a9tvm6u5dtq5v5djfxdrqjvyczzxl8hftszypu8xwr40lp96ewdj2fef408wy70gd3carf9n6xu7hrnhq6whpglyhzksvx

source: gharchive/pull-request

repo: OpenSats/website

license: MIT


text:
Timezone Table in Joda vs. custom geonames.org table

Time to evaluate how Timezones associated with Country obj could be better automated and improved through Joda Time's TZ db

I haven't used Joda yet but I have used Java 8's new time API that is said to be a port of Joda -- no doubt with some differences.  Just sharing; perhaps you needn't bring in a new dependency if you need Java 8.

authors: dsmiley mubaldino

repo: OpenSextant/Xponents

license_source: bigquery


text:
Development / local installation option does not work for Django commands

This works:
$ python3 -m venv venv
$ source venv/bin/activate
$ pip install openslides-x.x.tar.gz  # Use correct filename here
$ openslides start --development

But the following not:
$ python3 -m venv venv
$ source venv/bin/activate
$ pip install openslides-x.x.tar.gz  # Use correct filename here
$ openslides createsettings --development
$ openslides migrate --development
$ openslides runserver --development

@ostcar Can you look at this issue please. Could be important for 2.0. (Note: the options --development was renamed with #2012 to --local-installation)

At the moment the argument is only an argument for the start command and the createsettings command. See line 92 and 107 in _main_.py. To fix this, it has to be a global argument, like --version.
Then setup_django_settings_module(settings_path, development=development) has to be called at a global place like 32 in _main_.py.
I have no interest in fixing this.

@normanjaeckel Can you look at this issue please?

The problem was introduced by the grand refactoring of the start script about one year ago. Before the runserver and syncdb command were custom commands not Django commands.
Maybe you can use the add_arguments() method.

A hint how to use openslides with runserver with a specific settings:

Create the settings in a specific folder, for example mysettings/settings.py

Go to this folder, for example cd mysettings

Run openslides with the following command:

PYTHONPATH='.' DJANGO_SETTINGS_MODULE='settings' openslides runserver -p 12345

Conslusion of our last telephone conference: The --local-installation option is only a helper for the OpenSlides start command. So we do not implement it for the Django commands like runserver. This means you have to use either start or set the environment variables, see @ostcar's hint.

authors: emanuelschuetze normanjaeckel ostcar

repo: OpenSlides/OpenSlides


text:
Polls/elections: problem with default value analog

Description: If a user changes the default value of voting type for polls or elections to analog in the settings, votes didn't work anymore. (Also an error message appears in the console.) Even if the value is switched back to other voting types, it's not possible to reactivate the voting function.
Affected setting - voting type of ballots (elections)

Affected setting - voting type of motions

error message during vote creation - motions

error message during ballot creation:

Reproduction:

open a meeting
open settings > motions > default voting type > change to analog
open settings > elections > default voting type > change to analog
open motions > create a motion > change status to a state were voting is possible > create a vote
open elections > create a new election > add candidates > create a new ballot
Try to switch back the default voting type for motions and perform step again -> won't work -> voting is not possible anymore

What should happen:
Changing default voting types for elections and/or motions to analog shouldn't lead to a fatal error of the whole voting system.

Regression from #2963

authors: MSoeb bastianjoel

repo: OpenSlides/openslides-client


text:
Script has Error

'numpy._DTypeMeta' object is not subscriptable
while running the inference.py file

Have you found any solution for this error?

Currently Not
On Tue, 12 Sep, 2023, 9:18 pm Ilyes TALBI, @.***> wrote:

Have you found any solution for this error?
—
Reply to this email directly, view it on GitHub
https://github.com/OpenTalker/video-retalking/issues/100#issuecomment-1715986137,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/APZU6U3OEX6VAC77WSJZB6TX2B74PANCNFSM6AAAAAA4CMASDE
.
You are receiving this because you authored the thread.Message ID:
@.***>

I change requirements.txt to this : https://github.com/OpenTalker/video-retalking/issues/48#issuecomment-1583827089
It worked for me

Glad to hear it!
On Wed, 13 Sep, 2023, 2:15 pm Ilyes TALBI, @.***> wrote:

I change requirements.txt to this : #48 (comment)
https://github.com/OpenTalker/video-retalking/issues/48#issuecomment-1583827089
It worked for me
—
Reply to this email directly, view it on GitHub
https://github.com/OpenTalker/video-retalking/issues/100#issuecomment-1717204993,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/APZU6U3SYE3JFB43MPBCAWDX2FXB5ANCNFSM6AAAAAA4CMASDE
.
You are receiving this because you authored the thread.Message ID:
@.***>

authors: IlyesTal KartavyaBagga

repo: OpenTalker/video-retalking


text:
Publish to conan

Hi,
Would it be possible to publish the code to conan ?
I have tried modifying it to be publishable, but my conan-fu is miserable ...

See #11 for a look at my attempt.

repo: OpenTimer/Parser-Verilog


text:
manifest for smartgic/ovos-messagebus:dev not found

I am using the last version from dev:
$ docker compose up
[+] Running 7/7
 ✘ ovos_phal_admin Error                                                          1.6s
 ✘ ovos_audio Error                                                               1.6s
 ✘ ovos_cli Error                                                                 1.6s
 ✘ ovos_listener Error                                                            1.6s
 ✘ ovos_messagebus Error                                                          1.6s
 ✘ ovos_core Error                                                                1.6s
 ✘ ovos_phal Error                                                                1.6s
Error response from daemon: manifest for smartgic/ovos-messagebus:dev not found: manifest unknown: manifest unknown

You will have to git pull the latest changes, the  dev tag doesn't exist anymore since it has been replaces by the alpha tag (since we are building from the alpha releases on PyPi).

Ok, I pulled but I have local changes, so I think I messed up things in the rebase. Thank you

authors: atd goldyfruit

repo: OpenVoiceOS/ovos-docker


text:
🛑 Translator - NLLB - Ziggyai is down

In 596d8e9, Translator - NLLB - Ziggyai (https://ovosnllb.ziggyai.online/status) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Translator - NLLB - Ziggyai is back up in 67e5a18 after 7 minutes.

repo: OpenVoiceOS/status


text:
🛑 Translator - NLLB - Smart'Gic is down

In 4609642, Translator - NLLB - Smart'Gic (https://translator.smartgic.io/nllb/status) was down:

HTTP code: 503
Response time: 538 ms

Resolved: Translator - NLLB - Smart'Gic is back up in dc192d4 after 8 minutes.


text:
🛑 Text-to-Speech - Mimic3 - Smart'Gic is down

In d974a7b, Text-to-Speech - Mimic3 - Smart'Gic (https://tts.smartgic.io/mimic3/status) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Text-to-Speech - Mimic3 - Smart'Gic is back up in e54f327.


text:
Update modifiers to throw and update corresponding tests

In order to bring the codebase inline with the project guideline: G2 - Code that Fails Early, this PR makes modifiers fail "loudly" by throwing instead of silently no-oping. This leaves no ambiguity to the contract caller whether or not their action had succeeded.
The corresponding tests were also updated.

This is amazing, I wanted to this for a long time.
Thanks for taking care of it :D

Glad I could help @maraoz!

authors: fabioberger maraoz

repo: OpenZeppelin/zeppelin-solidity

license: mit


text:
Change killable to destroyable and kill to destroy

This contract was created in response to issue #161
The basic idea  being to keep naming in line with the recent change of "SUICIDE" to "SELFDESTRUCT" for reasons of sensitivity and morality.
(We value human life more than contracts; etc.)
Changes KillableToken contract to DestroyableToken contract.
Changes Killable contract to Destroyable contract.
All tests are passing.

Destructible or Destroyable? I like how the former sounds.

@federicobond I agree with you

authors: DavidKnott federicobond


text:
Add ganache npm run script, plus documentation on how to use it.

🚀 Description

Added ganache npm run script
Added documentation about how to utilize Ganache

may not be necessary once https://github.com/OpenZeppelin/zeppelin-solidity/pull/800 is merged

Closing due to inactivity, also not sure if we should bundle this, since it's more of a truffle console thing.

authors: ProphetDaniel Shrugs nventuro


text:
fix(app): Show more accurate error messages in pipette swap failures

overview
This PR is serving as a combo PR and ticket to "finish" up Change Pipettes for real. Aligns the error messages of pipette swap with the screens:

Pipette not attached

Incorrect pipette attached

Pipette not detached

changelog

fix(app): Show more accurate error messages in pipette swap failures
fix(app): Change back button to read "Exit" when it will exit

review requests
Easiest to test on a real robot. If testing on virtual smoothie, switch line 143 in app/src/components/ChangePipette/index.js to null to simulate a pipette removal (thanks hot reload).

@IanLondon this PR is not for detecting correct pipettes during calibration. Perhaps you meant to post this on #1263?

Nevermind, I thought app_wrong-pipette-alert #1263 was already merged and that this was a regression -- nope! I'll re-review tomorrow

@pantslakz to save some time on our upcoming call:

button text should be 'CONFIRM PIPETTE IS DETACHED':

Good catch! Fixed

When I tried to exit - robot did not home.

This sounds like you're running outdated robot software. The homing endpoint (as it is now used) was added in 3.0.0-beta.7. In office testing, robot homes its pipettes on all exit flows

rather than disabling the 'back' button - should we just remove it entirely?

Yup! This is some low-hanging polish that we didn't really want to bother UX with just yet given other priorities. Can we come back to it? Backstory: in the components library (where the title bar comes from), we have two TitleBar variants spec'd:

No button, text left aligned
Back button, text right aligned

We were holding off on generating a "no button, text right aligned" variant until we had an updated component + guidance about variant (1) from UX (which, as mentioned above, we have yet to ask for) just because it didn't seem super important. Thus, the quick and dirty way at the moment to achieve right aligned text is to simply add a disabled button.
Both @Kadee80 and I agree that "no back button" makes more sense, but that component library stuff is why title bars with disabled back buttons keep showing up when they don't match the screens / design intent.

Talked with @pantslakz in real life and got 👍 to merge this (with some followup for other parts of the flow)

authors: IanLondon mcous

repo: Opentrons/opentrons


text:
Need shorter video for landing page

Make shorter video for landing page
Why is this feature being added?

Right now our 11 minute video is pretty long. From quick searching 2 minutes is the maximum amount if you expect them to get all the information from it.
just one source
What should your feature do?
Couple of options:

Condense the current landing page video into something < 2 minutes.
Write script, dedicate to film and edit, etc.

Agree, it's way too long.

whomever takes this will you contact me before starting script

Maybe by using this as the video URL would be a quick fix. Not sure where the video should stop though.
https://www.youtube.com/embed/xN7yMoe38xc?rel=0&modestbranding=0&start=78&end=275
@JennWeideman

Here's a link to the video that was on the older OC Rails site. It was a little longer, but the production and content were both top-notch. It's a few years old now and is a bit dated, but if we do a new video, re-using that type of format (interviews from founders / staff / volunteers / success stories) could work.

why is this blocked?

@dmarchante I'm guessing because no one's written the script or created the video? 'Blocked' may be the wrong label - someone just needs to do all the things.

We'd also need somebody to film it. I think the issue is here for posterity, but nobody on GitHub can really accomplish what we need. It's just important to document that it is something that can be improved if the assets are provided.

@wimo7083 I agree. The video is quite large, which may affect the site's loading page. I'd keep it under 2 minutes to avoid creating site loading problems.

I think I have a one-minute version somewhere, let me look...

It doesn't affect load speed because the video doesn't load until after pressing play; however, this is such an easy fix, we should get this done...

@Wimsy113, do you still have that one-minute vid somewhere?

Let me dig through and see, if not I still have access to Final Cut pro and can cut up the full one again.

authors: JennWeideman LauraUX Wimsy113 dmarchante hollomancer jjhampton kylemh sethbergman wimo7083


text:
Reconciller doesn't support systems and domains

Reconciller should be able to reconcile system/ domain information using Kubernetes annotations.
This should be enabled by existing mutations (domainChildAssign and systemChildAssign).
If there is no objections, I'll prepare PR with this change

Hey @MarcinGinszt -  I have no objections if you'd like to try adding this change but I do know that this repo is quite out of date when it comes to opslevel-go's latest version and doing that update is a significant amount of work.  Additionally internally we are looking at doing a full rewrite of the architecture of this tool because we are changing how the app handles integrations like this to build out a more unified data ingestion pipeline.
I have no idea when all of the above would land or come true which is why we have deprioritzed changes to this tool temporarily (because of the architecture rewrite)
If you think you can make something work in the meantime i'm happy to review and test it.

Hey @rocktavious !
Could you maybe give us any timeframe, when could you pick those up?

https://github.com/OpsLevel/kubectl-opslevel/pull/173#issuecomment-1724246072

@MarcinGinszt
We have refactored a chunk of this repo out to a new library (so we can use it elsewhere) but i've added the ability to specify a system in the configuration now see here for an example - https://github.com/OpsLevel/opslevel-jq-parser/blob/main/config.go#L28
I'm preparing the release of this tool today 🎉  so this feature will be in that release.

authors: MarcinGinszt rocktavious

repo: OpsLevel/kubectl-opslevel


text:
Add a cities list page

For now just add this under a hidden route /cities. Start with the existing index.html.bak and work from there. We need to make sure to include a noscript version as well, probably just a static list of the cities we have.

This is still an interesting issue but will take some consideration for how to correctly implement it. Not just because we want to have a lightweight noscript version (that's a secondary concern) but mostly because we don't want to make the default page that people already expect to find Seattle resources on suddenly turn into a landing page of a cities directory.
Deploying sub-paths for each city would be a good approach, like not911.me/st-louis for example. But we should leave the default page as Seattle with a link to "More cities" on the Seattle page to the /cities path.


text:
Nhibernate error messages in Azure SQL and SQL server

Has anyone encountered similar issues? The exception below just started popping up out of nowhere after many years of using Orchard. The site gets locked and no one is able to navigate for periods of time.
Would it help to upgrade Nhibernate to a newer version? Should I also look at upgrading orchard Framework to version 1.10.3?
Moving to Orchard Core is out of question for now due to budget.
Current Orchard Framework Version: 1.10.2
Current Nhibernate version: 4.0.4.4000
Exception NHibernate.Exceptions.GenericADOException: could not execute batch command.[SQL: SQL not available] ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.  Operation cancelled by user.  The statement has been terminated. ---> System.ComponentModel.Win32Exception: The wait operation timed out     --- End of inner exception stack trace ---     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at System.Data.SqlClient.SqlCommandSet.ExecuteNonQuery()     at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps)     --- End of inner exception stack trace ---     at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps)     at NHibernate.AdoNet.AbstractBatcher.ExecuteBatchWithTiming(IDbCommand ps)     at NHibernate.AdoNet.AbstractBatcher.ExecuteBatch()     at NHibernate.Engine.ActionQueue.ExecuteActions()     at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)     at NHibernate.Event.Default.DefaultAutoFlushEventListener.OnAutoFlush(AutoFlushEvent event)     at NHibernate.Impl.SessionImpl.AutoFlushIfRequired(ISet1 querySpaces)     at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)     at NHibernate.Impl.CriteriaImpl.List(IList results)     at NHibernate.Impl.CriteriaImpl.ListT     at Orchard.ContentManagement.DefaultContentQuery.Slice(Int32 skip, Int32 count)     at Orchard.ContentManagement.DefaultContentQuery.ContentQuery1.Orchard.ContentManagement.IContentQuery<T>.List()     at Orchard.Widgets.Services.DefaultLayerEvaluationService.PopulateActiveLayers() in D:\a\1\s\GMS_Portal\Workforce\KLP_Branch_GMS_Portal\src\Modules\Orchard.Widgets\Services\DefaultLayerEvaluationService.cs:line 45     at Orchard.ContentManagement.Utilities.LazyField1.GetValue()     at Orchard.ContentManagement.Utilities.LazyField1.get_Value()     at Orchard.Widgets.Services.DefaultLayerEvaluationService.GetActiveLayerIds() in D:\a\1\s\GMS_Portal\Workforce\KLP_Branch_GMS_Portal\src\Modules\Orchard.Widgets\Services\DefaultLayerEvaluationService.cs:line 38     at Orchard.Widgets.Filters.WidgetFilter.OnResultExecuting(ResultExecutingContext filterContext) in D:\a\1\s\GMS_Portal\Workforce\KLP_Branch_GMS_Portal\src\Modules\Orchard.Widgets\Filters\WidgetFilter.cs:line 52     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList1 filters, ActionResult actionResult)     at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.b__1(IAsyncResult asyncResult) has been thrown in controller Tax.Core.Framework.Controllers.HomeController redirecting user to '~/Login/ApplicationError'

We are using azure sql without an issue. Some things to note:1. Depending on setup sql connections that are idle may timeout (we only use repositories within I singleton using work<> to overcome this - can be configured to use azure sql direct rather than through a gateway - it’s the gateway that times out the session)2. There is a mandatory request timeout at something like 15mins on http requests to the app serviceRegards,Damon GroenveldOn 3 Apr 2024, at 2:54 pm, andrewmadueke @.***> wrote:
Has anyone encountered similar issues? The exception below just started popping up out of nowhere after many years of using Orchard. The site gets locked and no one is able to navigate for periods of time.
Would it help to upgrade Nhibernate to a newer version? Should I also look at upgrading orchard Framework to version 1.10.3?
Moving to Orchard Core is out of question for now due to budget.
Current Orchard Framework Version: 1.10.2
Current Nhibernate version: 4.0.4.4000
Exception NHibernate.Exceptions.GenericADOException: could not execute batch command.[SQL: SQL not available] ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.  Operation cancelled by user.  The statement has been terminated. ---> System.ComponentModel.Win32Exception: The wait operation timed out     --- End of inner exception stack trace ---     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at System.Data.SqlClient.SqlCommandSet.ExecuteNonQuery()     at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps)     --- End of inner exception stack trace ---     at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps)     at NHibernate.AdoNet.AbstractBatcher.ExecuteBatchWithTiming(IDbCommand ps)     at NHibernate.AdoNet.AbstractBatcher.ExecuteBatch()     at NHibernate.Engine.ActionQueue.ExecuteActions()     at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)     at NHibernate.Event.Default.DefaultAutoFlushEventListener.OnAutoFlush(AutoFlushEvent event)     at NHibernate.Impl.SessionImpl.AutoFlushIfRequired(ISet1 querySpaces)     at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)     at NHibernate.Impl.CriteriaImpl.List(IList results)     at NHibernate.Impl.CriteriaImpl.ListT     at Orchard.ContentManagement.DefaultContentQuery.Slice(Int32 skip, Int32 count)     at Orchard.ContentManagement.DefaultContentQuery.ContentQuery1.Orchard.ContentManagement.IContentQuery.List()     at Orchard.Widgets.Services.DefaultLayerEvaluationService.PopulateActiveLayers() in D:\a\1\s\GMS_Portal\Workforce\KLP_Branch_GMS_Portal\src\Modules\Orchard.Widgets\Services\DefaultLayerEvaluationService.cs:line 45     at Orchard.ContentManagement.Utilities.LazyField1.GetValue()     at Orchard.ContentManagement.Utilities.LazyField1.get_Value()     at Orchard.Widgets.Services.DefaultLayerEvaluationService.GetActiveLayerIds() in D:\a\1\s\GMS_Portal\Workforce\KLP_Branch_GMS_Portal\src\Modules\Orchard.Widgets\Services\DefaultLayerEvaluationService.cs:line 38     at Orchard.Widgets.Filters.WidgetFilter.OnResultExecuting(ResultExecutingContext filterContext) in D:\a\1\s\GMS_Portal\Workforce\KLP_Branch_GMS_Portal\src\Modules\Orchard.Widgets\Filters\WidgetFilter.cs:line 52     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList1 filters, ActionResult actionResult)     at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.b__1(IAsyncResult asyncResult) has been thrown in controller Tax.Core.Framework.Controllers.HomeController redirecting user to '~/Login/ApplicationError'
—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

Let me also mention that we're not using the Orchard.sdf. We're reading the orchard settings from databases in a Sql Managed Instance and Sql Server on Prem. Thanks

There was a perf improvement in 1.10.3 for the query that is the issue in your logs, due to a SELECT n+1 problem, which could explain why it's timing out. You could try to apply this fix or move to 1.10.3.
The dev branch (1.11) also added some caching on top of this improvement, which is something you could also try, and would probably help a lot.
Check the DefaultLayerEvaluationService.PopulateActiveLayers in both 1.10.3 tags and dev branch to see these two improvements.

I'll look into this Sebastien. Thanks for the quick reply.

repo: OrchardCMS/Orchard


text:
Added a filter for projections over StringFields that allows returnin…

Added a filter for projections over StringFields that allows returning all items when the provided value is empty.
Add a ContainsAllifProvided filter to get All items if no "filter" is selected
this solve the #8225 issue

I see this is a follow-up to #8213. Actually, I think this should be a completely separate option for all types of data, not just strings: A common checkbox for all FieldTypeEditors that (when checked/enabled) does not run the filter if the provided value is empty, which can be quite common if you use a Token (e.g. filter by a query string parameter). I did something similar in Lombiq.Projections (NullSafeStringFieldTypeEditor), but it only applies to strings and is a separate filter.
To have this generalized could be a nice improvement to this feature, what do you think?

@BenedekFarkas I think what you are proposing makes sense for dev perhaps? I would merge this PR here in 1.10.x

That only works with those two specific cases. What I'm suggesting above is a simple, generic solution that can be applied to any filter (and when applied to a filter, it works regardless of what the rest of its configuration is).
I can take a look, but I'd start with pushing the latest 1.10.x to your PR branch, is that OK?

Closing this as #8781 covers the desired functionality: Use the ContainsAll value for Operator and the new checkbox (IgnoreFilterIfValueIsEmpty).


text:
Consider adding an option to make client identification mandatory

The latest OpenIddict bits allow rejecting token and revocation requests that don't specify a client_id by calling OpenIddictBuilder.RequireClientIdentification(). We should consider adding an option to enable it or even enable it by default.
Related tickets: https://github.com/openiddict/openiddict-core/issues/223#issuecomment-247810094 and https://github.com/openiddict/openiddict-core/issues/175
/cc @jersiovic @sebastienros

Done: https://github.com/OrchardCMS/Orchard2/commit/feda6d4c271c03d6ea7711bf31810a25a94ed2a9.


text:
ava.util.concurrent.ExecutionException: java.lang.NullPointerException

Mod Version:
DynamicSurroundings-1.12-3.4.7.1
Forge Version:
1.12.1 2474
Link to crash log (if applicable):
Client console.
https://gist.github.com/ProsperCraft/9298553c2f35608b5d29fb39077260e4
Full forge log -
https://gist.github.com/ProsperCraft/a56c79e1546e736712b7b89ba6a330c3/raw/66a980a92781849baea19459872dba8aa19a9644/gistfile1.txt
Description:
CME? NPE in client log when connecting to a server with wrong versions of a couple mods.

Pushed build to CurseForge with fixes.

Thank you.

authors: OreCruncher ProsperCraft

repo: OreCruncher/DynamicSurroundings


text:
[1.16.4] Aurora borealis effect instantly shifts to a new position in the sky when moving between y=62/63

Mod Version:
1.16.4-4.0.3.4
Forge Version:
1.16.4-35.1.36
Description:
Aurora borealis effect has a very jarring shift in positions when crossing between y=62 and y=63

Pushed update to CurseForge.

Pushed update to CurseForge.


text:
[1.12.2] Game crash upon respawning near... 3D Furnaces?

Minecraft: 1.12.2
Forge: 14.23.5.2795
Mods: 4
Baubles-1.12-1.5.2
jei_1.12.2-4.14.3.237
OreLib-1.12.2-3.5.1.0BETA
Patchwork-1.12.2-0.2.3.1BETA
Crash Report
https://pastebin.com/PU6DZ6Cb

Sometimes when respawning after dying near the 3D Furnaces... a random crash can occur. Tried with /kill while looking there, looking over there, moving around just to get it to crash.

Can I get your forge logs?

Hmm....would it be possible for you to try with Forge 2772?  Reason I ask is that is what I am using in my dev environment and I cannot repro the issue.  It seems it should be real easy to do that but for some reason I can't get it to break.

Managed to trigger it with a modpack I am working on.  Smells timing related.  Off to test a fix.

Pushed v0.2.3.2 to CurseForge.

authors: OreCruncher Z-Tunic

repo: OreCruncher/Patchwork


text:
Correction d'affichage dans les contrôles d'inventaire

Dans les vue "historique des contrôles d'inventaire" et "nouveau contrôle d'inventaire", le numéro d'inventaire affiché est incomplet (il manque les chiffres après le ".").
Faire en sorte que le numéro d'inventaire complet s'affiche.

Corrigé.

repo: OrifInformatique/stock


text:
Smart Contract Audits

Just leaving a note here for any discussion relevant to the auditing of our smart contracts.
@nick mentioned that the identity contracts are very much in alpha status and may not be ready for auditing.
To-Dos

[ ] add disclaimer comment(s) to the identity contract(s) @franckc

CC @tyleryasaka since he is very involved in everything related to ERC 725

Yeah I'm researching identity heavily right now and have a lot of thoughts and ideas that I'm exploring. Agreed they will likely change a good bit in the near future.

Done ✅

authors: franckc micahalcorn tyleryasaka

repo: OriginProtocol/origin-js


text:
Only return active listings

Description:
Make search return only active listings
Connected PR:
https://github.com/OriginProtocol/origin-box/pull/63

@sparrowDom I've lost track of what it means for a listing to be inactive. This only happens when someone explicitly closes (via withdrawListing), correct? If a listing is sold out, it will still be shown in search results?

Cool, per today's product discussion we will still show 'Sold out' listings
(in the short-term). So this will work for our v1.
On Wed, Sep 19, 2018 at 8:25 PM, Franck notifications@github.com wrote:

@micahalcorn https://github.com/micahalcorn You are correct. This is
only for the case where seller closes her listing. It does not handle the
case where item is sold out.
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/OriginProtocol/origin-js/pull/502#issuecomment-423027920,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AEuxN6Lx9FFMG2iJI6drsaIYvWcEDjGyks5ucwqTgaJpZM4WxAsC
.

--
Cofounder of Origin http://www.originprotocol.com
Join our Telegram http://t.me/originprotocol

This reminds me, listings that are sold out should probably be sorted to the bottom of search results right?

@matthewliu What do you think ? Should items that are sold out still show up on browse page at the bottom or should they be not show up at all ?

@micahalcorn ok, sounds good ! that makes it easy for now.

Yep, no effect for now. Later on we will make them disappear. In early
days, it will be a nice signal to show that items have actually gotten sold
on our marketplace DApp.
No need to re-sort at the moment either.
On Thu, Sep 20, 2018 at 3:31 PM, Franck notifications@github.com wrote:

@micahalcorn https://github.com/micahalcorn ok, sounds good ! that
makes it easy for now.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/OriginProtocol/origin-js/pull/502#issuecomment-423355342,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AEuxN-aDSM91yKhQoKsxsXNTm_iMhr-nks5udBczgaJpZM4WxAsC
.

--
Cofounder of Origin http://www.originprotocol.com
Join our Telegram http://t.me/originprotocol

authors: franckc matthewliu micahalcorn sparrowDom


text:
git sync: sync only the given branch

When working on multiple branches and I see that one branch has conflicts (via the PR on github), I would like to be able to simply run git sync <branchname>. So I don't have to checkout the branch myself.

Closing in favor of git sync --all

repo: Originate/git-town


text:
🛑 Cracked is down

In fc0142b, Cracked (https://cracked.io) was down:

HTTP code: 403
Response time: 67 ms

Resolved: Cracked is back up in 28fb003.

repo: OsintUK/Up-or-Down


text:
🛑 CrackingPro is down

In 207482d, CrackingPro (https://crackingpro.com) was down:

HTTP code: 0
Response time: 0 ms

Resolved: CrackingPro is back up in 00f563a.


text:
🛑 Cracked is down

In 628b815, Cracked (https://cracked.io) was down:

HTTP code: 403
Response time: 135 ms

Resolved: Cracked is back up in d82cf2d.


text:
self position

Ingame, !position should return self-position

Does it not do that currently?

The handler was missing from the handlers list. I fixed that.

authors: RedbackThomson Tillerino

repo: OsuCelebrity/OsuCelebrity


text:
Search Bar, My Items UI Tweaks

Add a search bar, and implement the filtering logic. The current filtering component is easy to extend for other filter mechanisms. We are adding searchString as a state variable keeping track of the current search query, and it will give immediate feedback while typing the query.
Apply the proposed layout from @Appppo which includes cuter icons, hovering and drop down behavior with nice layouts and highlighting.
See samples:
Mobile

Mobile with search query

Desktop

Desktop with search query

Looks good to me. @pyc92 Please take a look.

authors: Appppo eonwarped

repo: OtterClam/otto-app


text:
Famine test data

Here is the Famine watershed data to be tested in RavenPy.

Hi @Bijan55699, for this PR, do you think you could make a new folder (famine) and unzip the contents there ? I'll merge once that's done.

Hi @Zeitsperre , its Mohammad! I can do that. But @huard told me to add the data as a zip file. so I am not sure which one is ok...

The Famine_watershed_dataset repo contains the shapefile (HRU) of the Famine watershed to be tested in RavenPy.
Mohammad

repo: Ouranosinc/raven-testdata


text:
Rename test function

Should be named test_fit ? And in folder tests.
https://github.com/Ouranosinc/xclim/blob/8078cb5ac5d331361f6ff5255e1f88f6750bbb41/xclim/stats.py#L46

Yep, but it's still very much experimental (it works, but needs polishing).

I know, it's just so that we don't forget. Was browsing the code!

Added a note to address this in the future with b3d2debabff51ad5d4844295e28228b85d57e330

authors: Balinus Zeitsperre huard

repo: Ouranosinc/xclim


text:
Handler comap, contramap, imap and lens

This is a draft for transforming handlers in the read and write direction.

comap, like map on Observable, but returns a Handler which can still be used for writing.
contramap, like redirectMap on Observable redirects the written values into the Handler, but still returns a Handler for reading.
imap defines an isomorphism and returns a Handler where reading and writing are transformed.
lens zooms into one part of the data where changes are written back to the original Handler.

See the tests for examples.
We could also think about accepting automatically generated lenses, Iso and other stuff from Monocle.
For imap it could be useful to implement the Invariant type class from cats. For the comap and contramap it is sadly not possible to implement Functor or Covariant, since right now the type has to be the same. Ideas welcome!

I moved the relevant parts over to #91.
https://github.com/OutWatch/outwatch/pull/91/commits/d21fceb84e3335f719e84386c0d9af753921704b

repo: OutWatch/outwatch


text:
It doesn't work

Hello.
Here's the piece of my gulpfile:
gulp.task('default', function () {
	runSequence(
		'css',
		'html'
	);
});

You can see it's pretty simple.
My CSS task assemblies all CSS files into bundle.css, and my HTML task inlines it into HTML. When I make the changes to CSS files and run gulp, the changes are not appear at the end file. To ensure that run-sequence doesn't work, I added one more task that deletes bundle.css before running css task, and I got the ENOENT: no such file or directory, open '...\bundle.css', that pretty much proves that bundle.css hasn't been created. Here's my full gulpfile:
gulpfile.txt

Maybe I'm missing something? Let me know please!

Please read the docs again: your tasks are not correctly set up, so they are returning immediately. You need to configure them to be asynchronous.

omg, sorry

authors: OverZealous uyouthe

repo: OverZealous/run-sequence


text:
Strange avatar behaviour on consecutive message with deep-chat-temporary-message

I am following Suggestion button examples to better onboard my user by giving examples to them.
See this minimum reproducible snippet: https://codesandbox.io/p/sandbox/deep-chat-reat-jmrnyl?file=%2Fsrc%2FApp.js%3A17%2C14

Notice the avatar is visible only in last consecutive message, i.e. the one with suggestion buttons
Click on either of the suggestion
The suggestion buttons message is gone because it is set as temporary
Notice the first How can I help you today? message stay without any avatar

Is it right for me to expect the How can I help you today? message should have an avatar after the temporary message below it is gone?

Hi @michaelleungbowtie.
That is a conundrum 😕 I'll try to investigate and see if I can find a way to place the avatar in the previous message. Thankyou for letting me know about this.

Hi @michaelleungbowtie.
I have made the fix for this bug and it is now available in deep-chat-dev and deep-chat-react-dev version 9.0.190.
I will push this change in the next release. Let me know if you face any issues with it.
Thanks!

authors: OvidijusParsiunas michaelleungbowtie

repo: OvidijusParsiunas/deep-chat


text:
🛑 OwlTing Experiences is down

In ecdfe08, OwlTing Experiences (https://experiences.owlting.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: OwlTing Experiences is back up in affa578 after 18 minutes.

repo: OwlTing/upptime


text:
Get Event details

I can work out how to navigate getting data from the XML but can't see how to to get the details from an event i.e. the description you can see in event viewer.  Is this possible?

The textual representation (for example, the "general" tab) for a given EventID is not available through this atm. I've been poking around trying to figure out exactly where that comes from, and so far the best I can tell is that it actually involves loading up a DLL for each source provider and calling a format function from it. If that's the case, that seems very dirty.

Yup that seems excessive, thanks for the quick reply.

Np

repo: Owlz/winevt


text:
Feature/intolerance

Create intolerance and category tables and routes

Merge to dev, not main, please

authors: claudiaglez maicaocaa


text:
Pad turns undefined

Collaborative text goes crazy with a bunch of undefined

Couldn't be reproduced

authors: atd pablojan


text:
download package 报错

流程执行到make defconfig的时候报一下错误：
Run cd openwrt
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..HEAD
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..cbba577f6dcbffcd5a2933baad48459ec3f5681b
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..HEAD
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..cbba577f6dcbffcd5a2933baad48459ec3f5681b

configuration written to .config

fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..HEAD
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..cbba577f6dcbffcd5a2933baad48459ec3f5681b
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..HEAD
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..cbba577f6dcbffcd5a2933baad48459ec3f5681b
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..HEAD
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..cbba577f6dcbffcd5a2933baad48459ec3f5681b
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..HEAD
fatal: Invalid revision range 97a4ffcc125611dd5f307d54570373832a73e62d..cbba577f6dcbffcd5a2933baad48459ec3f5681b
time: target/linux/prereq#0.08#0.02#0.10
请问这个会影响最终编译结果么？

同样的问题，请问你解决了吗？

同样的问题，请问你解决了吗？

没问题，忽略就好


text:
fix: Metal backend

This PR allows users to use the Metal (MacOS) and cuBLAS backend by:

[x] Exposing the n_gpu_layers parameter in the CLI
[ ]  Using the Metal backend in the forward pass

After it creates the tokens and runs ggml_metal_init, I get this:
ggml_metal_init: GPU name:   Apple M1 Pro
ggml_metal_init: GPU family: MTLGPUFamilyApple7 (1007)
ggml_metal_init: hasUnifiedMemory              = true
ggml_metal_init: recommendedMaxWorkingSetSize  = 21845.34 MB
ggml_metal_init: maxTransferRate               = built-in GPU
ggml_metal_add_buffer: allocated 'backend         ' buffer, size =    54.36 MB, (   54.98 / 21845.34)
encodec_load_model_weights: model size =    44.36 MB
encodec_load_model: n_q = 32
ggml_metal_add_buffer: allocated 'backend         ' buffer, size =   314.06 MB, (  369.05 / 21845.34)
encodec_eval: compute buffer size: 314.05 MB

ggml_metal_graph_compute_block_invoke: error: node   0, op =   REPEAT not implemented
GGML_ASSERT: /Users/siraben/Git/bark.cpp/encodec.cpp/ggml/src/ggml-metal.m:1428: false
ggml_metal_graph_compute_block_invoke: error: node 4677, op = MAP_CUSTOM2_F32 not implemented
[1]    9701 abort      ./examples/main/main -ngl 100 -t 8 -m ./ggml_weights/ggml_weights.bin -em  -p

Hello @siraben !
Indeed, it seems that some operations (e.g., repeat, which is used to broadcast computations) do not have a corresponding Metal kernel implemented in ggml. I'll open a PR to implement them.

When I try to run cmake -DGGML_CUBLAS=ON .. I get:
CMake Warning at encodec.cpp/ggml/src/CMakeLists.txt:219 (message):
  cuBLAS not found

When I try to run cmake -DGGML_CUBLAS=ON .. I get:
CMake Warning at encodec.cpp/ggml/src/CMakeLists.txt:219 (message):
  cuBLAS not found

I also tried CMAKE_ARGS='-DLLAMA_CUBLAS=on' cmake .. and added all the changes proposed in this pull, but to no success.

authors: PABannier normatovjj siraben


text:
FTP Site Enhancements

Support additional files and data types listed below:

[x] Genome metadata
[x] Reference genomes
[x] Protein-protein interaction data
[ ] Transcriptomics data

@rkenyon would you close if this no longer valid?

@mshukla1 please check this whether we can close this.

authors: hyoo rkenyon


text:
Deadlocks during nightly purge

Hello,
We are getting many deadlocks occurring in the DynamicsPerf database every night from the SQL job DYNPERF_PROCESS_TASKS_LOW_PRIORITY which appears to happen just after midnight when it is doing purging of data after upgrading to version 2.20.
When you install DynamicsPerf it installed two jobs DYNPERF_PROCESS_TASKS & DYNPERF_PROCESS_TASKS_LOW_PRIORITY.  My first question is do both of these need to be running?
I thought maybe both of these jobs running every five minutes may have been the cause of the blocking (causing collisions) and even tried to change the schedule leaving a gap at midnight where only one job is running and the other one isn't.  This only delayed the time of the deadlocks and they didn't go away.
I've reinstalled DynamicsPerf from scratch thinking this would clean up the deadlocks due to stale data in the tables (as we've upgraded it and been running it for years) but after a couple days the deadlocks started happening again.
Any idea what can be done to eliminate the deadlocks from occurring and filling up my inbox?
I've attached the deadlock xml below.
Deadlock.xml.log
The CTE below may be the root cause but I'm not too sure.
WITH CTE_HIST (SERVER_NAME, DATABASE_NAME, QUERY_HASH, QUERY_PLAN_HASH, MAX_DATE)
AS (SELECT SERVER_NAME,
DATABASE_NAME,
QUERY_HASH,
QUERY_PLAN_HASH,
MAX(DATE)
FROM   QUERY_HISTORY WITH (NOLOCK)
GROUP  BY SERVER_NAME,
DATABASE_NAME,
QUERY_HASH,
QUERY_PLAN_HASH)
DELETE QS
FROM   QUERY_HISTORY QS WITH (ROWLOCK, READPAST)
INNER JOIN DATABASES_2_COLLECT DC
ON QS.SERVER_NAME = DC.LINKED_SERVER
AND QS.DATABASE_NAME = DC.DATABASE_NAME
INNER JOIN CTE_HIST CTE
ON CTE.SERVER_NAME = QS.SERVER_NAME
AND CTE.DATABASE_NAME = QS.DATABASE_NAME
AND CTE.QUERY_HASH = QS.QUERY_HASH
AND CTE.QUERY_PLAN_HASH = QS.QUERY_PLAN_HASH
WHERE  QS.SERVER_NAME = @SERVER_NAME
AND CTE.MAX_DATE < DATEADD(DAY, DC.PURGE_STALE_QUERIES_DAYS * -1, GETDATE())

Changing the CTE to a temp table appears to have solved the blocking.  The DYNPERF_PURGE_DATA execution time went from running 142 down to 13 seconds without adding any indexes to the temp table.

Nice Work!! Btw how is your performance going there?
On Fri, Jul 10, 2020 at 4:47 PM Jason-Giga notifications@github.com wrote:

Changing the CTE to a temp table appears to have solved the blocking. The
DYNPERF_PURGE_DATA execution time went from running 142 down to 13 seconds
without adding any indexes to the temp table.
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/PFEDynamics/DynamicsPerf/issues/18#issuecomment-656714826,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/ABNOLJFL7XVYBISVQLGXVLLR24SZVANCNFSM4NNHG4UQ
.

--
Groeten
Alexander

Issue is resolved

Nice Work!! Btw how is your performance going there?
…
On Fri, Jul 10, 2020 at 4:47 PM Jason-Giga @.***> wrote: Changing the CTE to a temp table appears to have solved the blocking. The DYNPERF_PURGE_DATA execution time went from running 142 down to 13 seconds without adding any indexes to the temp table. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#18 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABNOLJFL7XVYBISVQLGXVLLR24SZVANCNFSM4NNHG4UQ .
-- Groeten Alexander

Hi Alexander, we've been running Ax 2009 for 10 years now and typically do a yearly performance review with MS to keep on top of performance issues.  At this point we pretty comfortable with how our system is running.  Thanks!

authors: Alexander-Weurding Jason-Giga

repo: PFEDynamics/DynamicsPerf

license: MS-PL