user/dev discussion of public-inbox itself
 help / color / mirror / code / Atom feed
Search results ordered by [date|relevance]  view[summary|nested|Atom feed]
thread overview below | download mbox.gz: |
* [PATCH 3/7] overidx: eidx_prep: fix leftover dbh reference
    2021-01-20  5:04  6% ` [PATCH 0/7] lei: fixes piled higher and deeper Eric Wong
@ 2021-01-20  5:04  7% ` Eric Wong
  1 sibling, 0 replies; 2+ results
From: Eric Wong @ 2021-01-20  5:04 UTC (permalink / raw)
  To: meta

Leaving $dbh in another field was causing over.sqlite3 to
remain open after ->dbh_close.  Fix up some minor style
issues while we're at it.
---
 lib/PublicInbox/OverIdx.pm | 8 +++-----
 1 file changed, 3 insertions(+), 5 deletions(-)

diff --git a/lib/PublicInbox/OverIdx.pm b/lib/PublicInbox/OverIdx.pm
index 0a4eb39e..e606dcf5 100644
--- a/lib/PublicInbox/OverIdx.pm
+++ b/lib/PublicInbox/OverIdx.pm
@@ -537,7 +537,7 @@ sub eidx_prep ($) {
 	my ($self) = @_;
 	$self->{-eidx_prep} //= do {
 		my $dbh = $self->dbh;
-		$dbh->do(<<"");
+		$dbh->do(<<'');
 INSERT OR IGNORE INTO counter (key) VALUES ('eidx_docid')
 
 		$dbh->do(<<'');
@@ -574,11 +574,9 @@ CREATE TABLE IF NOT EXISTS eidx_meta (
 		# Currently used for "-extindex --reindex" for Xapian
 		# data, but may be used in more places down the line.
 		$dbh->do(<<'');
-CREATE TABLE IF NOT EXISTS eidxq (
-	docid INTEGER PRIMARY KEY NOT NULL
-)
+CREATE TABLE IF NOT EXISTS eidxq (docid INTEGER PRIMARY KEY NOT NULL)
 
-		$dbh;
+		1;
 	};
 }
 

^ permalink raw reply related	[relevance 7%]

* [PATCH 0/7] lei: fixes piled higher and deeper
  @ 2021-01-20  5:04  6% ` Eric Wong
  2021-01-20  5:04  7% ` [PATCH 3/7] overidx: eidx_prep: fix leftover dbh reference Eric Wong
  1 sibling, 0 replies; 2+ results
From: Eric Wong @ 2021-01-20  5:04 UTC (permalink / raw)
  To: meta

1/7 was necessary on my FreeBSD 11.x VM
2/7 fixes TEST_RUN_MODE=0
3/7 fixes a long-standing (well, several weeks) annoyance
4/7 depended on 3/7, sorta
5/7 should've been done ages ago
6/7 oops :x
7/7 belts and suspenders

Eric Wong (7):
  lei: allow more mbox inode types
  lei: exit code in oneshot mode
  overidx: eidx_prep: fix leftover dbh reference
  lei q: cleanup store initialization
  lei: dump and clear errors.log in daemon mode
  lei_xsearch: keep l2m->{-wq_s1} while preparing query
  lei_to_mail: call PublicInbox::IPC::DESTROY

 lib/PublicInbox/LEI.pm         | 32 +++++++++++++++++++++++++++-----
 lib/PublicInbox/LeiOverview.pm |  6 ++----
 lib/PublicInbox/LeiQuery.pm    | 18 ++++++++----------
 lib/PublicInbox/LeiToMail.pm   |  5 +++--
 lib/PublicInbox/LeiXSearch.pm  |  4 ++--
 lib/PublicInbox/OverIdx.pm     |  8 +++-----
 t/lei.t                        |  8 +++++++-
 7 files changed, 52 insertions(+), 29 deletions(-)


^ permalink raw reply	[relevance 6%]

Results 1-2 of 2 | reverse | options above
-- pct% links below jump to the message on this page, permalinks otherwise --
2021-01-19  9:34     [PATCH 0/9] lei bugfixes and error handling Eric Wong
2021-01-20  5:04  6% ` [PATCH 0/7] lei: fixes piled higher and deeper Eric Wong
2021-01-20  5:04  7% ` [PATCH 3/7] overidx: eidx_prep: fix leftover dbh reference Eric Wong

Code repositories for project(s) associated with this public inbox

	https://80x24.org/public-inbox.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).