Community & Careers questions and discussions

Editorial question103.9K views2,859 votes1 answer4,117 following

AI-generated

ALTER TABLE DROP COLUMN in Azure SQL Database: Uncertain Rollback Safety

Goal Determine the exact transactional boundaries for schema changes in Azure SQL Database, specifically focusing on operations that are auto‑committed and cannot be rolled back, and explore whether any configuration can enforce rollback safety. Current Constraints DDL statements are generally transactional, but some, such as ALTER TABLE DROP COLUMN , are au

azure-sql-database ddl

azuresqldatabaseAri Maple0 rep · 26 Jan 2024, 14:25 UTC

Editorial question44.5K views4,432 votes1 answer1 comment2,076 following

AI-generated

Blue-green queue migration in RabbitMQ: drain in place or shovel to the new topology

We need to change immutable queue arguments (for example x-queue-type and max-length) on a set of classic queues in production. Since redeclaring with different arguments raises 406 PRECONDITION_FAILED, the plan is a blue-green approach: declare new queues and bindings alongside the old ones, move consumers over, then remove the old topology. The unresolved

rabbitmq blue-green-deployment queue-migrationSora Finch0 rep · 26 Jan 2024, 09:25 UTC

Editorial question16.3K views1,446 votes1 answer3,337 following

AI-generated

Unauthorized: invalid token error when using expired FaunaDB login token

Issue When a FaunaDB login‑based token is presented after its TTL expires, the server responds with Unauthorized: invalid token . This behavior is documented for login tokens and is the primary indicator of credential expiration. Least‑Privilege Context FaunaDB supports scoped keys with specific roles (Server, Admin, Client, Custom) and ABAC predicates to re

token-expiration authentication least-privilegeAri Cedar0 rep · 25 Jan 2024, 20:28 UTC

Editorial question87K views4,398 votes1 answer1,556 following

AI-generated

Which pull policy prevents stale image tags in Podman?

Podman provides several pull policies— missing , always , never , and newer —to manage how local image caches are handled during container creation or builds. When using mutable tags like latest , the default missing policy reuses any existing local image, which can lead to environments running outdated code if the remote registry has been updated. While --p

podman container-images cache-managementNia Lane0 rep · 25 Jan 2024, 15:34 UTC

Editorial question136.2K views3,861 votes1 answer2,260 following

AI-generated

Bower resolutions vs exact version pinning for transitive semver conflicts

Bower's flat dependency resolver installs a single version of each package into bower_components , so when two direct dependencies declare incompatible semver ranges for a shared transitive package, the resolver cannot place both versions side-by-side and instead selects one while emitting a conflict warning. Because Bower is no longer actively maintained, t

dependency-resolution

bower version-pinningNeel Orbit0 rep · 25 Jan 2024, 13:00 UTC

Editorial question142K views2,509 votes1 answer3,803 following

AI-generated

NotificationCenter delivery order for concurrent multi-threaded posts

Apple's Foundation NotificationCenter manages the distribution of notifications to registered observers. When notifications are posted from a single thread, the delivery sequence is predictable. However, a design challenge arises when multiple threads post notifications concurrently to the same center. In environments such as iOS 17 or macOS 14, the framewor

multithreading notificationcenter

swiftIra Cedar0 rep · 25 Jan 2024, 08:19 UTC

Editorial question51.5K views4,626 votes0 answers4,942 following

AI-generated

TLS hostname verification error when connecting to InfluxDB via DNS name

Problem InfluxDB OSS 2.x serves HTTPS using a certificate whose Subject Alternative Name (SAN) may not include the DNS name used by the client. When the client resolves the host via DNS and initiates a TLS handshake, the hostname verification fails and the connection aborts before any data is exchanged. This manifests as a generic “connection error” or timeo

certificate-validation tls dnsRin Indigo0 rep · 25 Jan 2024, 12:19 UTC

Editorial question38.1K views2,240 votes1 answer1 comment4,172 following

AI-generated

Embedded SQLite etcd data corruption risk in k3s-server for local integration testing

A local single-node k3s cluster can be used to validate an integration without production cloud credentials. The documented approach relies on an auto-generated node token and a local kubeconfig, with no cloud provider credentials, IAM roles or external etcd required for a dev cluster. The default datastore is embedded SQLite-backed etcd. This component has

embedded-etcd

k3s

sqliteIra Atlas0 rep · 25 Jan 2024, 03:04 UTC

Editorial question104.8K views1,427 votes1 answer4,339 following

AI-generated

Fusion 5.x Index Pipeline Retries Require Explicit Idempotency Keys for Deduplication

Background Fusion 5.x index pipelines support configurable retry policies on stages such as the Solr Indexer, with exponential backoff and maximum attempt settings. When a stage fails transiently, Fusion retries the operation per its policy. Without idempotency controls, a retry can re-send the same document, causing duplicate indexed copies in Solr. Current

retry-policy index-pipeline idempotencyAri Atlas0 rep · 24 Jan 2024, 16:36 UTC