chore(NamedEvent): Cleanup of Posix NamedEvent and fixes of unit test. #2495

Job	Run time
android-armeabi-v7a-ndk-cmake	8m 8s
android-arm64-v8a-ndk-cmake	8m 10s
linux-gcc-make-armv7l	12m 56s
android-arm64-v8a-ndk-latest-cmake	8m 16s
linux-gcc-cmake	19m 36s
linux-gcc-cmake-unbundled	19m 10s
linux-gcc-make	23m 36s
linux-gcc-make-asan	28m 46s
linux-gcc-make-asan-no-soo	28m 17s
linux-gcc-make-cxx20	26m 46s
linux-gcc-make-tsan	25m 33s
linux-gcc-make-ubsan	35m 21s
linux-emscripten-cmake	4m 57s
linux-gcc-make-cross-armhf	13m 9s
macos-clang-cmake-openssl	24m 33s
macos-clang-cmake-openssl3	24m 35s
macos-clang-cmake-openssl3-visibility-hidden	24m 56s
macos-clang-make	30m 17s
macos-clang-make-visibility-hidden	27m 26s
linux-gcc-make-mongodb	6m 42s
linux-gcc-make-mysql	6m 42s
linux-gcc-make-odbc	11m 30s
linux-gcc-make-postgres	6m 30s
linux-gcc-make-redis	6m 37s
macos-clang-make-openssl3-asan	43m 58s
macos-clang-make-openssl3-tsan	29m 8s
macos-clang-make-openssl3-ubsan	47m 33s
windows-2022-msvc-buildwin-x64	35m 31s
windows-2022-msvc-cmake	22m 33s
linux-gcc-make-sqlite-no-sqlparser	6m 38s
	10h 17m 50s

Provide feedback