Running SQLite

Sid Agrawal siagraw at cs.ubc.ca
Sun Jun 11 06:59:54 CEST 2023


Thanks you Christian.

I was also reaching the same conclusion. I made changes to
vfs_plugin.cc so that fcntl always returns success for F_SETLK. But
your patch is cleaner.

Best,
Sid

On Sat, Jun 10, 2023 at 9:20 PM Christian Prochaska
<christian.prochaska at genode-labs.com> wrote:
>
> [CAUTION: Non-UBC Email]
>
> 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
> > T X�! W&�pV� { 2N�\� ���tIv��xۍd�c �b �9�ر��"� ��k�la 況���, �8���     �u����ٗ!�3x�-.�A ���;�w� ߳  t � � �`�   ���g R���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+l n���  �ߢ��z�%��l���u�+�&��Bn�m6�m6�]��M yǢ��[�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�M k�毝�۞|�H6�^��w��u����]   �}��}�ۭuӽ4<4� � z�"�}tE�ޭ��z���]�)���KE/ ��xm��
> >  ��n ����-u � ��X&j)\�b'E�e�:  �vT� �-- �>����4 at 4 2�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 �z m����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�MR K �H [H ܚ] [�� H �[\  H  ��ܘ[H  � ^ \��\�H �[ ] Lˈ H  ]�H ܚ]  [� ] �\�[�� ����^ [\  W�H \� H �\�K  �� H �[� X��\�� H �[ K�   �Y�    B� ��ܘ[H ��\ [ \�
> >  � X�  \� ܙX]
> > K  H [H �[��[�� [� � \��Y\� ] ��[� [YK�  ����  Z�H �S ] H \� �[  [�� �۝   �]   H ��[X[�    ]    B�����  Y�[�  �\ۉ�  �X��ۚ^�K���^H �]   [  � YH   ]  H [H Z\��[�� ��YH ��\ [ H � Y��  K�K�  H �YY   ˜��\ [ H   H �[ ] L˘� �[ H [� H �^H   ]  \� �]  \� �Z] Y   �   H  X� �\��[ۈ \�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 [�� Y H ��[��\��^ [\  \�   X� ܝ � [�   ܝ � �\ �ˆ�   H ��[Y[�  �]    H [��ZݛH �  [ۂ� �S�� W� T��� �� � ܝ �� �\ \�W� ܝ  ܝX��  X�›XZ�H �T��S Z � �[���[ ] W�^ [\  B����]  ] ��KKKKKKKKKKKKKKKKKKKKKKT� T� KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB��\��[  [�] X[ ^�Y ��\��[�Έ  �� �[ X��] [ۈ ��  Y]  [\  [Y[� Y   \�[�� �^ Y  �[ YB��[�� H �K�
> > KL�
> > �KY�َ
> > �M��؂��
> > H ZP� �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 �Y  Yܘ]�[   �XYܘ]� �˝X�˘�O� ܛ� N�����  K �� H ��[    Z�H  � �[� �S ] H [��Y H H �[�� 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===
>
>
> _______________________________________________
> Genode users mailing list
> users at lists.genode.org
> https://lists.genode.org/listinfo/users


More information about the users mailing list