Running SQLite

Christian Prochaska christian.prochaska at genode-labs.com
Sun Jun 11 06:20:09 CEST 2023


Hi Sid,

I had to patch the sqlite3 implementation that comes with Qt5
because of missing F_SETLK support. Maybe it is the same problem?

This is the patch:

https://github.com/cproc/qt5/commit/c8b512db33a612e5026aa73fd8bfd257f967cdd8.patch

Christian

On 11.06.23 05:26, Sid Agrawal wrote:
> Hi,
> I am writing a simple program to exercise sqlite3. I have written it
> using vfs_example_5 as a base, so I can access a file. Though the
> program compiles (which is great), I am running into issues at
> runtime. Looks like SQLite is calling fcntl with a command that the
> vfs_plugin doesn't recognize.
>
> My gut tells me that I am missing some compile flags, i.e., I need to
> compile the sqlite3.c file in a way that is better suited to the libc
> version used by Genode, which, IIRC is BSD's libc. Or perhaps I need
> to use an older version of SQLite?  Or I could be way off :)
>
> It would be great if folks could point me in the right direction. My
> code and steps to repro are below.
>
> Best,
> Sid
>
>
> Source Code:
>    https://github.com/sid-agrawal/genode/tree/sid-branch/repos/osmosis_examples/src/app/sqlite_example
>
>
> Steps to reproduce:
>
> git clone https://github.com/sid-agrawal/genode.git
> cd genode
> git checkout sid-branch
>  ./tool/create_builddir  x86_64
>  cd build/x86_64
> # Update build.conf to
> #   - include osmosis_examples, libports and ports repos
> #   - comment out the -no-kvm option
> <GENODE_DIR>/tool/ports/prepare_port grub2 libc
> make KERNEL=hw run/sqlite_example
>
>
> Output:
> -----------------------START--------------------------------
> kernel initialized
> Warning: TSC calibration not yet implemented, using fixed value
> Genode 21.05-2061-gcf807a62cb
> 785 MiB RAM and 64533 caps assigned to init
> [init -> sqlite_example] Starting example
> [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs
> [init] child "sqlite_example" exited with exit value 0
>
> Run script execution successful.
> -----------------------END--------------------------------
>
>
>
>
>
> On Tue, Jun 6, 2023 at 9:26 AM Sid Agrawal <siagraw at cs.ubc.ca> wrote:
>> Hi,
>> I would like to run SQLite inside a Genode process. I could not find a run recipe or a dir in libports. Has someone tried in the past? If so, can you please point me in the right direction?
>>
>> Best,
>> Sid
>> PhD UBC
>> sid-agrawal.ca
> _______________________________________________
> Genode users mailing list
> users at lists.genode.org
> https://lists.genode.org/listinfo/users
> E�n�sڶ�z����z�b�� zz
z��
> �b���u:
����&���
��$j��ץi�
�d^q�y��i��X
��^���r���f����ץi�
�l"��L�� �n+�>�d
> �eM7���h���k�z����z�b�� zz
z��~�܆���&���
��$j��ץi�
�d��]I�}��}9ۮ:�M���z+�u��X���}�^��m����	�� zz
z��o)��X
��^���r���)���`�w�����&��--wL��-��`�Hp7����zZ)y���
���w
�X���
��^��"wZ�=tӡ[�p�}u&���m��n���6�@� Ģ�v�����Ƭ���ꠞ���׭�Z����Z��]X��
��^��,m�M�*���N�����w(v)�
> ��z{Sʗ�z�rN��Ԯn�+�����GzZK��O��K��@��b����'���r��x����S�+���-1�,j�
6�xZ蘉�z�rN�^}�ޝǬ0�U�슉�zw^�'�{^��
> ��z{Cz�+��b�t^���
> �^E�
��k�d^���I��z�^���N�^���	�^���1�,j�
����'z���'�c����M�m�&�a��t���b���
;)a��nZ�M8؎i���=��y8,�ap�
Ӧ/�
T�CѠ��6�C�
�
�����ӑ��N{�Hc�
> ˨�?
Ow��[�D�3&���&�!
Ζo��э�F�~'
> �F�x��*s
�7��L�7
> TX�!W&�pV�
{2N�\����tIv��xۍd�c�b�9�ر��"���k�la況���,
�8���	�u����ٗ!�3x�-.�A���;�w�߳t���`�	���gR���R��=��ƀyǢ��_�����hq�a��u��h_ׯ5�mvo)b�� zz
z���+azɭ�Lb��x���zZ)y���
���w
�X���
��^��"wZ�*��MNL��}u&���m��n���6�D^q�y��i��W,��
k^6�M��V�+-���ר�
"����lL����lL��1�E !1�-��`�Hp7�1�n=�g���h���k"j
> ���.m���j���M5;��~����+-���ר���]I�}��}9ۭ��M���z+�u��f���5_4�� ��(�f���5_4�� ��(�m=��_4j�az{bq�^u���
> �f���.m��^v��w���D�L���tܝ6�޶��슉L���g"��۞�ć8n+ln��� �ߢ��z�%��l���u�+�&��Bn�m6�m6�]��MyǢ��[�f���5_4�� ��(���#>'Z�\w]�{~{�x������n����~����+-���ר���]	�}��}�ۭwӽ4<4�c
�Ơy+Z���W���M��f�$h>��Q���T�ӕE�}�6������8�(�˦4A��Ǧ�\�PH��#���+��� ��%y)��*.�ǀq�g��֪~�29�L̓r��
�6v
@
eP�
> w*L
���g_<�����S���<K�W3��3��r|E�
���o-��f��uѽ;��6�G���"��L���M6�M�k~���t�M4ѽ4�Mk�毝�۞|�H6�^��w��u����]	�}��}�ۭuӽ4<4� �z�"�}tE�ޭ��z���]�)���KE/��xm��
> 
��n����-u
�	��X&j)\�b'E�e�:�vT��--�>����4 at 42�a�
> ��6���2x&j)`���r������� ���Ț���r˛qƃjגj�t&���m��n��N��q�j)N�("��Lz�����R�l=�����
6��жv gñx����&j)`���r��z�����R�l=�����
6��жv gñx����&j)`���r�����r�^F��x@��y:zz
z�
�ɚ�X��X���
��b�� zz
z��\��8^��z�%��l���u�+�s�Y��W��*'�]�>��yקq�b����
��u�z�&j)b�	b�۬z�%��l���u�+����I칻
�&ކ�i����l���u�+��)�*'���z�&j)m��
��ު笶X���
��^��,���rО˛���m���+r�zm����l���u�+��b���j)�ǫ�����ٚ�[h�ǫ�X���
��^��
��GzZfj)m��
��ު笶X���
��^��,���r�zZK��R��
�&ކ�i����l���u�+��b�ا~���왨����z�+z����b�� zz
z����y˲��r��y��$���u�z�&j)b�	b�۬z�%��l���u�+�*'���O*^��m��Z�w!j�
�
���ק�:ڞ�ެIܡا���{���+�:.���n��q�%��l���u�+�t�jhh�ٚ�X
��^���r��J����+{oWJ����+z)���ҥ��j�ҥ��z�+�-4_(� cD

> 
�
T�

> 0
 ы!$�P��T N
> ��]2�4@�U �,��0�MRK�H[H
ܚ][��H
�[\H

��ܘ[H
�^\��\�H
�[]LˈH]�H
ܚ]
[�]�\�[��
����^[\W�H\�H�\�K
��H�[�X��\��H�[K��Y�
B�
��ܘ[H��\[\�
> 
�X�\�ܙX]
> KH[H
�[��[��[��\��Y\�]��[�[YK�����Z�H�S]H\��[[���۝
�]H��[X[�
]
B�����
Y�[��\ۉ�
�X��ۚ^�K���^H�]
[
�YH
]H[HZ\��[��
��YH��\[H�Y��K�K�H�YY
˜��\[H
H
�[]L˘��[H[�H
�^H
]\��]
\�
�Z]Y
�
HX��\��[ۈ
\�Y�H�[��K
�X�
RT��\���	��X�ˈ܈
\�\
�H�YY��
\�H[��\�
�\��[ۈو�S]O�܈H��[�H
�^Hٙ��B��]
��[�HܙX]Y�������[
�[�YH[�
H
�Y�
\�X�[ۋ�^B���H[�
�\
�
�
�\
��\�H�[�˂���\�
��Y�����\��H��N��



΋���]
X����K��Y
XYܘ]�[
��[��K�
�YK��Y
X��[��
ܙ\�����[��\��^[\\��ܘ��\

��[]W�^[\B����\
�
�
�\
��
X�N����]�ۙH



΋���]
X����K��Y
XYܘ]�[
��[��K��]���[��B��]�X���]
�Y
X��[���
����
�ܙX]W؝Z[\�

> �͍���Z[
�
> �͍��\]H�Z[
��ۙ�
ˆ�
H[��
YH��[��\��^[\\�X�ܝ
�[�
ܝ
�
�\�ˆ�
H��[Y[��]
H
[��ZݛH�
[ۂ��S��W�T�����
�ܝ
��
�\\�W�ܝܝX��X�›XZ�H�T��SZ
�
�[���[]W�^[\B����]

]��KKKKKKKKKKKKKKKKKKKKKKT�T�
KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB��\��[[�]X[^�Y��\��[�Έ���[X��][ۈ��
Y][\[Y[�Y

\�[���^Y
�[
YB��[��H
�K�
> KL�
> �KY�َ

> �M��؂��
> HZP��SH[�
>> L���\
�\��YۙY
�[�]��[�]
O�
�[]W�^[\WH�\�[��^[\B��[�]
O�
�[]W�^[\WH\��܎��۝
>
> N���[X[�
L���
�\
ܝY
H
��–�[�]
O�
�[]W�^[\WH\��܎��۝
>
> N���[X[�
L���
�\
ܝY
H
��–�[�]
O�
�[]W�^[\WH\��܎��۝
>
> N���[X[�
L���
�\
ܝY
H
��–�[�]
O�
�[]W�^[\WH\��܎��۝
>
> N���[X[�
L���
�\
ܝY
H
��–�[�]H�[��[]W�^[\H�^]Y
�]^]
�[
YH
���[�
�ܚ\
^X�][ۈ
�X��\�ٝ[
��KKKKKKKKKKKKKKKKKKKKKKQS�
KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB������ۈ
YK�[�
> �
�
��]N����+�SH�YYܘ]�[
�XYܘ]��˝X�˘�O�
ܛ�N�����K��H
��[Z�H
�
�[��S]H[��YHH�[��H

���\�ˈH��[���[�H
�[�
�X�\H܈H\�[�X�ܝ
ˈ\�
��Y[ۙH

�YY[�
H
\��Y�
���[�
[�H
X\�H
�[�YH[�
H
�Y�
\�X�[ۏ����\�
���Y��P��
�Y
XYܘ]�[
��B������������������������������������������������‘�[��H
\�\��XZ[[��\��\�\��\�
˙�[��K�ܙš



΋��\�
˙�[��K�ܙ��\�[����\�\��g===




More information about the users mailing list