Have you checked index fragmentation?
Try launching this query that gives you fragmentation percentage per table.
SELECT S.name as 'Schema',
T.name as 'Table',
I.name as 'Index',
DDIPS.avg_fragmentation_in_percent,
DDIPS.page_count
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS
DDIPS
INNER JOIN sys.tables T on T.object_id = DDIPS.object_id
INNER JOIN sys.schemas S on T.schema_id = S.schema_id
INNER JOIN sys.indexes I ON I.object_id = DDIPS.object_id
AND DDIPS.index_id = I.index_id
WHERE DDIPS.database_id = DB_ID()
and I.name is not null
AND DDIPS.avg_fragmentation_in_percent > 0
ORDER BY DDIPS.avg_fragmentation_in_percent desc
Then try to rebuild your indexes instead of reorganizing.
a helpful Plugin is the API-Logging Plugin for Shopware 6.
It allows all API request to the /api and /store-api endpoints to be reliably logged, making troubleshooting and monitoring much easier.
Here is the Link
It turns out I needed to copy over the cookies from the original request since Blazor Server does not automatically know about them so just creating an empty CookieContainer doesn't work the same as it does in WASM.
builder.Services.AddScoped(sp =>
new GraphQLHttpClient(config =>
{
var baseUri = new Uri(sp.GetRequiredService<NavigationManager>().BaseUri);
var cookie = sp.GetRequiredService<IHttpContextAccessor>().HttpContext?.Request.Cookies[".AspNetCore.Cookies"];
var container = new CookieContainer();
container.Add(new Cookie(".AspNetCore.Cookies", cookie, "/", baseUri.Host));
config.EndPoint = new Uri($"{baseUri}graphql");
config.HttpMessageHandler = new HttpClientHandler
{
CookieContainer = container,
UseCookies = true
};
}, new SystemTextJsonSerializer()));
I had a similar requirement for my function. Here you can read how I solved the problem. You can extend dynamic parameters depending on the values of the parameters. Take a look: https://stackoverflow.com/a/79227324/4879264
I just copied the x86 powershell lnk from %appdata%\Microsoft\Windows\Start Menu\Programs\Windows PowerShell and replaced the path to the executable back to %SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe, as none of the options in this thread seemed intuitive to me. For PowerShell 5.1 that is – some of the solutions here seem to be targeting PS7.
As mentioned in the question, I submitted a bug to docker about this, and the docker team got on it quite quickly. Unfortunately, the outcome is that it's not actually a bug in docker, rather the docs were wrong about what algorithms are supported. Only sha256 is supported, the reason was explained in this older comment.
The gist being that the checksum option doesn't just run a full checksum on the downloaded artefact, it's integrated with docker's own layer hashing system, which (I assume) only uses sha256.
A change to the docs has been submitted already (though as of this writing it's not live)
I'm probably massively oversimplifying or misrepresenting some details here, but that's a Good Enough™ explanation for me. If you need to know more than a very surface answer to the question "why can't I use other checksum algorithms in ADD in a Dockerfile", please don't rely on this answer and look into it more deeply.
If you need to perform a checksum on a build artifact with a different algorithm than sha256, you can't do it with ADD --checksum. To do that, see @DazWilkin's answer
Pre-generate a Fixed Question Set
You can generate a fixed set of questions once and save them in a neutral format. This ensures the same set of questions can be reused for both exams2webquiz and exams2openolat.
Steps:
Use exams2xyz to generate a consistent question set using the seed in one format (e.g., exams2webquiz).
Save the generated question set as a static file, such as JSON, XML, or RDS (R data file), for re-use.
Read the static file when creating outputs for both formats.
import pandas as pd
# Create the DataFrame
data = {
'A': ['First', 'Second'],
'B': ['row to delete', 'row to delete'],
'C': ['row to shift', 'row to shift']
}
df = pd.DataFrame(data)
print(df)
# Shift only the 'B' and 'C' columns
df[['B', 'C']] = df[['B', 'C']].shift(-1, axis=1, fill_value='')
print(df)
It seems like you may have some issues with route matching when running the tests in the suite. Can you share details about your authentication setup (e.g., Passport, Sanctum) ?
BTW, for failed authentication, you should be getting a 401 Unauthorized response, not a 404 or 200. You can use dd($response) to check what is return on posted JSON.
So I was having the same problem in OAuth consent screen. None of the solutions worked for me. I finally figured out that I have too many projects in my GCP. I deleted a few old projects and brought down the total project numbers to 6 and the consent screen worked.
You simply take the buffers and concatenate them along with a wav header in arraybuffer format, then convert the result to base64 and play it with expo-av :
@Eric 's solution might have helped few people to make the build pass. But, you would be wondering how can just adding -v to the build makes it pass. That's a good indication that you are having timing issues in authentication handshake. -v prints verbose output of error logs which takes slightly more time than usual and it helps the build pass.
inreplace failed
/usr/local/Cellar/curl/8.11.0_1/lib/pkgconfig/libcurl.pc:
expected replacement of /^(Requires.private: )ldap,(.*),mit-krb5-gssapi,/ with "\1\2,"
As of Rails 7.1.0.beta1, Rails.cache.redis always returns a Connection Pool (https://github.com/mperham/connection_pool), so the access to the Redis client and consequently to the keys are now different:
Rails.cache.redis.with do |redis_client|
redis_client.keys
end
The code doesnt work for me it gives an error message Failed to save logic app TestingRecurence. The recurrence schedule of trigger 'Recurrence' could not have 'WeekDays' for recurrence frequency 'Month'. Is there a workaround for this?
If you want an easy setup this transformation could be done with excel using pivot table, you can either export your table from power bi visual or save your table as an excel file. after performing pivot table you can re import it again in your power BI data model
I've had a similar problem, but was unable to use the workaround because the script file runs as soon as you open the spreadsheet because of the definition of the onOpen() function. Next time, I will try and open the script file without opening the spreadsheet to see if this resolves the issue for me as well.
According to the docs, one has to create a page [...page].vue in the pages folder. This route will match all routes and will display this page when no other routes are matching.
My mistake, it is indeed included in the documentation as Evgenij Ryazanov pointed out in the comments. I was able to fix the problem by starting the h2 in mode LEGACY, other modes will work as well. Information about different compatibility modes can be found here
The problem was on the provider's side. The provider said that somehow my IP address became non-white and changed it to white and the problem disappeared.
That happens because the compiler is confused about the actual value of this string. To "fix" this, you need to force its interpretation. Try the code below:
Go to Command Palette [short key Ctrl+Shift+P], type "Python: Select Interpreter," and provide a path to your venv. If it does not work you can also try to activate the venv manually by typing .\venv\Scripts\activate in your integrated terminal.
To simplify JSON parsing, it’s best to ensure that every value is associated with a key. You can restructure the JSON to include the “Street Address” value within a key-value pair.
What do you mean "Stripe support hasn’t been able to provide a solution" exactly? What did they say?
It's very hard to tell what is the problem with your specific account in a public forum. Please reach out to Stripe Support again, they should be able to help.
I am using pandas to read an excel file in the same folder as my python file. When running my file from cmd prompt, everything works great. When I ran the file from VS Code it would always say FileNotFound.
The Fix: In VS Code, use the file explorer and ensure you are in the folder containing your file and NOT a step or two higher in the file hierarchy. I had a "Python Projects" folder open and the files for this specific project were in a subfolder...when I navigated to just the subfolder specific to my project in VS code using "open folder", it fixed the issue.
@Rustam Gasanov's answer is the correct answer, but the latest version has changed the settings file path, Since I can't continue writing the latest config file path below the comment (not enough reputation points), I will write a new comment to supplement that answer.
This is usually because the value for the Virtual Disk Limit has been exhausted.
Just change the value in the config file and restart it:
du -sh ~/Library/Containers/com.docker.docker // Check how much does docker data currently occupy
I faced the same error, and the problem turned out to be the terminal's current directory. It wasn’t pointing to my React app’s folder. After navigating to the correct directory where my React app was located, running npm start worked perfectly. Let me know if this helps someone :)
dont worry about the site key even if somoene tries to abuse it he won't be able because its tied to ur domain , the thing that u should worry about is the private key thats where the verification of the token start if somoene got it he can simply send milions of verification to ur google api and then it would cost u
The issue arises because @GeneratedValue cannot be used with composite keys defined using @IdClass. To resolve this, remove @GeneratedValue and manage the id field manually. For Oracle, implement a service to fetch the next sequence value using a native query (SELECT <sequence_name>.NEXTVAL FROM DUAL). Before persisting the entity, set the id field using this service. For MariaDB, the database will handle the auto-increment behavior automatically.
I also checked, there is no wxDataViewListCtrl in wxSmith palette. Another option would to use wxListCtrl to implement similar functionalities like wxDataViewListCtrl. You can also use Standard>Custom to create your own class. Here is the tutorial for wxPanel using a "Custom" item https://wiki.codeblocks.org/index.php/WxSmith_tutorial:_Using_wxPanel_resources
I had the very same issue, and updating the service account didn't work for me.
Fortunately, although the project was old, there was yet no data in the Firebase Storage bucket. I added a new bucket of the same name and the issue disappeared.
I assume that the issue is very specific to projects that were created when Firebase Storage wasn't that mature.
I feel like you have a good general idea of the main messaging services that AWS provides, but I think a couple details are missing:
SQS
For this use case it might be a good option to consider an SQS FIFO queue which means the messages will be handled in order.
Otherwise one bid might reach the backend before another, even though it was published at a later timestamp.
Furthermore, make sure that the visibility timeout is larger than the time you require to process the message. Otherwise you could accidentally pull the same SQS message twice. This is a general best practice though, so nothing particular with your use case.
Kinesis
Kinesis will not force each consumer to read all messages.
With kinesis you have a dynamodb lease table where each consumer registers which shards it will be pulling information from.
In this setup with 2 instances it could be a good idea to have 2 shards (or more if needed) and each instance will only pull from the shards it has resisted in the lease table.
Furthermore, it would probably be a good idea to use the bidding item id as a hash key for the kinesis messages, assuring that each bid for a certain item always goes to the same shard, since kinesis only promises ordering on a shard level.
Backend Application
Depending on how your application runs it might still be a good idea to have some sort of locking in place in the application itself.
If you are sure it will only ever pull and process one message at a time though, I guess this might be overly cautious.
As to the "I also assume that every service instance maintains an in-memory mapping..." part:
I'm not quite sure if you're talking about the "leasing" part or the data storage of the bids. For both cases though I would ask why you think it should be in memory?
A centralised location both for the "leasing" and storage of the bids seems more appropriate, since it's then decoupled from the instances.
With kinesis there is the dynamodb lease table, and with Kafka I guesss it's something different, but still something central that all instances communicate with. Otherwise there would be no way of detection collisions where multiple consumers try and process the same shards etc.
As for the storage of the bids themselves, that should also generally be in a separate storage (e.g. RDS / DynamoDB) since otherwise they would of course disappear if you had an issue with your application or performed a deployment etc.
I found a clever solution to this. In the DI container, we usually register our dependencies during app initialization. However, it is fine to register a dependency in context. Here's a snippet of how I did it.
export function mountPrismaDatabase(app: OpenAPIHono<OpenAPIHonoConfig>) {
app.use(async (c, next) => {
// order is important here.
// we initialize our prisma client connection first
// and bind it to the context
const adapter = new PrismaD1(c.env.DB);
const client = new PrismaClient({ adapter });
c.set('prisma', client);
await next();
});
app.use(async (c, next) => {
// we then register that context to our di container
registerContextModule(applicationContainer, c);
await next();
});
}
I can then consume this dependency in my infrastructure.
If you need more details, you may check this basic todo repo that I am currently using to practice clean architecture in my profile. I am linking the exact commit hash so that this link won't be broken when I move files around.
I encountered, and I am still looking for a solution, the same problem. One thing I have learned thus far is to make sure that the private key is OPEN SSH.
pleas i need it , it is not that hard just give me and answer to my teacher question "how to add link to your xamarin project(text that, when clicked, takes you to the page)
If you're interested, you can try our self-developed Libro Notebook. It supports direct connections to SQLite databases without requiring magic commands, allowing you to perform database operations more efficiently and intuitively. It's especially suitable for database development and analysis scenarios. For more details, you can check out this article.
FROM webdevops/php-nginx:8.3-alpine
# Installation dans votre Image du minimum pour que Docker fonctionne
RUN apk add oniguruma-dev libxml2-dev
RUN docker-php-ext-install \
bcmath \
ctype \
fileinfo \
mbstring \
pdo_mysql \
xml
# Installation dans votre image de Composer
COPY --from=composer:latest /usr/bin/composer /usr/bin/composer
# Installation dans votre image de NodeJS
RUN apk add nodejs npm
ENV WEB_DOCUMENT_ROOT /app/public
ENV APP_ENV production
WORKDIR /app
COPY . .
# On copie le fichier .env.example pour le renommer en .env
# Vous pouvez modifier le .env.example pour indiquer la configuration de votre site pour la production
RUN cp -n .env.example .env
# Installation et configuration de votre site pour la production
# https://laravel.com/docs/10.x/deployment#optimizing-configuration-loading
RUN composer install --no-interaction --optimize-autoloader --no-dev
# Generate security key
RUN php artisan key:generate
# Optimizing Configuration loading
RUN php artisan config:cache
# Optimizing Route loading
RUN php artisan route:cache
# Optimizing View loading
RUN php artisan view:cache
# Compilation des assets de Breeze (ou de votre site)
RUN npm install
RUN npm run build
RUN chown -R application:application .
CMD ["sh", "-c", "run_migration_and_seed.sh"]
Adding this to my dockerfile taht only containe a php artisan migrate to test
but it's not launch
