DatePicker Component - Disable Function doesn't work completely

Package name(s)
Lab (@salt-ds/lab)
Package version(s)
@salt-ds/lab": "1.0.0-alpha.48"
Description
disabled prop with DatePicker isn't completely working properly --> it's disabled when clicking on the calendar icon but still allows an input via the textbox
Steps to reproduce
    <DatePicker
      style={{ width: "200px" }}
      disabled={true}
      onSelectionChange={(event, selectedDate) => {
        if (event.type !== "click") {return;}
        setSchedule(new Date(selectedDate as string));
      }}
      inputProps={{ "aria-label": "schedulePicker" }}
    />

Expected behavior
When testing I expected the DatePicker component to be disabled - but it still allowed input so my test failed
Operating system

[ ] macOS
[X] Windows
[ ] Linux
[ ] iOS
[ ] Android

Browser

[X] Chrome
[ ] Safari
[ ] Firefox
[ ] Edge

Are you a JPMorgan Chase & Co. employee?

[X] I am an employee of JPMorgan Chase & Co.

Hello @vickybonk I do realise your frustration with the textbox, I will share a work around  you can use below.
You could disable the textbox by adding an additional  props readOnly={true}.  In addition to this, you can use the emptyReadOnlyMarker props to then set a placeholder.
<DatePicker
  style={{ width: "200px" }}
  disabled={true}
  readOnly={true}
  emptyReadOnlyMarker={'1-2-2024'}
  onSelectionChange={(event, selectedDate) => {
    if (event.type !== "click") {return;}
    setSchedule(new Date(selectedDate as string));
  }}
  inputProps={{ "aria-label": "schedulePicker" }}
/>

thank you!


doom/core: avoid the litter of session.* files

When x-window commands emacs to quit, emacs saves a session in .emacs.d/session.* by default. There is no easy way to change the location of this session file. This PR overwrites the function responsible for creating the session file name emacs-session-filename. The new function sets the session file to reside in doom-cache-dir/sessions.

Nice work. Thanks again for your help!


Citation doesn't do anything when clicked on the Main Chain Plutus Script page

It could just be my browser but when I click the 1 at the end of the sentence, "claimTransactionHash of the transaction is NOT included in the distributed set" on the Main Chain Plutus Script page of the Cardano docs it doesn't do anything. Just a small bug but thought I'd let whoever controls this repo know. This is the page: https://docs.cardano.org/cardano-sidechains/sidechain-toolkit/mainchain-plutus-scripts#fn-1 .

As far as I can see the citation is not lined to anything.
I have deleted the citation. The correction is bundled with changes for ETCM-3500.

Thank you.


End to end integration

What it does:

User input query
Retrever paragraphs from ask-xDD retriever
Known enitty identification based on MacroStrat dictionary
Generate dynamic prompt for relationship triplets extraction
Merge all triplets in all paragraph into a GraphOutput Object
Convert to TTL format with provanace (not ready)

Somewhat finished merging.
@ilmcconnell can you take a look at the TTL output and see it if is correct or not?
http://cosmos0002.chtc.wisc.edu:8510/

@JasonLo
querying that endpoint with 'iron mines' returns a correctly formatted .ttl result
if I query with "Waldron Shale Indiana Stratigraphy" I get this error:
AttributeError: 'NoneType' object has no attribute 'additional_values'
Traceback:

File "/usr/local/lib/python3.11/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 535, in _run_script
    exec(code, module.__dict__)
File "/app/main.py", line 34, in <module>
    outputs = asyncio.run(outputs)
              ^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/asyncio/runners.py", line 190, in run
    return runner.run(main)
           ^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/asyncio/runners.py", line 118, in run
    return self._loop.run_until_complete(task)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/asyncio/base_events.py", line 654, in run_until_complete
    return future.result()
           ^^^^^^^^^^^^^^^
File "/app/text2graph/llm.py", line 273, in llm_graph_from_search
    graph = await ask_llm(
            ^^^^^^^^^^^^^^
File "/app/text2graph/llm.py", line 256, in ask_llm
    return await post_process(
           ^^^^^^^^^^^^^^^^^^^
File "/app/text2graph/llm.py", line 195, in post_process
    triplet.object.provenance.additional_values[
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


Zendesk Sell API support ? ( Create Lead )

Should Zendesk Sell API be included in this client library ? Currently trying to implement Core Sell API to Create Lead but can't find it in this library

Unfortunately the package only supports the core Zendesk APIs here - https://developer.zendesk.com/rest_api/docs/zendesk-apis/resources
Feel free to add the sell APIs and send us a PR


FTP Upload TLS/SSL Error

I am getting an error when trying to upload using a file using a FTP handler. Here is the function that I am calling:
func sendDataToServer(_ file: URL){
        let credentials = URLCredential(user: "sample", password: "sample", persistence: .forSession)

        let host = URL(string: "ftp://ftp.site.com")!
        let ftpProvider = FTPFileProvider(baseURL: host, passive: false, credential: credentials)!

        ftpProvider.copyItem(localFile: file, to: "/directory/test.csv", overwrite: true, completionHandler: { (error) in
            print(error?.localizedDescription ?? "no error")
        })
    }

Once this is executed I get the following error:
Invalid sequence of commands (AUTH SSL/TLS required prior to authentication).
Could you advise on what the next steps would be for this?
Thanks in advance!

Change this line to have ftps, or set port to 990:
let host = URL(string: “ftps://ftp.site.com”) // Implicitly on port 990
// OR
let host = URL(string: “ftp://ftp.site.com:990”)
// OR
let host = URL(string: “ftpes://ftp.site.com”) // Explicit mode

Greatly appreciated! I have changed it to:
let host = URL(string: "ftpes://ftp.site.com") // Explicit mode

This has made an output change to a different error:
331 Password required for *redacted*

I have confirmed this password is valid.

Updated code:
Swift 4
Xcode 9.2
func sendDataToServer(_ file: URL){
    let credentials = URLCredential(user: "sample", password: "sample", persistence: .forSession)
    let host = URL(string: "ftpes://ftp.site.com")!
    let ftpProvider = FTPFileProvider(baseURL: host, passive: true, credential: credentials)!
    let desc = "Uploading file in \(ftpProvider.type)"

    let progress = ftpProvider.copyItem(localFile: file, to: "/directory/test.csv"){ (error) in
        print("\(desc) failed: \(error?.localizedDescription ?? "no error desc")")
    }

    print(progress?.fractionCompleted ?? 0)
}

Here is the new output in full:
0.0
0.0
Uploading file in FTP failed: 331 Password required for *redacted*.
Uploading file in FTP failed: 331 Password required for *redacted*.

If you know swift well, please put a breakpoint on this line and check the code behavior.

That is where we may have a problem, I don't know too much about Swift. I can place a breakpoint though. Here is what I have from the stack trace:

Same output in the Debug area. Does this help any?

I meant to do trace. Can I have a demo account a server similiar to yours in order to test?

Furthermore please check https://github.com/amosavian/FileProvider/blob/master/Docs/Sample-iOS.swift to see correct sample code.

Thanks for the support. I have added you to a private repository with the modified code to test an upload to this server. Please let me know if you can see any reason why it won't push the file up.

I shall check when I got free. Thanks

I've used my test cases instead of your app. All bugs has been fixed and I will push a commit soon. The only thing is you must use .extendedPassive mode for your server instead of .passive mode.
let provider = FTPFileProvider(baseURL: url, mode: .extendedPassive, credential: cred)!

Other issues will be fixed after I push new commit.

Excellent support sir.

@webmasterjunkie Please check latest commit.

Confirmed. Thanks.

It still has problems with deleting folder recursively and reading file contents, though I think you don't need them at least now.

Hi, I have the follow error: The operation couldn’t be completed. (NSURLErrorDomain error -1101.)
This is my code:
`@IBAction func upload(_ sender: Any) {
print("Inicio carga de archivo")
    let localURL = FileManager.default.urls(for: .documentDirectory, in: .userDomainMask).first!.appendingPathComponent("ic_user_profile.jpg")
    let remotePath = "/ic_user_profile11111.jpg"

    let credential = URLCredential(user: self.username, password: self.password, persistence: .forSession)

    let ftpProvider = FTPFileProvider(baseURL: self.server, mode: .extendedPassive, credential: credential)!

    let progress = ftpProvider.copyItem(localFile: localURL, to: remotePath ){ (error) in
        print("Failed: \(error?.localizedDescription ?? "Error")")
    }

}`

@jbetancourtlopez The error is kCFURLErrorFileIsDirectory which means you are trying to upload a non-regular (directory or pipe) instead a file. Or the file does not exist?


An OR list in the --mappings option

The "OR list" have many applications, see one example here or this analytic query...
Suggestion: use comma-separated list as P1709,P2888 to recognize an "OR list".
Example:

wdtaxonomy -m P1709 Q33999 |grep schema.org is the default command, but returns empty.

wdtaxonomy -m P1709,P2888 Q33999 |grep schema.org as  default command is better, will return something.

Done in the master branch. How about some predefined list of common mapping properties or getting the list as sub-properties of Q30249126? Maybe this way:
wdtaxonomy -m all Q33999

Implemented in 0.5.0, including shortcut keywords. The output, however does not distinguish mapping types yet (#26).


snyk notifications

✗ High severity vulnerability found on<EMAIL_ADDRESS>
desc: Cross-site Scripting (XSS) via Data URIs
info: https://snyk.io/vuln/npm:marked:20170112
from<EMAIL_ADDRESS>><EMAIL_ADDRESS>Fix: None available. Consider removing this dependency.

✗ High severity vulnerability found on<EMAIL_ADDRESS>
desc: Cross-site Scripting (XSS) via Data URIs
info: https://snyk.io/vuln/npm:marked:20170112
from<EMAIL_ADDRESS>><EMAIL_ADDRESS>><EMAIL_ADDRESS>Fix: None available. Consider removing this dependency.

✗ High severity vulnerability found on<EMAIL_ADDRESS>
desc: Cross-site Scripting (XSS) via Data URIs
info: https://snyk.io/vuln/npm:marked:20170112
from<EMAIL_ADDRESS>><EMAIL_ADDRESS>><EMAIL_ADDRESS>><EMAIL_ADDRESS>Fix: None available. Consider removing this dependency.

https://github.com/chjj/marked/commit/cd2f6f5b7091154c5526e79b5f3bfb4d15995a51

I am keeping this one open until the change is pushed, but I wanted to rename the ticket to make it more search friendly.

This seems important enough to cut a new release for. Any reason that isn't being done?

@chjj @matt- @paulirish Any word on getting a tag for this fix?

0.3.7 finally came out, and did include the previous submitted fixes.  Unfortunately, there's still one high-severity vulnerability that is supposed to be addressed by the upcoming 0.3.9 release.

Believe 0.3.9 corrects all these issues. Please confirm and comment, if incorrect.


GH-3948 Serializable CoreDatatype.NONE

GitHub issue resolved: #3948
Briefly describe the changes proposed in this PR:

SimpleLiteral could not be serialized when the CoreDatatype was NONE, fix is to make CoreDatatype.NONE an enum

PR Author Checklist (see the contributor guidelines for more details):

[ ] my pull request is self-contained
[ ] I've added tests for the changes I made
[ ] I've applied code formatting (you can use mvn process-resources to format from the command line)
[ ] I've squashed my commits where necessary
[ ] every commit message starts with the issue number (GH-xxxx) followed by a meaningful description of the change

@nguyenm100 does this fix work for you?

@hmottestad Hi, it doesn't appear like that solves my problem
java.io.NotSerializableException: org.eclipse.rdf4j.model.base.CoreDatatype$$Lambda$52/0x0000000800c1cc70
at java.base/java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1197)
at java.base/java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1582)
at java.base/java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1539)
at java.base/java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1448)
at java.base/java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1191)
at java.base/java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:354)

While trying to serialize a Value via something like (vf is a ValueFactory):
		ByteArrayOutputStream expectedOut = new ByteArrayOutputStream();
	try (ObjectOutputStream oos = new ObjectOutputStream(...)) {
		oos.writeObject(vf.createLiteral("xyz", vf.createIRI(RDF.NAMESPACE)), vf.createLiteral("foo"));
	}

@nguyenm100 I'm not able to reproduce this. Here is my code:
import org.eclipse.rdf4j.model.impl.SimpleValueFactory;
import org.eclipse.rdf4j.model.vocabulary.RDF;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.ObjectOutputStream;

public class Temp {

	public static void main(String[] args) throws IOException {
		SimpleValueFactory vf = SimpleValueFactory.getInstance();
		ByteArrayOutputStream expectedOut = new ByteArrayOutputStream();
		try (ObjectOutputStream oos = new ObjectOutputStream(expectedOut)) {
			oos.writeObject(vf.createLiteral("xyz", vf.createIRI(RDF.NAMESPACE)));
			oos.writeObject(vf.createLiteral("foo"));
		}
	}

}

very bizarre but your code fails for me when I insert it into my unit-test against both Java 17 and Java 11.  But just by inspection, shouldn't coreDatatype extend for Serializable (or marked transient) for it to work?

@hmottestad (see above)

Enums are already serializable.
https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Enum.html
Can you make a branch/PR with a test that reproduces your issue?

coreDatype is an interface? https://rdf4j.org/javadoc/4.0.0-M2/org/eclipse/rdf4j/model/base/CoreDatatype.html

@nguyenm100 CoreDatatype is an interface but all the implementations are enums. CoreDatatype.NONE was a static lambda, but as of 4.0.2 it is instead backed by an enum.

Hi, confirmed your changes fixes my issue (I was somehow running against a version that didn't have your change). tx


New illustration with proper vector graphic

Here are new freshly made vector images of footer with logo, footer and line.
I have also .esp files but git won't accept them.
footerjalogo(1).pdf
footer_logo.pdf
viiva_A3(1).pdf

Thanks for contribution.
But we were looking for svg. And now, there are new graphics for the title page.


Improve OAuth SPA application create flow

Is your suggestion related to an experience ? Please describe.
Currently, in the console app, we have the below UX when creating a SPA using the template.

There are few improvements we can do,

Keep the redirect URI mandatory
Display the notice saying that if you are trying out quickly, that we will be adding some default value "X" as the callback URL or we can get rid of adding the default callback URL completely.

@NipuniBhagya

@NipuniBhagya

This issue is being closed due to extended inactivity. Please feel free to reopen it if further attention is needed. Thank you for helping us keep the issue list relevant and focused!


[Question]: Is the code on Gitee synchronized with the code on GitHub?

Describe your problem
https://gitee.com/infiniflow/ragflow  and   https://github.com/infiniflow/ragflow

https://gitee.com/infiniflow/ragflow is created and maintained by gitee.com. We don't intend to maintain this mirror.

https://gitee.com/infiniflow/ragflow is created and maintained by gitee.com. We don't intend to maintain this mirror.

Understood, thank you for your response


fix TiFlash wait index timeout due to not replicated filtered commands

Signed-off-by: CalvinNeo<EMAIL_ADDRESS>What problem does this PR solve?
Issue Number: close #5445
Problem Summary:
As mentioned in https://github.com/pingcap/tidb-engine-ext/pull/130
What is changed and how it works?
Check List
Tests

[ ] Unit test
[ ] Integration test
[ ] Manual test (add detailed scripts or steps below)
[ ] No code

Side effects

[ ] Performance regression: Consumes more CPU
[ ] Performance regression: Consumes more Memory
[ ] Breaking backward compatibility

Documentation

[ ] Affects user behaviors
[ ] Contains syntax changes
[ ] Contains variable changes
[ ] Contains experimental features
[ ] Changes MySQL compatibility

Release note

None

/run-check-issue-triage-complete

/merge

/run-integration-test

/run-integration-test

/run-integration-test

/run-integration-test

/run-integration-test

/run-integration-test

/run-integration-test


Contribs Repo

Currently, there are multiple deployment options that are fully outdated and built for platforms that probably are not worth maintaining.
It would be great if we support only a couple like Kubernetes and docker-compose.
The remaining deployment options could be removed from this repo and moved to a users-contribs repository just in case that someone has a use case for those or want to maintain it.
We should have only supported and updated deployment options.

Solved by #834


Integrating the library

I've just begun experimenting with integrating the library with an existing project and hit a couple of hurdles/questions.
I'm trying to integrate a few UI frameworks in a way that doesn't tie my project to any one of them too tightly at this point; so am attempting to create an abstraction layer that fits both my project and various UI frameworks with varying approaches.
One specific question I have is, can hikogui potentially be used in a situation where an application already has its own event loop? I have no experience with C++ coroutines so I think that's contributing to my uncertainty. I tried calling loop::main().resume_once() from within an existing loop, but the window was unresponsive.
A couple of other small things I've run into (note I'm trying to integrate into a project that doesn't use CMake; I believe I've reproduced the necessary preprocessor defines and such, but it's possible something I've missed may be contributing):

I believe the CMake install logic may be incomplete/out of date? It didn't seem to copy all headers necessary to use the library.
I suspect there may be some issues with #include dependencies, perhaps masked by PCH usage within the library/examples project. gui_window_win32.hpp (included by gui_system.hpp) uses a number of Windows typedefs without including them, which showed up as compilation errors when including this from my project. I've worked around it by explicitly including utility/win32_headers.hpp first, but from reading some of the comments in the code, I get the impression I shouldn't need to, and maybe some dependencies have been exposed to public headers unintentionally?

It is very likely you are starving loop::main().resume_once(), it needs to be called in a very tight loop, as the 60fps redraw is done through the main-loop. Also resume_once() will block, so you have very little time to do anything before you are required to call resume_once() again.
As it stands it would be very difficult to integrate with an existing loop, because it is already complicated to get a single high performance loop going; where the win32 message queue, 60fps vsync refresh and network connections are handled on the same thread.
There are ways to interact with the main loop, if you look at the vulkan triangle example you will see that the widget receives special redraw calls at 60fps to draw onto the swap-chain directly.
You can ignore co-routines mostly, when you see co-routines just think "callback-hell", which you should be used to when you are doing GUI development.  co-routines are pretty simple, co_await simply registers the current position as a callback function to the object that is on the RHS of a co_await statement. Which in the case of HikoGUI those callbacks will be triggered from the main-loop on the main-thread.
The CMake install is a bit nasty at the moment. I am working on using a more modern way how CMake handles include files, in preparation for eventually switching to modules as soon as compilers don't crash from using them.
I am sorry to say that would require to use the source directly instead of using the installation right now.

It is very likely you are starving loop::main().resume_once(), it needs to be called in a very tight loop, as the 60fps redraw is done through the main-loop. Also resume_once() will block, so you have very little time to do anything before you are required to call resume_once() again.

In this particular test I was calling it from a busy loop doing basically nothing else, so I don't think it was that. When I replaced that loop with a call to resume(), all was good. Anyway if it's not really designed to be used that way, then I'll see if I can integrate it in the intended manner.

The CMake install is a bit nasty at the moment. I am working on using a more modern way how CMake handles include files, in preparation for eventually switching to modules as soon as compilers don't crash from using them. I am sorry to say that would require to use the source directly instead of using the installation right now.

Ok no worries. Yep I fell back onto referencing the headers as they are in the source folder; it was then that I hit the Windows include issue.

I normally never build with PCH because it increases build times when developing (incremental builds don't work).

Part of the problem is the vulkan headers including the windows headers, and me including the vulkan header in a public header like gui_window_win32.hpp
The only real solution is modules. But as I said MSVC crashes when you use modules. And it seems they are not interested in fixing these bugs.

Also are you using main or the latest release? You may have more luck with main.
It has been a while since I made a release due to me going off in a tangent on a patch I was working on.

Are you hitting some multi-definitions on?:
struct HWND__;
using HWND = HWND__ *;

Also are you using main or the latest release? You may have more luck with main.

Yep I'm back on main now.

Are you hitting some multi-definitions

No it was the other way around, it hadn't got any definition at all for things like UINT_PTR.
I've discovered now what the difference is between my setup and the examples. It seems that gui_window_win32.hpp is currently relying on getting those Windows types indirectly via vulkan.h, but in my build I had failed to add the VK_USE_PLATFORM_WIN32_KHR define so it didn't pull in windows.h. Can't verify just now, but pretty sure adding that define to my build will fix the issue.

That could explain it, yes.
Now I wonder if I could set VK_USE_PLATFORM_WIN32_KHR only where the swap-chain is used so I can reduce exposing the win32 headers.

Realized that I can only integrate hikogui into my project (lots of shared libraries) if I build it as a shared library also, but on trying to do so, I get the following weird looking unresolved symbol error:
cmd.exe /C "cmd.exe /C ""C:\Program Files\Microsoft Visual Studio\2022\Preview\Common7\IDE\CommonExtensions\Microsoft\CMake\CMake\bin\cmake.exe" -E __create_def C:\Coding\hiko\hikogui\out\build\vc17-x64-windows-dll-dbg\CMakeFiles\hikogui.dir\.\exports.def C:\Coding\hiko\hikogui\out\build\vc17-x64-windows-dll-dbg\CMakeFiles\hikogui.dir\.\exports.def.objs && cd C:\Coding\hiko\hikogui\out\build\vc17-x64-windows-dll-dbg" && "C:\Program Files\Microsoft Visual Studio\2022\Preview\Common7\IDE\CommonExtensions\Microsoft\CMake\CMake\bin\cmake.exe" -E vs_link_dll --intdir=CMakeFiles\hikogui.dir --rc=C:\PROGRA~2\WI3CF2~1\10\bin\100226~1.0\x64\rc.exe --mt=C:\PROGRA~2\WI3CF2~1\10\bin\100226~1.0\x64\mt.exe --manifests  -- C:\PROGRA~1\MICROS~2\2022\Preview\VC\Tools\MSVC\1437~1.327\bin\Hostx64\x64\link.exe  @CMakeFiles\hikogui.rsp  /out:hikoguid.dll /implib:hikoguid.lib /pdb:hikoguid.pdb /dll /version:0.0 -machine:x64 -nologo -debug  /ignore:4744 /DEF:CMakeFiles\hikogui.dir\.\exports.def  && cd ."
  LINK: command "C:\PROGRA~1\MICROS~2\2022\Preview\VC\Tools\MSVC\1437~1.327\bin\Hostx64\x64\link.exe @CMakeFiles\hikogui.rsp /out:hikoguid.dll /implib:hikoguid.lib /pdb:hikoguid.pdb /dll /version:0.0 -machine:x64 -nologo -debug /ignore:4744 /DEF:CMakeFiles\hikogui.dir\.\exports.def /MANIFEST /MANIFESTFILE:hikoguid.dll.manifest" failed (exit code 1120) with the following output:
C:\Coding\hiko\hikogui\out\build\vc17-x64-windows-dll-dbg\exports.def : error LNK2001: unresolved external symbol =

That output isn't cut off, it actually ends with the =. Any idea?
This was with the following config, but I tried various combinations and all with the same result.
{
    "name": "vc17-x64-windows-dll-dbg",
    "displayName": "MSVC-x64-Debug Dll",
    "inherits": "vc17-x64-windows",
    "cacheVariables": {
        "CMAKE_BUILD_TYPE": "Debug",
        "BUILD_SHARED_LIBS": "ON",
        "HI_ENABLE_PCH": "OFF"
    }
}

DLL builds are very broken, it requires that every type and function be individually exported.
There is a way to export everything, which is what the build does, but as you see the linker/compiler is bugged with that feature.
I was hoping once we switch to modules it will become a module-only library without anything to link against.


Add knowledge-augmented Poe bot powered by LlamaIndex

Example here is also hosted at https://github.com/run-llama/llama-api/tree/main/poe-api

(Re-triggering CI)

I installed pre-commit.ci to autofix most of the lint issues, but a few need manual work.

I installed pre-commit.ci to autofix most of the lint issues, but a few need manual work.

qq: how do I run the same lint check locally (as done in CI)?

pip install pre-commit, then pre-commit run --all

pip install pre-commit, then pre-commit run --all

Gotcha, would be great to add this to  repo README.md for other contributors in the future as well!

pip install pre-commit, then pre-commit run --all

Gotcha, would be great to add this to repo README.md for other contributors in the future as well!

#42

Looks like all passing locally :D

Nice, got it to work.


Bump: asana automation

Background
Bumps asana automation to the next patch verrsion, due to a security update to its internal packages
Changes

Bump asana automation from v3.0.4 to v3.0.5

Testing

CI

Not merging yet, since for some reason, the action can't be found via tar. This could be a permissions issue, so I'm waiting for feedback from @alexmylonas


Make LocalContextMenuRepresentation public

Compose 1.1.0
To be able to override theme of Context menu.
After that we need to add a tutorial:
import androidx.compose.foundation.DarkDefaultContextMenuRepresentation
import androidx.compose.foundation.LightDefaultContextMenuRepresentation
import androidx.compose.foundation.LocalContextMenuRepresentation
import androidx.compose.foundation.isSystemInDarkTheme
import androidx.compose.material.Text
import androidx.compose.material.TextField
import androidx.compose.runtime.CompositionLocalProvider
import androidx.compose.runtime.mutableStateOf
import androidx.compose.runtime.remember
import androidx.compose.ui.ExperimentalComposeUiApi
import androidx.compose.ui.window.singleWindowApplication

@OptIn(ExperimentalComposeUiApi::class, androidx.compose.foundation.ExperimentalFoundationApi::class)
fun main() = singleWindowApplication(title = "Context menu") {
    val contextMenuRepresentation = if (isSystemInDarkTheme()) {
        DarkDefaultContextMenuRepresentation
    } else {
        LightDefaultContextMenuRepresentation
    }
    CompositionLocalProvider(
        LocalContextMenuRepresentation provides contextMenuRepresentation
    ) {
        val text = remember { mutableStateOf("Hello!") }
        TextField(
            value = text.value,
            onValueChange = { text.value = it },
            label = { Text(text = "Input") }
        )
    }
}

It is already public in 1.2. We probably need to backport it to 1.1

1.2 is almost released

Please check the following ticket on YouTrack for follow-ups to this issue. GitHub issues will be closed in the coming weeks.


Add methods to gnuplot class for querying gnuplot version

As the title says, we need some methods to know with what version of gnuplot we're working.

Added with f07071a


Fix duplicates handling in converting to safetensors

Fixes #169

The docs for this PR live here. All of your documentation changes will be reflected on that endpoint.


Compile error when using MQTTnet.AspNetCore v3.0.3

I get the following compile error when trying to build a sample project with MQTTnet.AspNetCore v3.0.3 from NuGet.  I have tried adding MQTTnet v3.0.3 to the project, but with no effect.
The code compile and executes when v3.0.2 is used, but v3.0.3 does not.
1>------ Build started: Project: MqttServerApp, Configuration: Debug Any CPU ------
1>Program.cs(22,13,22,38): error CS0012: The type 'IMqttServer' is defined in an assembly that is not referenced. You must add a reference to assembly 'MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7'.
1>Program.cs(27,13,27,41): error CS0012: The type 'IMqttServerOptions' is defined in an assembly that is not referenced. You must add a reference to assembly 'MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7'.
1>Program.cs(27,13,27,41): error CS0012: The type 'MqttServerOptionsBuilder' is defined in an assembly that is not referenced. You must add a reference to assembly 'MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7'.
1>Done building project "MqttServerApp.csproj" -- FAILED.
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

MqttServerApp.csproj
<Project Sdk="Microsoft.NET.Sdk.Web">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>netcoreapp2.2</TargetFramework>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="Microsoft.AspNetCore.App" />
    <PackageReference Include="MqttNet.AspNetCore" Version="3.0.3" />
  </ItemGroup>

</Project>

Program.cs
using Microsoft.AspNetCore;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.DependencyInjection;
using MQTTnet.AspNetCore;

namespace MqttServerApp
{
    class Program
    {
        static void Main(string[] args)
        {
            WebHost.CreateDefaultBuilder(args).UseStartup<Startup>().Build().Run();
        }
    }

    public class Startup
    {
        public void Configure(IApplicationBuilder application)
        {
            application.UseStaticFiles();
            application.UseMqttServer(c => { });
        }

        public void ConfigureServices(IServiceCollection services)
        {
            services.AddHostedMqttServer(c => { });
        }
    }
}

Duplicate of #390

OK but what happens if you just add MQTTnet 3.0.3 to the project?

I created a completely new ASP.NET project, added MQTTnet ASP.NET extension ONLY and it works perfectly. The interface IMqttServer is found properly. Please try to clean/rebuild/nuget restore your project.

I can reproduce the issue. Reference: https://github.com/mqttnettest/Issue677Test.

OK but what happens if you just add MQTTnet 3.0.3 to the project?

The same error... Check the https://github.com/mqttnettest/Issue677Test/tree/master/Issue677Test2 project.

This seems to be caused by the services.AddHostedMqttServer(mqttOptions); call.

OK I had the wrong Interface. For me it also does not work. But again the IMqttServer interface is working which is also coming from the MQTTnet lib instead of the extension library.
Adding the MQTTnet lib directly is possible but does not solve the problem. Very strange!
Is maybe the referenced ASP.NET lib not compatible? Because it requires that service collection.

Is maybe the referenced ASP.NET lib not compatible? Because it requires that service collection.

That might be a reason...

The error is looking for an assembly with a PublicKeyToken.

error CS0012: The type 'IMqttServerOptions' is defined in an assembly that is not referenced. You must add a reference to assembly 'MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7'.

Using dotPeek, I looked at the meta data of the MQTTnet.dll files in the NuGet package:

// Assembly MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=null
// MVID: CF2294BC-22C9-4DF9-A752-ADAC32691622
// Assembly references:
// netstandard, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51
...
[assembly: TargetFramework(".NETStandard,Version=v2.0", FrameworkDisplayName = "")]

// Assembly MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7
// MVID: C013CD92-8DA2-4A28-B895-B7C337F60DB1
// Assembly MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7
// MVID: C013CD92-8DA2-4A28-B895-B7C337F60DB1
// Assembly references:
// System.Runtime, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
...
[assembly: TargetFramework(".NETStandard,Version=v1.3", FrameworkDisplayName = "")]

// Assembly MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7
// MVID: 0B3389AA-CD20-499B-8112-1A82398596D4
// Assembly references:
// mscorlib, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b77a5c561934e089
...
[assembly: TargetFramework(".NETFramework,Version=v4.6.1", FrameworkDisplayName = ".NET Framework 4.6.1")]

// Assembly MQTTnet, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b69712f52770c0a7
// MVID: A9D2BD0B-2588-4F82-88A7-46E9D042E82E
// Assembly references:
// mscorlib, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=b77a5c561934e089
...
[assembly: TargetFramework(".NETFramework,Version=v4.5.2", FrameworkDisplayName = ".NET Framework 4.5.2")]

Looks like there is a problem with the PublicKeyToken of the .NET Standard 2.0 assembly. Which might explain why it can't find the assembly.

I also found that one diff with 3.0.2 is that the assembly version is no longer 1.0.0. It is now 3.0.3 (same as nuget version). I assume it is coming from the MQTTnet.Server builds because these will rebuild all assemblies and this will override the original ones which are intended for nuget release. This may also explain the issue you mentioned because the first build creates the properly but the build for MQTTnet.Server overrides that bins. I moved nuget generation BEFORE the generation of MQTTnet.Server. Hopefully this will fix it.

I released 3.0.4 which works again.

Hi @chkr1011. I'm afraid but this occurs in version 3.0.7 again...
.
Exactly the same issue with the same method: AddHostedMqttServer.
Adding the MQTTnet package additionally doesn't have an effect.

O sh... I am afraid that adding the test execution to the build script overrides the binaries again like in the previous issue. I will release 3.0.8 now. It has no change apart from a reordered build script.
Please let me know if the new version works again.

3.0.8 fixes this for me :)


Clicking Max means you cannot send a tx

You need to deduct fee from the amount if Max is selected
Also Max should be green like the colour of the arrow icon to switch between deposit/withdrawal modes

On optimism it calculates with the fee and shows insufficient if you click max unless you reduce the amount and it recalculates after you change the field after half a second:
Notice the message AND button changing to insufficient balance

Also top Available should change to "Balance:" to be consistent


Accept Input from Stream

I have a little VPS with approx 15 GB usable space.
Using traditional method of downloading redump and then extracting it, it will probably left with 1 or 2 GB of space.
Is it possible to feed xdvdfs from stream piped by unzip -p?
Perhaps like unzip -p game.zip | xargs xdvdfs pack? Well, I've tried it and obviously it doesn't works.
Thanx.

Piracy and its related use cases are not supported by this tool.


Show WASD keys on screen

Title explains everything
if you can help me please add me BETA#0530

You can make this with interfaces->surface or ImDrawList, just check when UserCmd::IN_FORWARD, UserCmd::IN_BACK, UserCmd::IN_MOVELEFT, UserCmd::IN_MOVERIGHT and next draw text and filled rectangles in the corner of the screen.
sry for my bad english xd

Thanks!
i wish if you can make a repo with this


Catalyst Data Store by Zoho / ZCQL

Problem
Support ZCQL from Zoho's catalyst https://www.zoho.com/catalyst/help/zcql.html
Suggested solution
idk add support
Alternatives
Use ZCQL from the SDK without prisma support
Additional context
I love zoho catalyst I cannot live without it but I want to use prisma to generate my SQL queries

Hi there,
As part of our effort to clean up our GitHub repo, we’re closing this issue to help focus on features and improvements that align with our focus areas and those of our community.
If this is issue is still important to you, feel free to reopen the issue and get like-minded users to upvote as we will prioritize fixing issues based on community interest. If you do reopen the issue, please ensure that there’s a clear method for us to reproduce it.
For more insight into our priorities and how we’re thinking about the future of the Prisma ORM, please see our recent blog post: https://www.prisma.io/blog/prisma-orm-manifesto.
Thank you for your understanding and support!


Conversion Rates are not the most up to date

Describe the bug
The conversion rates are not up to date and can cause in-accurate conversions, especially with large amounts.
To Reproduce
Convert something that is a large number and then check with google
Expected behavior
Google and conversion from extension are the same
Screenshots
N/A
Additional context
Problem with API most likely

Duplicate, closing


Some cleanups to the model spec documentation.

Clarify Android-only support for certain types.
Clean up descriptions of certain elements in the spec.
Fix a few typos.

Summary
The model spec documentation is confusing in a few cases, and some types are not supported on iOS (see https://github.com/pytorch/live/issues/26).
Changelog

[DOCS] Improve model spec documentation
Test Plan
There are no code changes in this PR.

We've merged the PR. Thanks again for your contributions, @mdwelsh!!


Refactor inspect logic

This pulls the logic for inspect out into a new file which makes it a bit easier to understand.
This was going to be the first part of an implementation for #276, but it seems like that might take a while so I'm going to PR a few bits of refactoring individually.

This is definitely a big improvement.
I'd like to refactor the unit tests that cover .inspect() too - currently they are a huge ugly blob at the top of test_api.py

We should merge his before refactoring the tests though, because that way we don't couple the new tests to the verification of this change.


Some checks are being skipped due to lack of async support

A number of checks are declared async but are being skipped with the following warning:
20:04:54 edx-repo-health/repo_health/check_github.py::check_build_duration
20:04:54 edx-repo-health/repo_health/check_github.py::check_settings
20:04:54 edx-repo-health/repo_health/check_github.py::check_languages
20:04:54 edx-repo-health/repo_health/check_renovate.py::check_renovate
20:04:54   /edx/var/jenkins/jobs/RepoHealth/jobs/org-repo-health-report/workspace/venv/lib/python3.8/site-packages/_pytest/python.py:184: PytestUnhandledCoroutineWarning: async def functions are not natively supported and have been skipped.
20:04:54   You need to install a suitable plugin for your async framework, for example:
20:04:54     - anyio
20:04:54     - pytest-asyncio
20:04:54     - pytest-tornasync
20:04:54     - pytest-trio
20:04:54     - pytest-twisted
20:04:54     warnings.warn(PytestUnhandledCoroutineWarning(msg.format(nodeid)))

I have a branch timmc/no-skip-async that I think works, but I couldn't get mocks working properly in the unit tests.

I believe https://github.com/openedx/pytest-repo-health/pull/206 will fix it.


Generator: upgrade from Karma to Web Test Runner

General Support Request
It appears that open-wc/testing-karma is deprecated and they suggest upgrading to Web Test Runner?
What will it take to upgrade to Web test runner? What is the effort to upgrade legacy components? Do we even need to upgrade legacy elements?
The scope of this update is to only upgrade the generator and decide what is the effort needed to upgrade legacy repos?

This work should have a PR pointing to the new next branch prior to release.

Currently proving out the new test runner with auro-pane before integrating into the generator.

DO NOT make a PR against ‘master’. Use the ‘next’ branch.


Better support for table prefixes, added license

I was having issues with plugins and models which used different table prefixes and found that these amendments resolved the issues for me

Thanks, fixed in https://github.com/biesbjerg/FilterHabtm/commit/5687ca49d3e3319316830cf6f46e61d8d196fb7d :-)


How to use Links ?

Hi,
I have noticed there is a possibility to define links between models (for example link a planet to several satellites).
I succeded in declaring them in my schemas, just like in the example given in the docs but, unfortunaltly, I fail to figure out how to use them.
Thanks,

me too!

I've posted a stackoverflow question, and I created the [orbit.js] tag

@dgeb, mind taking a look at my question, please?

Also, same as #263

Very sorry to delay with a response. The API for querying related records has changed - the new approach is documented here: http://orbitjs.com/v0.15/guide/querying-data.html#Standard-queries
For example:
store.query(q => q.findRelatedRecords({ type: 'planet', id: 'earth' }, 'moons'));


Local filesystem provider

Hi,
Just thought you might like to know that I've forked and added support for local filesystem lookups.
e.g. host -a dev.example.com <IP_ADDRESS> could check to see if /path/to/example.com exists locally and return <IP_ADDRESS> if found.
It can also be configured to work with domain suffixes e.g. example.com.dev or example.com.localhost
I'm finding this useful for local web development as I don't need to keep editing my hosts file every time I work on a new site, providing my folder structure is consistent.
Wasn't sure if that functionality was within the scope of this project so I didn't want to open as a PR.
https://github.com/Muffinman/PHP-DNS-SERVER/blob/master/src/DirStorageProvider.php

That is clever and it looks really good! You should open a PR.

I believe that's entirely due to this change in Chrome, specific to the ".dev" TLD.
https://laravel-news.com/chrome-63-now-forces-dev-domains-https
This will probably still work fine if you use .local or something along those lines.

Not in my case, my local domain formats are dev.example.com so that my password manager picks up the correct passwords for the parent domain.
It really did seem random where it would work for some domains but not others, and then would randomly stop working all together.
I'm pretty sure it was something specific to Chrome as any dig / host lookups worked perfectly from the command line, as did Safari when I tested that.


Dedication of public IP ranges broken after upgrade to <IP_ADDRESS>

ISSUE TYPE

Bug Report

COMPONENT NAME

API, UI, SSVM, CPVM

CLOUDSTACK VERSION

<IP_ADDRESS>

CONFIGURATION

1 Zone, Advanced networking, 3 domains
OS / ENVIRONMENT

All running Ubuntu 20.04.5
Database mysql 8
SUMMARY

Existing configuration (working running CS 4.16.1)

Setting system.vm.public.reservation.mode.strictness = true
After upgrade:
While deploying SSVM / CPVM, dedicated IP Ranges for use of system VMs aren't concidert for deployment. With system.vm.public.reservation.mode.strictness enabled, a deployment of SSVM / CPVM fails "due to Insufficent address capacity".
With system.vm.public.reservation.mode.strictness set to 'false' deployment is successfull while using IP ranges not marked as dedicated for system VMs.
Newly created IP ranges with dedication for systemVMs aren't stored or found in db table domain_vlan_map. Also prior used ip ranges dedicated for systemVMs aren't referenced in domain_vlan_map.
Currently tested with public IP addresses. Not tested with "strictness" for management IP addresses.
STEPS TO REPRODUCE

Create IP range for public IPs with dedication for system VMs enabled
Change setting system.vm.public.reservation.mode.strictness to true
Destroy existing CPVM / SSVM

EXPECTED RESULTS

- Table `domain_vlan_map` shows entry for newly created IP range (stored as new vlan) assigned to domain
- System VMs are successfully deployed using IPs from the dedicated IP range

ACTUAL RESULTS

- Table `domain_vlan_map` shows no entry
- Deployment of systemVMs  fails due to insufficent address capacity
- Changeing setting `system.vm.public.reservation.mode.strictness` to "false"
   --> deployment successfull using IP range of domain not dedicated for systemVMs

@Hudratronium I'm not able to reproduce this on 4.17 branch. I added a new public range and set system.vm.public.ip.reservation.mode.strictness to true. New system vms came up fine in the new range
(local) 🐓 > list zones id=8395094c-305b-46cd-878a-b1dcc01c37d0
{
  "count": 1,
  "zone": [
    {
      "allocationstate": "Enabled",
      "dhcpprovider": "VirtualRouter",
      "dns1": "<IP_ADDRESS>",
      "guestcidraddress": "<IP_ADDRESS>/24",
      "hasannotations": false,
      "id": "8395094c-305b-46cd-878a-b1dcc01c37d0",
      "internaldns1": "<IP_ADDRESS>",
      "localstorageenabled": false,
      "name": "Sandbox-simulator",
      "networktype": "Advanced",
      "securitygroupsenabled": false,
      "tags": [],
      "zonetoken": "bfd27e96-3ba0-3df3-b387-f8ff690c63c5"
    }
  ]
}
(local) 🐗 > list systemvms zoneid=8395094c-305b-46cd-878a-b1dcc01c37d0
{
  "count": 2,
  "systemvm": [
    {
      "activeviewersessions": 0,
      "created": "2022-09-05T12:36:52+0530",
      "dns1": "<IP_ADDRESS>",
      "gateway": "<IP_ADDRESS>",
      "hasannotations": false,
      "hostid": "fc35ad4a-bdc8-496a-94e9-46d9d228526a",
      "hostname": "SimulatedAgent.9d862bb4-6179-4a90-ab8a-f91b23fac374",
      "hypervisor": "Simulator",
      "id": "52ff1944-20d5-4954-8cfd-dcd0ed96b46f",
      "isdynamicallyscalable": false,
      "linklocalip": "<IP_ADDRESS>",
      "linklocalmacaddress": "0e:00:a9:fe:c4:7c",
      "linklocalnetmask": "<IP_ADDRESS>",
      "name": "v-9-VM",
      "podid": "ccdd5096-1dcc-40c5-9699-801e22f3f15f",
      "podname": "POD0",
      "privateip": "<IP_ADDRESS>",
      "privatemacaddress": "1e:00:54:00:00:40",
      "privatenetmask": "<IP_ADDRESS>",
      "publicip": "<IP_ADDRESS>",
      "publicmacaddress": "1e:00:91:00:00:c8",
      "publicnetmask": "<IP_ADDRESS>",
      "state": "Running",
      "systemvmtype": "consoleproxy",
      "templateid": "669011fa-2cdd-11ed-b1e6-645d8651f45a",
      "templatename": "SystemVM Template (simulator)",
      "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0",
      "zonename": "Sandbox-simulator"
    },
    {
      "agentstate": "Up",
      "created": "2022-09-05T12:36:53+0530",
      "dns1": "<IP_ADDRESS>",
      "gateway": "<IP_ADDRESS>",
      "hasannotations": false,
      "hostid": "bdefc6c3-4a43-4d6a-9570-0fc9a6ac6d14",
      "hostname": "SimulatedAgent.d1b801a8-36b8-47e7-bfd7-710402b63a99",
      "hypervisor": "Simulator",
      "id": "eb726c05-b467-48b7-b42e-8a6c0a9bca42",
      "isdynamicallyscalable": false,
      "linklocalip": "<IP_ADDRESS>",
      "linklocalmacaddress": "0e:00:a9:fe:b5:e5",
      "linklocalnetmask": "<IP_ADDRESS>",
      "name": "s-10-VM",
      "podid": "ccdd5096-1dcc-40c5-9699-801e22f3f15f",
      "podname": "POD0",
      "privateip": "<IP_ADDRESS>",
      "privatemacaddress": "1e:00:75:00:00:13",
      "privatenetmask": "<IP_ADDRESS>",
      "publicip": "<IP_ADDRESS>",
      "publicmacaddress": "1e:00:16:00:00:c9",
      "publicnetmask": "<IP_ADDRESS>",
      "state": "Running",
      "systemvmtype": "secondarystoragevm",
      "templateid": "669011fa-2cdd-11ed-b1e6-645d8651f45a",
      "templatename": "SystemVM Template (simulator)",
      "version": "<IP_ADDRESS>-SNAPSHOT",
      "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0",
      "zonename": "Sandbox-simulator"
    }
  ]
}
(local) 🐰 > list vlanipranges zoneid=8395094c-305b-46cd-878a-b1dcc01c37d0
{
  "count": 1,
  "vlaniprange": [
    {
      "account": "system",
      "cidr": "<IP_ADDRESS>/24",
      "domain": "ROOT",
      "domainid": "fe476c7c-2cdc-11ed-b1e6-645d8651f45a",
      "endip": "<IP_ADDRESS>",
      "forsystemvms": false,
      "forvirtualnetwork": true,
      "gateway": "<IP_ADDRESS>",
      "id": "10b19120-cfd8-441c-81c8-e156c09c38e4",
      "netmask": "<IP_ADDRESS>",
      "networkid": "234ef426-bb2f-445e-83d9-5363fc6bfb38",
      "physicalnetworkid": "a44e9a10-6682-42e1-81b3-ffabfdfc30f9",
      "startip": "<IP_ADDRESS>",
      "vlan": "vlan://50",
      "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0"
    }
  ]
}
(local) 🐈 > list configurations name=system.vm.public.ip.reservation.mode.strictness
{
  "configuration": [
    {
      "category": "Advanced",
      "description": "If enabled, the use of System VMs public IP reservation is strict, preferred if not.",
      "isdynamic": true,
      "name": "system.vm.public.ip.reservation.mode.strictness",
      "value": "false"
    }
  ],
  "count": 1
}
(local) 🐬 > create vlaniprange gateway=<IP_ADDRESS> netmask=<IP_ADDRESS> startip=<IP_ADDRESS> endip=<IP_ADDRESS> zoneId=8395094c-305b-46cd-878a-b1dcc01c37d0 vlan=51 forsystemvms=true forvirtualnetwork=true
{
  "vlan": {
    "account": "system",
    "cidr": "<IP_ADDRESS>/24",
    "domain": "ROOT",
    "domainid": "fe476c7c-2cdc-11ed-b1e6-645d8651f45a",
    "endip": "<IP_ADDRESS>",
    "forsystemvms": true,
    "forvirtualnetwork": true,
    "gateway": "<IP_ADDRESS>",
    "id": "edc376e0-cf2d-4ab7-aaac-0b7b14e2a931",
    "netmask": "<IP_ADDRESS>",
    "networkid": "234ef426-bb2f-445e-83d9-5363fc6bfb38",
    "physicalnetworkid": "a44e9a10-6682-42e1-81b3-ffabfdfc30f9",
    "startip": "<IP_ADDRESS>",
    "vlan": "vlan://51",
    "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0"
  }
}
(local) 🦌 > update configuration name=system.vm.public.ip.reservation.mode.strictness value=true
{
  "configuration": {
    "category": "Advanced",
    "description": "If enabled, the use of System VMs public IP reservation is strict, preferred if not.",
    "isdynamic": true,
    "name": "system.vm.public.ip.reservation.mode.strictness",
    "value": "true"
  }
}
(local) 🐃 > destroy systemvm id=52ff1944-20d5-4954-8cfd-dcd0ed96b46f
{
  "systemvm": {
    "created": "2022-09-05T12:36:52+0530",
    "dns1": "<IP_ADDRESS>",
    "hasannotations": false,
    "hostid": "fc35ad4a-bdc8-496a-94e9-46d9d228526a",
    "hostname": "SimulatedAgent.9d862bb4-6179-4a90-ab8a-f91b23fac374",
    "hypervisor": "Simulator",
    "id": "52ff1944-20d5-4954-8cfd-dcd0ed96b46f",
    "isdynamicallyscalable": false,
    "name": "v-9-VM",
    "podid": "ccdd5096-1dcc-40c5-9699-801e22f3f15f",
    "podname": "POD0",
    "state": "Running",
    "systemvmtype": "consoleproxy",
    "templateid": "669011fa-2cdd-11ed-b1e6-645d8651f45a",
    "templatename": "SystemVM Template (simulator)",
    "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0",
    "zonename": "Sandbox-simulator"
  }
}
(local) 🌵 > destroy systemvm id=eb726c05-b467-48b7-b42e-8a6c0a9bca42
{
  "systemvm": {
    "created": "2022-09-05T12:36:53+0530",
    "dns1": "<IP_ADDRESS>",
    "hasannotations": false,
    "hostid": "bdefc6c3-4a43-4d6a-9570-0fc9a6ac6d14",
    "hostname": "SimulatedAgent.d1b801a8-36b8-47e7-bfd7-710402b63a99",
    "hypervisor": "Simulator",
    "id": "eb726c05-b467-48b7-b42e-8a6c0a9bca42",
    "isdynamicallyscalable": false,
    "name": "s-10-VM",
    "podid": "ccdd5096-1dcc-40c5-9699-801e22f3f15f",
    "podname": "POD0",
    "state": "Running",
    "systemvmtype": "secondarystoragevm",
    "templateid": "669011fa-2cdd-11ed-b1e6-645d8651f45a",
    "templatename": "SystemVM Template (simulator)",
    "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0",
    "zonename": "Sandbox-simulator"
  }
}
(local) 🐂 > list systemvms zoneid=8395094c-305b-46cd-878a-b1dcc01c37d0
{
  "count": 2,
  "systemvm": [
    {
      "activeviewersessions": 0,
      "created": "2022-09-05T12:39:23+0530",
      "dns1": "<IP_ADDRESS>",
      "gateway": "<IP_ADDRESS>",
      "hasannotations": false,
      "hostid": "f0bcf07c-ab72-4137-a413-449684ae309c",
      "hostname": "SimulatedAgent.f83bd68a-5642-49bc-aac2-dd8a4785aedc",
      "hypervisor": "Simulator",
      "id": "01a9646f-17af-430d-aab4-a07b4a9eec35",
      "isdynamicallyscalable": false,
      "linklocalip": "<IP_ADDRESS>",
      "linklocalmacaddress": "0e:00:a9:fe:aa:b5",
      "linklocalnetmask": "<IP_ADDRESS>",
      "name": "v-11-VM",
      "podid": "ccdd5096-1dcc-40c5-9699-801e22f3f15f",
      "podname": "POD0",
      "privateip": "<IP_ADDRESS>",
      "privatemacaddress": "1e:00:60:00:00:90",
      "privatenetmask": "<IP_ADDRESS>",
      "publicip": "<IP_ADDRESS>",
      "publicmacaddress": "1e:00:40:00:03:f7",
      "publicnetmask": "<IP_ADDRESS>",
      "state": "Running",
      "systemvmtype": "consoleproxy",
      "templateid": "669011fa-2cdd-11ed-b1e6-645d8651f45a",
      "templatename": "SystemVM Template (simulator)",
      "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0",
      "zonename": "Sandbox-simulator"
    },
    {
      "agentstate": "Up",
      "created": "2022-09-05T12:39:53+0530",
      "dns1": "<IP_ADDRESS>",
      "gateway": "<IP_ADDRESS>",
      "hasannotations": false,
      "hostid": "bdefc6c3-4a43-4d6a-9570-0fc9a6ac6d14",
      "hostname": "SimulatedAgent.d1b801a8-36b8-47e7-bfd7-710402b63a99",
      "hypervisor": "Simulator",
      "id": "02c6d3dd-13ae-44d4-bf90-0d20e9647525",
      "isdynamicallyscalable": false,
      "linklocalip": "<IP_ADDRESS>",
      "linklocalmacaddress": "0e:00:a9:fe:66:1d",
      "linklocalnetmask": "<IP_ADDRESS>",
      "name": "s-12-VM",
      "podid": "ccdd5096-1dcc-40c5-9699-801e22f3f15f",
      "podname": "POD0",
      "privateip": "<IP_ADDRESS>",
      "privatemacaddress": "1e:00:1f:00:00:89",
      "privatenetmask": "<IP_ADDRESS>",
      "publicip": "<IP_ADDRESS>",
      "publicmacaddress": "1e:00:fd:00:03:f6",
      "publicnetmask": "<IP_ADDRESS>",
      "state": "Running",
      "systemvmtype": "secondarystoragevm",
      "templateid": "669011fa-2cdd-11ed-b1e6-645d8651f45a",
      "templatename": "SystemVM Template (simulator)",
      "version": "<IP_ADDRESS>-SNAPSHOT",
      "zoneid": "8395094c-305b-46cd-878a-b1dcc01c37d0",
      "zonename": "Sandbox-simulator"
    }
  ]
}

@shwstppr
Here the whole log with comments on database actions from my system. Out of interest: new created CS4.17 setup or upgraded from 4.16 / 4.15 / .... ?
Cann you maybe take a look into your db and lookig if you can find in domain_vlan_map a entry for referencing the vlan which is enabled for use with systemVMs and the domain you are actually using ?
###################################################################### Nic allocation

2022-08-31 18:44:21,203 DEBUG [c.c.v.VirtualMachineManagerImpl] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Allocating nics for VM instance {id: "86", name: "v-86-VM", uuid: "6f77acb4-c65e-49e8-ae03-1175b3974412", type="ConsoleProxy"}
2022-08-31 18:44:21,203 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-79, consoleproxy-1,
2022-08-31 18:44:21,204 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: start requested by: -Transaction.execute:39-NetworkOrchestrator.allocate:778-VirtualMachineManagerImpl$1.doInTransactionWithoutResult:478-TransactionCallbackWithExceptionNoReturn.doInTransaction:25-TransactionCallbackWithExceptionNoReturn.doInTransaction:21-Transaction.execute:40-VirtualMachineManagerImpl.allocate:469-VirtualMachineManagerImpl.allocate:528-ConsoleProxyManagerImpl.createProxyInstance:700-ConsoleProxyManagerImpl.startNew:572-ConsoleProxyManagerImpl.allocCapacity:809-ConsoleProxyManagerImpl.expandPool:1537
2022-08-31 18:44:21,204 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: has already been started.
2022-08-31 18:44:21,204 TRACE [o.a.c.e.o.NetworkOrchestrator] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) allocating networks for v-86-VM(template c20799e4-a990-449a-aae6-4b67374c7aff); 3 networks
2022-08-31 18:44:21,204 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,206 TRACE [c.c.u.d.T.Connection] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Creating a DB connection with  txn:  for 0: dbconn623913035. Stack: -TransactionLegacy.prepareStatement:466-TransactionLegacy.prepareAutoCloseStatement:459-GenericDaoBase.searchIncludingRemoved:396-GenericDaoBase.searchIncludingRemoved:359-GenericDaoBase.search:348-GenericDaoBase.search:1319-TemplateDeployAsIsDetailsDaoImpl.listDetailsByTemplateIdMatchingPrefix:64-TemplateDeployAsIsDetailsDaoImpl.listNetworkRequirementsByTemplateId:69-NativeMethodAccessorImpl.invoke0:-2-NativeMethodAccessorImpl.invoke:62-DelegatingMethodAccessorImpl.invoke:43-Method.invoke:566
2022-08-31 18:44:21,206 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT template_deploy_as_is_details.id, template_deploy_as_is_details.template_id, template_deploy_as_is_details.name, template_deploy_as_is_details.value FROM template_deploy_as_is_details WHERE template_deploy_as_is_details.template_id = ?  AND template_deploy_as_is_details.name LIKE ?

#### template_deploy_as_is_details = empty --> no results returned

2022-08-31 18:44:21,206 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT template_deploy_as_is_details.id, template_deploy_as_is_details.template_id, template_deploy_as_is_details.name, template_deploy_as_is_details.value FROM template_deploy_as_is_details WHERE template_deploy_as_is_details.template_id = 213  AND template_deploy_as_is_details.name LIKE x'6E6574776F726B2D25'
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Connection] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: Not closing DB connection because we're still in a transaction.
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT networks.id, networks.mode, networks.broadcast_domain_type, networks.traffic_type, networks.name, networks.display_text, networks.broadcast_uri, networks.gateway, networks.cidr, networks.network_cidr, networks.network_offering_id, networks.vpc_id, networks.physical_network_id, networks.data_center_id, networks.related, networks.guru_name, networks.state, networks.redundant, networks.dns1, networks.domain_id, networks.account_id, networks.set_fields, networks.guru_data, networks.dns2, networks.network_domain, networks.removed, networks.created, networks.reservation_id, networks.uuid, networks.guest_type, networks.acl_type, networks.restart_required, networks.specify_ip_ranges, networks.ip6_gateway, networks.ip6_cidr, networks.display_network, networks.network_acl_id, networks.streched_l2, networks.external_id FROM networks WHERE networks.id = ?  AND networks.removed IS NULL
2022-08-31 18:44:21,209 DEBUG [o.a.c.e.o.NetworkOrchestrator] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Allocating nic for vm VM instance {id: "86", name: "v-86-VM", uuid: "6f77acb4-c65e-49e8-ae03-1175b3974412", type="ConsoleProxy"} in network Network {"id": 200, "name": "null", "uuid": "1b0bf965-a391-478d-833d-3e37e4a15eb8", "networkofferingid": 1} with requested profile NicProfile {"broadcastUri":null,"iPv4Address":null,"id":0,"reservationId":null,"vmId":0}
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT data_center.id, data_center.name, data_center.description, data_center.dns1, data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1, data_center.internal_dns2, data_center.router_mac_address, data_center.guest_network_cidr, data_center.domain_id, data_center.domain, data_center.networktype, data_center.dns_provider, data_center.dhcp_provider, data_center.gateway_provider, data_center.vpn_provider, data_center.userdata_provider, data_center.lb_provider, data_center.firewall_provider, data_center.mac_address, data_center.zone_token, data_center.removed, data_center.allocation_state, data_center.uuid, data_center.is_security_group_enabled, data_center.is_local_storage_enabled, data_center.sort_key FROM data_center WHERE data_center.id = ?    AND account.removed IS NULL

### Getting Zone Information

2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT data_center.id, data_center.name, data_center.description, data_center.dns1, data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1, data_center.internal_dns2, data_center.router_mac_address, data_center.guest_network_cidr, data_center.domain_id, data_center.domain, data_center.networktype, data_center.dns_provider, data_center.dhcp_provider, data_center.gateway_provider, data_center.vpn_provider, data_center.userdata_provider, data_center.lb_provider, data_center.firewall_provider, data_center.mac_address, data_center.zone_token, data_center.removed, data_center.allocation_state, data_center.uuid, data_center.is_security_group_enabled, data_center.is_local_storage_enabled, data_center.sort_key FROM data_center WHERE data_center.id = 1  AND data_center.removed IS NULL
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: start requested by: -Transaction.execute:39-IpAddressManagerImpl.listAvailablePublicIps:824-IpAddressManagerImpl.fetchNewPublicIp:811-IpAddressManagerImpl.fetchNewPublicIp:803-IpAddressManagerImpl.assignPublicIpAddress:784-PublicNetworkGuru.getIp:125-PublicNetworkGuru.allocate:172-NetworkOrchestrator.allocateNic:973-NetworkOrchestrator$3.addRequestedNicToNicListWithDeviceNumberAndRetrieveDefaultDevice:823-NetworkOrchestrator$3.doInTransactionWithoutResult:797-TransactionCallbackWithExceptionNoReturn.doInTransaction:25-TransactionCallbackWithExceptionNoReturn.doInTransaction:21
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: has already been started.
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT data_center.id, data_center.name, data_center.description, data_center.dns1, data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1, data_center.internal_dns2, data_center.router_mac_address, data_center.guest_network_cidr, data_center.domain_id, data_center.domain, data_center.networktype, data_center.dns_provider, data_center.dhcp_provider, data_center.gateway_provider, data_center.vpn_provider, data_center.userdata_provider, data_center.lb_provider, data_center.firewall_provider, data_center.mac_address, data_center.zone_token, data_center.removed, data_center.allocation_state, data_center.uuid, data_center.is_security_group_enabled, data_center.is_local_storage_enabled, data_center.sort_key FROM data_center WHERE data_center.id = ?

  AND vlan.removed IS NULL  AND  (domain_vlan_map.domain_id IS NULL ) AND (account_vlan_map.account_id IS NULL )

### Checking for availeable VLANS for domain --> VLAN for system VM not shown / or in the result

2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT domain_vlan_map.id, domain_vlan_map.domain_id, domain_vlan_map.vlan_db_id FROM domain_vlan_map WHERE domain_vlan_map.domain_id = 1

### Checking for availeable VLANS wich are NOT assigned to ANY Account NOR to ANY Domain --> Result is the intended vlan with expected IP Range

2022-08-31 18:44:21,214 TRACE [c.c.u.d.GenericDaoBase] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) join search statement is com.mysql.cj.jdbc.ClientPreparedStatement: SELECT vlan.id, vlan.vlan_id, vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway, vlan.ip6_cidr, vlan.data_center_id, vlan.ip4_range, vlan.ip6_range, vlan.network_id, vlan.physical_network_id, vlan.vlan_type, vlan.uuid, vlan.removed, vlan.created FROM vlan  LEFT OUTER JOIN domain_vlan_map ON vlan.id=domain_vlan_map.vlan_db_id  LEFT OUTER JOIN account_vlan_map ON vlan.id=account_vlan_map.vlan_db_id WHERE vlan.data_center_id = 1  AND vlan.removed IS NULL  AND  (domain_vlan_map.domain_id IS NULL ) AND (account_vlan_map.account_id IS NULL )
2022-08-31 18:44:21,214 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,214 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,214 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated FROM configuration WHERE configuration.name = ?

  AND user_ip_address.allocated IS NULL  AND user_ip_address.vlan_db_id IN (?,?,?,?)  AND user_ip_address.forsystemvms = ?  AND user_ip_address.removed IS NULL  AND  (vlan.vlan_type = ? ) ORDER BY user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC  LIMIT 0, 1 FOR UPDATE

### Check of setting system.vm.public.ip.reservation.mode.strictness --> value "true"

2022-08-31 18:44:21,215 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated FROM configuration WHERE configuration.name = x'73797374656D2E766D2E7075626C69632E69702E7265736572766174696F6E2E6D6F64652E7374726963746E657373'
2022-08-31 18:44:21,215 TRACE [c.c.u.d.GenericDaoBase] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) join search statement is com.mysql.cj.jdbc.ClientPreparedStatement: SELECT user_ip_address.id, user_ip_address.account_id, user_ip_address.domain_id, user_ip_address.public_ip_address, user_ip_address.data_center_id, user_ip_address.source_nat, user_ip_address.allocated, user_ip_address.vlan_db_id, user_ip_address.one_to_one_nat, user_ip_address.vm_id, user_ip_address.state, user_ip_address.mac_address, user_ip_address.source_network_id, user_ip_address.network_id, user_ip_address.uuid, user_ip_address.physical_network_id, user_ip_address.is_system, user_ip_address.vpc_id, user_ip_address.dnat_vmip, user_ip_address.is_portable, user_ip_address.display, user_ip_address.rule_state, user_ip_address.forsystemvms, user_ip_address.removed, user_ip_address.created FROM user_ip_address  INNER JOIN vlan ON user_ip_address.vlan_db_id=vlan.id WHERE user_ip_address.data_center_id = 1  AND user_ip_address.allocated IS NULL  AND user_ip_address.vlan_db_id IN (3,10,13,14)  AND user_ip_address.forsystemvms = 1  AND user_ip_address.removed IS NULL  AND  (vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC  LIMIT 0, 1 FOR UPDATE
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT account_details.id, account_details.account_id, account_details.name, account_details.value FROM account_details WHERE account_details.account_id = ?  AND account_details.name = ?  ORDER BY RAND() LIMIT 1

### Trying to fetch IP-Address: No value / ip address returned -  Domain "Root" shall provide ip addresses; thats where the vlanIDs are comming from --> user_ip_address.vlan_db_id IN (3,10,13,14)

2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT user_ip_address.id, user_ip_address.account_id, user_ip_address.domain_id, user_ip_address.public_ip_address, user_ip_address.data_center_id, user_ip_address.source_nat, user_ip_address.allocated, user_ip_address.vlan_db_id, user_ip_address.one_to_one_nat, user_ip_address.vm_id, user_ip_address.state, user_ip_address.mac_address, user_ip_address.source_network_id, user_ip_address.network_id, user_ip_address.uuid, user_ip_address.physical_network_id, user_ip_address.is_system, user_ip_address.vpc_id, user_ip_address.dnat_vmip, user_ip_address.is_portable, user_ip_address.display, user_ip_address.rule_state, user_ip_address.forsystemvms, user_ip_address.removed, user_ip_address.created FROM user_ip_address  INNER JOIN vlan ON user_ip_address.vlan_db_id=vlan.id WHERE user_ip_address.data_center_id = 1  AND user_ip_address.allocated IS NULL  AND user_ip_address.vlan_db_id IN (3,10,13,14)  AND user_ip_address.forsystemvms = 1  AND user_ip_address.removed IS NULL  AND  (vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC  LIMIT 0, 1 FOR UPDATE
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated FROM configuration WHERE configuration.name = ?  ORDER BY RAND() LIMIT 1

### Trying to get information from the table account_detail for the account "system". Table is empty so no result back

2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT account_details.id, account_details.account_id, account_details.name, account_details.value FROM account_details WHERE account_details.account_id = 1  AND account_details.name = x'7573652E73797374656D2E7075626C69632E697073'  ORDER BY RAND() LIMIT 1
2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated FROM configuration WHERE configuration.name = ?

### Check for Configuration enable.account.settings.for.domain --> current value = false

2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated FROM configuration WHERE configuration.name = x'656E61626C652E6163636F756E742E73657474696E67732E666F722E646F6D61696E'  ORDER BY RAND() LIMIT 1
2022-08-31 18:44:21,217 WARN  [c.c.n.IpAddressManagerImpl] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Unable to get ip address in  zone id=1, vlanId id=[3, 10, 13, 14]
2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction: consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB connection
2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT data_center.id, data_center.name, data_center.description, data_center.dns1, data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1, data_center.internal_dns2, data_center.router_mac_address, data_center.guest_network_cidr, data_center.domain_id, data_center.domain, data_center.networktype, data_center.dns_provider, data_center.dhcp_provider, data_center.gateway_provider, data_center.vpn_provider, data_center.userdata_provider, data_center.lb_provider, data_center.firewall_provider, data_center.mac_address, data_center.zone_token, data_center.removed, data_center.allocation_state, data_center.uuid, data_center.is_security_group_enabled, data_center.is_local_storage_enabled, data_center.sort_key FROM data_center WHERE data_center.id = ?  AND data_center.removed IS NULL

### Check for setting use.system.public.ips --> current value = false

2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated FROM configuration WHERE configuration.name = x'7573652E73797374656D2E7075626C69632E697073'

### getting information for the current data_center / zone

2022-08-31 18:44:21,219 TRACE [c.c.u.d.T.Statement] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT data_center.id, data_center.name, data_center.description, data_center.dns1, data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1, data_center.internal_dns2, data_center.router_mac_address, data_center.guest_network_cidr, data_center.domain_id, data_center.domain, data_center.networktype, data_center.dns_provider, data_center.dhcp_provider, data_center.gateway_provider, data_center.vpn_provider, data_center.userdata_provider, data_center.lb_provider, data_center.firewall_provider, data_center.mac_address, data_center.zone_token, data_center.removed, data_center.allocation_state, data_center.uuid, data_center.is_security_group_enabled, data_center.is_local_storage_enabled, data_center.sort_key FROM data_center WHERE data_center.id = 1  AND data_center.removed IS NULL
2022-08-31 18:44:21,219 DEBUG [c.c.u.d.T.Transaction] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Rolling back the transaction: Time = 17 Name =  consoleproxy-1; called by -TransactionLegacy.rollback:888-TransactionLegacy.removeUpTo:831-TransactionLegacy.close:655-Transaction.execute:38-IpAddressManagerImpl.listAvailablePublicIps:824-IpAddressManagerImpl.fetchNewPublicIp:811-IpAddressManagerImpl.fetchNewPublicIp:803-IpAddressManagerImpl.assignPublicIpAddress:784-PublicNetworkGuru.getIp:125-PublicNetworkGuru.allocate:172-NetworkOrchestrator.allocateNic:973-NetworkOrchestrator$3.addRequestedNicToNicListWithDeviceNumberAndRetrieveDefaultDevice:823
2022-08-31 18:44:21,219 TRACE [c.c.u.d.T.Lock] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) SQL com.mysql.cj.jdbc.ClientPreparedStatement: SELECT user_ip_address.id, user_ip_address.account_id, user_ip_address.domain_id, user_ip_address.public_ip_address, user_ip_address.data_center_id, user_ip_address.source_nat, user_ip_address.allocated, user_ip_address.vlan_db_id, user_ip_address.one_to_one_nat, user_ip_address.vm_id, user_ip_address.state, user_ip_address.mac_address, user_ip_address.source_network_id, user_ip_address.network_id, user_ip_address.uuid, user_ip_address.physical_network_id, user_ip_address.is_system, user_ip_address.vpc_id, user_ip_address.dnat_vmip, user_ip_address.is_portable, user_ip_address.display, user_ip_address.rule_state, user_ip_address.forsystemvms, user_ip_address.removed, user_ip_address.created FROM user_ip_address  INNER JOIN vlan ON user_ip_address.vlan_db_id=vlan.id WHERE user_ip_address.data_center_id = 1  AND user_ip_address.allocated IS NULL  AND user_ip_address.vlan_db_id IN (3,10,13,14)  AND user_ip_address.forsystemvms = 1  AND user_ip_address.removed IS NULL  AND  (vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC  LIMIT 0, 1 FOR UPDATE  took 4
2022-08-31 18:44:21,219 TRACE [c.c.u.d.T.Connection] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing DB connection: dbconn623913035
2022-08-31 18:44:21,220 WARN  [c.c.c.ConsoleProxyManagerImpl] (consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Unable to allocate proxy [Console VM instance {id: "86", name: "v-86-VM", uuid: "6f77acb4-c65e-49e8-ae03-1175b3974412", type="ConsoleProxy"}] on zone [1] due to [Insufficient address capacity].
com.cloud.exception.InsufficientAddressCapacityException: Insufficient address capacityScope=interface com.cloud.dc.DataCenter; id=1

@Hudratronium mine was a new env. Maybe will check with upgrade

@shwstppr
at least it occurs to me that in my current setup the missing entry in the cloud.domain_vlan_map seems to be the crucial thing missing.
I can create a new dedicated range for the domain but it isn't represented in the cloud.domain_vlan_map table. Which seems to be crucial in the overall "search" for a fitting IP-Range. I don't know why this isn't updated / the existing configuration doesn't work out anymore.
Maybe some more infos regarding our global conf:
use.system.public.ips = false
system.vm.public.reservation.mode.strictness = true
From my reading of the trace-log above the process ist:

Check if the account has dedicated vlans --> result is "none"
Check if the domain has dedicated vlans --> results are all vlan for a domain, but missing the one for use with systemVMs as it isn't present in cloud.domain_vlan_map
Check if there are any vlans NOT assigned to a account or domain --> result it the correct VLAN (guess that would be the check if there is a "systempool") --> not choosen as use.system.public.ips = false
Looking up setting strictness  --> if true only domain related VLANs shall be checked / user_ip_address.forsystemvms setting is irrelevant
lookup IPs - depenending on assigned vlans of the domain -  and check for IPs which are not assigned and user_ip_address.forsystemvms = 1 --> fails as the "correct" vlan isn't in the results of the former querys as it is missing in db table

@Hudratronium can you please share logs/API call for adding the new ip range. Also, the cmk output of list vlanipranges
I don't think there should be an entry in cloud.domain_vlan_map when the range is reserved for system vms. Entry in this table is added only when the following code conditions are met for the range
                } else if (domain != null && !forSystemVms) {
                    // This VLAN is domain-wide, so create a DomainVlanMapVO entry
                    final DomainVlanMapVO domainVlanMapVO = new DomainVlanMapVO(domain.getId(), vlan.getId());
                    _domainVlanMapDao.persist(domainVlanMapVO);
                } else if (podId != null) {
                    // This VLAN is pod-wide, so create a PodVlanMapVO entry
                    final PodVlanMapVO podVlanMapVO = new PodVlanMapVO(podId, vlan.getId());
                    podVlanMapDao.persist(podVlanMapVO);
                }

So the range is dedicated to a domain only when it is not marked for systemvms. Error could be due to the fact that the range is not marked for systemvms but assigned to a domain which prevents listing its IPs from user.cloud_ip_address when CPVM is created.

@shwstppr
Just to be shure:
And with system.vm.public.reservation.mode.strictness = "true" and use.system.public.ips = "false" the deployment worked for you?
Have you more then the Root Domain deployed in your zone?
As i said i am just curious as this configuration has been working until i upgraded twards <IP_ADDRESS>. Might be that something went wrong during the upgrade of the Management-Server.
However from the logs of the SQL - statements everything is working as one would expected from a logical point.

When For system VMs is selected in the UI it correctly marks the IPs from the range for system VMs even when domain is selected (also with API, https://github.com/apache/cloudstack/issues/6698#issuecomment-1236621729).

It does indeed - but that doesn't help when during the allocationprocess the group of vlans gathered for a domain isn't containing the vlan-id, which is used to reference to the IP range  (IP - addresses) dedicated to systemVMs.
From the GUI point of view literally nothing has changed after the upgrade and everything is shown correctly.
Maybe you could share a log of the deploying sequence with "trace"-logging so that i can look up to it if they differ ?

Traditionally, I don't see any linkage between domain and system VMs.
At least from the overall architecture in my understanding this is going to be relevant if one is working with mulitple zones as well as "Dedicated Zones" for different Domains / Accounts - depending of course on what one wants to achieve.

@nvazquez just mentioning you here as you asked me to raise the issue and i don't know if i informed you about this on the mailinglist

Thanks @Hudratronium - I will book some time to try replicating it for an upgraded environment

@nvazquez
Did you found some time to look into this? As we are planning our schedule for the next CS Upgrades, i just wanted to be shure to provide valid information if needed.

@nvazquez
Just asking if you might see any chance to take a look into this topic?
As we are planning the next upgrade, i won't be able to give informations for this CS Version after the end of the month.

@shwstppr @nvazquez this is critical for <IP_ADDRESS>, it is reproducible?

@Hudratronium is this still an issue?
Are new dedications possible?

@DaanHoogland
As we haven't upgraded to a newer release - no, no update on this. Still the same behaviour as well as the above mentionend SQL statements.

@Hudratronium
it is normal you cannot find related records in domain_vlan_map or account_vlan_map.
can you share the result of the following mysql query ?
select public_ip_address,state,forsystemvms from user_ip_address join vlan on user_ip_address.vlan_db_id = vlan.id and vlan.uuid='adc15744-9b35-4bea-81f0-1fdbd5b544f3';

hi @weizhouapache
here the output of the sql-statement you requested:

public_ip_address
state
forsystemvms
removed

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

<IP_ADDRESS>
Free
1

Which are the IPs intended to use for public usage

looks good @Hudratronium
What about the following query? (copied from your log)
If it returns empty, try without some of the conditions
SELECT user_ip_address.* FROM user_ip_address  INNER JOIN vlan ON user_ip_address.vlan_db_id=vlan.id WHERE user_ip_address.data_center_id = 1  AND user_ip_address.allocated IS NULL  AND user_ip_address.vlan_db_id IN (3,10,13,14)  AND user_ip_address.forsystemvms = 1  AND user_ip_address.removed IS NULL  AND  (vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC

@weizhouapache
Tried it and results are as to be expected:
SELECT user_ip_address.* FROM user_ip_address  INNER JOIN vlan ON user_ip_address.vlan_db_id=vlan.id WHERE user_ip_address.data_center_id = 1  AND user_ip_address.allocated IS NULL  AND user_ip_address.vlan_db_id IN (3,10,13,14)  AND user_ip_address.forsystemvms = 1  AND user_ip_address.removed IS NULL  AND  (vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC
Return empty - no results
Removing the 'user_ip_address.vlan_db_id IN (3,10,13,14)' condition does the trick and the intended IP-Range is given back as a result.

@Hudratronium
so it looks the intended Ips (<IP_ADDRESS>-<IP_ADDRESS>) donot belong to  the vlans (3,10,13,14).
the vlans are returned by
SELECT vlan.id, vlan.vlan_id, vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway, vlan.ip6_cidr, vlan.data_center_id, vlan.ip4_range, vlan.ip6_range, vlan.network_id, vlan.physical_network_id, vlan.vlan_type, vlan.uuid, vlan.removed, vlan.created FROM vlan  LEFT OUTER JOIN domain_vlan_map ON vlan.id=domain_vlan_map.vlan_db_id  LEFT OUTER JOIN account_vlan_map ON vlan.id=account_vlan_map.vlan_db_id WHERE vlan.data_center_id = 1  AND vlan.removed IS NULL  AND  (domain_vlan_map.domain_id IS NULL ) AND (account_vlan_map.account_id IS NULL );

if the intended vlan is not  dedicated to an account (check account_vlan_map table), the intended vlan might be dedicated to domain. please check the domain_vlan_map.

They are returned and the Query returns all vlans which a exclusiv for the usage of systemvms - numbers '9'we and '17'.
These are not present - neither in 'account_vlan_map' nor 'domain_vlan_map'. And as you wrote above - that is to be expected.
However  - as written beforehand (https://github.com/apache/cloudstack/issues/6698#issuecomment-1237019304) -
That's where i find the concept or nameing a bit confusing. Looking at the sql from my instance there is currently no way that this is going to work as intended and the nameing in the gui itself is to some degree misleading.

The Query returns all vlans which are exclusiv for the usage of systemvms - numbers '9'we and '17' and are shown in the gui as 'domain = root' and 'account = system'. Like the screenshot in the post above https://github.com/apache/cloudstack/issues/6698#issuecomment-1237019304 These VLANs are not present - neither in 'account_vlan_map' nor 'domain_vlan_map'. And as you wrote above - that is to be expected.
However - as written beforehand (#6698 (comment)) - That's where i find the concept or nameing a bit confusing. Looking at the sql from my instance there is currently no way that this is going to work as intended and the nameing in the gui itself is to some degree misleading.

thanks @Hudratronium , for all the information.
I can reproduce the issue if
(1) use.system.public.ips = true
(2) system.vm.public.ip.reservation.mode.strictness = true
(3) there is a dedicated IP range for ROOT domain
(4) there is a dedicated IP range for SystemVMs
Your comment in https://github.com/apache/cloudstack/issues/6698#issuecomment-1236740037 is correct.
We need to add a record in account_vlan_map (for ROOT/system) or change the logic of picking up a public ip address.
I will look into it.

ping @shwstppr @weizhouapache @DaanHoogland

@rohityadavcloud
PR #7144 has been added to <IP_ADDRESS> milestone

I can reproduce the issue if
(1) use.system.public.ips = true
(2) system.vm.public.ip.reservation.mode.strictness = true
(3) there is a dedicated IP range for ROOT domain
(4) there is a dedicated IP range for SystemVMs

Your comment in https://github.com/apache/cloudstack/issues/6698#issuecomment-1236740037 is correct.
We need to add a record in account_vlan_map (for ROOT/system) or change the logic of picking up a public ip address.
I will look into it.

@DaanHoogland
I am able to reproduce the issue.
notes

use.system.public.ips = false
restart management server after global configuration changes

fixed by #7144


create conn pool for sslocal, with r2d2 or other pool lib

The current shadowsocks-rust implement not very fast. because the conn will be init if needed.
If we want to boost the conn performance, we need conn pool , Once we need conn, just get one from conn pool. it will be faster than the current.

Example code
use std::thread;

extern crate r2d2;
extern crate r2d2_foodb;

fn main() {
    let config = r2d2::Config::builder()
        .pool_size(15)
        .build();
    let manager = r2d2_foodb::FooConnectionManager::new("localhost:1234");

    let pool = r2d2::Pool::new(config, manager).unwrap();

    for _ in 0..20 {
        let pool = pool.clone();
        thread::spawn(move || {
            let conn = pool.get().unwrap();
            // use the connection
            // it will be returned to the pool when it falls out of scope.
        })
    }
}

The current proxy connect code

fn connect_proxy_server(svr_cfg: Rc<ServerConfig>) -> BoxIoFuture<TcpStream> {
    let timeout = *svr_cfg.timeout();
    trace!(
        "Connecting to proxy {:?}, timeout: {:?}",
        svr_cfg.addr(),
        timeout
    );
    match *svr_cfg.addr() {
        ServerAddr::SocketAddr(ref addr) => {
            Context::with(|ctx| {
                let handle = ctx.handle();
                try_timeout(TcpStream::connect(addr, handle), timeout, handle)
            })
        }
        ServerAddr::DomainName(ref domain, port) => {
            let fut = Context::with(|ctx| {
                let handle = ctx.handle();
                try_timeout(resolve(&domain[..], &handle), timeout, &handle).and_then(move |sockaddr| {
                    let sockaddr = match sockaddr {
                        IpAddr::V4(v4) => SocketAddr::V4(SocketAddrV4::new(v4, port)),
                        IpAddr::V6(v6) => SocketAddr::V6(SocketAddrV6::new(v6, port, 0, 0)),
                    };

                    Context::with(|ctx| {
                        let handle = ctx.handle();
                        try_timeout(TcpStream::connect(&sockaddr, &handle), timeout, &handle)
                    })
                })
            });
            boxed_future(fut)
        }
    }
}

Hmm. I don't think this implementation will be compliant with the common shadowsocks' server implementation.
Shadowsocks' server protocol requires a header for every connection, which contains the actual remote address that you are willing to connect. If you put that connection in a pool, when to send that header?

One possible solution may be uses target remote addresses as keys to cache those connections. It will works for most http connections that supports keep alive. But .. if one connection that supports keep alive, browser won't close it immediately. So ... hmm

300s time out. then auto close it..
seems this should be a SIP draft to shadowsocks.org


GEM-150 Changed article section header color to grey. Reduced font size.

@saeedmb8 @KaitCrawford
Also removed section icon on article page. (bug introduced in GEM-137)

:+1:


README.md modified

The paths were changed from absolute to relative.

Coverage remained the same at 100.0% when pulling 0cd3d080159493ec40841a9319fb18d61ede22cb on divyankkarolia97:devel into f0a8915ac0f57e1f42b8e96184226795beb86ae9 on BondAnthony:devel.

Thank you @divyankkarolia97


Title:Rock-Paper-Scissors game

Which pre-existing JavaScript project will you be working on?
I would like to add Rock-Paper-Scissors game, which created a good practice of concepts for me while learning Javascript.
Describe your enhancement/improvement

Choose your move by clicking on one of the three buttons:
Rock (👊)
Paper (✋)
Scissors (✌)
The computer will also make its move.
3.The winner is determined by the following rules:
Rock crushes Scissors
Scissors cuts Paper
Paper covers Rock
4.The result of each round will be displayed:
"YOU WIN" if you win the round
"YOU LOSE" if you lose the round
"IT'S A TIE" if both you and the computer choose the same move

Add any other context or relevant screenshots about the enhancement here.

please assign this issue to me under GSSOC'24

@SunayP Thank you for providing your insight but it is not required as of now


expect.hasAssertions should not accept arguments

Do you want to request a feature or report a bug?
Feature
What is the current behavior?
Calling expect.hasAssertions(3) results in no change from the behavior of expect.hasAssertions(). This is confusing with the expect.assertions(<n>) API that does change based on the parameters.

Please provide your exact Jest configuration and mention your Jest, node, yarn/npm version and operating system.

<EMAIL_ADDRESS><EMAIL_ADDRESS><EMAIL_ADDRESS><EMAIL_ADDRESS><EMAIL_ADDRESS>

You are right! It should throw – do you want to send a pull request for us? :)


loadable extension fails on ubuntu when loaded into python3

works on osx and windowz. 🤷♂
Debugging.

The loadable extension works fine in nodejs on ubuntu.
I wonder if Python's sqlite build is omitting certain functions that crsqlite depends on.

Linux builds are linking against the wrong stdc lib and incorrectly allocating memory in strdup as a result.

fixed by 582c53d77b98b98b8b8e3654364d5fdf90a821de
now to understand why Linux SELECT quote(c) returns a different result than SELECT quote(c) on mac.