[GNC] Session Error: failed to get_backend using access method "C"

Wed Jul 1 12:36:30 EDT 2020

This works fine in 3.10:

D:\>d:\tools\gnucash\bin\gnucash.exe
"D:\Data\Banking\GnuCash\t14.sqlite3.gnucash"

On Wed, Jul 1, 2020 at 12:28 PM Geert Janssens <geert.gnucash at kobaltwit.be>
wrote:

> Op woensdag 1 juli 2020 18:21:03 CEST schreef Lipp F.:
>
> > I have 3.10 installed and there is no gnucash-cli in this release. What
> do
>
> > you want me to test?
>
> >
>
> Reread my examples. They try to load files in gnucash.exe instead of
> gnucash-cli.exe :)
>
>
>
> Regards,
>
>
>
> Geert
>
>
>
> > On Wed, Jul 1, 2020 at 12:18 PM Geert Janssens <
> geert.gnucash at kobaltwit.be>
>
> >
>
> > wrote:
>
> > > Op woensdag 1 juli 2020 17:52:48 CEST schreef Lipp F.:
>
> > > > It is a bug indeed. Standard Windows path works fine in some parts of
>
> > > > the
>
> > > >
>
> > > > code but not everywhere. You can see the book file loaded and
> identified
>
> > >
>
> > > as
>
> > >
>
> > > > sqlite3. See logs below.
>
> > >
>
> > > While the logs may lead to that conclusion I'm not so sure that is
> really
>
> > > the case.
>
> > >
>
> > >
>
> > >
>
> > > When a file is loaded (as opposed to a URI for an actual database
> server)
>
> > > gnucash doesn't know beforehand what type of data is in there. So it
> will
>
> > > ask each backend in turn (sqlite3 or xml). The logs show the sqlite3
>
> > > backend trying to find the file. But that's before it can determine
>
> > > whether
>
> > > the file is really sqlite3. On successful loading (which didn't happen
>
> > > here), the first thing the backend would do is evaluate whether it can
>
> > > parse the file. If not, just backs off and passes the file to the next
>
> > > available backend (which would be xml). However in this case the
> backend
>
> > > failed to even locate the file, so it aborts file loading with an
> error.
>
> > >
>
> > >
>
> > >
>
> > > Back to the issue though. I asked you whether you see the same thing if
>
> > > you try to load the file in gnucash rather than gnucash-cli (I would
>
> > > expect
>
> > > so), and whether this already is the case on gnucash 3.x. I would like
> to
>
> > > know to determine whether it's a regression or a long-standing bug.
> That
>
> > > helps when trying to fix it.
>
> > >
>
> > >
>
> > >
>
> > > My example commands were a little mixed up unfortunately. Here they are
>
> > > again:
>
> > >
>
> > >
>
> > >
>
> > > C:\tools\gnucash\bin>gnucash.exe
> /C/Users/*****/Downloads/gnuCash-test-2/
>
> > >
>
> > > t14.sqlite3.gnucash
>
> > >
>
> > >
>
> > >
>
> > > C:\tools\gnucash\bin>gnucash.exe C:\Users\*****\Downloads\gnuCash-
>
> > >
>
> > > test-2\t14.sqlite3.gnucash
>
> > >
>
> > >
>
> > >
>
> > > Note there's an additional format you can use to pass file names. You
> can
>
> > > try:
>
> > >
>
> > > sqlite3:///c/Users/*****/Downloads.gnucash-test-2/t14.sqlite3.gnucash
>
> > >
>
> > > or perhaps
>
> > >
>
> > > sqlite3://c:\Users\*****\Downloads.gnucash-test-2\t14.sqlite3.gnucash
>
> > >
>
> > >
>
> > >
>
> > > I can't test right now myself which one is the exact right one.
>
> > >
>
> > >
>
> > >
>
> > > Regards,
>
> > >
>
> > >
>
> > >
>
> > > Geert
>
> > >
>
> > > > C:\tools\gnucash\bin>gnucash-cli.exe --debug --report run --name="Net
>
> > >
>
> > > Worth
>
> > >
>
> > > > Linechart" --output-file=r-nwl.html
>
> > > >
>
> > > > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'
>
> > > >
>
> > > > * 11:46:50 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi]
>
> > > >
>
> > > > GNC_DBD_DIR not set: using libdbi built-in default
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] 3 DBD
>
> > > >
>
> > > > drivers found
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi]
> Driver:
>
> > > >
>
> > > > mysql
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi]
> Driver:
>
> > > >
>
> > > > pgsql
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi]
> Driver:
>
> > > >
>
> > > > sqlite3
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.gui> [Gnucash::CoreApp::start] System locale
>
> > >
>
> > > returned
>
> > >
>
> > > > (null)
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.gui> [Gnucash::CoreApp::start] Effective locale
> set
>
> > > >
>
> > > > to English_United States.1252.
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.engine> [gnc_hook_num_args] no hook lists
>
> > > >
>
> > > > * 11:46:51 MESSG <gnc.report.core> loading saved reports
>
> > > >
>
> > > > * 11:46:51 MESSG <gnc.report.core> loading stylesheets
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb]
>
> > > >
>
> > > > schema: general, key: retain-days, settings_ptr: 01534078,
> handler_id: 1
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb]
>
> > > >
>
> > > > schema: general, key: retain-type-never, settings_ptr: 01534078,
>
> > > >
>
> > > > handler_id: 2
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb]
>
> > > >
>
> > > > schema: general, key: retain-type-days, settings_ptr: 01534078,
>
> > >
>
> > > handler_id:
>
> > > > 3
>
> > > >
>
> > > > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb]
>
> > > >
>
> > > > schema: general, key: retain-type-forever, settings_ptr: 01534078,
>
> > > >
>
> > > > handler_id: 4
>
> > > >
>
> > > > * 11:46:52 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb]
>
> > > >
>
> > > > schema: general, key: file-compression, settings_ptr: 01534078,
>
> > >
>
> > > handler_id:
>
> > > > 5
>
> > > >
>
> > > > * 11:46:52 INFO <gnc.gui> [scm_run_report] Loading datafile
>
> > > >
>
> > > > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'...
>
> > > >
>
> > > > * 11:46:52 INFO <gnc.account> [xaccAccountRecomputeBalance]
>
> > > > acct=Template
>
> > > >
>
> > > > Root starting baln=0/1
>
> > > >
>
> > > > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert
>
> > > >
>
> > > > 0726ec30 template into nsp=0702b1a0 template
>
> > > >
>
> > > > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert
>
> > > >
>
> > > > 097add18 ADF into nsp=0702b220 CURRENCY
>
> > > >
>
> > > > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert
>
> > > >
>
> > > > 097adcf8 ADP into nsp=0702b220 CURRENCY
>
> > > >
>
> > > > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert
>
> > > >
>
> > > > 097adc08 AED into nsp=0702b220 CURRENCY
>
> > > >
>
> > > > .....................
>
> > > >
>
> > > > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert
>
> > > >
>
> > > > 098a4228 XPD into nsp=0702b220 CURRENCY
>
> > > >
>
> > > > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert
>
> > > >
>
> > > > 098a4258 XPT into nsp=0702b220 CURRENCY
>
> > > >
>
> > > > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert
>
> > > >
>
> > > > 098a42a8 XSU into nsp=0702b220 CURRENCY
>
> > > >
>
> > > > * 11:47:02 INFO <qof.session> [QofSessionImpl::load_backend] Selected
>
> > > >
>
> > > > provider GnuCash Libdbi (SQLITE3) Backend
>
> > > >
>
> > > > * 11:47:02 INFO <gnc.backend.dbi>
>
> > > >
>
> > > > [QofDbiBackendProvider<Type>::type_check] doesn't exist (errno=5) ->
> DBI
>
> > > >
>
> > > > * 11:47:02 WARN <gnc.backend.dbi>
> [GncDbiBackend<Type>::session_begin()]
>
> > > >
>
> > > > Sqlite3 file
>
> > >
>
> > > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'
>
> > >
>
> > > > not found
>
> > > >
>
> > > > * 11:47:02 INFO <qof.session> [QofSessionImpl::begin] Done running
>
> > > >
>
> > > > session_begin on backend
>
> > > >
>
> > > > * 11:47:02 ERROR <gnc.gui> [scm_cleanup_and_exit_with_failure()]
> Session
>
> > > >
>
> > > > Error: Sqlite3 file
>
> > > >
>
> > > > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' not
> found
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncVendor before is 0
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncVendor after is 0
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncEntry before is 0
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncEntry after is 0
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncEmployee before is 0
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncEmployee after is 0
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncCustomer before is 0
>
> > > >
>
> > > > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncCustomer after is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncInvoice before is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > gncInvoice after is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > Lot before is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > Lot after is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > Budget before is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > Budget after is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > SchedXaction before is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > SchedXaction after is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > Trans before is 0
>
> > > >
>
> > > > * 11:47:03 INFO <qof.engine> [qof_collection_foreach] Hash Table
> size of
>
> > > >
>
> > > > Trans after is 0
>
>
>
>
>