Fauxton verification process fails at Create View step - and lots of repeated error lines in log... #4510

leanne63 · 2023-04-03T23:02:49Z

Fauxton verification process fails, showing 'x' at Create View step. It does not continue to the Replication step.

Also, the log is filled with repeated info- and error-level lines.

In checking the CouchDB2.log file in ~/Library/Logs, I found that the log is filled with repeated instances of these two lines:

[info] 2023-04-03T21:47:35.085573Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.2440.66> died normal
[error] 2023-04-03T21:47:35.087808Z couchdb@localhost <0.1084.2> -------- OS Process Error <0.2436.66> :: {os_process_error,{exit_status,134}}

Then, there are some of these groups appearing:

[notice] 2023-04-03T21:51:01.749761Z couchdb@localhost <0.401.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-03T21:51:01.749892Z couchdb@localhost emulator -------- Error in process <0.8878.71> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-03T21:51:01.749972Z couchdb@localhost emulator -------- Error in process <0.8878.71> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

And, finally, here are lines apparently about the verification process intermixed with those others:

[notice] 2023-04-03T21:50:07.336056Z couchdb@localhost <0.214.69> 041f660adc 127.0.0.1:5984 127.0.0.1 undefined GET /verifytestdb 404 ok 1
[notice] 2023-04-03T21:50:07.336276Z couchdb@localhost <0.411.69> 009a907b54 127.0.0.1:5984 127.0.0.1 undefined GET /verifytestdb_replicate 404 ok 0
[error] 2023-04-03T21:50:07.339667Z couchdb@localhost <0.1084.2> -------- OS Process Error <0.27462.69> :: {os_process_error,{exit_status,134}}
[info] 2023-04-03T21:50:07.339691Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27462.69> died normal
[notice] 2023-04-03T21:50:07.341400Z couchdb@localhost <0.214.69> 64545bf0a5 127.0.0.1:5984 127.0.0.1 undefined PUT /verifytestdb 401 ok 0
[error] 2023-04-03T21:50:07.342189Z couchdb@localhost <0.3751.0> -------- OS Process Error <0.27469.69> :: {os_process_error,{exit_status,134}}
[info] 2023-04-03T21:50:07.342217Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27469.69> died normal
[error] 2023-04-03T21:50:07.348370Z couchdb@localhost <0.1084.2> -------- OS Process Error <0.27466.69> :: {os_process_error,{exit_status,134}}
[info] 2023-04-03T21:50:07.348411Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27466.69> died normal
[error] 2023-04-03T21:50:07.351416Z couchdb@localhost <0.3751.0> -------- OS Process Error <0.27470.69> :: {os_process_error,{exit_status,134}}
[info] 2023-04-03T21:50:07.351484Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27470.69> died normal
[notice] 2023-04-03T21:50:07.355236Z couchdb@localhost <0.411.69> 1c4a73b921 127.0.0.1:5984 127.0.0.1 undefined PUT /verifytestdb/test_doc_10 404 ok 2
[notice] 2023-04-03T21:50:07.355561Z couchdb@localhost <0.407.69> 27c052967b 127.0.0.1:5984 127.0.0.1 undefined PUT /verifytestdb/test_doc_20 404 ok 2
[notice] 2023-04-03T21:50:07.355707Z couchdb@localhost <0.26465.69> 9a72e6cec9 127.0.0.1:5984 127.0.0.1 undefined PUT /verifytestdb/test_doc_30 404 ok 2
[notice] 2023-04-03T21:50:07.356616Z couchdb@localhost <0.26473.69> fdb1eaed85 127.0.0.1:5984 127.0.0.1 undefined PUT /verifytestdb/_design/view_check 404 ok 2
[info] 2023-04-03T21:50:07.359986Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27472.69> died normal
[error] 2023-04-03T21:50:07.359998Z couchdb@localhost <0.1084.2> -------- OS Process Error <0.27472.69> :: {os_process_error,{exit_status,134}}
[error] 2023-04-03T21:50:07.364881Z couchdb@localhost <0.3751.0> -------- OS Process Error <0.27474.69> :: {os_process_error,{exit_status,134}}
[info] 2023-04-03T21:50:07.364909Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27474.69> died normal
[error] 2023-04-03T21:50:07.369625Z couchdb@localhost <0.1084.2> -------- OS Process Error <0.27477.69> :: {os_process_error,{exit_status,134}}
[info] 2023-04-03T21:50:07.369660Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27477.69> died normal
[error] 2023-04-03T21:50:07.375000Z couchdb@localhost <0.3751.0> -------- OS Process Error <0.27483.69> :: {os_process_error,{exit_status,134}}
[info] 2023-04-03T21:50:07.375072Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.27483.69> died normal
[notice] 2023-04-03T21:50:07.380836Z couchdb@localhost <0.26471.69> edc773e296 127.0.0.1:5984 127.0.0.1 undefined DELETE /verifytestdb 401 ok 1
[notice] 2023-04-03T21:50:07.381000Z couchdb@localhost <0.26469.69> 78b4bcab32 127.0.0.1:5984 127.0.0.1 undefined DELETE /verifytestdb_replicate 401 ok 1

Steps to Reproduce

Start Fauxton
log in as admin
click the checkmark button to the left (#/verifyinstall) to verify

Expected Behaviour

I would expect the verification process to complete with all checkmarks and no errors. Or, if there is an error, that somewhere information be provided as to how to fix the error.

Your Environment

CouchDB version used: download link says Erlang/OTP 25.1.3 | Version 3.3.1
Browser name and version: Safari Version 16.4 (18615.1.26.11.22)
Operating system and version: macOS Ventura 13.3

Additional Context

There are other Mac users having a similar problem, per this StackOverflow question.

I was able to create a database; however, I haven't tried adding any records yet. I thought I should make sure this verification is working correctly, or I might have problems down the line.

The text was updated successfully, but these errors were encountered:

big-r81 · 2023-04-03T23:19:35Z

Please take a look at #4372.

whosnorman · 2023-04-04T01:52:34Z

Heyo @leanne63 / @big-r81 I found this download link for 3.2.2 by using the wayback machine! After replacing the app in Applications with this one I was able to run through all the verification steps.

leanne63 · 2023-04-04T14:37:33Z

@big-r81, after looking at #4372 (thanks for the related info!), I did the referenced curl statements (from jonathanwork at the bottom) to add the _users and _reference tables. Those both succeeded with the {"ok":true} result.

After adding those tables, I tried the verification process again. It sill stopped at Create View with an x.

My log no longer had any error references to the _users table. However, here's what it did have:

Still had a ton of these:

[info] 2023-04-04T13:42:55.148123Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.14969.3> died normal
[error] 2023-04-04T13:42:55.153570Z couchdb@localhost <0.1978.0> -------- OS Process Error <0.14972.3> :: {os_process_error,{exit_status,134}}
[info] 2023-04-04T13:42:55.153595Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.14972.3> died normal
[error] 2023-04-04T13:42:55.159023Z couchdb@localhost <0.1978.0> -------- OS Process Error <0.14975.3> :: {os_process_error,{exit_status,134}}
[info] 2023-04-04T13:42:55.159045Z couchdb@localhost <0.285.0> -------- couch_proc_manager <0.14975.3> died normal

It had a couple of these:

[error] 2023-04-04T13:54:14.498025Z couchdb@localhost <0.16443.16> -------- gen_server <0.16443.16> terminated with reason: {exit_status,134}
  last msg: redacted
     state: {os_proc,"./bin/couchjs ./share/server/main.js",#Port<0.353813>,fun couch_os_process:writejson/2,fun couch_os_process:readjson/1,5000,300000}
    extra: []
[error] 2023-04-04T13:54:14.498093Z couchdb@localhost <0.16443.16> -------- gen_server <0.16443.16> terminated with reason: {exit_status,134}
  last msg: redacted
     state: {os_proc,"./bin/couchjs ./share/server/main.js",#Port<0.353813>,fun couch_os_process:writejson/2,fun couch_os_process:readjson/1,5000,300000}
    extra: []
	
[error] 2023-04-04T13:54:14.498201Z couchdb@localhost <0.16443.16> -------- CRASH REPORT Process  (<0.16443.16>) with 0 neighbors exited with reason: {exit_status,134} at gen_server:handle_common_reply/8(line:805) <= proc_lib:init_p_do_apply/3(line:226); initial_call: {couch_os_process,init,['Argument__1']}, ancestors: [<0.16442.16>], message_queue_len: 1, links: [<0.285.0>], dictionary: [], trap_exit: false, status: running, heap_size: 1598, stack_size: 28, reductions: 1585

And, finally, the lines seeming to relate to the verification process specifically:

[notice] 2023-04-04T13:53:03.014403Z couchdb@localhost <0.18936.13> be38c3f373 127.0.0.1:5984 127.0.0.1 undefined POST /_session 200 ok 1
[notice] 2023-04-04T13:53:03.019931Z couchdb@localhost <0.18936.13> a731936b81 127.0.0.1:5984 127.0.0.1 admin GET /_session 200 ok 0
[notice] 2023-04-04T13:53:03.339469Z couchdb@localhost <0.18936.13> c847ea8fb7 127.0.0.1:5984 127.0.0.1 admin GET /_all_dbs 200 ok 2
[notice] 2023-04-04T13:53:03.347194Z couchdb@localhost <0.19007.13> c5dd095aa7 127.0.0.1:5984 127.0.0.1 admin GET /_users 200 ok 1
[notice] 2023-04-04T13:53:03.364258Z couchdb@localhost <0.10279.14> 0b92716cde 127.0.0.1:5984 127.0.0.1 admin GET /pers90 200 ok 17
[notice] 2023-04-04T13:53:03.364320Z couchdb@localhost <0.18936.13> 22724ca8fb 127.0.0.1:5984 127.0.0.1 admin GET /_replicator 200 ok 18
[notice] 2023-04-04T13:53:03.737519Z couchdb@localhost <0.18936.13> 82bd308f4e 127.0.0.1:5984 127.0.0.1 admin GET /_all_dbs?startkey=%22%22&endkey=%22%E9%A6%99%22&limit=30 200 ok 1
[notice] 2023-04-04T13:53:14.309856Z couchdb@localhost <0.18936.13> 32298a063b 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb 404 ok 1
[notice] 2023-04-04T13:53:14.309982Z couchdb@localhost <0.19007.13> 34dcede994 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate 404 ok 0
[notice] 2023-04-04T13:53:14.378827Z couchdb@localhost <0.18936.13> a370e97724 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb 201 ok 65
[notice] 2023-04-04T13:53:14.402419Z couchdb@localhost <0.19007.13> 1b645172a5 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_1 201 ok 19
[notice] 2023-04-04T13:53:14.419248Z couchdb@localhost <0.19007.13> 522dbeb904 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_1 201 ok 13
[notice] 2023-04-04T13:53:14.440066Z couchdb@localhost <0.19007.13> 3cabff4ffc 127.0.0.1:5984 127.0.0.1 admin DELETE /verifytestdb/test_doc_1?rev=2-d588d3e93ee155c5afffdf0247a2c5ef 200 ok 17
[notice] 2023-04-04T13:53:14.459130Z couchdb@localhost <0.19007.13> eccfb596bb 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_10 201 ok 15
[notice] 2023-04-04T13:53:14.477635Z couchdb@localhost <0.16841.14> b5b60294ae 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_30 201 ok 28
[notice] 2023-04-04T13:53:14.477633Z couchdb@localhost <0.10279.14> a1c5ffd801 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_20 201 ok 31

[error] 2023-04-04T13:54:14.450752Z couchdb@localhost <0.17922.14> -------- fabric_worker_timeout update_docs,couchdb@localhost,<<"shards/00000000-7fffffff/verifytestdb.1680616394">>
[notice] 2023-04-04T13:54:14.450923Z couchdb@localhost <0.16843.14> a5f147fde7 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/_design/view_check 500 ok 60001
[notice] 2023-04-04T13:54:14.470440Z couchdb@localhost <0.16843.14> 80cac64f8c 127.0.0.1:5984 127.0.0.1 admin DELETE /verifytestdb_replicate 404 ok 1
[notice] 2023-04-04T13:54:14.483810Z couchdb@localhost <0.14377.16> ab90a7f334 127.0.0.1:5984 127.0.0.1 admin DELETE /verifytestdb 200 ok 14

big-r81 · 2023-04-06T18:27:20Z

@leanne63

Hi, if you create the _users database, then the log messages are gone (as you already noticed!).

You need to install the Spidermonkey library, which is normally provided via the macOS .app package but doesn't work with the latest release .

Please install Homebrew and afterwards you can install Spidermonkey with:

brew install spidermonkey

Then you should be able to successful run the "Fauxton verification".

leanne63 · 2023-04-07T04:19:05Z

Is there no way to do this without Homebrew, then? I didn't see that in the requirements, and I try to avoid brew and its ilk (personal weirdness, sorry).

I did see a Mozilla page that had instructions for building spidermonkey on a Mac; however, the links are broken. A newer page exists, but it also says to use brew.

If brew is required, then I'm stuck and you can close this ticket...

big-r81 · 2023-04-07T13:11:57Z

The easiest way is to use Homebrew. You can compile Spidermonkey yourself, but I don't recommend it. If you can wait some time, we will prepare a next release in the near future and maybe this problem will be solved.

leanne63 · 2023-04-07T15:23:04Z

Looking forward to that release! Thanks, @big-r81!

big-r81 · 2023-04-20T16:03:30Z

@leanne63
Would you like to test the new release candidates, if spidermonkey is linked correctly within the app itself?

https://dist.apache.org/repos/dist/dev/couchdb/binary/mac/3.3.2/rc.1/

leanne63 · 2023-04-20T20:32:03Z

Yes! Installed 3.3.2/rc.1 - got this:

I'm unable to login (Name or Password Incorrect message) -

I edited the etc/local.ini in the app contents to add an admin and password.
I made sure to close the Fauxton window and restart CouchDB after setting up the admin info.
The path I used is: /Applications/Apache CouchDB.app/Contents/Resources/couchdbx-core/etc/local.ini
I searched, but don't see a local.ini file anywhere else on my system.
Here are the contents of my local.ini regarding admin setup:

; To create an admin account uncomment the '[admins]' section below and add a
; line in the format 'username = password'. When you next start CouchDB, it
; will change the password to a hash (so that your passwords don't linger
; around in plain-text files). You can add more admin accounts with more
; 'username = password' lines. Don't forget to restart CouchDB after
; changing this.
[admins]
admin1 = password1
;admin = mysecretpassword

The logs are showing this upon startup (without login) -

Despite the line ending in All system databases exist., it seems that the _replicator may still be missing: toward the end of the log is an info line saying: open_result error {not_found,no_db_file} for _replicator
The repeated errors from before are gone.

[info] 2023-04-20T20:18:44.277441Z couchdb@localhost <0.253.0> -------- Preflight check: Checking For Monsters

[info] 2023-04-20T20:18:44.277456Z couchdb@localhost <0.253.0> -------- Preflight check: Asserting Admin Account

[info] 2023-04-20T20:18:44.278843Z couchdb@localhost <0.253.0> -------- Apache CouchDB 3.3.2 is starting.

[info] 2023-04-20T20:18:44.278855Z couchdb@localhost <0.254.0> -------- Starting couch_sup
[info] 2023-04-20T20:18:44.328828Z couchdb@localhost <0.253.0> -------- Apache CouchDB has started. Time to relax.

[notice] 2023-04-20T20:18:44.332081Z couchdb@localhost <0.329.0> -------- rexi_server : started servers
[notice] 2023-04-20T20:18:44.332688Z couchdb@localhost <0.333.0> -------- rexi_buffer : started servers
[notice] 2023-04-20T20:18:44.360944Z couchdb@localhost <0.364.0> -------- mem3_reshard_dbdoc start init()
[notice] 2023-04-20T20:18:44.362506Z couchdb@localhost <0.366.0> -------- mem3_reshard start init()
[notice] 2023-04-20T20:18:44.362521Z couchdb@localhost <0.367.0> -------- mem3_reshard db monitor <0.367.0> starting
[notice] 2023-04-20T20:18:44.363487Z couchdb@localhost <0.366.0> -------- mem3_reshard starting reloading jobs
[notice] 2023-04-20T20:18:44.363539Z couchdb@localhost <0.366.0> -------- mem3_reshard finished reloading jobs
[info] 2023-04-20T20:18:44.476107Z couchdb@localhost <0.373.0> -------- Apache CouchDB has started. Time to relax.

[info] 2023-04-20T20:18:44.476149Z couchdb@localhost <0.373.0> -------- Apache CouchDB has started on http:https://127.0.0.1:5984/
[notice] 2023-04-20T20:18:44.512900Z couchdb@localhost <0.461.0> -------- All system databases exist.
[notice] 2023-04-20T20:18:44.952062Z couchdb@localhost <0.378.0> e69547df93 127.0.0.1:5984 127.0.0.1 undefined GET /_up 200 ok 27
[notice] 2023-04-20T20:18:45.057367Z couchdb@localhost <0.379.0> cf18f6dddb 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/ 304 ok 2
[notice] 2023-04-20T20:18:45.066481Z couchdb@localhost <0.379.0> c93fcfa561 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/js/manifest.f9cde0db85e3cd97708e.js 304 ok 1
[notice] 2023-04-20T20:18:45.067461Z couchdb@localhost <0.380.0> 9b393f932e 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/css/styles.5bda604c70f688307c36.css 304 ok 0
[notice] 2023-04-20T20:18:45.067753Z couchdb@localhost <0.381.0> 8202f7f626 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/css/styles.2fe6f2383b82d9a7610a.css 304 ok 0
[notice] 2023-04-20T20:18:45.068491Z couchdb@localhost <0.382.0> 3d25a5d31c 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/js/bundle.2fe6f2383b82d9a7610a.js 304 ok 1
[notice] 2023-04-20T20:18:45.068615Z couchdb@localhost <0.383.0> 3c2dccac15 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/js/vendor.5bda604c70f688307c36.js 304 ok 1
[notice] 2023-04-20T20:18:45.102974Z couchdb@localhost <0.382.0> 6666d80191 127.0.0.1:5984 127.0.0.1 undefined GET /_session 200 ok 0
[notice] 2023-04-20T20:18:45.105567Z couchdb@localhost <0.382.0> 2ec4a1df1e 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/img/couchdb-logo.png 304 ok 0
[notice] 2023-04-20T20:18:45.106904Z couchdb@localhost <0.379.0> e74811ff4a 127.0.0.1:5984 127.0.0.1 undefined GET / 200 ok 9
[notice] 2023-04-20T20:18:45.106962Z couchdb@localhost <0.381.0> 7a2ff2fe5f 127.0.0.1:5984 127.0.0.1 undefined GET / 200 ok 4
[notice] 2023-04-20T20:18:45.107010Z couchdb@localhost <0.380.0> af4b3eb70c 127.0.0.1:5984 127.0.0.1 undefined GET / 200 ok 4
[notice] 2023-04-20T20:18:45.109006Z couchdb@localhost <0.379.0> 495704a593 127.0.0.1:5984 127.0.0.1 undefined GET /_session 200 ok 0
[notice] 2023-04-20T20:18:45.109711Z couchdb@localhost <0.380.0> 86d0f2d999 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/img/fauxtonicon5.svg 304 ok 0
[notice] 2023-04-20T20:18:45.109819Z couchdb@localhost <0.381.0> 795ee30144 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/fonts/fontawesome-webfont.woff 304 ok 0
[notice] 2023-04-20T20:18:45.127295Z couchdb@localhost <0.379.0> 9d0f39239c 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/fonts/fauxtonicon5.woff 304 ok 1
[notice] 2023-04-20T20:18:49.491205Z couchdb@localhost <0.423.0> -------- couch_replicator_clustering : cluster stable
[notice] 2023-04-20T20:18:49.497682Z couchdb@localhost <0.445.0> -------- Started replicator db changes listener <0.573.0>
[info] 2023-04-20T20:18:49.498522Z couchdb@localhost <0.575.0> -------- open_result error {not_found,no_db_file} for _replicator
[notice] 2023-04-20T20:18:59.333038Z couchdb@localhost <0.329.0> -------- rexi_server : cluster stable
[notice] 2023-04-20T20:18:59.333130Z couchdb@localhost <0.333.0> -------- rexi_buffer : cluster stable

leanne63 · 2023-04-20T21:43:31Z

Further, tried doing the curl command to add the _replicator db - it failed authorization too, so...:

% curl -X PUT 'http:https://admin:[email protected]:5984/_replicator'
{"error":"unauthorized","reason":"Name or password is incorrect."}
% curl -X PUT 'http:https://admin1:[email protected]:5984/_replicator'
{"error":"unauthorized","reason":"Name or password is incorrect."}

[warning] 2023-04-20T21:37:42.131975Z couchdb@localhost <0.833.0> c7bca406d4 couch_httpd_auth: Authentication failed for user admin from 127.0.0.1
[notice] 2023-04-20T21:37:42.132324Z couchdb@localhost <0.833.0> c7bca406d4 127.0.0.1:5984 127.0.0.1 undefined PUT /_replicator 401 ok 8
[notice] 2023-04-20T21:37:56.881497Z couchdb@localhost <0.948.0> 2b21cd4144 127.0.0.1:5984 127.0.0.1 undefined PUT /_replicator 401 ok 1

big-r81 · 2023-04-20T21:50:12Z

Close CouchDB and try to delete (take a backup before) ~/Library/Application Support/CouchDB2. Iirc you should be asked to set a CouchDB password.

leanne63 · 2023-04-21T04:38:52Z

@big-r81 , renamed the ~/Library/Application Support/CouchDB2; started CouchDB, and got this window:

Selected Set Password - the window went away and immediately returned. Selected Set Password again - same thing.

Selected Cancel and Quit CouchDB, and that did quit. Reopening just brought the above message again, with the same result.

The old directory has folders for etc and var, both with other folders and files in them. The new directory only has an etc folder and etc/couchDB with nothing else under it.

Oh, and no log file was produced.

janl · 2023-04-21T14:26:15Z

can you retry this process, but as the first two steps:

quit the CouchDB Mac app
run ps ax | grep beam to see if there are any other erlang processes, and if there are, kill those first

leanne63 · 2023-04-21T16:16:14Z

@janl : made sure app was closed, then ran the command. Got result as follows:

% ps ax | grep beam
24933 s000  S+     0:00.00 grep beam

Just to double check, I also checked in Activity Monitor, searching All Processes for beam - it didn't find any.

janl · 2023-04-25T12:24:12Z

ok, and what happens when you start the install process from scratch now?

leanne63 · 2023-04-25T16:03:41Z

@janl :

start the install process from scratch

as in redownload the DMG (how I installed CouchDB initially), or
as in build it from scratch?

UPDATE

Deleted the CouchDB.app from Applications
Copied the same CouchDB.app from the .zip file I used earlier (3.3.2/rc.1/) into Applications
Restarted the app; got the following results:

This time, the password window opened and let me set the admin password.

The Fauxton page opened, and the verification process appears to have completed with all checkmarks (passing).

The log is interesting...

still missing databases ( _nodes, _dbs, _users) - even though it says it's creating the missing databases
lots of shard-related messages; however, those seem all to be related to the missing databases

I'll try adding the databases using curl to see how it goes from there. Here's the full log - minus a number of repeated errors (noted at the bottom) for this instance, apparently having to do with the missing _users database:

[info] 2023-04-25T18:18:06.078304Z couchdb@localhost <0.253.0> -------- Preflight check: Checking For Monsters

[info] 2023-04-25T18:18:06.078342Z couchdb@localhost <0.253.0> -------- Preflight check: Asserting Admin Account

[info] 2023-04-25T18:18:06.079580Z couchdb@localhost <0.253.0> -------- Apache CouchDB 3.3.2 is starting.

[info] 2023-04-25T18:18:06.079598Z couchdb@localhost <0.254.0> -------- Starting couch_sup
[notice] 2023-04-25T18:18:06.120475Z couchdb@localhost <0.109.0> -------- config: [admins] admin set to '****' for reason nil
[info] 2023-04-25T18:18:06.138891Z couchdb@localhost <0.253.0> -------- Apache CouchDB has started. Time to relax.

[notice] 2023-04-25T18:18:06.143140Z couchdb@localhost <0.329.0> -------- rexi_server : started servers
[notice] 2023-04-25T18:18:06.143770Z couchdb@localhost <0.333.0> -------- rexi_buffer : started servers
[warning] 2023-04-25T18:18:06.154760Z couchdb@localhost <0.341.0> -------- creating missing database: _nodes
[info] 2023-04-25T18:18:06.154777Z couchdb@localhost <0.342.0> -------- open_result error {not_found,no_db_file} for _nodes
[warning] 2023-04-25T18:18:06.177734Z couchdb@localhost <0.357.0> -------- creating missing database: _dbs
[warning] 2023-04-25T18:18:06.177736Z couchdb@localhost <0.358.0> -------- creating missing database: _dbs
[info] 2023-04-25T18:18:06.177751Z couchdb@localhost <0.360.0> -------- open_result error {not_found,no_db_file} for _dbs
[notice] 2023-04-25T18:18:06.182414Z couchdb@localhost <0.372.0> -------- mem3_reshard_dbdoc start init()
[notice] 2023-04-25T18:18:06.184170Z couchdb@localhost <0.374.0> -------- mem3_reshard start init()
[notice] 2023-04-25T18:18:06.184195Z couchdb@localhost <0.375.0> -------- mem3_reshard db monitor <0.375.0> starting
[notice] 2023-04-25T18:18:06.185048Z couchdb@localhost <0.374.0> -------- mem3_reshard starting reloading jobs
[notice] 2023-04-25T18:18:06.185081Z couchdb@localhost <0.374.0> -------- mem3_reshard finished reloading jobs
[info] 2023-04-25T18:18:06.298463Z couchdb@localhost <0.381.0> -------- Apache CouchDB has started. Time to relax.

[info] 2023-04-25T18:18:06.298517Z couchdb@localhost <0.381.0> -------- Apache CouchDB has started on http:https://127.0.0.1:5984/
[notice] 2023-04-25T18:18:06.303489Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:06.303588Z couchdb@localhost emulator -------- Error in process <0.403.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:06.303656Z couchdb@localhost emulator -------- Error in process <0.403.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[notice] 2023-04-25T18:18:06.325672Z couchdb@localhost <0.450.0> -------- Missing system database _users
[notice] 2023-04-25T18:18:06.713640Z couchdb@localhost <0.386.0> 8c32b6406b 127.0.0.1:5984 127.0.0.1 undefined GET /_up 200 ok 30
[notice] 2023-04-25T18:18:06.827760Z couchdb@localhost <0.387.0> 6a8b85b065 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/ 200 ok 2
[notice] 2023-04-25T18:18:06.831962Z couchdb@localhost <0.388.0> 575de652f1 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/css/styles.5bda604c70f688307c36.css 200 ok 0
[notice] 2023-04-25T18:18:06.832497Z couchdb@localhost <0.389.0> c10f64a077 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/js/manifest.f9cde0db85e3cd97708e.js 200 ok 0
[notice] 2023-04-25T18:18:06.834140Z couchdb@localhost <0.390.0> 82685846ee 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/css/styles.2fe6f2383b82d9a7610a.css 200 ok 2
[notice] 2023-04-25T18:18:06.836519Z couchdb@localhost <0.387.0> 7dbb2e69fb 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/js/vendor.5bda604c70f688307c36.js 200 ok 6
[notice] 2023-04-25T18:18:06.836774Z couchdb@localhost <0.388.0> dc53688bc1 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/js/bundle.2fe6f2383b82d9a7610a.js 200 ok 3
[notice] 2023-04-25T18:18:06.915864Z couchdb@localhost <0.109.0> -------- config: [couchdb] uuid set to e77dd7e197194c2ab9c6976fea923288 for reason nil
[notice] 2023-04-25T18:18:06.923994Z couchdb@localhost <0.390.0> 5000402dfe 127.0.0.1:5984 127.0.0.1 undefined GET /_session 200 ok 0
[notice] 2023-04-25T18:18:06.931623Z couchdb@localhost <0.391.0> 4f0e01a416 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/fonts/fontawesome-webfont.woff 200 ok 1
[notice] 2023-04-25T18:18:06.932127Z couchdb@localhost <0.390.0> f75005cde5 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/img/fauxtonicon5.svg 200 ok 2
[notice] 2023-04-25T18:18:06.937393Z couchdb@localhost <0.390.0> 8e6026d858 127.0.0.1:5984 127.0.0.1 undefined GET /_session 200 ok 0
[notice] 2023-04-25T18:18:06.938506Z couchdb@localhost <0.387.0> 74d7140a2c 127.0.0.1:5984 127.0.0.1 undefined GET / 200 ok 23
[notice] 2023-04-25T18:18:06.938512Z couchdb@localhost <0.389.0> 7a0cbe4c5c 127.0.0.1:5984 127.0.0.1 undefined GET / 200 ok 15
[notice] 2023-04-25T18:18:06.938560Z couchdb@localhost <0.388.0> 88fbec1840 127.0.0.1:5984 127.0.0.1 undefined GET / 200 ok 15
[notice] 2023-04-25T18:18:06.939671Z couchdb@localhost <0.387.0> e8871e5122 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/img/couchdb-logo.png 200 ok 0
[notice] 2023-04-25T18:18:06.962852Z couchdb@localhost <0.387.0> 4a4da10b7d 127.0.0.1:5984 127.0.0.1 undefined GET /_utils/dashboard.assets/fonts/fauxtonicon5.woff 200 ok 1
[notice] 2023-04-25T18:18:07.004966Z couchdb@localhost <0.392.0> 0bd25361bc 127.0.0.1:5984 127.0.0.1 undefined GET /apple-touch-icon-precomposed.png 404 ok 4
[notice] 2023-04-25T18:18:07.005923Z couchdb@localhost <0.392.0> 3d8d3e940a 127.0.0.1:5984 127.0.0.1 undefined GET /apple-touch-icon.png 404 ok 0
[notice] 2023-04-25T18:18:11.304672Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:11.304835Z couchdb@localhost emulator -------- Error in process <0.563.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:11.304918Z couchdb@localhost emulator -------- Error in process <0.563.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[notice] 2023-04-25T18:18:11.309191Z couchdb@localhost <0.424.0> -------- couch_replicator_clustering : cluster stable
[notice] 2023-04-25T18:18:11.313721Z couchdb@localhost <0.434.0> -------- Started replicator db changes listener <0.564.0>
[info] 2023-04-25T18:18:11.314076Z couchdb@localhost <0.566.0> -------- open_result error {not_found,no_db_file} for _replicator
[notice] 2023-04-25T18:18:16.306154Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:16.306366Z couchdb@localhost emulator -------- Error in process <0.611.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:16.306533Z couchdb@localhost emulator -------- Error in process <0.611.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[notice] 2023-04-25T18:18:20.351596Z couchdb@localhost <0.109.0> -------- config: [chttpd_auth] secret set to fa5d65910a612a5800ad69088b19c07a for reason nil
[notice] 2023-04-25T18:18:20.369202Z couchdb@localhost <0.387.0> a80f71e31a 127.0.0.1:5984 127.0.0.1 undefined POST /_session 200 ok 24
[notice] 2023-04-25T18:18:20.380541Z couchdb@localhost <0.387.0> a6fad85df8 127.0.0.1:5984 127.0.0.1 admin GET /_session 200 ok 1
[notice] 2023-04-25T18:18:20.441424Z couchdb@localhost <0.387.0> 8526b39327 127.0.0.1:5984 127.0.0.1 admin GET /_all_dbs 200 ok 29
[notice] 2023-04-25T18:18:20.813749Z couchdb@localhost <0.387.0> 0695e09c2c 127.0.0.1:5984 127.0.0.1 admin GET /_all_dbs?startkey=%22%22&endkey=%22%E9%A6%99%22&limit=30 200 ok 2
[notice] 2023-04-25T18:18:21.144338Z couchdb@localhost <0.329.0> -------- rexi_server : cluster stable
[notice] 2023-04-25T18:18:21.144455Z couchdb@localhost <0.333.0> -------- rexi_buffer : cluster stable
[notice] 2023-04-25T18:18:21.307880Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:21.308092Z couchdb@localhost emulator -------- Error in process <0.662.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:21.308196Z couchdb@localhost emulator -------- Error in process <0.662.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[notice] 2023-04-25T18:18:26.308512Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:26.308666Z couchdb@localhost emulator -------- Error in process <0.704.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:26.308718Z couchdb@localhost emulator -------- Error in process <0.704.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[notice] 2023-04-25T18:18:31.310029Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:31.310255Z couchdb@localhost emulator -------- Error in process <0.744.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:31.310361Z couchdb@localhost emulator -------- Error in process <0.744.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[notice] 2023-04-25T18:18:36.311697Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:36.311889Z couchdb@localhost emulator -------- Error in process <0.777.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:36.311934Z couchdb@localhost emulator -------- Error in process <0.777.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[notice] 2023-04-25T18:18:37.016148Z couchdb@localhost <0.387.0> f64652c281 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb 404 ok 2
[notice] 2023-04-25T18:18:37.016534Z couchdb@localhost <0.776.0> 88419c9088 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate 404 ok 1
[notice] 2023-04-25T18:18:37.051524Z couchdb@localhost <0.387.0> 1d75ca68ae 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb 201 ok 31
[notice] 2023-04-25T18:18:37.085444Z couchdb@localhost <0.776.0> 27e6c4ce5f 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_1 201 ok 15
[notice] 2023-04-25T18:18:37.091608Z couchdb@localhost <0.776.0> cd60d48471 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_1 201 ok 2
[notice] 2023-04-25T18:18:37.096608Z couchdb@localhost <0.776.0> 47da730732 127.0.0.1:5984 127.0.0.1 admin DELETE /verifytestdb/test_doc_1?rev=2-d588d3e93ee155c5afffdf0247a2c5ef 200 ok 3
[notice] 2023-04-25T18:18:37.102561Z couchdb@localhost <0.776.0> c1fe526d52 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_10 201 ok 3
[notice] 2023-04-25T18:18:37.104386Z couchdb@localhost <0.778.0> 404b5ed6e2 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_20 201 ok 3
[notice] 2023-04-25T18:18:37.105874Z couchdb@localhost <0.780.0> 83e6e6d568 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/test_doc_30 201 ok 3
[notice] 2023-04-25T18:18:37.183861Z couchdb@localhost <0.781.0> 17ec0aaa69 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/_design/view_check 201 ok 81
[info] 2023-04-25T18:18:37.201345Z couchdb@localhost <0.940.0> -------- Starting index update for db: shards/80000000-ffffffff/verifytestdb.1682446717 idx: _design/view_check
[info] 2023-04-25T18:18:37.201408Z couchdb@localhost <0.941.0> -------- Starting index update for db: shards/00000000-7fffffff/verifytestdb.1682446717 idx: _design/view_check
[info] 2023-04-25T18:18:37.206588Z couchdb@localhost <0.940.0> -------- Index update finished for db: shards/80000000-ffffffff/verifytestdb.1682446717 idx: _design/view_check
[info] 2023-04-25T18:18:37.234564Z couchdb@localhost <0.941.0> -------- Index update finished for db: shards/00000000-7fffffff/verifytestdb.1682446717 idx: _design/view_check
[notice] 2023-04-25T18:18:37.234735Z couchdb@localhost <0.776.0> 6b2c26424f 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/_design/view_check/_view/testview 200 ok 48
[notice] 2023-04-25T18:18:37.249482Z couchdb@localhost <0.429.0> -------- couch_replicator_scheduler: Job {"f88fa19a30001a54bbac190f91ddf477","+create_target"} started as <0.970.0>
[notice] 2023-04-25T18:18:40.423675Z couchdb@localhost <0.977.0> 8535d28657 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/ 200 ok 1
[notice] 2023-04-25T18:18:40.433948Z couchdb@localhost <0.977.0> b95c0f6e7c 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb_replicate/ 201 ok 10
[notice] 2023-04-25T18:18:40.435475Z couchdb@localhost <0.977.0> d58b80e4b1 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate/ 200 ok 1
[notice] 2023-04-25T18:18:40.436580Z couchdb@localhost <0.977.0> 9b00ba98c5 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/ 200 ok 1
[notice] 2023-04-25T18:18:40.437674Z couchdb@localhost <0.977.0> 2b0a4062ea 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate/ 200 ok 1
[notice] 2023-04-25T18:18:40.438671Z couchdb@localhost <0.977.0> 2ff689b6e6 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/_local/f88fa19a30001a54bbac190f91ddf477 404 ok 1
[notice] 2023-04-25T18:18:40.439499Z couchdb@localhost <0.977.0> e803100a13 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/_local/99272134628e0dab94c8d41a3646747f 404 ok 1
[notice] 2023-04-25T18:18:40.440456Z couchdb@localhost <0.977.0> 527dfbecc7 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/_local/04967ba99196d145a939f4b7e7bdf69f 404 ok 1
[notice] 2023-04-25T18:18:40.441490Z couchdb@localhost <0.977.0> 654407ef46 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/_local/3e7646c29c77e4bb7a0da8558ec5f2bf 404 ok 1
[notice] 2023-04-25T18:18:40.442264Z couchdb@localhost <0.977.0> 030ddb8451 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate/_local/f88fa19a30001a54bbac190f91ddf477 404 ok 0
[notice] 2023-04-25T18:18:40.443040Z couchdb@localhost <0.977.0> 290a7c1315 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate/_local/99272134628e0dab94c8d41a3646747f 404 ok 1
[notice] 2023-04-25T18:18:40.443866Z couchdb@localhost <0.977.0> 4f9fbec191 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate/_local/04967ba99196d145a939f4b7e7bdf69f 404 ok 0
[notice] 2023-04-25T18:18:40.444597Z couchdb@localhost <0.977.0> d8eaa3b99a 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate/_local/3e7646c29c77e4bb7a0da8558ec5f2bf 404 ok 0
[notice] 2023-04-25T18:18:40.447944Z couchdb@localhost <0.977.0> 65314aaa72 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/_changes?feed=normal&style=all_docs&since=0&timeout=10000 200 ok 1
[notice] 2023-04-25T18:18:40.450041Z couchdb@localhost <0.977.0> d9c524a0b5 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/ 200 ok 1
[notice] 2023-04-25T18:18:40.450173Z couchdb@localhost <0.970.0> -------- Starting replication f88fa19a30001a54bbac190f91ddf477+create_target (http:https://127.0.0.1:5984/verifytestdb/ -> http:https://127.0.0.1:5984/verifytestdb_replicate/) from _replicate endpoint worker_procesess:4 worker_batch_size:500 session_id:f490f8816126b8d32aac8ae86cd8bb6a
[notice] 2023-04-25T18:18:40.451721Z couchdb@localhost <0.978.0> 996ef5f4fd 127.0.0.1:5984 127.0.0.1 admin POST /verifytestdb_replicate/_revs_diff 200 ok 2
[notice] 2023-04-25T18:18:40.457325Z couchdb@localhost <0.978.0> a7473cbf78 127.0.0.1:5984 127.0.0.1 admin POST /verifytestdb/_bulk_get?latest=true&revs=true&attachments=false 200 ok 5
[notice] 2023-04-25T18:18:40.459014Z couchdb@localhost <0.977.0> cee9a346c2 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb/_design/view_check?revs=true&open_revs=%5B%221-1845fa639169348a576a52acfc0b919b%22%5D&latest=true 200 ok 7
[notice] 2023-04-25T18:18:40.464412Z couchdb@localhost <0.978.0> b729536434 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb_replicate/_design/view_check?new_edits=false 201 ok 5
[notice] 2023-04-25T18:18:40.468230Z couchdb@localhost <0.978.0> a3aa3898e2 127.0.0.1:5984 127.0.0.1 admin POST /verifytestdb_replicate/_bulk_docs 201 ok 3
[notice] 2023-04-25T18:18:40.469086Z couchdb@localhost <0.978.0> a68d83ec69 127.0.0.1:5984 127.0.0.1 admin POST /verifytestdb_replicate/_ensure_full_commit 201 ok 1
[notice] 2023-04-25T18:18:40.469088Z couchdb@localhost <0.977.0> 49c02becbd 127.0.0.1:5984 127.0.0.1 admin POST /verifytestdb/_ensure_full_commit 201 ok 1
[notice] 2023-04-25T18:18:40.469150Z couchdb@localhost <0.970.0> -------- recording a checkpoint for `http:https://127.0.0.1:5984/verifytestdb/` -> `http:https://127.0.0.1:5984/verifytestdb_replicate/` at source update_seq <<"7-g1AAAACbeJzLYWBgYMpgTmEQTM4vTc5ISXLIyU9OzMnILy7JAUklMiTV____PyuDOZElFyjAbmxgapBsmoJNAx5j8liAJEMDkPoPNY0ZbJqpgbF5okUyNn1ZAFw1MGw">>
[info] 2023-04-25T18:18:40.469573Z couchdb@localhost <0.1166.0> -------- Starting index update for db: shards/00000000-7fffffff/verifytestdb_replicate.1682446720 idx: _design/view_check
[notice] 2023-04-25T18:18:40.471220Z couchdb@localhost <0.978.0> bcb9ff079f 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb/_local/f88fa19a30001a54bbac190f91ddf477 201 ok 2
[info] 2023-04-25T18:18:40.473525Z couchdb@localhost <0.1166.0> -------- Index update finished for db: shards/00000000-7fffffff/verifytestdb_replicate.1682446720 idx: _design/view_check
[notice] 2023-04-25T18:18:40.473810Z couchdb@localhost <0.978.0> 3de4ec1279 127.0.0.1:5984 127.0.0.1 admin PUT /verifytestdb_replicate/_local/f88fa19a30001a54bbac190f91ddf477 201 ok 2
[notice] 2023-04-25T18:18:40.474114Z couchdb@localhost <0.429.0> -------- couch_replicator_scheduler: Job {"f88fa19a30001a54bbac190f91ddf477","+create_target"} completed normally
[notice] 2023-04-25T18:18:40.474136Z couchdb@localhost <0.776.0> 268f5dca13 127.0.0.1:5984 127.0.0.1 admin POST /_replicate 200 ok 3235
[info] 2023-04-25T18:18:40.474357Z couchdb@localhost <0.1202.0> -------- Starting index update for db: shards/80000000-ffffffff/verifytestdb_replicate.1682446720 idx: _design/view_check
[info] 2023-04-25T18:18:40.476682Z couchdb@localhost <0.1202.0> -------- Index update finished for db: shards/80000000-ffffffff/verifytestdb_replicate.1682446720 idx: _design/view_check
[notice] 2023-04-25T18:18:40.479466Z couchdb@localhost <0.776.0> 29e27a7a10 127.0.0.1:5984 127.0.0.1 admin GET /verifytestdb_replicate 200 ok 0
[notice] 2023-04-25T18:18:40.501618Z couchdb@localhost <0.778.0> f729afa007 127.0.0.1:5984 127.0.0.1 admin DELETE /verifytestdb 200 ok 4
[notice] 2023-04-25T18:18:40.503912Z couchdb@localhost <0.776.0> eb01e63027 127.0.0.1:5984 127.0.0.1 admin DELETE /verifytestdb_replicate 200 ok 6
[notice] 2023-04-25T18:18:41.313175Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:41.313360Z couchdb@localhost emulator -------- Error in process <0.1252.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:41.313463Z couchdb@localhost emulator -------- Error in process <0.1252.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

...

This part repeats repeats repeats with different process values (Error in process <0.1252.0> ) each time:

[notice] 2023-04-25T18:18:41.313175Z couchdb@localhost <0.402.0> -------- chttpd_auth_cache changes listener died because the _users database does not exist. Create the database to silence this notice.
[error] 2023-04-25T18:18:41.313360Z couchdb@localhost emulator -------- Error in process <0.1252.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

[error] 2023-04-25T18:18:41.313463Z couchdb@localhost emulator -------- Error in process <0.1252.0> on node couchdb@localhost with exit value:
{database_does_not_exist,[{mem3_shards,load_shards_from_db,"_users",[{file,"src/mem3_shards.erl"},{line,430}]},{mem3_shards,load_shards_from_disk,1,[{file,"src/mem3_shards.erl"},{line,405}]},{mem3_shards,load_shards_from_disk,2,[{file,"src/mem3_shards.erl"},{line,434}]},{mem3_shards,for_docid,3,[{file,"src/mem3_shards.erl"},{line,100}]},{fabric_doc_open,go,3,[{file,"src/fabric_doc_open.erl"},{line,39}]},{chttpd_auth_cache,ensure_auth_ddoc_exists,2,[{file,"src/chttpd_auth_cache.erl"},{line,214}]},{chttpd_auth_cache,listen_for_changes,1,[{file,"src/chttpd_auth_cache.erl"},{line,160}]}]}

leanne63 · 2023-04-25T19:05:40Z

@janl: part ii:

I noticed the log was also showing this line:

[info] 2023-04-25T18:54:06.432385Z couchdb@localhost <0.574.0> -------- open_result error {not_found,no_db_file} for _replicator

So, I also used curl to add the _replicator database. The new log still showed the same info item as above, but now the _replicator database shows when I log in.

Here are the results from my curl commands, including the initial ones I performed after seeing the above-referenced "missing db" messages. I'm just noting because _dbs was apparently present, while the rest were missing, even though the log said they had been created:

% curl -X PUT 'http:https://admin:[email protected]:5984/_users' 
{"ok":true}
% curl -X PUT 'http:https://admin:[email protected]:5984/_dbs'  
{"error":"file_exists","reason":"The database could not be created, the file already exists."}
% curl -X PUT 'http:https://admin:[email protected]:5984/_nodes'
{"ok":true}
% curl -X PUT 'http:https://admin:[email protected]:5984/_replicator'
{"ok":true}

janl · 2023-04-29T08:58:32Z

do you have any important data in your setup, or would you be okay with nuking the database dir?

rm -rf ~/Library/Application\ Support/CouchDB2/var/lib/couchdb

leanne63 · 2023-05-02T22:36:10Z

database dir nuked, @janl ! Sorry for the delay!

What's next? Should I try again?

leanne63 · 2023-05-06T14:46:42Z

Okay, I nuked the app AND the contents of ~/Library/Application\ Support/CouchDB2/ and started from scratch.

I split out the log file into sections based on action, and have attached the files here:

CouchDB2_uponLogin.log
CouchDB2_uponVerification.log
CouchDB2_afterLogoutAndClose.log

Items of note:

The _users database wasn't created
The missing _nodes and _dbs databases were created
The verify process passed everything (all related lines say ok)

So, at this point it appears that I need only curl to add the _users database, and it should work fine...

Let me know if you'd like me to try anything else...

leanne63 added bug needs-triage labels Apr 3, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Fauxton verification process fails at Create View step - and lots of repeated error lines in log... #4510

Fauxton verification process fails at Create View step - and lots of repeated error lines in log... #4510

leanne63 commented Apr 3, 2023

big-r81 commented Apr 3, 2023

whosnorman commented Apr 4, 2023

leanne63 commented Apr 4, 2023

big-r81 commented Apr 6, 2023

leanne63 commented Apr 7, 2023

big-r81 commented Apr 7, 2023

leanne63 commented Apr 7, 2023

big-r81 commented Apr 20, 2023

leanne63 commented Apr 20, 2023 •

edited

Loading

leanne63 commented Apr 20, 2023

big-r81 commented Apr 20, 2023

leanne63 commented Apr 21, 2023 •

edited

Loading

janl commented Apr 21, 2023

leanne63 commented Apr 21, 2023 •

edited

Loading

janl commented Apr 25, 2023

leanne63 commented Apr 25, 2023 •

edited

Loading

leanne63 commented Apr 25, 2023 •

edited

Loading

janl commented Apr 29, 2023

leanne63 commented May 2, 2023 •

edited

Loading

leanne63 commented May 6, 2023

Fauxton verification process fails at Create View step - and lots of repeated error lines in log... #4510

Fauxton verification process fails at Create View step - and lots of repeated error lines in log... #4510

Comments

leanne63 commented Apr 3, 2023

Fauxton verification process fails, showing 'x' at Create View step. It does not continue to the Replication step.

Also, the log is filled with repeated info- and error-level lines.

Steps to Reproduce

Expected Behaviour

Your Environment

Additional Context

big-r81 commented Apr 3, 2023

whosnorman commented Apr 4, 2023

leanne63 commented Apr 4, 2023

big-r81 commented Apr 6, 2023

leanne63 commented Apr 7, 2023

big-r81 commented Apr 7, 2023

leanne63 commented Apr 7, 2023

big-r81 commented Apr 20, 2023

leanne63 commented Apr 20, 2023 • edited Loading

leanne63 commented Apr 20, 2023

big-r81 commented Apr 20, 2023

leanne63 commented Apr 21, 2023 • edited Loading

janl commented Apr 21, 2023

leanne63 commented Apr 21, 2023 • edited Loading

janl commented Apr 25, 2023

leanne63 commented Apr 25, 2023 • edited Loading

leanne63 commented Apr 25, 2023 • edited Loading

janl commented Apr 29, 2023

leanne63 commented May 2, 2023 • edited Loading

leanne63 commented May 6, 2023

leanne63 commented Apr 20, 2023 •

edited

Loading

leanne63 commented Apr 21, 2023 •

edited

Loading

leanne63 commented Apr 21, 2023 •

edited

Loading

leanne63 commented Apr 25, 2023 •

edited

Loading

leanne63 commented Apr 25, 2023 •

edited

Loading

leanne63 commented May 2, 2023 •

edited

Loading