Error Codes Reference | Geode Database

Geode follows ISO/IEC SQL error code standards for consistent error reporting across all client libraries and interfaces. This reference provides complete documentation of all error codes, their meanings, and resolution strategies. <h3 id="error-code-format" class="position-relative d-flex align-items-center group"> Error Code Format <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="error-code-format" aria-haspopup="dialog" aria-label="Share link: Error Code Format"> Share link </button> </h3><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>Geode uses two types of error codes: <ol> <li>GQLSTATUS Codes: 5-character SQL-standard status codes (e.g., <code>00000</code>, <code>42000</code>)</li> <li>Internal Error Codes: Descriptive error names (e.g., <code>ERR_OOM</code>, <code>ERR_FLOAT_NAN</code>)</li> </ol> <h4 id="error-response-structure" class="position-relative d-flex align-items-center group"> Error Response Structure <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="error-response-structure" aria-haspopup="dialog" aria-label="Share link: Error Response Structure"> Share link </button> </h4>All error responses follow this JSON format: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "status_class": "42000", "status": "42001", "message": "Undefined table: NonExistentTable", "details": { "table_name": "NonExistentTable", "suggestion": "Check table name spelling or create the table first" } } </code></pre></div> <h3 id="gqlstatus-codes" class="position-relative d-flex align-items-center group"> GQLSTATUS Codes <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="gqlstatus-codes" aria-haspopup="dialog" aria-label="Share link: GQLSTATUS Codes"> Share link </button> </h3> <h4 id="success-codes" class="position-relative d-flex align-items-center group"> Success Codes <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="success-codes" aria-haspopup="dialog" aria-label="Share link: Success Codes"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Class</th> <th>Description</th> <th>Action Required</th> </tr> </thead> <tbody> <tr> <td><code>00000</code></td> <td>Success</td> <td>Query executed successfully</td> <td>None</td> </tr> <tr> <td><code>01000</code></td> <td>Warning</td> <td>Warning (with successful completion)</td> <td>Review warning message</td> </tr> <tr> <td><code>02000</code></td> <td>No Data</td> <td>Query returned no rows</td> <td>None (expected in some cases)</td> </tr> </tbody> </table> Example: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Returns 00000 on success CREATE (p:Person {name: 'Alice'}); -- Returns 02000 if no matches MATCH (p:Person {name: 'NonExistent'}) RETURN p; </code></pre></div> <h4 id="client-errors-class-0a" class="position-relative d-flex align-items-center group"> Client Errors (Class 0A) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="client-errors-class-0a" aria-haspopup="dialog" aria-label="Share link: Client Errors (Class 0A)"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> <th>Common Causes</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>0A000</code></td> <td>Feature not supported</td> <td>Unsupported GQL feature or operation</td> <td>Check GQL compliance documentation</td> </tr> <tr> <td><code>0A001</code></td> <td>Transaction already active</td> <td>BEGIN called while transaction active</td> <td>COMMIT or ROLLBACK current transaction first</td> </tr> <tr> <td><code>0A002</code></td> <td>No active transaction</td> <td>COMMIT/ROLLBACK without BEGIN</td> <td>Start transaction with BEGIN before committing</td> </tr> </tbody> </table> Examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- 0A001: Transaction already active BEGIN TRANSACTION; BEGIN TRANSACTION; -- ERROR -- 0A002: No active transaction COMMIT; -- ERROR (no transaction started) -- Correct usage BEGIN TRANSACTION; CREATE (p:Person {name: 'Bob'}); COMMIT; </code></pre></div> <h4 id="data-exception-class-22" class="position-relative d-flex align-items-center group"> Data Exception (Class 22) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="data-exception-class-22" aria-haspopup="dialog" aria-label="Share link: Data Exception (Class 22)"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> <th>Common Causes</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>22000</code></td> <td>Data exception</td> <td>General data error</td> <td>See specific code</td> </tr> <tr> <td><code>22001</code></td> <td>String data, right truncation</td> <td>String exceeds maximum length</td> <td>Reduce string length or increase limit</td> </tr> <tr> <td><code>22002</code></td> <td>Null value, no indicator</td> <td>NULL in non-nullable context</td> <td>Provide non-null value</td> </tr> <tr> <td><code>22003</code></td> <td>Numeric value out of range</td> <td>Number too large/small for type</td> <td>Use appropriate numeric type</td> </tr> <tr> <td><code>22004</code></td> <td>Null value not allowed</td> <td>NULL where NOT NULL constraint exists</td> <td>Provide non-null value</td> </tr> <tr> <td><code>22005</code></td> <td>Error in assignment</td> <td>Type mismatch in assignment</td> <td>Check type compatibility</td> </tr> <tr> <td><code>22007</code></td> <td>Invalid datetime format</td> <td>Malformed date/time string</td> <td>Use ISO 8601 format</td> </tr> <tr> <td><code>22008</code></td> <td>Datetime field overflow</td> <td>Date/time value out of valid range</td> <td>Check date/time bounds</td> </tr> <tr> <td><code>22012</code></td> <td>Division by zero</td> <td>Arithmetic division by zero</td> <td>Add zero check before division</td> </tr> <tr> <td><code>22015</code></td> <td>Interval field overflow</td> <td>Interval exceeds maximum</td> <td>Use smaller interval</td> </tr> <tr> <td><code>22018</code></td> <td>Invalid character value</td> <td>Invalid encoding or character</td> <td>Check string encoding (UTF-8)</td> </tr> <tr> <td><code>22019</code></td> <td>Invalid escape character</td> <td>Bad escape sequence in string</td> <td>Use valid escape sequences</td> </tr> <tr> <td><code>22021</code></td> <td>Character not in repertoire</td> <td>Character not supported in encoding</td> <td>Use supported UTF-8 characters</td> </tr> <tr> <td><code>22023</code></td> <td>Invalid parameter value</td> <td>Function parameter invalid</td> <td>Check parameter constraints</td> </tr> <tr> <td><code>22025</code></td> <td>Invalid escape sequence</td> <td>Bad regex or LIKE escape</td> <td>Fix escape sequence</td> </tr> <tr> <td><code>22027</code></td> <td>Trim error</td> <td>Invalid TRIM specification</td> <td>Check TRIM syntax</td> </tr> </tbody> </table> Examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- 22001: String truncation CREATE (p:Person {name: Char('VeryLongNameThatExceedsLimit', 10)}); -- ERROR: String 'VeryLongNameThatExceedsLimit' exceeds Char(10) limit -- 22003: Numeric out of range RETURN SmallInt(100000); -- ERROR: Value exceeds i16 range -- 22007: Invalid datetime RETURN Date('invalid-date'); -- ERROR -- 22012: Division by zero RETURN 10 / 0; -- ERROR -- Correct usage RETURN 10 / CASE WHEN $divisor = 0 THEN 1 ELSE $divisor END; </code></pre></div> <h4 id="integrity-constraint-violation-class-23" class="position-relative d-flex align-items-center group"> Integrity Constraint Violation (Class 23) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="integrity-constraint-violation-class-23" aria-haspopup="dialog" aria-label="Share link: Integrity Constraint Violation (Class 23)"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> <th>Common Causes</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>23000</code></td> <td>Integrity constraint violation</td> <td>General constraint violation</td> <td>See specific code</td> </tr> <tr> <td><code>23001</code></td> <td>Restrict violation</td> <td>Foreign key constraint prevents delete</td> <td>Delete dependent records first</td> </tr> <tr> <td><code>23502</code></td> <td>Not null violation</td> <td>NULL value in NOT NULL column</td> <td>Provide non-null value</td> </tr> <tr> <td><code>23503</code></td> <td>Foreign key violation</td> <td>Referenced record doesn’t exist</td> <td>Create referenced record first</td> </tr> <tr> <td><code>23505</code></td> <td>Unique violation</td> <td>Duplicate value in unique index</td> <td>Use unique value</td> </tr> <tr> <td><code>23514</code></td> <td>Check constraint violation</td> <td>Value fails CHECK constraint</td> <td>Provide valid value</td> </tr> </tbody> </table> Examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- 23502: Not null violation CREATE (p:Person {age: null}); -- ERROR if age has NOT NULL constraint -- 23505: Unique violation CREATE (p1:Person {email: '[email protected]'}); CREATE (p2:Person {email: '[email protected]'}); -- ERROR if email is UNIQUE -- 23503: Foreign key violation CREATE (o:Order {customer_id: 999}); -- ERROR if customer 999 doesn't exist </code></pre></div> <h4 id="syntax-error-or-access-violation-class-42" class="position-relative d-flex align-items-center group"> Syntax Error or Access Violation (Class 42) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="syntax-error-or-access-violation-class-42" aria-haspopup="dialog" aria-label="Share link: Syntax Error or Access Violation (Class 42)"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> <th>Common Causes</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>42000</code></td> <td>Syntax error or access rule violation</td> <td>General syntax error</td> <td>Check GQL syntax</td> </tr> <tr> <td><code>42001</code></td> <td>Undefined object</td> <td>Table, column, or function not found</td> <td>Verify object names</td> </tr> <tr> <td><code>42002</code></td> <td>Duplicate object</td> <td>Object already exists</td> <td>Use IF NOT EXISTS or drop first</td> </tr> <tr> <td><code>42601</code></td> <td>Syntax error</td> <td>Malformed GQL query</td> <td>Fix query syntax</td> </tr> <tr> <td><code>42602</code></td> <td>Invalid name</td> <td>Reserved keyword or invalid identifier</td> <td>Use quotes for identifiers</td> </tr> <tr> <td><code>42611</code></td> <td>Invalid column definition</td> <td>Bad column specification</td> <td>Check column syntax</td> </tr> <tr> <td><code>42701</code></td> <td>Duplicate column</td> <td>Column specified multiple times</td> <td>Remove duplicate</td> </tr> <tr> <td><code>42703</code></td> <td>Undefined column</td> <td>Column doesn’t exist</td> <td>Check column name</td> </tr> <tr> <td><code>42704</code></td> <td>Undefined object</td> <td>Referenced object not found</td> <td>Create object or fix reference</td> </tr> <tr> <td><code>42710</code></td> <td>Duplicate object</td> <td>Object name collision</td> <td>Use unique name</td> </tr> <tr> <td><code>42712</code></td> <td>Duplicate alias</td> <td>Alias used multiple times</td> <td>Use unique aliases</td> </tr> <tr> <td><code>42723</code></td> <td>Duplicate function</td> <td>Function already defined</td> <td>Drop function or use different name</td> </tr> <tr> <td><code>42883</code></td> <td>Undefined function</td> <td>Function not found</td> <td>Check function name and arguments</td> </tr> <tr> <td><code>42939</code></td> <td>Reserved name</td> <td>Using reserved keyword</td> <td>Quote identifier or use different name</td> </tr> <tr> <td><code>42P01</code></td> <td>Undefined table</td> <td>Table doesn’t exist</td> <td>Create table first</td> </tr> <tr> <td><code>42P02</code></td> <td>Undefined parameter</td> <td>Parameter not provided</td> <td>Supply parameter value</td> </tr> <tr> <td><code>42P07</code></td> <td>Duplicate table</td> <td>Table already exists</td> <td>Use IF NOT EXISTS or different name</td> </tr> </tbody> </table> Examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- 42001: Undefined object MATCH (n:NonExistentLabel) RETURN n; -- ERROR: Label 'NonExistentLabel' not found -- 42002: Duplicate object CREATE INDEX person_email ON Person(email); CREATE INDEX person_email ON Person(email); -- ERROR -- 42601: Syntax error MATCH (n) RETURN n WHERE n.age > 30; -- ERROR: WHERE after RETURN -- 42P01: Undefined table MATCH (n:Person) WHERE n.age > 30 RETURN n; -- ERROR if Person label doesn't exist -- Correct: Use IF NOT EXISTS CREATE INDEX IF NOT EXISTS person_email ON Person(email); </code></pre></div> <h4 id="insufficient-resources-class-53" class="position-relative d-flex align-items-center group"> Insufficient Resources (Class 53) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="insufficient-resources-class-53" aria-haspopup="dialog" aria-label="Share link: Insufficient Resources (Class 53)"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> <th>Common Causes</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>53000</code></td> <td>Insufficient resources</td> <td>General resource issue</td> <td>Increase resources or optimize query</td> </tr> <tr> <td><code>53100</code></td> <td>Disk full</td> <td>Out of disk space</td> <td>Free disk space</td> </tr> <tr> <td><code>53200</code></td> <td>Out of memory</td> <td>Insufficient RAM</td> <td>Increase memory or reduce query complexity</td> </tr> <tr> <td><code>53300</code></td> <td>Too many connections</td> <td>Connection pool exhausted</td> <td>Close unused connections or increase pool size</td> </tr> <tr> <td><code>53400</code></td> <td>Configuration limit exceeded</td> <td>Limit setting reached</td> <td>Adjust configuration limits</td> </tr> </tbody> </table> Examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- 53200: Out of memory MATCH (n)-[r*]-(m) -- ERROR: Unbounded path may exhaust memory RETURN n, m; -- Correct: Limit path length MATCH (n)-[r*1..5]-(m) WHERE n.id = 123 RETURN n, m LIMIT 100; </code></pre></div> <h4 id="system-error-class-58" class="position-relative d-flex align-items-center group"> System Error (Class 58) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="system-error-class-58" aria-haspopup="dialog" aria-label="Share link: System Error (Class 58)"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> <th>Common Causes</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>58000</code></td> <td>System error</td> <td>General I/O error</td> <td>Check system logs</td> </tr> <tr> <td><code>58030</code></td> <td>I/O error</td> <td>Disk read/write failure</td> <td>Check disk health</td> </tr> <tr> <td><code>58P01</code></td> <td>Undefined file</td> <td>File not found</td> <td>Verify file path</td> </tr> <tr> <td><code>58P02</code></td> <td>Duplicate file</td> <td>File already exists</td> <td>Delete file or use different path</td> </tr> </tbody> </table> <h4 id="internal-error-class-xx" class="position-relative d-flex align-items-center group"> Internal Error (Class XX) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="internal-error-class-xx" aria-haspopup="dialog" aria-label="Share link: Internal Error (Class XX)"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> <th>Common Causes</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>XX000</code></td> <td>Internal error</td> <td>Database bug</td> <td>Report to developers with reproduction steps</td> </tr> <tr> <td><code>XX001</code></td> <td>Data corrupted</td> <td>Storage corruption</td> <td>Restore from backup</td> </tr> <tr> <td><code>XX002</code></td> <td>Index corrupted</td> <td>Index integrity violation</td> <td>Rebuild index</td> </tr> </tbody> </table> <h3 id="internal-error-codes" class="position-relative d-flex align-items-center group"> Internal Error Codes <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="internal-error-codes" aria-haspopup="dialog" aria-label="Share link: Internal Error Codes"> Share link </button> </h3> <h4 id="memory-errors" class="position-relative d-flex align-items-center group"> Memory Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="memory-errors" aria-haspopup="dialog" aria-label="Share link: Memory Errors"> Share link </button> </h4><table> <thead> <tr> <th>Error Code</th> <th>Description</th> <th>Context</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>ERR_OOM</code></td> <td>Out of memory</td> <td>Memory allocation failed</td> <td>Reduce query complexity or increase system memory</td> </tr> <tr> <td><code>ERR_ALLOCATION_FAILED</code></td> <td>Memory allocation error</td> <td>Allocator returned error</td> <td>Check system resources</td> </tr> </tbody> </table> Example: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- ERR_OOM: Large aggregation without limits MATCH (n)-[r*]-(m) RETURN collect(n) AS all_nodes; -- May cause OOM -- Solution: Add limits MATCH (n)-[r*1..3]-(m) WHERE n.id = 123 RETURN collect(n) AS nearby_nodes LIMIT 1000; </code></pre></div> <h4 id="type-errors" class="position-relative d-flex align-items-center group"> Type Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="type-errors" aria-haspopup="dialog" aria-label="Share link: Type Errors"> Share link </button> </h4><table> <thead> <tr> <th>Error Code</th> <th>Description</th> <th>Context</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>ERR_FLOAT_NAN</code></td> <td>Invalid float (NaN or Inf)</td> <td>Float arithmetic produced NaN/Inf</td> <td>Check for division by zero or invalid operations</td> </tr> <tr> <td><code>ERR_CHAR_LEN</code></td> <td>String exceeds length limit</td> <td>String longer than declared Char(n)</td> <td>Reduce string length or use Varchar/Text</td> </tr> <tr> <td><code>ERR_DEC_DIV_ZERO</code></td> <td>Decimal division by zero</td> <td>Division by zero in Decimal arithmetic</td> <td>Add zero check</td> </tr> <tr> <td><code>ERR_IP_PARSE</code></td> <td>Invalid IP address</td> <td>Malformed IP address string</td> <td>Use valid IPv4/IPv6 format</td> </tr> <tr> <td><code>ERR_JSON_PARSE</code></td> <td>Invalid JSON</td> <td>Malformed JSON string</td> <td>Fix JSON syntax</td> </tr> <tr> <td><code>ERR_RANGE_BOUNDS</code></td> <td>Invalid range bounds</td> <td>Range start > end or invalid inclusive/exclusive</td> <td>Fix range bounds</td> </tr> </tbody> </table> Examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- ERR_FLOAT_NAN RETURN sqrt(-1); -- ERROR: NaN not allowed -- ERR_CHAR_LEN CREATE (p:Person {code: Char('TOOLONG', 5)}); -- ERROR -- ERR_IP_PARSE RETURN IpAddr('999.999.999.999'); -- ERROR -- ERR_JSON_PARSE RETURN Json('{invalid json}'); -- ERROR -- Correct usage RETURN IpAddr('192.168.1.1'); RETURN Json('{"valid": "json"}'); </code></pre></div> <h4 id="index-errors" class="position-relative d-flex align-items-center group"> Index Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="index-errors" aria-haspopup="dialog" aria-label="Share link: Index Errors"> Share link </button> </h4><table> <thead> <tr> <th>Error Code</th> <th>Description</th> <th>Context</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>ERR_INDEX_CORRUPTION</code></td> <td>Index structure corrupted</td> <td>Index integrity check failed</td> <td>Rebuild index</td> </tr> <tr> <td><code>ERR_INDEX_FULL</code></td> <td>Index size limit exceeded</td> <td>Index too large</td> <td>Partition data or increase limits</td> </tr> </tbody> </table> <h4 id="network-errors" class="position-relative d-flex align-items-center group"> Network Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="network-errors" aria-haspopup="dialog" aria-label="Share link: Network Errors"> Share link </button> </h4><table> <thead> <tr> <th>Error Code</th> <th>Description</th> <th>Context</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>ERR_CONNECTION_FAILED</code></td> <td>Connection failure</td> <td>Cannot connect to server</td> <td>Check network and server status</td> </tr> <tr> <td><code>ERR_TIMEOUT</code></td> <td>Operation timeout</td> <td>Query or connection timed out</td> <td>Increase timeout or optimize query</td> </tr> <tr> <td><code>ERR_PROTOCOL_ERROR</code></td> <td>Protocol violation</td> <td>Invalid message format</td> <td>Update client library</td> </tr> </tbody> </table> <h4 id="transaction-errors" class="position-relative d-flex align-items-center group"> Transaction Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="transaction-errors" aria-haspopup="dialog" aria-label="Share link: Transaction Errors"> Share link </button> </h4><table> <thead> <tr> <th>Error Code</th> <th>Description</th> <th>Context</th> <th>Resolution</th> </tr> </thead> <tbody> <tr> <td><code>ERR_TRANSACTION_CONFLICT</code></td> <td>Transaction conflict</td> <td>Concurrent modification conflict</td> <td>Retry transaction</td> </tr> <tr> <td><code>ERR_DEADLOCK</code></td> <td>Deadlock detected</td> <td>Circular lock dependency</td> <td>Retry transaction</td> </tr> <tr> <td><code>ERR_SERIALIZATION_FAILURE</code></td> <td>Serialization failure</td> <td>SSI conflict in SERIALIZABLE isolation</td> <td>Retry transaction</td> </tr> </tbody> </table> Example: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- ERR_TRANSACTION_CONFLICT BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE SNAPSHOT; -- ... operations ... COMMIT; -- May fail with conflict, retry needed -- Retry logic (pseudocode) max_retries = 3 for attempt in range(max_retries): try: execute_transaction() break except ERR_TRANSACTION_CONFLICT: if attempt == max_retries - 1: raise sleep(exponential_backoff(attempt)) </code></pre></div> <h3 id="error-handling-best-practices" class="position-relative d-flex align-items-center group"> Error Handling Best Practices <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="error-handling-best-practices" aria-haspopup="dialog" aria-label="Share link: Error Handling Best Practices"> Share link </button> </h3> <h4 id="check-for-common-errors" class="position-relative d-flex align-items-center group"> Check for Common Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="check-for-common-errors" aria-haspopup="dialog" aria-label="Share link: Check for Common Errors"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Python client example from geode_client import Client, QueryError client = Client(host="localhost", port=3141) async with client.connection() as conn: try: page, _ = await conn.query("MATCH (p:Person) RETURN p") except QueryError as e: message = str(e) if message.startswith("42P01:"): print("Table doesn't exist - creating it") await conn.execute("CREATE (:Person {name: 'Alice'})") elif message.startswith("53200:"): print("Out of memory - reducing query complexity") page, _ = await conn.query("MATCH (p:Person) RETURN p LIMIT 100") else: raise </code></pre></div> <h4 id="retry-transient-errors" class="position-relative d-flex align-items-center group"> Retry Transient Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="retry-transient-errors" aria-haspopup="dialog" aria-label="Share link: Retry Transient Errors"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Go client example import "geodedb.com/geode" func executeWithRetry(db *sql.DB, query string, maxRetries int) error { for i := 0; i < maxRetries; i++ { _, err := db.Exec(query) if err == nil { return nil } // Check if error is retryable if isRetryable(err) { time.Sleep(time.Duration(i*100) * time.Millisecond) continue } return err } return fmt.Errorf("max retries exceeded") } func isRetryable(err error) bool { // Transaction conflicts, deadlocks, timeouts statusCode := extractStatusCode(err) return statusCode == "ERR_TRANSACTION_CONFLICT" || statusCode == "ERR_DEADLOCK" || statusCode == "ERR_TIMEOUT" } </code></pre></div> <h4 id="validate-input-data" class="position-relative d-flex align-items-center group"> Validate Input Data <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="validate-input-data" aria-haspopup="dialog" aria-label="Share link: Validate Input Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">// Rust client example use geode_client::{Connection, Error, Result}; async fn create_person(conn: &mut Connection, name: &str, age: i32) -> Result<()> { // Validate before sending to database if name.is_empty() { return Err(Error::validation("Name cannot be empty")); } if age < 0 || age > 150 { return Err(Error::validation("Age must be 0-150")); } let query = format!("CREATE (p:Person {{name: '{}', age: {}}})", name, age); conn.query(&query).await?; Ok(()) } </code></pre></div> <h4 id="log-errors-for-debugging" class="position-relative d-flex align-items-center group"> Log Errors for Debugging <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="log-errors-for-debugging" aria-haspopup="dialog" aria-label="Share link: Log Errors for Debugging"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Enable detailed error logging -- Set in server configuration logging: level: 'debug' include_stack_traces: true error_details: true </code></pre></div> <h3 id="common-error-scenarios" class="position-relative d-flex align-items-center group"> Common Error Scenarios <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="common-error-scenarios" aria-haspopup="dialog" aria-label="Share link: Common Error Scenarios"> Share link </button> </h3> <h4 id="scenario-1-undefined-label" class="position-relative d-flex align-items-center group"> Scenario 1: Undefined Label <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="scenario-1-undefined-label" aria-haspopup="dialog" aria-label="Share link: Scenario 1: Undefined Label"> Share link </button> </h4>Error: <code>42001 - Undefined object: Label 'Person' not found</code> Cause: Querying non-existent label Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Check if label exists SHOW LABELS; -- Create label by inserting node CREATE (:Person {name: 'Alice'}); -- Then retry query MATCH (p:Person) RETURN p; </code></pre></div> <h4 id="scenario-2-unique-constraint-violation" class="position-relative d-flex align-items-center group"> Scenario 2: Unique Constraint Violation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="scenario-2-unique-constraint-violation" aria-haspopup="dialog" aria-label="Share link: Scenario 2: Unique Constraint Violation"> Share link </button> </h4>Error: <code>23505 - Unique violation: email '[email protected]' already exists</code> Cause: Duplicate value in unique index Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Option 1: Use different value CREATE (p:Person {email: '[email protected]'}); -- Option 2: Update existing record MATCH (p:Person {email: '[email protected]'}) SET p.updated_at = timestamp(); -- Option 3: Use MERGE to update or insert MERGE (p:Person {email: '[email protected]'}) ON CREATE SET p.created_at = timestamp() ON MATCH SET p.updated_at = timestamp(); </code></pre></div> <h4 id="scenario-3-transaction-conflict" class="position-relative d-flex align-items-center group"> Scenario 3: Transaction Conflict <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="scenario-3-transaction-conflict" aria-haspopup="dialog" aria-label="Share link: Scenario 3: Transaction Conflict"> Share link </button> </h4>Error: <code>ERR_TRANSACTION_CONFLICT - Concurrent modification detected</code> Cause: Two transactions modifying same data Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Implement retry with exponential backoff import time from geode_client import Client, QueryError client = Client(host="localhost", port=3141) async def execute_with_retry(conn, query, max_retries=3): for attempt in range(max_retries): try: await conn.begin() await conn.query(query) await conn.commit() return except QueryError: await conn.rollback() if attempt == max_retries - 1: raise time.sleep(0.1 * (2 ** attempt)) # Exponential backoff # async with client.connection() as conn: # await execute_with_retry(conn, "MATCH (n) RETURN count(n)") </code></pre></div> <h4 id="scenario-4-query-timeout" class="position-relative d-flex align-items-center group"> Scenario 4: Query Timeout <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="scenario-4-query-timeout" aria-haspopup="dialog" aria-label="Share link: Scenario 4: Query Timeout"> Share link </button> </h4>Error: <code>ERR_TIMEOUT - Query exceeded timeout (30000ms)</code> Cause: Query too complex or slow Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Original (slow) MATCH (n)-[r*]-(m) RETURN n, m; -- Optimized MATCH (n)-[r*1..3]-(m) WHERE n.id = 123 RETURN n, m LIMIT 100; -- Or increase timeout -- Client configuration: -- timeout_ms: 60000 </code></pre></div> <h3 id="related-documentation" class="position-relative d-flex align-items-center group"> Related Documentation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="related-documentation" aria-haspopup="dialog" aria-label="Share link: Related Documentation"> Share link </button> </h3><ul> <li><a href="/docs/guides/troubleshooting/" >Troubleshooting Guide</a> - Common issues and solutions</li> <li><a href="/docs/query/performance-tuning/" >Query Performance Tuning</a> - Optimize queries to avoid errors</li> <li><a href="/docs/transactions/advanced-patterns/" >Advanced Transaction Patterns</a> - Handle transaction errors</li> <li><a href="/docs/api-reference/" >API Reference</a> - Complete function and error documentation</li> </ul> <h3 id="summary" class="position-relative d-flex align-items-center group"> Summary <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="summary" aria-haspopup="dialog" aria-label="Share link: Summary"> Share link </button> </h3>Geode provides comprehensive error reporting with: <ul> <li>GQLSTATUS Codes: ISO/IEC SQL-standard 5-character codes for interoperability</li> <li>Internal Error Codes: Descriptive error names for specific conditions</li> <li>Detailed Messages: Clear explanations and resolution guidance</li> <li>Structured Errors: JSON format with context and suggestions</li> </ul> Use error codes to: <ol> <li>Identify issues - Understand what went wrong</li> <li>Handle gracefully - Implement retry logic for transient errors</li> <li>Validate input - Prevent errors before they occur</li> <li>Debug efficiently - Use error context to locate root causes</li> </ol> Always check error codes and implement appropriate error handling in production applications.